AnsweredAssumed Answered

How to script printing of multiple layouts plus multi page PDFs in containers in sequence.

Question asked by AnthonyTesoriero on May 3, 2014
Latest reply on Jul 5, 2016 by mikebeargie


How to script printing of multiple layouts plus multi page PDFs in containers in sequence.


     I need some scripting written for a filemaker solution.
     We need a script that will print a multipage PDF within a printing sequence.
     Knowing your familiarity with filemaker PRO, you know that filemaker is unable to print multipage PDF's in container fields. Further complicating the mater filemaker pro for mac has a frequent problem crashing on larger files when using Adobe as the default web plugin to view PDF files, thereby making it necessary to default to using "preview" for mac as the default reader. The problem with using preview though is that when certain documents were created originally using acrobat such as forms or PDFs with embedded pics, Preview will fail to recognize the data on the forms or the embedded pics thereby rendering a blank page, making its necessary to use Acrobat only to print the documents...
     Our solution requires us to batch print large amounts of documents from found sets within our database.
     Each record has a series of layouts that must be printed in a specific order and a collection of attachments (container fields) that must also be printed.
     Currently we are able to batch print all the filemaker layout documents in the proper sequential order for a batch, (Average 20 records per batch, each record having 10 pages = 200 Pages (without corresponding attachments) 
      Because of filemaker's limitations however we must then manually go into each record, open each relevant attachment, right click to "open as" Adobe PDF, execute a print command, manually close the adobe window, manually close the filemaker container window and repeat for each relevant attachment per record.... As you can imagine this becomes very time consuming. 
     To make matters more complicated we then have to hand collate the documents to insert the separately printed container PDF's and associate them with the other printed docs...
     Ideally we would like a cross platform solution that will enable us to print the entire file in the proper sequential order so that it is pre collated.  (i.e. Print 5 layouts, print container 1, print 3 layouts, print container 2, print 2 layouts, print containers 3 and 4) move to next record repeat...
     However if a cross platform solution is not possible we would opt for a MAC only solution.
     Any assistance you can provide is appreciated.