Import data - problems

[Ruslan Zasukhin]

On 8/25/09 12:18 PM, "Greg Olson-Hyde" <greg at hawkmount.com> wrote:

Hi Greg,

> Your export idea was a good one, I saw one problem, my text file has
> "" surrounding all the integer values, yours don't. With 'SQLite
> Manager' ALL fields are surrounded by quotes - I think that is the
> reason for the quitting on import.
> 
> So, I changed my 'Short' and 'Long' integer fields to 'text' in
> Valentina and the import has worked.
> 
> Then I changed them to 'Short' and 'Long' after the import - is that
> the way to do it?

Yes, if SqlLite manager is not able remove that quotes...

Can be other way of course
    open text file in some text editor. E.g. TextMate
    and using REGEX find/replace remove quotes
    around all numbers.

Better avoid such transformations of types in DB..
Just from paranoid point of view :-)


-- 
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]