Exporting and importing at specific times

[eddyb2]

Hi all

I have an export script and an import script setup.

The database is hosted on FMServer 9 running on Windows Server 2008

At 2am I would like the export script to run

At 3am I would like the import script to run

Is it possible in FM to set a time for a script to run?

It is unlikely that anyone will have the database open on a client at that time but not definite.

Thanks

[eddyb2]

I have just found the schedules section in the FileMaker Server 9 Admin Console and found the opton to schedule a script. Perfect.

Ed

[IdealData]

Your plan is flawed...

The EXPORT and IMPORT script steps won't run on FMS. FMS only supports the script steps that are WEB COMPATIBLE.

What are you trying to achieve?

[eddyb2]

You have just helped me with my calculation export- it is for that.

In the early hours of the morning I want that export script to run to create a "request file".

This request file is then FTP'd off somewhere (this is done using external software)

I then have to wait for an hour for a response file, which again using extenal software, I grab from the FTP site and bring down to the server. I want that to then be imported, using my script, back into the database.

Probably as clear as mud but hope you can make sense of that!

[IdealData]

Have a look around for a plug-in that runs on FMS.

Troi have a good history.

[Fitch]

Another option is the "robot": run your script on a FileMaker client. Typical setup:

- A local FileMaker file that runs a script on open

- The open script calls the script on the server (your import or export script), and then closes the file

You can set up windows task scheduler or some other utility to launch this file. The rest is all FileMaker.

[eddyb2]

Thanks Fitch, sounds like a plan, will give it a try.

Is there a specific way to ensure the script runs on the server rather than on the robot PC?

Thanks

[Fitch]

I may not have been clear enough: the purpose of the local file is to supply a target for the task scheduler.

The local file runs a script that opens the hosted file, does whatever processing is needed, then closes.

Everything happens on the local machine, using a hosted file. If you set up the correct file reference in the local file pointing to the hosted file, that is all the assurance you need.