Bulk update based on certain condition

joyanta sen asked on May 15, 2018 18:59

Hello, I am new in CMS and started my CMS journey with Kentico11. Currently I am facing a problem. I need to update UserInfo data from the data available in CSV file and that too based on a condition, which is LastUpdatedDate in the file should be greater than the data in UserInfo table. Could you please tell me the way to bulk update based on some condition.

Thanks.

userinfo update

Recent Answers

Peter Mogilnitski answered on May 16, 2018 00:49 (last edited on May 16, 2018 00:59)

You trying to update CMS_User table (BACKUP YOUR TABLE first). This CSV data file is a some sort of a copy of CMS_User? or it is coming from a different source? Normally you would use Kentico Import Toolkit. It does update by default using GUID (i.e.UserGUID) to join the records and you can specify your WHERE condition (you probably have to use macro in there).

1 votesVote for this answer Mark as a Correct answer

Juraj Ondrus answered on May 17, 2018 07:21

Just to add what Peter said, you can also create a simple API tool using Kentico API to do the job: https://docs.kentico.com/api11/configuration/users

0 votesVote for this answer Mark as a Correct answer