Index: /WAeUP_SRP/base/skins/waeup_utilities/ti_391_resolve.py
===================================================================
--- /WAeUP_SRP/base/skins/waeup_utilities/ti_391_resolve.py	(revision 2605)
+++ /WAeUP_SRP/base/skins/waeup_utilities/ti_391_resolve.py	(revision 2605)
@@ -0,0 +1,75 @@
+## Script (Python) "ti_391_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_391_resolve')
+from Products.AdvancedQuery import Eq, Between, Le,In
+aq_portal = context.portal_catalog_real.evalAdvancedQuery
+
+request = context.REQUEST
+session = request.SESSION
+response = request.RESPONSE
+setheader = request.RESPONSE.setHeader
+def rwrite(s):
+    response.setHeader('Content-type','text/html; charset=ISO-8859-15')
+    response.write("%s<br>\n\r" % s)
+
+#logger.info('')
+
+query = Eq('portal_type','StudentPersonal')
+#brains = context.students_catalog()
+brains = aq_portal(query)
+total = len(brains)
+#rwrite("found %d " % total)
+no_email = 0
+edited = 0
+count = 0
+logger.info('started for %d' % total)
+for brain in brains:
+    count += 1
+    doc = brain.getObject().getContent()
+    if doc.email and doc.email.find('@') < 0:
+        no_email += 1
+        #rwrite ("%s email = %s" % (brain.getId,doc.email))
+        try:
+            app_doc = getattr(brain.getObject().aq_parent,'application').getContent()
+            logger.info("setting email of %s from %s to %s" % (brain.getPath().split('/')[-2],
+                                                               doc.email,
+                                                               app_doc.app_email))
+            doc.edit(mapping={'email': app_doc.app_email})
+            edited += 1
+        except:
+            logger.info("failed to set email of %s from %s" % (brain.getPath().split('/')[-2],
+                                                               doc.email,
+                                                               ))
+            pass
+    else:
+        #rwrite ("%s email = %s" % (brain.getPath(),doc.email))
+        pass
+    # if count > 2000:
+    #     break
+logger.info('finished checked %d edited %d' % (count,
+                                               edited,))
+
