How to rework a template to connect to a database

**apollodriver** · May 27th, 2018

Hello

i need to create a template that is able to be attached to a db in libreoffice

i am not able to do this -

what are the preliminaries to do so --

see what is wanted -

in other words: i need to rework the code of the template that has got a horizontal - weekly laout of the days -

i need to have the template that is designed verticallly

Code:

+------------------------------------------------+
|                                                |
|   ^Tag>                           tag eins     |
|   <Feiertag>                                   |
|   <Quelle>                                     |
|   <Deutsch>                                    |
|   <Französisch>                                |
|   vAltgriechisch>                              |
|                                                |
|                                                |
|                                                |
|                                                |
|                                                |
|    ^Tag>                          tag zwei     |
|    <Feiertag>                                  |
|    <Quelle>                                    |
|    <Deutsch>                                   |
|    <Französisch>                               |
|    vAltgriechisch>                             |
|                                                |
|                                                |
|                                                |
|                                                |
|                                                |
|     etc. - etx.                   etx          |
|                                                |
|                                                |
|                                                |
+------------------------------------------------+

and yes - finally i have to be able to connect the db.

see the DATA: -i need to connect the template to the database
see here
https://www.mediafire.com/file/fwm6k...3/kalender.odb
https://www.mediafire.com/file/5djdo...g/Kalender.odt

**oldos2er** · May 28th, 2018

What operating system are you using?

**apollodriver** · May 30th, 2018

Hello

i need to create a template that is able to be attached to a db in libreoffice

i am not able to do this -

what are the preliminaries to do so --

see what is wanted -

in other words: i need to rework the code of the template that has got a horizontal - weekly laout of the days -

i need to have the template that is designed verticallly

Code:

+------------------------------------------------+
|                                                |
|   ^Tag>                           tag eins     |
|   <Feiertag>                                   |
|   <Quelle>                                     |
|   <Deutsch>                                    |
|   <Französisch>                                |
|   vAltgriechisch>                              |
|                                                |
|                                                |
|                                                |
|                                                |
|                                                |
|    ^Tag>                          tag zwei     |
|    <Feiertag>                                  |
|    <Quelle>                                    |
|    <Deutsch>                                   |
|    <Französisch>                               |
|    vAltgriechisch>                             |
|                                                |
|                                                |
|                                                |
|                                                |
|                                                |
|     etc. - etx.                   etx          |
|                                                |
|                                                |
|                                                |
+------------------------------------------------+

and yes - finally i have to be able to connect the db.

see the DATA: -i need to connect the template to the database
see here
https://www.mediafire.com/file/fwm6k...3/kalender.odb
https://www.mediafire.com/file/5djdo...g/Kalender.odt __weekly__template__.odt 2018_05_20_calender_template_horizontal_.odt calender_template_horizontal_.odt vertical_weekly_template__.odt weekly-calendar-2018-portrait-days-vertically.ods

**apollodriver** · May 31st, 2018

i am running linux - opensuse linux version 42.3

i would be very very glad if you can help me

**apollodriver** · May 31st, 2018

hier i have some view with an panorama mode - tihis should be flipped to porrait mode

http://www.mediafire.com/file/4y35k6...late_basis.ods

is this doable!?

**coffeecat** · May 31st, 2018

Duplicate threads merged and moved from the Cafe to the openSUSE and SUSE Linux Enterprise sub-forum.

**apollodriver** · June 1st, 2018

hello dear Coffeecat
many many thanks for your moderation - thanks for this great place - it is such a lovley place for idea exchange

i try to do some experiments with the flip of the text in the cells

**apollodriver** · June 1st, 2018

well i just hae created some data that need to go into the vertical view - in other words the portrait-VIiew:

PLZ See the folllowing dataset -

qiustion : well i guess that i woulld be able to put this dataset into a __handmade__ calendar tempalte - that i fill with coy apser

note: see the date

Quote:

05.01.18 1.Petrus 5,10 Der Gott aller Gnade, der euch berufen hat zu seiner ewigen Herrlichkeit in Christus, der wird euch, die ihr eine kleine Zeit leidet, aufrichten, stärken, kräftigen, gründen. Le Dieu de toute grâce, qui vous a appelés en Jésus -Christ à sa gloire éternelle, après que vous aurez souffert un peu de temps, vous perfectionnera lui-même, vous affermira, vous fortifiera, vous rendra inébranlables. Ὁ δὲ θεὸς πάσης χάριτος, ὁ καλέσας ὑμᾶς εἰς τὴν αἰώνιον αὐτοῦ δόξαν ἐν Χριστῷ [Ἰησοῦ], ὀλίγον παθόντας αὐτὸς καταρτίσει, στηρίξει, σθενώσει, θεμελιώσει.
06.01.18 Lukas 1,78-79 Unser Gott ist voll Liebe und Erbarmen; er schickt uns den Retter, das Licht, das von oben kommt. Dieses Licht leuch km,,tet allen, die im Dunkeln sind, die im finsteren Land des Todes leben. Grâce aux entrailles de la miséricorde de notre Dieu, En vertu de laquelle le soleil levant nous a visités d'en haut, | Pour éclairer ceux qui sont assis dans les ténèbres et dans l'ombre de la mort, Pour diriger nos pas dans le chemin de la paix. διὰ σπλάγχνα ἐλέους θεοῦ ἡμῶν, ἐν οἷς ἐπισκέψεται ἡμᾶς ἀνατολὴ ἐξ ὕψους, | ἐπιφᾶναι τοῖς ἐν σκότει καὶ σκιᾷ θανάτου καθημένοις, τοῦ κατευθῦναι τοὺς πόδας ἡμῶν εἰς ὁδὸν εἰρήνης.
07.01.18 Johannes 1,45 Philippus spricht zu Nathanael: Wir haben den gefunden, von dem Mose im Gesetz und die Propheten geschrieben haben, Jesus, Josefs Sohn, aus Nazareth. Philippe rencontra Nathanaël, et lui dit: Nous avons trouvé celui de qui Moïse a écrit dans la loi et dont les prophètes ont parlé, Jésus de Nazareth, fils de Joseph. εὑρίσκει Φίλιππος τὸν Ναθαναὴλ καὶ λέγει αὐτῷ· ὃν ἔγραψεν Μωϋσῆς ἐν τῷ νόμῳ καὶ οἱ προφῆται εὑρήκαμεν, Ἰησοῦν υἱὸν τοῦ Ἰωσὴφ τὸν ἀπὸ Ναζαρέτ.

well as mentioned above: you see the dates - and you also can see the texts.

Note: these texts need to go into the portrait - calendar template.

what do you guess - now all i need is to have such a portrait calendar-template. Then i can go on..

what do you say!?