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 iW 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 "##########"
*1
The item name (The item name in NetSpot Accountant 4.0 or later or iW 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.