Difference between revisions of "Importing data from XL"
Jump to navigation
Jump to search
(Created page with "== 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 applies by default * Codeunits are triggered by default * Field system names (uppercase) are used by default == Field references == Data plays a special role in regard to what you want to do * When creating data the DataID may NOT be included * Wh...") |
|||
| Line 5: | Line 5: | ||
General rules using the import | General rules using the import | ||
* Validation rules | * Validation rules apply by default ('''Disable validation''') | ||
* Codeunits are triggered by default | * Codeunits are triggered by default ('''Disable codeunits''') | ||
* Field system names | * Field system names are used by default ('''Allow field display names''') | ||
== Field references == | == 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 creating data the DataID may NOT be included | ||
* When updating data a valid DataID MUST be applied | * When updating data a valid DataID MUST be applied | ||
== Troubleshooting == | == Troubleshooting == | ||
Revision as of 05:45, 19 August 2022
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