ELIS 1.9 Manual

ELIS Data Hub

Batch Importing Course Info.

The Course tab is where you can edit the import parameters for 'course' information. Since you are using Data Hub with ELIS, you can also use this tab to set Curriculum, Track, Class, and ELIS Course properties. Currently only csv files are supported.

On the course properties mapping table, we can map the key names in DH to the names of values in the import file. The following properties can currently be set for ELIS course information on the Course properties mapping table. You only need to remap data entered here if your export file has different names in it, for instance if your legacy system used a field named 'courseid' instead of 'idnumber', then the correct field name would need to be entered in the properties map.

ELIS Data Hub Course tab


assignment:
This assigns the course to a curriculum. A course may be assigned to more than one curriculum by entering it in more than one row.
link:
This is the shortname of the Moodle course that should be used as a template for classes created off of the ELIS course.

The following two fields are not in the courses properties map shown above but are required for every course import file.

action: The available actions are create, update, and delete.
context:
Enter 'course' in the context field when importing course information. The context field is telling the system what is being added. The other available entries are class, track, and curr (curriculum). Note: Remember to use curr for 'curriculum'.

The required fields for courses are:
  1. execute/action
  2. context
  3. idnumber
  4. name
Note: Action should always be first, as shown in the example below.

Example:
A csv file with the following information in it is created in OpenOffice*:
Course file example

Select this link to download the file in the previous image.

Then we upload it to the ipload directory**:

Uploading a file to the import folder

Once the file is in place, the system will process it according to the settings in the Data Hub block configuration. If you want to process it right away, you can click the "Save and Process" button located on the Course tab of the ELIS DH interface. Make sure the file name on the Course tab matches the name of the file uploaded to the import folder.

Courses tab

Then scroll to the bottom of the page and select the Save and process button.

Save and process button

ELIS DH will report whether the file was successfully loaded.

Log file link

Select the log file link to view the log.

Log file

The log is also available in the iplog directory of your ELIS DH directory, if you have entered the usernames of users who should receive email notifications - the log will also be emailed to them.

Once the import has been run successfully, you can click the Manage Courses link and see the course or courses you have imported.

Manage Courses link and screen


*csv files can be created in many systems and by automated processes, we're just using OpenOffice as an example here.

** Shown is uploading via Cyberduck - any SFTP client will work, though, as will automated processes that write the file via SCP.