Changeset 8781 for main

Timestamp:

23 Jun 2012, 09:43:57 (13 years ago)

Author:

Henrik Bettermann

Message:

Be more intelligent when creating an appropriate lga key.

File:

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

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

@@ -17 +17 @@
 ##
 """
-Fix exports from old SRP portal to make them importable by current portal.
+Fix exports from old SRP portal and other data sources to make
+them importable by current portal.
 
 Usage:
@@ -28 +29 @@
 Errors/warnings will be displayed on the shell, the output will be put
 into the specified output file.
+
+
+The lgas.py module must be copied into the same folder where this script
+is started.
 """
 import csv
@@ -33 +38 @@
 import re
 import sys
+
+try:
+    from lgas import LGAS
+except:
+    print 'ERROR: lgas.py is missing.'
+    sys.exit(1)
+
+def strip(string):
+    string = string.replace('_', '')
+    string = string.replace('/', '')
+    string = string.replace('-', '')
+    string = string.replace(' ', '')
+    string = string.lower()
+    return string
+
+LGAS_inverted_stripped = dict([(strip(i[1]), i[0]) for i in LGAS])
+LGAS_dict = dict(LGAS)
 
 ##
@@ -189 +211 @@
         except:
             return ''
+        if value in LGAS_dict.keys():
+            return value
+        # If real names are given, let's see if a similar value
+        # in LGAS exist.
+        value = LGAS_inverted_stripped.get(strip(value), value)
         return value
 
@@ -232 +259 @@
         """ 'True'/'False' --> 'f'/'m'
         """
-        if value in ('True','f'):
+        if value in ('F', 'True','f'):
             value = 'f'
-        elif value in ('False','m'):
+        elif value in ('M', 'False','m'):
             value = 'm'
         else: