Execute Script (**With Non-Web Compat. Script Itmes) at a specific time

[FredP]

I am looking for a way to schedule a script to run in filemaker everyday at 6:00am. Advanced server allows you to schedule scripts, but only if it uses Web Compatible Script Steps Only. That will not work for us.

 

So I am looking for other suggestions from people that might be able to help me achieve this same end result. I realize, that it might not be a filemaker specific solution, but rather something in windows perhaps?

 

Ideally, all that would have to happen is

 

1)Launch Filemaker (if not already running)

2)Login as someone

3)Execute script

 

Seems easy enough, but we want this script to run every day at 6 am.

 

Anyone have a solution?

 

Fred

[karibarikix]

I have something similar on my system. First I wrote an applescript that in essence opened the Filemaker database and ran a script to upload all the data, then I saved the script as an application. I then used iCal (on Mac) and scheduled it to run everyday at 3:00am. But applescript is only available on Mac. So this may not work for you. But maybe you have a lab Mac can be designated to do this. My applescript is this

 

tell application "FileMaker Pro"

getURL "YOUR DATABASE URL GOES HERE!"

end tell

 

tell application "FileMaker Pro"

activate

do script "SCRIPT TO UPLOAD ANY DATA HERE!"

end tell

 

I would imagine you could use visual basic and a calendar thats available on a PC but I don't have much knowledge there.

[FredP]

Yes, that is essentially what I would want, but it would also have to be smart enough to also handle logging into the database.

 

Of course, I am looking for a PC solution. But if I find nothing else, maybe I will dig up a mac somewhere

 

Fred

[FredP]

Well, I have looked around for something like this, but have yet to find it. If anyone knows a way I can have a script run automatically at a specific time of day, inside filemaker on a pc somehow, I would love to know.

 

I'd gladly pay if there is a commercial plugin that can help.

 

Thanks

Fred

[touchMe]

might be worth a look, http://www.onestopfilemaker.com/plugins/newer_plug-ins/events_40.html

 

There is an older version for FM3-6 and version 4 for 7 and 8, you might wanna make use of their try-before-you-buy for 9

[FredP]

They have updated it for FMP9, and I will check it out and post a response to how well it worked. thank you!

 

Fred