I'm trying to import a daily excel file of data from a container field in my filemaker 12 solution to a temp table in filemaker.
How I'd LIKE to do this is by importing directly from the path where the container data is stored on the server:
"filewin:/C:/Program Files/FileMaker/FileMaker Server/Data/Databases/RC_Data_FMS/DATABASE/Files/DATABASE/Attachment/data/file.xls"
but that doesn't work (yes, the folder is open access, and I can double click and open that file directly into excel). It does work if I drop a copy of file.xls on the desktop and use:
"filewin:" & get(desktopPath) & "file.xls"
Since I am counting on the file in the container being updated everyday (and not having the ability to manually or automatically export the container contents on the server), I don't think that path is viable.
How would you go about accomplishing the above?