Changeset 9007 for main/waeup.kofa/trunk/tools

Timestamp:

17 Jul 2012, 04:36:27 (12 years ago)

Author:

Henrik Bettermann

Message:

Extend import file repair script.

Add shell script for downloading export files.

Location:

main/waeup.kofa/trunk/tools

Files:

• download_exports.sh (added)
• fix_import_file.py (modified) (7 diffs)

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

@@ -103 +103 @@
     'date': 'date',
     'category': 'p_category',
+    'reg_transition': 'reg_state',  # we completely change this column,
+                                    # since reg_state import is usually intended
+    'transition': 'reg_transition',
     }
 
@@ -109 +112 @@
     # base data
     'reg_state': 'state',
+    'reg_transition': 'state',
     'jamb_reg_no': 'reg_number',
     'matric_no': 'matric_number',
@@ -165 +169 @@
     'courses_registered': 'courses registered',
     'courses_validated': 'courses validated',
+    'admit': 'admitted',
+    'return': 'returning'
     }
 
@@ -193 +199 @@
         """
         if len(value) == 7:
-            return 'E' + value
+            return 'B' + value
         return value
 
@@ -201 +207 @@
         """
         return REGSTATE_MAPPING.get(value,value)
+
+    @classmethod
+    def reg_transition(self, value):
+        if value == "admitted":
+            return "admit"
+        if value == "returning":
+            return "return"
+        return value
 
     @classmethod
@@ -421 +435 @@
         if not value:
             return
+        value = value.strip('#')
         value = value.replace('-', '')
         value = value.replace('/', '')
         match = RE_PHONE.match(value)
         phone = match.groups()[0]
-        value = '-%s' % phone
+        if value.startswith('234'):
+            value = '+' + value[:3] + '-' + value[3:]
+        else:
+            value = '-%s' % phone
         return value + '#'
 
@@ -437 +455 @@
             return [(i[0].lower(),i[1]) for i in liste]
         return
+
 
 def main():