<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br><div><div>On May 16, 2012, at 6:10 PM, william humphrey wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">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:<div><br></div><div><div>00:00:00:007</div><div>00:00:00:007</div><div>00:00:00:007</div><div>00:00:00:018</div>
<div>00:00:00:007</div><div>00:00:00:010</div><div>00:00:00:012</div><div>00:00:00:012</div><div>00:00:00:018</div><div>00:00:00:008</div><div>00:00:00:007</div><div>00:00:00:007</div><div>00:00:00:007</div><div>00:00:00:009</div>
<div>00:00:00:007</div><div>00:00:00:007</div><div>00:00:00:016</div><div>00:00:00:018</div><div>00:00:00:007</div><div><br></div><div>The time is like this because it was a SQLite import. So I want to change it to:</div>
<div><br></div><div><div>07:00:00:000</div><div>07:00:00:000</div><div>07:00:00:000</div><div>18:00:00:000</div><div>07:00:00:000</div><div>10:00:00:000</div><div>12:00:00:000</div><div>12:00:00:000</div><div>18:00:00:000</div>
<div>08:00:00:000</div><div>07:00:00:000</div><div>07:00:00:000</div><div>07:00:00:000</div><div>09:00:00:000</div><div>07:00:00:000</div><div>07:00:00:000</div></div><div><br></div><div>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</div>
<div><br></div><div>I thought that 5.0.0 build April 28, 2012 21:04:55 was a version where this import ability was fixed.</div><div><br></div><div><br></div></div></blockquote><br></div><div>Judging on your bug report <a href="http://www.valentina-db.com/bt/view.php?id=5816">http://www.valentina-db.com/bt/view.php?id=5816</a></div><div>you are trying to import a single column into the table which is under PK (primary key) constraint.</div><div>So you should get a lot of warnings (see Warning*.log) like "PK violation" and zero records imported as a result.</div><div><br></div><div>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.</div><div><br></div><div apple-content-edited="true">
<div>-- <br>Best regards,<br>Ivan Smahin<br>Senior Software Engineer<br>Paradigma Software, Inc<br>Valentina - The Ultra-Fast Database<br><a href="http://www.valentina-db.com/">http://www.valentina-db.com</a></div>
</div>
<br></body></html>