1) Save your transaction history from your Internet banking as showed on the following picture:

2) Run following script on saved file:
#!/usr/bin/perl
use utf8;
if ($#ARGV != 1 ) {
print "usage: csob.pl inputfile outputfile\n";
exit;
}
open INPUT, "<:encoding(cp1250)", $ARGV[0];
open OUTPUT, ">:encoding(utf8)", $ARGV[1];
print OUTPUT "\n";
while(<INPUT>) {
if (/:/) {
($key, $value) = split(/:\s*/, $_, 2);
$value =~ s/\s*\n$//;
if ($key eq "datum zaúčtování") {
($day, $month, $year) = split (/\./, $value);
$value = "$year/$month/$day";
}
$values{$key} = $value;
} else {
if ($values{"částka"}) {
print OUTPUT ";"; #1="transactionId"
print OUTPUT "0300;"; #2="localBankCode"
print OUTPUT ";"; #3="localAccountNumber"
print OUTPUT ";"; #4="remoteBankCode"
print OUTPUT ";"; #5="remoteAccountNumber"
print OUTPUT '"'.$values{"datum zaúčtování"}.'";'; #6="date"
print OUTPUT '"'.$values{"datum zaúčtování"}.'";'; #7="valutadate"
print OUTPUT '"'.$values{"částka"}.'";'; #8="value/value"
print OUTPUT '"'.$values{"měna"}.'";'; #9="value/currency"
print OUTPUT ";"; #10="localName"
print OUTPUT '"'.$values{"název protiúčtu"}.'";'; #11="remoteName[0]"
print OUTPUT ";"; #12="remoteName[1]"
print OUTPUT '"'.$values{"označení operace"}.'";'; #13="purpose[0]"
print OUTPUT '"'.$values{"poznámka"}.'";'; #14="purpose[1]"
print OUTPUT '"'.$values{"konstantní symbol"}.'";'; #15="purpose[2]"
print OUTPUT '"'.$values{"variabilní symbol"}.'";'; #16="purpose[3]"
print OUTPUT '"'.$values{"specifický symbol"}.'";'; #17="purpose[4]"
print OUTPUT ";"; #18="purpose[5]"
print OUTPUT ";"; #19="purpose[6]"
print OUTPUT ";"; #20="purpose[7]"
print OUTPUT ";"; #21="purpose[8]"
print OUTPUT ";"; #22="purpose[9]"
print OUTPUT ";"; #23="purpose[10]"
print OUTPUT ";"; #24="purpose[11]"
print OUTPUT ";"; #25="category[0]"
print OUTPUT ";"; #26="category[1]"
print OUTPUT ";"; #27="category[2]"
print OUTPUT ";"; #28="category[3]"
print OUTPUT ";"; #29="category[4]"
print OUTPUT ";"; #30="category[5]"
print OUTPUT ";"; #31="category[6]"
print OUTPUT ""; #32="category[7]"
print OUTPUT "\n";
}
%values = ();
}
}
close INPUT;
close OUTPUT;
3) Import newly created file into KMyMoney using default CSV importer.
rd@radekdostal.com
+43 681 815 945 10
skype: radekdostal
www.mimo-domov.cz - Czech and Slovak people abroad