Index: /main/waeup.kofa/trunk/tools/download_exports.sh
===================================================================
--- /main/waeup.kofa/trunk/tools/download_exports.sh	(revision 9007)
+++ /main/waeup.kofa/trunk/tools/download_exports.sh	(revision 9007)
@@ -0,0 +1,13 @@
+#!/bin/sh
+
+## We expect at least three arguments...
+if [ $# -ne 3 ]; then
+    echo "Usage: $0 [user name] [password] [exporter]"
+    exit
+fi
+
+wget --save-cookies cookies.txt --keep-session-cookies --post-data "form.login=$1&form.password=$2" https://uniben-kofa.waeup.org/login 
+wget --load-cookies cookies.txt  --output-document $3.csv https://uniben-kofa.waeup.org/datacenter/export.csv?exporter=$3
+tar -czf Kofa$3.tar.gz $3.csv
+rm $3.csv
+mv Kofa$3.tar.gz /home/ftp/uniben
Index: /main/waeup.kofa/trunk/tools/fix_import_file.py
===================================================================
--- /main/waeup.kofa/trunk/tools/fix_import_file.py	(revision 9006)
+++ /main/waeup.kofa/trunk/tools/fix_import_file.py	(revision 9007)
@@ -103,4 +103,7 @@
     'date': 'date',
     'category': 'p_category',
+    'reg_transition': 'reg_state',  # we completely change this column,
+                                    # since reg_state import is usually intended
+    'transition': 'reg_transition',
     }
 
@@ -109,4 +112,5 @@
     # base data
     'reg_state': 'state',
+    'reg_transition': 'state',
     'jamb_reg_no': 'reg_number',
     'matric_no': 'matric_number',
@@ -165,4 +169,6 @@
     'courses_registered': 'courses registered',
     'courses_validated': 'courses validated',
+    'admit': 'admitted',
+    'return': 'returning'
     }
 
@@ -193,5 +199,5 @@
         """
         if len(value) == 7:
-            return 'E' + value
+            return 'B' + value
         return value
 
@@ -201,4 +207,12 @@
         """
         return REGSTATE_MAPPING.get(value,value)
+
+    @classmethod
+    def reg_transition(self, value):
+        if value == "admitted":
+            return "admit"
+        if value == "returning":
+            return "return"
+        return value
 
     @classmethod
@@ -421,9 +435,13 @@
         if not value:
             return
+        value = value.strip('#')
         value = value.replace('-', '')
         value = value.replace('/', '')
         match = RE_PHONE.match(value)
         phone = match.groups()[0]
-        value = '-%s' % phone
+        if value.startswith('234'):
+            value = '+' + value[:3] + '-' + value[3:]
+        else:
+            value = '-%s' % phone
         return value + '#'
 
@@ -437,4 +455,5 @@
             return [(i[0].lower(),i[1]) for i in liste]
         return
+
 
 def main():
