Automating a (Mac) script to run at midnight

[johnatcctv]

I have a Filemaker 6 script that generates a TV schedule for our channel for the next day, but I don't know how to tell either

a) Filemaker Server (which hosts the file with the script) to run that script, or

: Filemaker to run any given script (including that one) at a certain time every day.

In the case of a), it seems like Filemaker Server can only run AppleScripts, and I don't know how to translate my Filemaker Script into an AppleScript.

In the case of :, well, I just don't know any way of triggering scripts to run except for during Start-up.

Any ideas for where I can get help with either option?

[jonesy17]

Check out the Events plug-in for FM at http://wmotion.com/events.html

[Steven H. Blackwell]

You would run this from FileMaker Pro on a workstation, not from FileMaker Server.

if you have a script called "Generate Schedule" you can use this format:

tell application "FileMaker Pro"

go to "file my_file.fp5"

do script FileMaker script "Generate Schedule" of file 1

end tell

Save this as an applet never show startup screen. Have iDo run it at the desired time. Include some error checking in the applet.

HTH

Steven