SQL

Put the SQL data in a format expected by EDT

Syntax for data (import)

Import the data in a SQL format

1. Go to the menu Imports/Exports > TXT/CSV/XML/SQL > Import in SQL.
2. In the import window, choose in the drop-down menu the type of data to be imported.
3. Configure the connection to the SQL Server by using the wizard if needed.
4. Enter your query and click on the button Execute the query.
5. Associate every column with an EDT rubric by clicking on the arrow on top of the column. If a column should not be imported, select Field ignored. If some data does not correspond to the expected format, it will be displayed in red. Hover the cursor over it to display the reason for the problem in a tool tip.
6. In the frame Options on the bottom of the window, indicate the sign that separates different data in the same cell (for example the course contain several teachers, teachers having several subjects, etc.).
7. Once all the matching is established, click on the button Import.