[GNC] Export Current Search

Wed Nov 3 04:29:54 EDT 2021

That would be very useful. 

On Wed, Nov 3, 2021, at 7:15 AM, Alan A Holmes wrote:
> Some while ago Adrien Monteleone went through all the steps necessary 
> to upgrade from a very old V2.x of GnuCash to the last V2.y, then to 
> V3.x and then to V4.x. I've just had a quick look at the archives but 
> can't find it. Perhaps someone can find it more easily, or perhaps 
> Adrien himself can point to it.
>
>
> Alan A Holmes
>
> -----Original Message-----
> From: gnucash-user 
> <gnucash-user-bounces+gnucash=alanaholmes.me.uk at gnucash.org> On Behalf 
> Of Mike Stillingfleet
> Sent: 02 November 2021 19:32
> To: David Carlson <david.carlson.417 at gmail.com>
> Cc: Gnucash Users <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Export Current Search
>
> Ah OK. It would appear that I might be a little out of date. If I up 
> date will my data be safe??
>
> On Tue, Nov 2, 2021, at 7:05 PM, David Carlson wrote:
>> You stumped the experts and the rest of us too.  Nobody remembers whether that option was available that long ago.   You would have a rather long migration path to the current release of 4.8 or so, depending on whether you have data files and reports to update too.  
>> 
>> 
>> On Tue, Nov 2, 2021, 1:44 PM Mike Stillingfleet <mikestillingfleet at fastmail.co.uk> wrote:
>>> __
>>> 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
>>> 
>
> --
>   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