How to update documents with the Import Toolkit

Digital Team asked on June 1, 2016 17:48

Hi,

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?

Thanks

kentico import toolkit

Recent Answers

David te Kloese answered on June 2, 2016 01:42

Hi,

I assume you've followed all steps mentioned on DevNet: https://devnet.kentico.com/docs/7_0RC/devguide/index.html?import_toolkit_final_steps.htm

Mainly Step 6 and details here should be interesting to you: https://devnet.kentico.com/docs/7_0RC/devguide/index.html?import_toolkit_final_steps.htm

What is the Where Condition in step 6, since the auto mapping on GUID doesn't seem to work.

0 votesVote for this answer Mark as a Correct answer

Digital Team answered on June 2, 2016 10:10

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.

0 votesVote for this answer Mark as a Correct answer

David te Kloese answered on June 2, 2016 13:14

No experience but guess something like:

NodeAliasPath ='{%NodeAliasPath%}'

0 votesVote for this answer Mark as a Correct answer