I want to export an account as I see it in the interactive view of GnuCash as an ASCII file

Dorel Ciornei dorelciornei at yahoo.com
Sun Aug 30 11:43:27 EDT 2015


I had exactly the same issue.What Geert suggested is exactly what i did:
I ran a report, selected the options I wanted (make sure to expand the Options window of the report to see the all the Filter By... options, with the include/exclude choices).
I selected everything in the report, copied and paste in a new spreadsheet.
It worked like a charm.I hope it works for you too. 


     On Friday, August 28, 2015 1:08 PM, Geert Janssens <geert.gnucash at kobaltwit.be> wrote:
   

 On Monday 24 August 2015 10:57:58 Anton Kratz wrote:
> Hi,
> 
> when I look at an account in GnuCash, I see the following columns:
> Date, Num, Description, Transfer, R, Debit, Credit, Balance.
> 
> Each transaction is on a single line.
> 
> I want to export an account with these eight columns, with each
> transaction as a single line, as a tab-separated (or comma-separated)
> ASCII file. I.e. I want to export the account as I see it in the
> interactive view of GnuCash, as a delimiter-separated ASCII file. Is
> this possible, and how can I do that?
> 
> I can export accounts as ASCII files via "File --> Export --> Export
> Transactions to CSV...".
> 
> However, I then get much more columns and lines that I am interested
> in, namely columns:
> 
> Date, Account Name, Number, Description, Notes, Memo, Category, Type,
> Action, Reconcile, To With Sym, From With Sym, To Num., From Num., To
> Rate/Price, From Rate/Price
> 
> ...and also, each transaction is now on three lines.
> 
> I can re-format the export into what I want and what I know from the
> GnuCash interactive view, but it is a very tedious and error-prone
> process.
> 
> Anton
> 
I'm afraid this is not possible from the gui and on OS X you won't be able to write a script for 
it in python either (the python bindings are not available on OS X).

I haven't tried but perhaps you could use the transaction report instead ?

It has more configuration options and its output can be saved to html. I know both Excel and 
LibreOffice/OpenOffice Calc can import the html file. Or you can even copy/paste directly from 
the open report to an open spreadsheet.

Regards,

Geert
_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


   


More information about the gnucash-user mailing list