maybe icon indicating copy to clipboard operation
maybe copied to clipboard

Bug: Single and double quotation marks are not properly escaped from a CSV import

Open sup3rgiu opened this issue 1 month ago • 5 comments

Where did this bug occur? (required)

  • [x] I am a self-hosted user reporting a bug from my self hosted app
  • [ ] I am a user of Maybe's paid app

Describe the bug Consider this simple csv:

Date;Description;Amount (EUR);
09.01.2025;Bar "La collina";-19,50;

I'm currently facing 3 issues with the "Import transactions" feature:

  1. Quotation marks cannot be present within the csv content. As you can see, I have some " in the "Description" column. If there are, the upload fails with this message:

Image

  1. In the "Date format" field, the format DD.MM.YYYY is not present. When using DD.MM.YY, the sample transaction is imported as "9 January 2020"

Image

  1. No options to change the decimal separator. When imported, the sample transaction is registered as -1950€.

Note that I found these bugs when importing a real CSV provided by my bank (UniCredit).

sup3rgiu avatar Jan 25 '25 16:01 sup3rgiu