Changeset 8939 for main/waeup.kofa/trunk/tools/fix_import_file.py

Timestamp:

8 Jul 2012, 05:17:11 (12 years ago)

Author:

Henrik Bettermann

Message:

More conversions.

Skip student_created.

File:

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

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

@@ -97 +97 @@
     'scd_sit_results': 'result',
     'alr_results': 'result',
+    'email': 'email',
+    'fst_sit_type': 'sittype',
+    'scd_sit_type': 'sittype',
     }
 
@@ -232 +235 @@
         if value == 'akwa_ibom_uru_offong_oruko':
             return 'akwa_ibom_urue-offong-oruko'
+        if value == 'edo_ohionmwon':
+            return 'edo_orhionmwon'
+
+        if value == 'nassarawa_nassarawa':
+            return 'nassarawa_nassawara'
+
+        if value == 'kogi_mopa-muro-mopi':
+            return 'kogi_mopa-muro'
+
+        if value == 'delta_osimili-north':
+            return 'delta_oshielli-north'
+
+        if value == 'delta_osimili':
+            return 'delta_oshimili'
+
+        if value == 'delta_osimili-south':
+            return 'delta_oshimili-south'
         try:
             value = value.replace("'","")
@@ -372 +392 @@
         if value == "nigeria":
             return "NG"
-        return value
+        if value == "niger":
+            return "NE"
+        return value
+
+    @classmethod
+    def sittype(self, value):
+        if value == "nabtec":
+            return "nabteb"
+        return value
+
+    @classmethod
+    def email(self, value):
+        return value.strip()
 
     @classmethod
@@ -414 +446 @@
             header = convert_fieldnames(reader.fieldnames)
             writer.writerow(header)
+        if row.get('reg_state') == 'student_created':
+            continue
         for key, value in row.items():
             if not key in OPTIONS.keys():