Index: /main/waeup.kofa/trunk/tools/fix_import_file.py
===================================================================
--- /main/waeup.kofa/trunk/tools/fix_import_file.py	(revision 9477)
+++ /main/waeup.kofa/trunk/tools/fix_import_file.py	(revision 9478)
@@ -110,4 +110,8 @@
     'payment_date': 'date',
     'validation_date': 'date',
+    'resp_approved_amount': 'amount',
+    'amount': 'amount',
+    'amount_auth': 'amount',
+    'surcharge': 'amount'
     }
 
@@ -236,5 +240,5 @@
         value = cls.old_new_id_map.get(value, value)
         if len(value) == 7:
-            return 'M' + value
+            return 'B' + value
         return value
 
@@ -320,4 +324,5 @@
         # 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,4 +437,13 @@
 
     @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,4 +497,6 @@
         """
         if not value:
+            return
+        if len(value) < 5:
             return
         value = value.strip('#')
@@ -491,4 +507,6 @@
         if value.startswith('234'):
             value = '+' + value[:3] + '-' + value[3:]
+        elif value.startswith('+234'):
+            value = value[:4] + '-' + value[4:]
         else:
             value = '-%s' % phone
@@ -520,7 +538,7 @@
             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.
