Index: /WAeUP_Doc/ImportVerdicts.txt
===================================================================
--- /WAeUP_Doc/ImportVerdicts.txt	(revision 3038)
+++ /WAeUP_Doc/ImportVerdicts.txt	(revision 3038)
@@ -0,0 +1,110 @@
+==================
+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"
+
