Skip to main content

Notifications

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

How to create a csv file via a xmlport ?

(0) ShareShare
ReportReport
Posted on by 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 ;)

  • Suggested answer
    Binesh Profile Picture
    Binesh 7,885 on at
    RE: How to create a csv file via a xmlport ?

    Hello,

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

    pastedimage1598296106699v1.png

    pastedimage1598296171932v2.png

    pastedimage1598296221176v3.png

    pastedimage1598296278096v4.png

    pastedimage1598296330613v5.png

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,159 on at
    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 Profile Picture
    Andy Sather on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans