[Bug 152429] Enhancement: Allow BASE to access multiple external data sources

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=152429

Heiko Tietze <heiko.tietze at documentfoundation.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|Linux (All)                 |All
           Keywords|needsUXEval                 |
                 CC|libreoffice-ux-advise at lists |gabriel.masei at 1and1.ro,
                   |.freedesktop.org            |heiko.tietze at documentfounda
                   |                            |tion.org
             Status|UNCONFIRMED                 |NEW
     Ever confirmed|0                           |1
             Blocks|                            |104790, 108441

--- Comment #7 from Heiko Tietze <heiko.tietze at documentfoundation.org> ---
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 on the CC list for the bug.