[Kexi] Importing database ...

[Sebastian Sauer]

On Thursday 14 September 2006 09:56, Jarosław Staniek wrote:
> David Love said the following, On 2006-09-14 06:16:
> > I have migrated from the RISC OS platform, using an Acorn RiscPC
> > computer.  Over the years I have developed several databases which, in
> > addition to the native format are able to be exported as either CSV or
> > TSV files.  Is there any way I can import these into Kexi?
>
> David,
> CSV format (and TSV what's a version of CSV) is supported natively in Kexi
> within its GUI. Table is created after you import a single file. For more
> options take a look here http://kexi-project.org/pics/1.0/csv_import.png
> There are import and export commands in File menu, and copy/paste "special"
> commands in Edit menu, so using clipboard is also an option that can speed
> up your work.
>
> To be honest - what's not yet suported is to importing additional data to
> already-existing table.

To extend that; it is not supported nativly, but since Kexi comes with a 
full-powered scripting-framework (Python and Ruby, Javascript-integration is 
on progress) you are able to just use the Scripts Manager located at the 
Tools-menu to fetch the newest version of the CopyCenter-script ( 
http://www.kde-files.org/content/show.php?content=35251 ) and use that script 
to import and export between multiple backends including CSV, QtSQL and 
KexiDB. Also importing (or update) into already existing tables is supported 
and since the script is written in Python, you are able to easily change or 
extend it to your own needings.

-- 
Sebastian Sauer aka dipesh[sebsauer]
http://www.dipe.org/public_key.asc
Fingerprint: 8F1E 219B 16E6 4EC7 29CC F408 E193 65E2 9134 2221
Coder in http://www.koffice.org && http://www.kmldonkey.org