INSERT FROM URL (file:) not working with PSOS

Discussion created by user2148128 on Aug 9, 2018
Latest reply on Nov 16, 2018 by TSGal

FMP 16, latest release

FMS 17, latest release

PSOS->Windows Server 2012




In the script that's done on the server via PSOS, I have this simple example which fails:


Set Variable [ $fileList ; Value: List(layout1::ResponseText) ] // works

Set Variable [ $counter ; Value: 1 ]

Set Variable [ $fileToUse ; Value: GetValue($fileList; $counter) ]


Note: $fileToUse is now: "C:\Program Files\FileMaker\FileMaker Server\Data\Documents\test_me\70\Simple File.txt"


Yet, the following INSERT FROM URL FAILS in PSOS script:

Insert from URL [ Select ; With dialog: Off ; layout1::FileFromServer ; "file://" & $fileToUse ]




On the server itself, we have the following valid path:  C:\Program Files\FileMaker\FileMaker Server\Data\Documents\test_me\70


In that final 70 directory, we have the expected file


So .... why is this File INSERT FROM URL Failing (silently with no helpful logging message)??


I also tried:

  • file:/
  • file:///
  • using only files with no spaces in file name
  • using double backslashes in file paths
  • using forward slashes in file paths
  • other file types (PDF, ...)
  • quoting the file path string separately
  • hard-coding documents path in variable instead of using Get(DocumentsPath), then extracting the remaining path from each value in the edit box
  • using Get(DocumentsPath), then extracting the remaining path from the values in the edit box