Index: WAeUP_SRP/trunk/skins/waeup_utilities/ti_229_resolve.py
===================================================================
--- WAeUP_SRP/trunk/skins/waeup_utilities/ti_229_resolve.py	(revision 1879)
+++ WAeUP_SRP/trunk/skins/waeup_utilities/ti_229_resolve.py	(revision 1879)
@@ -0,0 +1,82 @@
+## Script (Python) "ti_229_resolve"
+##bind container=container
+##bind context=context
+##bind namespace=
+##bind script=script
+##bind subpath=traverse_subpath
+##parameters=
+##title=
+##
+# $Id$
+"""
+resolve ticket #229
+"""
+try:
+    from Products.zdb import set_trace
+except:
+    def set_trace():
+        pass
+import logging
+#>>>>>>>>>>>>>>>><
+logger = logging.getLogger('Skins.ti_229_resolve')
+# logger.info('already done on  by joachim')
+# return
+#<<<<<<<<<<<<<<<<<
+from Products.AdvancedQuery import Eq, Between, Le,In
+aq_students = context.students_catalog.evalAdvancedQuery
+
+request = context.REQUEST
+session = request.SESSION
+response = request.RESPONSE
+setheader = request.RESPONSE.setHeader
+students = context.portal_url.getPortalObject().campus.students
+#from string import Template
+def rwrite(s):
+    response.setHeader('Content-type','text/html; charset=ISO-8859-15')
+    response.write("%s<br>\n\r" % s)
+
+logger.info('ti_229 started')
+
+query = In('level',('0',''))
+brains = aq_students(query)
+total = len(brains)
+logger.info('found %d students' % total)
+count = 0
+commit_after = 5
+for brain in brains:
+    try:
+        study_course = getattr(getattr(students,brain.id),'study_course')
+    except:
+        logger.info('study_course of %s not found' % brain.id)
+        continue
+    count += 1
+    s_results = context.results_import(matric_no = brain.matric_no)
+    if s_results:
+        lnr = self.getLevelFromResultsCosCode(s_results)
+        level = "%d00" % lnr
+        verdict,eligible = self.getVerdict(s_results[0].Verdict)
+        if eligible:
+            level = "%d00" % (lnr + 1)
+    else:
+        logger.info('matric_no %s not found in results_import' % brain.matric_no)
+        continue
+    study_course.getContent().edit(mapping={'current_level': level,
+                                            'current_verdict': verdict,
+                                           }
+                                  )
+    try:
+        study_course = getattr(getattr(students,brain.id),'study_course')
+    except:
+        logger.info('study_course of %s not found' % brain.id)
+        continue
+    study_course.getContent().edit(mapping={'current_mode': '%s_ft' % brain.entry_mode.lower()})
+    logger.info('%d of %d changed level,verdict of %s to %s,%s'  % (count,
+                                                                    total,
+                                                                    brain.id,
+                                                                    level,
+                                                                    verdict,
+                                                                   ))
+    if not count % commit_after:
+        context.waeup_tool.doCommit()
+        logger.info("committed %d transactions" % commit_after)
+logger.info('ti_229 finished for %d of %d' % (count,total))
