Index: /main/waeup.sirp/trunk/tools/fix_import_file.py
===================================================================
--- /main/waeup.sirp/trunk/tools/fix_import_file.py	(revision 7609)
+++ /main/waeup.sirp/trunk/tools/fix_import_file.py	(revision 7610)
@@ -58,4 +58,5 @@
     'semester': 'semester',
     'application_category': 'application_category',
+    'lga': 'lga',
     }
 
@@ -79,4 +80,5 @@
     'student_created': 'created',
     'admitted': 'admitted',
+    'objection_raised': 'clearance started',
     'clearance_pin_entered': 'clearance started',
     'clearance_requested': 'clearance requested',
@@ -146,4 +148,17 @@
         return value
 
+    @classmethod
+    def lga(self, value):
+        """ Remove apostrophe
+        """
+        if value == 'akwa_ibom_uru_offong_oruko':
+            return 'akwa_ibom_urue-offong-oruko'
+        try:
+            value = value.replace("'","")
+            value = value.lower()
+        except:
+            return ''
+        return value
+
 
     @classmethod
@@ -167,7 +182,7 @@
         """ 'True'/'False' --> 'married'/'unmarried'
         """
-        if value == 'True':
+        if value in ('True','married'):
             value = 'married'
-        elif value == 'False':
+        elif value in ('False','unmarried'):
             value = 'unmarried'
         else:
@@ -179,7 +194,7 @@
         """ 'True'/'False' --> 'f'/'m'
         """
-        if value == 'True':
+        if value in ('True','f'):
             value = 'f'
-        elif value == 'False':
+        elif value in ('False','m'):
             value = 'm'
         else:
