[GNC] Export Current Search

davidcousens49 at gmail.com davidcousens49 at gmail.com
Wed Nov 3 14:40:06 EDT 2021


Thanks John, 
I'll try and get a bit of spare time and trawl through the archives to update
the wiki then. Will likely need a bit of proofing afterwards.
Cheers
David

On Wed, 2021-11-03 at 11:20 -0700, john wrote:
> 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