Doesn't work import products in CRM 4.0
-
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
Alle reacties
-
dinsdag 19 februari 2008 23:03
Hi.
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.
Cheers,
Adi
-
woensdag 20 februari 2008 5:37Moderator
Marina,
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.
Best regards,
Imran
http://microsoftcrm3.blogspot.com
-
woensdag 20 februari 2008 6:59
Hello Imran!
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.
Best regards,
Marina
-
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.
Best Regards,
Marina
-
zaterdag 8 maart 2008 2:31
Hi Marina.
Follow this post instructions on how to import lookup fields:
http://forums.microsoft.com/Dynamics/ShowPost.aspx?PostID=2966322&SiteID=27
Cheers,
Adi
-
zondag 9 maart 2008 11:28Moderator
Check new thing
http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx
it has better understanding.
Regards,
Imran
http://microsoftcrm3.blogspot.com