Hi, I'm using CMSImport pro on an umbraco 4.11.5 project.
I am trying to update existing records that were originally manually created. I set the Name of the node as the Primary Key and select the 'update' option. The title of the column in the CSV or XLS also matches 'Name'. I've checked the primary keys time and time again to check they match and there's no whitespace.
First time I do the import it creates new nodes and it doesn't update the existing ones. If I run the import again, it updates the newly imported ones, but I can't get it to make a mark on the original manually entered nodes.
has anyone had a similar situation and know any ways to get it to do what I need?
Thsi is because there is a relation between imported nodes and datarecords only. So only the imported records can be updated. You can do two things:
delete the old records since you are going to import those again.
Add the records top the CMSImportRelation table. Format of DataSourceKey is [Data Adapter][Primary key name][Primary key value]. Then CMSImport knows the relation.
records being duplicated, not updating
Hi, I'm using CMSImport pro on an umbraco 4.11.5 project.
I am trying to update existing records that were originally manually created. I set the Name of the node as the Primary Key and select the 'update' option. The title of the column in the CSV or XLS also matches 'Name'. I've checked the primary keys time and time again to check they match and there's no whitespace.
First time I do the import it creates new nodes and it doesn't update the existing ones. If I run the import again, it updates the newly imported ones, but I can't get it to make a mark on the original manually entered nodes.
has anyone had a similar situation and know any ways to get it to do what I need?
thanks
Hi Rob,
Thsi is because there is a relation between imported nodes and datarecords only. So only the imported records can be updated. You can do two things:
Hope this helps.
Best,
Richard
is working on a reply...