Import Spreadsheet

Discussion created by jameshoty on Dec 1, 2013
Latest reply on Dec 1, 2013 by fshcm13



I have a working solution on FileMaker Pro Advance that import one of the sheet in a spreadsheet. I have tested it and it is working to my expectation. Now I upload the solution and it is now hosted by FileMaker Server Advance. So the import record script has to change. I created a new script

Screen Shot 2013-12-01 at 17.26.39.png

The file "a_vantage.xls" is located in the server (a spearate machine from my macbook), in the location "../library/filemaker server/data/documents"

Screen Shot 2013-12-01 at 17.29.34.png


I create a new schueld that run FileMaker script

Screen Shot 2013-12-01 at 17.32.07.png


I manually execute the schedule (ie. the script to import), I get the following error : last scripting error (112)

Screen Shot 2013-12-01 at 17.20.25.png

Is this error the same as the server event error code?


What did I not do right if I want to scehdule a job to import record into a table periodically?