When uploading users, either via the manual method or the automated method, the first step is to create your CSV file. Below are some instructions and guidelines to help you create your CSV file.
| Table of Contents | ||||
|---|---|---|---|---|
|
General Guidelines
The following general guidelines are true regardless of what actions you're trying to accomplish with user uploads:
- The CSV file has fields separated by a comma (or other delimiter) ONLY - no space. The first line contains the valid field names. The rest of the lines (records) contain information about each user.
- Be careful with special characters in field information like quotes or other commas. Commas must be escaped. Rules and examples about how quotation marks are handled are discussed later in this document.
- Test a CSV file with only one record before a uploading a larger file.
- You can use a spreadsheet program such as Microsoft Excel to create the file with the required columns and fields, and then save the file as "CSV (comma delimited)". These files can be opened with simple text editors for verification.
Sample File
Here is a sample file that is valid for uploading users. You can either copy / paste it in your favorite CSV editor or download it here:
...
- For the System Administrator role, use "manager" (without the quotes)
- For the System Coordinator rule, use "coordinator"
- For the Supervisor role, use "supervisor"
- For the Course Creator role, use "coursecreator"
sysrole1,sysrole2,sysrole3
...
The role can be "student", "editingteacher" or "teacher". The enrolment duration must be in days.
...