This forum has been archived. All content is frozen. Please use KDE Discuss instead.

all values are taken as debit on CSV import

Tags: None
(comma "," separated)
User avatar
atrox
Registered Member
Posts
211
Karma
0
OS
Hi.

Just getting started with Skrooge here... :)

I've got some CSV exports from my bank accounts. I've set corrent CSV import values, including 'Sign'. Before I defined 'Sign' correctly all imported values were taken as credit. After defining 'Sign' all values on import are debits (minus) - the debit value in CSVs is the standard D which is also set as the debit value.

Am I doing something wrong?

My configured values for CSV import:
Sign:
Code: Select all
^sign|^sens|^(deebet|kreedit)

Debit values:
Code: Select all
^-|^debit|^withdrawal|D|


Example row:
Code: Select all
"Kliendi konto";"Reatüüp";"Kuupäev";"Saaja/Maksja";"Selgitus";"Summa";"Valuuta";"Deebet/Kreedit";"Arhiveerimistunnus";"Tehingu tüüp";"Viitenumber";"Dokumendi number";
"EE...";"10";"01.05.2015";"";"Algsaldo";"99,62";"EUR";"K";"";"AS";"";"";
User avatar
atrox
Registered Member
Posts
211
Karma
0
OS
Figured this out - it was that '|' at the end of debit values setting which caused anything to match.
Correct value would be:
Code: Select all
^-|^debit|^withdrawal|D


Bookmarks



Who is online

Registered users: abc72656, Bing [Bot], daret, Google [Bot], lockheed, Sogou [Bot], Yahoo [Bot]