Base files used in this way are saved locally (or on a network share) but do not contain any data.īy selecting File->New->Database from within LibreOffice you are presented with a database setup wizard - this will guide you through the steps to connect to uzERP (or any other database backend) LibreOffice uses its own Base application to connect to a postgreSQL backend providing a ‘bridge’ to the Calc spreadsheet - this is analogous to an ODBC connection in Office. Mac and Windows users should go here for installation help. On Ubuntu they can be installed from the software centre or with the following command at the sudo apt install libreoffice-base & libreoffice-sdbc-postgresql Some distributions do not install these LibreOffice components by default so you should check that they are there. In order to connect to postgresql the following components must be installed I use Ubuntu 18.04 on my development laptop and I have version: 6.0.7.3.
The current version of LibreOffice is 6.2, although the repo for your particular operating system may be slightly behind this. Using the open source Calc spreadsheet from LibreOffice and uzERP’s backend database postgreSQL - “The World’s Most Advanced Open Source Relational Database” - this blog post looks at how you can tie the two together to allow users to access information directly with no rekeying. This was also explored in a another post on csv files and LibreOffice Pivot Tables. As noted in a this post, one reason for installing uzERP is to get better information for key decision makers, many of whom like to use spreadsheets to carry out analysis or generate reports.
0 kommentar(er)
