PerfectPass Data Overview & Specification

Student information including person data, class schedule, and photo can be imported into PerfectPass using the RapIDutilities import/export utility or the Data Management tool.

See Data Import & Export for a walkthrough showing how to use RapIDutilities to import / export PerfectPass data.

Data Requirements

File Format Information

  • CSV, TAB, PIPE data file only

  • Column names are option

  • 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.

 

This table details the default PerfectPass student data fields.

Custom data fields can be added by accessing Students > Manage > Edit Custom Fields.

Field Name

Description

Type

Required

Field Name

Description

Type

Required

StudentID

Student ID is used to lookup student records manually or when scanning an ID card.

String

Yes

FirstName

Student first name

String

Yes

LastName

Student last name

String

Yes

MiddleName

Student middle name

String

-

Grade

Student grade level

String

-

Address1

Student home address 1

String

-

City

Student home city

String

-

State

Student home state

String

-

Zip

Student home zip

String

-

Phone

Student phone number

String

-

Email

Student home email

String

-

Birthdate

Student birthdate

String

-

Gender

Student Gender

String

-

 

Student Class Schedule Data Specifications

Class schedules are optional. However, to import class schedules the student data fields must also be included.

This table details the PerfectPass class schedule data fields.

Field Name

Description

Type

Required

Field Name

Description

Type

Required

Period

Class period

String

Yes

TeacherFull

Teacher's name

String

Yes

ClassID

Class ID

String

Yes

ClassName

Class description

String

Yes

Location

Class location

String

Yes

 

Example Import

The sample Import.csv contains all required fields for student data with class schedules.

Student Data

Student Data + Class Schedule Data

Student Data

Student Data + Class Schedule Data

StudentID
FirstName
LastName

  • StudentID

  • FirstName

  • LastName

  • Period

  • ClassID

  • ClassName

  • TeacherFull

  • Location

Sample Import.csv

 

Student Photo Requirements

  • JPG format only

Â