Changeset 5581 for WAeUP_SRP/trunk/WAeUPTables.py

Timestamp:

8 Nov 2010, 12:59:16 (14 years ago)

Author:

Henrik Bettermann

Message:

First version of Moodle authentication data export.

File:

• WAeUP_SRP/trunk/WAeUPTables.py (modified) (2 diffs)

WAeUP_SRP/trunk/WAeUPTables.py

@@ -435 +435 @@
         out = open(export_file,"a")
         csv_writer = csv.DictWriter(out,fields,)
-        if include_unused is not None and str(member) not in ('admin','joachim'):
+        if include_unused is not None and str(member) not in ('admin'):
             logger.info('%s tries to dump pintable with unused pins' % (member))
             return
@@ -765 +765 @@
         WAeUPTable.__init__(self, name)
         return
+        
+    security.declareProtected(ModifyPortalContent,"exportMoodleData") ###(
+    def exportMoodleData(self):
+        "export a WAeUPTable"
+        member = self.portal_membership.getAuthenticatedMember()
+        logger = logging.getLogger('WAeUPTables.StudentsCatalog.exportMoodleData')
+        if str(member) not in ('admin'):
+            logger.info('%s tries to dump Moodle Data' % (member))
+            return        
+        fields = [field for field in self.schema()]
+        export_fields = ['username','firstname','lastname','email','current_session','reg_state','password']
+        format = ','.join(['"%%(%s)s"' % fn for fn in export_fields])
+        csv = []
+        csv.append(','.join(['"%s"' % fn for fn in export_fields]))
+        #import pdb;pdb.set_trace()
+        for uid in self._catalog.uids:
+            records = self.searchResults({"%s" % self.key : uid})
+            if len(records) > 1:
+                # Can not happen, but anyway...
+                raise ValueError("More than one record with uid %s" % uid)
+            if len(records) == 0:
+                raise KeyError("No record for uid %s" % uid)
+            rec = self.record2dict(fields,records[0],None)            
+            rec['firstname'] = rec['firstname'] + rec['middlename']
+            rec.update({'reg_state':rec['review_state']})
+            rec['current_session'] = rec['session']
+            rec['username'] = rec['id']
+            rec['password'] = self.waeup_tool.getCredential(rec['id'])
+            csv.append(format % rec)
+        current = DateTime.DateTime().strftime("%d-%m-%y_%H_%M_%S")
+        open("%s/export/moodle-%s.csv" % (i_home,current),"w+").write('\n'.join(csv))        
+        return 'ready'
 
     def manage_catalogClear(self, REQUEST=None, RESPONSE=None, URL1=None):