Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Suggested answer

XMLPort Question - Inserting a row manually in the export file

Posted on by 50

Hi everyone, 

I am wanting to create a export file with XMLPort in Dynamics NAV, with AL. 

The format I want is for every line read from the source file, i will copy this row, modify and create a second additional row. 

Is this possible in XMLPort? 

Thanks

  • screen123 Profile Picture
    screen123 50 on at
    RE: XMLPort Question - Inserting a row manually in the export file

    1-abstract-junk-test

    2-more-abstract-jksd-test

    The export needs to result in below

    1-abstract-junk-test

    1-abstract-junk-test-copied-and-modified-line

    2-more-abstract-jksd-test

    2-more-abstract-jksd-test-copied-and-modified-line

  • screen123 Profile Picture
    screen123 50 on at
    RE: XMLPort Question - Inserting a row manually in the export file

    Hi Rockwith Nav,

    I'm not sure how I can explain this more.

    Imagine a simple XML file to be used in a export in NAV for the Purchase Line table.

    XML Port is used to export the data out into XML.

    The only requirement here is the XML export, for all the Purchase Line table rows; there will be a extra row that was created and inserted into the XML export file.

    So if Purchase Line contains below rows

    1-xkjsdsd-junk-test

    2-skdjksd-jksd-test

    The export needs to result in below

    1-abstract-junk-test

    1-abstract-junk-test-copied-and-modified-line

    2-more-abstract-jksd-test

    2-more-abstract-jksd-test-copied-and-modified-line

    Can this be done in NAV XML Port?

    Thanks

  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 6,562 on at
    RE: XMLPort Question - Inserting a row manually in the export file

    The Question is still not clear, can you please explain once more?

  • screen123 Profile Picture
    screen123 50 on at
    RE: XMLPort Question - Inserting a row manually in the export file

    So if there was 1 row in the source file, the exported file will contain 2 rows, with the second row a manually inserted row.

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,683 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans