10 Replies Latest reply on Sep 4, 2012 9:03 AM by CapitolContender

    scheduled server script to import static container file location?

    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?