Index: /WAeUP_SRP/base/skins/waeup_utilities/ti_507_resolve.py
===================================================================
--- /WAeUP_SRP/base/skins/waeup_utilities/ti_507_resolve.py	(revision 3353)
+++ /WAeUP_SRP/base/skins/waeup_utilities/ti_507_resolve.py	(revision 3353)
@@ -0,0 +1,67 @@
+## Script (Python) "ti_507_resolve"
+##bind container=container
+##bind context=context
+##bind namespace=
+##bind script=script
+##bind subpath=traverse_subpath
+##parameters=
+##title=
+##
+# $Id$
+"""
+"""
+try:
+    from Products.zdb import set_trace
+except:
+    def set_trace():
+        pass
+
+mtool = context.portal_membership
+member = mtool.getAuthenticatedMember()
+if str(member) not in ('admin','joachim'):
+    return
+
+
+import logging
+import DateTime
+logger = logging.getLogger('Skins.ti_507_resolve')
+from Products.AdvancedQuery import Eq, Between, Le,In
+aq_students = context.students_catalog.evalAdvancedQuery
+aq_portal = context.portal_catalog_real.evalAdvancedQuery
+students_folder = context.portal_url.getPortalObject().campus.students
+
+request = context.REQUEST
+session = request.SESSION
+response = request.RESPONSE
+setheader = request.RESPONSE.setHeader
+logger.info('start')
+count = 0
+found = 0
+commit_after = 10000
+certificates = context.getCertificatesDict()
+students = context.students_catalog()
+wrong = []
+missing_courses = []
+wrong_modes = []
+for student in students:
+    count += 1
+    if student.entry_mode and student.course:
+        certificate = certificates.get(student.course,None)
+        if certificate is None:
+            if student.course not in missing_courses:
+                missing_courses += student.course,
+                logger.info('missing course %s' % student.course)
+            continue
+        entry_mode = student.entry_mode    
+        if entry_mode != certificate.get('study_mode','xxx'): 
+            wrong += student.id,
+            if student.entry_mode not in wrong_modes:
+                wrong_modes += student.entry_mode,
+                logger.info('%s != %s' % (student.entry_mode,
+                                          certificates[student.course]['study_mode']))
+    if wrong and not (len(wrong) % commit_after):
+        logger.info('found %d wrong of %d' % (len(wrong),count))
+        
+logger.info('wrong modes %s' % (', '.join(wrong_modes)))
+logger.info('missing courses %s' % (', '.join(missing_courses)))
+logger.info('found %d wrong of %d' % (len(wrong),count))
