cds-snc / platform-forms-client

NextJS application that serves the public-facing website for Forms
https://forms-staging.cdssandbox.xyz/
MIT License
35 stars 13 forks source link

Exporting Translation to CSV breaks when commas are included as part of radio button element options. #4656

Closed bryan-robitaille closed 2 days ago

bryan-robitaille commented 1 week ago

Description

Reference to support ticket

Broken CSV: beaver-dam-breaching-and-removal-code-of-practice-2024-11-13.csv

Form Template to Replicate: beaver-dam-breaching-and-removal-code-of-practice-final-2024-11-13.json

Expected behaviour

The csv file is correct parsed and imported into Excel.

Screenshots or videos

image (4)

Additional context

This happens to any element that contains "Options" (like radio buttons and dropdowns)

thiessenp-cds commented 3 days ago

I'll time-box this to about two days. From past work with CSV bugs, these can turn into a black hole of dev time