Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV forum / How to create a csv fi...
Microsoft Dynamics NAV forum
Suggested answer

How to create a csv file via a xmlport ?

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

Categories:
Other
  • 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,155 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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,647 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans