Editing Workflow:PDF/A validation and metadata extraction

{{Infobox_COW
|name=PDF/A validation and metadata extraction
|category=File format validation, Metadata extraction
|status=Productive
|tools=UKWA search interface<br />[[GNU_Wget]]<br />[[veraPDF]]<br />XMLstarlet<br />Excel
|input= Corpus of PDF/A files
|output= CSV with validationresult and metadata
|organisation=[http://dpconline.org/ Digital Preservation Coalition]
}}

[[Category:COW Workflows]]
==Workflow description==
<!-- Describe your workflow here. If necessary add a diagram -->
*UKWA search interface (create URL list of PDF/A files in UKWA) ->
*[[GNU_Wget]] (download files from IA, to create the test corpus) ->
*[[veraPDF]] (validates and extracts metadata from test corpus) ->
*XMLstarlet (process XML, extract useful fields into a CSV) ->
*Excel (view and analyse results in spreadsheet form)

The workflow begins with creation of a corpus of test files which is constructed using the UK Web Archive search interface (for example see [https://www.webarchive.org.uk/shine/search?query=content_type:%22application/pdf%22%20content_type_version:%221b%22 this]). The result is a list of URLs. These are fetched with Wget to create a large test corpus of predominantly PDF/A files. VeraPDF is then used to validate and extract metadata for each file. XMLstarlet is applied to extract fields of interest from the resulting XML creating a CSV. The CSV is then imported to Excel for analysis.

==List of Tools==
<!-- List the tools in your workflow in a bulleted list (begin each line with an asterisk). Link to tool entries in COPTR where possible -->
*UKWA search interface
*[[GNU_Wget]]
*[[veraPDF]]
*XMLstarlet
*Excel

==Organisation==
<!-- Add the name of your organisation here -->
[http://dpconline.org/ Digital Preservation Coalition]

==Purpose, context and content==
<!-- Describe what your workflow is for, what the organisational context of the workflow is, and what content it is designed to work with -->
This is a basic workflow for ad-hoc investigation of a set of PDF/A files. This is a very simple, manual, workflow that was used for testing purposes as part of the development of veraPDF, and is described further in this blog post:
http://dpconline.org/blog/pdf-eh-redux-putting-verapdf-into-practice

==Evaluation/Review==
<!-- How effective was the workflow? Was it replaced with a better workflow? Did it work well with some content but not others? What is the current status of the workflow? Does it relate to another workflow already described on the wiki? Link, explain and elaborate -->
The workflow was useful in that it helped to identify a number of bugs in veraPDF that have since been fixed. The workflow as is provides a very basic method of investigating PDF files, perhaps where some troubleshooting is required.

==Evaluation/Review==
<!-- How effective was the workflow? Was it replaced with a better workflow? Did it work well with some content but not others? What is the current status of the workflow? Does it relate to another workflow already described on the wiki? Link, explain and elaborate -->

<!-- Add four tildes below ("~~~~") to create an automatic signature, including your wiki username. Ensure your user page (click on your username to create it) includes an up to date contact email address -->
[[User:Prwheatley|Prwheatley]] ([[User talk:Prwheatley|talk]]) 11:51, 8 February 2017 (UTC)