| 1 | ==================
|
|---|
| 2 | Importing Verdicts
|
|---|
| 3 | ==================
|
|---|
| 4 | Structure of the CSV file
|
|---|
| 5 | --------------------------
|
|---|
| 6 |
|
|---|
| 7 | the CSV-file must have one of these headlines
|
|---|
| 8 |
|
|---|
| 9 | | student_id, current_session, current_level, current_verdict
|
|---|
| 10 | |
|
|---|
| 11 | | matric_no, current_session, current_level, current_verdict
|
|---|
| 12 | |
|
|---|
| 13 | | student_id,matric_no, current_session, current_level, current_verdict
|
|---|
| 14 |
|
|---|
| 15 |
|
|---|
| 16 | The fields mean:
|
|---|
| 17 |
|
|---|
| 18 | :student_id:
|
|---|
| 19 | the id of the student
|
|---|
| 20 |
|
|---|
| 21 | :matric_no:
|
|---|
| 22 | students matricel number
|
|---|
| 23 | If student_id and matric_no are specified it is checked if the student_id
|
|---|
| 24 | and matric_no belong to the same student.
|
|---|
| 25 |
|
|---|
| 26 | :current_session:
|
|---|
| 27 | the session-id this verdict is for, this value must be the same as in the
|
|---|
| 28 | studylevel-object
|
|---|
| 29 |
|
|---|
| 30 | :current_level:
|
|---|
| 31 | the level-id this verdict is for, on probation levels must be specified as
|
|---|
| 32 | level-nr + 10 or +20. It is checked if this level exists and its
|
|---|
| 33 | review_state is opened.
|
|---|
| 34 |
|
|---|
| 35 | :current_verdict:
|
|---|
| 36 | the verdict-id from the vocabulary *verdicts*
|
|---|
| 37 |
|
|---|
| 38 |
|
|---|
| 39 | Example Verdicts.csv::
|
|---|
| 40 |
|
|---|
| 41 | matric_no, current_session, current_level,current_verdict
|
|---|
| 42 | MGS0602342,06,200,B
|
|---|
| 43 | MGS0602346,06,200,A
|
|---|
| 44 | MGS0602350,06,200,B
|
|---|
| 45 | MGS0602360,06,200,A
|
|---|
| 46 | MGS0602375,06,200,B
|
|---|
| 47 | MGS0602388,06,200,A
|
|---|
| 48 | MGS0602390,06,200,A
|
|---|
| 49 | MGS0603494,06,200,B
|
|---|
| 50 |
|
|---|
| 51 |
|
|---|
| 52 | The import form
|
|---|
| 53 | ---------------
|
|---|
| 54 |
|
|---|
| 55 | :Filename:
|
|---|
| 56 | Verdicts.csv
|
|---|
| 57 |
|
|---|
| 58 | :Import Layout:
|
|---|
| 59 | Verdicts
|
|---|
| 60 |
|
|---|
| 61 | :Import or Edit:
|
|---|
| 62 | edit (import is not possible)
|
|---|
| 63 |
|
|---|
| 64 | if **Bypass QueueCatalog** is shown, click it!
|
|---|
| 65 |
|
|---|
| 66 | click "import"
|
|---|
| 67 |
|
|---|
| 68 | Logging messages
|
|---|
| 69 | ----------------
|
|---|
| 70 |
|
|---|
| 71 | Startmessage
|
|---|
| 72 |
|
|---|
| 73 | | 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
|
|---|
| 74 |
|
|---|
| 75 | Successful import
|
|---|
| 76 |
|
|---|
| 77 | | 2008-01-23 10:02:59 INFO WAeUPTool.importData 1 of 1 "E943527","MGS0602342","06","200","B"
|
|---|
| 78 |
|
|---|
| 79 | Commit message
|
|---|
| 80 |
|
|---|
| 81 | | 2008-01-23 10:07:40 INFO WAeUPTool.importData 19 transactions committed
|
|---|
| 82 |
|
|---|
| 83 | Finish message
|
|---|
| 84 |
|
|---|
| 85 | | 2008-01-23 10:08:23 INFO WAeUPTool.importData Finished import from Verdicts07_2.csv: 2001 imported, 30 not imported (of total 4736)
|
|---|
| 86 |
|
|---|
| 87 | Generated files
|
|---|
| 88 | ---------------
|
|---|
| 89 |
|
|---|
| 90 | The imported records are written to a file named Verdicts_imported_TIMESTAMP.csv
|
|---|
| 91 |
|
|---|
| 92 | The not imported records are written to a file named
|
|---|
| 93 | Verdicts_not_imported_TIMESTAMP.csv. This file contains for each not
|
|---|
| 94 | imported record a detailed error message.
|
|---|
| 95 |
|
|---|
| 96 | Error descriptions in the not_imported file
|
|---|
| 97 | -------------------------------------------
|
|---|
| 98 |
|
|---|
| 99 | | "SSC0307645","06","400","L","no student with matric_no SSC0307645"
|
|---|
| 100 |
|
|---|
| 101 | | "SSC0307646","06","400","A","student A123456 matric_no SSC0307646 does not match SSC0307666"
|
|---|
| 102 |
|
|---|
| 103 | This can only happen if student_id AND matric_no are specified.
|
|---|
| 104 |
|
|---|
| 105 | | "SSC0307646","06","400","A","student X191513 in wrong review_state courses_registered"
|
|---|
| 106 |
|
|---|
| 107 | | "SSC0307657","06","400","L","student_id: E986457 imported session 06 does not match session 04"
|
|---|
| 108 |
|
|---|
| 109 | | "SSC0307657","06","400","L","student_id: E986457 imported level 400 does not match level 300"
|
|---|
| 110 |
|
|---|
