If you are at all familiar with Python, I'd do this by hand in code by looping over the transactions and postings within rather than trying to fiddle with BQL. Here's some inspiration: https://github.com/beancount/beancount/blob/v2/beancount/projects/export.py Once you are familiar with a few API pieces (loader.load_file and filtering to get the Transactions out of entries), this is a quick task.
On Tue, Nov 30, 2021 at 10:41 AM Varac <va...@varac.net> wrote: > For tax consultency I need to export an csv file which lists my > transactions in this format (only fields relevant to my question given): > > date, amount, account_from, account_to > > I.e. given this transaction: > > > 2021-11-30 txn "Shopping" > Assets:Beans -10 EUR > Expenses:Unneccessary 4 EUR > Expenses:Wtf 6 EUR > > > I want a csv export like this: > > 2021-11-30, 4, Asset:Beans, Expenses:Unneccessary > 2021-11-30, 6, Asset:Beans, Expenses:Wtf > > Is there any way getting this out of a bean-query ? > Or what would be the best approach ? > Looking forward to some serious beancount SQL wizardry above my horizon ! > > Thanks for any hints, Varac > > -- > You received this message because you are subscribed to the Google Groups > "Beancount" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to beancount+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/beancount/89497063-12be-83cf-8953-d2e7090f90f0%40varac.net > . > -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop receiving emails from it, send an email to beancount+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/CACGEkZsa3n78JeF3aMcsAH1%3D3%3DeEWY5VLp6U_%3DBTKxw08O2%2BdQ%40mail.gmail.com.
