VISUAL QUICKPRO GUIDE FileMaker Pro 7 Advanced FOR WINDOWS AND MACINTOSH [Electronic resources] نسخه متنی

Importing with Scripts

When you need to import data into a FileMaker database regularly, it makes sense to use scripts. In this example, we'll do an import and then create a script to do that same import. With this script, as long as the field names remain the same, the data will be imported into the correct fields even if the field order in the source file changes.

To import data with matching field names

1 .Choose Scripts > ScriptMaker (Control+Shift+S/Command+Shift+S).

2 .When the Define Scripts dialog box appears, click New. When the Edit Script dialog box appears, type Import Matching for the script name.

3 .Scroll down to the Records category and double-click Import Records (Figure 12.23).

4 .In the Script Step Options section, click "Perform without dialog," then click "Specify data source" (Figure 12.24).

5 .When the Specify File dialog box appears, select the File Type from the drop-down list. Click Add File.

6 .When the Open File dialog box appears, navigate to the file you want to import and double-click it. Click OK to return to the Edit Script dialog box.

7 .In Script Step Options, click Specify import order.

8 .

When the Import Field Mapping dialog box appears, choose "matching names" from the "Arrange by" drop-down menu (Figure 12.25).

9 .Make sure that the fields you want to import have horizontal arrows pointing to the target field, then click OK.

10 .When the Import Options dialog box appears, click the "Perform auto-enter" check box if you want the imported records to have any auto-enter or lookup fields updated (Figure 12.26). Click Import. Click OK twice to finish.