I am working on a project that exclusively relies on scripts to pull data from multiple files, transform the data, write the result into a new table/layout, and finally export into a csv file. Everything works perfectly on the client side after running the scripts. But when I run the same scripts on FM server 14 as a schedule, nothing happens.
Go to layout
Show all records
Delete all records
Go to record
Loop ... End Loop
If ...End if
Filemaker Pro Advanced 14
Filemaker Server 14
Windows Server 2012 R2 Standard
Also, I am not so thorough about authentication issues. Anybody who runs the scripts puts an export directory so I am not sure how to make sure the server has access to the directory.
Any suggestions are appreciated!