Import options (class form)

  • Article

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Click System administration > Common > Data export/import > Import.

Use this form to import data that was exported by using Microsoft Dynamics AX export.

When you import data, the changes are committed per table. This means that all records must be read and must be free of errors before the import starts. 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\60\Client\Log.

Note

Data import is not a transaction that can be rolled back. Before importing data, back up your database. For more information, see Plan data import, export, and migration.

If you select a definition group for import, some dependent tables may not be imported.

Task that uses this form

Import data from another instance of Microsoft Dynamics AX

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

Enter criteria on the General tab

Submit a batch processing job from a form

Tab

Tab

Description

Advanced

Define optional settings for the import, such as whether to include shared tables and system tables, and whether to overwrite existing data.

Fields

Field

Description

Definition group

Select a definition group to import tables from.

File name

Use the browse button (folder icon) to locate a file to import data from.

Execute on AOS

If you are executing immediately, rather than an as a batch job, select this check box to have the import job executed on the AOS instead of by the client.

This option will typically improve performance.

Include shared tables

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

Tip

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

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

Include system tables

Select this check box to import data that is stored in system tables.

Update existing record

Select this check box to 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.

See also

Create definition groups for import and export

Select tables (form)

Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).