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

Timestamp:

30 Oct 2012, 20:19:06 (12 years ago)

Author:

Henrik Bettermann

Message:

Add converter for amounts and other things.

File:

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

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

@@ -110 +110 @@
     'payment_date': 'date',
     'validation_date': 'date',
+    'resp_approved_amount': 'amount',
+    'amount': 'amount',
+    'amount_auth': 'amount',
+    'surcharge': 'amount'
     }
 
@@ -236 +240 @@
         value = cls.old_new_id_map.get(value, value)
         if len(value) == 7:
-            return 'M' + value
+            return 'B' + value
         return value
 
@@ -320 +324 @@
         # If real names are given, let's see if a similar value
         # in LGAS exist.
+        value = value.replace('_',' ')
         value = LGAS_inverted_stripped.get(strip(lower), value)
         return value
@@ -432 +437 @@
 
     @classmethod
+    def amount(self, value, row):
+        """ Amounts must be integers
+        """
+        try:
+            return float(value)
+        except:
+            return
+
+    @classmethod
     def mode(self, value, row):
         if value == "transfer_fulltime":
@@ -483 +497 @@
         """
         if not value:
+            return
+        if len(value) < 5:
             return
         value = value.strip('#')
@@ -491 +507 @@
         if value.startswith('234'):
             value = '+' + value[:3] + '-' + value[3:]
+        elif value.startswith('+234'):
+            value = value[:4] + '-' + value[4:]
         else:
             value = '-%s' % phone
@@ -520 +538 @@
             header = convert_fieldnames(reader.fieldnames)
             writer.writerow(header)
-        if row.get('reg_state') == 'student_created':
-            # We do not reimport student records which have never been accessed.
-            continue
+        #if row.get('reg_state') == 'student_created':
+        #    # We do not reimport student records which have never been accessed.
+        #    continue
         if row.get('status') == 'started':
             # We do not reimport started payments.