New to FileMaker server and have been trying to roll it out for my own company but running into a problem I can't seem to solve or find the right answers to online.
I am saving an excel file called import.xlsx in /Library/FileMaker Server/Data/Documents/ and using a variable filepath to point to the file however this script does not work when used in PSoS step. However if I specify the file locally whilst using FMP, and using only the script "Import Test" the import works fine.
Is it a problem with the variable filepath I have set? Or have I missed something out? I have included the two scripts that I wrote to try and make the import happen via PSoS. Any help or advice would be greatly appreciated!! - Yong
Script to Trigger PSoS "Import PSoS Button"
1. Commit Records/Request
2. Perform Script on Server [ "Import Test" ]
Script to Import Records from Excel "Import Test"
1. Go to Layout [ "Test" (Test) ]
2. Set Variable [ $filepath ; Value: "filemac:" & Get(DocumentsPath) & "import.xlsx" ]
3. Import Records [ With dialog: Off ; Source: "$filepath"; Worksheet: "" ; Add; Mac Roman ]