[GNC] Export Current Search

Wed Nov 3 03:15:59 EDT 2021

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.