Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 13 posts - 1 through 13 (of 13 total)
  • Author
    Posts
  • in reply to: How Could I Import To Different Tables With Sja ? #22677
    MuphoOx
    Member

    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 🙄

    in reply to: How Could I Import To Different Tables With Sja ? #22676
    MuphoOx
    Member

    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)

    in reply to: How Could I Import To Different Tables With Sja ? #22674
    MuphoOx
    Member

    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 ?

    in reply to: How Could I Import To Different Tables With Sja ? #22672
    MuphoOx
    Member

    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

    in reply to: How Could I Import To Different Tables With Sja ? #22671
    MuphoOx
    Member

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

    in reply to: How Could I Import To Different Tables With Sja ? #22669
    MuphoOx
    Member

    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 ?

    in reply to: How Could I Import To Different Tables With Sja ? #22667
    MuphoOx
    Member

    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.

    in reply to: Re-organize The Sja Output Log File #22435
    MuphoOx
    Member

    @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 🙁

    in reply to: Re-organize The Sja Output Log File #22432
    MuphoOx
    Member

    If there is any question don't hesitate … 🙄

    in reply to: Progress Indicator Very Much Wanted #21305
    MuphoOx
    Member

    yeah sure!

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

    in reply to: Progress Indicator Very Much Wanted #21303
    MuphoOx
    Member

    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.

    in reply to: Sja And Atomic Transaction #22409
    MuphoOx
    Member

    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 ?

    in reply to: Help About Sja & Named Pipe … #22190
    MuphoOx
    Member

    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…

Viewing 13 posts - 1 through 13 (of 13 total)