Users can be imported en masse from a CSV or txt file, into a user directory. 

From the "Users" tool, click on "Import users". 

Then select the population and user directory into which to import your users. The directory must be an editable directory (database users).

Then select the CSV or text file containing the users.

Two options are available for this import:

  • Delete users not present in the file: the user directory will be emptied of users not present in the file. Check this box if the file contains an exact update of all your users.
  • Passwords are hashed : 
    • if your file contains passwords in clear text, leave this box unchecked, as the passwords will be encrypted before storage at import time
    • if your file contains hashed passwords, check this box to store the passwords without further transformation. In this case, the passwords must have been hashed with SHA512 with a salt key present in the file ("salt" column).

Users already in the user directory will be updated.

The file must contain :

  • a header line containing mimima "login;lastname;firstname;email;password" (order doesn't matter) or "login;lastname;firstname;email;password;salt" if passwords are hashed in the file.
  • then one user per line (the separator is the semicolon ; )

File examples :

With plaintext passwords

login;lastname;firstname;email;password          
login1;Lastname1;Firstname1;mail1@example.con;password1          
login2;Lastname2;Firstname2;mail2@example.con;password2          
login3;Lastname3;Firstname3;mail3@example.con;password3          
login4;Lastname4;Firstname4;mail4@example.con;password4                      

With hashed passwords

login;lastname;firstname;email;password;salt          
login1;Lastname1;Firstname1;mail1@example.con;CFFBC01BF8EA8354BE249B20E30D495A42E05861103D9A044C7E3802C27C7C0D93A6127CBA9DAD58B9861841CDFDB1532F91C7DB5DD2E7C5D63F5C30C9FB84DD;dac6595c04dda81          
login2;Lastname2;Firstname2;mail2@example.con;E913DEFDF16F3E969C8A409BEE825717735F0B7E39DC747821861E5B72B46E0C8C5AD5049FB17EFDE2D193D578CB327DBDFEDF063A361A76C323872648FDF5A0;bts4597p04osd12          
login3;Lastname3;Firstname3;mail3@example.con;AD096DAAF13354D889F431A0849ED2908DBF656721C7121D1350696CDB5E86E93257C3B88E357D16808BEBD7567879F70FE6D423AE5D6FF2259971F7F0B70160;poc1364m08llm78          
login4;Lastname4;Firstname4;mail4@example.con;98E20BFE3429B0A3C0398069D7FC121133BF973C6F08BC23DF1E46143EDEE24C017A5C758726135A749BC79AB3AD5098A0AB7AF83A8A7625EE29D987DE177823;faq9876a07jst45          
Back to top