- Importing a notebook
- With the notebook import application, you enter the contents of a notebook that you have processed/filled outside the IS, e.g. in Excel on your computer, into the IS.
This application can only load a file that was created by the notebook export application. This file must retain the student and course identification column. Importing into a notebook will irreversibly overwrite the existing data in the notebook.
When outputting from Excel, it is necessary to select the tab-delimited text output format. The Excel workbook will not be accepted by the application.
You can have a notebook of just one name in one file, even if it belongs to multiple courses at the same time. However, when importing a file, you must first select all (or more) courses that appear in the file. That is, you must have the courses into which the contents will be imported listed in the page header. If you don't have any there, you will probably get an error message "You don't have permission to the course".
When importing a file, only some columns are read. Columns are separated by tab or colon (:). They are numbered from one. Two or more columns are relevant for import. The first mandatory column is the identification string.
It contains a unique identifier associating the evaluation with the course, the period, the individual, his/her study and the course enrolment. This data must not be changed in the process of processing the assessment outside the IS. The first number of the identification string is the student's učo and the second is the course code. The identification string contains some extra data in order to recognize an inadvertent change of the identification string as an error. In the form above, you must set the sequence number of the identifier column. If you do not fill it in, it will be an error. The pre-filled column number value corresponds to the column number where the identifier is inserted by the export application.
The second mandatory column is the content column. You can specify more than one content column number if you are processing the exported notebook in Excel and you have your own data in multiple columns. When importing the notebook, all the columns you specify are taken and combined into one content column (separated by a single space). The imported file must not contain the ¨ character (single consonant).
If more than one row is stored for one student, i.e. the content is made up of multiple rows, the so-called continuation rows are created when exporting to a text format separated by colons (not for Excel!). The continuation line starts with the character "|" (vertical bar) in the first column. The notebook can also be loaded in the same form.
We recommend that you import at least twice. On the first attempt, leave the default "try without saving - used for checking purposes". No changes will be made in this mode, but all error and informational messages will be displayed.
If you select "import and save", then the contents of all the correct records will be imported. Erroneous ones are left unchanged.
If you discard some rows from the exported file, the content of the notebook in the IS is not changed when importing the discarded students. Only the contents of those students and courses that are listed in the identification string are imported.
If in Excel you need to add "*" before numbers in a specific column to indicate a further processable point value, proceed as follows (in Excel): select Format -> Cells -> Number tab -> Custom -> enter e.g.
"*"#