Import Utility - Revision history

Admin at 15:52, 6 May 2026

2026-05-06T15:52:19Z

Admin: /* See Also */

2026-05-06T15:46:08Z

Admin2 at 15:34, 25 July 2024

2024-07-25T15:34:32Z

Admin2 at 15:34, 25 July 2024

2024-07-25T15:34:06Z

Admin at 15:13, 25 July 2024

2024-07-25T15:13:10Z

Admin2 at 20:17, 14 July 2014

2014-07-14T20:17:13Z

Admin2 at 20:16, 14 July 2014

2014-07-14T20:16:59Z

Editor1: New page: User, roster, course and other data can be imported into Enterprise Edition. The [http://www.rcampus.com/ Personal Edition] does not provide this feature...

2011-08-03T22:25:44Z

New page: User, roster, course and other data can be imported into Enterprise Edition. The [http://www.rcampus.com/ Personal Edition] does not provide this feature...

New page

User, roster, course and other data can be imported into [[RCampus - Enterprise Edition|Enterprise Edition]]. The [http://www.rcampus.com/ Personal Edition] does not provide this feature.

Note: Enterprise Edition administrators, please contact us for the import format.

← Older revision		Revision as of 15:52, 6 May 2026
Line 1:		Line 1:
	The import utility helps with integration or manually importing users, courses and classes, enrollments, demographics, programs, etc. Available in [[RCampus - Enterprise Edition\|Enterprise Edition]] only.		The import utility helps with integration or manually importing users, courses and classes, enrollments, demographics, programs, etc. Available in [[RCampus - Enterprise Edition\|Enterprise Edition]] only.

		+	= 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 <code>user.csv</code> begins with the literal word <code>user</code>:
		+
		+	<pre>
		+	user,"K9999999","mattiep","","Melinda","Legette","","2","1"
		+	user,"K9998888","jdoe","","John","Doe","","2","1"
		+	</pre>
		+
		+	And every row in <code>property.csv</code> begins with <code>Property</code>:
		+
		+	<pre>
		+	Property,RACE,Race,BL,"Black or African American"
		+	Property,RACE,Race,WH,"White"
		+	</pre>
		+
		+	The record type identifiers for each file are:
		+
		+	{\| class="wikitable"
		+	! File !! Record Type Identifier
		+	\|-
		+	\| <code>user.csv</code> \|\| <code>user</code>
		+	\|-
		+	\| <code>property.csv</code> \|\| <code>Property</code>
		+	\|-
		+	\| <code>propertyuserbyid.csv</code> \|\| <code>propertyuserbyId</code>
		+	\|-
		+	\| <code>program.csv</code> \|\| <code>program</code>
		+	\|-
		+	\| <code>programuser.csv</code> \|\| <code>programuser</code>
		+	\|}
		+
		+	== Import Files Summary ==
		+
		+	Data is organized across five files, each serving a distinct purpose:
		+
		+	{\| class="wikitable"
		+	! File !! Purpose !! Typical Frequency
		+	\|-
		+	\| <code>[[Importing Users\|user.csv]]</code> \|\| Creates or updates student and staff accounts \|\| Daily
		+	\|-
		+	\| <code>[[Importing Properties and Demographics\|property.csv]]</code> \|\| Defines valid demographic lookup values (e.g. race, residency, level) \|\| Monthly or semi-annually
		+	\|-
		+	\| <code>[[Importing Properties and Demographics\|propertyuserbyid.csv]]</code> \|\| Assigns demographic attributes to individual students \|\| Daily
		+	\|-
		+	\| <code>[[Importing Programs and Degrees\|program.csv]]</code> \|\| Defines academic programs \|\| Monthly or semi-annually
		+	\|-
		+	\| <code>[[Importing Programs and Degrees\|programuser.csv]]</code> \|\| Assigns students to programs \|\| Daily
		+	\|}
		+
		+	Note that <code>property.csv</code> and <code>program.csv</code> 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 <code>property.csv</code> before they can be assigned via <code>propertyuserbyid.csv</code>.
		+	* Program values must be defined in <code>program.csv</code> before they can be assigned via <code>programuser.csv</code>.

	==Accessing the Import Utility==		==Accessing the Import Utility==

← Older revision		Revision as of 15:46, 6 May 2026
Line 10:		Line 10:

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

← Older revision		Revision as of 15:34, 25 July 2024
Line 11:		Line 11:
	==See Also==		==See Also==
	*{{Admin see also}}		*{{Admin see also}}
−	*[[RCampus - Enterprise Edition]]
−	*[[RCampus - Personal Edition]]

@@ Line 1: / Line 1: @@
 The import utility helps with integration or manually importing users, courses and classes, enrollments, demographics, programs, etc. Available in [[RCampus - Enterprise Edition|Enterprise Edition]] only.
 ==Accessing the Import Utility==
 #Login as an admin
-#Select '''more…'''> '''manage''' > '''admin workspace'''
+#Select '''more…''' > '''manage''' > '''admin workspace'''
 #Select '''Import CSV'''
 #Follow the instructions for import types and format
 ==See Also==

@@ Line 1: / Line 1: @@
-User, roster, course and other data can be imported into [[RCampus - Enterprise Edition|Enterprise Edition]]. The [http://www.rcampus.com/  Personal Edition]  does not come with this feature.
+The import utility helps with integration or manually importing users, courses and classes, enrollments, demographics, programs, etc. Available in [[RCampus - Enterprise Edition|Enterprise Edition]] only.
 ==See Also==
 *[[RCampus - Enterprise Edition]]
 *[[RCampus - Personal Edition]]

← Older revision		Revision as of 20:16, 14 July 2014
Line 1:		Line 1:
−	User, roster, course and other data can be imported into [[RCampus - Enterprise Edition\|Enterprise Edition]]. The [http://www.rcampus.com/ Personal Edition] does not ~~provide~~ this feature.	+	User, roster, course and other data can be imported into [[RCampus - Enterprise Edition\|Enterprise Edition]]. The [http://www.rcampus.com/ Personal Edition] does not come with this feature.

−	Note: Enterprise Edition administrators, please contact us for the import format.	+
		+	'''Note''': Enterprise Edition administrators, please contact us for the import format.
		+
		+
		+	==See Also==
		+	[[RCampus - Enterprise Edition]]
		+	[[RCampus - Personal Edition]]