Of course these are valid values as for as CSV is concerned, but not ALL are
valid as far as MySQL goes. I have no problem restoring MySQL-DATE COLUMN
values, but represent them as "2014-12-22", the same as character strings.
Forget Base at the moment and deal with the stipulations of SQL, in particular
MySQL.
On Thu, 21 Jan 2016 11:37:51 +0100, Jaroslaw Staniek <stan...@kde.org> wrote:
On 20 January 2016 at 21:34, Andreas Säger <ville...@t-online.de> 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: users+unsubscr...@global.libreoffice.org
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
--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
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
