Free Download Libreoffice Base
Leon Marcellus
I know a lot of time has passed but I wanted to mention that when libreoffice is installed from PPA without Base and then one installs Base by itself (sudo apt-get install libreoffice-base), the separate report-builder is not installed and you get similar issues. So by installing it thus:
I have created a contact list database which will be used by others. Opening it needs to be very, very simple, opening right to the contact list form to enter data (without having to look at the Base application interface.) Is there any way to create a desktop link, button, icon, not sure of the correct term, something that would just stay on the desktop whether or not libreoffice Base was open, so they could click it and have the form open?
(continued) So clicking the desktop link opens the Writer document with a button in it.
Clicking the button in the Writer document opens the Writer version of the form.
Well fine, but I cannot figure out how to get data into the database from the Writer version of the Base form.
Create an ODB file.
Register this ODB file with LO (see the built-in help on registering databases).
Create a Writer form which is bound to the datasource of your ODB file, or create a form within your ODB file and then save it to a separate location.
Create a link on your desktop to the Writer form file.
Double-click to open your form and gain access to the underlying DB.
LibreOffice Base is a free and open-source database development and administration tool for relational database management systems that is part of the LibreOffice office suite. LibreOffice Base was built off of a fork of OpenOffice.org and was first released as version 3.4.0.1 on October 4, 2011.[4]
LibreOffice Base is designed to allow users to easily create, access, modify, and view databases and their data. This is done by providing users with a graphical user interface that allows users to work with four main tools: Tables, queries, forms, and reports.[6][7] Base includes software wizards to assist users with various aspects of the program.[8][9] LibreOffice Base requires Java in order to create databases with forms, wizards, and more.[10]
Base is able to work with both embedded and external database files. Embedded databases are stored as a single file using C++ based Firebird and Java-based HSQLDB as its storage engine. When connecting to external databases, Base acts as a graphical user interface front-end to facilitate interactions with various database systems including Access Database Engine (ACE/JET), ODBC/JDBC data sources, MySQL, MariaDB, and PostgreSQL.[7]
Base has been described as an unusual project in the niche of database management system software which tends toward proprietary software designed for enterprise users.[6] Proprietary database management software costs have been described as a reason for the use of Base in small businesses.[11]
The SDK is a development kit for LibreOffice 7.4, which eases the development of office components. It provides a set of libraries, binaries, header, and IDL files which have final API's and can only be extended with new functionality. This set of libraries and binaries is the minimum set of functions needed to use system abstraction for base functionality and for using UNO (Universal Network Objects) component technology. The UNO component model is the base of the whole Office API. The SDK provides everything necessary to use the Office API from external programs (e.g. Java, C++) or to extend the Office functionality with new components (e.g. new filter components, CalcAddin functions). It is compatible over several versions because the API remains unaffected and will only be extended with new functions.
Since JavaScript and Node.js does not exist in Haiku yet, I planned on using LibreOffice Base to create front-ends for my PostgreSQL databases. However, I soon discovered the LibreOffice Base is flat-out broken!
YABasic could be an option if the JDBC driver could be used and I have no clue how to do that in YABasic. In VB, I designate the JDBC drvier and it just works but VB was designed with databases in mind over the years.
Open up LibreOffice Base and the database wizard will start. From the window, select Connect to an existing database and, from the drop-down, select MySQL. Click Next and then make sure Connect using JDBC is selected (Figure B).
35fe9a5643