Index: /WAeUP_SRP/base/skins/waeup_utilities/removeImagesFromZODB.py
===================================================================
--- /WAeUP_SRP/base/skins/waeup_utilities/removeImagesFromZODB.py	(revision 2349)
+++ /WAeUP_SRP/base/skins/waeup_utilities/removeImagesFromZODB.py	(revision 2349)
@@ -0,0 +1,75 @@
+## Script (Python) "writeStudentImages"
+##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.removeImagesFromZODB')
+
+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('')
+students = context.students_catalog()
+starttime = DateTime.DateTime()
+logger.info("Start removing %d student images" % len(students))
+count = 0
+chunk = 50
+stool = context.portal_schemas
+schemas = ['student_application',
+           'student_clearance',
+          ]
+students_folder = context.portal_url.getPortalObject().campus.students
+image_keys = {}
+for schema_id in schemas:
+    schema = getattr(stool,schema_id)
+    image_keys[schema_id] = [key for key in schema.keys() 
+                             if schema[key].meta_type == "CPS Image Field"]
+for student in students:
+    count += 1
+    if count and not count % chunk:
+        logger.info("removed %d of %d student images " % (count,len(students)))
+        context.waeup_tool.doCommit()
+    for schema_id in schemas:
+        try:
+            doc_id = getattr(getattr(students_folder,student.id),
+                          schema_id[len('student_'):]).getContent().getId()
+        except:
+            continue
+        doc = context.portal_repository[doc_id]
+        ids = [key for key in image_keys[schema_id]
+               if key in doc.objectIds()]
+        if not ids:
+            continue
+        try:
+            doc.manage_delObjects(ids)
+            #logger.info("removed %s images " % (student.id))
+        except:
+            set_trace()
+            logger.info("!!!!!!!could not remove  %s images " % (student.id))
+logger.info("Finished removing %d student images" % len(students))
