X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Ffusionax%2Fimport-ax.sh;h=fb3a6dbea7c09e0b748655033ea3398eb768298b;hb=e8a898662eeafa5201082067a7aac46573884ebb;hp=35b4b6af75e027d72085d6bba6154d2a3906e286;hpb=b9ad087851ce4a09236f64f67d15fdaf29e38cf0;p=platal.git

diff --git a/modules/fusionax/import-ax.sh b/modules/fusionax/import-ax.sh
index 35b4b6a..fb3a6db 100755
--- a/modules/fusionax/import-ax.sh
+++ b/modules/fusionax/import-ax.sh
@@ -1,15 +1,16 @@
 #! /bin/bash
 
 # import des données
-scp -i ax_xorg_rsa xorg@polytechniciens.com:/home/axasso/ax-import/export_4D.txt.rar .
-unrar e -inul export_4D.txt.rar
+#scp -i ax_xorg_rsa xorg@polytechniciens.com:/home/axasso/ax-import/export_4D.txt.rar .
+#unrar e -inul export_4D.txt.rar
+cp /home/x2004jacob/export*utf8.TXT .
 
 # séparation en fichiers de tables 
-cat export-total* | grep ^AD > Adresses.txt
-cat export-total* | grep ^AN > Anciens.txt
-cat export-total* | grep ^FO > Formations.txt
-cat export-total* | grep ^AC > Activites.txt
-cat export-total* | grep ^EN > Entreprises.txt
+cat export_total* | grep ^AD > Adresses.txt
+cat export_total* | grep ^AN > Anciens.txt
+cat export_total* | grep ^FO > Formations.txt
+cat export_total* | grep ^AC > Activites.txt
+cat export_total* | grep ^EN > Entreprises.txt
 
 exit 1
 
@@ -18,9 +19,14 @@ echo int
 $MYSQL x4dat < Activites.sql
 $MYSQL x4dat < Adresses.sql
 $MYSQL x4dat < Anciens.sql
-$MYSQL x4dat < Formations.sql
 $MYSQL x4dat < Entreprises.sql
+./formation.pl
+cat Formations_out.txt > Formations.txt
+rm -f Formations_out.txt
+$MYSQL x4dat < Formations.sql
+
 
 # nettoyage
 echo nettoyage
-rm Adresses.txt Anciens.txt Formations.txt Activites.txt Entreprises.txt export_4D.txt.rar export-total*
+#rm Adresses.txt Anciens.txt Formations.txt Activites.txt Entreprises.txt export_4D.txt.rar export-total*
+rm Adresses.txt Anciens.txt Formations.txt Activites.txt Entreprises.txt export-total*