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


  • Craig100 1136 posts 2523 karma points c-trib
    Apr 13, 2021 @ 14:20
    Craig100
    0

    Update existing records

    Using CMSImport
    Umbraco 8

    Umb 8.12.2 CMSImport V4.1.1

    Hi,

    I have built a small website that is to be updated via CSV file imports. CMSImport is set to "Update record" when record exists and the Primary key is the page name in the CSV and "Delete old records" is on.

    I'm finding that the import is only updating 1 of the 12 pages and creating new versions of the other 11 pages. The page names in the CSV file exactly match those in Umbraco. The CSV file looks correct when opened in a plain text editor. I've tried setting the Text Indicator to "" and None but it makes no difference. How do I get CMSImport to update rather than create new pages?

    Thanks,

    Craig

    Copy Link
  • Richard Soeteman 4035 posts 12842 karma points MVP
    Apr 14, 2021 @ 07:31
    Richard Soeteman
    0

    Hi Craig,

    You need unique id's for the primary keys. CMSImport keeps an internal relation between imported data and the Umbraco document. It will not look at page id's or names.

    Hope this explains,

    Richard

    Copy Link
  • Craig100 1136 posts 2523 karma points c-trib
    Apr 14, 2021 @ 08:12
    Craig100
    0

    Thanks Richard,

    If I delete a node's existing children and import from scratch, then it looks like it updates ok on following imports.

    I'll have to bear that in mind for future use cases. It won't "update" existing content, it will only update it's own imports.

    Craig

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft