Import Users From NUF File

The characters in the file must be in ANSI format. The first record is a header record (required). The succeeding records are zero to many user records with zero to many detail records.

Structure example

Header record
    User Record (Person A)
        Detail Record (A local phone)
        Detail Record (A’s mobile phone)
        Detail Record (A’s email address)
    User Record (Person B – has no details)
    User Record (Person C)
        Detail Record (C’s local phone)

File extension: nuf

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	Datetime	The date and time the user is activated. Format is DD-MM-YYYY HH:MM:SS. Value can be omitted.
Deactivate date	Datetime	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"