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:

MapModelToFormat

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

MapModelToFormatBinding

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

CSVImportTestFile

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

MapModelToFormatTest

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

MapModelToFormatTestResult

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:

WordPress.com Logo

You are commenting using your WordPress.com 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