Importing Users Using Import Toolkit

Daniel Maley asked on January 8, 2018 19:13

Hello,

I am using the Import Toolkit to import users from one instance of Kentico to another as outlined in this article. After the import is complete, I attempt to login on the Target site using one of the imported users and the login fails. Has anyone used this tool to import users successfully? Any idea what I am doing wrong?

import import toolkit

Correct Answer

David te Kloese answered on January 9, 2018 09:34

When selected "Password format" is SHA-something or PBKDF2 (which you should) it's adding a salt based on the User GUID. So probably best to also copy the GUID's. (never use plain text password)

0 votesVote for this answer Unmark Correct answer

Recent Answers

Peter Mogilnitski answered on January 8, 2018 19:29

Check if the users are enabled after your import ( select UserEnabled, * from cms_user where ...)

0 votesVote for this answer Mark as a Correct answer

Daniel Maley answered on January 8, 2018 19:32

Hi Peter, thanks, yes the user is Enabled. The CMS_User table is identical on the Source and Target sites... This includes the Username and Password fields.

0 votesVote for this answer Mark as a Correct answer

Peter Mogilnitski answered on January 8, 2018 20:04

Are they actually assigned to the your site? Check CMS_UserSite table

0 votesVote for this answer Mark as a Correct answer

Daniel Maley answered on January 8, 2018 20:14

Hi Peter yes, the site stuff is correct as well. I believe this may be due to the fact that a new GUID is assigned to the User after the import?

0 votesVote for this answer Mark as a Correct answer

Peter Mogilnitski answered on January 8, 2018 20:40

I don't think that GUID matters in this case (you may try to restart the site just in case), I guess you have to take two users (imported and existing one) and compare their records side by side for 2 two tables: CMS_User and CMS_Usersettings to see what is missing or not set.

0 votesVote for this answer Mark as a Correct answer

Daniel Maley answered on January 8, 2018 21:00

Hi Peter, I have compared both tables. Once I updated the Target GUID to match the source in the CMS_User and CMS_UserSettings table I was able to login. I believe the password might be hashed using the GUID and that may have been the issue.

0 votesVote for this answer Mark as a Correct answer

Daniel Maley answered on January 9, 2018 16:02

Thanks David that makes sense. Unfortunately the Import Toolkit does not allow you to copy the User GUID column so I had to write some additional SQL to update the CMS_User and CMS_UserSettings table after the import.

0 votesVote for this answer Mark as a Correct answer