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

Discuss the database features

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

Postby dreamquartz » Sun Mar 10, 2019 2:00 am

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 6.x and OO 4.x on Windows 7 PRO & Ubuntu 18.04 LTS.
dreamquartz
 
Posts: 701
Joined: Mon May 30, 2011 4:02 am

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

Postby eremmel » Sun Mar 10, 2019 1:22 pm

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.
Is your question answered: edit your initial post add "[Solved]" to the subject and check V
LO4.2.8 for work with ORB; AOO4.1.4,LO5.2.5/6.0.5 on W7E SP1 64bit
It's Microsoft marketing that tells you computers are qualified for non-technicians
User avatar
eremmel
Volunteer
 
Posts: 1037
Joined: Tue Dec 30, 2008 1:15 am
Location: Barneveld, Netherlands

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

Postby dreamquartz » Tue Mar 12, 2019 7:45 am

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 6.x and OO 4.x on Windows 7 PRO & Ubuntu 18.04 LTS.
dreamquartz
 
Posts: 701
Joined: Mon May 30, 2011 4:02 am


Return to Base

Who is online

Users browsing this forum: No registered users and 3 guests