X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Ffusionax%2Fimport-ax.sh;h=505f87b9f772fc5039745e73716967395cc34c8d;hb=29459c499c3c88fb9cdd34413dcbd5370d3573d3;hp=35b4b6af75e027d72085d6bba6154d2a3906e286;hpb=b9ad087851ce4a09236f64f67d15fdaf29e38cf0;p=platal.git diff --git a/modules/fusionax/import-ax.sh b/modules/fusionax/import-ax.sh index 35b4b6a..505f87b 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 @@ -23,4 +24,5 @@ $MYSQL x4dat < Entreprises.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*