Work with a Developer to get the pa11y report exported to a spreadsheet, like this:
Open up the AirTable Worksheet for the project, being sure to use a table with pa11y pre-set.
In the spreadsheet, copy all the URLs for each Failure. You will need to select-all from the Formula Bar. We want to get each of these URLs into their own row on the AirTable.
Paste these URLs into AirTable. They all should appear on their own row. You will be prompted from AirTable for confirmation to "expand" table to accommodate additional rows. Select 'Yes.'
Next, in the spreadsheet, reference the Error "name", selecting only the last part of the full error name, for instance, "H91.InputText.Name"
In AirTable, paste this into the "Name" and drag to copy for all the URLs that were pasted.
In AirTable, navigate to the "Advisory Technique" field. Begin typing the letters in Column A, "Name" to get a list of matches. Once you have found the "Match" select it.
You will notice WCAG Criteria, Advisory Technique Title and Advisory Technique Summary columns will get auto-filled. Then Fill down to rest of the rows that contain the URLs that you just pasted.
It is also helpful to identify and group & sort by Type of Pattern (atom, organism, molecule) and the Pattern (e.g., "Cards). We can extract this information from the URL. Let's download the AirTable that we just created.
We will first split the URLs by the delimiter /
Now we can delete the parts of the URL that we don't need.
We now need to get rid of the 01- that are in 2 columns. We will trim these values. Insert a column before Col K and enter this formula:
The next part will be sorting, but let's preserve the original sort by assigning numeric values in Column L.
Drag to the rest of the URLs.
You will now have the ability to get this order of URLs back to the same order as in AirTable.
Next, we will sort by Col K:
Then you will insert a new column to the left; begin typing the pattern that you see in the first few characters, e.g., "atoms" "molecules". Drag to fill rows for each type. Perform this for all the pattern URLs: atoms, molecules, organisms, templates, pages, styleguide
Insert a new column before L. Similar to removing the 03-'s, we will use the =RIGHT formula to remove the atoms- organisms - and so forth for all pattern types. Since each is a unique character count, you will need to update the formula, using the below as a guide, focusing on the last digit.
=RIGHT(M1,LEN(M1)-6) (atoms)=RIGHT(M11,LEN(M11)-10) (molecules)=RIGHT(M17,LEN(M17)-10) (organisms)=RIGHT(M23,LEN(M23)-6) (pages)=RIGHT(M122,LEN(M122-11) (styleguide)=RIGHT(M132,LEN(M132-10) (templates)
Then copy, insert new column Paste Special > Values. Once you've created this new column, you may delete the original column with the formulas.
Sort (again) on the row of #s to return to the original sort.
Copy Columns K & L.
Paste into AirTable, under Pattern Type and Patterns
The AirTable project is set up with views:
By Failure (As you see it)
By Pattern (See all the errors by Pattern, e.g., "Header")
By Pattern Type ( See all errors grouped by Type, e.g., all atoms, all molecules)
Create JIRA tickets by Error Type:
Set your AirTable View "By Failure"
Go to your JIRA Project
Create a New Story
Copy the "Advisory Technique Title" into the Summary Field
In the Body, Type in the Description ("Advisory Technique Summary"), the WCAG Criteria affected.
Copy the Pattern Type, Patterns, & URLs and go to a Markdown Editor: https://thisdavej.com/copy-table-in-excel-and-paste-as-a-markdown-table/
Paste the Markdown into JIRA ticket and Save.