https://bugs.kde.org/show_bug.cgi?id=397886
Bug ID: 397886
Summary: CSV importer chooses wrong separator
Product: kmymoney
Version: 4.8.1
Platform: Other
OS: Linux
Status: UNCONFIRMED
Severity: normal
Priority: NOR
Component: importer
Assignee: kmymoney-de...@kde.org
Reporter: josebernar...@yahoo.com
Target Milestone: ---
My bank is ING Belgium. Their export is too complex, with the transaction
information broken in the following fields (taken directly from the CSV):
Account Number;Account Name;Counterparty account;Entry number;Booking
date;Value date;Amount;Currency;Description;Entry Details;Message
I had been able, with 4.7.x, to edit that CSV, and add two columns, one with
the concatenation of the Counterparty account, Description, entry details and
message for the memo, and another with Description and entry details for the
payee. The fields would look as follows in the CSV:
Account Number;Account Name;Counterparty account;Entry number;Booking
date;Value date;Amount;Currency;Counterparty account-Description-Entry
Details-Message;Description-Entry Details;Description;Entry Details;Message
The other relevant information is that comma - "," is the decimal separator.
With 4.8.0 and 4.8.1, the importer stubbornly decides that the field separator
is the colon ":" if I feed it the changed CSV. I first tried editing the CSV
and replacing the separator with the colon, but then the importer decides it
should be the comma. If I use semi-colon, comma, or tab, it always claims the
separator is the colon.
This would be ok IF it were possible to change the separator in the importer,
but that is impossible for some reason I just can't find.
This behaviour, and the impossibility of overriding it, makes the CSV importer
nearly useless for me. The information is split in so many ways by ING's
exporter that in some cases "Description" is empty, in others has only
"European Direct Debit", in others is "Entry Details" that is empty.
I can provide a couple of example files, but they have too many details on my
bank account and movements for me to be happy to provide them publicly.
--
You are receiving this mail because:
You are watching all bug changes.
