[violante]

It didn't worked 🙁

I hope you can import the table

The max(DATE_TARIF) value is correct, but MARGE_THEO value isn't correct

The out from your formula is:

MAGASIN

---

ARTICLE_NT

---

DATE_TARIF

---

MARGE_THEO

1

---

76608

---

2006-05-02

---

0.00

1

---

76609

---

2100-06-03

---

5.19

1

---

76610

---

2005-07-01

---

10.11

1

---

76611

---

2006-04-25

---

5.39

1

---

76612

---

2002-08-08

---

4.04

but the correct output should be:

MAGASIN

---

ARTICLE_NT

---

DATE_TARIF

---

MARGE_THEO

1

---

76608

---

2006-05-02

---

67.64

1

---

76609

---

2100-06-03

---

9.11

1

---

76610

---

2005-07-01

---

8.42

1

---

76611

---

2006-04-25

---

4.27

1

---

76612

---

2002-08-08

---

1.04

What Happens is that MARGE_THEO value doesn't correspond with the DATE_TARIF row

😮 🙁

[attachment=505:attachment]

😮

[violante]

peterlaursen wrote on Aug 14 2006, 04:27 PM:

@violante

next time please post a COMPLETE DUMP ready for import! Why should I waste time TYPING when I could easily import your DUMP in a seconds.

🙁 sorry… 🙁

do you want me to export it as CSV???

I'm quite new with this, sorry 🙁

[violante]

Quote:

EXACTLY the same – the same data types etc.

Date types:

MAGASIN [smallint(1), NOTNULL]

ARTICLE_NT [smallint(5), NOTNULL]

DATE_TARIF [date, NOTNULL]

MARGE_THEO [decimal(6,2), null]

PA_BRUT [decimal(9,3),NULL]

PV_CONSO[decimal(9,3),NULL]

Quote:

* Write the output here EXACTLY and COMPLETELY as you want it!

MAGASIN

---

ARTICLE_NT

---

DATE_TARIF

---

MARGE_THEO

1

---

76608

---

16-08-2001

---

0

1

---

76608

---

18-12-2001

---

17,58

1

---

76608

---

10-01-2002

---

77,9

1

---

76609

---

02-01-2006

---

67,64

1

---

76609

---

10-02-2006

---

34,9

1

---

76610

---

01-05-2006

---

67,64

1

---

76610

---

02-05-2006

---

48,9

1

---

76610

---

03-05-2006

---

59,83

The output should be:

MAGASIN

---

ARTICLE_NT

---

DATE_TARIF

---

MARGE_THEO

1

---

76608

---

10-01-2002

---

77,9

1

---

76609

---

10-02-2006

---

34,9

1

---

76610

---

03-05-2006

---

59,83

[violante]

Quote:

wel then I think that my first 'shot' will work!

That's right it worked 😀

But my table has multipli values for article_nt…

I would like to have it grouped by article_nt …

I tried:

Select * from tar

ORDER BY date_tarif desc limit 1

group by article_nt

And happened the following error :

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group by article_nt' at line 3

May be the 2nd shot will end with my problem 😀

[violante]

peterlaursen wrote on Aug 11 2006, 04:38 PM:

But do you want to retrieve the max. value for date_tarif and at the same time the max. value for marge_theo (not corresponding values)?

No, what Iwould like is the max. value for date_tarif and the marge_theo value of the row that corresponds to max. value for date_tarif

Do you understand what i need??

Sorry but my english is not verry goos :huh:

[violante]

I did it, it was in fact verry easy 😮

But I can't even connect to the database, i get a message saying that the connection was canceled (translating from frenck system)

🙁

[violante]

peterlaursen wrote on Aug 1 2006, 10:14 PM:

It installs without problems.

Hi…

I unziped the folder and run install.bat, but it doesn't work.

I really don't understand the readme file 🙁

Could you help me?

[violante]

peterlaursen wrote on Jul 31 2006, 05:35 PM:

Does the Migration Tool mapping dialogue show the column twice?

No in the mapping dialog box the column is shown once 🙁

[violante]

yes, it works just fine 😀

thank you verry much 🙂

I have a table with more than 2.000.000 records from 180.000 diferent articles, for example id_article has 25 records, each one with a different date.

Is it possible when importing with migration toolkit, to place a statement, to import only the most recent record of each article??

The advantage is that the table would have only one record per article 😀

is it possible?

[violante]

hi!! 🙂

I finaly did some improvements 🙂

Instead of selecting “Copy table(s) from the datasource” I selected “Use a Query to specify the data to transfer” (SQLyog Migration Toolkit);

Now i have another problem, I need the table to be updated daily at 03:00, and I planed a sinchronization, and there's no problem 🙂

My problem is about how to assign the primary keys automatically 🙁

Is it possible to do it in the SQL statement?

Thanks in advance

[violante]

Hi, I installed SQL Server 2005 Express Edition, and tried to import the table, and the importation was successfull 😮

I also tried the last driver available of AcuODBC (V.7.0) and the problem is still there ERROR 1060 🙁

[violante]

The ODBC Driver is ACUCORP Version 6.2 but i allready imported other tables from the same database, where the “magasin” column exists (is one of the PK's) and there are no errors 😕

[violante]

I'm Importing from a COBOL database via ODBC.

When I select not to abort on error, the error is the same, it doesn't import any data at all.

Using MS ACCESS the importation goes just fine, and there are no duplicated column names.

🙁

[violante]

[attachment=502:attachment]

the table doesn't exist,

Is there a better way than migration toolkit???

[violante]

😕 Sorry, i didn't explain a thing 😕

I'm working with SQLyog 5.15, and with migration toolkit, I'm trying to import some tables, and i get that error, but there is only one magasin column, and the name is not duplicated like MAGASIN, for example 🙁

Sorry, if my english is not perfect 😕

[Author]

Posts