R3051: Format of CSV Bulk Update (User)

 

These are examples and formats of CSV files when registering Users in bulk.

Format of CSV

For each User to be added, separate each item on one line with a single-byte comma (,)

Format (Order of Items)

User Name,Email Address,Password,Organization1,Organization2,...

Items to Describe

Items	Description
User Name	The name of the User to be added (mandatory)
Email Address	The email address of the User to be added (mandatory)
Password	The Password of the User to be added (optional)
Organization	Organizations to which a User to be added belongs (optional) When adding a User with a Position in an organization, put "!!Position name" after the Organization name Multiple Organizations can be specified

• A comma is required even if the value is omitted
• If the password is omitted, it will be issued automatically (Displayed on confirmation screen)
• When more than one Organization is written, the first one will be the [Main organization]
  • If omitting, a User is added without affiliation

Example

SouthPole,[e-mail],south1234,Sales,Sales 1st division!!Division Manager
Hawaii,[e-mail],,Sales 1st division
Oafu,[e-mail],

---

Notes

• Using “Email address” as a key, the registered Users are collated and new Users are registered in bulk
  • No matching "Email address" exists: New addition
  • Matching “Email address” exists: Overwrite
• If you specify an Organization or Position that is not registered, it will be ignored
  • The User is registered without affiliation nor Position