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.
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.
If this item is omitted when importing changes, the existing user will carry over the original password.
pin
Yes
A number up to seven digits
Non-numeric characters
Output as "*******" (* x 7) when exporting.
When updating the PIN, "*******" will be deleted and overwritten by the new PIN.
If this item is omitted when importing changes, the existing user will carry over the original PIN.
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."
cardIdList
Yes
Card ID: a number up to eight alphanumeric characters
You can specify up to 1,000 items.
Non-single-byte alphanumeric characters
See "Notes."
Exported only if the optional Copy Card Reader is attached.
Multiple items of card information are connected with a semi-colon (;).
This item appears between "e-mail address" and "icon image" when the optional Copy Card Reader is attached.
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.
dc
Yes
0 to 32 characters
Control characters
-
(N/A)
N/A
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_flg
No
-
-
-
Cannot be changed. This is an identification flag for the user registered after completing server authentication.
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.
The line at the beginning of the file is the column line.
Items names may not appear in sequence.
The supported encoding for CSV files is UTF-8.
To edit a CSV file, use a CSV file editor or text editor. If you open a CSV file in Microsoft Excel, numbers will not be recognized as strings and initial zeros will be lost.
1713-0RW