The standard data format is generally used when you are exporting large amounts of data. This method supports the fast export of large amounts of data.

Use standard data format to export large binary or comma-separated files. The standard export yields two files: a data file (*.dat) and a definition file (*.def). The data file contains the data that you have exported. The definition file contains information about table name and ID, field name and ID, record ID information, transaction IDs, and company account.

Before you can export standard data, you must first create a definition group as described in Create definition groups for import and export.

Export standard data

  1. Click > > > .

  2. Select the definition group that you want to export, and then click .

    The dialog box opens.

  3. For , use the browse button to select a location for the file that contains the export data, and type a file name.

    Important Important

    Be sure to save exported files in a folder that has appropriately restricted permissions. In particular, allowing access to the data from the following tables can potentially expose confidential or security information: SysConfig, SysUserInfo, AccessRightsList, UserGroupInfo, UserInfo, and UserGroupInfo.

    If unsecured data from these tables is edited and then imported, you run the risk of potentially providing increased access to the Microsoft Dynamics AX system.


  4. Select the file type:

    • – Use a compressed file format. This option is used most frequently if the data will be imported back into Microsoft Dynamics AX.

    • – Do not include container fields in the export. This comma-separated format is typically used to export data for viewing in a spreadsheet.

  5. Select the check box to have the report executed by the AOS server instead of by the client.

    This option typically improves performance.

  6. Click the OKbutton to start the export.

See Also