Along with sequential updates, the term "Member" is being changed to "User", and "Employee ID" is being changed to "User ID" within the help pages. If "Member" or "Employee ID" is still displayed on your screen, please read them as "User" or "User ID" while referring to this help documentation. For more details on the background of this change, please check this announcement.
Overview
Josys uses User IDs and email addresses as unique keys for users.
This page explains how to update user email addresses in bulk using a CSV file.
Please use this method when changing email address domains, etc.
Steps
1. When User IDs are set
By importing a CSV file, you can update email addresses in bulk using the User ID as the unique key.
(Example) If the following data exists, you can update the email addresses using User IDs 0001 and 0002 as keys.
| User ID | Email Address | Name | Other Columns |
|---|---|---|---|
| 0001 | (Blank) | Taro Yamada | |
| 0002 | (Blank) | Hanako Suzuki |
2. When User IDs are not set
If User IDs are not registered, you can update them by following these steps:
- Assign temporary User IDs in bulk via CSV using the existing email addresses.
- Update the email addresses in bulk via CSV using the temporary User IDs as keys.
- Delete the User IDs via CSV (leaving only the email addresses).
(Example) If the following data exists:
| User ID | Email Address | Name | Other Columns |
|---|---|---|---|
| taro.yamada@josys.com | Taro Yamada | ||
| hanako.suzuki@josys.com | Hanako Suzuki |
1. First, assign temporary User IDs to the data.
| User ID | Email Address | Name | Other Columns |
|---|---|---|---|
| ABC000006 | taro.yamada@josys.com | Taro Yamada | |
| ABC000007 | hanako.suzuki@josys.com | Hanako Suzuki |
2. Update the email addresses using the User IDs as keys.
| User ID | Email Address | Name | Other Columns |
|---|---|---|---|
| ABC000006 | taro.yamada@josys.com → t.yamada@josys.com | Taro Yamada | |
| ABC000007 | hanako.suzuki@josys.com → h.suzuki@josys.com | Hanako Suzuki |
3. Import the data with the User ID column left blank and the email addresses filled in, and delete the temporary User IDs as needed.
| User ID | Email Address | Name | Other Columns |
|---|---|---|---|
| ABC000006 → (Blank) | t.yamada@josys.com | Taro Yamada | |
| ABC000007 → (Blank) | h.suzuki@josys.com | Hanako Suzuki |