Adding and Editing User Information in a CSV File

This section describes the content of each column in a CSV file used for importing or exporting. Refer to this section when editing CSV files.
However, if "No" is written in the "Change Required" section for a particular column, do not change the content of that column.
Column Name
Change Required
Valid Characters
Invalid Characters
Compatibility With Remote UI Screen
Notes
uid
Yes
1 to 32 characters
Control characters, single-byte spaces, and the following characters:
\ / : * ? | < > [ ] ; , = + @ "
Must be input when importing.
"@" may be available depending on a setting. <Allow Use of @ in User Name>
password
Yes
0 to 32 characters within the ISO885915 character set
Control characters
Output as "********" (* x 8) when exporting.
When updating the password, "********" will be deleted and overwritten by the new password. However, when importing changes, even if you leave the field unspecified (blank), it will not be overwritten as empty (blank), but will instead retain the existing value.
If this item is omitted when importing changes, the existing user will carry over the original password.
cn
Yes
0 to 32 characters
Control characters
N/A
cn;lang-ja;phonetic
Yes
0 to 32 characters
Control characters
See "Notes."
Displayed as "phonetic" if the display language is set to "Japanese."
mail
Yes
Combination of 0 to 256 alphanumeric characters and symbols
Control characters
N/A
avatorImgPath
No
-
-
Cannot be changed. Automatically assigned when specifying icon images.
dept_id
Yes
A number up to seven digits
Non-single-byte numeric characters
N/A
dept_pin
Yes
A number up to seven digits
Non-single-byte numeric characters
N/A
roleName
Yes
0 to 32 characters
Control characters, single-byte spaces, and the following characters:
\ / : * ? | <>[];,=+@"&
If this item is omitted, or if a name is specified that is not registered in role management, it will be changed to the initial role setting.
cardId1
Yes
Combination of 0 to 128 alphanumeric characters and symbols
Control characters
-
Not case sensitive.
Cannot conflict with another user or "cardId2". If it conflicts with another user, it will be left blank.
issueNumber1
Yes
0 to 2147483647
Non-single-byte numeric characters
-
N/A
cardId2
Yes
Combination of 0 to 128 alphanumeric characters and symbols
Control characters
-
Not case sensitive.
Cannot conflict with another user or "cardId1". If it conflicts with another user or "cardId1", it will be left blank.
issueNumber2
Yes
0 to 2147483647
Non-single-byte numeric characters
-
N/A
accountExpires
Yes
See "Notes."
See "Notes."
YYYYMMDD format. "235959" is automatically added as the time after importing.
accountDisabled
Yes
1 or 0
Any character besides "1" (disable) or "0" (enable)
N/A
group
Yes
0 to 64 characters.
You can specify up to 10 items.
Control characters, single-byte spaces, and special symbols.
The "Group name" registered in the user group management is written here. If the user belongs to multiple groups, group names are connected with a "|".
createDate
Yes
See "Notes."
See "Notes."
-
(N/A)
Output in the "TYYYYMMDDhhmmssmmm" format when exporting. (The "T" is added in order to prevent corruption of the text.)
When importing, input the information in one of the following formats.
YYYYMMDDhhmmssmmm
TYYYYMMDDhhmmssmmm
YYYYMMDD
TYYYYMMDD
Used for sorting in the Picture Login registration order.
If you omit this item, the date and time of importing is used for the date and time of registration for new users. For existing users, the original registration date and time are carried over.
lastLoginDate
Yes
See "Notes."
See "Notes."
-
(N/A)
The date and time that the user last logged in are stored.
Output in the "TYYYYMMDDhhmmssmmm" format when exporting. (The "T" is added in order to prevent corruption of the text.)
When importing, input the information in one of the following formats.
YYYYMMDDhhmmssmmm
TYYYYMMDDhhmmssmmm
YYYYMMDD
TYYYYMMDD
Used for determining whether a user has logged in and whether to perform automatic user deletion.
If you omit this item, the date and time that the user last logged in are blank for new users. For existing users, date and time that the user last logged in are carried over.
dc
No
0 to 32 characters
Control characters
-
(N/A)
Cannot be changed. It will be automatically assigned for the following users.
Users registered following server authentication
Users registered via <Register Automatically When Job Is Received> in Picture Login
uuid
No
-
-
-
Cannot be changed. Automatically assigned during user registration.
sdl_digest
No
-
-
-
Cannot be changed. Automatically generated when registering/changing password.
uac_advbox_digest1
No
-
-
-
Cannot be changed. Automatically generated when registering/changing password.
uac_advbox_digest2
No
-
-
-
Cannot be changed. Automatically generated when registering/changing password.
pin_digest
No
-
-
-
Cannot be changed. Automatically generated when registering/changing PIN.
server_user_gp_key
No
-
-
-
Cannot be changed. This is the group to which the user who is registered after completing server authentication belongs.
server_user_gp_value
No
-
-
-
Cannot be changed. This is the group to which the user who is registered after completing server authentication belongs.
non_expire_password
Yes
1 or 0
Any character besides "1" (enable) or "0" (disable)
If this item is not entered, "0" (disabled) is reflected.
next_password_change_required
Yes
1 or 0
Any character besides "1" (enable) or "0" (disable)
If this item is not entered, "0" (disabled) is reflected.
second_factor
Yes
1 or 2
Other than "1" (PIN) or "2" (pattern)
-
If both a PIN and pattern are set, the value of the item that was last set is reflected.
If both a PIN and pattern are not set, the value is ignored.
If login via pattern is set, you can switch to login via PIN by setting second_factor to "1" (PIN), and importing a CSV file with the PIN entered in "pin".
CharSet
-
-
-
-
For UTF8, "CharSet:UTF8" will be written in the column line.
The line at the beginning of the file is the column line.
Items names may not appear in sequence.
The encodings supported by CSV files are UTF-8, SJIS, BIG5, GB2312, and Korean.
Text strings in exported CSV files are surrounded by "[" and "]" if any of the following conditions apply. When editing a CSV file and adding new text strings that meet the following conditions, surround any such text strings with "[" and "]".
Numbers starting with "0"
Numbers greater than 12 digits
Text strings surrounded by "[" and "]"
A9AU-0CE