Bug 408138 - Date of imported transactions not recognised
Summary: Date of imported transactions not recognised
Status: RESOLVED FIXED
Alias: None
Product: skrooge
Classification: Applications
Component: general (show other bugs)
Version: 2.19.0
Platform: Other Linux
: NOR normal
Target Milestone: 25.1.0
Assignee: Bernhard Scheirle
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-05-31 09:00 UTC by Christoph Vogtländer
Modified: 2019-05-31 19:54 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In: 2.20
Sentry Crash Report:


Attachments

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