Editing User Information Using a CSV File

This section describes the CSV file in the User Authentication format used to import and export user information in the local device.
You can directly edit an exported CSV file to add and edit user information managed with User Authentication.

Encoding and Description Rules

CSV files support UTF-8, SJIS, BIG5, GB2312, and Korean encoding.
The first row in a CSV file is the column row. The second and later rows are user information.
The columns are in no particular order.
Strings in an exported CSV file that meet any of the following conditions are enclosed in brackets [ ]. To add a new string that meets the following conditions when editing a CSV file, enclose it in brackets [ ].
Number that starts with 0
Number with 12 or more digits
String enclosed in brackets [ ]

Description (Column)

The following are the columns described in the CSV file:
uid
User name.
Be sure to specify this when importing.
Use 1 to 32 characters.
Do not use control characters, spaces, or the following characters: \ / : * ? | < > [ ] ; , = + @ ".
* The at sign (@) may be available depending on the settings. [Allow Use of @ in User Name]
password
The password used when logging in with keyboard authentication.
Use up to 32 ISO 88559-15 encoded characters.
The password is displayed as "********" (eight asterisks) when exported.
To change the password, delete "********" and enter a new password.
If the password is left blank and differential import is used to import user information, existing users keep their original passwords.
When you access Advanced Box opened as an SMB server, authentication may fail if the password is imported as "********."
pin
The PIN used for Picture Login when the user is required to enter a PIN.
Specify a number from one to seven digits in length.
The PIN is displayed as "*******" (seven asterisks) when exported.
To change the PIN, delete "*******" and enter a new PIN.
If the PIN is left blank and differential import is used to import user information, existing users keep their original PINs.
cn
User's display name. The display name is used for the following:
The user name at forced hold
The sender name when sending e-mail
The user name at Picture Login
Use up to 32 characters. Do not use control characters.
cn;lang-ja;phonetic
Displays the reading of the user's display name when Japanese is selected for the display language.
Use up to 32 characters.
cardIdList
User's card ID.
Use up to eight alphanumeric characters. To enter more than one card ID, separate each card ID with a semicolon (;). Specify up to 1,000 card IDs.
mail
User's e-mail address.
Use up to 256 alphanumeric characters and symbols.
avatorImgPath (cannot be changed)
This is set automatically when the icon image is specified.
dept_id
Department ID to which the user belongs when using Department ID Management.
Specify a number up to seven digits.
dept_pin
Department ID PIN.
Specify a number up to seven digits.
roleName
User's privilege (role).
Specify a role name registered to the machine. If left blank or a role name not registered to the machine is specified, the default role is used.
* By default, the default role is set to "GeneralUser." You can change the default role. [Default Role When Registering User]
accountExpires
Account expiration date.
Use the format YYYYMMDD to specify the expiration date. When the file is imported, the time is set automatically to "235959."
accountDisabled
Set the account status (enabled or disabled).
Specify 0 (enabled) or 1 (disabled).
group
The user group to which the user belongs.
Specify the group name registered to the machine. When you assign more than one user group, you can specify up to 10 groups separated by a vertical line (|).
createDate
User's registration date and time.
* This is used for registered order sorting for Picture Login.
The date and time is output in the format "TYYYYMMDDhhmmssmmm" when exported.
* "T" is added to the beginning of the string to prevent garbled characters.
Specify the date and time in any of the following formats when importing the file.
YYYYMMDDhhmmssmmm
TYYYYMMDDhhmmssmmm
YYYYMMDD
TYYYYMMDD
If the date and time is left blank at import, the setting is configured as follows:
The import date and time becomes the registration date and time for new users.
The original registration date and time is used for existing users.
lastLoginDate
User's last login date and time. This is used to determine if a user is logged in and whether to automatically delete a user.
The date and time is output in the format "TYYYYMMDDhhmmssmmm" when exported.
* "T" is added to the beginning of the string to prevent garbled characters.
Specify the date and time in any of the following formats when importing the file.
YYYYMMDDhhmmssmmm
TYYYYMMDDhhmmssmmm
YYYYMMDD
TYYYYMMDD
If the date and time is left blank at import, the setting is configured as follows:
The last login date and time is blank for new users.
The original last login date and time is used for existing users.
dc (cannot be changed)
This is set automatically for the following users:
Users registered after server authentication
Users registered with "Register Automatically When Job Is Received" for Picture Login
uuid (cannot be changed)
This is set automatically when a user is registered.
sdl_digest (cannot be changed)
This is generated automatically when a password is registered or changed.
uac_advbox_digest1 (cannot be changed)
This is generated automatically when a password is registered or changed.
uac_advbox_digest2 (cannot be changed)
This is generated automatically when a password is registered or changed.
pin_digest (cannot be changed)
This is generated automatically when a PIN is registered or changed.
server_user_flg (cannot be changed)
ID flag of the user who registered after server authentication.
server_user_gp_key (cannot be changed)
The group to which the user who registered after server authentication belongs.
server_user_gp_value (cannot be changed)
The group to which the user who registered after server authentication belongs.
non_expire_password
Set the password expiration date (enabled or disabled).
Specify 0 (disabled) or 1 (enabled).
next_password_change_required
Set to force the user to change the password at first login (enabled or disabled).
Specify 0 (disabled) or 1 (enabled).
second_factor
Set the login method for two-factor authentication at Picture Login.
Specify 1 (PIN) or 2 (pattern).
When both PIN and pattern are set, the value of the last specified method is used.
When the PIN and pattern are not set, the login method is disabled.
If "second _factor" is set to "1" (PIN) and the CSV file with the PIN specified is imported while a pattern is set for the login method, the login method is changed to login with PIN.
CharSet:<encoding>
CSV file encoding (column row only).
Example: When using UTF-8
The column row is "CharSet:UTF8."
A0YC-1LH