PDF Form Filling, XML & RPA Integration

How to create reader-friendly documents from XML or JSON data–automatically!

This demo also shows how to harness the efficiency of Robotic Process Automation (), powered by our partners at AstroRPA, to take a tedious multi-step work routine and turn it into a hands-off process completed in a fraction of the time.

In this scenario, our user receives survey responses in the form of XML data attached to an email. For the purposes of making the information easily readable to the average person, they would like to fill that data into actual forms and store those PDFs in their document management system for viewing later. This allows them to view both electronic and paper responses in a human-readable format in the same repository.

Easily fill forms from XML data

SimpleIndex can read data from XML, JSON, or simple table formats like or Excel, into fillable . But there's some prep work that must be done because the XML data arrives in a single file, but SimpleIndex needs individual XML and PDF files for each survey to generate the documents.

In our scenario, the user has to carry out the following steps:

  1. Move the XML attachment from email to a folder
  2. Open the XML and copy each survey results block to its own individual XML file
  3. Save those individual XML files to the “Input” folder of the SimpleIndex job
  4. Copy one blank PDF form for each XML file to the “Input” folder
  5. Name each blank PDF form with the same name as the XML file e.g. “Patient-001.xml” and “Patient-001.pdf”
  6. Run the SimpleIndex job to create the filled-in PDF forms

Using AstroRPA, we can create a robot that performs all these steps while the user goes for a cup of coffee 🍵 Is there truly a time savings? Watch the video to see both the user and the robot (hint: the robot is about 9 times more efficient 🤖).


Automated XML to Forms with SimpleIndex and AstroRPA

Many document processes require you to prepare documents for processing, such as downloading docs and data files from a website or third party app, splitting and sorting the files, etc.. After processing, they often need to be uploaded to another website or third-party app along with the required . Using RPA, you can fully integrate these steps into a single automated no matter what applications or websites are used, without any API integrations or custom coding.

Contact Us to find out how our automation experts can put SimpleIndex and RPA to work for you!

Learn More:

Scan, file, and process document data quickly and efficiently with Simple Software's tailored OCR automation and one-click processing that fits your unique business needs
Use SimpleIndex OCR to convert scanned and digital images to searchable PDF files for automated sorting, filing, and export to applications such as Word, Excel, PowerPoint, etc.
Automatically and accurately convert scanned and digital documents with simple and complicated tables to PDF files, Excel, Google Sheets, CVS, and other spreadsheet formats with Simple Software's advanced document management suite including Abbyy FineReader, Simple Index, SimpleView, SimpleSearch, SimpleSend, SimpleExport, SimpleCoversheet, and AI components
SimpleIndex OCR automation analyzes, classifies, verifies, and exports digital data into searchable documents that can be stored and processed in a variety of SQL applications
Simple Software's Document management OCR (Optical Character Recognition) uses smart machine-learning and AI (artificial intelligence) methods to convert handwritten and digital text and image data into machine-readable text, allowing users to search, index, and organize large volumes of document data
Simultaneously recognize, analyze, and export large volumes of documents and digital data with SimpleIndex batch OCR (Optical Character Recognition) for processes dealing with large volumes of documents, such as digitizing paper and scanned archives or processing document data in a document management system
SimpleIndex Server enterprise OCR lets users automatically perform optical character recognition on thousands of documents at a time, scaling to meet the demands of the large volumes of document conversions and processes tailored to the user's specifications
SimpleIndex OCR data capture technology and page layout analysis automatically identifies common invoice data elements (vendor, date, amount, invoice number, line item data, etc.) to automate data entry, eliminate errors, automate retrieval, match POs (Purchase Orders), validate quantities and prices, automate electronic document management and storage