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:
"/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!