AnsweredAssumed Answered

Import Records (Run on Server) Error 100

Question asked by deninger on Dec 7, 2017
Latest reply on Dec 7, 2017 by philmodjunk

I have been trying to import a file on a server-side script and am running into an Error 100 (file is missing).

 

A search of this forum finds a few suggestions, but none appear to apply. I don't run any scripts upon login or attached to layouts with a trigger so there are not any incompatible steps causing issues. The file is a .csv and not a .xlsx so that is not the issue. The file has full read-write permissions, so that is not the issue...

 

I am fairly certain that it is simply my path not resolving. My difficulty stems from this being a hosted server for which I do not have shell access. I do have a scratch directory off of the root of the server's drive  /scratch/ (MacOS X Server).

 

The file I am trying to import was placed in the directory using the following script:

 

set variable [$fetch ; value: BE_SaveURLToFile ($leieFileURL ; "/scratch/UPDATED.csv" )]

 

and the file exists after this is done (I have FTP access to the directory).

 

So I think that the problem is that I am incorrectly defining the path. I have tried:

 

"/scratch/UPDATED.csv"

"filemac:/scratch/UPDATED.csv"

"/FM Server #23/scratch/UPDATED.csv"

"filemac:/FM Server #23/scratch/UPDATED.csv"

 

None of which actually resolves and succeeds to import the records. I can think of no other ways to define the path...

 

Any insight would be appreciated!

 

Mike

Outcomes