How to Modify Hierarchy Filed Values by using Import Manager
I have some lookup table values in my source file in 1st attempt I have updated successfully. But, after cross checks the same i found that hierarchy level are incorrect at the destination side.
Source Hierarchy lookup values
Destination Hierarchy lookup values
Note: After Adding the Source filed hierarchy structure by selecting the Add Branch as child opting in the value mapping area
I am getting unique constraint Violated error message while importing the values.
So, how can I update the Source Hierarchy fields structure to Destination Hierarchy Field structure?
Thanks in Advance.
While importing the values if you get the error unique constraint Violated, that means that the same value has been mapped twice.
when you try to map the values of the hierarchy, NULL would have been automatically mapped.
When you select all the records and do add branch as child, the same NULL would have been added and mapped again.
If not with NULL, this could be the case with some other value.
Just check if some value is added and mapped twice in your value mapping.
This should solve your issue.
Try and let me know the result.