Logging on to the Server

[Michael Reade]

Hi,

I'm trying to do the following (using FM8)

At a specific time (say 3:00 am)..

Open Filemaker Client on a local machine...

Log on the Filemaker Server (with specific user/password)...

Run a script...

Wait until script is finished...

Quit Filemaker client.

Does anyone know what the applescript code for that is...

Thanks a lot,

Michael Reade

[Erik Saline]

Applescript can do it, but you can also use a plugin called oAzium Events. You can set the date, time, database, and scripts. There documentation has many examples to follow.

[Tim Baldwin]

Hi

To login remotely you need to have the IP address of the host. Also you need your username and password and the name of the database.

The code may look something like this. (substitute [..] )

property remoteURL "FMP8:// [username] : [password] @ [iP Address] / [Database name]"

tell application "FileMaker Pro"

activate

getURL remoteURL

do script "Scriptmaker name"

end tell

Include a step in your FilemakerScript which exits the application after it has done what it needs to.

Scheduling the script is simplicity itself.

Use the " ical" application which comes with OSX. Sound crazy but it works!

Open the application and create a new event. Set this event to run every day (or whenever) and set the time to 3am. Then set the alarm to run this applescript. (with a reminder 0 mins before).

Hope this helps.

Tim