Import Utility
The import utility helps with integration or manually importing users, courses and classes, enrollments, demographics, programs, etc. Available in Enterprise Edition only.
Contents
Importing Data to RCampus
RCampus supports importing student, demographic, and program data from an institution's Student Information System (SIS). This allows assessment results to be analyzed and reported by student characteristics and academic program.
Import Methods
Data can be delivered to RCampus in two ways:
- Automated (Panda SFTP Integration)
- Files are exchanged on a scheduled basis between the institution's SIS and RCampus over a secure SFTP connection. RCampus publishes a list of students it expects data for, and the institution responds with the appropriate files. See Panda SFTP Integration for connection and scheduling details.
- Manual Upload
- CSV files can be uploaded directly through the RCampus administrative interface. The same file formats and field rules apply regardless of delivery method.
How Import Files Are Structured
All RCampus import files are plain CSV (comma-separated values) files. They share a consistent structure across all file types:
- No header row — the first line is always a data record.
- Record type identifier in the first field — every row begins with a literal keyword that tells RCampus what kind of record it is. This keyword is the same on every row within a given file.
- One record per line.
- UTF-8 encoding, comma-delimited.
- Values enclosed in double quotes where applicable.
The Record Type Identifier
The first field on every row is a hardcoded label identifying the record type. This means each row is self-describing — RCampus knows how to process it from the row itself, independent of the filename or any header.
For example, every row in user.csv begins with the literal word user:
user,"K9999999","mattiep","","Melinda","Legette","","2","1" user,"K9998888","jdoe","","John","Doe","","2","1"
And every row in property.csv begins with Property:
Property,RACE,Race,BL,"Black or African American" Property,RACE,Race,WH,"White"
The record type identifiers for each file are:
| File | Record Type Identifier |
|---|---|
user.csv |
user
|
property.csv |
Property
|
propertyuserbyid.csv |
propertyuserbyId
|
program.csv |
program
|
programuser.csv |
programuser
|
Import Files Summary
Data is organized across five files, each serving a distinct purpose:
| File | Purpose | Typical Frequency |
|---|---|---|
user.csv |
Creates or updates student and staff accounts | Daily |
property.csv |
Defines valid demographic lookup values (e.g. race, residency, level) | Monthly or semi-annually |
propertyuserbyid.csv |
Assigns demographic attributes to individual students | Daily |
program.csv |
Defines academic programs | Monthly or semi-annually |
programuser.csv |
Assigns students to programs | Daily |
Note that property.csv and program.csv define lookup values that must exist before they can be referenced in the assignment files. These definition files are uploaded less frequently since the underlying data changes infrequently.
Data Matching and Updates
- Student IDs must exactly match those on record in RCampus.
- Re-sending a record for an existing student updates that student's data.
- Sending a record for a new ID creates a new account.
- Demographic property values must be defined in
property.csvbefore they can be assigned viapropertyuserbyid.csv. - Program values must be defined in
program.csvbefore they can be assigned viaprogramuser.csv.
Accessing the Import Utility
- Login as an admin
- Select more… > manage > admin workspace
- Select Import CSV
- Follow the instructions for import types and format
