Questions tagged [libreoffice-base]

Database front end and management tool of the LibreOffice suite

Filter by
Sorted by
Tagged with
0
votes
0answers
22 views

Scripting LibreOffice Base - languages pros and cons [on hold]

As per https://help.libreoffice.org/Common/Scripting one can use 4 languages for scripting in Libre Office: LibreOffice Basic JavaScript BeanShell Python Question part A: did I miss something? I ...
0
votes
1answer
23 views

Importing big bunch of files to LibreOffice Base table in one shot

I have table like this: and a bunch of CSV files like this: in per-patient directories. Please note that I need to take a Patient field from path name and Date from file name (as you see). What is ...
0
votes
1answer
19 views

LibreOffice Base Primary Key of several columns?

I have created a database with one table like this: How to create a primary key like: (Patient, Date, Test, Parameter) ? The database will be holding data for numerous patients examined multiple ...
0
votes
0answers
6 views

Automatic Expansion of Fields in Libre Office Base reports: Possible?

I want to generate a report in Libre Office Base. One of the fields is a text field -- "memo" I believe is the word -- that can be quite long. I think the longest example is not quite two ...
0
votes
0answers
9 views

Does the LibreOffice query wizard support criteria that compare columns?

I am trying to teach a lesson based on a third-party educational module about desktop database products such as MS Access, LibreOffice Base, and OpenOffice Base. The module attempts to be agnostic ...
0
votes
0answers
12 views

HSQLDB Merge failure :Unexpected token: MERGE in statement [ MERGE]

Running the worked example from the manual I get an error at the MERGE stage. I was reduced to running this after trying my own code and getting the same error but hoped the doco example would work! I ...
0
votes
1answer
100 views

How to dynamically update a LibreOffice spreadsheet from file?

I have a CSV file with data I want in a spreadsheet - mostly to display a chart based on it. I also want the chart to be updated every time the file is rewritten by a console application. What I tried ...
1
vote
0answers
62 views

Libreoffice base combo box populating text boxes

I am using Libreoffice Base 4.2.8.2 on Zorin OS 9 I need a combo box (Business names) which will fill in text boxes text box 1 (Address)text box 2 (Phone) text box 3 (email) etc. It must be a combo ...
1
vote
1answer
356 views

Set background color in LibreOffice base form

The title pretty much says it all. I am trying to create a form in design view in LibreOffice and I can't see any control that allows me to set the background color. I've seen some old answers to ...
0
votes
1answer
199 views

Subtracting two times in libre office base

How can I subtract two times in a query in libre office base? For instance, 10:30 - 9:00 should give 1:30. Thanks. EDIT: As it says in the question, I am having this problem in "base", not with the ...
0
votes
1answer
19 views

Query that needs input from two different records

I have a "timecard" table. A few typical entries might look like ID task date start time 1 proj_XDFR 4/5/18 8:30 2 proj_PEIRN 4/5/18 9:45 3 proj_ERU54 ...
1
vote
1answer
28 views

Libre Office form — need data sheet layout with a lookup field

I am trying to develop a timecard form. The fields are ID, task, date, start time, and stop time. I want to create the form as a datasheet. I don't know the specific name for this, but I want it to ...
0
votes
1answer
233 views

Sync sheets in Libreoffice

Hopefully someone can help. I have an eccommerce dropship website on Woocommerce which I update via CSV using WPAllImport. I currently download a CSV Spreadsheet from my supplier which contains ...
1
vote
1answer
301 views

Cannot edit imported data in Libreoffice Base

I am using Libreoffice Base for my International GCSE ICT exam. I am practicing with past papers, but I can't get it to work. The files provided come as separate csv files, which have to be imported. ...
1
vote
2answers
3k views

Libreoffice Base: Need today's date as default value in a form field

New to libreoffice Base. I've found how to set the default value in a table to the current date. Now I need to have the current date show up in the corresponding field in a form. I have tried ...
0
votes
1answer
938 views

How to add a datasheet-style (grid) form/field in LibreOffice Base design view?

When creating a LibreOffice Base form via the Wizard, it is possible to choose a 'datasheet' style for the selected fields. The fields become part of a Mainform_Grid and/or Subform_Grid item if you ...
3
votes
2answers
1k views

LibreOffice 5.2.2.2 won't run without Java

I am trying to get LibreOffice to work with my Mac. We are trying to use the database application, but keep getting asked to install Java so it can connect to the tables. I have installed Java and ...
1
vote
0answers
26 views

LibreOfficeDev5.3 on Ubuntu 16.04 does not save modified forms

I've installed LO dev 5.3, because I need direct SQL to work, which I read was fixed in this version, but now I'm facing the issue that I can't edit any forms anymore. I can create new forms using the ...
2
votes
1answer
3k views

Populate foreign key using combo/dropdown on form

I'd like to populate a foreign key field in one table using a combobox/dropdown where the values the user sees are not the IDs but a description field from the foreign table. Consider the following ...
0
votes
1answer
152 views

modify a view that other views depend on

I use LibreOffice Base to create weekly reports. I have one table (named time_spent) that contains a lot of normalized data, and I am using views to do the processing required to produce the reports I ...
1
vote
0answers
313 views

LibreOffice Base sub form with multiple rows displayed

How do I show multiple lines in my sub-form? For example, my main form is a prospect, with the sub-form recording and displaying one or more activity. After creating the sub-form, only one line is ...
1
vote
0answers
141 views

How to print a LibreOffice Base Relation Design?

I've gone to the trouble of creating a graphic representation of my database design using Relation Design tool in LibreOffice Base. How can I print that out/export it to a PDF to share with others, ...
0
votes
1answer
40 views

OpenOffice showing syntax eror

Here's what I have so far: SELECT DISTINCT Min("gpa"."current_gpa"), "students"."lastname", "students"."firstname" FROM "students", "gpa" WHERE "students"."...
3
votes
0answers
5k views

Libreoffice Base: How have a combobox linked to a related table linked to or in the form table control

I could not sum up, what I really want in the title. But here I am going to try to explain what is it about. I have switched from MS Access to Libreoffice Base because it is open source, free and ...
1
vote
1answer
659 views

How to use data contained in several related database tables for a form letter?

I want to create a form letter with LibreOffice Writer. The data is contained in a LibreOffice Base database, in several tables. I followed the guide Creating a Form Letter. It seems that I can only ...
2
votes
2answers
2k views

Can LibreOffice Base directly use MySQL syntax?

From what I can see, LibreOffice Base comes with an HSQLDB implementation by default. I understand that ODBC allows users to connect to different data sources, including databases that use different ...
0
votes
2answers
2k views

Is it possible to put a wildcard search into a parameter query in LibreOffice Base?

I am using Base in LibreOffice 4.0 (still using the HSQL that comes with Base but looking at moving to HSQL 2.2.8) and I would like to do a query that asks for parameter input like: SELECT * FROM "...
0
votes
1answer
716 views

Trouble connecting to LibreOffice Base database in split database mode using HSQL 2.2.8

I am trying to install a split database (starting with a file copy) using an upgrade to HSQL 2.2.8. I got HSQL 2.2.8, and have followed the instructions from another post on this site ( How to set up ...
3
votes
1answer
11k views

How to set up the jdbc driver to connect to hsqldb from libreoffice?

I am trying to "split" a LibreOffice .odb file into a HSQL database and an OpenOffice document containing forms and macros. I am trying to follow the instructions from this thread: Within a few ...
2
votes
0answers
827 views

How to represent m:n relationships in a form in Libre Office base?

I have an embedded database in Libre Office. I am building a form in it, and got into a problem. I have a table called "Author" and another table called "Publication", connected by a third table "...
1
vote
1answer
589 views

Postgresql is not avaible in Libreoffice Base

I want to edit a postgresql base using libreoffice-base. When I launch the database wizard of Libreoffice-base, I am blocked at the first step: I can select an existing base, but the only ones ...
1
vote
2answers
917 views

No option to print LibreOffice Base document

My husband is trying to print out a document he has produced in LibreOffice Base. Unfortunately there is no option to print and we have tried everything we can think of. Bit of a Luddite so please ...
1
vote
1answer
3k views

How to use CREATE TABLE queries in LibreOffice Base?

I'm using LibreOffice 3.5.4.2 (from Ubuntu 12.04 packages) and trying to create tables using SQL's CREATE TABLE statement. For the first few attempts I got a message saying that the query must be a ...
0
votes
1answer
3k views

Libreoffice Base: combobox keeps replacing value to 0

I have a ComboBox which loads a country list, every time i select one item and then focus in other object of the form it resets to 0. This ComboBox is linked with an Integer value in the main table (...
0
votes
1answer
3k views

Can LibreOffice Base odb databases migrate to SQL server?

If I make a LibreOffice Base database in its native ODB format, is it possible to later migrate the database to a SQL server such as PostgreSQL??? If so, how? Thanks!
17
votes
2answers
36k views

How do I connect to a PostgreSQL server using LibreOffice Base?

I'm running into errors when I try to connect to a PostgreSQL server on the local machine using LibreOffice Base 3.5 (this applies to LibreOffice 4 as well): The following syntax (localhost:5432=<...
2
votes
0answers
286 views

Querying DB2 view from Libreoffice Base

I've created a view in DB2 that has the information I need for labels that I was hoping to print out from LibreOffice. When I query the view from the console ("SELECT * FROM ADDRBOOK.LABELS"), I get ...
0
votes
2answers
3k views

Dynamic Filtering on LibreOffice Base Reports

Is it possible to do a Dynamic Filtering on LibreOffice Base Reports?
7
votes
2answers
3k views

Insert a field at a specific position

In a LibreOffice Base document, the sequence of fields in a table definition is important[0]. But when I ask the “Table Design” dialogue to insert a field, or to paste a row from the clipboard, it ...