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.
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. 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."
|
|
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.
|
|
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
|
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_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.
|
|
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 "]"
|