Import of mySQL text file into Valentina

Ruslan Zasukhin sunshine at public.kherson.ua
Wed Jan 3 08:23:22 CST 2007


On 07/2/1 6:10 PM, "robmann at gp-racing.com" <robmann at gp-racing.com> wrote:

Hi Robert,

I have check your import COMA-separated file, and reason why after import
you get wrong values in columns.

Problem is that in text file mySQL show datetime values as

    2006-07-17 03:48:43

But in your empty database Valentina you can see that
    format of date is:   MDY
    Date Separator is:    /
        
You need change this to    YMD  and   -

To import text file correctly.


----
Meanwhile I see the need improve Valentina, so such issue will not break
values in other columns, and we need somehow inform user about such problem
of import.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]




More information about the Valentina mailing list