Creation Imports vs. Update Imports
- Affiliations
-
- "Affiliation Indexes" column
- Learners
-
- "Username" column
- Instructors
-
- "Username" column
- Courses
-
- "Course" column (this is the Course Index in Genius+ after creation)
- Sections
-
- "Section" column (this is the Section Index in Genius+ after creation)
- Enrollments
-
- "Username" AND "SectionIndex" columns
-
-
- Username will be the username of the related user whose enrollments you are trying to update.
- SectionIndex will be the section index in Genius of the related section to the enrollment.
-
CSV Import Guide:
Administration > Operations > Import CSV is the best place to execute CSV imports in Genius+.
- Select the type of CSV you want to import and click preview or upload.
- Upload will push the changes into your system immediately.
- Preview will give you a snapshot of what the data you are importing would look like.
As a best practice, save your CSV files as "CSV UTF-8" files. This will ensure that special letters and characters in your spreadsheets are maintained in the import.
**Reminders**
- Sections = Course offerings made from a course template.
- Course = Template of course.
- Learners = Anyone who registers for a course.
- Affiliations = Like departments or organizations, this is a way of creating a different experience on the site for different groups of users.
- Enrollments = The association between a learner and the section they sign up for.
- External Course = a record of a course taken outside of the current organization used for credit. This is usually designed for prerequisite and transcript purposes.
Below is a guide for each CSV import and the formatting for the values that can be entered for each column. It is a best practice that for the INITIAL imports, users follow the CSV imports in the order we have them presented below. That way, if there are items Genius+ has to generate for you (like an ID), they will be available in the system once you are ready to populate those fields.
Examples are provided in purple italics.
KEY for column indicators (must be removed before uploading)
R= Required
NR= Not Required
Affiliations
| Name (R) | Status (R) | Notes (NR) | Parent (NR) | Competencies (NR) | Certificate (NR) | Theme (NR) | BBStudentRoles (NR) | BBTeacherRoles (NR) | SupportEmail (NR) | SupportPhone (NR) | SupportUrl (NR) |
AffiliationIndex (NR) |
|
This is the actual name of the affiliation. Affiliation100 |
ACTIVE or ARCHIVED |
Notes for staff users. Affiliation100 is for internal employees only - System Admin. |
This can be used to create a hierarchy style affiliation. Adding an existing affiliiation name here will make this entry the "child" of it. Affiliation99 |
If there are competencies that exist in your Genius+ instance, you can list them by name here. They must be separated through delineation. Competency1 | Competency2 |
The name of the certificate all members of the affiliation will receive when completing a course or section. AffiliationCertificate |
Affiliations can have their own specific themes made in System Setup. The name of the Theme you created would go here. Theme100 |
Blackboard Learn and Learn Ultra users only. For organizations that use custom roles to be converted to existing roles in the LMS. CustomRole100 |
Blackboard Learn and Learn Ultra users only. For organizations that use custom roles to be converted to existing roles in the LMS. CustomRole200 |
Email domain to be used to override the global value put into Administration > Parameters > SUPPORT_EMAIL. catsupport@cat.com |
Phone number to be used to override the global value put into Administration > Parameters > SUPPORT_PHONE. 222-555-2222
|
URL to be used to override the global value put into Administration > Parameters > SUPPORT_URL. https://supporturl.com |
The unique ID assigned to an affiliation by Genius after it is created. 2 |
Learners
| Username (R) | Password (NR) | FirstName (R) | LastName (R) | Email (R) | CellPhone (NR) | PrimaryAffiliationIndex (NR) | AffiliationIndexes (NR) | LocalID (NR) | Status (R) | Notes (NR) |
|
This is the unique combination of letters, numbers, and/or symbols that a learner uses to log in to Genius+ with. It can be an email if you want emails used as usernames. TestLearner@test.com |
This is the unique combination of letters, numbers, and symbols that a learner creates as a password to log in to Genius+ with. Must be between 8-12 characters. Student1#1 |
Learner's first name. Georgina |
Learner's surname. Reyes |
This is the email address that will receive communications on behalf of Genius+. TestLearner@test.com |
This is the phone number that will be listed on the learner profile in Genius+. 222-555-5555 |
The unique ID assigned to an affiliation by Genius+ after it is created. This value is considered the learner's primary affiliation. 2 |
The unique ID (s) assigned to an affiliation by Genius+ after it is created. 2 If there are more than one the formatting is like so: Make sure to separate by comma. |
This can be whatever you want it to be if you have another ID you want to attach to the learner. For Blackboard Learn or Learn Ultra clients, this can be mapped to the StudentIndex through Admin > LMS > Properties to LMS. This will then populate the Local ID as the Learner ID in LMS. training11ec |
ACTIVE or ARCHIVED |
Notes for staff users. Georgina is allergic to peanuts. |
Affiliation columns left blank will create the learner with no affiliation.
Passwords can be left blank which will allow the system to generate the password for the learner.
Instructors
| LastName (R) | FirstName (R) | AffiliationIndexes (NR) | Notes (NR) | Status (R) | Cap (R) | Email (R) | Phone (R) | Username (R) | Password (NR) |
|
Instructor's surname. Starr |
Instructor's first name. Ringo |
The unique ID (s) assigned to an affiliation by Genius+ after it is created. 2 If there are more than one the formatting is like so: Make sure to separate by comma. |
Any items to note about the instructor. Instructor works in Pacific Time zone. |
ACTIVE or ARCHIVED |
The maximum number of active learners the instructor can have in enrollments at a time. 500 |
This is the email address that will receive communications on behalf of Genius+. rstarr@beatles.com |
This is the phone number that will be listed on the learner profile in Genius+ (333) 555-2555 |
This is the unique combination of letters, numbers, and/or symbols that an instructor uses to log in to Genius+ with. It can be an email if you want emails used as usernames. rstarr@beatles.com |
This is the unique combination of letters, numbers, and symbols that a learner creates as a password to log in to Enterprise+ with. Must be between 8-12 characters. Instructor1#1 |
Affiliation columns left blank will create the instructor with no affiliation.
Courses
| Course (NR) | Name (R) | CourseCode (NR) | Category (R) | Status (R) | AffiliationIndexes (NR) | SelfRegistration (R) | RequiresApproval (R) | TemplateLMSID (NR) | ShortDescription (NR) | LongDescription (NR) | Keywords (NR) | CatalogImage (NR) | Certificate (NR) | Expiration (NR) | PreRequisite (NR) | DocumentsPrerequisite (NR) | Recommendations (NR) | Tags (NR) |
|
This column is used when updating a course record. You can use Course Code, Course Index Number, or Course Name in it to reference the existing course. If you are creating new courses, you do not need to fill out this column. 29 |
This is the actual display name of the course. English Language for Beginners |
A code that might be assigned by the organization to this course. ELL101 |
This item pulls from entries in Administration > System Setup > Lists > Categories. Any entry from that list is an acceptable value here. Training |
ACTIVE or ARCHIVED |
The unique ID (s) assigned to an affiliation by Genius+ after it is created. 2 If there are more than one the formatting is like so: Make sure to separate by comma. |
Putting Yes as the value will permit learners to be able to register for courses on their own. Putting No as the value will require a staff role to enroll learners into the course. Yes |
Putting Yes as the value will add an approval workflow to the enrollment process into all sections of this course. Putting No as the value will permit learners to instantly enroll into the section of the course. No |
This is the ID of the template course created in your LMS. This connects the template you created in the LMS to the template you are creating in Enterprise+. ELL_TEMPLATE |
A short, one-to-two-line description of the course. English Language for Beginners virtual bootcamp. |
The description in the course catalog that appears when the info button for the course is selected. Can be a longer body of text. This is a bootcamp style course on the English Language for Beginning learners. The course consists of multiple modules and will be hosted across a variety of platforms. |
This item pulls from entries in Administration > System Setup > Lists > Keywords. Any entry from that list is an acceptable value here. BeginnerLevel |
This item pulls from files uploaded in Administration > System Setup > File Upload > file URL. Any entry from that list is an acceptable value here. https://stenterprisefiles.blob.core/test.png |
This item pulls from files uploaded in Administration > Operations > Certificates. Any certificate set to COURSE type is an acceptable value here. TestCourseCertificate10 |
If a value is placed here, the course will "expire" by that value. 11/11/2025 |
If a value is placed here, the course will require a prerequisite course to be completed to enroll into this one. CourseNameHere
|
If a value is placed here, the course will require document(s) to be submitted as prerequisites to enroll into this one. DocumentPrerequisiteName |
Any courses that are recommended to take that are similar to this course can be put as values here. CourseNameHere |
This item pulls from entries in Administration > System Setup > Lists > Tags. Any entry from that list is an acceptable value here. Virtual |
Affiliation columns left blank will create the course with no affiliation.
Sections
| Course (NR) | Section (R) | Name (R) | InstructorUsername (R) | Status (R) | AffiliationIndexes (NR) | Term (R) | Cap (R) | StartDate (R) | EndDate (R) | Duration (NR) | EnrollByDate (NR) | Location (NR) | Price (NR) | Credits (R) | AttendanceMeasure (NR) | Lessons (NR) | LMS (NR) | LMSCourseID (NR) | ExternalLink (NR) | Delivery (NR) | Competencies (NR) | CompletionFormula (NR) | Notes (NR) |
|
This column is used when updating a course record. You can use Course Code, Course Index Number, or Course Name in it to reference the existing course. If you are creating new courses, you do not need to fill out this column. 29 |
The unique ID assigned to a section by Genius after it is created. 12 |
This is the actual display name of the section. English Language for Beginners 2024 |
This is the unique combination of letters, numbers, and/or symbols that an instructor uses to log in to Genius+ with. rstarr@beatles.com |
ACTIVE or ARCHIVED |
The unique ID (s) assigned to an affiliation by Genius+ after it is created. 2 If there are more than one the formatting is like so: Make sure to separate by comma. |
This item pulls from entries in Administration > System Setup > Lists > Terms. Any entry from that list is an acceptable value here. Ongoing |
The maximum number of active learners the section can have in enrollments at a time. 50 |
The start date of the section. 10/10/2024 |
The end date of the section. 10/20/2024 |
The duration in days of the section. 10 |
The date a learner must enroll in this section by before registration closes. 10/11/2024 |
Any text value is accepted here if there is a location to be included with the section. Building A, Room 2929 |
The price of the section. 400.00 |
The number of credits awarded to the learner upon completion of the section. 1 |
BY_MEETING_TIMES or BY_LESSON_NUMBER |
The number of lessons included in the section. 12 |
This item pulls from entries in Administration > Integrations > LMS. Any entry from that LMS NAME list is an acceptable value here. TEST_PROD_ULTRA |
If the section already exists in the LMS, use this field to populate the LMSCourseID of the section to be synced. SampleELL101_2 |
This link is used for sections that are not hosted in an LMS and should direct the learner to a different URL where the section is hosted. https://zoommeeting.com/ |
This item pulls from entries in Administration > System Setup > Lists > Delivery Methods. Any entry from that list is an acceptable value here. Online |
This item pulls from entries in Administration > System Setup > Lists > Competencies. Any entry from that list is an acceptable value here. Interpersonal Communication |
This item pulls from entries in Sections > Add Section > Completion Formula field. Select edit on that field to view a list of commonly used formulas. OVERALL_GRADE_TEXT == "PASS"
|
Notes for staff users about the section. Organization B is sponsoring this section's participants to take for free. |
Adding a completion formula will override the global completion formula set in Parameters.
Affiliation columns left blank will create the course with no affiliation.
Enrollments**
| Username (R) | Section (R) | Status (R) | StartDate (R) | EndDate (R) | ExitDate (R) | Grade (NR) | Assignments (NR) | AssignmentsCompleted (NR) |
|
This is the unique combination of letters, numbers, and/or symbols that a learner uses to log in to Genius+ with. testlearner@test.com |
The unique ID assigned to a course by Genius after it is created. 12 |
ACTIVE, DROPPED, DROPPED_GRACE, COMPLETED, BLOCKED, FUTURE, UNSUCCESSFUL are all acceptable values here. New enrollments should be set as ACTIVE, historical enrollments can have any of the other statuses listed above. ACTIVE |
The start date of the enrollment, often the first day of the learner's enrollment in the section. 10/10/2024 |
The end date of the enrollment, often the last day of the learner's enrollment in the section. 10/20/2024 |
The day the learner meets the completion formula for the enrollment in the section. 10/20/2024 |
The numeric value grade the learner received upon completion. 98 |
The total numeric value of assignments a learner has to complete in the section. 12 |
The total numeric value of assignments the learner completed already in the section. 12 |
Only add an exit date if the learner is not active in the section. The exit date represents the date of the completion of the course.
**Only used for creation CSVs. Any updates will only impact the STATUS of the enrollment.
NEW UPDATES AS OF 08/2024:
- As an admin, if you are doing an External Course import and adding the equivalent course (using CourseIndex, Course Name, or Course Code), it will now count towards a completion of a Learning Path or Prerequisite similar to if a learner reported their own external course for credit.
Comments
0 comments
Article is closed for comments.