Import subjects
The Import subjects button on the Subjects tab enables the import of subjects into the Subjects register, from a predefined Excel file.
 |
HINT
For a practical use case of subject import from Excel see the User Manual.
|
The button has two options:
When clicking the button, an Excel file (Subject_import_template_EU) is downloaded onto your computer. The table has predefined fields for the input of data about subjects.
Clicking the Import subjects button opens a new form – File upload for subject import:
The filled out Excel file (Subject_import_template_EU) can be uploaded with the Drag and drop method, or by clicking into the grey field, which will open a window with Explorer, where you can select your file.
The program shows the imported data. In the temporary view, the data can still be changed, edited, or added.
The toolbar has buttons:
|
Repeat import
|
Begins a new import process.
|
|
Save
|
Saves the data from the temporary table into the Subjects register.
|
|
X (Exit)
|
Cancels the import process.
|
The header shows the following data:
|
Show only errors (toggle button)
|
If this toggle button is enabled (colored yellow), only subjects (lines) with mistakes or missing data are shown. This feature is very useful with a large data import.
|
|
No. of updated subjects
|
Displays the number of subject that are already in the register and will only be updated.
|
|
No. of new subjects
|
Shows the number of subject that are not in the register yet, and are being imported for the first time.
|
|
No. of errors in columns
|
Shows the number of all errors in all columns.
Where there is mandatory data missing in the table (error), the program will return the ! warning sign.
When all the errors are fixed, the number will return to 0.
|
Columns
|
Status
|
The X sign shows that there is an error in this line. When the error in an individual line is fixed, the X sign in the Status column will disappear.
|