[GNC] Export Current Search

john jralls at ceridwen.us
Wed Nov 3 14:20:25 EDT 2021 

There's already some of that at https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgrade, but the instructions aren't as clear as Geert's post.

Regards,
John Ralls


> On Nov 3, 2021, at 2:02 AM, davidcousens49 at gmail.com wrote:
> 
> Upgrade 2.6 to 3.5 
> https://www.mail-archive.com/gnucash-user@gnucash.org/msg13291.html
> I think Geert's post which was the in thread (scroll down)I posted earlier is a
> bit more complete as it discusses reports and preferences as well as changes to
> the data file. 
> 
> Possibly worth putting a summary in the Wiki re upgrades from earlier version.
> 
> David Cousens
> On Wed, 2021-11-03 at 07:15 +0000, 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.
>> 
>> _______________________________________________
>> 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.
> 
> _______________________________________________
> 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.

More information about the gnucash-user mailing list