Migrate legacy system users/passwords into Creatio

Hello community!



We have a client with a legacy application which is used by 500 odd users. Creatio is to replace this legacy app and the client would like all 500 users to be migrated into Creatio - including their passwords - thereby not forcing users to reset/set new passwords on Creatio. The migration will happen via SQL scripts which will directly write to Creatio's DB. 

 

1. How can I directly modify/add a user's PW via SQL???

2. Can I programatically modify a user's PW? I notice that the default change PW feature calls the AdministrationService/ValidatePassword and AdministrationService/UpdateOrCreateUser?? If I replicate this via C#, I should be able to change the password programmatically. Request you to confirm. 

 

P.S I am aware that the passwords of System users are stored in the SysAdminUnit table but they are hashed.

Like 0

Like

4 comments
Best reply

Best option would be to import the users using the Excel import. You can include a password in the Excel file, but you just can't name the column "Password" or it won't let you continue as the screen locks up if the Excel file contains a column named password (we usually just name the column PW). See more here: https://customerfx.com/article/importing-users-into-creatio-formerly-bp…

 

Of course, once they are imported, you can update the users/contacts and add/remove roles as needed via SQL or OData, etc.

Ryan

Hello,

 

As for now, there is no option to change or view passwords via code. You can import users with passwords via Excel import tool. If you add password column it will be imported as it is specified in the file. 

 

Best regards,

Angela

Best option would be to import the users using the Excel import. You can include a password in the Excel file, but you just can't name the column "Password" or it won't let you continue as the screen locks up if the Excel file contains a column named password (we usually just name the column PW). See more here: https://customerfx.com/article/importing-users-into-creatio-formerly-bp…

 

Of course, once they are imported, you can update the users/contacts and add/remove roles as needed via SQL or OData, etc.

Ryan

Angela Reyes, @Ryan Farley

Hi Angela. We understand that the Excel import is one way to go about this. Nevertheless, we want to understand how the password is hashed and stored in the DB. 



Can you shed some light on what hashing/salting/encryption is used to convert the raw password to the hashed form? There will be some cases where a manual excel import is not feasible and passwords will have to be migrated Database to Database via SQL. This info will help us there.

M Shrikanth,

We are using SHA-256 + hashing with salt using Bcrypt to store passwords in DB.

Show all comments