[kmymoney] [Bug 459006] New: Investment activity type 'Remove' is replaced by 'Add' in CSV import

[René]

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

            Bug ID: 459006
           Summary: Investment activity type 'Remove' is replaced by 'Add'
                    in CSV import
           Product: kmymoney
           Version: 5.1.3
          Platform: openSUSE RPMs
                OS: Linux
            Status: REPORTED
          Severity: normal
          Priority: NOR
         Component: importer
          Assignee: kmymoney-devel at kde.org
          Reporter: r.cluzel at gmail.com
  Target Milestone: ---

SUMMARY
***
NOTE: If you are reporting a crash, please try to attach a backtrace with debug
symbols.
See
https://community.kde.org/Guidelines_and_HOWTOs/Debugging/How_to_create_useful_crash_reports
***
Hi everybody,

I'm using KMyMoney (V 5.1.3) under Opensuse Tumbleweed (20220908 x86_64) with
Gnome 42.2 (with Wayland). 
I created a CSV file for importing investments with different activity types
(Buy, Sell, Dividend, Add and Remove).
Buy, Sell, Dividend, Add activity types work well and create the corresponding
records in the KMM empty created investment account.

The rows containing Remove for removing securities after they have been created
(with dates in the correct order) operate as Add activity type.

STEPS TO REPRODUCE
1. The CSV file:

Type de compte :Placement,,,,,,,,,,,
,,,,,,,,,,,
Date,Titre,Action/type,Montant,Quantité,Cours,Intérêts,Commissions,Compte,Note,État,Symbole
2022-10-10,AMUNDI CRDT Euro P,Buy,"-2812,26","18,2","154,69",,,TitreTest
(Courtage),,,FR0010775429
2022-10-10,AMUNDI CRDT Euro P,Buy,"-2534,94","0,3","9749,77",,,TitreTest
(Courtage),,,FR0010775429
2022-10-10,BNP Paribas,Buy,"-417,67","4,3","97,36",,,TitreTest
(Courtage),,,FR0011362094
2022-10-10,SG MONE PLUS P -
FR0011362094,Buy,"-299,67","4,5","66,89",,,TitreTest (Courtage),,,FR0000131104
2022-10-11,AMUNDI CRDT Euro P,ReinvDiv,"5,45","18,2","0,3","-5,45",,TitreTest
(Courtage),,,FR0010775429
2022-10-11,BNP Paribas,Sell,"223,11","3,3",67,,,TitreTest
(Courtage),,,FR0011362094
2022-10-12,BNP Paribas,DivX,10,0,0,-10,,TitreTest (Courtage),,,FR0011362094
2022-10-15,SG MONE PLUS P - FR0011362094,Shrsin,0,5,0,,,TitreTest
(Courtage),,,FR0000131104
2022-10-16,SG MONE PLUS P - FR0011362094,Remove,0,2,0,,,TitreTest
(Courtage),,,FR0000131104
2022-10-10,AMUNDI CRDT Euro P,Remove,0,3,0,,,TitreTest
(Courtage),,,FR0010775429

2. The output of the import process:

Type de compte :Placement

Date,Titre,Action/type,Montant,Quantité,Cours,Intérêts,Commissions,Compte,Note,État
2022-10-10,"SG MONE PLUS P -
FR0011362094",Buy,"-299,67","4,50","66,890000",,,"Titres_Pour_Tests
(Courtage)",,
2022-10-10,"BNP Paribas",Buy,"-417,67","4,30","97,360000",,,"Titres_Pour_Tests
(Courtage)",,
2022-10-10,"AMUNDI CRDT Euro P",Shrsin,,"3,00",,,,,,
2022-10-10,"AMUNDI CRDT Euro
P",Buy,"-2534,94","0,30","9749,770000",,,"Titres_Pour_Tests (Courtage)",,
2022-10-10,"AMUNDI CRDT Euro
P",Buy,"-2812,26","18,20","154,690000",,,"Titres_Pour_Tests (Courtage)",,
2022-10-11,"BNP Paribas",Sell,"223,11","3,30","67,000000",,,"Titres_Pour_Tests
(Courtage)",,
2022-10-11,"AMUNDI CRDT Euro P",ReinvDiv,"5,45","18,20","0,300000","-5,45",,,,
2022-10-12,"BNP Paribas",DivX,"10,00",,,"-10,00",,"Titres_Pour_Tests
(Courtage)",,
2022-10-15,"SG MONE PLUS P - FR0011362094",Shrsin,,"5,00",,,,,,
2022-10-16,"SG MONE PLUS P - FR0011362094",Shrsin,,"2,00",,,,,,
3. 

OBSERVED RESULT

The two rows of the CSV file indicating to remove the corresponding securities
are the two last rows:

2022-10-16,SG MONE PLUS P - FR0011362094,Remove,0,2,0,,,TitreTest
(Courtage),,,FR0000131104
2022-10-10,AMUNDI CRDT Euro P,Remove,0,3,0,,,TitreTest
(Courtage),,,FR0010775429

The corresponding rows in the output are 

2022-10-10,"AMUNDI CRDT Euro P",Shrsin,,"3,00",,,,,,
2022-10-16,"SG MONE PLUS P - FR0011362094",Shrsin,,"2,00",,,,,,


EXPECTED RESULT

As one can note, the activity type in the output is  Shrsin, which corresponds
to Add ans not to Remove .

Many thanks for your help

René


SOFTWARE/OS VERSIONS
Windows: 
macOS: 
Linux/KDE Plasma: 
(available in About System)
KDE Plasma Version: 
KDE Frameworks Version: 
Qt Version:  .......................................  Qt5

ADDITIONAL INFORMATION

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