Re: Register report with depth limit and sub-totaling

2016-06-13 Thread Evgeny Panasyuk

>
>
> How to achieve this?
>

I found on web that it is possible to achieve this with balance report plus 
special --group-by format:
; example2.ledger

2016/04/30 car
expenses:car:gas  200$
expenses:car:repair   500$
expenses:other 50$
assets:cash

2016/05/31 car
expenses:car:gas  100$
expenses:car:repair  1000$
expenses:other  5$
assets:cash

ledger -f example2.ledger bal --group-by 'format_date(date, "%Y-%m")' --depth 
2 expenses
2016-04
750$  expenses
700$car
 50$other

750$

2016-05
   1105$  expenses
   1100$car
  5$other

   1105$


-- 

--- 
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 ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: Scaling to large transaction datasets

2016-06-13 Thread Martin Michlmayr
* Pavel  [2016-05-30 14:06]:
> I have a dataset with tens of thousands transactions per months over
> several years and was attracted by ledger's flexibility in commodity
> handling. Just checking if anyone has experience with large journals
> before I script data dump to a ledger input text-file.

If you run into problems, you could also split your files per year and
start each year with "opening balance" entries based on the closing
balance of the previous year.

-- 
Martin Michlmayr
http://www.cyrius.com/

-- 

--- 
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 ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: Verify account balance from bank statement

2016-06-13 Thread John Wiegley
> Martin Blais  writes:

> I bet it wouldn't make Ledger more than 5% slower, and only when the option
> is specified. It would, however, need keep the posting objects in memory
> through the end of the first pass. (Warning: I haven't looked at the source
> code.)

If those are the only caveats, I'd support such a change.

-- 
John Wiegley  GPG fingerprint = 4710 CF98 AF9B 327B B80F
http://newartisans.com  60E1 46C4 BD1A 7AC1 4BA2

-- 

--- 
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 ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: Scaling to large transaction datasets

2016-06-13 Thread John Wiegley
> Pavel   writes:

> I was wondering if anyone tried using ledger with a large transaction set, 
> around 10^5 to 10^6 transactions total? Would it be practical?

If you avoid using automated transactions, then there should be no problem
with data sets of that size in C++Ledger.

-- 
John Wiegley  GPG fingerprint = 4710 CF98 AF9B 327B B80F
http://newartisans.com  60E1 46C4 BD1A 7AC1 4BA2

-- 

--- 
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 ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: Does anyone have a hledger to beancount converter?

2016-06-13 Thread Martin Blais
Beancount doesn't convert from ledger nor hledger. I set out to write a
converter at some point but I couldn't get the ledger Python API working
quickly and on Mac and Linux and so I gave up. one could write a
ledger/hledger parser to do this, would be another idea.

Note that if you use beancount syntax it's straightforward to convert to
other ledger syntaxes, either using the existing converters or writing your
own
On Jun 13, 2016 09:25, "Simon Michael"  wrote:

> On 6/4/16 10:43 PM, Mark Hansen wrote:
>
>> I figured I'd ask on the mailing list before trying to write my own. I did
>> a bit of searching but couldn't find one.
>>
>
> There isn't one specifically, but isn't your hledger file pretty close to
> ledger format ? (hledger print output certainly is). At
> http://plaintextaccounting.org/#data-importconversion there's
> ledger2beancount.py, also I believe beancount includes some conversion
> tools.
>
>
> --
>
> --- 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 ledger-cli+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 

--- 
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 ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: ledger ncurses interface

2016-06-13 Thread Simon Michael



On 6/13/16 6:30 AM, Simon Michael wrote:

On 6/9/16 12:41 PM, Fergus Cameron wrote:

Nah, text-editor is better idea.  Create a temp file (mktemp) and
output some data to it from either an 'entry' transaction or a static
template (with current date, I guess).  Then invoke VISUAL or EDITOR
on it (or 'vi' if nothing there) and once that exits, append to the
current ledger file.  Job done.  IMHO.


I'm interested too. Recently I've begun adding data entry to hledger-ui,
by integrating the console-style hledger add command. I was thinking of
the above, but I think the editor modes work best eg for account name
completion when they can see the full file, so I plan to do that. It
makes for easier saving too. In any case, for this kind of thing we need
to find out the file position of a transaction.


PS: I mean, for editing we'd like to have the file position. For adding, 
it's a simple append, just as you said.


--

--- 
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 ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: ledger ncurses interface

2016-06-13 Thread Simon Michael

On 6/9/16 12:41 PM, Fergus Cameron wrote:

Nah, text-editor is better idea.  Create a temp file (mktemp) and
output some data to it from either an 'entry' transaction or a static
template (with current date, I guess).  Then invoke VISUAL or EDITOR
on it (or 'vi' if nothing there) and once that exits, append to the
current ledger file.  Job done.  IMHO.


I'm interested too. Recently I've begun adding data entry to hledger-ui, 
by integrating the console-style hledger add command. I was thinking of 
the above, but I think the editor modes work best eg for account name 
completion when they can see the full file, so I plan to do that. It 
makes for easier saving too. In any case, for this kind of thing we need 
to find out the file position of a transaction.


--

--- 
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 ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: Does anyone have a hledger to beancount converter?

2016-06-13 Thread Simon Michael

On 6/4/16 10:43 PM, Mark Hansen wrote:

I figured I'd ask on the mailing list before trying to write my own. I did
a bit of searching but couldn't find one.


There isn't one specifically, but isn't your hledger file pretty close 
to ledger format ? (hledger print output certainly is). At 
http://plaintextaccounting.org/#data-importconversion there's 
ledger2beancount.py, also I believe beancount includes some conversion 
tools.



--

--- 
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 ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: Ledger Tree not Visible

2016-06-13 Thread Simon Michael

On 6/9/16 10:24 AM, James wrote:

Hi,
i am new to ledger. When I run the balance command I get a collapsed
version with :-

Assets
Equity
Liabilities

How do I correct this?


Welcome. Quick fix: add the -s flag to your balance command. Better fix: 
upgrade to Ledger 3.



--

--- 
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 ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: Register report with depth limit and sub-totaling

2016-06-13 Thread Simon Michael

On 5/31/16 7:37 AM, Evgeny Panasyuk wrote:

I do not want such detailed report, what I want is to limit depth to 2 and
get subtotals for each second level account, similar to above balance
report. Something like:
ledger -f example.ledger reg expenses -M
16-May-01 - 16-May-31   expenses:car  1100$
1100$
expenses:other   5$
1105$

How to achieve this?


You could use hledger register:

ledger -f example.ledger print expenses | hledger -f- reg expenses -M 
--depth 2



--

--- 
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 ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.