Changeset 1756

Timestamp:

8 May 2007, 15:01:11 (18 years ago)

Author:

joachim

Message:

New form import
added portal status message to main_template

Location:

WAeUP_SRP/trunk

Files:

• WAeUPTool.py (modified) (13 diffs)
• profiles/default/layouts.xml (modified) (1 diff)
• profiles/default/layouts/import.xml (added)
• profiles/default/schemas.xml (modified) (1 diff)
• profiles/default/schemas/import.xml (added)
• profiles/default/vocabularies.xml (modified) (1 diff)
• profiles/default/vocabularies/csv_names.xml (added)
• profiles/default/vocabularies/import_names.xml (added)
• skins/waeup_default/get_csv_names.py (added)
• skins/waeup_default/import.py (added)
• skins/waeup_default/import_form.pt (added)
• skins/waeup_default/sessions_voc.py (modified) (1 diff)
• skins/waeup_design/main_template.pt (modified) (1 diff)
• skins/waeup_student/study_course_view.pt (modified) (1 diff)

WAeUP_SRP/trunk/WAeUPTool.py

@@ -67 +67 @@
                      )
 
-    student_field2types = {   ###(
-                      'StudentApplication':
-                          {'id': 'application',
-                           'title': 'Application Data',
-                           'fields':
-                             ('jamb_reg_no',
-                              'entry_mode',
-                              #'entry_level',
-                              'entry_session',
-                              'jamb_score',
-                              'email',
-                              'phone',
-                              )
-                              },
-                      'StudentPume':
-                          {'id': 'pume',
-                           'title': 'Pume Data',
-                           'fields':
-                             ('pume_score',
-                              )
-                              },
-                      'StudentClearance':
-                          {'id': 'clearance',
-                           'title': 'Clearance Data',
-                           'fields':
-                             ('matric_no',
-                              #'entry_level',
-                              'entry_session',
-                              'nationality',
-                              'lga',
-                              )
-                              },
-                         'StudentPersonal':
-                          {'id': 'personal',
-                           'title': 'Personal Data',
-                           'fields':
-                             ('firstname',
-                              'middlename',
-                              'lastname',
-                              'sex',
-                              'email',
-                              'phone',
-                              )
-                              },
-                         'StudentStudyCourse':
-                          {'id': 'study_course',
-                           'title': 'Study Course',
-                           'fields':
-                             ('study_course',
-                              'current_level',
-                              'current_session',
-                              'current_verdict',
-                              )
-                              },
-                         }
-    ###)
-
     def rwrite(self,s):
         response = self.REQUEST.RESPONSE
@@ -292 +235 @@
             return res[0]
         return None
+    ###)
+
+    security.declareProtected(ModifyPortalContent,'get_csv_filenames') ###(
+    def get_csv_filenames(self):
+        "do it"
+        files = [file for file in os.listdir("%s/import/" % (i_home)) 
+                 if file.endswith('.csv') and file.find('imported') == -1]
+        return files
     ###)
 
@@ -696 +647 @@
     ###)
 
+    student_field2types = {   ###(
+                      'StudentApplication':
+                          {'id': 'application',
+                           'title': 'Application Data',
+                           'wf_state': 'close',
+                           'fields':
+                             ('jamb_reg_no',
+                              'entry_mode',
+                              #'entry_level',
+                              'entry_session',
+                              'jamb_score',
+                              'email',
+                              'phone',
+                              )
+                              },
+                      'StudentPume':
+                          {'id': 'pume',
+                           'title': 'Pume Data',
+                           'wf_state': 'close',
+                           'fields':
+                             ('pume_score',
+                              )
+                              },
+                      'StudentClearance':
+                          {'id': 'clearance',
+                           'title': 'Clearance Data',
+                           'wf_state': 'close',
+                           'fields':
+                             ('matric_no',
+                              'nationality',
+                              'lga',
+                              )
+                              },
+                         'StudentPersonal':
+                          {'id': 'personal',
+                           'title': 'Personal Data',
+                           'wf_state': 'close',
+                           'fields':
+                             ('firstname',
+                              'middlename',
+                              'lastname',
+                              'sex',
+                              'email',
+                              'phone',
+                              'perm_address',
+                              )
+                              },
+                         'StudentStudyCourse':
+                          {'id': 'study_course',
+                           'title': 'Study Course',
+                           'wf_state': 'close',
+                           'fields':
+                             ('study_course',
+                              'current_level',
+                              'current_session',
+                              'current_mode',
+                              'current_verdict',
+                              )
+                              },
+                         }
+    ###)
+
+
     security.declareProtected(ModifyPortalContent,'import_student') ###(
     def import_student(self,dict):
@@ -714 +728 @@
         students_folder.invokeFactory('Student', sid)
         student_obj = getattr(students_folder,sid)
-        #password = self.generatePassword()
-        #self.makeStudentMember(sid,password)
         f2t = self.student_field2types
         for pt in f2t.keys():
@@ -728 +740 @@
                 d['sex'] = dict.get('sex') == 'F'
             sub_doc.edit(mapping = d)
-            self.portal_workflow.doActionFor(sub_obj,'close',dest_container=sub_obj)
+            self.portal_workflow.doActionFor(sub_obj,f2t[pt]['wf_state'],dest_container=sub_obj)
         wfaction = 'return'
         self.portal_workflow.doActionFor(student_obj,wfaction)
@@ -745 +757 @@
         start = True
         tr_count = 1
+        total_imported = 0
+        total_not_imported = 0
         total = 0
         iname = "import_%s" % name
@@ -751 +765 @@
         schema = stool._getOb(iname)
         if schema is None:
+            em = 'No such schema import_%s' % iname
             logger.error('No such schema import_%s' % iname)
-            return
+            return em
         layout = ltool._getOb(iname)
         if layout is None:
-            logger.error('No such layout import_%s' % iname)
-            return
+            em = 'No such layout import_%s' % iname
+            logger.error(em)
+            return em
         validators = {}
         for widget in layout.keys():
@@ -762 +778 @@
         creator = getattr(self, 'import_%s' % name,None)
         if creator is None:
-            logger.error('No creator function create_%s' % name)
-            return
+            em = 'No creator function create_%s' % name
+            logger.error(em)
+            return em
         not_imported = []
         imported = []
@@ -769 +786 @@
             items = csv.DictReader(open("%s/import/%s.csv" % (i_home,filename),"rb"))
         except:
-            logger.error('Error reading %s.csv' % filename)
-            return
+            em = 'Error reading %s.csv' % filename
+            logger.error(em)
+            return em
         for item in items:
             tr_count += 1
@@ -788 +806 @@
                     return
                 s = ','.join(['"%s"' % fn for fn in import_keys])
-                imported.append(s)
-                not_imported.append('%s,"Error"' % s)
+                open("%s/import/%s_imported%s.csv" % (i_home,filename,current),"a").write(s + '\n')
+                open("%s/import/%s_not_imported%s.csv" % (i_home,filename,current),"a").write('%s,"Error"' %s + '\n')
                 format = ','.join(['"%%(%s)s"' % fn for fn in import_keys])
                 format_error = format + ',"%(Error)s"'
+                #from pdb import set_trace; set_trace()
+                format = '"%(id)s",'+ format
             ds = DataStructure(data=item,datamodel=dm)
             error_string = ""
@@ -798 +818 @@
                     error_string += " %s : %s" % (k,ds.getError(k))
             if not error_string:
-                item['id'],error = creator(dm)
+                item.update(dm)
+                item['id'],error = creator(item)
                 if error:
                     error_string += error
@@ -804 +825 @@
                 item['Error'] = error_string
                 not_imported.append(format_error % item)
+                total_not_imported += 1
             else:
-                imported.append(format % dm)
+                imported.append(format % item)
+                total_imported += 1
+            total += 1
             if tr_count > 1000:
                 if len(not_imported) > 0:
@@ -819 +843 @@
                 regs = []
                 logger.info(em)
-                total += tr_count
                 tr_count = 0
-        if len(imported) > 1:
+        if len(imported) > 0:
             open("%s/import/%s_imported%s.csv" % (i_home,filename,current),"a").write(
                                                 '\n'.join(imported))
-        if len(not_imported) > 1:
+        if len(not_imported) > 0:
             open("%s/import/%s_not_imported%s.csv" % (i_home,filename,current),"a").write(
                                                 '\n'.join(not_imported))
-        return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1'))
+        em = "Imported: %d, not imported: %d of total %d" % (total_imported,total_not_imported,total) 
+        logger.info(em)
+        return em
     ###)
 

WAeUP_SRP/trunk/profiles/default/layouts.xml

@@ -11 +11 @@
   <object name="department" meta_type="CPS Layout"/>
   <object name="faculty" meta_type="CPS Layout"/>
+  <object name="import" meta_type="CPS Layout"/>
   <object name="import_student" meta_type="CPS Layout"/>
   <object name="members" meta_type="CPS Layout"/>

WAeUP_SRP/trunk/profiles/default/schemas.xml

@@ -16 +16 @@
  <object name="student" meta_type="CPS Schema"/>
  <object name="scratch_card_batch" meta_type="CPS Schema"/>
+ <object name="import" meta_type="CPS Schema"/>
  <object name="import_student" meta_type="CPS Schema"/>
  <object name="import_student_level_data" meta_type="CPS Schema"/>

WAeUP_SRP/trunk/profiles/default/vocabularies.xml

@@ -6 +6 @@
  <object name="acco_hall_reserved_rooms" meta_type="CPS Method Vocabulary"/>
  <object name="courselevel" meta_type="CPS Vocabulary"/>
+ <object name="csv_names" meta_type="CPS Method Vocabulary"/>
  <object name="entry_modes" meta_type="CPS Vocabulary"/>
  <object name="exam_subjects" meta_type="CPS Vocabulary"/>
  <object name="exam_types" meta_type="CPS Vocabulary"/>
  <object name="exam_grades" meta_type="CPS Vocabulary"/>
+ <object name="import_names" meta_type="CPS Vocabulary"/>
  <object name="institution_types_voc" meta_type="CPS Vocabulary"/>
  <object name="get_departments_voc" meta_type="CPS Method Vocabulary"/>

WAeUP_SRP/trunk/skins/waeup_default/sessions_voc.py

@@ -11 +11 @@
     return l
 
-if len(key) != 2:
-    return 'unknown'
 try:
     y = int(key)
 except:
     return 'unknown'
+##if len(key) != 2:
+##    return 'unknown'
 if y < 90:
     cent = 2000

WAeUP_SRP/trunk/skins/waeup_design/main_template.pt

@@ -183 +183 @@
           <td style="" class="shapeAreaShape5 colorBarAreaColor" valign="top">
             <div style="padding: 0.5em; text-align: left;" class="fontColordefaultfontcolors fontShapeaverage">
-                    <metal:block define-slot="header" />
-                    <metal:block define-slot="main" />
-                    <metal:block define-slot="sub" />
+              <metal:block use-macro="here/generic_lib_portal_message/macros/portal_message" />
+              <metal:block define-slot="header" />
+              <metal:block define-slot="main" />
+              <metal:block define-slot="sub" />
             </div>
           </td>

WAeUP_SRP/trunk/skins/waeup_student/study_course_view.pt

@@ -25 +25 @@
           <td width="220px">Certificate Code:</td> 
           <td><span tal:content="info/doc/study_course" /></td>
+        </tr>
+        <tr>
+          <td width="220px">Current Session:</td> 
+          <td><span tal:content="python:context.portal_vocabularies.sessions.get(info['doc'].current_session)" /></td>
         </tr>
         <tr>