X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Ffusionax%2Fimport-ax.sh;h=999c16ff29d4e87b83355e56d56efd71ea8d6e97;hb=f74509fbb4f06820dc3d028e3ffd2145f151b013;hp=505f87b9f772fc5039745e73716967395cc34c8d;hpb=acc9be56f2cc773f7e684f9cd3201141bc126ee2;p=platal.git diff --git a/modules/fusionax/import-ax.sh b/modules/fusionax/import-ax.sh index 505f87b..999c16f 100755 --- a/modules/fusionax/import-ax.sh +++ b/modules/fusionax/import-ax.sh @@ -5,7 +5,7 @@ #unrar e -inul export_4D.txt.rar cp /home/x2004jacob/export*utf8.TXT . -# séparation en fichiers de tables +# 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 @@ -19,8 +19,12 @@ 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