Replace users with csv import
With Asprova My Schedule ver.25.3 or later, users can be created by importing csv files. To perform import, go to user management page at "/admin/users" and look for "Import users from file" button.
info
This operation can only be done by the default server admin, The user is always excluded from the replacement, and it cannot be included in the csv file.
warning
Importing users with csv will replace users. If the server has UserA and UserB, and you import a csv file containing UserC, the server will have only UserC.
CSV file format
The import csv file must follow the requirements below:
- The first row must be the column names specified in the table below.
- The default server admin must not be included.
- The rows must have no duplicate usernames.
| Column Index | Column Name | Description | Allowed values | Nullable |
|---|---|---|---|---|
| 1 | Username | Username. If the user is authenticated with AD, it is UPN. | string | no |
| 2 | DisplayName | Display name | string | yes |
| 3 | AuthMethod | Authentication method | "Password" or "ActiveDirectory" | no |
| 4 | Password | Password. Only valid if the auth method is "Password". | string | no |
| 5 | ServerPermission | Server-level permission | "ServerAdmin" | yes |
| 6 | ProjectId1 | Id of the project the user will be given permission on | string | yes |
| 7 | ProjectPermission1 | the project permission | "ProjectAdmin", "ResultInput" or "ReadOnly" | yes |
| 8 ~ 15 | ProjectIdN and ProjectPermissionN | Up to 10 pairs | see column 6 and 7 | yes |