Change Null/Missing Export Columns for Easier Filtering

[davidclaveau]

Description:

When I open up a recently downloaded Null/Missing export, I would like to see the Bundle, Park, Subarea, and Months in separate columns so it's easier to filter the data.

Right now, the Bundle, Park, Subarea and Months are in rows, but it would be easier to filter the data if these items were in columns instead.

Acceptance Criteria:

Given I am an A&R user When I export the A&R Missing data Then I get an excel spreadsheet where the Bundle, Park, Subarea, and Months are in separate columns

Development Checklist:

• [ ] Bundle, Park, Subarea, and Months are in separate columns
• [ ] The Activities and Years are in the same format

Definition of Ready (Note: If any of these points are not applicable, mark N/A)

• [ ] User story is included
• [ ] User role and type are identified
• [ ] Acceptance criteria are included
• [ ] Wireframes are included
• [ ] Design / Solution is accepted by Product Owner
• [ ] Dependencies are identified (technical, business, regulatory/policy)
• [ ] Story has been estimated (under 13 pts)

Definition of Done

• In progress:
  • [ ] Acceptance criteria are tested (Functionality meets the acceptance criteria defined in the ticket)
  • [ ] UI meets accessibility requirements
  • [ ] Unit tests are written
  • [ ] Work is traceable in GitHub
  • [ ] PR linked to ticket number
  • [ ] If needed/required - Dev adds flag/label to highlight any migration steps necessary prior to PROD deployment
• Code review:
  • [ ] Code is peer reviewed and has passed CI/CD tests
• QA:
  • [ ] Acceptance criteria are tested (Functionality meets the acceptance criteria defined in the ticket)
  • [ ] Code is potentially shippable to the production environment
  • [ ] Functional features have been tested and passed by QA
  • [ ] UI components tested by designer
  • [ ] Code is deployed to PROD when moved to 'done' column (unless requested otherwise by PO)
• PO Review:
  • [ ] Acceptance criteria are tested (Functionality meets the acceptance criteria defined in the ticket)
  • [ ] Reviewed and approved by Product Owner

Notes:

[davidclaveau]

Hey @manuji this is ready to be moved to TEST now!

The Missing Export should now have Bundle, Park, Subarea and Month columns so it's easier for the user to filter the data in the spreadsheet.

This means the data is a little haphazard in how it's displayed, as items are still written by the old setup (by bundle, then park, then subarea, and then in a monthly order) - so it might look odd to see things printed out of order, but that's expected behaviour!

Let me know if you have any questions!

[Dianadec]

@manuji does this need further testing?

[manuji]

Hi @Dianadec , I will update the status today. Thank you!

[manuji]

Tested on TEST: Pending

• Verified that this task has ben implemented and the exported report for missing/null values shows data in their respective columns with proper column headers.

• @davidclaveau , there is a small issue with park names with special characters, when there are special characters, the data get added in to the wrong columns. Refer to the screenshot below.

• Also refer to the attached csv below, it has a huge gap between data and I am not sure what caused that, but please check the line 68 to 95. A&R_Missing_Report (13).csv

[davidclaveau]

I will aim to add a fix to this in #377 when I apply an overall fix to the export!

[davidclaveau]

@manuji this fix will be in PR #383

The issue arose when the exporter misinterpreted specialized names containing commas, like ȽÁU,WELṈEW̱/John Dean Park. The CSV file incorrectly split these names into separate cells, treating the comma as a delimiter. Names with commas should be properly "escaped" and displayed now that we know what to look for!