Changeset 7602

Timestamp:

8 Feb 2012, 07:24:41 (13 years ago)

Author:

Henrik Bettermann

Message:

More converters.

File:

• main/waeup.sirp/trunk/tools/fix_import_file.py (modified) (4 diffs)

main/waeup.sirp/trunk/tools/fix_import_file.py

@@ -47 +47 @@
     'entry_session': 'session',
     'current_session': 'session',
+    'session_id': 'session',
     'reg_state': 'reg_state',
     'password': 'password',
     'phone': 'phone',
+    'level': 'level',
+    'start_level': 'level',
+    'end_level': 'level',
+    'level_id': 'level',
+    'current_level': 'level',
+    'semester': 'semester',
+    'application_category': 'application_category',
     }
 
@@ -107 +115 @@
 
     @classmethod
+    def level(self, value):
+        """ '000' --> '10'
+        """
+        try:
+            number = int(value)
+        except ValueError:
+            return 9999
+        if number == 0:
+            return 10
+        return number
+
+    @classmethod
+    def semester(self, value):
+        """ '0' --> '9'
+        """
+        try:
+            number = int(value)
+        except ValueError:
+            return 9999
+        if number == 0:
+            return 9
+        return number
+
+    @classmethod
+    def application_category(self, value):
+        """ '' --> 'no'
+        """
+        if value == '':
+            return 'no'
+        return value
+
+
+    @classmethod
     def session(self, value):
         """ '08' --> '2008'
@@ -113 +154 @@
             number = int(value)
         except ValueError:
+            #import pdb; pdb.set_trace()
             return 9999
         if number < 14:
@@ -220 +262 @@
                 continue
             row[key] = converter(row[key])
-        writer.writerow(row)
+        try:
+            writer.writerow(row)
+        except:
+            print row['student_id']
 
     print "Output written to %s" % output_file