locked
Import Many to Many relationship to CRM 2011 RRS feed

  • 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 Thanks
    Monday, 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

    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/

    Monday, April 8, 2013 7:31 AM
    Answerer
  • 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 message
    Tuesday, April 9, 2013 5:26 AM