Importing Data Into Your Database → Importing Data From A Generic ODBC Database → Specifying Additional Options for Generic Data Imports
When you import data from a generic ODBC database, the Additional Data Options dialog box enables you to set options for re-importing data, as well as script options.
The following options are available:
Write over data in the item, using import data maps – Select this option to write over data in previously imported items. For example, you may want to write over previously imported items if you adjust your field mapping after your initial import. During the subsequent import, field values are adjusted for previously imported items based on the new values, and new items are added.
Update only if change detected – If the previous option is selected, you can select this check box to update previously imported items only if a change has actually occurred.
Leave the item unmodified – Select this option to import new data without modifying previously imported data.
New records must have unique text in field – To prevent duplicate records in the receiving database, select this check box, and then select a field from the list. The list contains Text fields in the receiving database that are not set as Memo fields and that were mapped on the Map External Source Fields to Destination Fields dialog box. Before adding new records, the Import Data Wizard checks the receiving table for records with identical values in this field. Searching is case-insensitive. Matching records are not updated, and new records containing the same value are not created. When new records are not created because of this setting, entries are added to the log file.
Consider the following information when you select a field for uniqueness checking:
The system "title" field in the receiving table is marked with an asterisk.
To guarantee unique item IDs for all items imported to a table, you can select the Item ID field for uniqueness checking. Doing so overrides numbering properties you may have set up in the receiving project, however.
To avoid problems with duplicate contact names when you import data into the Contacts table, consider mapping the e-mail field and using it for uniqueness checking.
Pre-Import Script – Select the script to run before the source to destination field mapping occurs. For details on scripts, refer to Specifying Scripts for Generic Data Imports.
Post-Import Script – Select the script to run after the source to destination field mapping occurs. For details on scripts, refer to Specifying Scripts for Generic Data Imports.
Import As User – Select which user adds or updates the items during the database import.
Click Next to continue.
The Save Your Import Option Set dialog box opens. For details, refer to Saving Your Import Option Set. For details on executing Import Options Sets, refer to Executing Import Options Sets. For logging information, refer to Import Data Log Information.
Copyright © 2001–2019 Micro Focus or one of its affiliates. All rights reserved.