Re: best way to slurp bank records?

2012-10-03 Thread Russell Adams
Inline below. On Wed, Oct 03, 2012 at 04:27:09PM +0100, Toby Gee wrote: Sorry - I wrote this two days ago and it's been held up in moderation, I guess. Since then I tried icsv2ledger, and managed to do most of the below (I'm sure csv2ledger can also do it, of course), so I now have two

Re: best way to slurp bank records?

2012-10-03 Thread Peter Ross
On 4 October 2012 01:27, Toby Gee toby...@gmail.com wrote: Sorry - I wrote this two days ago and it's been held up in moderation, I guess. Since then I tried icsv2ledger, and managed to do most of the below (I'm sure csv2ledger can also do it, of course), so I now have two slightly

Re: best way to slurp bank records?

2012-10-03 Thread Zack Williams
- is there an easy way in all of this (perhaps in Ledger itself?) to change the sign of all of the transactions for some account? One of my credit cards uses the opposite sign convention to all my other accounts. This feature is in many of the CSV to ledger conversion tools already. - how

Re: best way to slurp bank records?

2012-10-02 Thread Eric Abrahamsen
On Tue, Oct 02 2012, Russell Adams wrote: I was too using a personal perl script, doing the mapping from a table. But I tried the 'i' of icsv2ledger, and felt in love with this 'i'. On contrary, rubycsv and CSV2ledger does not (yet?) implement this 'interactiveness'. Also CSV2ledger is

Re: best way to slurp bank records?

2012-10-01 Thread Russell Adams
On Sun, Sep 30, 2012 at 10:29:17PM -0700, Zack Williams wrote: On Sun, Sep 30, 2012 at 12:31 PM, thierry thierry.dauco...@free.fr wrote: I have another change to propose to icsv2ledger. Why is there an account mapping file AND a payee mapping file? Why not merging into a single file? The

Re: best way to slurp bank records?

2012-10-01 Thread thierry
On Monday, October 1, 2012 8:24:29 AM UTC+2, Russell Adams wrote: On Sun, Sep 30, 2012 at 10:29:17PM -0700, Zack Williams wrote: On Sun, Sep 30, 2012 at 12:31 PM, thierry thierry@free.frjavascript: wrote: The only downside compared to any of the other CSV programs is that

Re: best way to slurp bank records?

2012-10-01 Thread Peter Ross
On 2 October 2012 07:40, thierry thierry.dauco...@free.fr wrote: On Monday, October 1, 2012 8:24:29 AM UTC+2, Russell Adams wrote: On Sun, Sep 30, 2012 at 10:29:17PM -0700, Zack Williams wrote: On Sun, Sep 30, 2012 at 12:31 PM, thierry thierry@free.fr wrote: The only downside

Re: best way to slurp bank records?

2012-10-01 Thread Russell Adams
I was too using a personal perl script, doing the mapping from a table. But I tried the 'i' of icsv2ledger, and felt in love with this 'i'. On contrary, rubycsv and CSV2ledger does not (yet?) implement this 'interactiveness'. Also CSV2ledger is not unicode compliant, and I am not living in

Re: best way to slurp bank records?

2012-10-01 Thread Peter Ross
On 2 October 2012 10:00, Russell Adams rlad...@adamsinfoserv.com wrote: I was too using a personal perl script, doing the mapping from a table. But I tried the 'i' of icsv2ledger, and felt in love with this 'i'. On contrary, rubycsv and CSV2ledger does not (yet?) implement this

Re: best way to slurp bank records?

2012-09-30 Thread Peter Ross
On 29 September 2012 22:37, thierry thierry.dauco...@free.fr wrote: Thanks Peter for this message. I re-discovered the tool, and finally switched to it! The 'i' of icsv2ledger ('i' meaning interactive) is what convinced me. I forked and pulled some changes in github. I have others changes but

Re: best way to slurp bank records?

2012-09-30 Thread Zack Williams
On Sun, Sep 30, 2012 at 12:31 PM, thierry thierry.dauco...@free.fr wrote: I have another change to propose to icsv2ledger. Why is there an account mapping file AND a payee mapping file? Why not merging into a single file? The rubycsv code I wrote does this. Actually it has a generic tablematch

Re: best way to slurp bank records?

2012-09-29 Thread thierry
Thanks Peter for this message. I re-discovered the tool, and finally switched to it! The 'i' of icsv2ledger ('i' meaning interactive) is what convinced me. I forked and pulled some changes in github. I have others changes but they may break some existing functionalities. I write below what I

Re: best way to slurp bank records?

2012-09-26 Thread Eric Abrahamsen
On Tue, Sep 25 2012, Peter Ross wrote: On 25 September 2012 08:19, thierry wrote: icsv2ledger, from Quentin Stafford-Fraser https://github.com/quentinsf/icsv2ledger - code does not look to be unicode compliant - can not rename payee You can rename the payee now. It also has the advantage

Re: best way to slurp bank records?

2012-09-24 Thread thierry
Hi Eric, I personally use a homemade perl script based on pdftotext, which then parse the text output and write ledger syntax. As suggested by Zack, I could have done PDF to CSV and then using a CSV to Ledger tool. But none satisfied my needs. Anyway, here is my personal notes about some CSV

Re: best way to slurp bank records?

2012-09-24 Thread Peter Ross
On 25 September 2012 08:19, thierry wrote: icsv2ledger, from Quentin Stafford-Fraser https://github.com/quentinsf/icsv2ledger - code does not look to be unicode compliant - can not rename payee You can rename the payee now. It also has the advantage that it remembers the renaming of payee

best way to slurp bank records?

2012-09-23 Thread Eric Abrahamsen
I've got some text files from my Chinese banks formatted according to their own system. I'm planning on just using Python to slurp the file in, but I'll need to write it out to ledger format. What's the best way of doing that? I didn't see anything in the /python or /contrib folders that look like

Re: best way to slurp bank records?

2012-09-23 Thread Zack Williams
On Sun, Sep 23, 2012 at 6:34 AM, Eric Abrahamsen e...@ericabrahamsen.net wrote: I've got some text files from my Chinese banks formatted according to their own system. I'm planning on just using Python to slurp the file in, but I'll need to write it out to ledger format. What's the best way of