Admin: Created page with "= 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..."

2026-05-06T15:57:13Z

Created page with "= Importing Users = The <code>user.csv</code> file creates or updates user accounts in RCampus. Each row represents one user. This file is typically uploaded daily as part of..."

New page

= Importing Users =

The <code>user.csv</code> 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:

<pre>
user,"{UserID}","{Username}","{Password}","{FirstName}","{LastName}","{Email}","{UserType}","{UserStatus}"
</pre>

=== Example ===

<pre>
user,"K9999999","mattiep","","Melinda","Legette","","2","1"
</pre>

=== Field Reference ===

{| class="wikitable"
! Position !! Field !! Description !! Notes
|-
| 1 || Record type || Literal value: <code>user</code> || Hardcoded; same on every row
|-
| 2 || UserID || Unique student identifier || Must match an ID from <code>students.csv</code> (automated) or existing RCampus records (manual)
|-
| 3 || Username || Institutional login username || May be blank
|-
| 4 || Password || Account password || Typically blank (<code>""</code>) 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|UserType Codes]] below
|-
| 9 || UserStatus || Coded value identifying the account status || See [[#UserStatus Codes|UserStatus Codes]] below
|}

=== UserType Codes ===

{| class="wikitable"
! Code !! Meaning
|-
| <code>0</code> || Unknown / invalid
|-
| <code>1</code> || Employee (faculty, staff, or advisor)
|-
| <code>2</code> || Student
|}

=== UserStatus Codes ===

{| class="wikitable"
! Code !! Meaning
|-
| <code>0</code> || Unknown
|-
| <code>1</code> || Active (AS)
|-
| <code>2</code> || Inactive (IS)
|-
| <code>3</code> || Inactive Graduate (IG)
|-
| <code>10</code> || 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 (<code>""</code>).

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

Importing Users - Revision history

Admin: Created page with "= 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..."

Admin: Created page with "= 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..."