[GNC] Export Current Search

[Mike Stillingfleet]

2.6.16 windows 10.

On Tue, Nov 2, 2021, at 6:39 PM, David Carlson wrote:
> John asked "What version of
> > GnuCash and what operating system/distro?"
> 
> On Tue, Nov 2, 2021, 1:24 PM Mike Stillingfleet <mikestillingfleet at fastmail.co.uk> wrote:
>> Yes.
>> 
>> On Tue, Nov 2, 2021, at 6:18 PM, John Ralls wrote:
>> > 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
>> 
>> -- 
>>   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