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 & Specification for student data and class schedule data specifications.

 

Requirements

  • Windows 8/10 or Server 2012+

  • RapIDutilities v2.0.2.205 or greater

  • A PerfectPass user account (we recommend a locked account)

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

In the Data File Mapping screen the PerfectPass Tables droplist let’s you enable or disable the schedule destination table.

Want to upload schedule data? Leave schedule enabled.

Don’t want to upload schedules? Disable the schedule table.

  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

Photos are optional.
Student photos must be in JPG format and titled by IDNUMBER.jpg, or the import file must have a PHOTO field that references the photo filename.

  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

Filter by label

There are no items with the selected labels at this time.

Questions? Contact us at support@visiondatabase.com