Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Does Server Scheduled Script supports updating external data source ?


This topic is 4791 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

We have a FMS v11 in our main office with a fixed IP. Our remote sales office has its own FMS server v11.

I have a FM script in the sales office. It basically does a very simple find all sales enter today and then update a table in the main office FMS server. This is done using the External Data Source. The script run perfectly from a sales office PC with FM Pro. However, when I run the same script as Server Schedule Script in the sales office, nothing gets update in the main table. No error is reported and the status is OK.

Could it be the scheduled script does not support external data source ? I hope this is not the case.

Posted

Could it be the scheduled script does not support external data source?

FMS can only see and work with files it hosts itself.

Posted

Vaughan,

FMS cannot see any External Data Sources? I'd need a robot to pull new mySQL records or they'd need to be pushed into FM?

tia,

Barbara

  • 3 months later...
Posted

I found this in 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."

Posted

Thanks, Supernatural, but that doesn't really answer my question. Apparently, server doesn't see ESS sources, and I can't find documentation to that effect.

This topic is 4791 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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