==================
Importing Verdicts
==================
Structure of the  CSV file
--------------------------

the CSV-file must have one of these headlines

| student_id, current_session, current_level, current_verdict
| 
| matric_no, current_session, current_level, current_verdict
| 
| student_id,matric_no, current_session, current_level, current_verdict


The fields mean:

:student_id: 
  the id of the student
  
:matric_no:
  students matricel number
  If student_id and matric_no are specified it is checked if the student_id
  and matric_no belong to the same student. 
  
:current_session:
  the session-id this verdict is for, this value must be the same as in the
  studylevel-object
  
:current_level:
  the level-id this verdict is for, on probation levels must be specified as
  level-nr + 10 or +20. It is checked if this level exists and its
  review_state is opened.

:current_verdict:
  the verdict-id from the vocabulary *verdicts*
  

Example Verdicts.csv::

 matric_no, current_session, current_level,current_verdict 
 MGS0602342,06,200,B
 MGS0602346,06,200,A
 MGS0602350,06,200,B
 MGS0602360,06,200,A
 MGS0602375,06,200,B
 MGS0602388,06,200,A
 MGS0602390,06,200,A
 MGS0603494,06,200,B


The import form  
---------------

:Filename:
  Verdicts.csv
  
:Import Layout:
  Verdicts
  
:Import or Edit:
  edit (import is not possible)

if **Bypass QueueCatalog** is shown, click it!

click "import" 

Logging messages
----------------

Startmessage

| 2008-01-23 10:02:58 INFO WAeUPTool.importData johnd starts import from Verdicts07_2.csv in edit mode with schema and layout import_verdict

Successful import

| 2008-01-23 10:02:59 INFO WAeUPTool.importData 1 of 1 "E943527","MGS0602342","06","200","B"

Commit message

| 2008-01-23 10:07:40 INFO WAeUPTool.importData 19 transactions committed

Finish message

| 2008-01-23 10:08:23 INFO WAeUPTool.importData Finished import from Verdicts07_2.csv: 2001 imported, 30 not imported (of total 4736)

Generated files
---------------

The imported records are written to a file named Verdicts_imported_TIMESTAMP.csv

The not imported records are written to a file named
Verdicts_not_imported_TIMESTAMP.csv. This file contains for each not
imported record a detailed error message.

Error descriptions in the not_imported file
-------------------------------------------

| "SSC0307645","06","400","L","no student with matric_no SSC0307645"

| "SSC0307646","06","400","A","student A123456 matric_no SSC0307646 does not match SSC0307666"

This can only happen if student_id AND matric_no are specified.

| "SSC0307646","06","400","A","student X191513 in wrong review_state courses_registered"

| "SSC0307657","06","400","L","student_id: E986457 imported session 06 does not match session 04"

| "SSC0307657","06","400","L","student_id: E986457 imported level 400 does not match level 300"