Announcements
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 ;)
Hello,
Design the XMLPort with Customer -> Customer Business Relation -> Contact as shown below.
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.
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.
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156