Import Utility - Revision history

Admin2 at 18:55, 9 October 2026

2026-10-09T18:55:20Z

← Older revision		Revision as of 18:55, 9 October 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 =		= 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.		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 ==		== Import Methods ==
Line 14:		Line 16:
	; Manual Upload		; 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.		: 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 ==		== How Import Files Are Structured ==
Line 24:		Line 27:
	* '''UTF-8 encoding, comma-delimited.'''		* '''UTF-8 encoding, comma-delimited.'''
	* '''Values enclosed in double quotes where applicable.'''		* '''Values enclosed in double quotes where applicable.'''


	=== The Record Type Identifier ===		=== The Record Type Identifier ===
Line 58:		Line 62:
	\| <code>programuser.csv</code> \|\| <code>programuser</code>		\| <code>programuser.csv</code> \|\| <code>programuser</code>
	\|}		\|}


	== Import Files Summary ==		== Import Files Summary ==
Line 78:		Line 83:

	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.		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 ==		== Data Matching and Updates ==
Line 86:		Line 92:
	* Demographic property values must be defined in <code>property.csv</code> before they can be assigned via <code>propertyuserbyid.csv</code>.		* 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>.		* 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==

Admin at 15:52, 6 May 2026

2026-05-06T15:52:19Z

← 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==

Admin: /* See Also */

2026-05-06T15:46:08Z

Admin2 at 15:34, 25 July 2024

2024-07-25T15:34:32Z

← 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]]

Admin2 at 15:34, 25 July 2024

2024-07-25T15:34:06Z

← Older revision		Revision as of 15:34, 25 July 2024
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.


	==Accessing the Import Utility==		==Accessing the Import Utility==
	#Login as an admin		#Login as an admin
	#Select '''more…'''> '''manage''' > '''admin workspace'''		#Select '''more…''' > '''manage''' > '''admin workspace'''
	#Select '''Import CSV'''		#Select '''Import CSV'''
	#Follow the instructions for import types and format		#Follow the instructions for import types and format


	==See Also==		==See Also==

Admin at 15:13, 25 July 2024

2024-07-25T15:13:10Z

← Older revision		Revision as of 15:13, 25 July 2024
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.


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

			==Accessing the Import Utility==
			#Login as an admin
			#Select '''more…'''> '''manage''' > '''admin workspace'''
			#Select '''Import CSV'''
			#Follow the instructions for import types and format

	==See Also==		==See Also==
			*{{Admin see also}}
	*[[RCampus - Enterprise Edition]]		*[[RCampus - Enterprise Edition]]
	*[[RCampus - Personal Edition]]		*[[RCampus - Personal Edition]]

Admin2 at 20:17, 14 July 2014

2014-07-14T20:17:13Z

← Older revision		Revision as of 20:17, 14 July 2014
Line 6:		Line 6:

	==See Also==		==See Also==
	[[RCampus - Enterprise Edition]]		*[[RCampus - Enterprise Edition]]
	[[RCampus - Personal Edition]]		*[[RCampus - Personal Edition]]

Admin2 at 20:16, 14 July 2014

2014-07-14T20:16:59Z

← 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]]

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:46, 6 May 2026
Line 10:		Line 10:

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