Index: /WAeUP_SRP/trunk/skins/waeup_utilities/ti_306_resolve.py
===================================================================
--- /WAeUP_SRP/trunk/skins/waeup_utilities/ti_306_resolve.py	(revision 2003)
+++ /WAeUP_SRP/trunk/skins/waeup_utilities/ti_306_resolve.py	(revision 2003)
@@ -0,0 +1,68 @@
+## Script (Python) "ti_306_resolve"
+##bind container=container
+##bind context=context
+##bind namespace=
+##bind script=script
+##bind subpath=traverse_subpath
+##parameters=
+##title=
+##
+# $Id: ti_294_resolve.py 1983 2007-07-04 07:32:36Z henrik $
+"""
+"""
+try:
+    from Products.zdb import set_trace
+except:
+    def set_trace():
+        pass
+import logging
+logger = logging.getLogger('Skins.ti_294_resolve')
+from Products.AdvancedQuery import Eq, Between, Le,In,MatchGlob
+aq_pins = context.portal_pins.evalAdvancedQuery
+pins = context.portal_pins()
+scat = context.students_catalog
+
+request = context.REQUEST
+session = request.SESSION
+response = request.RESPONSE
+setheader = request.RESPONSE.setHeader
+students = context.portal_url.getPortalObject().campus.students
+
+#query = Eq('pin','APP')
+#brains = aq_pins(query)
+#total = len(brains)
+#logger.info('found %d APP PINs' % total)
+
+count = 0
+commit_after = 100
+todelete = []
+
+total = len(pins)
+
+for brain in pins:
+    if not brain.pin.startswith('APP') or not brain.student:
+        continue
+
+    application = None
+    sbrains = scat(jamb_reg_no = brain.student.upper())
+    if len(sbrains)>0:
+        sbrain = sbrains[0]
+    else:
+        logger.info('%s, %s' % (brain.student,brain.pin))
+        continue
+    try:
+        application = getattr(getattr(students,sbrain.id),'application')
+    except:
+        logger.info('%s, application does not exist' % (brain.student))
+        continue
+    application.getContent().edit(mapping={'app_ac_pin ': brain.pin})
+    logger.info('%s, %s replaced' % (brain.student,brain.pin))
+    count += 1
+    if count and not count % commit_after:
+        context.waeup_tool.doCommit()
+        logger.info("committed %d transactions" % commit_after)
+        return
+logger.info('finished for %d of %d' % (count,total))
+return
+
+
