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
[Solved] Use fields from registered database in pdf-file
-
- Posts: 881
- Joined: Mon May 30, 2011 4:02 am
[Solved] Use fields from registered database in pdf-file
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.
Re: like to use fields from registered database in pdf file
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.
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)
W11 22H2 (build 22621), LO 7.4.2.3(x64)
-
- Posts: 881
- Joined: Mon May 30, 2011 4:02 am
Re: Like to use fields from registered database in pdf file
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
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.