Index: /WAeUP_SRP/base/skins/waeup_utilities/ti_513_resolve.py
===================================================================
--- /WAeUP_SRP/base/skins/waeup_utilities/ti_513_resolve.py	(revision 3371)
+++ /WAeUP_SRP/base/skins/waeup_utilities/ti_513_resolve.py	(revision 3371)
@@ -0,0 +1,75 @@
+## Script (Python) "ti_513_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_513_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
+count = 0
+found = 0
+commit_after = 100
+logger.info('start')
+students = context.students_catalog()
+wrong = {}
+missing_courses = []
+wrong_starts = []
+for student in students:
+    count += 1
+    if student.jamb_reg_no.endswith('/07'):
+        pos = 0
+        if student.jamb_reg_no[:5].isalpha():
+            pos = 5
+        elif student.jamb_reg_no[:4].isalpha():
+            if student.jamb_reg_no[:4] != 'UBNO': 
+                pos = 4
+        if pos:
+            d = {}
+            d['student_id'] = student.id
+            d['jamb_reg_no_old'] = student.jamb_reg_no
+            d['jamb_reg_no'] = student.jamb_reg_no[:3]+student.jamb_reg_no[pos:]
+            #set_trace()
+            if student.jamb_reg_no[:pos] not in wrong_starts:
+                wrong_starts += student.jamb_reg_no[:pos],
+            wrong[student.id] = d
+logger.info('found %d wrong of %d' % (len(wrong),count))
+count = 0
+for student_id,d in wrong.items():
+    try:
+        getattr(getattr(students_folder,student_id),'application').getContent().edit(mapping=d)
+        logger.info("%(student_id)s changed jamb_reg_no from %(jamb_reg_no_old)s to %(jamb_reg_no)s" % d)
+    except:
+        logger.info("%(student_id)s change failed")
+    if count and not count % commit_after:
+        context.waeup_tool.doCommit()
+        logger.info("committing %d of total %d" % (commit_after,count))
+    count += 1
+logger.info('finished')                    
