Import Student Data & Photos

In the following example we will use RapIDutilities to import student data and photos for a fictitious customer named Vision High School.

Refer to Student Data Overview for student data and class schedule data specifications.

Overview

1. Install RapIDutilities v.2.0.0.196 or greater

2. Create a new PerfectPass Import map

3. Choose the import file and photo folder then run the map to upload the student data to PerfectPass

Create a new map

1. Open RapIDutilities

2. Go to the PerfectPass Import tab

3. Click New

Import Map Setup

PerfectPass Credentials

1. Enter a unique Map Name

2. Enter a PerfectPass username and password, then click Apply

3. Click OK on the Login Success prompt
   

   

Data File Mapping

1. Select an Import File then choose the appropriate delimiter and if there are column names in the import file

2. Click Set Columns/Preview to make sure the import data is recognized by RapIDutilities
   

   

3. In the PerfectPass Tables droplist, DESELECT schedule if you do not want to upload class schedules.
   

   

4. Select an Import Field and the related PerfectPass Field, then click right arrow to add it to Mapped Fields
   Note: BLUE fields signify the field is required
   

   

5. Map all necessary fields
   Note: You can map custom fields - add the custom field to PerfectPass first.

6. Proceed to the Photos tab
   

Photos

1. Enable the Include Photos button

2. Point to the Photos Source Directory

3. Select the ID Number field from the droplist

4. Enable Photos are IDnum.jpg if necessary, or choose an appropriate Photos Field
   

   

5. Click Save

Photos Options

Log missing photos - Write missing photo references to the RapIDutilities log.

Enable Delta Upload - This option will only include photos modified in the last HOURS for upload to PerfectPass. This is to keep the student data upload package size to a minimum and increase processing speed both server and client side.

Hours - RapIDutilities uses the File Modified Date to determine if a photo is new or recently changed. e.g. 24 hours means that RapIDutilities will upload any photos with a modified date within the last 24 hours of the map run time.

Run the map

Select the map then click Run Now from the ribbon menu.

The PerfectPass import map be automated using the Command Line Operator button to create a batch file. Schedule the batch file to run daily using using Windows Task Scheduler.

Related articles