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, 20169 yr by 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