Index: /WAeUP_SRP/trunk/skins/waeup_utilities/fixLevelFromResults.py
===================================================================
--- /WAeUP_SRP/trunk/skins/waeup_utilities/fixLevelFromResults.py	(revision 1387)
+++ /WAeUP_SRP/trunk/skins/waeup_utilities/fixLevelFromResults.py	(revision 1387)
@@ -0,0 +1,71 @@
+## Script (Python) "search_pins"
+##bind container=container
+##bind context=context
+##bind namespace=
+##bind script=script
+##bind subpath=traverse_subpath
+##parameters=REQUEST
+##title=
+##
+# $Id$
+"""
+list Students for ClearanceOfficers
+"""
+
+request = REQUEST
+request = context.REQUEST
+session = request.SESSION
+response = request.RESPONSE
+def rwrite(s):
+    response.setHeader('Content-type','text/html; charset=ISO-8859-15')
+    #response.setHeader('Content-length','%d' % (len(s)))
+    #response.setStatus('OK')
+    response.write(s)
+wftool = context.portal_workflow
+mtool = context.portal_membership
+member = mtool.getAuthenticatedMember()
+roles = member.getRolesInContext(context)
+retcat = context.returning_import
+rcat = context.results_import
+scat = context.students_catalog
+from Products.AdvancedQuery import Eq, Between, Le,In
+aq_students = context.students_catalog.evalAdvancedQuery
+students = context.portal_url.getPortalObject().campus.students
+
+if str(member) not in ('admin','joachim'):
+    return 
+count = 0
+lc = 1
+#from Products.zdb import set_trace;set_trace()
+res = scat()
+for sbrain in res:
+    ec = "x"
+    erg = context.results_import(matric_no=sbrain.matric_no)
+    if erg and erg[0].Level:
+        ec = "e"
+        level = erg[0].Level
+        for e in erg:
+            ec = "E"
+            if level != e.Level:
+                ec = "%s:%s!=%s<br />\n" % (sbrain.matric_no,level,e.Level) 
+        level = "%d" % (int(level) + 100)
+        context.students_catalog.modifyRecord(id = sbrain.id, level=level)
+        while True:
+            student = getattr(students,sbrain.id,None)
+            ec = "s"
+            if student is None:
+                break
+            ec = "S"
+            study_course = getattr(student,"study_course", None)
+            if study_course is None:
+                break
+            study_course.getContent().edit(mapping = {'current_level':level})
+            ec += "C"
+            break
+    rwrite(ec)
+    count += 1
+    if count > 60:
+        lc += 1
+        rwrite("<br />\n%3d " % lc)
+        count = 0
+rwrite("<br />\n Done" )
