[MuphoOx]

Hi all !

I'm back to the forum, was in holidays 😆

To solve my probleme i've used an sql script with many Select and Where conditions in aan SJA notification Job, and now everything is ok 🙄

[MuphoOx]

ohh !! yeah !! i forgot this !!

==> ligne_prix_achat.code_article = article.code_article and article.code_utilisateur_article = temp_table.code_utilisateur_article;

that was just a miss ! (i've not executed the request yet)

[MuphoOx]

This alter table was done first on MySQL 5 and that was working.

i'm trying to do a migration to a temp table on the database i'm using and execute an SQLScript as this one :

Quote:

insert into article

select

code_utilisateur_article, descriptif_langue_1_article, nom_article, […], code_type_gestion_stock, stock_negatif_autorise, […]

from temp_table;

insert into ligne_de_tarif

select prix_vente

from temp_table, article, remise

where remise.code_article = article.code_article and article.code_utilisateur_article = temp_table.code_utilisateur_article ;

insert into ligne_prix_achat

select date_debut, date_fin

from temp_table, article, ligne_prix_achat

where ligne_prix_achat.code_article and article.code_utilisateur_artcile = temp_table.code_utilisateur_article ;

what do you think of this solution ?

[MuphoOx]

i'm back again …

i've tried your solution, but i think that will not work with MySQL version 4.1.12. Unfortunately, i can't upgrade to mysql 5, and doing this will lead to many changes on our ERP software. The error message that i had during the creation of the FK constraint is :

The ALTER TABLE :

Quote:

ALTER TABLE migration_data_client_boutique.produits24_article ADD CONSTRAINT

FOREIGN KEY (code_utilisateur_article) REFERENCES bw.article(code_utilisateur_article) ON DELETE CASCADE;

FOREIGN KEY (CODE_UNITE_STOCKAGE) REFERENCES bw.article(CODE_UNITE_STOCKAGE) ON DELETE CASCADE;

[…]

The error message is : SEE THE ATTACHMENT

[MuphoOx]

OOOkey ! thx peter; i'll try this tricky method ! answer you once i'm done 😉

[MuphoOx]

You're right sir !

this what i want to do … i did this … but, more of it, i would put some of the selected column on TABLE_1, and other columns on TABLE_2 of the same database.

i made a batch file with many sja jobs. the problem that i've encountered is that the tables used are related

TABLE_1 (ID_tb1, fk_id_tb3, article_name, …)

TABLE_2 (ID_tb2, fk_id_tb1, article_price, …)

TABLE_3 (ID_tb3, …)

I can't insert data on a table randomly, so how coul i insert data (concerning prices for exemple) on the TABLE_2 as i can keep the relation between the two tables ?

[MuphoOx]

thank you peter for the fast reply.

The data source is an excel file, i've imported them to an access database using CSV cause when i wanted to migrate directly from excel to access (both in office 2003 format) i had many error messages.

Realy i don't know how i could use the SQL Where to put the data of 3 or 4 access DB colums into adequate collums in the mysql tables.

[MuphoOx]

@TomBez

It would be greate to put html tabs … but i'm reading the file trough a Buffer line by line, i don't know how i could split the array in colums.

@Peter

I've tried the non-proportional font => Courier, but in vain .. nothing has changed ! exactlu the same result. And what makes me 😡 is that the same command, called directly from CMD window is well organised 🙁

[MuphoOx]

If there is any question don't hesitate … 🙄

[MuphoOx]

yeah sure!

It will be not so easy to put a percentage prograss bar ! but anyway, any sign of activity will be helpful 🙂 Thx.

[MuphoOx]

hey peter,

I'd like to know if there is any proress about the progress bar … i know it's an old post, but it's just to have some news about it.

[MuphoOx]

Thx to peter laursen, the answer was as brief as i'de liked to !

SJA does not support transactions!

🙁 i have a very big problem then …

any one could help ?

[MuphoOx]

thx for your answer, Peter;

i was writing an update of this situation …

actually, i've changed the parameters; i've commented-out 'disable-networking' in MySQL and used a tcp port, and have put a 'bind-address=127.0.0.1' clause to keep my server secure.

I was using the “named pipe” 'cause our clients when they have a firewall, it block the communication port of mysql, so no more connexion to the data base is possible; then the software is not working… and the client complain … 😡 . The named pipe was used cause it doesn't use any communication port …

Anyway, with the bind-address, the sync job works well; but i have to find a solution to avoid the firewall… or to add a rule on every well knwon firewall…. but it's an other task…

[Author]

Posts