PSOS Import Records is failing

[thomas.brinch]

Hi,

I have a problem with server side import of records. I have a simple script which just does an import of a textile (with tab delimiters):

Set Variable [$FileList; Value: "filewin://server/folder/1795739.txt"]
Go to Layout ["files" (files)]
Import Records [No dialog; "$FileList"; Add; UTF-8]

When I run it client side, everything is fine. When I run it server side with Perform Script on Server I'm getting an error:

The previous script step, "Perform Script on Server", could not be completed because of an error....

If I run Get ( LastError), I get error code 100 (File is missing)

I have tried many different file locations for the textile. Network path, Local path (on the FM server) and Relative path (from where the database is placed on FM server).
I have tried placing the file in the FM server Databases and Documents folder AND the User Documents folder:

filewin://server/folder/1795739.txt
filewin:/C:/Users/ARAXI/Documents/1795739.txt
filewin:/C:/Program Files/FileMaker/FileMaker Server/Data/Documents/1795739.txt
filewin:/C:/Program Files/FileMaker/FileMaker Server/Data/Databases/1795739.txt
file:1795739.txt

Every time I get error 100. What am I doing wrong??

FileMaker server is v14 on Windows Server 2008 and the client is running on Windows 7.

 

Edited May 18, 2016 by thomas.brinch

[thomas.brinch]

Hmm. Found out that server side import works from the FM server Documents folder only - and no other locations.

I did try this earlier, but I made a typo in the path - my bad :-D