2 Replies Latest reply on Jan 21, 2016 3:02 AM by Ben_B94

    Auto Import into FMP

    Ben_B94

      We use a fuel management system online which can produce reports as excel documents. The online system we use will automatically download the file into the downloads folder it seems with no way of changing the location. Each week the report is run and will download a new excel file into downloads. I know this is asking a lot but could FileMaker be set up to read certain fields automatically, considering the location of the file will keep changing? I'm assuming not, just seeing if Filemaker can overcome the shortcomings of a different application altogether.

        • 1. Re: Auto Import into FMP

          "Working with Microsoft Excel" in the Help file explains how to link FileMaker and an Excel file to import data on a regular basis. I suppose you could set the import, I haven't tried, to only update the changes.

           

          If your new Excel Report file has a new name so that it won't overwrite an existing file, this is a problem.

           

          You could get a list of the files in the Downloads folder using a Plugin and go from there.

          • 2. Re: Auto Import into FMP
            Ben_B94

            Thanks for the input,


            Limitations on the excel/online program side of things if I could get it to overwrite it'd be perfect, so just having to save as over another excel file used as the recurring import and filemaker seems to update ok. Not completely automated but almost there.


            -Regards