How to overwrite with Import Toolkit

Monjoie Dominique asked on March 14, 2017 10:49

Hi,

I have a lot of pages (more than 500 of Page Type 'Who'). This page type includes informations such as Name, Address, City and so on. All is fullfilled but I created a new field called Category. On the other hand, I have an Excel file with 2 columns (NumWho and Category). NumWho in my Excel file have to match WhoID in my page type but where is the WhoID field at step 6 ?. Import Toolkit always create new fields instead of overwriting existing ones. Is there an easy solution to update my records with an additional field ? Is it possible to do that with Import Toolkit or do I have to use SQL statements and, in this case, how to do ?

Thanks,

Best regards,

import toolkit overwrite

Correct Answer

Brenden Kehren answered on March 16, 2017 14:08

If you don't see your primary key field then you need to check the box in the top right corner of step 6 that says "show advanced columns".

0 votesVote for this answer Unmark Correct answer

Recent Answers

Brenden Kehren answered on March 14, 2017 13:46

You can use the import toolkit to update existing records as long as they have the same primary key values and you map that out.

To add that additional field, go to your page type and add that field. Then restart KIT (it caches the structure until you restart it) and your new field will be in the list. Don't map any of the other fields except the fields you want to update and the ID field and import away.

0 votesVote for this answer Mark as a Correct answer

Monjoie Dominique answered on March 14, 2017 18:10

Hi Mr Kerhen,

I spent a long time today to do that but unfortunately without success. I created a very sipmle Page Type called Test, so it generated an automatic field (TestID) and I just added 2 fields : TestName and TestCategory. I have my Excel file with also 3 fields called NumWho, WhoName and WhoCategory. Until step 6, all is well but there, I don't see the possibility to match TestID (it doesn't appear anywhere). I try to use it as alias source name field (to match document name). I try to use a WHERE Condition : TestID = NumWho and I only match TestCategory and WhoCategory (and of course the document name) but it always create me a new set of pages instead of overwriting existing ones.

What is wrong in my approach ?

Thanks,

Sorry for my bad english,

All the best

0 votesVote for this answer Mark as a Correct answer