Answered by:
Doesn't work import products in CRM 4.0

Question
-
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
Tuesday, February 19, 2008 1:19 PM
Answers
-
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
Sunday, March 9, 2008 11:28 AMModerator
All replies
-
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
Tuesday, February 19, 2008 11:03 PM -
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
Wednesday, February 20, 2008 5:37 AMModerator -
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
Wednesday, February 20, 2008 6:59 AM -
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
Wednesday, February 20, 2008 7:21 AM -
Hello! I can't use data migration manager because he does not allow to do re-import data.
Best Regards,
Marina
Wednesday, February 20, 2008 8:08 AM -
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
Saturday, March 8, 2008 2:31 AM -
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
Sunday, March 9, 2008 11:28 AMModerator