» MEAP » File Formats for Local Device Authentication User Information Files
|
File Formats for Local Device Authentication User Information Files
SDL Format
NetSpot Accountant 3.x Format
NetSpot Accountant 4.x Format
The following three file formats can be used for importing and exporting user information:
SDL format
NetSpot Accountant 3.x format
NetSpot Accountant 4.x format
NOTE
It is recommended you use the SDL Format when exporting and importing user information with imageWARE Accounting Manager (NetSpot Accountant).
Only the information for users that have a department ID assigned are exported with the NetSpot Accountant formats. If no users have department IDs assigned, a 0 byte file is exported.
If you use a NetSpot Accountant format, you may not be able to import users that are automatically registered.
SDL Format
The SDL format is the format used for local device authentication. This format adopts the LDIF file format, which sues the ldif file extension. LDIF (LDAP Data Interchange Format) is used for transferring directory information between LDAP directory servers, etc.
Each record in an LDIF file is separated by at least one empty line. A record comprises of multiple lines that do not include any empty lines. Each record contains an ID line (which can be omitted) and multiple entries. Each entry contains an attribute name and attribute value separated by a colon. If only blank spaces appear after the colon, that entry is ignored. However, if an entry is divided by a line break code and one space, that line break code and space are ignored. Characters after this are handled as if they are connected to the previous line, even if they are spaces. Either carriage return + line feed or line feed only can be used as the line break code. Line breaks are not allowed before the colon. Lines starting with # are ignored.
UTF-8 is used for character encoding.
Example:
dn: uid=J00001
userPassword: {sdl}1234567890abcdefghijklmn
canonUid: 1000001
canonPwd: 1010001
cn: SampleUser01
cn;lang-ja;phonetic:
mail: SampleUser.J00001@example.com
objectClass: top
objectClass: person
Input File Format
Attribute name
Can be omitted?
Default value used when omitted
Item name in SSO-H
Description
dn
No
-
User Name
"uid="login user name ("uid=" can be omitted). Must be from 1 to 32 characters. You cannot include spaces or the following symbols (\ / : * ? l < > [ ] ;, = + @ ").
userPassword
Yes
-
Password (corresponding to the user name)
When encrypted: the attribute value starts with "{sdl}". Use the encrypted value from the exported file.
When not encrypted: You can leave this blank or enter up to 32 characters.
canonUid
Yes
-
Department ID
Must be from 1 to 7 digits.
canonPwd
Yes
-
Password (corresponding to the department ID)
You can leave this blank or enter up to 7 digits.
cn
Yes
[null]
Displayed As
You can leave this blank or enter up to 32 characters.
cn;lang-ja;phonetic
Yes
[null]
-
-
mail
Yes
[null]
E-mail Address
You can leave this blank or enter up to 256 ASCII characters. The format of e-mail addresses is not checked.
objectClass
Yes
[null]
"top"
"top" (fixed)
objectClass
No
Not limited
"person"
"person" (fixed)
NOTE
1) The attribute names can be specified in any order. Unnecessary attribute names can be omitted.
2) User Type is not included in the input format. After the import is performed, edit it to "Administrator" as necessary.
Output File Format
Attribute name
Corresponding user information on the [Register]/[Edit] screen of [User Management]
Description
dn
User Name
The login user name.
userPassword
Password (corresponding to the user name)
The attribute value starts with "{sdl}" and the password is encrypted.
canonUid
Department ID
The department ID.
canonPwd
Password (corresponding to the department ID)
Not encrypted. If there are not enough digits, zeros are added to the start of the number.
cn
Displayed As
The display name.
cn;lang-ja;phonetic
-
-
mail
E-mail Address
The e-mail address.
Role
Role that the user belongs to
If "Administrator" is selected, the user type is set as the administrator. If it is omitted, default role is set.
objectClass
-
"top" (fixed)
objectClass
-
"person" (fixed)
NOTE
User Type is not output.
NetSpot Accountant 3.x Format
The NetSpot Accountant 3.x format is the file format for user information used in NetSpot Accountant 3.x. Windows Japanese (CP932) or Windows Latin-1 (CP1252) is used as the character code.
Input File Format
Item number
Item name*1
Corresponding user information on the [Register]/[Edit] screen of [User Management]
1
Parent Department ID
-
2
Account Type
-
3
User ID
User Name*2, Department ID
4
User Name
Displayed As
5
Password
Password
6
E-mail Address
E-mail Address
7
Log In Name
User Name*3
8
Domain Name
-
9-10
Printing Usage Limit
-
11
Card ID
-
Output File Format
Item number
Corresponding user information on the [Register]/[Edit] screen of [User Management]
Item name*1
Description
1
-
Parent Department ID
Always [0]
2
-
Account Type
Always [1] (user)
3
Department ID
User ID
4
Displayed As
User Name
5
Password
Password
Always NULL
6
E-mail Address
E-mail Address
7
User Name
Log In Name
8
-
Domain Name
Always " "
9-10
-
Printing Usage Limit
Always NULL
NOTE
*1: The item name (The item name in NetSpot Accountant 3.0 or later. Item names are not displayed in the CSV file itself.)
*2: When [User ID] is set for [User Name Type] in [NetSpot AccountantFormat Is Selected] in [Import] in the SSO-H management application.
*3: When [Windows User Name] is set for [User Name Type] in [NetSpot AccountantFormat Is Selected] in [Import] in the SSO-H management application.
NetSpot Accountant 4.x Format
The NetSpot Accountant 4.x format is the file format for user information used in NetSpot Accountant 4.x or later and imageWARE Accounting Manager 5.0 or later. Windows Japanese (CP932) or Windows Latin-1 (CP1252) is used as the character code.
Input File Format
Item number
Item name*1
Corresponding user information on the [Register]/[Edit] screen of [User Management]
1
Parent Department ID
-
2
Account Type
-
3
User ID
User Name*2, Department ID
4
User Name
Displayed As
5
Password
Password
6
E-mail Address
E-mail Address
7
Log In Name
User Name*3
8
Domain Name
-
9-15
Printing Usage Limit
-
16
Card ID
-
Output File Format
Item number
Corresponding user information on the [Register]/[Edit] screen of [User Management]
Item name*1
Description
1
-
Parent Department ID
Always [0]
2
-
Account Type
Always [1] (user)
3
Department ID
User ID
4
Displayed As
User Name
5
Password
Password
Always NULL
6
E-mail Address
E-mail Address
7
User Name
Log In Name
8
-
Domain Name
Always " "
9-15
-
Printing Usage Limit
Always NULL
16
-
Card ID
Always "##########"
NOTE
*1: The item name (The item name in NetSpot Accountant 4.0 or later or imageWARE Accounting Manager 5.0 or later. Item names are not displayed in the CSV file itself.)
*2: When [User ID] is set for [User Name Type] in [NetSpot AccountantFormat Is Selected] in [Import] in the SSO-H management application.
*3: When [Windows User Name] is set for [User Name Type] in [NetSpot AccountantFormat Is Selected] in [Import] in the SSO-H management application.
Back to Top