Index: /WAeUP_SRP/base/skins/waeup_utilities/purgeCourseResultsObjects.py
===================================================================
--- /WAeUP_SRP/base/skins/waeup_utilities/purgeCourseResultsObjects.py	(revision 3128)
+++ /WAeUP_SRP/base/skins/waeup_utilities/purgeCourseResultsObjects.py	(revision 3128)
@@ -0,0 +1,82 @@
+## Script (Python) "purgeCourseResultsObjects"
+##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.purgeCourseResultsObjects')
+from Products.AdvancedQuery import Eq, Between, Le,In
+aq_results = context.course_results.evalAdvancedQuery 
+aq_portal = context.portal_catalog_real.evalAdvancedQuery
+#aq_students = context.students_catalog.evalAdvancedQuery
+students = context.portal_url.getPortalObject().campus.students
+request = context.REQUEST
+session = request.SESSION
+response = request.RESPONSE
+setheader = request.RESPONSE.setHeader
+
+results = aq_portal(Eq('portal_type','StudentCourseResult'))
+total = len(results)
+logger.info("found %d course result objects" % (total))
+count = 0
+moved = 0
+cocount = 0
+commit_after = 20
+current_student_id = ''
+current_level_id = ''
+to_move = []
+for result in results:
+    count += 1
+    pl = result.getPath().split('/')
+    student_id = pl[-4]
+    level_id = pl[-2]
+    if student_id != current_student_id:
+        if current_student_id:
+            to_move += (current_student_id,current_level_id),
+        current_student_id = student_id
+        current_level_id = level_id
+    elif level_id != current_level_id:
+        to_move += (current_student_id,current_level_id),
+        current_level_id = level_id
+for student_id,level_id in to_move:
+    try:
+        study_level = getattr(getattr(getattr(students,student_id),
+                                      "study_course")
+                              ,level_id)
+    except:
+        logger.info('%s level %s not found' % (student_id,level_id))
+        continue
+    context.course_results.moveResultsHere(study_level,student_id)
+    moved += 1
+    logger.info("moved results of student %s" % (student_id))
+    if moved and not moved % commit_after:
+        context.waeup_tool.doCommit()
+        logger.info("Committing %s transactions, total %s" % (commit_after,count))
+        # cocount += 1
+        # if cocount > 2:
+        #     break
+msg = "finished moving results of %d students" % (moved)
+logger.info(msg)
+#rwrite(msg)
+
+
