Ems Data Export Instructions

Contributers: Administrator, Mick Mifsud

Modified: 2 years ago

Page Permission: Public - Revision: 820

For all tables clicking on the "columns" button under the filter fields will show you all the fields that will be exported to the CSV, the checkbox this is only to show what fields are visible on the current page, all fields will be exported to the CSV.

For all tables, clicking the "CSV" while no columns are selected will export all currently filtered rows. Alternatively you can select the rows you want to export on that page.

The EMS is split into courses with subjects as their children. A course, for example, would be "DVM 3/4" and its child subject (or class/cohort) would be "Class of 2024 - DVM 3/4".

Company Export

In the "Course Edit" page in the top actions menu click the button called "Company Export".

This page will export all companies for the selected course. You will need to export each course to get all records from the EMS. Both "DVM 1/2" and "DVM 3/4" courses have separate listings.

Column names prefixed with a single letter correspond to the following:

  • C = Company Categories
  • A = Company Animals Worked On
  • F = Company Facilities

You can use the form fields at the top of the page to filter the results.

  • Search: Search for a company ID or text within the name and other company fields.
  • Published: Only show companies that students can view.
  • Status: Show companies that match the selected status values.
  • LGA: Filter companies by Local government area (LGA)
  • State: Filter companies by state
  • Country: Filter companies by country
  • Category: Filter companies by category
  • Date Range: Select a date range the company was added to the EMS

Company Placement Comment Export

In the "Course Edit" page in the top actions menu click the button called "Company Comment Export".

Export all public and private comments for every placement report submitted withing the date range.

You can use the form fields at the top of the page to filter the results.

  • Date From: Search for comments that where created from this date. The default EMS value is set to 3 years in the past.

Supervisor Export

In the "Course Edit" page in the top actions menu click the button called "Supervisor Export".

This page will export all supervisors for the selected course. You will need to export each course to get all records from the EMS. Both "DVM 1/2" and "DVM 3/4" courses have separate listings. However, in this case "DVM 1/2" do not use supervisors and will not have any.

You can use the form fields at the top of the page to filter the results.

  • Search: Search for a supervisor ID or text within the name and other supervisor fields.
  • Graduation_Year: Not used, Ignore this filter.
  • Status: Show supervisors that match the selected status values.

Placement Export

In the "Course Edit" page in the top actions menu click the button called "Placement Export".

Here you can export all placement data for a course and its child subjects.

This page will export all placements for the selected course and filtered subjects. You will need to export each course to get all records from the EMS. Both "DVM 1/2" and "DVM 3/4" courses have separate listings.

For the placement reports the columns will have the current status value if a report/assessment exits.

The fields From the "mentor" field onward are per student the assessment totals are after the "mentor" field.

NOTE: Do not try to export all placements as there are to many and the CSV export will fail. Be sure to filter by a subjects (default is current active subjects), status's and/or a date range.

You can use the form fields at the top of the page to filter the results.

  • Date Range: Select a date range of placements start and end date.
  • Status: Show placements that match the selected status values.
  • Subject: Select the placement subjects to filter. By default, the active subjects are selected.

Student Unit Totals

Select a DVM 3/4 subject then on the left menu select "Reporting -> Rule Report".

These totals are also in the "Placement Export" table, but this table only lists the totals per student. This table may be more useful as it does not have the placement data.

This page will export unit data for a specific Subjects student list only. You will need to export this list from each individual subject to get a complete record.

You can use the form fields at the top of the page to filter the results.

  • Status: Show total for a placements with that status only