https://bugs.documentfoundation.org/show_bug.cgi?id=152429
Heiko Tietze <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- OS|Linux (All) |All Keywords|needsUXEval | CC|libreoffice-ux-advise@lists |[email protected], |.freedesktop.org |heiko.tietze@documentfounda | |tion.org Status|UNCONFIRMED |NEW Ever confirmed|0 |1 Blocks| |104790, 108441 --- Comment #7 from Heiko Tietze <[email protected]> --- Hm... this CREATE TEXT TABLE() works (only for the deprecated HSQLDB) and creates a table with a different icon, so I guess there is some difference but I cannot read it in some properties dialog. The subsequent commands SET TABLE and SOURCE fail with "1: Unexpected token: SOURCE in statement [SOURCE] at /usr/src/debug/libreoffice-fresh/libreoffice-24.2.5.2/connectivity/source/drivers/jdbc/Object.cxx:173". UI-wise I could imagine to add another link in the Tasks view "Connect to CSV file..." that opens the file, reads the column names from the first row, and guesses the data format from the following (Gabriel implemented something similar recently). Eventually it's pretty easy to change the field type. I wonder if other DB types such as Firebird can deal with CSV too. Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=104790 [Bug 104790] [META] Database connectivity interfaces (ODBC, JDBC..) and external databases https://bugs.documentfoundation.org/show_bug.cgi?id=108441 [Bug 108441] [META] Database table bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
