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. "@" may be available depending on a setting. Configuring the User Login Methods and Authentication Devices |
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. |
pin | No | - | - | - | Not used with this machine. |
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 | - | - | - | Not used with this machine. |
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 | No | - | - | - | Not used with this machine. |
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 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 |
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. |
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. |
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 "]" |