Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

AX2012 Entity Export

Posted on by Microsoft Employee

Hi,

I have a request to export the data for Vendor Entity in AX2012, and that would be easily done by the data import/export framework, but the entity has more than 255 fields or as we can say parameters, and that looks to be the limit when exporting to Excel since Excel can not have more than 255 columns.

So, my next idea was to export to CSV and then convert it to an Excel file but, that also is not working in my case because that data is not good and I can not find the right separator to separate the parameters.

Does anyone else face this problem, and maybe come with some solution?

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,902 Super User 2024 Season 2 on at
    RE: AX2012 Entity Export

    Hi SIwannaS,

    Excel 64-bit for sure doesn't have a limitation of of 255 columns, Do you need all the fields? You can also change the mapping and exclude fields which are not having values in all records.

    Possibly, you can also try an xml format.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,302 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans