AnsweredAssumed Answered

how to import records from excel on server (PSoS)

Question asked by gongky on Jun 10, 2016
Latest reply on Aug 31, 2016 by bigtom

Hi Everyone!

 

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 ]

Outcomes