AnsweredAssumed Answered

unable to import data via scheduled job on filemaker pro server

Question asked by mummey_nc on Mar 5, 2018
Latest reply on Mar 6, 2018 by mummey_nc

I have tried every variation I can come up with using these two sites as my guide:

https://support.filemaker.com/s/answerview?language=en_US&anum=7035

http://www.filemaker.com/help/13/fmp/en/html/create_db.8.42.html#1087742

 

Unfortunately I could not get any variations to work (I have tried using mapped network drives, file shares, absolute paths, placing the spreadsheets in the mydocuments area and other areas on the server).  Here is the latest setup and symptoms (the symptoms are the same for every variation I have tried):

 

When a user runs this script on their machine, it works (the records import into the database):
Import Records using this path:  filewin://filemakerserver45FileShare/File1.xls

 

When a Schedule runs this script on the server (server45), it doesn't work (no records import, job completes with "scripting error(100)"):
Import Records using this path:  filewin://filemakerserver45FileShare/File1.xls

 

I don't think I am dealing with a permissions issue, I have made sure that I am running the scheduled job as the same user that is able to successfully import the spreadsheet when running the command from their computer.

 

If anyone has any suggestions, please send them my way, thanks so much.

Outcomes