Import local users from a CSV File
Use a CSV file to add a large number of local users at one time. For the format of CSV files, see Format of a Local User CSV File prior to completing these instructions. You can download a sample CSV file from the import screen.
When importing a CSV file, make sure that the language of the Management Console is the same one as when the file has been exported. Otherwise, some setting values are not imported.
-
Click [User Management] → [Users].
-
Click
(Import).
-
Click [Browse...] on the [Import CSV File] screen, and then select a CSV file.
If you have not yet created the CSV file, click [Download Sample File] to download a sample CSV file to be used as a template.
-
Click [Upload], and then click [OK].
The information imported into the local users are displayed.
Format of a Local User CSV File
A local user information CSV file is written out in the format indicated below: The variables are indicated in bold.
Do not change the information in lines one through three, because this information is used for identification
Line number |
Contents |
---|---|
1 |
# Format Version: X.X.X.X |
2 |
# Generated at: (Date/time of write-out) |
3 |
# Function Name: Users |
4 |
"(Item name of the column (item name of import/export))" |
5 |
"(Value that corresponds to the item name of the column)" |
See the following columns for the item names of the column (item names of import/export) and their meanings.
Item name of the column (item name of import/export) |
Column name of the database |
Description |
---|---|---|
slnxuser_name |
slnxuser_name |
User Name |
auth_name |
auth_id |
Authentication Profile |
slnxuser_displayname |
slnxuser_displayname |
Display Name |
slnxuser_email |
slnxuser_email |
|
slnxuser_homefolder |
slnxuser_homefolder |
User Home Folder |
slnxdep_name |
slnxdep_id |
Department |
slnxuser_faxnumber |
slnxuser_faxnumber |
Fax |
slnxuser_pw |
slnxuser_password |
Password |
slnxuser_pincode |
slnxuser_pincode |
PIN |
slnxuser_secondarypincode |
slnxuser_secondarypincode |
Secondary PIN |
slnxuser_lang |
slnxuser_lang |
User Language |
slnxcc_name |
slnxuser_defaultcc |
Default Cost Center |
slnxperm_name |
slnxperm_id |
Permission |
slnxuser_synflag |
slnxuser_synflag |
LDAP Synchronization |
slnxuser_enforce_colorbalance |
slnxuser_enforce_colorbalance |
Enforce Color Page Limit |
slnxuser_enforce_balance |
slnxuser_enforce_balance |
Enforce Account Limit |
slnxuser_colorquota |
slnxuser_colorquota |
Default Color Page Limit |
slnxuser_colorbalance |
slnxuser_colorbalance |
Color Page Balance |
slnxuser_quota |
slnxuser_quota |
Default Account Limit |
slnxuser_balance |
slnxuser_balance |
Account Balance |