made another clean install of RunRev and V4_rev_4 mac and still have crashes

[Ivan Smahin]

On May 16, 2012, at 6:10 PM, william humphrey wrote:

> I just spent three hours trying to import a CSV file.  I am doing this because the time in my field for time is like this:
> 
> 00:00:00:007
> 00:00:00:007
> 00:00:00:007
> 00:00:00:018
> 00:00:00:007
> 00:00:00:010
> 00:00:00:012
> 00:00:00:012
> 00:00:00:018
> 00:00:00:008
> 00:00:00:007
> 00:00:00:007
> 00:00:00:007
> 00:00:00:009
> 00:00:00:007
> 00:00:00:007
> 00:00:00:016
> 00:00:00:018
> 00:00:00:007
> 
> The time is like this because it was a SQLite import.  So I want to change it to:
> 
> 07:00:00:000
> 07:00:00:000
> 07:00:00:000
> 18:00:00:000
> 07:00:00:000
> 10:00:00:000
> 12:00:00:000
> 12:00:00:000
> 18:00:00:000
> 08:00:00:000
> 07:00:00:000
> 07:00:00:000
> 07:00:00:000
> 09:00:00:000
> 07:00:00:000
> 07:00:00:000
> 
> But I don't know who to do that inside vStudio with SQL so I dumped a file and fixed it using Excel. No I have discovered that it is impossible to import a CVS file. No matter what I try, vServer, single database, every possible combination of settings, even changing field type to text -  absolutely everything it always says "0" files imported
> 
> I thought that 5.0.0 build April 28, 2012 21:04:55 was a version where this import ability was fixed.
> 
> 

Judging on your bug report http://www.valentina-db.com/bt/view.php?id=5816
you are trying to import a single column into the table which is under PK (primary key) constraint.
So you should get a lot of warnings (see Warning*.log) like "PK violation" and zero records imported as a result.

Meanwhile, we will add that "warning content" related to import process right into vStudio - like we do in SQL result panel. So, you will see all the failed rows and reasons right there.

-- 
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina-beta/attachments/20120521/6fce1bac/attachment.html>