On 20 January 2016 at 21:34, Andreas Säger <[email protected]> wrote:
> How can anybody solve any csv related problem without knowing anything > about > the actual content? > > 4 different lines of perfectly valid and commonly used csv data: > > 1234.98;2014-12-22 > 1.234,98;22 Dez 2014 > 1234.98;12/22/14 > 1234.98;22/12/14 > > Each line carries the exact same information. I could add a thousand more > different lines with the exact same values without leaving the conventions > of valid csv. > Exactly, this is why I have invested in pretty a intelligent auto-detection of data types and representation of values in Kexi CSV importer. Yes, dates values are the most tricky. Sure, the auto-detection has limits, importing has to be _interactive_ at times, at least until we "know" all the options user wants to use, then the user would be able to save and re-use an 'import specification'. For complicated import cases it's not a matter of a custom SQL statement, it's sometimes a trial-and-error process. The only thing I would regret is that we have no organized FOSS effort to share such routines and every app has own. Not yet at least. (Ian has sent me a rich feedback off the list, work in progress) > > > -- > View this message in context: > http://nabble.documentfoundation.org/LibreOffice-Base-and-MySQL-tp4172396p4172475.html > Sent from the Users mailing list archive at Nabble.com. > > -- > To unsubscribe e-mail to: [email protected] > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > > -- regards, Jaroslaw Staniek KDE: : A world-wide network of software engineers, artists, writers, translators : and facilitators committed to Free Software development - http://kde.org Calligra Suite: : A graphic art and office suite - http://calligra.org Kexi: : A visual database apps builder - http://calligra.org/kexi Qt Certified Specialist: : http://www.linkedin.com/in/jstaniek -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
