How to complete the database with spreadsheet data?

If your data is stored in a spreadsheet, you can import it into most EDT displays.

1. Put data in the format expected by EDT (one line per data item; one column per type of information; respect of syntax for certain types of data).
2. In the spreadsheet, select the data to be imported and copy them using the shortcut Ctrl + C.
3. In EDT, go to Timetable > Subjects/Specializations/Teachers/etc. then paste the data using the shortcut Ctrl + V: an import window opens.
4. In this window, match the data:
   
   • • in the drop-down menu Type of data to import, select the data type,
       
       
       
       
   • select the field separator Tabulation,
     
     
     
     
   • for each column, replace Field ignored with the appropriate type of field.
     
     
     
     
     Note
     

     • If a column is not to be imported, leave Field ignored.
     • As long as required fields are missing, all data is displayed in red. If some data remains in red at the end of the matching process, it's because it doesn't match the expected format: move the cursor over it to find out why.
     • If you have copied the column titles, tick Do not import the [1] first lines.
     • If imported columns contain multiple data (for example, courses containing several teachers, teachers with several subjects, etc.), verify the sign separating them in the field Separator of multiple resources (by default, the comma).
5. Click on Import. With the Network version, you switch to EXCLUSIVE USAGE mode for the duration of the import. Once you've viewed the import report, close the import window and exit EXCLUSIVE USAGE mode.