[GNC] Export Current Search
Mike Stillingfleet
mikestillingfleet at fastmail.co.uk
Tue Nov 2 14:22:36 EDT 2021
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
More information about the gnucash-user
mailing list