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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Import data - New table

(0) ShareShare
ReportReport
Posted on by

Can data import/export framework be used to import data into a new table (user created)? Please point me to relevant resources

*This post is locked for comments

I have the same question (0)
  • Verified answer
    André Arnaud de Calavon Profile Picture
    300,911 Super User 2025 Season 2 on at

    Hi DaxCrm,

    Yes you can use new tables in this framework. You can use the entity wizard to create the base for a new entity.

    Some information can be found on the next page: technet.microsoft.com/.../jj933277.aspx

  • Community Member Profile Picture
    on at

    Thanks Andre! that helps!

    Please let me know if there is a way of checking duplicates during import.

  • André Arnaud de Calavon Profile Picture
    300,911 Super User 2025 Season 2 on at

    Hi DaxCrm,

    You have to add logic to find duplicates and ignore them. Would it be possible to cleanup the file in upfront or check afterwards?

  • Community Member Profile Picture
    on at

    Hi Andre,

    Thanks for your response. The issue is not with one file having duplicates... The thing is multiple sales reps do the data import (files coming from different sources) and there is a good probability of duplicates arising. The users will not be able to cleanup data before uploading to AX. It would be good if AX can alert of duplicates during import....

  • André Arnaud de Calavon Profile Picture
    300,911 Super User 2025 Season 2 on at

    Hi DaxCrm,

    In this case you will need additional logic during import or a good cleanup utility for after the import. Note that you can merge Address book records, but not when two records do have the same role (e.g. customer or prospect) in the same company.

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…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans