How do I set up a recurring import in FileMaker Pro?
Answer ID: 7532Last Updated: Sep 19, 2011To set up recurring imports:1.2.In Browse mode, choose File menu > Import Records > File.3.For Files of type (Windows) or Show (Mac OS), select the type of file you want to import. For example, choose Excel Workbooks (*xlsx).For a list of supported file types, see Supported import/export file formats.4.Locate and select the file containing data you want to import.5.Select Set up as automatic recurring import, then click Open.The path of the file you selected appears in the Recurring Import Setup dialog box.6.To skip importing column headings, select Don’t import first record (Contains field names).7.Accept the default layout name or type a new name for the layout FileMaker Pro will create to display the imported data.8.Accept the default script name or type a new name for the script you can use to update data manually.9.Click OK.10.If you are importing data from an Excel file, you can import by worksheet or by named range.Note You can import data from only one worksheet or named range per layout.
Day 07 - Recurring Import in FileMaker - MightyData VIDEO
Thanks, but the problem is that there´s a diffrent file every time...
Maybe I need a script that imports every file in the folder..
Will each different file be the same in structure but just have a different file name? There should be tools that would allow you to automatically rename the file and put it in the folder for you.
It's also possible to create a script that imports every file found in a given directory provided they meet the criteria I just specified that they all have the same structure.
Option 1: Locate your folder inside the computer's documents folder. There's a get function that can list the contents of every file and folder inside documents so you can use that function to parse out the files listed inside one of its subdirectories. The advantage here is that you don't need a plug in to do this. The disadvantage is that you have to put the folder inside documents.
Opton 2: Acquire a plug in that lists the contents of a specified folder. This allows you to use a folder located anywhere accessible to your computer, but now you have to use a plug in--which can cost money and which can complicate maintenance and upgrades. (OS and FileMaker upgrades have been known to cause a plug in to "break".)
The same script can use a container field and export field contents to either delete, move or rename a file in order to keep from importing the same file twice.
Thanks a lot! I will try Option 1!!!