You can create, update, and delete sections and enrollments using CSV Imports.

The fields requested for the update are identical to those requested for create, except that the update requires the Section ID to make section updates via import. For Enrollment updates, they are the same.

Generating a section or enrollment export should provide most of the data you need for an Update or Delete-action import. You may also need a Term, Course, or User export to obtain the system IDs for any changes you want to make to the sections.

A Delete action import for a section requires only the section's system ID. A Delete-action enrollments import requires the user ID / email of the user you are un-enrolling and the Section ID of the section you are removing them from.

Imported files must have all fields / columns requested: If the Update-import example contains a field, that field must be included in the final import, even if you are not making changes to the values for that field. As noted below, if an optional field is blank, the value is removed for that item. Similarly, if the FIELD is missing from the import file for an optional field, that value will be removed from all items in the update file. If the field is required, it must both exist in the import file and have a value.

Remove or Append Field Values on Update

Since you can copy existing values from an export into an update-action import file, we expect that if you wish to retain the existing values, those will be present in the import. This means that for updates:

• To remove the value(s) for a field where the value is optional, remove the existing value and leave the field blank.
  • If the value is required and the field is blank, the row will be rejected.
  • If the value is optional and the field is blank, the value will be removed from the object's properties.
  • If the value is optional and the field is missing from the import (the column is not present), that value will be removed from all items in the update.
• To replace a field's value, remove the existing value and replace it with the new/updated value.
• To append values in a field where multiple values are allowed, retain the existing values and add the new values to the field (separated with a semicolon).

Create Section

Download a sample CSV file and enter the values for your new sections into the fields provided. Then import your new file.

Use the system ID for the Course, Term, and any Instructors you are adding to the section when creating it. To obtain the system ID for these fields, perform an Export for the object type whose IDs you want to use, then copy that information into the appropriate fields of your import file.

Update Section

Generate a Section Export, then select and update the necessary information for the import file. Then import your new file.

Imported files must have all fields / columns requested: If the Update-import example contains a field, that field must be included in the final import, even if you are not making changes to the values for that field. As cited above, if a value is blank for an optional field, the value is removed for that item. Similarly, if the FIELD is missing from the import file for an optional field, that value will be removed from all items in the update file. If the field is required, it must both exist in the import file and have a value.

Update LMS Course IDs

The Update LMS Course IDs import allows you to identify the LMS Courses that will link into each EchoVideo section, and to update or remove those links as needed. The LMS Courses field in the import includes a true/false parameter that indicates whether the LMS Course will automatically link to the EchoVideo section. Setting the "true" parameter in the field data makes the EchoVideo LTI link in the LMS course take users directly to the EchoVideo section, without requiring any selection by the Instructor or administrator.

If using the LMS Courses field to establish direct default linking behavior, you will need the LMS Configuration ID from the Configurations page for the LMS you are using. The LMS Configuration ID identifies the LMS configuration link being used. Use the same ID shown in the LTI Configuration URL used to establish the LTI link between EchoVideo and the LMS.

IMPORTANT NOTES: Default linking from the LMS into an EchoVideo section will only work if there is only one EchoVideo section identified for the LMS Course. Multiple LMS courses can link to a single section. However, if one LMS Course links to multiple EchoVideo sections, the admin or instructor must select the appropriate section in the LMS course. In addition, if there are discrepancies between the LMS Course ID(s) entered in the LMS Course IDs field and those entered in the LMS Courses field, those in the LMS Courses field will take precedence.

Generate a Section Export to get the Section IDs needed, and the LMS Course ID if one is already linked to one or more sections. Then import your new file.

As with other imports, if the Update-import example contains a field, that field must be included in the final import, even if you are not making changes to the values for that field. If a value is blank for an optional field, the value is removed for that item. You can use this Update imports feature to REMOVE the LMS ID and linking values from each EchoVideo section, if necessary.

Delete Section

Generate a Section Export, then select and copy the rows for the sections you want to delete into a new file for the Delete-action import. You can retain additional fields in the file; all except ID are ignored. Then import your new file.

Enroll Users (Create Enrollments for a Section)

Download a sample CSV file and enter the values for your new sections into the fields provided. Then import your new file.

You can use an email address or system ID for the User field. Use the system ID to identify the section. All fields in the Create Enrollment import are required.

To obtain the system ID, export the object type whose IDs you need, then copy the information into the appropriate fields of your import file.

Update User Enrollments (Change User Roles in a Section)

Download a sample CSV file and enter the values for your new sections into the fields provided. Then import your new file.

You can use an email address or system ID for the User field. Use the system ID to identify the section. All fields in the Update Enrollments import are required.

To get the system ID, run an Export for the object type whose IDs you need, then copy that information into the appropriate fields in your import file.

Unenroll Users (Delete Enrollments From a Section)

Generate an Enrollment Export, then select and copy (into a new file) the rows for the users you want to unenroll and the sections from which you want to remove them. You can retain additional fields in the file; all except ID are ignored. Then import your new file.