Index: /WAeUP_SRP/trunk/skins/waeup_utilities/fix_session_in_course_results.py
===================================================================
--- /WAeUP_SRP/trunk/skins/waeup_utilities/fix_session_in_course_results.py	(revision 5211)
+++ /WAeUP_SRP/trunk/skins/waeup_utilities/fix_session_in_course_results.py	(revision 5211)
@@ -0,0 +1,67 @@
+## Script (Python) "fix_session"
+##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',):
+    return
+
+
+import logging
+import DateTime
+logger = logging.getLogger('fix_session_in_course_results')
+from Products.AdvancedQuery import Eq, Between, Le,In
+
+course_results = context.course_results
+students = context.portal_url.getPortalObject().campus.students
+
+
+brains = course_results()
+total = len(brains)
+edited = 0
+for brain in brains:
+    if not students.hasObject(brain.student_id):
+        logger.info("no student %s" % student_id)
+        continue
+    student = getattr(students, brain.student_id)        
+    if not student.hasObject("study_course"):
+        logger.info("%s: no study_course" % brain.student_id)
+        continue
+    study_course = student.study_course
+    if not study_course.hasObject(brain.level_id):
+        logger.info("%s: no level %s" % (brain.student_id,brain.level_id))
+        continue
+    level_obj = getattr(study_course, brain.level_id)    
+    level_doc = level_obj.getContent()   
+    session_id = level_doc.session
+    if len(session_id) == 9:
+        session_id = session_id[2:4]
+    elif len(session_id) != 2:
+        logger.info("invalid session %s in level %s for student %s" %
+                    (session_id,brain.level_id,brain.student_id))               
+        
+    if brain.session_id != session_id:
+        data = {}
+        old_session_id == brain.session_id
+        data['key'] = brain.key
+        data['session_id'] = session_id
+        course_results.modifyRecord(**data)
+        logger.info("%s: %s overwritten with %s" % (brain.key,old_session_id,session_id))
+        edited += 1
+        
+logger.info("edited %d course results of %s total" % (edited,total))
