Student information including person data, class schedule and photo can be imported into PerfectPass using the RapIDutilities data import utility.


Class schedules and photos are optional. However, to import class schedules or photos all required student data fields must also be present in the Perfectpass import file.


File Format Information

  • Comma separated value (CSV) data file only
  • Column name is required (no spaces)
  • Column name does not need to match the labels provided below
  • Student Data only - One row per student
  • Student Data + Class Schedule – one row per student for each class


Student Data Specifications

Student record data is mandatory.


The table details the PerfectPass student data fields.


Field Name
Description
Type
Required
StudentID
Student ID is used to lookup student records manually or when scanning an ID card.
String
Required
FirstName
Student first name
String
Required
LastName
Student last name
String
Required
MiddleName
Student middle name
String
Optional
Grade
Student grade level
String
Optional
Address1
Student home address 1
String
Optional
City
Student home city
String
Optional
State
Student home state
String
Optional
Zip
Student home zip
String
Optional
Phone
Student phone number
String
Optional
Email
Student home email
String
Optional
Birthdate
Student birthdate
String
Optional
Gender
Student Gender
String
Optional




Student Class Schedule Data Specifications

Class schedules are optional. However, to import class schedules you must include the required fields for student data.


The table details the PerfectPass class schedule data fields. 


Field Name
Description
Type
Required
Period
Class period
String
Required
TeacherFull
Teacher's name
String
Required
ClassID
Class ID
String
Required
ClassName
Class description
String
Required
Location
Class location
String
Required



Example Import

Required fields for student data, or student data with class schedules.

Student Data

Student Data + Class Schedule Data
StudentID
FirstName
LastName
  • StudentID
  • FirstName
  • LastName
  • Period
  • TeacherFull
  • ClassID



Sample Import.csv


Student Photo Requirements

  • JPG format only
  • The photo file must be named using the STUDENTID.jpg naming convention. For example – 10010.jpg or 20020.jpg
  • Photo resolution – no greater than 500 x 500
  • File size – no greater than 100 kb


10010.jpg (300 x 330)

20020.jpg (300 x 330)