+2Hi,
I need to update my database via API. The problem I've encountered is that during this process, I update and create users.
For new users, I need to provide the password, but not for existing users.
The database has over 190,000 active users, and checking whether they already exist on the platform is not a solution. The vast majority do not have registered email addresses, so password recovery is also not a solution.
Has anyone else experienced this problem? Any ideas?
Best answer by KMallette
Hi,
I need to update my database via API. The problem I've encountered is that during this process, I update and create users.
For new users, I need to provide the password, but not for existing users.
The database has over 190,000 active users, and checking whether they already exist on the platform is not a solution. The vast majority do not have registered email addresses, so password recovery is also not a solution.
Has anyone else experienced this problem? Any ideas?
Then, after that, when updating the database via API, you’ll need to either 1. do a search to see if the account exists or 2. have a provision for the script to do something if it errors trying to create a new account with the same username (which, again won’t work perfectly until you have a standardization of your usernames). In your script you could set a default password and then enable the “Force password update on first login”. Then communicate (because now you have email addresses that you can use) to your users what that standard password is. They’ll have to change it first time the come to the site.
Looks like /manage/v1/user (to create) and /manage/v1/user{id} (to update) both have a ‘force_change” option for the password … and I think I saw a place to set a notification as well.
Hi
Have you considered using the CSV option to update or create users? There’s an option box for update information for existing users. You can also map to passwords you created in the CSV and also force users to change password at next login. Not sure if any of this helps. Always test in sandbox.
+4
If you did that you could use FirstName.LastName as their password, or give them all similar passwords.
Without email I am not sure how any of this will be communicated to them.
Here is the code body I tested.
{
"userid": "daffy.duck@gmail.com",
"email": "daffy.duck@gmail.com",
"firstname": "Daffy",
"lastname": "Duck",
"password": "Daffy",
"level": 6,
"language": "english",
"timezone": "America/Chicago"
}As
You could do a bulk create with just basic info (the top 5 lines of the code I shared) and then do updates to the users as needed via the API.
+9Hi,
I need to update my database via API. The problem I've encountered is that during this process, I update and create users.
For new users, I need to provide the password, but not for existing users.
The database has over 190,000 active users, and checking whether they already exist on the platform is not a solution. The vast majority do not have registered email addresses, so password recovery is also not a solution.
Has anyone else experienced this problem? Any ideas?
Then, after that, when updating the database via API, you’ll need to either 1. do a search to see if the account exists or 2. have a provision for the script to do something if it errors trying to create a new account with the same username (which, again won’t work perfectly until you have a standardization of your usernames). In your script you could set a default password and then enable the “Force password update on first login”. Then communicate (because now you have email addresses that you can use) to your users what that standard password is. They’ll have to change it first time the come to the site.
Looks like /manage/v1/user (to create) and /manage/v1/user{id} (to update) both have a ‘force_change” option for the password … and I think I saw a place to set a notification as well.
+2Hi
Enter your email address or username and password below to log in to Docebo Community. No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.