Pergunte aqui

Perfil de hmadhi - atividade

2020-09-05 17:44:37 +0200 Marcada como a melhor resposta LibreOffice Base - Split Database - Cannot see Tables after migration

I have a splitDB configuration which is working fine. However when I move the database to another machine, configure the appropriate Properties for JDBC, I do not see the tables. The Forms, Queries and Reports are intact as these are part of the ODB file. I have copied all the neccessary database files as well viz:

-rwxr--r-- 1 hmadhi hmadhi  5163 May 27 15:36 mydb.script
-rwxr--r-- 1 hmadhi hmadhi 32768 May 27 15:36 mydb.data
-rwxr--r-- 1 hmadhi hmadhi    88 May 27 15:36 mydb.properties

Can someone help in determining why I the ODB file does not show the Tables? I do not want to manually create all tables.

I have using the following Datasource URL

  jdbc: hsqldb:file:///path/to/odb/dir/ mydb;default_schema=true;shutdown=true;hsqldb.default_table_type=cached;get_column_name=false

I have the hsqldb.jar file in the same dir as the odb and mydb files.

2020-09-01 16:52:11 +0200 Marcada como a melhor resposta Libreoffice 5.1 Base: How to use "Push Button" to open a second Form with specific data

I have two forms: 1. PatientConsultsForm (PatientForm + subForm ConsultDetails 2. DispenseForm

On the PatientForm I want a "Push Button" that will open the DispenseForm for the specific PatientID/ConsultID. How do I accomplish this.

2017-08-17 21:20:17 +0200 Medalha recebida  Pergunta famosa (fonte)
2017-03-29 22:34:15 +0200 Medalha recebida  Pergunta famosa (fonte)
2017-01-06 18:03:22 +0200 Medalha recebida  Estudante (fonte)
2016-09-09 15:42:23 +0200 Medalha recebida  Pergunta famosa (fonte)
2016-08-15 17:13:12 +0200 Medalha recebida  Pergunta famosa (fonte)
2016-08-04 16:26:19 +0200 Medalha recebida  Pergunta famosa (fonte)
2016-07-01 02:35:29 +0200 Medalha recebida  Pergunta famosa (fonte)
2016-06-19 08:30:31 +0200 Medalha recebida  Pergunta famosa (fonte)
2016-06-02 16:11:30 +0200 Medalha recebida  Pergunta notável (fonte)
2016-06-02 10:03:33 +0200 Medalha recebida  Torcedor (fonte)
2016-06-02 09:55:45 +0200 Marcada como a melhor resposta LibreBase 5.1 : Multiple Table Subforms

I have the following scenario:

PatientDetails->ConsultDetails (1->N)
ConsultDetails->DispenseDetails (1->M)

PatientDetails

PatientID
PatientName
MedicalAid

ConsultDetails

ConsultID
PatientID
ServiceDate
ReservationNumber

DispenseDetails

DispenseID
ConsultID
TarrifCode
Description
Price

I would like to have a single form that will allow me to add Patient Details, Consult Details as well as Dispense Details. The Consult SubForm (Table) should allow multiple consults to be added. When a specific consult is selected, the corresponding Dispense Details must be shown in the Dispense SubForm (Table).

2016-06-02 09:55:11 +0200 Marcada como a melhor resposta Libre Base 5.1: Open Report based on current record

I have a form that allows a user to input PatientDetails, ConsultDetails (SubForm) and DispenseDetails (SubSubForm). I am now at point where I would like to print a report based on the current record in the form.

How do I specify a filter so that only a single Patient/Consult/Dispense Detail is shown?

2016-06-02 09:53:21 +0200 Marcada como a melhor resposta Libreoffice Base - Display Form based on Group Box Option selected

I have a form that contains Patient Details. I would now like to implement an Group Box so that the user can choose "Cash" or "Medical Aid". The relevant Subform must be displayed depending on what is chosen. Any ideas on how to implement this in Libreoffice Base. I am using LibreOffice version 5.1.3

2016-06-02 09:37:29 +0200 Medalha recebida  Acadêmico (fonte)
2016-06-02 09:36:56 +0200 Medalha recebida  Palpiteiro
2016-06-02 09:36:56 +0200 Resposta comentada Libreoffice Base - Importing/Exporting ODT into/from Form

Thank you @pierre-yves-samyn . The utility works as expected.

2016-06-01 16:57:56 +0200 Medalha recebida  Pergunta popular (fonte)
2016-06-01 11:14:13 +0200 Pergunta comentada Writer form to Base conversion

I have a similar requirement. Essentially I want to import an ODT file back into BASE - see this link.

2016-06-01 10:33:26 +0200 Perguntou Libreoffice Base - Importing/Exporting ODT into/from Form

I know how to export a form created in Base as an ODT to be used as a Standalone Form. However many a times I need to import the ODT file back into the ODB for various reasons. Is there an easy way of doing this?

2016-05-31 16:14:38 +0200 Resposta comentada Libreoffice Base - Display Form based on Group Box Option selected

Cool thanks @Ratslinger

2016-05-31 16:12:59 +0200 Medalha recebida  Pergunta notável (fonte)
2016-05-31 15:47:19 +0200 Pergunta comentada base crashes when opening sqlite db view

Have you tried using JDBC? Thinking maybe SQLiteStudio connects natively to the DB and that's why you don't have a problem.

2016-05-31 15:32:47 +0200 Respondeu uma pergunta Can I just download Writer and Calc?

If you using Linux - Go to the Software Center Search for Libreoffice and install Writer and Calc.

2016-05-31 12:11:20 +0200 Medalha recebida  Pergunta notável (fonte)
2016-05-30 21:50:09 +0200 Resposta comentada Libreoffice Base - Save Records in Forms SubForms SubSubForms

I agree. Its easier to hit Ctrl-S...

2016-05-30 21:46:58 +0200 Medalha recebida  Pergunta notável (fonte)
2016-05-30 21:10:25 +0200 Pergunta comentada Split Database - RFC

As long as the Class Path is setup correctly I don't see/understand why this is an issue. Maybe copy the hsqldb.jar file to the directory holding the the odb file and change the class path as appropriate?

2016-05-29 22:27:00 +0200 Resposta comentada Libreoffice Base - Save Records in Forms SubForms SubSubForms

k thanks for the reply. For the sake of completeness and for the benefit of others as well can you help with a macro to do this. Alternatively can you provide a link?

2016-05-29 22:01:08 +0200 Medalha recebida  Pergunta popular (fonte)
2016-05-29 18:18:15 +0200 Medalha recebida  Pergunta notável (fonte)
2016-05-29 10:42:21 +0200 Perguntou Split Database - RFC

Having looked at various links on how to create a split database and having experimented with them, I am proposing in this post a simpler method and would like your comments, concerns , guidance and questions.

I am using Ubuntu 16.04 LibreOffice 5.1.3

(Unfortunately I cannot upload pictures as I do not have enough points)

These are the steps

  1. Tools -> Options -> LibreOffice->Advanced->Class Path->Add Archive ... Eg.

    /usr/lib/libreoffice/program/classes/hsqldb.jar

  2. Start with Database wizard - "Connect To Existing Database"->"JDBC"

  3. "Set up a connection to a JDBC database" Enter the following:

    Database URL:

    hsqldb:file:////path/to/Project/mydb;default_schema=true;shutdown=true;hsqldb.default_table_type=cached;get_column_name=false
    

    JDBC Class Driver:

org.hsqldb.jdbcDriver
  1. "Setup User Authentication" ... Username = SA

  2. "Decide How To Proceed After Saving The Database"

  3. "Save Database" -> Choose a location eg ~/Project/

The following hsqldb files will be created in ~/Project

mydb.properties
mydb.script
mydb.log
  1. Proceed to create a table eg "Test" Columns ID and add some data

  2. The following additional hsqldb file will be created in the ~/Projects directory

mydb.data

I would like to hear from the community ... any concerns, comments ? Have I missed something important?

2016-05-29 07:35:23 +0200 Medalha recebida  Pergunta popular (fonte)
2016-05-28 19:58:09 +0200 Perguntou Libreoffice Base - Save Records in Forms SubForms SubSubForms

Is there a way of saving data records in a Form/SubForm/SubSubForm with a single click (except the obvious "Save" Button)? I know how to add a button action to save a record on a Form. However in some cases after entering data into a Form/SubForm there should be possibility of saving data with having to save data for each form separately.