Importing data from XL

How to import data

When importing a file you can either update or insert records.

After the import is handled a file containing the results are returned to the user.

General rules using the import

• Validation rules apply by default (Disable validation)
• Codeunits are triggered by default (Disable codeunits)
• Field system names are used by default (Allow field display names)

Field references

Field names should use the system format (uppercase without any special characters), but it is possible to allow display name during imports (Allow field display names). An easy way to get the file format right is to export a couple of records and choosing System format.

DataID plays a special role in regard to what you want to do

• When creating data the DataID may NOT be included
• When updating data a valid DataID MUST be applied

Troubleshooting

Complete failure to import can be caused by

• Used field name display values
• Forgot DataID column in an update
• Included DataID column in an insert

Errors in single records could be caused by

• Some required fields are missing
• Status field was left empty
• Values in lookup fields are misspelled