> > >

Use this form to import data that was originally exported from Microsoft Dynamics AX.

Data is committed per table or per 1000 records for import. This means that 1000 records must be read and must be free of errors before the actual import occurs. Any errors that occur during the import are entered into a log file in the Microsoft Dynamics AX Log directory, which is located in the path where Microsoft Dynamics AX is installed on the computer. This path is usually \Program Files\Microsoft Dynamics AX\40\Client\Log.

Tasks that use this form

Navigating the form

The following links and tables provide descriptions for the controls in this form.

Enter criteria on the General tab

Prepare batch processing on the Batch tab

Tabs

Tab

Description

Define optional settings for the import, such as compression, indexing, and whether to overwrite existing data.

Fields

Button

Description

Select a definition group to filter the tables to import data from. This selection is optional.

Use the browse button (folder icon) to locate the file that contains the data to be imported.

Select this check box to have the import executed by the AOS server instead of by the client.

This option will typically improve performance.

Select this check box to import data that is stored in tables that are not company accounts-specific.

Tip Tip

The SaveDataPerCompanytable property defines whether data in a table is company accounts-specific.

When this setting is used together with the option, be aware that cross-company data is updated.

Select this check box to delete existing data before the import. If the check box is clear, imported data will be added to an existing set of company accounts. Parameter records are always deleted before an import.

Select the method for performing the import:

  • – Import data without checking whether records already exist.

    This is the fastest import method and is useful when duplicate records are expected to be rare or unimportant.

  • – Update data during the import.

    For each record in the import file, the system will check whether it already exists. If it does, existing data will be overwritten with new data from the import file. This method is time-consuming, but it is useful when the purpose of the import is to update existing information.

  • – Skip the import of records that already exist.

    For each record in the import file, the system will check whether it already exists. If it does, data will not be imported. This method is time-consuming, but it useful when the purpose of the import is to add new data only, without modifying existing data.

Select the method for maintaining record indexes during import:

  • – The index is updated for each record that is imported.

    This method is typically used when you import a few records into a table with many records.

  • – Rebuild the index after the import is completed.

    This method is typically used when you import many records to an empty table.

Select this check box to compress record IDs so that there are no gaps in the sequence and the same start IDs are used for each table.

All record IDs and record references are recreated. This option might take longer but is recommended.

Select this check box to have the imported records trigger configured alerts. If the check box is clear, no alerts will be generated by imported records.

For information about how to create alerts, see Create alert rules.

See Also