Sign in Register
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!

    Copy Link
  • Søren Kottal 712 posts 4570 karma points MVP 6x 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.

    Copy Link
  • 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?

    Copy Link
  • 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?

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft