[Solved] Connect and visualize other odb files

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

[Solved] Connect and visualize other odb files

Postby viceant » Tue Jul 26, 2016 9:59 am

Hello, excuse my poor english ;)

I intend to make a principal database and connect it to a auxiliaries databases so that, Calc alike, some fields are linked to another table fields and you can visualize its data but not change them. For example, In Base you can connect to an Access database and visualize its data.

Is there any way to make it in Base?
Last edited by viceant on Wed Aug 17, 2016 1:39 pm, edited 2 times in total.
LibreOffice 5.0.5.2 on Windows 7 Professional 64/ Ubuntu 14.04 LTS
viceant
 
Posts: 19
Joined: Tue Sep 22, 2015 2:40 pm
Location: Spain, Balearic Islands

Re: Connect and visualize other odb files

Postby Villeroy » Tue Jul 26, 2016 10:10 pm

One Base file, one data source. WIthin the data source application you may be able to link text, dBase or something else. To some very limited extent you may overcome this limitation.
In Writer or Calc hit F4. You see a registered database "Bibliography". When you right-click>"Edit Database" then you see that this database is linked a dBase directory in your user profile.
Create a simple plain text file consisting of some values from the "Identifier" field and save this text file in its own directory.
Connect a registered text database to this directory. Like dBase databases, text databases are linked to directories of similar text files.
Now you can create a form in a stand-alone Writer document connected to the text file toghether with a subform connected to the dBase file. This does not work with embedded forms because they always refer to the containing database document. The subform shows the corresponding dBase record for the selected record in the text file.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24374
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Connect and visualize other odb files

Postby viceant » Fri Aug 12, 2016 9:39 am

I guess I need a database in multiuser mode, don't I?
LibreOffice 5.0.5.2 on Windows 7 Professional 64/ Ubuntu 14.04 LTS
viceant
 
Posts: 19
Joined: Tue Sep 22, 2015 2:40 pm
Location: Spain, Balearic Islands

Re: Connect and visualize other odb files

Postby Villeroy » Fri Aug 12, 2016 3:43 pm

You have a registered database "Bibliography". The name refers to a database document <user profile>/database/biblio.odb.
The document is connected to a dBase directory <user profile>/database/biblio/ which contains a dBase file biblio.dbf.

Save the following text data in a text file and save the text file to a dedicated directory as BlahData.csv. The first line "ID" is a column label.
Code: Select all   Expand viewCollapse view
ID
GUR00
PAR00
OOO00
OOO01
OOO02
OOO03
OOO04
SUN00
SUN01
SUN02
SUN03
BAI00
MIL00
HAU00
LEE00
LAM00
GAE00
BOE00
BOE01
TOO00

Now you have a second database of type "Text". Connect a new Base document to it, save it as Blah.odb so you get a second database document blah.odb, linked to some text directory and registered as "Blah".
Now open the attached Writer document which contains a form and a subform. The form on the left shows the IDs from the text file. The subform shows the related details from the dBase file.
Attachments
BlahForm.odt
Linking data from BlaData.csv with details from biblio.dbf
(10.06 KiB) Downloaded 45 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24374
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Connect and visualize other odb files

Postby viceant » Wed Aug 17, 2016 1:37 pm

Ok, thanks
LibreOffice 5.0.5.2 on Windows 7 Professional 64/ Ubuntu 14.04 LTS
viceant
 
Posts: 19
Joined: Tue Sep 22, 2015 2:40 pm
Location: Spain, Balearic Islands


Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 5 guests