[platal.git] / modules / fusionax / import-ax.sh

#! /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
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

exit 1

# int�gration dans notre bdd
echo int�gration dans notre bdd
$MYSQL x4dat < Activites.sql
$MYSQL x4dat < Adresses.sql
$MYSQL x4dat < Anciens.sql
$MYSQL x4dat < Formations.sql
$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-total*
Commit	Line	Data
b9ad0878 PC	1	#! /bin/bash
	2
	3	# import des donn�es
22f043e4 SJ	4	#scp -i ax_xorg_rsa xorg@polytechniciens.com:/home/axasso/ax-import/export_4D.txt.rar .
	5	#unrar e -inul export_4D.txt.rar
	6	cp /home/x2004jacob/export*utf8.TXT .
b9ad0878 PC	7
b9ad0878 PC	8	# s�paration en fichiers de tables
22f043e4 SJ	9	cat export_total* \| grep ^AD > Adresses.txt
	10	cat export_total* \| grep ^AN > Anciens.txt
	11	cat export_total* \| grep ^FO > Formations.txt
	12	cat export_total* \| grep ^AC > Activites.txt
	13	cat export_total* \| grep ^EN > Entreprises.txt
b9ad0878 PC	14
	15	exit 1
	16
	17	# int�gration dans notre bdd
	18	echo int�gration dans notre bdd
	19	$MYSQL x4dat < Activites.sql
	20	$MYSQL x4dat < Adresses.sql
	21	$MYSQL x4dat < Anciens.sql
	22	$MYSQL x4dat < Formations.sql
	23	$MYSQL x4dat < Entreprises.sql
	24
	25	# nettoyage
	26	echo nettoyage
22f043e4 SJ	27	#rm Adresses.txt Anciens.txt Formations.txt Activites.txt Entreprises.txt export_4D.txt.rar export-total*
22f043e4 SJ	28	rm Adresses.txt Anciens.txt Formations.txt Activites.txt Entreprises.txt export-total*