Index: /WAeUP_SRP/base/WAeUPTables.py
===================================================================
--- /WAeUP_SRP/base/WAeUPTables.py	(revision 3601)
+++ /WAeUP_SRP/base/WAeUPTables.py	(revision 3602)
@@ -1611,4 +1611,52 @@
 ###)
 
+    def getAllCourses(self,student_id): ###(
+        query = Eq('student_id',student_id)
+        course_results = self.course_results.evalAdvancedQuery(query)
+        for brain in course_results:
+            d = {}
+
+            for field in self.schema():
+                d[field] = getattr(brain,field,'')
+
+            d['weight'] = ''
+            d['grade'] = ''
+            d['score'] = ''
+
+            if str(brain.credits).isdigit():
+                credits = int(brain.credits)
+                score = getattr(brain,'score',0)
+                if score and str(score).isdigit() and int(score) > 0:
+                    score = int(score)
+                    grade,weight = self.getGradesFromScore(score)
+                    d['weight'] = weight
+                    d['grade'] = grade
+                    d['score'] = score
+            d['coe'] = ''
+            if brain.core_or_elective:
+                d['coe'] = 'Core'
+            elif brain.core_or_elective == False:
+                d['coe'] = 'Elective'
+            id = code = d['id'] = brain.code
+            d['code'] = code
+            res = self.courses_catalog.evalAdvancedQuery(Eq('code',code))
+            if res:
+                course = res[0]
+                d['title'] = course.title
+                # The courses_catalog contains strings and integers in its semester field.
+                # Maybe this can be fixed by reindexing the catalog. The schema of course says 'CPS Int Field'.
+                d['semester'] = str(course.semester)
+            else:
+                d['title'] = "Course has been removed from course list"
+                d['semester'] = ''
+            if brain.carry_over:
+                d['coe'] = 'CO'
+            courses.append(d)
+        return courses
+    ###)
+
+InitializeClass(CourseResults)
+###)
+
 class OnlinePaymentsImport(WAeUPTable): ###(
 
Index: /WAeUP_SRP/unilorin/waeup_custom/getTranscriptInfo.py
===================================================================
--- /WAeUP_SRP/unilorin/waeup_custom/getTranscriptInfo.py	(revision 3602)
+++ /WAeUP_SRP/unilorin/waeup_custom/getTranscriptInfo.py	(revision 3602)
@@ -0,0 +1,59 @@
+## Script (Python) "getTranscriptInfo"
+##bind container=container
+##bind context=context
+##bind namespace=
+##bind script=script
+##bind subpath=traverse_subpath
+##parameters=student=None
+##title=
+##
+# $Id: getStudyLevelInfo.py 2760 2007-11-26 07:39:15Z henrik $
+"""
+return Info about the Studylevel
+try:
+    from Products.zdb import set_trace
+except:
+    def set_trace():
+        pass
+"""
+
+info = context.waeup_tool.getAccessInfo(context)
+student_id = info['student_id']
+if student_id is None:
+    return None
+
+mtool = context.portal_membership
+member = mtool.getAuthenticatedMember()
+member_id = str(member)
+
+course_results = context.course_results
+request = context.REQUEST
+response = request.RESPONSE
+import logging
+logger = logging.getLogger('Skins.getTranscriptInfo')
+
+
+info['is_so'] = is_so = info['is_sectionofficer']
+info['student'] = student = context.students_catalog.getRecordByKey(student_id)
+info['review_state'] = review_state = student.review_state
+school_fee_paid =  review_state == 'school_fee_paid'
+info['has_verdict'] = has_verdict = level_doc.verdict
+
+info['verdict'] = context.portal_vocabularies.verdicts.get(level_doc.verdict).upper()
+info['session'] = context.portal_vocabularies.sessions.get(level_doc.session)
+
+cert_id = student.course
+info['cert_id'] = cert_id
+total_credits,gpa,carry_overs,normal1,normal2,normal3 = course_results.getCourses(student_id,level_id)
+info['total_credits'] = total_credits
+
+current_session = student.session
+info['gpa'] = gpa
+
+if gpa and total_credits:
+    info['gpa'] = "%4.2f" % (float(gpa)/int(total_credits))
+
+info['carry_overs'] = carry_overs
+
+
+return info
