In the CSV export from my bank, income and expenditure amounts are listed in separate columns, instead of as a single column with + or - prefixed. It would be nice if Skrooge could handle this.
OS: Linux (i686) release 184.108.40.206-desktop-2mnb
Could you attach an example ?
Created attachment 56107 [details]
Example showing separate amount columns
Here’s an example showing the CSV output from my bank. The line marked «Kreditrente» is income; all the others are expenditures.
Created attachment 56119 [details]
How to set settings to do the csv import
I will deliver a correction allowing the importation with the attached settings
SVN commit 1215026 by smankowski:
BUG: 263263: Separate field for income and expenditure when importing CSV files
M +1 -0 CHANGELOG
M +14 -14 skgbankmodeler/skgimportexportmanager.cpp
M +24 -2 skgbankmodeler/skgimportexportmanager.h
M +24 -0 skgbankmodelertest/skgtestimportcsv.cpp
M +4 -0 skrooge_importexport/skgimportexport_settings.kcfg
M +7 -6 skrooge_importexport/skgimportexportplugin.cpp
M +133 -89 skrooge_importexport/skgimportexportpluginwidget_pref.ui
WebSVN link: http://websvn.kde.org/?view=rev&revision=1215026
I don’t think that would work. The row with income just happened to have type ‘Kreditrente’; it could have any number of different strings (this is basically the ‘Category’ column). I guess my example had too few rows / different field values to show this.
The points is that all the expenditure is stored in the column ‘UT FRA KONTO’, and all the income is stored in the column ‘INN PÅ KONTO’.
I understood that too and this is corrected.
I tested it and it works.