Welcome!

Microservices Expo Authors: Liz McMillan, Pat Romanski, Elizabeth White, Mehdi Daoudi, Yeshim Deniz

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

Microservices Articles
All zSystem customers have a significant new business opportunity to extend their reach to new customers and markets with new applications and services, and to improve the experience of existing customers. This can be achieved by exposing existing z assets (which have been developed over time) as APIs for accessing Systems of Record, while leveraging mobile and cloud capabilities with new Systems of Engagement applications. In this session, we will explore business drivers with new Node.js apps ...
Using new techniques of information modeling, indexing, and processing, new cloud-based systems can support cloud-based workloads previously not possible for high-throughput insurance, banking, and case-based applications. In his session at 18th Cloud Expo, John Newton, CTO, Founder and Chairman of Alfresco, described how to scale cloud-based content management repositories to store, manage, and retrieve billions of documents and related information with fast and linear scalability. He addres...
While some developers care passionately about how data centers and clouds are architected, for most, it is only the end result that matters. To the majority of companies, technology exists to solve a business problem, and only delivers value when it is solving that problem. 2017 brings the mainstream adoption of containers for production workloads. In his session at 21st Cloud Expo, Ben McCormack, VP of Operations at Evernote, discussed how data centers of the future will be managed, how the p...
Digital Transformation is well underway with many applications already on the cloud utilizing agile and devops methodologies. Unfortunately, application security has been an afterthought and data breaches have become a daily occurrence. Security is not one individual or one's team responsibility. Raphael Reich will introduce you to DevSecOps concepts and outline how to seamlessly interweave security principles across your software development lifecycle and application lifecycle management. With ...
Containers and Kubernetes allow for code portability across on-premise VMs, bare metal, or multiple cloud provider environments. Yet, despite this portability promise, developers may include configuration and application definitions that constrain or even eliminate application portability. In this session we'll describe best practices for "configuration as code" in a Kubernetes environment. We will demonstrate how a properly constructed containerized app can be deployed to both Amazon and Azure ...
The now mainstream platform changes stemming from the first Internet boom brought many changes but didn’t really change the basic relationship between servers and the applications running on them. In fact, that was sort of the point. In his session at 18th Cloud Expo, Gordon Haff, senior cloud strategy marketing and evangelism manager at Red Hat, will discuss how today’s workloads require a new model and a new platform for development and execution. The platform must handle a wide range of rec...
More and more companies are looking to microservices as an architectural pattern for breaking apart applications into more manageable pieces so that agile teams can deliver new features quicker and more effectively. What this pattern has done more than anything to date is spark organizational transformations, setting the foundation for future application development. In practice, however, there are a number of considerations to make that go beyond simply “build, ship, and run,” which changes how...
CloudEXPO New York 2018, colocated with DXWorldEXPO New York 2018 will be held November 11-13, 2018, in New York City and will bring together Cloud Computing, FinTech and Blockchain, Digital Transformation, Big Data, Internet of Things, DevOps, AI, Machine Learning and WebRTC to one location.
DevOpsSummit New York 2018, colocated with CloudEXPO | DXWorldEXPO New York 2018 will be held November 11-13, 2018, in New York City. Digital Transformation (DX) is a major focus with the introduction of DXWorldEXPO within the program. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term.
Adding public cloud resources to an existing application can be a daunting process. The tools that you currently use to manage the software and hardware outside the cloud aren’t always the best tools to efficiently grow into the cloud. All of the major configuration management tools have cloud orchestration plugins that can be leveraged, but there are also cloud-native tools that can dramatically improve the efficiency of managing your application lifecycle. In his session at 18th Cloud Expo, ...