About the ID Manager CSV Data File

The following table displays the CSV header names that must be used when importing data into ID Manager or IRIS BioStore via ID Gateway.

The Person ID is the primary key and should always remain the same for each unique record to prevent duplication.

IDManger Header CSV Header Description Type Accepted Values (if applicable)
Last Name LastName Person's last name Alpha 50  
First Name FirstName Person's first name Alpha 50  
Person ID $StudentID Unique ID Alpha 40  
Pin $Pin Unique PIN Alpha 20  
RFID/Mifare $Card Unique RFID/Mifare Number Alpha 50  
Access Mode Person's authentication options Alpha 10 (blank), F, C, B, P, NPW, PW, F/C, F/B, F/P, F/C/B/P, F+, PF, CP. Go to User Authentication.
Year Year Person's year group Alpha 20  
Tutor Tutor Person's tutor group Alpha 50  
Class Class Person's class Alpha 50  
Date of Birth DOB Person's date of birth Date 10  
Gender Gender Person's gender Gender 10 M, F, -
Address Address Person's address MultiLineText 255  
Course Course Person's course Alpha 50  
Phone 1 Phone1 Person's phone contact Phone 25  
Phone 2 Phone2 Person's alternative phone contact Phone 25  
Email Address Email Person's email contact Alpha 50  
Mail Title MailTitle Person's mail title Alpha 50  
Hint Hint Authentication option - hint Alpha 20  
User Name $UserName Authentication option - username Alpha 50  
Password Password Authentication option - password Alpha 20  
Barcode $Barcode Authentication option - barcode Alpha 50  
Comment Comment Comment for the person Alpha 255  
Free Meals FreeMeals Free meals status YesNo Yes, No
User Type UserType Type of user in IDManager Alpha 20 Student, Staff, Site Staff, Visitor, Contractor, Governor, Test
Preferred First PreferredName Person's preferred first name Alpha 50  
Postcode PostCode Person's postcode Alpha 20  
Meals Expire FreeMealsDate When free meals expire Date 10  
Middle Names MiddleNames Person's middle name Alpha 50  
Title Title Person's title Alpha 20  
Admission Num $Admission Person's admission number Alpha 40  
UPN $UPN Person's UPN Alpha 40  
Preferred Last PreferredLastName Person's preferred last name Alpha 50  
Mag-Stripe $Card2 Authentication option - Mag-Stripe Alpha 50  
AD User Name (CN) ADUserName Person's AD User Name (CN) Alpha 50  
AD Logon Name $ADLogonName Person's AD Logon Name Alpha 50  
AD DN $ADDN Person's AD DN Alpha 255  
Card Print Date CardDate Person's last printed card date Date 10  
Card Issue CardIssue Increments from 1 each time a new card is issued Alpha 10  
Card Expire Date CardExpireDate Date that the person's card will expire Date 10  
Home Email HomeEmail Person's home contact email Alpha 50  
Work Email WorkEmail Person's work contact email Alpha 50  
Permission Permission Person's parental permission status Alpha 10 None, Parental, Self
CRB Number $CRBNumber Person's CRB number Alpha 50  
Job Title JobTitle Person's job title Alpha 50  
Key Stage KeyStage Person's key stage Alpha 10 (blank), KS0, KS1, KS2, KS3, KS4, KS5
Finger Match FPRS Person's finger quality requirement Alpha 10 (blank), 25, 50, 75, 100
DXGUID $DXGUID Person's DXGUID Alpha 40  
Staff Contact Email StaffEmail Staff contact email for the person Alpha 50  
Legal Last LegalLastName Person's legal last name Alpha 50  
PP Date PPDate Date that parental permission was granted Date 10