Admin at 22:50, 6 May 2026

2026-05-06T22:50:05Z

Admin: Created page with "= Importing Programs and Degrees = Academic program data in RCampus is managed through two files that work together: * `program.csv` — defines the academic prog..."

2026-05-06T16:06:19Z

Created page with "= Importing Programs and Degrees = Academic program data in RCampus is managed through two files that work together: * <code>program.csv</code> — defines the academic prog..."

New page

= Importing Programs and Degrees =

Academic program data in RCampus is managed through two files that work together:

* <code>program.csv</code> — defines the academic programs available in RCampus.
* <code>programuser.csv</code> — assigns students to those programs.

'''Important:''' Programs must be defined in <code>program.csv</code> before students can be assigned to them in <code>programuser.csv</code>. Upload <code>program.csv</code> 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 <code>programuser.csv</code> references.

This file changes infrequently and is typically uploaded monthly or semi-annually rather than daily.

=== Record Format ===

Each row contains 5 fields:

<pre>
program,{ProgramID},{ProgramCode},{ProgramTitle},{ProgramDesc}
</pre>

=== Example ===

<pre>
program,"3UAS196ABS","ABS","Associate of Applied Science - Business","Business degree program"
</pre>

=== Field Reference ===

{| class="wikitable"
! Position !! Field !! Description !! Notes
|-
| 1 || Record type || Literal value: <code>program</code> || Hardcoded; same on every row
|-
| 2 || ProgramID || Unique program identifier || This is the value referenced in <code>programuser.csv</code>
|-
| 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 <code>programuser.csv</code>.
* 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:

<pre>
programuser,{ProgramId},{UserId}
</pre>

=== Example ===

<pre>
programuser,"3UAS196ABS","S927342"
programuser,"3UAS196ABS","S927343"
programuser,"4UAS220NUR","S927342"
</pre>

In the example above, student <code>S927342</code> is enrolled in two programs.

=== Field Reference ===

{| class="wikitable"
! Position !! Field !! Description !! Notes
|-
| 1 || Record type || Literal value: <code>programuser</code> || Hardcoded; same on every row
|-
| 2 || ProgramId || Program identifier || Must match a ProgramID defined in <code>program.csv</code>
|-
| 3 || UserId || Student's unique identifier || Must match a UserID in <code>user.csv</code>
|}

=== 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 <code>program.csv</code> or the record will not be processed.
* UserId must match a user already in RCampus.

==See Also==
*{{Import see also}}

@@ Line 27: / Line 27: @@
 <pre>
-program,"3UAS196ABS","ABS","Associate of Applied Science - Business","Business degree program"
+program,"AS-BUS","AS-BUS","Associate of Applied Science - Business","Business degree program"
 </pre>
@@ Line 69: / Line 69: @@
 <pre>
-programuser,"3UAS196ABS","S927342"
+programuser,"AS-BUS","S927342"
-programuser,"3UAS196ABS","S927343"
+programuser,"AS-BUS","S927343"
-programuser,"4UAS220NUR","S927342"
+programuser,"AS-ENG","S927342"
 </pre>

Importing Programs and Degrees - Revision history

Admin at 22:50, 6 May 2026

Admin: Created page with "= Importing Programs and Degrees = Academic program data in RCampus is managed through two files that work together: * program.csv — defines the academic prog..."

Admin: Created page with "= Importing Programs and Degrees = Academic program data in RCampus is managed through two files that work together: * `program.csv` — defines the academic prog..."