| 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 | |
|---|
