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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Data Management - Upload
Microsoft Dynamics AX (Archived)

Data Management - Upload

(0) ShareShare
ReportReport
Posted on by lmai 2,442

Hi All, 

Could someone please suggest an import/export method that makes data upload easier?  I always have an error here and an error there.  It has always a struggling task for me. 

When you get an error message, how do you know what the error means?  Example, "The data value violates integrity constraints".  It's so vague.  What constraints? What should it be?

Also, can you export a vendor record, for example, then use these fields to import it back in?  

Thanks so much!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Manoj Tirukoti Profile Picture
    Manoj Tirukoti 30 on at

    Hi There,

    Datamanagement is the best tool out there. You can do so much with it and its very powerful

    "The data value violates integrity constraints" - This means its either an Enum or EDT for which the values provided by you arent valid. You can also skip validations on import using check boxes on the entity itself

    2018_2D00_07_2D00_24_5F00_9_2D00_35_2D00_31.jpg

    I would suggest first creating an export of the entity that you want to later import to get the template and then do the necessary changes.

  • Sangram Shinde Profile Picture
    Sangram Shinde 2,120 on at

    As suggested by Sukrut and Manoj, you can use data management for all your import and export activities as MS introduces large number of data entities to manage data import and export. Regarding the error you posted - you need to check if your file has invalid values for the mandatory fields for that entity.

    Thanks,

    Sangram

  • fatihgork Profile Picture
    fatihgork 3,817 on at

    Kim,

    I don't know any way where you can make messages more detailed but when you get "The data value violates integrity constraints" error, check mandatory fields in the table. Generally either a mandatory field is left blank or value of a field is over its character limit.

    We can also help with experience we got.

    What entity will you use? Maybe we used it before and can share templates/rules with you.

  • lmai Profile Picture
    lmai 2,442 on at

     I have Map source to staging, but not Map staging to target.  Could you please provide screenshot on how you got to Map staging to target?  Thanks

    map.gif

  • lmai Profile Picture
    lmai 2,442 on at

    Staging-2.gif

    Thanks, Sukrut,  These have been checked but the data wouldn't imported.  

  • lmai Profile Picture
    lmai 2,442 on at

    Yes, I did; but the error message was so vague.  I didn't know what it meant.  That was why I reached out for help.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 39

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans