{"id":7703,"date":"2014-07-07T14:39:35","date_gmt":"2014-07-07T19:39:35","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/docs\/?page_id=7703"},"modified":"2023-07-21T10:49:55","modified_gmt":"2023-07-21T15:49:55","slug":"merge-data-to-pdf","status":"publish","type":"ht_kb","link":"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/merge-data-to-pdf","title":{"rendered":"Merge Data to PDF"},"content":{"rendered":"\n<p>Occasionally, customers desire to have data from within their database be merged into an editable\/interactive PDF file (Also known as PDF Forms). This documentation will walk you through this process.<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-alert\">The output you generated is not intended to be fed back into the database. This template&#8217;s sole purpose to quickly and efficiently generate pre-filled PDF forms for you.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Video Walkthrough<\/h2>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Merge Data to PDF\" width=\"643\" height=\"362\" src=\"https:\/\/www.youtube.com\/embed\/b9h33REqEQU?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Configuration<\/h2>\n\n\n\n<p>To begin, you must have access to an editable PDF file, as m-Power will not create one for you. Save this editable PDF file to your m-Power folder. mrc recommends placing this file in a new folder called &#8220;pdf&#8221; directly off of your root \/m-power folder.<\/p>\n\n\n\n<p>Next, build a new retrieval application, choosing the &#8220;Merge Data to PDF&#8221; template. Be sure to select all tables and fields that you would possibly wish to utilize in your PDF Merge. Be sure to select a unique Dimension field(s) and then build the application.<\/p>\n\n\n\n<p>Prior to running the application, open &#8220;Edit Properties,&#8221; and navigate to the &#8220;Map PDF Fields&#8221; tab:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/MergePDF1.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>Be sure to specify to your application, via the &#8220;Data to PDF Retrieval&#8221; option, the location of your editable PDF file. <\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">You may use ${mpower} to specify the root m-Power folder.<\/p>\n\n\n\n<p>While here, be sure to set the &#8220;List PDF Variables&#8221; option to &#8220;Yes&#8221;. This option will allow you to determine the specific input names used within your editable PDF file. Save the properties once done.<\/p>\n\n\n\n<p>When you run the application, you will be presented with a listing of every editable field within the PDF file, as well as the input type (Text, Checkbox, etc..) associated with this input. Please print this page.<\/p>\n\n\n\n<p>Next, return back to &#8220;Edit Properties&#8221; and navigate to the &#8220;Map PDF Fields&#8221; tab once again. Seeing as you no longer need the PDF&#8217;s input listing, you must change &#8220;List PDF Variables&#8221; back to &#8220;No.&#8221; <\/p>\n\n\n\n<p>Below this option you will find a listing of all of the fields with your application. Here you will assign the PDF&#8217;s input boxes to your application&#8217;s fields. You need not assign every field to a PDF input, but any fields not mapped will not be merged into your PDF output.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.mrc-productivity.com\/docs\/vue-images\/MergePDF2.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>Once completed, press OK. When you run the application now, since your &#8220;List PDF Variables&#8221; property is set to &#8220;No&#8221;, your application will automatically generate a PDF file for you.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.mrc-productivity.com\/docs\/images\/mergepdf3.png\" alt=\"\"\/><\/figure>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h2 class=\"wp-block-heading\">Other Notes<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Since the Merge Data to PDF is a retrieval, you may use standard retrieval URL syntax to call this application directly from another application. For example, lets say my Merge Data to PDF application was sequenced by Employ_Id. If I have a separate retrieval that lists all of my employee information, I could build a link that calls the Merge Data to PDF passing in slnk=1 and Employ_ID= the current employee id. When an end-user clicks on the link at run-time, the PDF would automatically be generated for the end-user.<\/li>\n\n\n\n<li>Also available in the application properties are the options to customize the PDF output filename and to flatten the PDF. Type the desired filename into the Output PDF Filename property, including the .pdf extension (i.e. output_name.pdf). The output filename must be different than the source PDF filename. The Flatten PDF Form property will make the PDF output not editable after output. If Preserve PDF Form is selected, users are able to edit the PDF form.<\/li>\n<\/ul>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Occasionally, customers desire to have data from within their database be merged into an editable\/interactive PDF file (Also known as PDF Forms). This documentation will walk you through this process. Video Walkthrough Configuration To begin, you must have access to an editable PDF file, as m-Power will not create one&#8230;<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[249],"ht-kb-tag":[274],"class_list":["post-7703","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-retrieval","ht_kb_tag-pdf"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/7703","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/comments?post=7703"}],"version-history":[{"count":14,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/7703\/revisions"}],"predecessor-version":[{"id":13002,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/7703\/revisions\/13002"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/media?parent=7703"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-category?post=7703"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-tag?post=7703"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}