search

bcgov / MFIN-Data-Catalogue

The Finance Data Catalogue enables users to discover data holdings at the BC Ministry of Finance and offers information and functionality that benefits consumers of data for business purposes. The product is built using Drupal and adheres to the Government of BC's Core Administrative and Descriptive etadata Standard.
Other
6 stars 0 forks source link

"Generate CSV" is not generating CSV #367

Closed NicoledeGreef closed 7 months ago

NicoledeGreef commented 7 months ago

OP timer

https://openplus.monday.com/boards/4092908516/pulses/6075778605

Describe the bug

After a search is performed, a user can select one or more MRs for export as CSV. A file is generated but the contents of the file is not comma separated values, rather it seems the delimiter is a semi-colon. See attached file. site_search_2024_02_15_15_36-7a348467.csv

To reproduce

Steps to reproduce the behaviour:

  1. Visit test.cat.data or dv14
  2. Perform a search with no parameters which returns the entire list of MRs
  3. Select All records
  4. Scroll down and click "Generate csv...": image
  5. File link is generated; download the file and view in text editor or MS Excel (does not render well in Excel without telling Excel to import data from a file - all text ends up in Column A): image

Expected behaviour

Downloaded file should be comma delimited not semi-colon delimited. When users download and doubleclick it or select Open in Excel the column headers and values should be in distinct columns).

Screenshots

Downloaded file in a text Editor: image

Having to import the data in Excel to get it to render properly is not end user friendly (not everyone knows how to do this): image

lkmorlan commented 7 months ago

Simple config change. Config is done in the View.

CraigClark commented 7 months ago

tested on dv14 and passes