locked
Data Import for an entity with self relation. RRS feed

  • Question

  • Hi,

    I'm trying to export an entity that has a self relation to itself 

    for example : 

    course Entity has a prerequest and the pre request may also have another pre request .. and so on.

    now I tried to import the csv file that contains all courses but I always get lookup reference couldn't be resolved.

    how can I import such an entity?

    Thanks,


    Zarour

    Thursday, June 20, 2013 1:16 PM

All replies

  • Hi,

    You could first import all courses without the attribute "prerequest". 

    After that import you export all courses for reimport, fill in the prerequest attribute and import again.

    Best regards

    Steve 


    Steve Sämmang, Vienna, Austria
    Blog: xrm.io Website: simplic.at

    Thursday, June 20, 2013 1:20 PM
  • Thank you , I will try it. but I think it will fail because of duplicate records found , will not it ?

    Zarour

    Thursday, June 20, 2013 1:24 PM
  • I did exactly what you said but I always get lookup reference could not be resolved for the prerequisites :(

    Zarour

    Thursday, June 20, 2013 1:36 PM
  • Did you import all courses without the column for prerequisites first?

    Steve Sämmang, Vienna, Austria
    Blog: xrm.io Website: simplic.at

    Thursday, June 20, 2013 1:44 PM
  • Yes I did, after I re import the courses with prerequisites filled it gave me a duplicate lookup reference  

    Zarour

    Saturday, June 22, 2013 7:17 AM
  • Hi,

    The problem is that you are using a field for the lookup reference which seems to be not unique.

    Follow this link resolving this issue: http://exploringxrm.wordpress.com/2012/05/08/resolving-duplicate-lookup-references-in-import-process/

    Best regards

    Steve


    Steve Sämmang, Vienna, Austria
    Blog: xrm.io Website: simplic.at

    Saturday, June 22, 2013 11:33 AM
  • Yes I thought that it was the problem, but I only use the Course ID for the lookup.

    Zarour

    Sunday, June 23, 2013 6:43 AM