MSDyn365FO. How to Import CSV file using Electronic Reporting. Part 3 – Map format to model.

In this blog post we will create new mapping to map format to model. On the format designer screen, click “Map format to model” button. Create new record, select model definition, specify name and description:


Open designer. In the designer bind Record List from the format to Record List in the model and then bind fields accordingly.


Finally, we can test our format. For the test I’m going to use simple CSV file:


Go back to Model to Datasource mapping form, click run in the action pane and upload the file.


If we’ve done everything right, we will get XML file that contains data mapped to model or errors, if any:


At this stage we have Data Model, Format and Mapping that we’ve tested. In the next blog post we will do the last piece of the setup – map Model to Destination and test the whole import.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s