I'm using the Kentico 7 Import Toolkit and want to import Documents in the tree.
The problem is when I tick "Import new and overwrite existing documents" it only create new Documents with a "(1)" instead of updating the original one.
I also tried to map a uniqueidentifier to NodeGUID using my INT primary key with followin query:
Select cast(CONVERT(BINARY(16), REVERSE(CONVERT(BINARY(16), MyIntID))) as uniqueidentifier) as NodeGUID , * from MyView
It generates the data, But when I execute the importer following error appears:
An error occured on import: Specified cast is not valid.
How can I make it update the exiting documents?
I assume you've followed all steps mentioned on DevNet:
Mainly Step 6 and details here should be interesting to you:
What is the Where Condition in step 6, since the auto mapping on GUID doesn't seem to work.
I left the where condition blank, what should I write in the field to get the documents matching and updating?
Also I used the GUID mapping in the custom tables (not documents) and it worked correctly updating the matching fields.
No experience but guess something like:
Please, sign in to be able to submit a new answer.