Index: /WAeUP_SRP/trunk/WAeUPTool.py
===================================================================
--- /WAeUP_SRP/trunk/WAeUPTool.py	(revision 1249)
+++ /WAeUP_SRP/trunk/WAeUPTool.py	(revision 1250)
@@ -71,4 +71,13 @@
     ###)
 
+    security.declareProtected(ModifyPortalContent,'getCredential')
+    def getCredential(self,student_id):
+        "return a student password"
+        student_entry = getattr(self.portal_directories.students,student_id,None)
+        if student_entry is None:
+            return None
+        else:
+            return student_entry.password
+
     security.declareProtected(ModifyPortalContent,'createOne') ###(
     def createOne(self,students_folder,student_brain,letter,commit=False):
@@ -157,9 +166,24 @@
             logger.info(em)
         level = student.Level
+        validlevel = False
         try:
             int(level)
+            validlevel = True
         except:
             em = '"%(matric_no)s","invalid Level","%(Level)s"' % student
             logger.info(em)
+        if not validlevel:
+            erg = self.results_import(matric_no = student.matric_no)
+            level = 'xxx'
+            if erg:
+                level = erg[0].Level
+            try:
+                int(level)
+                em = '"%s","fixed Level from results_import","%s"' % (student.matric_no,erg[0].Level)
+                logger.info(em)
+                validlevel = True
+            except:
+                em = '"%s","invalid Level in results_import","%s"' % (student.matric_no,erg[0].Level)
+                logger.info(em)
         matric_no = student.matric_no
         sid = student_id
Index: /WAeUP_SRP/trunk/skins/waeup_student/fixLevel.py
===================================================================
--- /WAeUP_SRP/trunk/skins/waeup_student/fixLevel.py	(revision 1250)
+++ /WAeUP_SRP/trunk/skins/waeup_student/fixLevel.py	(revision 1250)
@@ -0,0 +1,47 @@
+## 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
+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
+
+if str(member) not in ('admin','joachim'):
+    return 
+count = 0
+#from Products.zdb import set_trace;set_trace()
+values = scat.uniqueValuesFor('level')
+#query = ~ In("level",('100', '200', '300', '400', '500', '600'))
+query = In("level",('',))
+res = aq_students(query)
+#from Products.zdb import set_trace;set_trace()
+modified = []
+modified.append("%d to change" % len(res))
+list = []
+for sbrain in res:
+    list.append((sbrain.id,sbrain.matric_no))
+for id,m in list:
+    erg = context.results_import(matric_no=m)
+    if erg and erg[0].Level:
+        context.students_catalog.modifyRecord(id = id, level=erg[0].Level)
+        modified.append("%s, %s" % (id,m))
+    else:
+        modified.append("no results for %s, %s" % (id,m))
+return '\n'.join(modified)
