Changeset 398

Timestamp:

21 Aug 2006, 14:29:27 (18 years ago)

Author:

joachim

Message:

import of full_time_students_results

Location:

WAeUP_SRP/trunk

Files:

• Academics.py (modified) (1 diff)
• Students.py (modified) (8 diffs)
• profiles/default/layouts.xml (modified) (1 diff)
• profiles/default/layouts/course_results.xml (added)
• profiles/default/schemas/course_results.xml (modified) (1 diff)
• profiles/default/types/StudentsFolder.xml (modified) (2 diffs)

WAeUP_SRP/trunk/Academics.py

@@ -616 +616 @@
     portal_type = meta_type
     security = ClassSecurityInfo()
+    def getCourseEntry(self,cid):
+        res = self.portal_catalog({'meta_type': "Course",
+                                           'id': cid})
+        if res:
+            return res[-1]
+        else:
+            return None
+
+    security.declareProtected(View,"Title")
+    def Title(self):
+        """compose title"""
+        ce = self.getCourseEntry(self.id.upper())
+        if ce:
+            return "%s" % ce.Title
+        return "No such course"
 
 InitializeClass(CourseTicket)

WAeUP_SRP/trunk/Students.py

@@ -19 +19 @@
 p_home = Globals.package_home(globals())
 i_home = Globals.INSTANCE_HOME
+MAX_TRANS = 1000
 
 class StudentsFolder(CPSDocument): ###(
@@ -32 +33 @@
         """load Fulltime Studentdata from CSV values"""
         #return
+        import transaction
+        tr_count = 0
         name = 'short_full_time'
         no_import = False
@@ -64 +67 @@
                 continue
             certcode = makeCertificateCode(student.get('CourseMajor'))
-            if sid in students_added:
-                em = 'Student with ID %(MatricNo)s %(fullname)s already exists in this import\n' % student
-                logger.info(em)
-                no_import.write(em)
-                no_import.write('"%(MatricNo)s","%(EntryRegNo)s","%(CurrentSession)s","%(StudentLevel)s","%(fullname)s","%(FirstName)s","%(MiddleName)s","%(Lastname)s","%(FormerSurname)s","%(Sex)s","%(Nationality)s","%(State)s","%(LGA)s","%(PermanentAddress)s","%(PermanentAddressCity)s","%(CampusAddress)s","%(PhoneNumber)s","%(Emailaddress)s","%(Mode)s","%(CourseMajor)s","%(Faculty)s","%(Dept)s"\n' % student)
-                continue
+##            if sid in students_added:
+##                em = 'Student with ID %(MatricNo)s %(fullname)s already exists in this import\n' % student
+##                logger.info(em)
+##                no_import.write(em)
+##                no_import.write('"%(MatricNo)s","%(EntryRegNo)s","%(CurrentSession)s","%(StudentLevel)s","%(fullname)s","%(FirstName)s","%(MiddleName)s","%(Lastname)s","%(FormerSurname)s","%(Sex)s","%(Nationality)s","%(State)s","%(LGA)s","%(PermanentAddress)s","%(PermanentAddressCity)s","%(CampusAddress)s","%(PhoneNumber)s","%(Emailaddress)s","%(Mode)s","%(CourseMajor)s","%(Faculty)s","%(Dept)s"\n' % student)
+##                continue
             s = studs.get(sid,None)
             if certcode not in certs.keys():
@@ -92 +95 @@
                 s = getattr(self,sid)
                 students_added.append(sid)
+                studs[sid] = s
                 s.invokeFactory('StudentPersonal','personal')
                 sp = s.personal
@@ -153 +157 @@
                 no_import.write(em)
                 no_import.write('"%(MatricNo)s","%(EntryRegNo)s","%(CurrentSession)s","%(StudentLevel)s","%(fullname)s","%(FirstName)s","%(MiddleName)s","%(Lastname)s","%(FormerSurname)s","%(Sex)s","%(Nationality)s","%(State)s","%(LGA)s","%(PermanentAddress)s","%(PermanentAddressCity)s","%(CampusAddress)s","%(PhoneNumber)s","%(Emailaddress)s","%(Mode)s","%(CourseMajor)s","%(Faculty)s","%(Dept)s"\n' % student)
+            if tr_count > MAX_TRANS:
+                #transaction.commit()
+                #em = '>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>Transaction commited\n' % student
+                logger.info(em)
+                tr_count = 0
+            tr_count += 1
         return self.students.academics_contents()
     ###)
 
-    security.declareProtected(ModifyPortalContent,"loadFullTimeStudentsResultsFromCSV")
+    security.declareProtected(ModifyPortalContent,"loadFullTimeStudentsResultsFromCSV") ###(
     def loadFullTimeStudentsResultsFromCSV(self):
         """load Fulltime Studentdata from CSV values"""
         #return
-        name = 'short_full_time_results_2004_2005.csv'
+        import transaction
+        tr_count = 0
+        name = 'short_full_time_results_2004_2005'
         no_import = False
         if not no_import:
@@ -177 +189 @@
         for s in l:
             students[s.id] = s.getObject()
-        courses = self.portal_catalog({'meta_type': "Course"})
+        l = self.portal_catalog({'meta_type': "Course"})
+        courses = {}
+        for c in l:
+            courses[c.id] = c.getObject()
         for result in results:
             sid = result.get('Matnumber')
             if sid not in students.keys():                
-                em = 'Student with ID %(Matnumber)s not found\n' % student
-                logger.info(em)
-                no_import.write(em)
-                no_import.write('"%(Matnumber)s","%(CosCode)s","%(Ansbook)s","%(CosStuatus)s","%(Session)s","%(Mat_Cos)s","%(Score)s","%(CarryLevel)s","%(Grade)s","%(Weight)s","%(Semster)s","%(Verdict)s","%(Level)s","%(id)s","%(GPA)s"\n' % student)
+                em = 'Student with ID %(Matnumber)s not found\n' % result
+                logger.info(em)
+                no_import.write(em)
+                no_import.write('"%(Matnumber)s","%(CosCode)s","%(Ansbook)s","%(CosStuatus)s","%(Session)s","%(Mat_Cos)s","%(Score)s","%(CarryLevel)s","%(Grade)s","%(Weight)s","%(Semster)s","%(Verdict)s","%(Level)s","%(id)s","%(GPA)s"\n' % result)
                 continue
-            if student.get('CosCode') not in courses:
-                em = 'Course with ID %(CosCode)s not found\n' % student
-                logger.info(em)
-                no_import.write(em)
-                no_import.write('"%(Matnumber)s","%(CosCode)s","%(Ansbook)s","%(CosStuatus)s","%(Session)s","%(Mat_Cos)s","%(Score)s","%(CarryLevel)s","%(Grade)s","%(Weight)s","%(Semster)s","%(Verdict)s","%(Level)s","%(id)s","%(GPA)s"\n' % student)
+            course = result.get('CosCode')
+            if course not in courses.keys():
+                em = 'Course with ID %(CosCode)s not found\n' % result
+                logger.info(em)
+                no_import.write(em)
+                no_import.write('"%(Matnumber)s","%(CosCode)s","%(Ansbook)s","%(CosStuatus)s","%(Session)s","%(Mat_Cos)s","%(Score)s","%(CarryLevel)s","%(Grade)s","%(Weight)s","%(Semster)s","%(Verdict)s","%(Level)s","%(id)s","%(GPA)s"\n' % result)
                 continue
-            level = student.get('Level')
+            level = result.get('Level')
             try: 
                 int(level)
             except:
-                em = 'Result for Student with ID %(Matnumber)s Course %(CosCode)s Level is empty\n' % student
-                logger.info(em)
-                no_import.write(em)
-                no_import.write('"%(Matnumber)s","%(CosCode)s","%(Ansbook)s","%(CosStuatus)s","%(Session)s","%(Mat_Cos)s","%(Score)s","%(CarryLevel)s","%(Grade)s","%(Weight)s","%(Semster)s","%(Verdict)s","%(Level)s","%(id)s","%(GPA)s"\n' % student)
+                em = 'Result for result with ID %(Matnumber)s Course %(CosCode)s Level is empty\n' % result
+                logger.info(em)
+                no_import.write(em)
+                no_import.write('"%(Matnumber)s","%(CosCode)s","%(Ansbook)s","%(CosStuatus)s","%(Session)s","%(Mat_Cos)s","%(Score)s","%(CarryLevel)s","%(Grade)s","%(Weight)s","%(Semster)s","%(Verdict)s","%(Level)s","%(id)s","%(GPA)s"\n' % result)
                 continue
             sf = students.get(sid)
@@ -206 +222 @@
             if l is None:
                 #self.log('Creating Department %(DeptCode)s = %(Description)s' % dep)
-                logger.info('Creating Level %(StudentLevel)s for %(fullname)s' % student)
+                logger.info('Creating Level %(Level)s for %(Matnumber)s' % result)
                 sc.invokeFactory('StudyLevel', level)
                 l = getattr(sc, level)
@@ -216 +232 @@
                 second_s = getattr(l,'second')
                 second_s.getContent().edit(mapping={'Title': 'Second Semester'})
-            snr = student.get('Semester')
+            snr = result.get('Semester')
             semester = getattr(l,'first')
-            if snr == "1":
+            if snr == "2":
                 semester = getattr(l,'second')
+            logger.info('Creating CourseTicket %(CourseTicket)s in Level %(Level)s for %(Matnumber)s' % result)
+            semester.invokeFactory('CourseTicket',course)
+            ct = getattr(semester,course)
+            d = {}
+            d['ansbook'] = result.get('Ansbook')
+            d['status'] = result.get('CosStuatus')
+            d['score'] = result.get('Score')
+            d['carry_level'] = result.get('CarryLevel')
+            d['grade'] = result.get('Grade')
+            d['weight'] = result.get('Weight')
+            d['verdict'] = result.get('Verdict')
+            d['import_id'] = result.get('id')
+            gpa = result.get('GPA').replace(',','.')
+            d['gpa'] = float(gpa) 
+            ct.getContent().edit(mapping = d)
+            if tr_count > MAX_TRANS:
+                transaction.commit()
+                tr_count = 0
+            tr_count += 1
+        return self.students.academics_contents()
             
-                
-                
-
+###)
+
+            
     security.declareProtected(View,"Title")
     def Title(self):

WAeUP_SRP/trunk/profiles/default/layouts.xml

@@ -13 +13 @@
  <object name="clearence" meta_type="CPS Layout"/>
  <object name="course" meta_type="CPS Layout"/>
+ <object name="course_results" meta_type="CPS Layout"/>
  <object name="department" meta_type="CPS Layout"/>
  <object name="faculty" meta_type="CPS Layout"/>

WAeUP_SRP/trunk/profiles/default/schemas/course_results.xml

@@ -1 +1 @@
 <?xml version="1.0"?>
 <object name="course_results" meta_type="CPS Schema">
+ <field name="ansbook" meta_type="CPS String Field"/>
+ <field name="carry_level" meta_type="CPS String Field"/>
+ <field name="gpa" meta_type="CPS Float Field"/>
  <field name="grade" meta_type="CPS String Field"/>
- <field name="points" meta_type="CPS Int Field"/>
+ <field name="import_id" meta_type="CPS String Field"/>
+ <field name="score" meta_type="CPS Int Field"/>
+ <field name="status" meta_type="CPS String Field"/>
+ <field name="verdict" meta_type="CPS String Field"/>
+ <field name="weight" meta_type="CPS String Field"/>
 </object>

WAeUP_SRP/trunk/profiles/default/types/StudentsFolder.xml

@@ -8 +8 @@
  <property name="product">WAeUP_SRP</property>
  <property name="factory">addStudentsFolder</property>
- <property name="immediate_view">folder_view</property>
+ <property name="immediate_view">academics_contents</property>
  <property name="global_allow">True</property>
  <property name="filter_content_types">True</property>
@@ -70 +70 @@
     url_expr="string:${object_url}/loadFullTimeStudentsFromCSV"
     visible="True"/>
+ <action title="Import FtS Results" action_id="import_fulltime_students"
+    category="import" condition_expr=""
+    url_expr="string:${object_url}/loadFullTimeStudentsResultsFromCSV"
+    visible="True"/>
 </object>