Bug 121805 - uploading documents into Base (eg pdfs, writer documents) editing UI
Summary: uploading documents into Base (eg pdfs, writer documents) editing UI
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Base-Enhancements
  Show dependency treegraph
 
Reported: 2018-11-29 15:55 UTC by rik
Modified: 2018-12-05 12:40 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description rik 2018-11-29 15:55:54 UTC
This is a feature request: i'm a big fan of Libre Office and would always use it if possible, but i am in the situation now where i need to build a database of documents that my organization has published in the past. To do so, i wish to make a database of names, titles etc for each document. BUt i also wish to upload each document into the database, so that the file is easily shareable to different people and copiable to different hard drives. Unless i've missed it, this is not possible in Base. It IS possible in Access, so I;m working with that now, but hence the feature request:)
Rik
Comment 1 Alex Thurgood 2018-12-04 09:19:22 UTC
@Rik : you can store binary data in your embedded database, but if you do that with embedded hsqldb ODB, the database will become unwieldy (memory management issues) and error prone over time (you also need how to figure out how to display the PDF, but this is technically possible).

Ideally, the PDFs should be stored separately in a file store, and a path URL to each one stored in the database. This will reduce portability though, as the path to the PDF store would have to be identical on each machine (and the store transferred along with the ODB file).


Whilst I can agree to the request for enhacement, given the current environment surrounding embedded database files, I doubt that this is going to change any time soon.
Comment 2 Alex Thurgood 2018-12-04 09:20:57 UTC
This issue has been around since embedded hsqldb in an ODB file was first developed, hence inherited from OOo.