Excel (import)
Click here to see this page in full context

Excel (import)

All the data can be imported from Excel (or another spread sheet) into EDT: classes, courses, students, equipment, subjects, ETM, staff, schedule, teachers, legal guardians, rooms.

Put the Excel data in a format expected by EDT

In every Excel file, you must have a line per data, a column by type of information (field). The titles of the columns are of no importance. On the other hand, some data must respect the syntax expected by EDT (Syntax for data (import)).

Manually import data from Excel in EDT

  1. In the Excel file, select the data to be import and use [Ctrl + C] to copy it.
  2. In any work group display Timetable, use [Ctrl + V] to paste the data: the import window opens.
  3. On top, select the type of data to import.
  4. Indicate Tabulation as field divider.
  5. Match each column with an EDT field. For this, click on the arrow next to the title Ignored field and select in the drop-down menu the field to which the column corresponds. If a column should not be imported, leave Ignored field. As long as missing fields are required, all the data is displayed in red. If some data remains red at the end of the matching, it does not correspond to the expected format: hover the cursor over it to know why. Most of the time, the data is still imported but modified to be compliant.
  6. If you have copied the column titles, tick Do not import the [1] first lines.
  7. If the columns imported contains multiple data (for example, the courses contain several teachers, teachers having several subjects, etc.), verify the sign that divides them in the field Multiple resource divider (comma by default).
  8. Click on Import: EDT proposes to transfer to Exclusive Usage mode (the other users are transferred to Consultation mode for the time of the import).
  9. EDT displays a report concerning the imported data.
  10. Close the window, EDT proposes to save the import format: if you think of repeating this type of import regularly, save the format so you will not have to match the columns; you can find the import format by clicking on Open on the top right of the window.
  11. Click on the button  in the tool bar.
  12. In the popup window, choose by saving your modifications.