csv export invalid with semicolon in text
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
HomeBank |
Fix Released
|
Low
|
Maxime DOYEN |
Bug Description
The CSV character choice in Preferences only affects importing of transactions. When exporting, it always uses a semi-colon.
Can the character chosen in Preferences be used when exporting, or optionally a second Preference (happy for current default of ; to be set) for export delimiter?
Reason being I had a semicolon in the Memo field and it threw the CSV importing out(!). I use export when in 'Transactions \ Show All' (and sometimes 'Show').
A related nice feature would be to warn user if the CSV character is included in any data field - so they can correct (= remove) it before saving the change, unless they explicitly then "OK" it anyway.
Operating System: Windows 10 & 11
HomeBank 5.5.4
Running against GTK+ 3.24.31
description: | updated |
description: | updated |
Changed in homebank: | |
assignee: | nobody → Maxime DOYEN (mdoyen) |
importance: | Undecided → Low |
status: | New → Confirmed |
Changed in homebank: | |
importance: | Low → Wishlist |
milestone: | none → 5.6 |
Changed in homebank: | |
status: | Confirmed → In Progress |
summary: |
- wish: user setting for export csv delimiter character + csv export invalid with semicolon in text |
Changed in homebank: | |
importance: | Wishlist → Low |
milestone: | 5.6 → 5.5.6 |
status: | In Progress → Fix Committed |
Changed in homebank: | |
status: | Fix Committed → Fix Released |
the problem is not really the delimiter, it is just that I do not use string delimiter " when the text as the separator into it, for example, if you import this, it will work
date;paymode; info;payee; memo;amount; category; tags 0;;;"memo with ;";0,00;;"tag;"
05/18/2022;
but anyway, choosing the export separator by default and at export time is a plus