[Solved] Use fields from registered database in pdf-file

Discuss the database features
Post Reply
dreamquartz
Posts: 881
Joined: Mon May 30, 2011 4:02 am

[Solved] Use fields from registered database in pdf-file

Post by dreamquartz »

Hi All,

I have a multi page pdf-file to which I would like to add fields from a registered database in LO.
Some of the fields to be repeated on all pages.
I cannot seem to find a method to do so.
I am able to add a field to a single page, and copy it to a next page, but it appears not to be a copy of itself, but a new reference.
I know that multi page pdf-files, opened in Draw, are actually single drawings in Draw, and there lays the real problem.

Any suggestions?

Thanks in advance,

Dream
Last edited by dreamquartz on Tue Mar 12, 2019 7:46 am, edited 1 time in total.
LO 7.x, HSQLDB 2.7.x & Ubuntu 22.04 LTS.
eremmel
Posts: 1080
Joined: Tue Dec 30, 2008 1:15 am

Re: like to use fields from registered database in pdf file

Post by eremmel »

PDF documents are ment to be read-only or at most act as a form.
The normal way is to create a document with the proper tooling (OpenOffice, MS Office, ....) and then convert to PDF or print to PDF printer. During the creation process one has the freedom to use information via a registered Base document.
It's Microsoft marketing that tells you computers are qualified for non-technicians
W11 22H2 (build 22621), LO 7.4.2.3(x64)
dreamquartz
Posts: 881
Joined: Mon May 30, 2011 4:02 am

Re: Like to use fields from registered database in pdf file

Post by dreamquartz »

My solution:
1. Saved pdf-file as png-pictures
2. Create new page styles, per png-picture, in Writer
3. Link page-styles together via "Page-Style"-> "Organizer"->"Next style" as next page for document
4. Import appropriate Bitmap(s) @ "Page Style"-> "Area"
5. Set "Page Style"-> "Area" -> "Style" as 'Stretched'
6. Set page margins for every page are set to '0', to get the best results
7. Create required document with required pages, based on created page style
8. "Insert"-> "Field"-> "More Fields" and select appropriate DataBase fields to be placed, where needed by using margins, tabs, indents, and spacing to move the field to the location where needed

The result is a document with multiple page backgrounds, equal to the original pdf-file, but now in Writer, where fields appear to be located in the correct place.

I can now load the document in question and use Queries from my DataBase to print a Writer file, based on the results of the Queries.

Dream
LO 7.x, HSQLDB 2.7.x & Ubuntu 22.04 LTS.
Post Reply