Jump to content
Sign in to follow this  
brian rich

Scheduled scripts and external databases

Recommended Posts

We are running FMS 11 Server advanced and also run a 'robot' FMP 11 Client on a separate computer on the network, whose job is to assemble a certain data set overnight from databases on the Filemaker server - this dataset is used for personnel scheduling.

A Planning database on the server references the robot's scheduling data and updates it's own dataset. The script in the Planning database that runs the update calls several scripts in the robot client. This script works correctly when run locally from a client.

We set up a schedule on the server to run the update script in the Planning database but it does not appear to work. Using the 'Show Compatibility' box on the update script does not show the Perform Script steps which refer to the external database as incompatible.

Are server side scripts able to call scripts in remote databases?

Thanks

Brian

Share this post


Link to post
Share on other sites

Page 133 in fms11_help.pdf

"A server-side FileMaker script that is running on one FileMaker server cannot open a database that is hosted on a different FileMaker server."

Share this post


Link to post
Share on other sites

Thanks @supernatural

That was it - looked at the log files and the Perform Script steps to the external files were giving error 100 (file not found)

Brian

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    AlesD 
×

Important Information

By using this site, you agree to our Terms of Use.