Import Users From a CSV File¶
The characters in the file must be in ANSI format. File extension must be: csv
Header record¶
Fieldname |
Data type |
Description |
Record type |
String (1) |
Must have the value ”H”. |
Users |
Integer |
The number of users in the file. |
Encrypted passwords |
String(1) |
If field value is “N” user fields are encrypted before they are saved. Otherwise the password is interpreted as encrypted with the SHA-256 algorithm. |
Custom fields |
Integer |
Number of custom fields. |
Custom fields |
String |
List and order of appearance of custom fields in the user records. |
User record¶
Fieldname |
Data type |
Description |
Record type |
String (1) |
Must have the value “U”. |
User ID |
String (10) |
Unique login. Might be initials, a number etc. |
Password |
String (100) |
The user’s password. Value can be omitted. |
Name |
String (50) |
The first name of the user. |
Last name |
String (50) |
Last name of the user. |
Active date |
Date time |
The date and time the user is activated. Format is DD-MM-YYYY HH:MM: SS. Value can be omitted. |
Deactivate date |
Date time |
The date and time the user is deactivated. Format is DD-MM-YYYY HH:MM: SS. Value can be omitted. |
Active |
Integer |
Is the user active? Y=Yes, no otherwise. |
Calendar identification |
String(50) |
Identification of user in calendar system. Most commonly the user’s email address is used. |
Custom fields |
The custom fields in the order stated in the header record. Values can be omitted. |
User details¶
Fieldname |
Data type |
Description |
Record type |
String (1) |
Must have the value “D”. |
Communication type |
Integer |
Type of detail. Possible values are: 2: Local phone 3: Work phone 4: Home phone 5: Mobile phone 6: Fax 7: Mail 8: Web |
Default |
Is the communication item default for the type? N=No, Y=Yes. Mutual exclusive within types. |
|
Enabled |
N=No, Y=Yes. |
|
Value |
Value. E.g. phone number, mail address etc. (depends on the communication type field) |
Remarks¶
To make sure that the imported file has the right format, it will be checked thoroughly. If it has the right format, it will be imported, otherwise it will be rejected. Since custom fields can have predefined values, values for these fields will be validated. If values are invalid, the file will not be imported. If more than one user detail of a certain type in the file is set to be default, the last imported detail will be set to default.
File example¶
"H","4","Y","4","ADDRESS 1","ADDRESS 2","DIVISION","COUNTRY"
"U","454","","Dan","Poulsen","03-05-2006","","0","","Vestergade 8","","Sales","Faroe Islands"
"U","543","","Hans","Joensen","21-07-2006","","0","","Østergade 34","","Prod","Faroe Islands"
"D","5","Y","Y","217103"
"U","434","","Aksel","Hansen","01-06-2006","","0","","Nordgade 7","","Prod","Faroe Islands"
"D","5","Y","Y","255394"
"U","446","","Angela","Olsen","03-05-2006","","0","","Sydgade 11","","Prod","Faroe Islands"
"D","4","Y","Y","319110"
"D","5","Y","Y","256250"