Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Import data - New table

Posted on by Microsoft Employee

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

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,151 Super User 2024 Season 2 on at
    RE: Import data - New table

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Import data - New table

    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
    André Arnaud de Cal... 291,151 Super User 2024 Season 2 on at
    RE: Import data - New table

    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
    Community Member Microsoft Employee on at
    RE: Import data - New table

    Thanks Andre! that helps!

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

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,151 Super User 2024 Season 2 on at
    RE: Import data - New table

    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

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans