Asked by:
Import Many to Many relationship to CRM 2011

Question
-
I am currently migrate some legacy data from CRM 4.0 to CRM2011, however, there is big barrier on the Many-to-Many relationship importing, I have search for the solution and get this from codeplexhttp://crm2011manytomany.codeplex.com/discussions/433816, when I importing data, it keep get 'Issues on line 1 - line has 1 instead of 2' error, any advise on it ThanksMonday, April 8, 2013 6:03 AM
All replies
-
Hi Guys
I have try to import some legacy data from CRM 4.0 to CRM 2011 with many to many relationship,
however I get this http://crm2011manytomany.codeplex.com/, then when I importing data, it keep get 'Issues on line 1 - line has 1 instead of 2' error, any advise on it Thanks
- Merged by DavidJennawayMVP, Moderator Tuesday, April 9, 2013 7:48 AM Duplicate thread
Monday, April 8, 2013 6:09 AM -
Have you tried the suggested solution from the same discussion?
The problem was not with the content of the file, but with the encoding. What I did to fix this was go to the Export tab and (having made sure that at least one N:N relationship already existed), and exported a file. I then cut and paste my comma seperated values from the other file into this new file and this worked fine. Once the file is uploaded, you see a progress bar and errors for any records which it is not able to map. You can then use the Export tool to verify which records have been created.
I ended up using semi-colons as a seperator - not sure if that was necessary, but that's what the export file has, so I used that.Monday, April 8, 2013 6:52 AM -
Hi Marshall,
Same post you have already posted in deployment forum,
your thread, please dont repeat the same thread again in all forums
http://social.microsoft.com/Forums/en-US/crmdeployment/thread/07da3381-07f9-4a24-8808-11136fbe3366
Thanks & Regards, MS CRM Consultant, V.Surya. My Blog: http://inventcrm.wordpress.com/
- Proposed as answer by SuryaMSCRMEditor Monday, April 8, 2013 7:32 AM
Monday, April 8, 2013 7:31 AMAnswerer -
Sorry for that, could you please delete this one, Cheers,Monday, April 8, 2013 10:56 PM
-
yes I did, just could not avoid the error messageTuesday, April 9, 2013 5:26 AM