Importing Users

Importing Users

The user.csv file creates or updates user accounts in RCampus. Each row represents one user. This file is typically uploaded daily as part of the Panda SFTP Integration or provided manually through the RCampus administrative interface.

For a general explanation of how RCampus import files are structured, see Importing Data to RCampus.

File: user.csv

Record Format

Each row contains 9 comma-separated fields:

user,"{UserID}","{Username}","{Password}","{FirstName}","{LastName}","{Email}","{UserType}","{UserStatus}"

Example

user,"K9999999","mattiep","","Melinda","Legette","","2","1"

Field Reference

Position	Field	Description	Notes
1	Record type	Literal value: user	Hardcoded; same on every row
2	UserID	Unique student identifier	Must match an ID from students.csv (automated) or existing RCampus records (manual)
3	Username	Institutional login username	May be blank
4	Password	Account password	Typically blank ("") unless your process requires it
5	FirstName	Student's first name
6	LastName	Student's last name
7	Email	Student's email address	May be blank
8	UserType	Coded value identifying the account type	See UserType Codes below
9	UserStatus	Coded value identifying the account status	See UserStatus Codes below

UserType Codes

Code	Meaning
0	Unknown / invalid
1	Employee (faculty, staff, or advisor)
2	Student

UserStatus Codes

Code	Meaning
0	Unknown
1	Active (AS)
2	Inactive (IS)
3	Inactive Graduate (IG)
10	Faculty / staff / advisor — records with this status are skipped during student demographic imports

Key Points

• One row per user.
• The UserID must match a student ID provided by RCampus (for automated imports) or an existing record (for manual imports). Records with unrecognized IDs will not be processed.
• Sending a row for an existing UserID updates that user's record. Sending a row for a new UserID creates a new account.
• Fields that are not required for your institution may be left blank using empty double quotes ("").

See Also

• Import Utility
• Importing Users
• Importing Properties and Demographics
• Importing Programs and Degrees
• Panda SFTP Integration