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"

 

Last edited on October 30th, 2017