CourseNetworking (CN) allows you to manually bulk create users through the Admin interface.
We provided the sample CSV file for this import and also all of the required, recommended and optional fields are listed in below table. For each field data type, standard format and description can found on the same row.
CSV File Format
In order to bulk upload data into CN, you must create CSV text files. CSV files can be generated by many programs. Student Information Systems (SIS) often have a method for generating reports in CSV format that can be modified to fit the format CN requires. If you do not know how to save a file in a CSV format, please check the documentation for the program you are using to create your CSV file.
CSV Field Formatting
The first row of your CSV file (header) must include the complete Field Name (i.e. institution_id,first_name,last_name etc). Please refer to the first column of the table below. The order of the fields does not matter.
CSV Update Users
This CSV file can be used for both creating new users and updating existing users. When your institution Channel already has some members, if you upload a CSV file, we will ask if you are only creating new users or both creating new users (if there are any on the CSV file) and updating information of the existing users. If you choose the latter, please note that some existing members may have already personalized their profile information, such as gender, secondary email, primary language, bio and other information on their CN ePortfolio/Profile. If you don't want to override the user inputs, please do not include the corresponding columns on this CSV file or leave the cells blank.
Data Fields in the CSV file
The following table has five columns:
- Field Name: Indicates the exact name of each field in the header row of the CSV file
- Required: Indicates if a field is “Required”, “Recommended” or “Optional”
- Data Type: Indicates the allowed data type of the field
- Value Range: Provides different possible (valid) values for a certain field in the CSV file
- Description: Provides any additional description of the data fields such as how they are used and the applied standards.
Field Name
|
Required
|
Data Type
|
Value Range
|
Description
|
institution_id
|
Required
|
String
|
|
A unique identifier used to reference users in the enrollments table. This identifier should not be changed and must be globally unique.
|
first_name
|
Required
|
String
|
|
|
last_name
|
Required
|
String
|
|
|
primary_email
|
Required
|
String
|
Valid Email
|
should be unique for each user
|
status
|
Required
|
Enum
|
active
deleted
alumni
inactive
parent
|
This status would be matched to the status of the user in CN. The “deleted” value equals to "dropped off" in CN.
|
password
|
Optional
|
String
|
|
This field sets the password for users. This field is optional and users can create their CN Password on their own.
|
user_label
|
Optional
|
String
|
|
Institution admins need to create user labels from the Manage User Labels tab first. For adding multiple labels you would need to separate them using “|”. For example, “FirstYear|Staff” will associate two labels, “FirstYear” and “Staff” to the assigned users.
|
login_id
|
Optional
|
String
|
|
This value can be used to match the user with an external server such as LDAP or CAS as external authentication server
|
sis_id
|
Optional
|
String
|
|
A secondary unique identifier is useful for more complex SIS integrations. This identifier should not be changed and must be globally unique.
|
full_name
|
Optional
|
String
|
|
|
birth_date
|
Recommended
|
DateTime
|
e.g. YYYY-MM-DDTHH:MM:SSZ
|
CN will not display this information on the website. It will only be recorded internally for permission granting purposes. For example, younger students' ePortfolio page will not be public facing based on their institution's setting.
|
gender
|
Optional
|
Int
|
0 = not known,
1 = male,
2 = female,
9 = not applicable
|
|
creation_date
|
Optional
|
DateTime
|
e.g. YYYY-MM-DDTHH:MM:SSZ
|
|
admission_date
|
Optional
|
DateTime
|
e.g. YYYY-MM-DDTHH:MM:SSZ
|
This creation date is the date of creation for the user record on the student information system of the institution.
CN may use this data to label the start date of the certified institution logo on user ePortfolios.
|
major_minor
|
Recommended
|
String
|
|
This data will be used to fill the Major/Study Area field and to automatically generate skill tags on user ePortfolio/profile page. You can use "|" to seperate multiple terms.
|
secondary_email
|
SR
|
String
|
Valid Email
|
|
grade_level
|
Recommended
|
String
|
Description => Code
Infant/toddler => IT
Preschool => PR
Prekindergarten => PK
Transitional Kindergarten => TK
Kindergarten => KG
First grade => 01
Second grade => 02
Third grade => 03
Please go to Description
|
Complete list of codes and Description:
CN will not display this information on the website. It will only be recorded internally for permission granting purposes. For example, younger students' ePortfolio page will not be public facing based on their institution's setting
|
country
|
Recommended
|
String
|
|
Country of current residency.
This will be used to fill the Country/Region field and to display the flag on user ePortfolio/profile page.
|
state
|
Optional
|
String
|
|
This will be used to fill the State/Province field on user ePortfolio/profile page.
|
city
|
Optional
|
String
|
|
This will be used to fill the City field on user ePortfolio/profile page.
|
nationality
|
Optional
|
String
|
Country Name
|
CN will not display this information on the website. It will only be recorded internally. |
primary_language
|
Optional
|
String
|
|
This will be used to fill the Primary Language field on user ePortfolio/profile page.
|
institutional_role
|
Optional
|
String
|
Student
Faculty
Member
Instructor
Mentor
Staff
Alumni
ProspectiveStudent
Guest
Other
Administrator
Observer
Parent/Guardian
None
|
This role is basically the role of the user within the institution which is different than the role within the course.
This will be used to fill the Role/Status field on user ePortfolio/profile page.
|
mobile_phone
|
Recommended
|
String
|
Valid Phone Number
|
CN will not display this information on the website. It will only be recorded internally. |
bio
|
Optional
|
String
|
Any text without carriage return (new line, Enter)
|
This value would be shown as Introduction under the About section on user ePortfolio/profile page.
|
Comments
0 comments
Article is closed for comments.