Copied to clipboard

Flag this post as spam?

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


  • rich hamilton 117 posts 136 karma points
    Oct 17, 2012 @ 16:18
    rich hamilton
    0

    Update Records

    I was hoping that I could import my products against the parent node with their own unique ID.

    But then update them using that unique ID without having to map them to a parent node again. Is this posible?

  • Richard Soeteman 4049 posts 12922 karma points MVP 2x
    Oct 17, 2012 @ 16:26
    Richard Soeteman
    0

    I Assume you are using the free version? The Pro version allows you to update records and works as you describe.

    Best,

    Richard

  • rich hamilton 117 posts 136 karma points
    Oct 17, 2012 @ 16:31
    rich hamilton
    0

    No, I have the licence.

    I have these options

    DocumentType
     
    Auto publish
    -
    Enable content updates
    Only uncheck this option when you don't have a primary key in your datasource.
    When the record already exists
     
    Select primary key in datasource
     
    -
    Select parent relation key
    Select the column which is related to the primary key of the parent Import
     
    -
    Enable recursive imports
    But I have to select parent relation key, but I have already imported them, so just wanted to update them using the primary key.
  • rich hamilton 117 posts 136 karma points
    Oct 17, 2012 @ 16:41
    rich hamilton
    0

    or i could do it from the root, then it asks for location, will it change the location of the node if it already exists?

  • Richard Soeteman 4049 posts 12922 karma points MVP 2x
    Oct 17, 2012 @ 16:44
    Richard Soeteman
    0

    Ah sorry,

    My mistake I see what you mean now. I'll put it on my list but the whole relation mechanism is based on a relation between the imported record and the document. Which works well since you don't need any relation information stored in the Umbraco document. But in your situation it will get in your way when you want to update already existing content.

    You could try to build the CMSImport relation table yourself the format is [DataAdapter][Primary key name][Primary key value] and map those against the documents for now.

    Best,

    Richard

  • rich hamilton 117 posts 136 karma points
    Oct 17, 2012 @ 16:50
    rich hamilton
    0

    Yes, it orks well on the initial import to organise the data, but you may want to update later without knowing what the parent is.

     

    Thanks

  • Richard Soeteman 4049 posts 12922 karma points MVP 2x
    Oct 17, 2012 @ 16:55
    Richard Soeteman
    0

    Relations will be updated when the content is moved but also only when the record is first imported using CMSImport. Don't know if you can change the parent because it will insert records on that location if it can't find a relation..

    Sorry no easy answer..

  • rich hamilton 117 posts 136 karma points
    Oct 17, 2012 @ 16:57
    rich hamilton
    0

    ok, will give it a go.

    At least it should keep the location of the ones already added.

Please Sign in or register to post replies

Write your reply to:

Draft