AnsweredAssumed Answered

Server Script Scheduling and Importing Text

Question asked by wbanks on Jun 11, 2013
Latest reply on Jun 14, 2013 by disabled_dbail22@comcast.net

Title

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.

     Thanks

Outcomes