Import a CSV file with ER (II)

#er

Dynamics 365 ERP - Development

The article discusses importing CSV files into the system and covers topics such as format, format mapping, and testing the development.
It mentions creating an import format under a model and using UTF-8 without BOM encoding.
There's a mention of a mistranslation by Microsoft where "BOM" is translated to "LMAT" in Spanish.
The article explains setting delimiters, multiplicity, and date formats in the import format.
It details creating format mapping, binding it with the model, and assigning null values to empty fields.
Testing the format and format mapping is recommended before running the import.
The process of running the CSV import ER from the ER workspace or integrating it into the UI by a programmer is discussed.
Potential issues with CSV values containing symbols that could break the ER are mentioned, hinting at a future article exploring non-standard parsing methods.

Registered users can view the full text for FREE!