AnsweredAssumed Answered

Server Script Scheduling and Importing Text

Question asked by wbanks on Jun 11, 2013
Latest reply on Jun 14, 2013 by


Server Script Scheduling and Importing Text

Your post

     Hi All,

     I'm using FileMaker Server 12 Advanced.

     The script is used to load the contents of a text file into a field.  The location of this text file is determined through a calculation.


Set Variable [$URL; Value:TableName::TextCalculation]

     NOTE: $URL appears as ' file:///Volumes/Share/Folder/TextFile.pdf.txt'

Insert from URL [Select; No Dialog; TableName::TextField; $URL]

Commit Records/Requests [Skip data entry validation; No Dialog; Force Commit]


     The problem that I've having is when I open the database in FMP12 and execute the script on the server, it works perfectly.  The pathing appears as it should.  When I schedule this FileMaker script, I suspect that the $URL path is not being generated properly.  I say suspect, because I can not see the results as this is being executed.

     Any assistance with this would be very much appreciated.