GaoshengHuang

Cannot run FMP scripts on FM server 14

Discussion created by GaoshengHuang on Mar 12, 2017
Latest reply on Mar 14, 2017 by GaoshengHuang

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.

 

Scripts used:

Set variable

Set field

Go to layout

Perform find

Show all records

Delete all records

Go to record

Loop ... End Loop

If ...End if

Export Records

 

System Environment:

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!

Outcomes