Copied to clipboard

Flag this post as spam?

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


  • Ismail Mayat 4511 posts 10092 karma points MVP 2x admin c-trib
    Dec 09, 2011 @ 12:10
    Ismail Mayat
    0

    Move datatype from parent to child

    Anyone any ideas / techniques or packages that they are aware of so that I can move a text datatype from a parent doc type to a child doc type without losing any data?  

    One idea i had was to export the page name and the field data into sql server.  Move the datatype which will lose data then import using cmsimport.

    Regards

    Ismail

  • Dirk De Grave 4541 posts 6021 karma points MVP 3x admin c-trib
    Dec 09, 2011 @ 12:15
    Dirk De Grave
    1

    Ouch, this one is tough... I'd do the following:

    Create the datatype on the child doc type (probably using a different alias), and perform sql statements to do the data move. Both datatypes will have their own controlId (guid), so it should be possible to move data between those records in cmsPropertyData. Just make sure to get the latest version of each of the cmsPropertyData records for each of the documents you already have.

    Oh, backup first!

     

    Cheers,

    /Dirk

  • Richard Soeteman 4054 posts 12927 karma points MVP 3x
    Dec 09, 2011 @ 12:17
    Richard Soeteman
    1

    Hi Ismael,

    That would be possible(and I should promote that ;-) )But I think it would be easier if you the property on the child datatype as well and then create a Dashboard control that takes all documents of the child document type and copies the date from its parent document. When finished you remove the datatype from the parent document type and the data is moved.

    Cheers,

    Richard

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies