[libreoffice-users] Can I embed ODB Database file in Writer document?

[Joshua Kramer]

Hello-

Is it possible to either have a small (less than 50 records) database
in a Writer document, or embed an ODB database right in the document
(instead of having it be in an external file)?

I have a document that has two different views of the same data.
Right now I'm doing everything by hand, which is error-prone and
inefficient. I thought I could just create a small database table and
then have the two views based on the table. But I also want it to be
portable, i.e. if I want someone else to edit this file I can just
send one file containing both the writer document and the database.

Thanks!
-JK

[Alexander Thurgood]

Le 24/07/2017 à 17:18, Joshua Kramer a écrit :

Hi Joshua,

Post by Joshua Kramer
Is it possible to either have a small (less than 50 records) database
in a Writer document, or embed an ODB database right in the document
(instead of having it be in an external file)?

No and no, respectively.

From what I understand, it is now possible to have a mailmerge Writer
document that contains the data referenced by the mailmerge stored
within the Writer document. Whether or not this successfully transfers
over to another machine is something I haven't tested.

Post by Joshua Kramer
I have a document that has two different views of the same data.
Right now I'm doing everything by hand, which is error-prone and
inefficient.

In what sense are you talking about views ? Do you mean actual database
views in the classical DBA sense, or do you mean some graphical
representation of the data in a formatted Writer document ?

Post by Joshua Kramer
portable, i.e. if I want someone else to edit this file I can just
send one file containing both the writer document and the database.

So unless I have really misunderstood what it is you are attempting to
achieve, you can already do this with just a single ODB file.

The ODB file can contain a series of queries, views (in the DBA sense of
the word), Writer forms displaying data either obtained from views or
queries, and even reports. This file can be sent to other users who can
then edit it to their heart's content.


Alex

[Gabriele Ponzo]

I haven't tested yet the embedding mail merge, but it could somehow be the
solution...

It's a matter of knowing better the requirements and do some testing.

Post by Alexander Thurgood
Hi Joshua,

Post by Joshua Kramer
Is it possible to either have a small (less than 50 records) database
in a Writer document, or embed an ODB database right in the document
(instead of having it be in an external file)?

No and no, respectively.
From what I understand, it is now possible to have a mailmerge Writer
document that contains the data referenced by the mailmerge stored
within the Writer document. Whether or not this successfully transfers
over to another machine is something I haven't tested.

Post by Joshua Kramer
I have a document that has two different views of the same data.
Right now I'm doing everything by hand, which is error-prone and
inefficient.

In what sense are you talking about views ? Do you mean actual database
views in the classical DBA sense, or do you mean some graphical
representation of the data in a formatted Writer document ?

Post by Joshua Kramer
portable, i.e. if I want someone else to edit this file I can just
send one file containing both the writer document and the database.

So unless I have really misunderstood what it is you are attempting to
achieve, you can already do this with just a single ODB file.
The ODB file can contain a series of queries, views (in the DBA sense of
the word), Writer forms displaying data either obtained from views or
queries, and even reports. This file can be sent to other users who can
then edit it to their heart's content.
Alex
--
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted