Re: [GNC] Unable to Export General Ledger (was: Potential regression: PDFs generated using "Make PDF" have a superfluous blank page)

That’s probably a different issue entirely. I just ran the General Ledger Report, and used both ‘Export' (which is HTML) and ‘Make PDF’ both of which worked fine without extra blank pages. (I’m now on 3.906 on MacOS 10.15.5) I haven’t yet jumped to 4.x but will tonight. I’ll see if I can test

Re: export general ledger

Op dinsdag 19 december 2017 15:58:38 CET schreef Adrien Monteleone: > Thanks Geert, > > Good to know if I ever need this, export is not the way to go. > > Out of curiosity, could you shed light on why the limitation to export only > one account type at a time? > > Regards, > Adrien I believe

Re: export general ledger

Thanks Geert, Good to know if I ever need this, export is not the way to go. Out of curiosity, could you shed light on why the limitation to export only one account type at a time? Regards, Adrien > On Dec 19, 2017, at 2:16 AM, Geert Janssens > wrote: > > Op

Re: export general ledger

Op dinsdag 19 december 2017 02:55:14 CET schreef Adrien Monteleone: > Sorry if my understanding of the GC General Ledger was off. > > By combining the files, I meant the exported csv files. So a simple: “cat * > > gnucash.csv” after those 4 exports would do the trick. > You'd probably end up

Re: export general ledger

Jeff, If you have piles of invoices, and you like data entry spreadsheet/text style, you can set up an import csv for them instead and bring them in all at once. There’s a few threads here about the format not too long ago. (within the year) Regards, Adrien > On Dec 18, 2017, at 1:06 PM, Jeff

Re: export general ledger

Sorry if my understanding of the GC General Ledger was off. By combining the files, I meant the exported csv files. So a simple: “cat * > gnucash.csv” after those 4 exports would do the trick. Regards, Adrien > On Dec 18, 2017, at 1:17 PM, Wm via gnucash-user >

Re: export general ledger

On 18/12/2017 18:13, Adrien Monteleone wrote: Jeff, If I recall correctly from other discussion, the General Ledger is not it’s own entity. It’s a ‘view’ of the separate account ledgers all rolled into one. This is probably why there is no export option for it. You recall incorrectly. The

Re: export general ledger

On 18/12/2017 13:16, Sébastien de Menten wrote: To export a gnucash book to a ledger-cli output, you may be interested by the piecash python module and the related script https://github.com/sdementen/piecash/blob/master/scripts/piecash_ledger.py I already said that, you just have to wait

Re: export general ledger

On 18/12/2017 10:32, Jeff Abrahamson wrote: On 18/12/17 03:26, Wm via gnucash-user wrote: On 17/12/2017 19:31, Jeff Abrahamson wrote: I'd like to export the general ledger to a csv file.  When I use File -> Export, however, I'm offered a choice of exporting income, expenses, assets, or

Re: export general ledger

> > Alternatively there are a number of scripts that can take gnc files of > some flavour and produce ledger-cli / beancount compatible files which are > generally mores useful than csv files for accounting data anyway. It looks like ledger-cli dropped gnucash import support in 2009?

Re: export general ledger

Thanks, Adrien.  In the end, as long as I can automate this, I'll be happy.  (I haven't fully followed on on the python solution, but it sure looks like it will work fine, so I've chalked it up as future work for me rather than potential workflow blocking today.  Always good to have a project over

Re: export general ledger

Jeff, If I recall correctly from other discussion, the General Ledger is not it’s own entity. It’s a ‘view’ of the separate account ledgers all rolled into one. This is probably why there is no export option for it. GnuCash takes the opposite approach from paper books. With paper, you enter

Re: export general ledger

To export a gnucash book to a ledger-cli output, you may be interested by the piecash python module and the related script https://github.com/sdementen/piecash/blob/master/scripts/piecash_ledger.py On Mon, Dec 18, 2017 at 11:32 AM, Jeff Abrahamson wrote: > On 18/12/17 03:26, Wm

Re: export general ledger

On 18/12/17 03:26, Wm via gnucash-user wrote: > On 17/12/2017 19:31, Jeff Abrahamson wrote: >> I'd like to export the general ledger to a csv file.  When I use File -> >> Export, however, I'm offered a choice of exporting income, expenses, >> assets, or liabilities.  But I'd like to have all

Re: export general ledger

On 17/12/2017 19:31, Jeff Abrahamson wrote: I'd like to export the general ledger to a csv file.  When I use File -> Export, however, I'm offered a choice of exporting income, expenses, assets, or liabilities.  But I'd like to have all transactions in the csv file. I think I see how to do this

export general ledger

I'd like to export the general ledger to a csv file.  When I use File -> Export, however, I'm offered a choice of exporting income, expenses, assets, or liabilities.  But I'd like to have all transactions in the csv file. I think I see how to do this using python (the example script