https://bugs.kde.org/show_bug.cgi?id=460947
Bug ID: 460947
Summary: CSV importer doesn't import ACH Debit payee
descriptions correctly
Classification: Applications
Product: kmymoney
Version: 5.1.3
Platform: Other
OS: Linux
Status: REPORTED
Severity: normal
Priority: NOR
Component: importer
Assignee: kmymoney-de...@kde.org
Reporter: tube.ra...@gmail.com
Target Milestone: ---
Created attachment 153169
--> https://bugs.kde.org/attachment.cgi?id=153169&action=edit
export.csv file which will create the error
SUMMARY
When using the CSV imported to import data from my bank into Kmymoney the payee
descriptions on ACH debits are imported incorrectly. The data entered in the
payee field is a character string from an old transaction followed by " &".
It appears in the payee description field in the database as follows: "JOHNSONS
PRODUCE &".
The imported CSV file contains different payee data in the payee/data field and
the issue is consistent whether the CSV is imported as either an 'amount'
based CSV or a 'credit/debit' based CSV. The problem is also evident in
previous versions of the Kmymoney CSV importer back to at least 5.1.1.
STEPS TO REPRODUCE
The CSV file line in question as a 'credit/debit' based CSV file is:
10/4/2022,,ACH Debit PAYPAL INST XFER 022277007290137,,125.50
1. file->import->csv
2. banking->skip setup->select file (export.csv)
3. formats: decimal symbol: dot(.) date format: m d y
4. import CSV
5. select banking account
6. click ok
OBSERVED RESULT
The first transaction containing a payee description line which contains "ACH
Debit" in the payee description field is entered into the kmymoney database as
"JOHNSONS PRODUCE &".
EXPECTED RESULT
The transaction payee description field should be entered into the kmymoney
database as "ACH Debit PAYPAL INST XFER 022277007290137" which is what is in
the CSV file payee description.
SOFTWARE/OS VERSIONS
Linux/KDE Plasma:
(available in About System)
KDE Plasma Version: 5.24.6
KDE Frameworks Version: 5.92.0
Qt Version: 5.15.3
ADDITIONAL INFORMATION
a test CSV file has been attached.
--
You are receiving this mail because:
You are watching all bug changes.
