Index: /main/waeup.sirp/trunk/tools/fix_import_file.py
===================================================================
--- /main/waeup.sirp/trunk/tools/fix_import_file.py	(revision 7601)
+++ /main/waeup.sirp/trunk/tools/fix_import_file.py	(revision 7602)
@@ -47,7 +47,15 @@
     'entry_session': 'session',
     'current_session': 'session',
+    'session_id': 'session',
     'reg_state': 'reg_state',
     'password': 'password',
     'phone': 'phone',
+    'level': 'level',
+    'start_level': 'level',
+    'end_level': 'level',
+    'level_id': 'level',
+    'current_level': 'level',
+    'semester': 'semester',
+    'application_category': 'application_category',
     }
 
@@ -107,4 +115,37 @@
 
     @classmethod
+    def level(self, value):
+        """ '000' --> '10'
+        """
+        try:
+            number = int(value)
+        except ValueError:
+            return 9999
+        if number == 0:
+            return 10
+        return number
+
+    @classmethod
+    def semester(self, value):
+        """ '0' --> '9'
+        """
+        try:
+            number = int(value)
+        except ValueError:
+            return 9999
+        if number == 0:
+            return 9
+        return number
+
+    @classmethod
+    def application_category(self, value):
+        """ '' --> 'no'
+        """
+        if value == '':
+            return 'no'
+        return value
+
+
+    @classmethod
     def session(self, value):
         """ '08' --> '2008'
@@ -113,4 +154,5 @@
             number = int(value)
         except ValueError:
+            #import pdb; pdb.set_trace()
             return 9999
         if number < 14:
@@ -220,5 +262,8 @@
                 continue
             row[key] = converter(row[key])
-        writer.writerow(row)
+        try:
+            writer.writerow(row)
+        except:
+            print row['student_id']
 
     print "Output written to %s" % output_file
