Index: main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/export.py
===================================================================
--- main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/export.py	(revision 18339)
+++ main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/export.py	(revision 18340)
@@ -18,5 +18,14 @@
 """Exporters for student related stuff.
 """
+import grok
 from waeup.kofa.students.export import DataForLecturerExporter
+
+from zope.component import getUtility, createObject
+
+from waeup.kofa.students.export import (get_levels,
+    DataForLecturerExporter, StudentExporterBase,)
+
+from waeup.kofa.utils.batching import ExporterBase
+
 from kofacustom.unidel.students.interfaces import (
     ICustomStudent,
@@ -32,4 +41,69 @@
     NigeriaStudentPaymentExporter)
 from waeup.kofa.utils.helpers import iface_names
+
+
+def get_tickets_for_ict(students, previous=0, **kw):
+    """
+    """
+    tickets = list()
+    #code = kw.get('code', None)
+    level = kw.get('level', None)
+    session = kw.get('session', None)
+    ct_level = kw.get('ct_level', None)
+    ct_session = kw.get('ct_session', None)
+    ct_semester = kw.get('ct_semester', None)
+    for level_obj in get_levels(students, previous, **kw):
+        allticketcodes = list()
+        for ticket in level_obj.values():
+            if ct_level not in ('all', None):
+                if level_obj.level in (10, 999, 1000, None)  \
+                    and int(ct_level) != level_obj.level:
+                    continue
+                if level_obj.level not in range(
+                    int(ct_level), int(ct_level)+100, 10):
+                    continue
+            if ct_session not in ('all', None) and \
+                int(ct_session) != level_obj.level_session:
+                continue
+            if ct_semester not in ('all', None) and \
+                int(ct_semester) != ticket.semester:
+                continue
+            if ticket.total_score is not None:
+                if ticket.total_score < ticket.passmark:
+                    remark = 'failed'
+                else:
+                    remark = 'passed'
+            else:
+                remark = 'nottaken'
+            ticket.remark = remark
+            ticket.stdnt = level_obj.student
+            tickets.append(ticket)
+            allticketcodes.append(ticket.code)
+        # collect missed tickets for each study level
+        certificate = getattr(
+            level_obj.student.get('studycourse', None), 'certificate', None)
+        if certificate:
+            for certcourse in certificate.values():
+                if certcourse.level != level_obj.level:
+                    continue
+                if certcourse.getCourseCode() not in allticketcodes:
+                    ticket = createObject(u'waeup.CourseTicket')
+                    ticket.code = certcourse.getCourseCode()
+                    ticket.remark = 'missed'
+                    ticket.course_category = certcourse.course_category
+                    ticket.stdnt = level_obj.student
+                    tickets.append(ticket)
+    # Remove failed or missed tickets if they have been passed later
+    obsolete = list()
+    for student in students:
+        all_tickets = [i for i in tickets if student == i.stdnt]
+        passed_tickets = [i for i in all_tickets if i.remark == 'passed']
+        for passed_ticket in passed_tickets:
+            for ticket in all_tickets:
+                 if ticket.code == passed_ticket.code: # remove passed ticket too
+                    obsolete.append(ticket)
+    for ticket in set(obsolete):
+        tickets.remove(ticket)
+    return tickets
 
 class CustomStudentExporter(NigeriaStudentExporter):
@@ -121,2 +195,28 @@
             value, name, context=context)
 
+class OutstandingCourses2Exporter(grok.GlobalUtility, StudentExporterBase):
+    """
+    """
+    grok.name('outstandingcourses_2')
+
+    title = u'Outstanding Courses V2'
+
+    fields = ('student_id', 'matric_number', 'certcode', 'display_fullname',
+              'code', 'course_category', 'remark')
+
+    def filter_func(self, x, **kw):
+        return get_tickets_for_ict(x, **kw)
+
+    def mangle_value(self, value, name, context=None):
+        """The mangler determines the student's id and fullname.
+        """
+        if context is not None:
+            student = context.student
+            if not student:
+                student = getattr(context, 'stdnt', None)
+            if name in ('student_id', 'display_fullname', 'matric_number',
+                'certcode') and student is not None:
+                value = getattr(student, name, None)
+        return ExporterBase().mangle_value(value, name, context=context)
+
+
Index: main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/tests/test_export.py
===================================================================
--- main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/tests/test_export.py	(revision 18339)
+++ main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/tests/test_export.py	(revision 18340)
@@ -8,5 +8,6 @@
 from kofacustom.unidel.utils.utils import CustomKofaUtils
 from kofacustom.unidel.students.export import (
-    CustomStudentExporter, CustomStudentPaymentExporter)
+    CustomStudentExporter, CustomStudentPaymentExporter,
+    OutstandingCourses2Exporter)
 from kofacustom.unidel.testing import FunctionalLayer
 
@@ -113,2 +114,27 @@
             )
         return
+
+class OutstandingCourses2ExporterTest(StudentImportExportSetup):
+
+    layer = FunctionalLayer
+
+    def setUp(self):
+        super(OutstandingCourses2ExporterTest, self).setUp()
+        self.setup_for_export()
+        return
+
+    def test_export_all(self):
+        # we can really export all course tickets
+        # set values we can expect in export file
+        self.setup_student(self.student)
+        self.student['studycourse']['100']['CRS1'].course_category = 'C'
+        exporter = OutstandingCourses2Exporter()
+        exporter.export_all(self.app, self.outfile)
+        result = open(self.outfile, 'rb').read()
+        self.assertEqual(
+            result,
+            'student_id,matric_number,certcode,display_fullname,code,'
+            'course_category,remark\r\n'
+            'A111111,234,CERT1,"TESTER, Anna M.",CRS1,C,nottaken\r\n'
+            )
+        return
Index: main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/utils.py
===================================================================
--- main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/utils.py	(revision 18339)
+++ main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/utils.py	(revision 18340)
@@ -33,4 +33,34 @@
         return True
     return False
+
+    #: A tuple containing all exporter names referring to students or
+    #: subobjects thereof.
+    STUDENT_EXPORTER_NAMES = (
+            'students',
+            'studentstudycourses',
+            'studentstudycourses_1',
+            #'studentstudycourses_2',
+            'studentstudylevels',
+            #'studentstudylevels_1',
+            #'studentstudylevels_2',
+            'coursetickets',
+            #'coursetickets_1',
+            #'coursetickets_2',
+            'studentpayments',
+            'bedtickets',
+            'trimmed',
+            'outstandingcourses',
+            'unpaidpayments',
+            'sfpaymentsoverview',
+            'sessionpaymentsoverview',
+            'studylevelsoverview',
+            'combocard',
+            'bursary',
+            'accommodationpayments',
+            'transcriptdata',
+            'trimmedpayments',
+            'outstandingcourses_2'
+            )
+
 
 class CustomStudentsUtils(NigeriaStudentsUtils):
