Bug 294527 - Importing 'q43' files reverses the sign of imports
Summary: Importing 'q43' files reverses the sign of imports
Status: RESOLVED WORKSFORME
Alias: None
Product: kmymoney
Classification: Applications
Component: general (show other bugs)
Version: 4.6.1
Platform: Ubuntu Linux
: NOR normal
Target Milestone: ---
Assignee: Cristian Oneț
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-02-20 20:54 UTC by Josep Cols
Modified: 2012-03-12 19:35 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments
Example of q43 file (902 bytes, text/plain)
2012-03-11 15:15 UTC, Josep Cols
Details
Kmymoney database after q43 file was applied (5.67 KB, application/octet-stream)
2012-03-11 15:16 UTC, Josep Cols
Details
Screenshot of the successful import (77.64 KB, image/png)
2012-03-12 19:34 UTC, Cristian Oneț
Details

Note You need to log in before you can comment on or make changes to this bug.
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.