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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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