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.
...
When uploading information in a checkbox, use the value of "1" to check it and "0" (zero) to uncheck it. Note that no value (e.g. an empty cell in your spreadsheet or "") is equivalent to adding a "0". In other words, if you have a column for a field that is a checkbox and do not specify a value, the checkbox for the users in question will be unchecked as a result of the upload.
If the value for the checkbox is anything other than 0, 1 or a space, the system will store the value in the database but visually will render the checkbox as unchecked.
Field Type: Date/time
When uploading to a Date/Time custom user field, the date format must be YYYY-MM-DD. For example, to show a date of September 1, 2017, the date must be 2017-09-01. If you are specifying the time, the convention is 'YYYY-MM-DD-HH-MM-SS' using the 24-hour time format. Note however that if the field itself is not configured to accept the time (e.g. it only accepts the date), then the HH-MM-SS portion of the value will be ignored.
...
- 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.
...