You can set up a FileMaker Pro Advanced file to automatically update data imported from another file, such as a Microsoft Excel spreadsheet. Recurring import occurs automatically every time you open the file and the first time you view the layout containing the data from the external file. Later, you can run a script to update data.
When you set up recurring imports, FileMaker Pro Advanced creates a new table for the imported data and a new layout to display the data. You can customize the layout in Layout mode later, if you wish.
Each time you update data, FileMaker Pro Advanced deletes data in the recurring import layout and replaces it with current data from the external file. Data imported via recurring import cannot be modified or added to in FileMaker Pro Advanced.
Note To set up recurring imports, you must open a file with an account that is assigned the Full Access privilege set. For information about privilege sets, see About accounts, privilege sets, and extended privileges. Users do not need to use an account with Full Access privileges to use recurring import after it has been set up in a file.
1. Create a new file or open the file in which you want to set up recurring imports. See Creating a FileMaker Pro Advanced file or Opening and managing files.
2. In Browse mode, choose File menu > Import Records > File.
3. For Files of type (Windows) or Show (macOS), 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 Advanced 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.
To | Do this |
Import data by worksheet | Select Display worksheets, select the worksheet you want to import, then click Continue. |
Import data by named range | Select Display named ranges, select the named range you want to import, then click Continue. |
The new layout appears in Browse mode in Table View. For more information about Table View, see Viewing records as a form, list, or table.
•Recurring import creates a new table and layout for imported data. If you want to add imported data to an existing table or layout in your database, see Importing data into FileMaker Pro Advanced.
•Data changes in external files must be saved in the original application before FileMaker Pro Advanced can import them.
•Recurring import is an import-only process. To make changes to the data, first modify data in the source file. Next, import data in the FileMaker Pro Advanced file by clicking the script button on the recurring import layout. If changes are made to the data while the FileMaker Pro Advanced file is closed, data on the recurring import layout will update the first time you view the layout during your next FileMaker Pro Advanced session.
•When data is imported for the first time, FileMaker Pro Advanced creates an Import log file in the folder that contains the FileMaker Pro Advanced file. This log file is updated each time data is imported into any FileMaker Pro Advanced file located in this folder.
•When you use the script button to update data, FileMaker Pro Advanced deletes all previously imported records, reimports the data, and creates new records for any new data found in the external file.
•As your needs grow, you might find that you want to modify the import script. For more information about planning and creating scripts, see Automating tasks with scripts.
•The automatically generated script FileMaker Pro Advanced creates for recurring import is not supported in a server-side script.