CSV Export Improvements

Two quick improvements that would help with CSV exporting and importing into spreadsheet programs:

  1. Quote Text Columns – Any commas in the text fields currently break the CSV imports and have to be manually corrected. This can be (mostly) fixed by either quoting text columns in double-quotes and/or escaping commas in text fields (,). Double-quotes in text fields can be similarly escaped by double-quotes.
  2. Remove ‘$’ Prefixes – This causes issues with some spreadsheet imports which considers the column as text instead of number. A simple 2-decimal floating point number like “25.00” would work fine.
2 Likes

A post was merged into an existing topic: COMING SOON | Improvements to Patron Relationship Manager