X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Ffusionax%2Fimport-ax.sh;h=999c16ff29d4e87b83355e56d56efd71ea8d6e97;hb=1c0419d6b4c94643bfa7bed9a6b435bbdbbae02f;hp=505f87b9f772fc5039745e73716967395cc34c8d;hpb=f875fdc7a9cd2b879598a1e0ac0cb73456e4e809;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