1 Reply Latest reply on Jun 14, 2013 11:51 AM by dbail22@comcast.net

    Server Script Scheduling and Importing Text



      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.