[GNC] Export Current Search

John Ralls jralls at ceridwen.us
Tue Nov 2 14:18:49 EDT 2021


Is a register page displayed in the main window? What version of GnuCash and what operating system/distro?

Regards,
John Ralls

> On Nov 2, 2021, at 11:06 AM, Mike Stillingfleet <mikestillingfleet at fastmail.co.uk> wrote:
> 
> OK well I am afraid that I do not see that on my GNUCASH.  
> 
> On Tue, Nov 2, 2021, at 5:32 PM, John Ralls wrote:
>> No, the Help is literally correct: There is a menu item "Export Current 
>> Register to CSV..." but *only* if a register tab has focus.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>>> On Nov 2, 2021, at 10:25 AM, Mike Stillingfleet <mikestillingfleet at fastmail.co.uk> wrote:
>>> 
>>> OK so the option  export transactions is what the help is referring to? 
>>> 
>>> On Tue, Nov 2, 2021, at 3:48 PM, john wrote:
>>>> No, Help is correct. As David pointed out that item is presented only if the current active tab is a register.
>>>> 
>>>> Regards,
>>>> John Ralls
>>>> 
>>>> 
>>>>> On Nov 2, 2021, at 1:28 AM, Mike Stillingfleet <mikestillingfleet at fastmail.co.uk> wrote:
>>>>> 
>>>>> Thank you Michael.  This works. So the help files for GNUcash which show the fourth option no longer apply.
>>>>> 
>>>>> On Tue, Nov 2, 2021, at 8:24 AM, Michael Hendry wrote:
>>>>>> On 2 Nov 2021, at 07:31, Mike Stillingfleet 
>>>>>> <mikestillingfleet at fastmail.co.uk> wrote:
>>>>>>> 
>>>>>>> Dear GNUCash Forum,
>>>>>>> 
>>>>>>> Firstly I how that I have posted this correctly.
>>>>>>> 
>>>>>>> I have read in the GNU Cash help that if I have focus on the current search I should see 4 export options and one of those will be File->Export->Export Active Register to CSV.
>>>>>>> 
>>>>>>> I do not have that option.
>>>>>>> 
>>>>>>> Is this something that has been removed?
>>>>>>> 
>>>>>>> How else could I export the current search?
>>>>>>> 
>>>>>>> TIA
>>>>>> 
>>>>>> After you have run the search, you will have a “Search Results” tab open.
>>>>>> 
>>>>>> From the “Reports” menu, choose “Account Report”.
>>>>>> 
>>>>>> Click the “Export” button, and save the file to HTML.
>>>>>> 
>>>>>> Before the Export stage, you can adjust the contents of the report 
>>>>>> using the “Options” button.
>>>>>> 
>>>>>> I’m using LibreOffice for the next stage, but presumably other office 
>>>>>> suites will do the same.
>>>>>> 
>>>>>> Open the HTML file in LibreOffice.
>>>>>> 
>>>>>> Select All, and Copy to clipboard.
>>>>>> 
>>>>>> Open a new Spreadsheet file.
>>>>>> 
>>>>>> Paste.
>>>>>> 
>>>>>> Save As CSV.
>>>>>> 
>>>>>> 
>>>>>> This is a very roundabout route, but if this is a one-off job probably 
>>>>>> worthwhile,
>>>>>> 
>>>>>> Michael
>>>>>> 
>>>>>> PS Curses! As I was about to send this, David Cousens beat me to it 
>>>>>> with a proper solution! The feature that misled me (and presumably 
>>>>>> Mike) is that the Export button that appears once the Register tab is 
>>>>>> selected implies that this is the only way to export from a register, 
>>>>>> and blinded me to that alternative route.
>>>>> 
>>>>> -- 
>>>>> Mike Stillingfleet
>>>>> mikestillingfleet at fastmail.co.uk
>>>>> _______________________________________________
>>>>> gnucash-user mailing list
>>>>> gnucash-user at gnucash.org
>>>>> To update your subscription preferences or to unsubscribe:
>>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>>> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>>>> -----
>>>>> Please remember to CC this list on all your replies.
>>>>> You can do this by using Reply-To-List or Reply-All.
>>> 
>>> -- 
>>>  Mike Stillingfleet
>>>  mikestillingfleet at fastmail.co.uk
> 
> -- 
>  Mike Stillingfleet
>  mikestillingfleet at fastmail.co.uk



More information about the gnucash-user mailing list