If you need to perform a bulk upload that allows you to edit multiple users or different fields of the same user at the same time, you can do it by performing a bulk upload, which allows you to update:
- Surname
- Name
- Birth date
- Phone number
- Mail address
- Hiring date
To perform the upload, you must follow these steps:
1. Log in to Humand Admin
2. On the left menu, go to "Users"
3. Under the Create user arrow, select “Bulk upload of users”.
4. Follow this step-by-step:
-
From here you can download the spreadsheet with all the data of the existing users:
-
Then, complete or overwrite the fields you want to modify or update for the users.
Follow these tips when completing the spreadsheet:
- Usernames cannot exceed 100 characters and the only valid special characters are . @ - +.
- In the third step you can define whether you are adding new users or updating the information of existing users.
- If you decide to overwrite the information, all the cells left empty in the excel will be loaded empty in the user information, and the rest of the data will remain the same as in the excel file for each user. The password field can be left empty without deleting the user's password.
- The excel format must be maintained. No new columns or sheets can be added.
- No cell can exceed 255 characters.
- The excel can have up to 1500 rows.
Note that although they will not be mandatory, we can take advantage of this instance and load extra user data that will be functional with multiple Humand modules such as:
- Birth date
- Phone number
- Mail address
- Boss
- Hiring date
-
After editing the spreadsheet, select the file to upload, choose to "overwrite the information" and click "Complete".
4. After uploading, you can see on the Status column if the data upload was successful:
5. That's it! You have successfully uploaded the new information.