[kmymoney] [Bug 460947] New: CSV importer doesn't import ACH Debit payee descriptions correctly

[bill weinel]

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-devel at kde.org
          Reporter: tube.radio at 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 the assignee for the bug.