Bug 294527

Summary: Importing 'q43' files reverses the sign of imports
Product: [Applications] kmymoney Reporter: Josep Cols <josep>
Component: generalAssignee: Cristian Oneț <onet.cristian>
Status: RESOLVED WORKSFORME    
Severity: normal CC: josep, onet.cristian
Priority: NOR    
Version: 4.6.1   
Target Milestone: ---   
Platform: Ubuntu   
OS: Linux   
Latest Commit: Version Fixed In:
Attachments: Example of q43 file
Kmymoney database after q43 file was applied
Screenshot of the successful import

Description Josep Cols 2012-02-20 20:54:05 UTC
Version:           4.6.1 (using KDE 4.7.2) 
OS:                Linux

Usig aqbanking/q43 to import 'q43' files (a spanish format) reverses the sign of the imports: positive imports are considered negative ones and negative importa   are considered positive ones.
(Sorry, but my kmymoney language is catalan): payments are considered incomes and incomes payments

Reproducible: Always

Steps to Reproduce:
simply import a q43 file to test

Actual Results:  
payments are imported as incomes
incomes are imported as payments

Expected Results:  
import payments as payments
import incomes as incomes

OS: Linux (i686) release 2.6.38-12-generic-pae
Compiler: gcc
Comment 1 Thomas Baumgart 2012-02-20 21:44:59 UTC
Can you provide us a sample .kmy and a sample .q43 file which shows the problem? That would help to investigate it a lot faster. Many thanks in advance.
Comment 2 Josep Cols 2012-02-20 21:51:24 UTC
Ok. I will try...
It's not eassy... I tried to delete and modify some records from a real 
q43 file, but I think they are some check sum on the file: if I modify 
the file, the file does not loads at all...
I do'nt want to send a real q43 file from my account because they have 
the name and account number...
I will investigate more and send a file...
Thanks

Al 20/02/12 22:45, En/na Thomas Baumgart ha escrit:
> https://bugs.kde.org/show_bug.cgi?id=294527
>
>
>
>
>
> --- Comment #1 from Thomas Baumgart<ipwizard users sourceforge net>   2012-02-20 21:44:59 ---
> Can you provide us a sample .kmy and a sample .q43 file which shows the
> problem? That would help to investigate it a lot faster. Many thanks in
> advance.
>
Comment 3 Josep Cols 2012-02-20 22:08:07 UTC
Hello:

I attach two files:
bug294527.kmy (with only the 4 records imported from bug294527.q43)
bug294527.q43: the file to import. Contains 4 records

Records:
-- ANUL FUNDACION NUEVA EDUCACION
-- INTERESSOS PER DOMICILIACIÓ DE REBUTS
==> are incomes

-- REINTEGR. CAIXER AUTOMATIC 5402XXXXXXXX0018 05.02
-- CARREC REBUT EGARVIA, S.A.
==> are payments

The .q43 file was generated by my bank.

If you open bug294527.kmy, you can see that all they are imported in the 
oposite form.

To reproduce, simply import the .q43 file to the 'Cuenta corriente' account

Regards

Al 20/02/12 22:45, En/na Thomas Baumgart ha escrit:
> https://bugs.kde.org/show_bug.cgi?id=294527
>
>
>
>
>
> --- Comment #1 from Thomas Baumgart<ipwizard users sourceforge net>   2012-02-20 21:44:59 ---
> Can you provide us a sample .kmy and a sample .q43 file which shows the
> problem? That would help to investigate it a lot faster. Many thanks in
> advance.
>
Comment 4 Cristian Oneț 2012-03-08 17:46:56 UTC
Could you please use the web interface to attach the files? If you reply to the notification messages and attach stuff to the replies those attachments get dropped by Bugzilla. You can visit the bug in the interface and see that there are no attachments here.
Comment 5 Josep Cols 2012-03-11 15:15:26 UTC
Created attachment 69496 [details]
Example of q43 file
Comment 6 Josep Cols 2012-03-11 15:16:22 UTC
Created attachment 69497 [details]
Kmymoney database after q43 file was applied
Comment 7 Cristian Oneț 2012-03-12 19:34:35 UTC
Created attachment 69552 [details]
Screenshot of the successful import

As you can see in the attached screenshot the file imported as you expected it to import - that means the bug has been fixed in AqBanking.

I have version 5.0.21 installed. Looking at http://www2.aquamaniac.de/sites/news/index.php I found a news with "behebt einen Fehler im Q43-Importer" I think that stands for your bug and it was fixed in version 5.0.5. I think that this is where the bug was first spotted https://bugs.launchpad.net/ubuntu/+source/libaqbanking/+bug/724393

In conclusion I'll close this as FIXED.