Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / XMLPort to .csv assign...
Microsoft Dynamics NAV (Archived)

XMLPort to .csv assigning a Boolean a Value on export

(0) ShareShare
ReportReport
Posted on by Troyh

Let me preface this by saying I am a beginner with XMLPorts and the supporting code. I see it I get it but I cannot always get it to do what I want, but trying to learn as I go.

We are using NAV 2017 On-Prem

I am trying to figure out how to export data using a filter but I do not want the field that I am filtering on to be exported.
Here is my example
I want to export Purchase Header data filter on Document Type. I do not want or need the Document Type field exported. This data will be passed to another program that cannot handle the Document Type field. The Document Types that I want to export are; Order, Credit Memo and Return Order.

Thank you in advance for any help.

Troy

*This post is locked for comments

  • Troyh Profile Picture
    Troyh on at
    RE: XMLPort to .csv assigning a Boolean a Value on export

    Suresh,

    Thank you for the help!

    Troy

  • Troyh Profile Picture
    Troyh on at
    RE: XMLPort to .csv assigning a Boolean a Value on export

    Olister,

    Thank you for your help!!

    Troy

  • Verified answer
    Olister Rumao Profile Picture
    Olister Rumao 3,957 on at
    RE: XMLPort to .csv assigning a Boolean a Value on export

    Hi Troy,

    I would suggest you to proceed this way.

    After you add you Table Element, there is a property with the name Table View or Table Filter

    You can add your filter for Document Type there.

    This means that you don't need to add this field to your CSV just filter the data as per Table View.

    Let me know if you need further help.

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: XMLPort to .csv assigning a Boolean a Value on export

    You don't need to add that field, you can specify that filter on the Table Element by using the properties.

    Check this link for more information about exporting using xmlport

    https://www.cloudfronts.com/export-data-excel-dynamics-nav-column-captions-using-xml-port/

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

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans