scheduled server script to import static container file location?

Discussion created by CapitolContender on Aug 31, 2012
Latest reply on Sep 4, 2012 by CapitolContender

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?