Bug 408138

Summary: Date of imported transactions not recognised
Product: [Applications] skrooge Reporter: Christoph Vogtländer <kde>
Component: generalAssignee: Bernhard Scheirle <bernhard+kde>
Status: RESOLVED FIXED    
Severity: normal CC: bernhard+kde, stephane
Priority: NOR    
Version First Reported In: 2.19.0   
Target Milestone: 25.1.0   
Platform: Other   
OS: Linux   
Latest Commit: https://cgit.kde.org/skrooge.git/commit/?id=e11cac2094d295b53d016f34ab5cacb7ed9c54da Version Fixed/Implemented In: 2.20
Sentry Crash Report:

Description Christoph Vogtländer 2019-05-31 09:00:50 UTC 
The date of imported transactions is always set to the current date. I'm using the aqbanking (SABB) backend.

Using skrooge-sabb.py directly (e.g. "./skrooge-sabb.py bulkdownload --output_folder ~/tmp/") shows that the format in the resulting CSV files is "YYYY/MM/DD". This format is not listed as a possible format in the Skrooge import settings. So it might be that Skrooge simply is not able to recognise the used date format any longer.

It seems that the format is provided by the bank? Or is it possible to configure the format in AqBanking somehow?

The import worked without problems in earlier versions of Skrooge/AqBanking. Unfortunately I do not know exactly when I did the last successful import (I think it was around Februrary 19).


STEPS TO REPRODUCE
1. import with aqbanking backend

OBSERVED RESULT
The date of all imported transactions is the current date

EXPECTED RESULT
The date should be the actual date of the transaction

SOFTWARE/OS VERSIONS
Linux/KDE Plasma: Arch Linux
KDE Plasma Version: 5.15.5
KDE Frameworks Version: 5.58.0
Qt Version: 5.12.3
Comment 1 Stephane MANKOWSKI 2019-05-31 18:18:33 UTC 
Hi,

Could you send me some samples of lines returned by the following command line?
skrooge-sabb.py bulkdownload --output_folder /tmp/sample.csv

The file will be in /tmp/sample.csv
My email is in the "About" of Skrooge.
Comment 2 Bernhard Scheirle 2019-05-31 18:39:31 UTC 
Hi,

this is fixed in skrooge 2.20.

As a workaround for 2.19 you can manually modify the 
"org.kde.skrooge-import-backend-aqbanking.desktop"*¹ file:

1. Replace the last line with:
   X-SKROOGE-csvcolumns=date|mode|comment|payee|amount|unit

   (Note the added "|unit")

2. Run "kbuildsycoca5" to update the desktop file cache.
3. Restart skrooge.

*¹: On my system it is located in /usr/share/kservices5/.
    Run "kf5-config --path services" to get location on your system.

Regards,
Bernhard
Comment 3 Christoph Vogtländer 2019-05-31 19:54:55 UTC 
I confirm that the workaround in org.kde.skrooge-import-backend-aqbanking.desktop fixes the problem. Thank you very much.