When using the Import Records script step or Export Records script step in a FileMaker Server scheduled script, keep the following in mind:
Any specified file must be in the Documents folder, the temporary folder, or a child folder of either the Documents folder or the temporary folder.
At this time, importing/exporting directly from another FileMaker Pro file (or the same FileMaker file) is not supported via a FileMaker Server scheduled script. In order to do so, the script would need to export the records from the FileMaker Pro file to one of the above valid paths and then import the records from this file into the FileMaker Pro file.
See the following Knowledgebase answer for additional information:
We apologize for the inconvenience that this may cause you.
While it's not a perfect solution, it is possible to set up a robot client file that triggers a script such as this at a scheduled time. Since it's performed from a client session, the server side script limitations are avoided.
I've learned how to do this for a Windows OS, but hesitate to try to describe this for Mac. If you know a way for the Mac OS to open a filemaker file at a scheduled time, then you can make this work.
Create a filemaker file and give it an account name and password that matches an account/password in the hosted file.
Set File Options so that the file opens automatically with this account/password combination.
Create a script that performs the script in the Hosted file.
Add Exit Application as the last line of this script to automatically close the file.
Set File options to perform this script when the file is opened.
Now set your OS to open this file at a scheduled time. In Windows, you would use the Task Manager. Perhaps someone can suggest a Mac OS equivalent for this last part.
First, let me say that this FMS limitation is a TOTAL SHAME, even more since it's the 2nd release of server side scripting even more whan you dare to say on your website 'forget robots'
SHAME SHAM SHAME SHAME
Yes for the Mac there's Cronnix I use it every day
I must agree to Glitchtracker! It's really a shame! FileMaker Server Advanced 10 is incapable of importing tables from tables shared by itself!
Is FileMaker Server Advanced 10 a database system?