Ask Your Question

Base: View files from file system [closed]

asked 2012-11-10 19:13:36 +0200

qrider70 gravatar image

It is my understanding that storing binary blobs like photos or videos is discouraged in LO Base. Rather, we should store the location of a file.

In my use case, I will likely want to have a single-user database as I am dealing with a scenario where not everyone is in the same office so using MySQL or similar database is not ideal. With the single-user database, I would have a subfolder in the folder where the database is located. That folder would contain the files that need to be referenced in the database. It could be photos, videos, or other kinds of documents. I will want to set this up so that I can store a filename and then be able to instruct the form how to retrieve it. If it is a photo or video, I would like to be able to display it in the form. If it is another kind of document, I would want to somehow have the OS launch the appropriate application for that type of file.

Where can I find information on how to go about this? In the past, I have had experience with Paradox, Access, and Filemaker. So the basic ideas of setting up a database and using a form editor make sense. But I have not had a need to add references to other files until now. Since my co workers have varying OS's, I thought I would try Base to see if I can put something together for our group.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-25 01:03:35.129466

1 Answer

Sort by » oldest newest most voted

answered 2013-03-01 06:29:18 +0200

qubit gravatar image

Hi @qrider70,

There's a video on Youtube by Shane Piper that sounds like it would be very helpful:

LIBREOFFICE BASE - Insert and display an Image using a Text Field [VARCHAR]

Published on Nov 30, 2012 - This is part 2 of inserting and image in to Libreoffice Base, this is an alternative method of importing image data, but this time just the hyper link or URL of an image and display it along with your employee, student, customer etc.. database.

edit flag offensive delete link more


@qrider70 -- did my answer help you out? Still interested in an answer to your question?

qubit gravatar imagequbit ( 2013-03-14 01:50:42 +0200 )edit

Question Tools



Asked: 2012-11-10 19:13:36 +0200

Seen: 6,151 times

Last updated: Mar 01 '13