Skip to main content
Question

How to generate multiple PDF files from an Oracle database with a common image (logo).

  • October 30, 2023
  • 1 reply
  • 70 views

Good morning. I'm writing this question to see if someone can provide a new idea! I saw couple blogs talking about, but without good result.

I am trying to generate an atlas, given an Oracle database, of different files, each one with its ID, generating a PDF file for each one.

The problem appears when adding a common image, such as a logo. If it comes from a reader, when doing a "fanout" on the writer, how it detects that it does not have an ID generates a file separate from the others, with the common information.

After trying with a cloner, feature merger, or adding an attribute that is the path to the image for each record, I cannot get it to be seen (I can show that the path is physically written).

Any ideas? Thank you so much!

1 reply

redgeographics
Celebrity
Forum|alt.badge.img+62

Any common items, such as that logo, will have to be duplicated for every output PDF and get the appropriate attribute you're fanouting on.

 

I usually do that through an unconditional join: e.g. a FeatureMerger with the same value for both requestor and supplier key (value, not attribute!)