Frank Schönheit - Sun Microsystems Germany ha scritto:
FYI. As always, feedback is highly appreciated in [EMAIL PROTECTED]
Ciao
Frank
-------- Original Message --------
Subject: Link CSV/Text files into HSQL databases / preliminary / 0.2
Date: Tue, 05 Sep 2006 15:52:01 +0200
From: Frank Schönheit <[EMAIL PROTECTED]>
Reply-To: [email protected]
To: [email protected]
Title
=====
Link CSV/Text files into HSQL databases
Location
========
http://dba.openoffice.org/specifications/Link_CSV_Text_files_into_HSQL_databases.odt
Revision
========
0.2
Status
======
preliminary
Changed
=======
first public version
Abstract
========
In business processes, it's often necessary to exchange data between
completely different applications. One common, widely-used, simple
file-based format is CSV: text files containing multiple rows of
homogenous data.
OpenOffice.org can already process such data in Calc, by interpreting
the data therein as spreadsheet data, and in Base, by accessing it as
relational database table. Especially the latter feature is rather
limited, as it's not possible to update the data, or build more complex
data models, for instance including relational integrity.
HSQLDB, the default database engine used by OpenOffice.org Base,
features linkage of CSV/Text files, handling them as if they were native
HSQL tables, including applicability of the full power of the HSQL
database engine.
This document describes an user interface, implemented for
OpenOffice.org Base, which allows to conveniently manage those linked
tables in an HSQL database.
Comments
========
good for a first impression / discussion, still lacking quite some items
Issues
======
n/a
Feedback
========
mailto:[email protected]
Hi Frank,
first of all, my personal thanks for this improvement. I often work with
tables saved as csv files and the ability to directly link them to Base
will simplify a lot their management, to me.
At a first glance at your document, I'd say that nothing lacks. Then,
I'm very eager to test the new feature.
Best regards and thanks again,
Franco
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
