dkb-visa icon indicating copy to clipboard operation
dkb-visa copied to clipboard

valuta_date empty for soll/haben

Open inktrap opened this issue 9 years ago • 1 comments

An entry like the following one has an empty COL_VALUTA_DATE, because it does not show a transaction, only the Soll or Haben (that you currently owe or have). So this should not be one of the transactions.

"Nein";"01.01.2015";"";"Soll";"-00,01";"";

However filtering and matching transactions to accounts should happen later, so I used this simple but ugly fix:

if len(line[self.COL_VALUTA_DATE].strip()) == 0:
    return re.sub('.*?(\d{1,2})\.(\d{1,2})\.(\d{2,4}).*?', r'\2/\1/\3',
        line[self.COL_DATE])
else:
    return re.sub('.*?(\d{1,2})\.(\d{1,2})\.(\d{2,4}).*?', r'\2/\1/\3',
        line[self.COL_VALUTA_DATE])

Otherwise the generated qif-file won't be importabable

inktrap avatar Jan 30 '16 17:01 inktrap

Can you try whether my alternative fix from 947b97e helps?

hoffie avatar May 29 '16 20:05 hoffie