Copied to clipboard

Flag this post as spam?

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


  • Ron G 41 posts 137 karma points
    Jul 19, 2016 @ 23:11
    Ron G
    0

    Manually enter data into the Umbraco Database

    Is it possible to manually update data in the [cmsPropertyData] table?

    I have a bunch of records that need updating based on a property data field.

    For example:

    UPDATE cmsPropertyData SET dataNvarchar = '20' WHERE  propertytypeid = 23 AND contentNodeId = @umbracoId AND versionId IN (SELECT versionId FROM cmsDocument WHERE published = 1)
    

    Would I need to update another table also? Like [cmsContentXml]?

    Thanks!

  • Søren Kottal 606 posts 3869 karma points MVP 3x c-trib
    Jul 20, 2016 @ 06:42
    Søren Kottal
    0

    Safest method would be to go through the service APIs. https://our.umbraco.org/documentation/Reference/Management/Services/ContentService

    Write up an API controller, that runs through the required nodes, and updates them.

  • Ron G 41 posts 137 karma points
    Jul 20, 2016 @ 20:52
    Ron G
    0

    The problem is I have 20,000 nodes that need updating. I was hoping for a simple SQL UPDATE solution.

    What other database table get updated when you update a property within a node?

  • Ron G 41 posts 137 karma points
    Jul 22, 2016 @ 14:42
    Ron G
    0

    I did try to update the cmsPropertyData directly but its not showing up in Umbraco. Has anyone made this work before?

Please Sign in or register to post replies

Write your reply to:

Draft