PSOS import file returns error 100

[Lou]

I have a script to import files into a table which I would like to automate thru filmmaker script schedules I setup the schedule and it runs as it should but it fails, so I tried to run script on server thru filemaker pro but it also failed so I simplified the script to 2 lines which also failed. When the script is ran locally it works fine but not on Server it returns error 100 which indicates file not found.

The files are located on the C drive of the server under a folder called Dealersocket, after several attempts using direct, network, and variable paths and online research no matter what I try I can't get it to work properly. I'm hoping someone can assist me.

 

#===============  here is the import script =======================

Set Error Capture [ On On ]

Set Variable [ $file ; Value: "filewin:/C:/Dealersocket/InProgress.csv" ]

Import Records [ With dialog: Off Off ; Table: InProgress ; “$file” ; Update; Windows ANSI ]

 

# =============== PSOS =========================

Set Error Capture [ On On ]

Perform Script on Server [ Specified: From list ; “Import Inventory” “Import Inventory” ; Parameter:       ; Wait for completion: On On ]

Set Variable [ $error ; Value: Get ( LastError ) ]

Set Variable [ $results ; Value: Get ( ScriptResult ) ]

If [ not $error and $results ≠ False ]

Set Variable [ $$SERVER.RESULT ; Value: Get ( ScriptResult ) ]

Else

Show Custom Dialog [ "Error" ; "SOB I encountered error " & $error & " and the script results are " & $results &"." ]

End If

 

No matter what I do I always get error 100

Edited May 10 by Lou

[comment]

48 minutes ago, Lou said:

The files are located on the C drive of the server under a folder called Dealersocket, after several attempts using direct, network, and variable paths and online research no matter what I try I can't get it to work properly.

As you can see in the help:

Quote

 

When running a script on FileMaker Server or FileMaker Cloud:

• Any specified file must be in the Documents folder, the temporary folder, or a child folder of either of these folders. 

 

https://help.claris.com/en/pro-help/content/paths-in-server-side-scripts.html

 

 

 

Edited May 10 by comment

[Lou]

it worked moved files to the document folder on the server 

 

thank you