Index: /main/waeup.kofa/trunk/tools/fix_import_file.py
===================================================================
--- /main/waeup.kofa/trunk/tools/fix_import_file.py	(revision 8938)
+++ /main/waeup.kofa/trunk/tools/fix_import_file.py	(revision 8939)
@@ -97,4 +97,7 @@
     'scd_sit_results': 'result',
     'alr_results': 'result',
+    'email': 'email',
+    'fst_sit_type': 'sittype',
+    'scd_sit_type': 'sittype',
     }
 
@@ -232,4 +235,21 @@
         if value == 'akwa_ibom_uru_offong_oruko':
             return 'akwa_ibom_urue-offong-oruko'
+        if value == 'edo_ohionmwon':
+            return 'edo_orhionmwon'
+
+        if value == 'nassarawa_nassarawa':
+            return 'nassarawa_nassawara'
+
+        if value == 'kogi_mopa-muro-mopi':
+            return 'kogi_mopa-muro'
+
+        if value == 'delta_osimili-north':
+            return 'delta_oshielli-north'
+
+        if value == 'delta_osimili':
+            return 'delta_oshimili'
+
+        if value == 'delta_osimili-south':
+            return 'delta_oshimili-south'
         try:
             value = value.replace("'","")
@@ -372,5 +392,17 @@
         if value == "nigeria":
             return "NG"
-        return value
+        if value == "niger":
+            return "NE"
+        return value
+
+    @classmethod
+    def sittype(self, value):
+        if value == "nabtec":
+            return "nabteb"
+        return value
+
+    @classmethod
+    def email(self, value):
+        return value.strip()
 
     @classmethod
@@ -414,4 +446,6 @@
             header = convert_fieldnames(reader.fieldnames)
             writer.writerow(header)
+        if row.get('reg_state') == 'student_created':
+            continue
         for key, value in row.items():
             if not key in OPTIONS.keys():
