RPI Consultants Knowledge Base

PDF Editing with Perceptive Content & PDFtk Server

Leveraging open source PDFtk Server software is a great way to enhance your current Perceptive Content process by adding functionality to automatically fill out PDF forms. If you have a large number of PDF forms to fill out using predefined data that can be pulled from a database, csv file, or any other source accessible through iScript, you can save a great deal of time with PDFtk instead of resorting to manual data entry.

PDFtk Server is a tool that can be used to fill out a PDF form with an FAF file containing all of the necessary form fields and values requiring an update. With a simple iScript, you can create the FAF file using data pulled from a database, csv file, or another source. Once the FAF file is created, the iScript can run the necessary PDFtk commands required to pair the newly generated FAF file with the PDF Form. The result is a new PDF document containing all of the information defined in the FAF file created through the iScript process.

We’ve put together a proof of concept to display the PDFtk Server functionality. In the video, Geoff Lilienfeld demonstrates the simplicity of combining the FAF file with the original PDF form to create our filled out PDF form output. The FAF file mentioned is where we can define every form field specific to our desired PDF form and enter any value that we want to update the field to. When it comes to PDF forms, the possibilities are endless.

Although the focus of this post has been filling out forms, PDFtk Server can also merge PDFs, split PDFs, rotate PDF pages, flatten forms, apply watermarks, and a number of other things. The great news is that all of this functionality can be accessed through the command line, so all of the functionality can be leveraged through an iScript.

Transcript

So, what we’ve done is we’ve created a simple command line application that can be called from the Perceptive Content, iScript, and what it does is, it starts, we will just maintain a … we have a PDF here, an image of a W2, which can be obtained from the IRS, of course. We utilize PDFTK to drive the application, which is a free library. So, there’s no licensing there, and of course, you might notice that I’m doing this on a Mac, but this does run the same on Windows, including Windows Server. Then, so, when we’re calling it from Perceptive Content, we’ll pass it the variables, so for every row in a CSV file, it will create an image, and store that image within Perceptive Content, and index it appropriately. In our case here, for the purpose of this demo, I just have some hard coded variables here.

So, if I run this command line, you’ll not that it just created this test W2 output, and that has the data on here. So, if I wanted to change this to anything, control, number 6789abc, save that, rerun this. Let’s go ahead and call this output2, and run that. We’ll now have a new PDF, and you will note that we now have an updated control number. So, again, this can be run from Perceptive Content iScript, and then we will be able to store these images within Perceptive Content, and securely retrieve them from clicking a link within Lawson.

Want More Content?

Sign up and get access to all our new Knowledge Base content, including new and upcoming Webinars, Virtual User Groups, Product Demos, White Papers, & Case Studies.

[gravityform id=”4″ title=”false” description=”false” ajax=”false” /]

Follow us online for faster access to announcements, knowledge base updates, and upcoming events!

Entire Knowledge Base

All Products, Solutions, & Professional Services

Contact Us to Get Started

Don’t Just Take Our Word for it!

See What Our Clients Have to Say

Denver Health

“RPI brought in senior people that our folks related to and were able to work with easily. Their folks have been approachable, they listen to us, and they have been responsive to our questions – and when we see things we want to do a little differently, they have listened and figured out how to make it happen. “

Keith Thompson
Director of ERP Applications

Atlanta Public Schools

“Prior to RPI, we were really struggling with our HR technology. They brought in expertise to provide solutions to business problems, thought leadership for our long term strategic planning, and they help us make sure we are implementing new initiatives in an order that doesn’t create problems in the future. RPI has been a God-send. “

Skye Duckett
Chief Human Resources Officer

Nuvance Health

“We knew our Accounts Payable processes were unsustainable for our planned growth and RPI Consultants offered a blueprint for automating our most time-intensive workflow – invoice processing.”

Miles McIvor
Accounting Systems Manager

San Diego State University

“Our favorite outcome of the solution is the automation, which enables us to provide better service to our customers. Also, our consultant, Michael Madsen, was knowledgeable, easy to work with, patient, dependable and flexible with his schedule.”

Catherine Love
Associate Human Resources Director

Bon Secours Health System

“RPI has more than just knowledge, their consultants are personable leaders who will drive more efficient solutions. They challenged us to think outside the box and to believe that we could design a best-practice solution with minimal ongoing costs.”

Joel Stafford
Director of Accounts Payable

Lippert Components

“We understood we required a robust, customized solution. RPI not only had the product expertise, they listened to our needs to make sure the project was a success.”

Chris Tozier
Director of Information Technology

Bassett Medical Center

“Overall the project went really well, I’m very pleased with the outcome. I don’t think having any other consulting team on the project would have been able to provide us as much knowledge as RPI has been able to. “

Sue Pokorny
Manager of HRIS & Compensation

MD National Capital Park & Planning Commission

“Working with Anne Bwogi [RPI Project Manager] is fun. She keeps us grounded and makes sure we are thoroughly engaged. We have a name for her – the Annetrack. The Annetrack is on schedule so you better get on board.”

Derek Morgan
ERP Business Analyst

Aspirus

“Our relationship with RPI is great, they are like an extension of the Aspirus team. When we have a question, we reach out to them and get answers right away. If we have a big project, we bounce it off them immediately to get their ideas and ask for their expertise.”

Jen Underwood
Director of Supply Chain Informatics and Systems

Our People are the Difference

And Our Culture is Our Greatest Asset

A lot of people say it, we really mean it. We recruit good people. People who are great at what they do and fun to work with. We look for diverse strengths and abilities, a passion for excellent client service, and an entrepreneurial drive to get the job done.

We also practice what we preach and use the industry’s leading software to help manage our projects, engage with our client project teams, and enable our team to stay connected and collaborate. This open, team-based approach gives each customer and project the cumulative value of our entire team’s knowledge and experience.

The RPI Consultants Blog

News, Announcements, Celebrations, & Upcoming Events

News & Announcements

High Fives & Go Lives

Upcoming Events

Go to Top