Importing Programs and Degrees
Contents
Importing Programs and Degrees
Academic program data in RCampus is managed through two files that work together:
program.csv— defines the academic programs available in RCampus.programuser.csv— assigns students to those programs.
Important: Programs must be defined in program.csv before students can be assigned to them in programuser.csv. Upload program.csv first if you are introducing new programs.
For a general explanation of how RCampus import files are structured, see Importing Data to RCampus.
File 1: program.csv
This file defines the academic programs (degrees, certificates, majors, etc.) that exist in RCampus. It serves as the master list that programuser.csv references.
This file changes infrequently and is typically uploaded monthly or semi-annually rather than daily.
Record Format
Each row contains 5 fields:
program,{ProgramID},{ProgramCode},{ProgramTitle},{ProgramDesc}
Example
program,"3UAS196ABS","ABS","Associate of Applied Science - Business","Business degree program"
Field Reference
| Position | Field | Description | Notes |
|---|---|---|---|
| 1 | Record type | Literal value: program |
Hardcoded; same on every row |
| 2 | ProgramID | Unique program identifier | This is the value referenced in programuser.csv
|
| 3 | ProgramCode | Institutional program code | Short code used by the SIS |
| 4 | ProgramTitle | Program name | Human-readable program title |
| 5 | ProgramDesc | Program description | Additional description; may be the same as ProgramTitle |
Key Points
- One row per program.
- The ProgramID is what you will reference when enrolling students via
programuser.csv. - This file only defines programs. It does not enroll any students.
File 2: programuser.csv
This file assigns students to academic programs. Each row represents a single student-to-program membership. A student enrolled in more than one program will appear on multiple rows.
This file is typically uploaded daily.
Record Format
Each row contains 3 fields:
programuser,{ProgramId},{UserId}
Example
programuser,"3UAS196ABS","S927342" programuser,"3UAS196ABS","S927343" programuser,"4UAS220NUR","S927342"
In the example above, student S927342 is enrolled in two programs.
Field Reference
| Position | Field | Description | Notes |
|---|---|---|---|
| 1 | Record type | Literal value: programuser |
Hardcoded; same on every row |
| 2 | ProgramId | Program identifier | Must match a ProgramID defined in program.csv
|
| 3 | UserId | Student's unique identifier | Must match a UserID in user.csv
|
Key Points
- One row per student-program membership.
- A student enrolled in multiple programs will appear on one row per program.
- ProgramId must already exist in
program.csvor the record will not be processed. - UserId must match a user already in RCampus.
