Base-Daten in Writer drucken - als Serienbrief

[sayhello]

Moin Community,

ich möchte die Felder aus einer Datenbank im Dokument verwenden - und eine fertige Writer-Template dafür einsetzen es geht um ein Kalenderblatt mit sieben Tagen - also einen Wochenkalender.

Die Daten in Base hab ich auch schon.
Ferner auch schon ein Writer-Template


Wie würdet Ihr vorgehen!?

Freue mich von Euch zu hoeren.

[Villeroy]

Create a query which includes the relevant data of the week.
Since I know the database you are talking about:

Code: Select all

SELECT * FROM "qMerge" 
WHERE WEEK("D")=:Wochennummer

Insert database fields from that query into your Writer template (menu:Insert>Fields>Other... Database...)
Every time you print the text document, you will be asked for the week number.

[sayhello]

hello dear villeroy ,

first of all - many thanks for the quick reply.


i have a db where the data is stored in a table - named kalendarium

https://www.mediafire.com/file/fwm6k28f ... lender.odb

i have a template for a writer [serial-print] with seven days layout

https://www.mediafire.com/file/5djdowe1 ... lender.odt


now i need ot run the db [table named kalendarium ] against the writer file called Kalender odt

and and all hellp is greatly appreciated

[sayhello]

good evening

after some further investigations i have gathered more insithts.

i guess that i have to atttach the database to Libreoffice somehow.

Extras → Optionen → LibreOffice Base → Database. aferwards i use [New…] and go to the .odb-file and sign up this.

In Writer i open all with Strg + ⇧ + F4 the files, and choose the right ones - with drag and drop - with the mouse the header-title out of the base-database
in the text.