Echo360 has always had the capability of creating (and in some cases updating) objects in the system using CSV file imports. However, bulk updates were limited to only user enrollments and those imports were cumbersome to generate and maintain.
The Admin CSV Functionality now ties into the Echo360 API, allowing for bulk create, update, and for many objects, delete of items in the system. The reason we can do this now is because we now provide CSV Exports of system items that include the object IDs.
Since the use of object ID for update or delete ensures that the correct object is being changed or removed, allowing broad-stroke changes to the system significantly reduces the possibility of user-error where the change cannot be undone.
Support for Delegated
Administration: If delegated
administration is enabled for the institution, institution-level admins
can see all imports and exports that have been performed on the system
through the Imports/Exports tab. Organization and Department level admins
can only see the imports/exports THEY initiated.
If delegated administration is not enabled for the institution, all admins can see all imports/exports run through this tab.
We suggest using the following workflow for Export/Import CSV changes to Echo360:
Large imports can take some time to process. For this reason, your imported CSV file should contain only the rows being created or that require updates. Every row in the file must be parsed and validated, even if it makes no changes; having unnecessary rows in the imported file will needlessly increase processing time.
Most create-action imports do not require an export to be generated first, however some of the create-action imports do require the use of a system ID for the value in one or more fields. For example, Create Section import requires a Course ID and Term ID for the new sections. Use a course and term export to find the IDs you need to use and copy them into the Section import fields.
You may also find it useful to generate an Export if there are system items with similar/identical fields to the ones you want to create. Use the export to copy the values you want. For example, creating an Intro to Biology section in a new term might use all the same fields as the old Intro to Biology section did, with the exception of Term ID (new term/new ID).
Delete-action imports do not require any fields other than ID because the values in the other fields don't matter if the item is being deleted. The only validation we have is to see that the ID given matches the object type you have selected to delete.
You may want to, however, retain one or more other fields in the Delete-action CSV file, to do your own validation that the listed items are the ones you want to delete, or to confirm those items have been deleted once the import is finished.