dinsdag 19 februari 2008 13:19
Hello, dear users!
I have .csv file with data: Name, Price 1, Price 2, Price 3, Decimals, Id, UnitGroup, DefaultGroup. If I enter in fields UnitGroup and DefaultGroup corresponding values, and then do standard Import I get error in Import: "An error has occured. Try this action again. If this problem continues, check the Microsoft Dynamics CRM Community for solutions or contact your organization's MD CRM Administrator. Finally, you can contact Microsoft Support" (№ 0х80043b0a).
And if I enter in fields UnitGroup and DefaultGroup GUID's and doing standard Import then I get error: "the source data is not in the required format"(№ 0х80040356) on column "DefaultGroup".
I can't use only Data Migration Manager because I need do re-import products (i.e export from CRM to excel -> change data in Excel -> then import to CRM), but this feature absent in Data Migration Manager.
Please help me, if anyone can resolve this.
Best regards, Marina
dinsdag 19 februari 2008 23:03
I checked and it seems that you can not import lookup field using the UI.
You can use SDK matching classes to achieve your goal.
woensdag 20 februari 2008 5:37Moderator
You have to use specific Guid rather than name.. If you are looking to put name in csv files, then you use custom development, get the guid of the specific unitgroup and then pass to that for import.
woensdag 20 februari 2008 6:59
Thank you for answer. As a result, I can't do import data in lookup fields (in my case this is a required fields) without custom development, that's right? Strange, import Products is a standard functionality.
woensdag 20 februari 2008 7:21
mabey the data migration manager will help you , you can inport the lookup field , please any one correct me if the data migration manager not helpful in this case
woensdag 20 februari 2008 8:08
Hello! I can't use data migration manager because he does not allow to do re-import data.
zaterdag 8 maart 2008 2:31
Follow this post instructions on how to import lookup fields:
zondag 9 maart 2008 11:28Moderator
Check new thing
it has better understanding.