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?
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.
Update existing records
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
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
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
is working on a reply...