GSoC: Add support for importing tables from LibreOffice Base to Kexi [was: The results of your email commands]

[Jaroslaw Staniek]

On 19 February 2014 11:11, Jayesh Hathila <sharma.jayesh52 at gmail.com> wrote:
> Hi,
> (Ya that was .mdb )
> After going through different possible ways by which this can be
> implemented, I settled with the below one :
> I would probably need to obtain a connection to the db that the .odb
> specifies, and then will create the .csv (of tables) from there. Then that
> .csv can be imported simply as that will only have tables not the queries or
> records or anything.
>
> I just wanted to have other's view on my approach, is it fine or do I need
> to tune it more?

Good to see you're further analyzing the task.

Requirements are as follows:
- schema of each table should be imported, mapped to capabilities of KexiDB
- then tables should be re-created using the KexiDB API
- then tables should be populated with records fetched from the
original tables of the .odb database

This means that using the intermediate CSV (mostly typeless) format
we're loosing schema information such as existence of primary keys,
types, unique constraints, and everything that you can use in Kexi's
Table Designer. The extra step also makes the process more complicated.
CSV is not a common-denominator format used by Kexi.

So the suggestion is to look how it's done in the mdb
migration driver, then in other migration drivers.

Importing queries, forms, reports, scripts is out of scope of the task.

-- 
regards / pozdrawiam, Jaroslaw Staniek
 Kexi & Calligra & KDE | http://calligra.org/kexi | http://kde.org
 Qt for Tizen | http://qt-project.org/wiki/Tizen
 Qt Certified Specialist | http://www.linkedin.com/in/jstaniek