ProgressBook ATT2SIS Import File

In the following example we will use RapIDutilities to create a data export from PerfectPass for a fictitious customer named Vision High School in the ProgressBook ATT2SIS Import format.

Overview

1. Install RapIDutilities v.2.0.0.195 or greater

2. Create a new PerfectPass Import map using the below reference guide then apply special FORMAT_DT text functions to the creationTime fields

3. Set a file output destination then run the map to produce the export file

Create a new map

1. Open RapIDutilities

2. Go to the PerfectPass Export tab

3. Click New

ATT2SIS Map Setup

1. Enter a unique Map Name

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

3. Click OK on the Login Success prompt
   

   

4. Open the Data File Mapping tab

5. Choose an Output File destination

6. Select Student Incident from the PerfectPass API droplist

7. Disable Column Names in Header

8. Add 5 columns and set the Text/Function

   1. Add student.IDnumber

   2. Add creationTime - set the Text/Function to FORMAT_DT(yyyyMMdd)

   3. click Add Static Column - blank out the Text/Function

   4. Add creationTime - set Text/Function to FORMAT_DT(hh:mm tt)

   5. Add creationTime - set Text/Function to FORMAT_DT(''t)
      

      

      

9. Click Preview to see output similar to the following. Note that you may not have any incident data to export at the time the ATT2SIS map is created.
   

   

10. Click Save

Related articles