Performing scripts on FMS on an external hosted file
I am trying to use FMS update an externally hosted file from an internal hosted file unattended.
After many hours of frustration I have realized that FMS cannot import data from another FileMaker file hosted on another server.
I have read many threads about this here and elsewhere.
I am trying to work around this and was thinking of exporting the data from the external file to a local directory, but I cannot make FileMaker Server to perform any script in the external hosted file without returning the file not found error (100).
So, can FileMaker Server even do this or do I have to make a VB script with an opener file, exposed account/password and the whole mess?