Skip navigation
prem maker
Currently Being Moderated

Mail Merge in frame maker?

Nov 16, 2011 3:51 AM

first of all I want to know below things


1) Is there any possibility to connect oracle database from Frame maker Tool?

2) how do i insert dynamic data into .fm file?

3) can i use fdk to connect oracle database?

4) will FDK support java language?


My Requirement:


1) have to create one static paragraph with place holder for dynamic data in frame maker (ex: your loan amount @amt is approved) here @amt is placeholder

2) get amt from database or user and modify @amt with loan amount. (ex: your loan amount 1,00,000 is approved)

3) generate pdf using java code.




  • Currently Being Moderated
    Nov 16, 2011 7:10 AM   in reply to prem maker

    Yes you can do this dynamically either by using a database publishing tool like PatternStream ($$$) or by using FrameScript($) with a good chunk of programming. You also probably could do this with ExtendScript, but I don't know enough about what sort of ODBC there is in this new tool - it's too poorly documented. These approaches would all use a "pull" approach to dynamically pull the content into FM via SQL queries (which you'll also need to program into the application within FM).


    An alternative consideration is to use a "push" approach where the publishing automation is triggereed from the database end. With this approach you can use Datazone's Miramo ($$$ - same league as PatternStream for enterprise tools) or their new Miramo Personal Edition (*freebie*) to take tagged (your own structure or XML) data into FM along with content residing in other FM files (i.e. your merge) to produce final pdfs. his tool is used by many financial and insurance institutions to create customized individual reports, statements, invoices, etc. at rates approaching a quarter-million PDF pages per hour. The Personal Edition is geared to run on the desktop using only FM (by the way the others would require you to get FM Server = $$$), but throughput is down around the range of 25-30k PDF pages/hour.


    With a push approach using either of the Miramo products, you wouldn't need to do any programming on the FM end of things. You would set up the queries in Oracle and generate the reports to feed into FM via Miramo which would then process the mark-up using your business rules to create the FM and PDF files. The FM files in this case are trransient and need not even be generated.


    Check out:





    Miramo Personal Edition (including download area):

    Mark as:
  • Currently Being Moderated
    Nov 16, 2011 8:51 PM   in reply to prem maker

    Nope, no open source. TANSTAAFL


    If you need to do it on the cheap, then either homebrew your code using the FDK or Extendscript, or use the freebie MPE. Otherwise the products are licensed in the enterprise tiers ($$$$$$$$$)

    Mark as:
  • Currently Being Moderated
    Nov 18, 2011 10:31 AM   in reply to prem maker

    See my response in your other thread:


    Weren't there sample files in the MPE download?

    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points