Server Script Scheduling and Importing Text
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.
Add a field that shows and updates your calculation for the path and do both tests again.