Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Fergus Davidson 309 posts 588 karma points
    May 25, 2012 @ 11:40
    Fergus Davidson
    0

    Child definitions not importing

    Hi

    i am trying to import from an excel workbook with data on 3 seperate sheets.

    the structure once imported should be:

     - document folder
     -  - document
     -  -  - version1
     -  -  - version2
     -  - document
     -  - document
     - document folder

    so, document folders have documents which have versions.

    each level is on a different sheet:

    folders [with folderID]

    documents [with documentID]

    versions [with versionID]

    i am setting up an import definition for the folders with a child definition for the documents which then has a further child definition for the versions.

    when i run the import, all i am getting is the folders imported. the other records are detected, but it does not seem to be 'seeing' the relationships between the levels.

    can anyone suggest where i may be going wrong?

    Copy Link
  • Richard Soeteman 4046 posts 12899 karma points MVP 2x
    May 25, 2012 @ 12:27
    Richard Soeteman
    1

    Hi did you pick a parent relation? In the documents sheet you should specify the column that holds the relation to the Folders sheet  In the example below you see that I create a relation to the Product category folder by specifying productcategoryId column taht exists in the products sheet.

     

     

    Hope this helps you,

     

    Richard

    Copy Link
  • Fergus Davidson 309 posts 588 karma points
    May 25, 2012 @ 13:53
    Fergus Davidson
    0

    Hi RIchard, well yes i had done that, but what i had not done is define the primary key [doh!]

    because i was not planning updates i had not ticked it and was thinking that it must be the data oro the nested child definitions.

    thank you for your reply and screengrab

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft