Welcome!

Microservices Expo Authors: Pat Romanski, Elizabeth White, Liz McMillan, Christoph Schell, Matt Brickey

Related Topics: Microservices Expo, Java IoT, Adobe Flex, Machine Learning

Microservices Expo: Article

Form(ing) Standards - Recycling Old Stuff Can Be Incredibly Painful

I am on my favorite soapbox - “standards” – standards around form filling

I am on my favorite soapbox - "standards" - standards around form filling. Generally speaking, no discussion of standards could be complete without an assessment of the state of play of the not so humble Adobe Portable Document Format or as most of us know it, PDF. I debated the merits of the PDF back in the late 1990s (an astonishing 14 years ago) and with the passage of time, a few things have changed but in some respects they are the same.

The reason this topic is quite focal for me at the moment, is the fact that I continue to see customers and prospects take a hard line in wanting to retain their existing PDF documents and at the same time, make them more technically relevant to the continuing trend of trying to eliminate paper forms and improve back office efficiency by avoiding the need for people to laboriously transcribe data from electronic forms into application screens of key record keeping systems like SAP ERP.  This is an area where Winshuttle has made some significant in-roads in helping customers eliminate transcription from Excel and InfoPath into back office ERP systems through an integration layer built around the Microsoft product suite.

Adobe has been around since the early 1980s and the idea of PDF was to create a document format that wouldn't require special processing by the computer, and could be viewed and printed regardless of the installed OS - first version was released in 1993. At the time there was the Macintosh, OS/2 from IBM, DOS and early versions of Windows.

By the mid 1990s, PDF documents were pretty ubiquitous for electronic documents. You needed a reader, which you could often get off a Bulletin Board or bundled with some of the many distributable software packages available at the time. A frustration experienced by many continued to be the fact that Microsoft didn't natively support generating PDF documents from spreadsheets, presentations and Word, and was fighting on several document writing fronts, including against the languishing WordPerfect.  Microsoft did however have Envoy, a program that allowed a reader to read Microsoft Office documents; the availability of this product meant that partners and customers that did not use Microsoft products could still view Microsoft documents.  In 2000, Microsoft released an initial version of an XML-based version of Excel which it incorporated into OfficeXP, later in 2002 Word followed and when Office2003 was released Office open XML was pretty much standard.

Adobe took a little longer than Microsoft to embrace some degree of openness and it was only in 2001 that the PDF specification was opened up for use. Officially, in 2008, it was released as an open standard. But, as Joel Geraci points out on Quora, an Acrobat 1.0 PDF still renders 100% correctly on Acrobat X, more than 15 years later.

This bit of history is important to understand why PDF has been so successful. Consider that despite our relative resistance to generating paper copies of documents, when we do need to reduce an electronic document to a hard copy, it needs to be pretty much pixel perfect. We want the images to appear where they should, we want the fields to line up vertically and we want the pagination to appear at the correct break points in the document. The combination of printers, supported font faces, paper sizes and margins can result in some very interesting outcomes and this too has driven the improvements in products like Microsoft Word to allow a true WYSIWYG experience.  Of course, I try to discourage printing as much as possible and then find myself very frustrated when I discover that the idle printer at home won't print anything because the ink cartridge is as parched as the Gobi desert or the rollers on the laser printer have become as hard as rocks and won't pick up the paper. The visual experience is nonetheless important, especially for form filling.

Many organizations provide online form entry, either regular HTML rendered forms or PDF documents.  PDF also supports embedding of JavaScript to help with the form behavior or data validation.

Some great perspectives on the pros and cons outlined by Quick PDF are:

  • PDF is supported across multiple platforms. This means you see a document exactly as it was created, regardless of what platform it was created on and regardless of the application environment you are viewing it on, whether it be a mobile phone, an Android tablet, an iPad, a Microsoft, Apple or Sun operating system .
  • There's imaging hardware independence too, you can print the same document on a cheap dot matrix printer as well as on a high-end publishing plotter.
  • The documents are relatively compact, the text only versions are compressed, though versions that have encryption or contain images or are scanned documents that have not been processed with an OCR engine can be large.
  • PDFs can contain multimedia elements, such as: graphics, video and audio files, hyperlinks, hotspots and multifaceted multimedia objects.
  • Even As already mentioned, PDF's can be protected. The author has several security options including locking the file so, that it would open only after entering a correct password as well as supporting annotation, or preventing editing, copying content or printing.
  • You can use PDF as many organizations do, on the Internet, but HTML files are much more efficient.
  • You can use PDF to exchange graphics, but most desktop publishing applications support  TIFF, PNG, EPS and JPEG.
  • The focus of PDF is visualization and presentation of the document.  As a consequence it often doesn't preserve the document's logical structure.
  • PDF files often prove hard to modify. It is extremely difficult or even impossible to add a text block or an image to an existing PDF file if you didn't originate that document.

Returning to my problem or frustration of the moment, I looked at the form that was presented to me recently and tried to figure out just how much effort was going to be involved in manipulating this document to work with a Winshuttle Web Service connecting it to SAP. As the support partner at another company stated, "The challenge we have with PDF forms is that the form filling functionality of PDF is much more advanced than the form creation capability of MS Office.  So for us to replicate a PDF form in MS Office, we need to work with imperfect tools to do so. It is essentially like trying to edit an image that has been created with Adobe Photoshop with Microsoft Paint. The advanced tools in one program are just not available in the other."

There had been some hopes that we could simply do a like conversion of PDF content to  MS Office formats, however, when a PDF form is converted to MS Office format, some features (i.e. table lines, boxes, etc) get converted as graphics, which sometimes makes it difficult to edit freely as you would with a simple text document.  Most automation conversion software cannot produce "fillable" forms per se. So don't pin any high hopes on PDF to MS Office converters.

The tricky thing with PDF forms is that they require quite a bit of work sometimes, depending on the nature and complexity of the form.

At face value, the task should have been fairly straightforward. The problem we concluded is that the method used to build the Adobe PDF form doesn't conform to any of the contemporary interactive form standards either for PDF or for MS Office. In addition, one of the characteristics that I discovered emerging in another installation is a seemingly random approach to naming technical objects. Developers have an uncanny ability to come up with some of the most curious names imaginable for technical objects, and although some of them are very descriptive, if there is missing information in either the name or in the documentation of the technical object then supporting them at some later stage will prove to be troublesome especially if the initial developer has moved on to another assignment.

My conclusions? If you're determined to recycle an existing Adobe form, make sure that it is one that has been developed against the backdrop of accepted fillable form standards. Don't be too optimistic about being able to integrate it with anything except itself. Even if the form will never be integrated with anything - it will just be used to gather data - be careful about the types of fillable fields that you use.

Secondly, when naming your technical objects, try to build some degree of intelligence into the naming convention and apply this consistently. Calling a form, for example,  applicationform.pdf is great if you only ever have one application type to support or if you have an overarching all singing all dancing application form. The same sense of standards should apply to your metadata as well.

Finally, be careful about your choice of an Adobe PDF. Do you really need the data to be entered into a pixel perfect document format? Will an Excel-based form, for example, get you to the same place? Even an InfoPath form may be a better proposition. Excel is pretty ubiquitous these days at least. You don't' have to set Excel, InfoPath or even PDF as the standard but you should understand some of the strengths and weaknesses of each of these document types.

Further Reading

PDF vs Markup Language - Clinton Jones

How did the PDF file format become the de facto standard for document publishing? - Quora discussion

Microsoft InfoPath or Adobe Forums? - Kristian Kalsing

More Stories By Clinton Jones

Clinton Jones is a Product Manager at Winshuttle. He is experienced in international technology and business process with a focus on integrated business technologies. Clinton also services a technical consultant on technology and quality management as it relates to data and process management and governance. Before coming to Winshuttle, Clinton served as a Technical Quality Manager at SAP. Twitter @winshuttle

@MicroservicesExpo Stories
"DivvyCloud as a company set out to help customers automate solutions to the most common cloud problems," noted Jeremy Snyder, VP of Business Development at DivvyCloud, in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
There is a huge demand for responsive, real-time mobile and web experiences, but current architectural patterns do not easily accommodate applications that respond to events in real time. Common solutions using message queues or HTTP long-polling quickly lead to resiliency, scalability and development velocity challenges. In his session at 21st Cloud Expo, Ryland Degnan, a Senior Software Engineer on the Netflix Edge Platform team, will discuss how by leveraging a reactive stream-based protocol,...
DevOps at Cloud Expo, taking place October 31 - November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA, is co-located with 21st Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world. The widespread success of cloud computing is driving the DevOps revolution in enterprise IT. Now as never before, development teams must communicate and collaborate in a dynamic, 24/7/365 environment. There is no time to w...
From personal care products to groceries and movies on demand, cloud-based subscriptions are fulfilling the needs of consumers across an array of market sectors. Nowhere is this shift to subscription services more evident than in the technology sector. By adopting an Everything-as-a-Service (XaaS) delivery model, companies are able to tailor their computing environments to shape the experiences they want for customers as well as their workforce.
If you read a lot of business and technology publications, you might think public clouds are universally preferred over all other cloud options. To be sure, the numbers posted by Amazon Web Services (AWS) and Microsoft’s Azure platform are nothing short of impressive. Statistics reveal that public clouds are growing faster than private clouds and analysts at IDC predict that public cloud growth will be 3 times that of private clouds by 2019.
"Outscale was founded in 2010, is based in France, is a strategic partner to Dassault Systémes and has done quite a bit of work with divisions of Dassault," explained Jackie Funk, Digital Marketing exec at Outscale, in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
"We focus on SAP workloads because they are among the most powerful but somewhat challenging workloads out there to take into public cloud," explained Swen Conrad, CEO of Ocean9, Inc., in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
"I think DevOps is now a rambunctious teenager – it’s starting to get a mind of its own, wanting to get its own things but it still needs some adult supervision," explained Thomas Hooker, VP of marketing at CollabNet, in this SYS-CON.tv interview at DevOps Summit at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
For over a decade, Application Programming Interface or APIs have been used to exchange data between multiple platforms. From social media to news and media sites, most websites depend on APIs to provide a dynamic and real-time digital experience. APIs have made its way into almost every device and service available today and it continues to spur innovations in every field of technology. There are multiple programming languages used to build and run applications in the online world. And just li...
If you are thinking about moving applications off a mainframe and over to open systems and the cloud, consider these guidelines to prioritize what to move and what to eliminate. On the surface, mainframe architecture seems relatively simple: A centrally located computer processes data through an input/output subsystem and stores its computations in memory. At the other end of the mainframe are printers and terminals that communicate with the mainframe through protocols. For all of its appare...
Your homes and cars can be automated and self-serviced. Why can't your storage? From simply asking questions to analyze and troubleshoot your infrastructure, to provisioning storage with snapshots, recovery and replication, your wildest sci-fi dream has come true. In his session at @DevOpsSummit at 20th Cloud Expo, Dan Florea, Director of Product Management at Tintri, provided a ChatOps demo where you can talk to your storage and manage it from anywhere, through Slack and similar services with...
"Peak 10 is a hybrid infrastructure provider across the nation. We are in the thick of things when it comes to hybrid IT," explained Michael Fuhrman, Chief Technology Officer at Peak 10, in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
Data reduction delivers compelling cost reduction that substantially improves the business case in every cloud deployment model. No matter which cloud approach you choose, the cost savings benefits from data reduction should not be ignored and must be a component of your cloud strategy. IT professionals are finding that the future of IT infrastructure lies in the cloud. Data reduction technologies enable clouds — public, private, and hybrid — to deliver business agility and elasticity at the lo...
"At the keynote this morning we spoke about the value proposition of Nutanix, of having a DevOps culture and a mindset, and the business outcomes of achieving agility and scale, which everybody here is trying to accomplish," noted Mark Lavi, DevOps Solution Architect at Nutanix, in this SYS-CON.tv interview at @DevOpsSummit at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
"As we've gone out into the public cloud we've seen that over time we may have lost a few things - we've lost control, we've given up cost to a certain extent, and then security, flexibility," explained Steve Conner, VP of Sales at Cloudistics,in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
"I will be talking about ChatOps and ChatOps as a way to solve some problems in the DevOps space," explained Himanshu Chhetri, CTO of Addteq, in this SYS-CON.tv interview at @DevOpsSummit at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
DevOps is often described as a combination of technology and culture. Without both, DevOps isn't complete. However, applying the culture to outdated technology is a recipe for disaster; as response times grow and connections between teams are delayed by technology, the culture will die. A Nutanix Enterprise Cloud has many benefits that provide the needed base for a true DevOps paradigm. In their Day 3 Keynote at 20th Cloud Expo, Chris Brown, a Solutions Marketing Manager at Nutanix, and Mark Lav...
"NetApp's vision is how we help organizations manage data - delivering the right data in the right place, in the right time, to the people who need it, and doing it agnostic to what the platform is," explained Josh Atwell, Developer Advocate for NetApp, in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
Five years ago development was seen as a dead-end career, now it’s anything but – with an explosion in mobile and IoT initiatives increasing the demand for skilled engineers. But apart from having a ready supply of great coders, what constitutes true ‘DevOps Royalty’? It’ll be the ability to craft resilient architectures, supportability, security everywhere across the software lifecycle. In his keynote at @DevOpsSummit at 20th Cloud Expo, Jeffrey Scheaffer, GM and SVP, Continuous Delivery Busine...
"We do one of the best file systems in the world. We learned how to deal with Big Data many years ago and we implemented this knowledge into our software," explained Jakub Ratajczak, Business Development Manager at MooseFS, in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.