web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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 6

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

I have the same question (0)
  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,247 Super User 2025 Season 2 on at

    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/

  • Verified answer
    Olister Rumao Profile Picture
    Olister Rumao 3,967 on at

    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.

  • Troyh Profile Picture
    Troyh 6 on at

    Olister,

    Thank you for your help!!

    Troy

  • Troyh Profile Picture
    Troyh 6 on at

    Suresh,

    Thank you for the help!

    Troy

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans