Ask Your Question
1

Problem with libreOffice base

asked 2018-05-03 12:37:17 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Hello, i made a database in libreoffice base and i want to share this file with my friend because we need to work on this file parallel. when i tried to do it with the writer (i used the google drive for shere) for example, there wasnt a problem. but there is no option to "remote file" in the base files. what can i do?? thank you very much!! Tal

edit retag flag offensive close merge delete

Comments

@TAL: In the future, please do not check the community wiki checkbox. See guidelines for asking.

Jim K gravatar imageJim K ( 2018-05-03 15:25:19 +0200 )edit

2 Answers

Sort by » oldest newest most voted
1

answered 2018-05-03 16:42:47 +0200

Ratslinger gravatar image

Hello @TAL,

This is NOT a problem with Base. Using a remote storage service for Base is more complex. Base is only a front end to a database. Many use it with the default embedded HSQLDB. But many (including myself) also use it with a variety of DB's. This presents a problem in trying to open, save & close as happens in Writer or Calc for example.

You can still use Google Drive or another service such as DropBox by utilizing a client program and a synchronized folder. Google Drive only has clients for Windows & Mac. For Linux you need to use a third party client such as CloudCross or Ocamlfuse (those are free but there are more which have a cost). Have tested both & are very slow. Personally I would prefer using DropBox which has clients available for Windows, Mac, Linux & Android.

Once you have a process set, the files(s) sync from the storage(cloud) to the specified folder. Then, especially with Base, copy what is to be worked with to a local folder & work with it from there. When ready to store it again, just copy from local folder to synced folder & the updated version is stored in the cloud. Most have built in versioning.

References:

Google Drive

Cloud Cross

Ocamlfuse

DropBox

Some sharing info on DropBox - Sharing database using Dropbox

If this answers your question please tick the ✔ (upper left area of answer). It helps others to know there was an accepted answer.

edit flag offensive delete link more

Comments

Normally I use Dropbox as well. My answer discusses Google Drive because that's what LibreOffice gives as an option for remote storage.

Jim K gravatar imageJim K ( 2018-05-03 21:42:49 +0200 )edit
1

answered 2018-05-03 16:27:58 +0200

Jim K gravatar image

Apparently Base with embedded setup does not allow remote file locations.

To test this, I first put a copy of an ODB file on Google Drive. Then, from the LibreOffice Start Center, I went to Remote Filesas described at https://help.libreoffice.org/6.1/en-U.... So far, so good. It loaded the file from Google Drive.

However, trying to view a table produced the following error message.

The connection to the data source "New Database" could not be established.

The given URL contains no valid local file system path. Please check the location of your database file.

To fix this, I went to Save As and saved a copy of the file to the local machine. Now everything worked properly.

After changes were made, I had to open Google Drive via Chrome Web Browser and drag the file to upload it, because I do not see any way for LibreOffice to save Base files remotely.

Now, what you should be using is a split database setup with an engine such as MySQL. In that case, the ideal way is to connect remotely to a database server. However, for personal use, most of us do not have access to a networked database server machine.

Instead, what I have done in the past is to use MyISAM tables which get saved on the local machine as text files. Then set up a script to copy any changed tables along with the ODB file to and from the shared drive. Not nearly as convenient as the remote functionality that LibreOffice Writer has, but it gets the job done.

edit flag offensive delete link more

Comments

@Jim K Using a Google client & synced folder would eliminate all that 'save as' and using a browser. After initial log in, just copy & past to/from the synced folder.

Ratslinger gravatar imageRatslinger ( 2018-05-03 20:05:32 +0200 )edit

Agreed. I went about it the way I did not because it was easier but in order to determine what functionality LibreOffice provides.

Jim K gravatar imageJim K ( 2018-05-03 21:39:15 +0200 )edit
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2018-05-03 12:37:17 +0200

Seen: 419 times

Last updated: May 03 '18