Changeset 7628 for main/waeup.sirp/trunk/tools

Timestamp:

10 Feb 2012, 20:45:33 (13 years ago)

Author:

Henrik Bettermann

Message:

Add converters for payment files.

File:

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

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

@@ -59 +59 @@
     'application_category': 'application_category',
     'lga': 'lga',
+    'order_id': 'no_int',
     }
 
@@ -74 +75 @@
     # course ticket
     'level_id': 'level',
+    # payment ticket
+    'order_id': 'p_id',
+    'status': 'p_state',
+    'category': 'p_category',
+    'resp_pay_reference': 'r_pay_reference',
+    'resp_desc': 'r_desc',
+    'resp_approved_amount': 'r_amount_approved',
+    'item': 'p_item',
+    'amount': 'amount_auth',
+    'resp_card_num': 'r_card_num',
+    'resp_code': 'r_code',
+    'date': 'creation_date',
+    'surcharge': 'surcharge_1',
+    'session_id': 'p_session',
     }
 
@@ -216 +231 @@
             value += '#'
         return value
+
+    @classmethod
+    def no_int(self, value):
+        """ Add hash.
+        """
+        # We add the hash symbol to avoid automatic number transformation
+        # in Excel and Calc for further processing
+        value += '#'
+        return value
+
 
     @classmethod