Changeset 457 for WAeUP_SRP/trunk

Timestamp:

31 Aug 2006, 13:23:15 (18 years ago)

Author:

joachim

Message:

added JAMB import

Location:

WAeUP_SRP/trunk

Files:

• Students.py (modified) (1 diff)
• profiles/default/types/StudentsFolder.xml (modified) (1 diff)

WAeUP_SRP/trunk/Students.py

@@ -273 +273 @@
 ###)
 
+    security.declareProtected(ModifyPortalContent,"loadJAMBFromCSV")###(
+    def loadJAMBFromCSV(self):
+        """load JAMB data from CSV values"""
+        #return
+        students_folder = self.portal_catalog({'meta_type': 'StudentsFolder'})[-1].getObject()
+        import transaction
+        tr_count = 0
+        name = 'SampleJAMBDataII'
+        no_import = False
+        if not no_import:
+            no_import = open("%s/import/%s_not_imported.csv" % (i_home,name),"w")
+            no_import.write('REG-NO,NAME,SEX,STATE,LGA,ENG-SCORE,SUBJ1,SUBJ1-SCORE,SUBJ2,SUBJ2-SCORE,SUBJ3,SUBJ3-SCORE,AGGREGATE,UNIV1,FACULTY1,COURSE1,UNIV2,FACULTY2,COURSE2')
+        logger = logging.getLogger('%s_import' % name)
+        logger.info('Start loading from %s.csv' % name)
+        try:
+            result = csv.DictReader(open("%s/import/%s.csv" % (i_home,name),"rb"))
+        except:
+            logger.error('Error reading %s.csv' % name)
+            return
+        for jamb in result:
+            logger.info('processing %(REG-NO)s,%(NAME)s,%(SEX)s,%(STATE)s,%(LGA)s,%(ENG-SCORE)s,%(SUBJ1)s,%(SUBJ1-SCORE)s,%(SUBJ2)s,%(SUBJ2-SCORE)s,%(SUBJ3)s,%(SUBJ3-SCORE)s,%(AGGREGATE)s,%(UNIV1)s,%(FACULTY1)s,%(COURSE1)s,%(UNIV2)s,%(FACULTY2)s,%(COURSE2)s\n' % jamb)
+            jamb_reg_no = jamb.get('REG-NO')
+            res = self.portal_catalog({'meta_type': "StudentAdmission",
+                                     'jamb_reg_no': jamb_reg_no })
+            if res:
+                em = 'Student with REG-NO %(REG-NO)s already exists\n' % jamb
+                logger.info(em)
+                no_import.write(em)
+                no_import.write('%(REG-NO)s,%(NAME)s,%(SEX)s,%(STATE)s,%(LGA)s,%(ENG-SCORE)s,%(SUBJ1)s,%(SUBJ1-SCORE)s,%(SUBJ2)s,%(SUBJ2-SCORE)s,%(SUBJ3)s,%(SUBJ3-SCORE)s,%(AGGREGATE)s,%(UNIV1)s,%(FACULTY1)s,%(COURSE1)s,%(UNIV2)s,%(FACULTY2)s,%(COURSE2)s\n' % jamb)
+                continue
+            sid = generateStudentId()
+            #self.log('Creating Faculty %(id)s = %(Title)s' % faculty)
+            not_created = True
+            while not_created:
+                try:
+                    students_folder.invokeFactory('Student', sid)
+                    not_created = False
+                except BadRequest:
+                    sid = generateStudentId()
+            logger.info('%(tr_count)s: Creating Student with ID %(sid)s REG-NO %(jamb_reg_no)s ' % vars())
+            s = getattr(self,sid)
+            s.invokeFactory('StudentAdmission','admission')
+            da = {'Title': 'Admission Data'}
+            s.invokeFactory('StudentPersonal','personal')
+            sp = s.personal
+            d = {'Title': 'Personal Data'}
+            s.invokeFactory('StudentClearance','clearance')
+            sc = s.clearance
+            dc = {'Title': 'Clearance Data'}
+            da["jamb_reg_no"] = jamb.get("REG-NO")
+            da["jamb_lastname"] = jamb.get("NAME")
+            d["lastname"] = jamb.get("NAME")
+            da["jamb_sex"] = jamb.get("SEX")
+            da["jamb_state"] = jamb.get("STATE")
+            da["jamb_lga"] = jamb.get("LGA")
+            da["jamb_score"] = jamb.get("AGGREGATE")
+            da["jamb_first_cos"] = jamb.get("COURSE1")
+            da["jamb_second_cos"] = jamb.get("COURSE2")
+            da["jamb_first_uni"] = jamb.get("UNIV1")
+            da["jamb_second_uni"] = jamb.get("UNIV2")
+            s.personal.getContent().edit(mapping=d)
+            s.admission.getContent().edit(mapping=da)
+        return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1'))
+    ###)
+                
+            
 
     security.declareProtected(View,"Title")

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

@@ -71 +71 @@
   <permission value="Modify portal content"/>
  </action>
+ <action title="JAMB"
+    action_id="import_fulltime_students_results" category="import"
+    condition_expr=""
+    url_expr="string:${object_url}/loadJAMBFromCSV"
+    visible="True">
+  <permission value="Modify portal content"/>
+ </action>
 </object>