Small and medium business | Business Central, N...

How to create a csv file via a xmlport ?

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hey guys,

I would like to export all my customer data from NAV to a csv file.

The special thing about this is that I want to export not only the customer data but also the corresponding contact data.

For example, there is a customer that I want to export. This eliminates three contacts.

The csv file should then look like this: The first three lines are filled with the customer data and the contact data is added to these lines.

Currently, my csv file looks like this: I have one line for the customer data and three additional lines with the contact data.

How can I get this to work?

Thank you ;)

All responses (3)

Answers (0)

Suggested answer

Binesh 7,885 on at

Like (0)

Report

RE: How to create a csv file via a xmlport ?

Hello,

Design the XMLPort with Customer -> Customer Business Relation -> Contact as shown below.
Suggested answer

JAngle 33,159 on at

Like (0)

Report

RE: How to create a csv file via a xmlport ?

Check out these links for help on doing this:

docs.microsoft.com/.../walkthrough--exporting-data-from-tables-to-csv-files

docs.microsoft.com/.../saveascsv-function

I imagine the query one is the easiest to get going with even if it does involve coding.
Suggested answer

Andy Sather on at

Like (0)

Report

RE: How to create a csv file via a xmlport ?

I wasn't able to see the screenshot on your post. I am not sure how you would be able to export the customer table and also insert lines with contact data. You can export all of the tables via Config Package if that helps. You can put Table 18 - Customer and Table 5050 Contacts. I see this is for Nav 2013. I wasnt sure if you had Config Packages in that version, but you should have RapidStart.