Table Import Definition window

 


Use the Table Import Definition window to create new import definitions, edit existing import definitions or import data using an import definition.

Because the Import Utility transfers information directly into the application’s data tables, we recommend that you make a complete backup of your application data before performing any import operations. If any problems occur with the import operation, you will be able to restore the application’s data from the backup.


Before using this window, be sure you have performed the following actions:

Set user access to Import

If the application restricts access to the Import Utility, be sure the appropriate users are allowed access to the utility.

Set table security

To ensure the integrity of the application’s data, use the application's security feature to set table access for all users with access to Import. By setting table access, you protect the tables you don't want data imported to. If table access isn't set for Import users, all tables in the application are accessible for use with the Import Utility.

Locate related table information

When you import data to a table, you may also need to import some of the same data to related tables, so that they contain synchronous (identical or corresponding) data. To do this, you will need to create separate import definitions for all tables related to the main table you're importing to.

To be sure that you're importing to all the tables that you need to, review all the tables related to the main table using the Additional Table Information window in the resource descriptions. These tables should be examined and analyzed to determine whether their data needs to be updated when changes are made to the main table you're importing to. In particular, all the tables that make up a table group should be updated together, as these tables have been designed to work together and should always contain synchronous data for each record you import. (Be aware, however, that not all tables related to the main table are in the same table group.)

You can also use the Select A Table window to display the tables used by the currently-active window in the application.

After importing, rebuild data tables and check links

After you import data, you may want to run any table maintenance procedures provided by the application to check imported records for data integrity.

To display this window

In most applications, go to the Tools menu, point to Integrate and choose Table Import.