[Kmymoney-devel] [kmymoney4] [Bug 327495] New: CSV Import causes KMM to recreate every single payee even if they already exist in the payee database

[lp.allard.1 at gmail.com]

https://bugs.kde.org/show_bug.cgi?id=327495

            Bug ID: 327495
           Summary: CSV Import causes KMM to recreate every single payee
                    even if they already exist in the payee database
    Classification: Unclassified
           Product: kmymoney4
           Version: 4.6.4
          Platform: Compiled Sources
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: general
          Assignee: kmymoney-devel at kde.org
          Reporter: lp.allard.1 at gmail.com

When I import a CSV file (generated from LibreOffice Calc), KMM screws up the
amounts.

For example, the CSV file has 3 columns in LibreOffice Calc

Date  -  Payee  -  Amount

In the exported CSV file, for example the first few lines would look like:

2012-12-04,"Seller ABC",-$16
2012-12-14,"The corner store",-$13.50
2013-01-16,"Best restaurant in town",-$8.00

Once imported, KMM would create a new payee called "Seller ABC" even if this
payee already exists and has the IDENTICAL same name.  Then KMM will map the
transaction of $16 to it. Because of that, importing a large CSV file is
impractical as it basically doubles the payee list.

Reproducible: Always

Steps to Reproduce:
1. Create a CSV file with a program such as Libreoffice calc or MS excel
2. Import the CSV in KMM
3.KMM will recreate the payees even if they already exist
Actual Results:  
KMM will recreate the payees even if they already exist.  It doubles the
payees..

Expected Results:  
KMM should do a cross reference and reuse the existing payees to match the
transactions, not recreate identical ones..

-- 
You are receiving this mail because:
You are the assignee for the bug.