Changeset 1146 for WAeUP_SRP/trunk/Academics.py

Timestamp:

29 Dec 2006, 07:00:35 (18 years ago)

Author:

joachim

Message:

added import for registered and results,
the csv-files must contain a modified heading
results can be viewed with session_results_anon_view
modified Courses import to use courses catalog

File:

• WAeUP_SRP/trunk/Academics.py (modified) (3 diffs)

WAeUP_SRP/trunk/Academics.py

@@ -187 +187 @@
         """install Universityspecific Courses from CSV values"""
         #return
+        not_allowed =re.compile('[^A-Z0-9]')
         wf = self.portal_workflow
         name = 'Courses'
@@ -208 +209 @@
             logger.error('Error reading %s.csv' % name)
             return
-        no_import = open("%s/import/%s_not_imported.csv" % (i_home,name),"w")
+        imported = []
+        not_imported = []
         heading = ','.join(['"%s"' % fn for fn in fields])
-        no_import.write('%s\n' % heading)
+        imported.append(heading)
+        not_imported.append(heading)
+        #no_import.write('%s\n' % heading)
         l = self.portal_catalog({'meta_type': "Faculty"})
         facs = {}
@@ -222 +226 @@
         course_list = [ c.id for c in cl]
         for course in courses:
-            processing = "processing %s" % format
-            logger.info(processing % course)
+            #processing = "processing %s" % format
+            #logger.info(processing % course)
+            course_id = course.get('code')
+            if not_allowed.search(course_id):
+                msg = ',"Invalid Course Code"'
+                #logger.info(msg)
+                #not_imported.append('"%s",' % msg)
+                not_imported.append(format % course + msg)
+                continue
             depid = course.get('department_code').upper()
             if depid in deps.keys():
                 dept= deps.get(depid)
             else:
-                msg = "Department %(department_code)s for Course %(code)s not found" % course
-                logger.info(msg)
-                no_import.write('"%s",' % msg)
-                no_import.write(format % course + "\n")
+                msg = ',"Department not found"'
+                #logger.info(msg)
+                #not_imported.append('"%s",' % msg)
+                not_imported.append(format % course + msg)
                 continue
-            course_id = course.get('code')
             if course_id in course_list:
-                msg = "Multiple Course Code"
-                logger.info(msg)
-                no_import.write('"%s",' % msg)
-                no_import.write(format % course + "\n")
+                msg = ',"Multiple Course Code"'
+                #logger.info(msg)
+                #not_imported.append('"%s",' % msg)
+                not_imported.append(format % course + msg)
                 continue
+            level = "%c00" % course_id[-3]
+            course['level'] = level
             cf = dept.courses
             c = getattr(cf,course_id,None)
+            cd_fields = (('code','code'),
+                         ('faculty','faculty_code'),
+                         ('department','department_code'),
+                         ('title','title'),
+                         ('credits','credits'),
+                         ('level','level'),
+                         ('semester','semester'),
+                         )
+            cd = {}
+            for t,f in cd_fields:
+                cd[t] = course[f]
+            #import pdb;pdb.set_trace()
             if c is None:
                 logger.info('Creating Course %(code)s  %(title)s in Department %(department_code)s' % course)
                 cf.invokeFactory('Course', course_id)
                 course_list.append(course_id)
+                imported.append(format % course)
                 c = getattr(cf,course_id)
+                self.courses_catalog.addRecord(**cd)
+            else:
+                self.courses_catalog.modifyRecord(**cd)
             c.getContent().edit(mapping=course)
             review_state = course.get('review_state')
             if review_state == "checked" and wf.getInfoFor(c,'review_state',None) != 'checked':
                 self.portal_workflow.doActionFor(c,'approve')
+        current = DateTime.DateTime().strftime("%d-%m-%y_%H_%M_%S")
+        if len(not_imported) > 1:
+            open("%s/import/%s_%s_not_imported.csv" % (i_home,name,current),"w")\
+                .write('\n'.join(not_imported))
+        open("%s/import/%s_%s_imported.csv" % (i_home,name,current),"w")\
+                .write('\n'.join(imported))
         return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1'))
     ###)