[GNC] Export Current Search

David Carlson david.carlson.417 at gmail.com
Tue Nov 2 14:39:39 EDT 2021


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.
>


More information about the gnucash-user mailing list