On 30.05.14,15:51, Jostein Berntsen wrote: > On 30.05.14,09:19, Edwin van Leeuwen wrote: > > On Fri, 30 May 2014 09:54:39 +0200, Jostein Berntsen <[email protected]> > > wrote: > > > On 29.05.14,23:18, Esben Stien wrote: > > > > > > > > I have the following bank statement from my bank: > > > > > > > > "03.11.2013";"Foo";"04.11.2013";"1.638,00";"" > > > > "03.11.2013";"Bar";"04.11.2013";"";"492,93" > > > > > > > > The fields are: > > > > > > > > "Date";"Description";"Interest Date";"Out of Account";"In to Account" > > > > > > > > , so the ins and outs are separated, the date format is fubar, the > > > > separator is semicolon and the amount format is just as fubar. > > > > > > > > I could script it into something more sane, but I wonder if > > > > > > > > https://github.com/bhutley/bank-csv-to-ledger > > > > > > > > ..or another import package can work directly with this format? > > > > > > > > > > I like to use reckon: > > > > > > https://github.com/cantino/reckon > > > > > > How to use: > > > > > > http://blog.andrewcantino.com/blog/2010/11/06/command-line-accounting-with-ledger-and-reckon/ > > > > > > > Reckon should parse your csv file correctly. If not please file a bug so > > we can improve Reckon :) > > > > Cheers, Edwin > > Thanks, Edwin. :) Here is an example on a reckon command I use for my bank > csv fle: > > eckon -f drang2.csv -v --ignore-columns 2 --csv-separator ';' --currency NOK > --suffixed --comma-separates-cents -l jbfinans.dat -o jbfinans.dat >
Sorry, it should be this command for my bank csv file: reckon -f drang2.csv -v --ignore-columns 2 --csv-separator ';' --currency NOK --suffixed --comma-separates-cents -l jbfinans.dat -o jbfinans.dat Jostein -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
