I noticed that the Open File and Close File script steps are not supported when running scripts on the server so that makes me ask the question.
What does the scheduled script do?
While scheduled backup, files are paused some while then users can't open them at the time.
Files are not paused during backup. You can still access and use the field while the backup is taking place. The scheduled script pulls data from a remote file once every evening. The issue is that Open File and Close File are not supported so I don't know if it will allow me to pull the data. I have the remote file setup in the External Datasources section.
If the second file is on a different FileMaker server, then no you cannot access the data in that file in a server scheduled script.
Or, if the second file is on a same server, you can "Perform Script" in second file direct, not need to open it.
For import, you need to export records into document or temprorary directory.
Retrieving data ...