{"id":11962,"date":"2020-01-20T17:38:50","date_gmt":"2020-01-20T17:38:50","guid":{"rendered":"https:\/\/www.directimpactsolutions.com\/?p=11962"},"modified":"2023-05-22T19:15:42","modified_gmt":"2023-05-22T19:15:42","slug":"word-excel-to-pdf-in-filemaker","status":"publish","type":"post","link":"https:\/\/www.directimpactsolutions.com\/en\/word-excel-to-pdf-in-filemaker\/","title":{"rendered":"Converting Word &amp; Excel to PDF in FileMaker"},"content":{"rendered":"<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Converting-to-PDF.gif\" alt=\"converting Word and Excel to PDF in FileMaker\" class=\"wp-image-11963\" width=\"690\" height=\"204\"\/><\/figure><p>Document storage is a crucial capability of a FileMaker database. <a href=\"https:\/\/www.microsoft.com\/en-ca\/microsoft-365?omkt=en-US&amp;rtc=1\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft Word and Excel<\/a> files are among the most commonly stored files, and portable document format (PDF) has become the go-to format for file sharing.<\/p><p>It\u2019s helpful to preview and share Word and Excel files in PDF format in order to avoid sharing the original file. There\u2019s also a need to display these files without having to install Office apps for all FileMaker users.<\/p><p>AppWorks has developed a lightweight tool to accomplish this task, as demonstrated by the GIF above. No FileMaker plugins or 3rd party APIs are being used; this is all accomplished using native OS and FileMaker scripts.<\/p><h3 class=\"wp-block-heading\">Use case:<\/h3><p>For example, you can modify an invoice in MS Word and upload it to the database. FileMaker can then automatically convert the file to portable document format and send it to the desired recipient. A copy of the sent PDF file is stored in FileMaker for auditing purposes. Automating this workflow can be a great timesaver.<\/p><h4 class=\"wp-block-heading has-medium-font-size\"><strong>Manual workflow:<\/strong><\/h4><ul class=\"wp-block-list\"><li>Modify the Word document<\/li>\n\n<li>Export as PDF<\/li>\n\n<li>Upload the Word document<\/li>\n\n<li>Upload the PDF file<\/li><\/ul><h4 class=\"wp-block-heading has-medium-font-size\"><strong>Automated workflow:<\/strong><\/h4><ul class=\"wp-block-list\"><li>Modify the Word document<\/li>\n\n<li>Upload the Word document<\/li><\/ul><h3 class=\"wp-block-heading\">Features<\/h3><ul class=\"wp-block-list\"><li>Reliable and accurate conversions<\/li>\n\n<li>Fast<\/li>\n\n<li>Easy to manage and modify<\/li>\n\n<li>No recurring or upgrade fees<\/li>\n\n<li>Supports MS Office versions as old as Office 2003<\/li>\n\n<li>Supports bookmarks based on headings or bookmarks in Word<\/li>\n\n<li>Quick implementation into FileMaker databases using&nbsp;<a href=\"https:\/\/directimpactsolutions.com\/en\/how-to-download-a-file-from-filemaker-server-19\/\">FileMaker Server<\/a>&nbsp;18 or later&nbsp;<em>(Upgrades are easy, please contact us if this is a challenge for you)<\/em><\/li>\n\n<li>Smart logic to detect if a file was already converted and if a new portable document format file should be generated if the source file changed<\/li>\n\n<li>Human readable logs<\/li><\/ul><h3 class=\"wp-block-heading\"><strong>Supported conversions:<\/strong><\/h3><ul class=\"wp-block-list\"><li>.doc to .pdf<\/li>\n\n<li>.docx to .pdf<\/li>\n\n<li>.xls to .pdf<\/li>\n\n<li>.xlsx to .pdf<\/li><\/ul><p>If you\u2019re interested in converting files to portable document format in your FileMaker database, we\u2019re happy to help implement this functionality in your solution. You can contact us&nbsp;<a href=\"https:\/\/directimpactsolutions.com\/en\/contact-us\/\">here.<\/a>&nbsp;Please note that implementing this technique requires FileMaker Server 18 and above, and that the maximum supported file size is 64 MB.<\/p><hr class=\"wp-block-separator has-alpha-channel-opacity\" style=\"margin-top:var(--wp--preset--spacing--70);margin-bottom:var(--wp--preset--spacing--70)\"\/><p class=\"has-small-font-size\"><em>*This article was originally written for AppWorks, which has since joined Direct Impact Solutions. This article is intended for informative purposes only. To the best of our knowledge, this information is accurate as of the date of publication.<\/em><\/p>","protected":false},"excerpt":{"rendered":"<p>Document storage is a crucial capability of a FileMaker database. Microsoft Word and Excel files are among the most commonly stored files, and portable document format (PDF) has become the go-to format for file sharing. It\u2019s helpful to preview and share Word and Excel files in PDF format in order to avoid sharing the original &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.directimpactsolutions.com\/en\/word-excel-to-pdf-in-filemaker\/\"> <span class=\"screen-reader-text\">Converting Word &amp; Excel to PDF in FileMaker<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":6,"featured_media":11966,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"","footnotes":""},"categories":[29],"tags":[231,39,203,230],"class_list":["post-11962","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-low-code","tag-excel","tag-filemaker","tag-pdf","tag-word"],"uagb_featured_image_src":{"full":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Converting-Word-and-Excel-to-PDF-in-FileMaker.jpg",1500,750,false],"thumbnail":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Converting-Word-and-Excel-to-PDF-in-FileMaker-150x150.jpg",150,150,true],"medium":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Converting-Word-and-Excel-to-PDF-in-FileMaker-300x150.jpg",300,150,true],"medium_large":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Converting-Word-and-Excel-to-PDF-in-FileMaker-768x384.jpg",768,384,true],"large":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Converting-Word-and-Excel-to-PDF-in-FileMaker-1024x512.jpg",1024,512,true],"1536x1536":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Converting-Word-and-Excel-to-PDF-in-FileMaker.jpg",1500,750,false],"2048x2048":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Converting-Word-and-Excel-to-PDF-in-FileMaker.jpg",1500,750,false],"woocommerce_thumbnail":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Converting-Word-and-Excel-to-PDF-in-FileMaker-300x300.jpg",300,300,true],"woocommerce_single":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Converting-Word-and-Excel-to-PDF-in-FileMaker-600x300.jpg",600,300,true],"woocommerce_gallery_thumbnail":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Converting-Word-and-Excel-to-PDF-in-FileMaker-100x100.jpg",100,100,true]},"uagb_author_info":{"display_name":"Direct Impact Solutions","author_link":"https:\/\/www.directimpactsolutions.com\/en\/author\/direct-impact-solutions\/"},"uagb_comment_info":0,"uagb_excerpt":"Document storage is a crucial capability of a FileMaker database. Microsoft Word and Excel files are among the most commonly stored files, and portable document format (PDF) has become the go-to format for file sharing. It\u2019s helpful to preview and share Word and Excel files in PDF format in order to avoid sharing the original&hellip;","_links":{"self":[{"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/posts\/11962","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/comments?post=11962"}],"version-history":[{"count":5,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/posts\/11962\/revisions"}],"predecessor-version":[{"id":12334,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/posts\/11962\/revisions\/12334"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/media\/11966"}],"wp:attachment":[{"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/media?parent=11962"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/categories?post=11962"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/tags?post=11962"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}