Question

Auto-generated passwords

  • 13 January 2022
  • 4 replies
  • 75 views

Userlevel 7
Badge +7

Does anyone know if when importing users via the CSV option, can Docebo auto-generate passwords during that process? Or is this option only available when resetting individual passwords?


4 replies

Great question! I wonder if anyone has come across an answer to this. And I haven’t been able to find if you can assign a generic password during the CSV import/update option to new users? (i.e. during import assign say a standard password to all users as a baseline until we finalize our SSO)

Userlevel 5
Badge +1

we use an excel formula to generate the passwords when producing the CSV file:

in the field where the password is to be set:

 

=(CHAR(RANDBETWEEN(97,107))&CHAR(CHOOSE(RANDBETWEEN(1,3),RANDBETWEEN(65,72),RANDBETWEEN(74,78),RANDBETWEEN(80,90))))&RANDBETWEEN(2,9)&RANDBETWEEN(2,9)&CHAR(RANDBETWEEN(80,90))&RANDBETWEEN(2,9)&RANDBETWEEN(2,9)&CHAR(CHOOSE(RANDBETWEEN(1,3),RANDBETWEEN(65,72),RANDBETWEEN(74,78),RANDBETWEEN(80,90)))

Hope this helps :)

Gary

 

@Gary Jarvis Thanks Gary, super helpful! Once created and imported via CSV, how are you letting your users know what that first randomized password is before they are prompted to change it?

 

Userlevel 7
Badge +7

There are also many password generating tools available, some free some not, you can use.

Reply