Re: [GNC] Transaction report export file type
Rich I just managed to get a balance sheet report into calc on LM20 by copying the html from the report to the clipboeard then used Edit->Paste Special- >Unformatted Text then selected only the tab separator (having comma or space selected is a disaster). It copied from the clipboard with no problem and put everything in the right rows and columns. David Cousens On Thu, 2021-06-24 at 15:56 -0700, Rich Shepard wrote: > On Fri, 25 Jun 2021, David H wrote: > > > You'll probably have to do a bit of cleaning up whichever way you go if > > you want to get rid of all the extraneous headers the are in the html file > > to get to a true .csv looking file :-) > > David, > > Figured out how to do it. In Calc -> Sheet -> Link to external data brings > in the .html. And saving as .csv does work. > > Cleaning up the cruft in emacs is simple. > > I've learned something new today. > > Thanks, > > Rich > ___ > gnucash-user mailing list > gnucash-user@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@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.
Re: [GNC] Transaction report export file type
Ah I didn't think of that - been a long while since I stopped writing design docs and had to link in an external object :-) So we're both still learning which is good !!! Cheers David H. On Fri, 25 Jun 2021 at 08:58, Rich Shepard wrote: > On Fri, 25 Jun 2021, David H wrote: > > > You'll probably have to do a bit of cleaning up whichever way you go if > > you want to get rid of all the extraneous headers the are in the html > file > > to get to a true .csv looking file :-) > > David, > > Figured out how to do it. In Calc -> Sheet -> Link to external data brings > in the .html. And saving as .csv does work. > > Cleaning up the cruft in emacs is simple. > > I've learned something new today. > > Thanks, > > Rich > ___ > gnucash-user mailing list > gnucash-user@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@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.
Re: [GNC] Transaction report export file type
On Fri, 25 Jun 2021, David H wrote: You'll probably have to do a bit of cleaning up whichever way you go if you want to get rid of all the extraneous headers the are in the html file to get to a true .csv looking file :-) David, Figured out how to do it. In Calc -> Sheet -> Link to external data brings in the .html. And saving as .csv does work. Cleaning up the cruft in emacs is simple. I've learned something new today. Thanks, Rich ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Transaction report export file type
I just used Ubuntu's file explorer to open the folder with the .html file in and then right clicked which gives me a dialog box that I can choose lots of options one of which is what I want to do - it's actually the 2nd option down not the bottom one which says "Other Application"... Cheers David On Fri, 25 Jun 2021 at 08:51, Rich Shepard wrote: > On Fri, 25 Jun 2021, David H wrote: > > > Er yes - I'm running LibreOffice Calc 7.1 on Ubuntu 21.04 and it will > open > > the .html file directly and you can save it as .csv from there - you just > > have to make sure when you are asked what you want to open the .html file > > with you click on "Other Application" at the bottom of the dialog box and > > scroll down until you find the LibreOffice calc menu item and click on > it. > > David, > > When I invoke LO and select ctrl-o to open a file I'm not asked which tool > should open it. It opens as a read-only Writer file. > > Regards, > > Rich > ___ > gnucash-user mailing list > gnucash-user@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@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.
Re: [GNC] Transaction report export file type
You'll probably have to do a bit of cleaning up whichever way you go if you want to get rid of all the extraneous headers the are in the html file to get to a true .csv looking file :-) Cheers David H. On Fri, 25 Jun 2021 at 08:46, Rich Shepard wrote: > On Fri, 25 Jun 2021, David H wrote: > > > Er yes - I'm running LibreOffice Calc 7.1 on Ubuntu 21.04 and it will > open > > the .html file directly and you can save it as .csv from there - you just > > have to make sure when you are asked what you want to open the .html file > > with you click on "Other Application" at the bottom of the dialog box and > > scroll down until you find the LibreOffice calc menu item and click on > it. > > David, > > Okay. I sit corrected. > > I'll try that rather than opening a new spreadsheet and then opening the > data file. > > Thanks, > > Rich > ___ > gnucash-user mailing list > gnucash-user@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@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.
Re: [GNC] Transaction report export file type
On Fri, 25 Jun 2021, David H wrote: Er yes - I'm running LibreOffice Calc 7.1 on Ubuntu 21.04 and it will open the .html file directly and you can save it as .csv from there - you just have to make sure when you are asked what you want to open the .html file with you click on "Other Application" at the bottom of the dialog box and scroll down until you find the LibreOffice calc menu item and click on it. David, When I invoke LO and select ctrl-o to open a file I'm not asked which tool should open it. It opens as a read-only Writer file. Regards, Rich ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Transaction report export file type
On Fri, 25 Jun 2021, David H wrote: Er yes - I'm running LibreOffice Calc 7.1 on Ubuntu 21.04 and it will open the .html file directly and you can save it as .csv from there - you just have to make sure when you are asked what you want to open the .html file with you click on "Other Application" at the bottom of the dialog box and scroll down until you find the LibreOffice calc menu item and click on it. David, Okay. I sit corrected. I'll try that rather than opening a new spreadsheet and then opening the data file. Thanks, Rich ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Transaction report export file type
On Fri, 25 Jun 2021, David H wrote: What about the cut and paste from html into Calc ? David, I'd first have to remove all the html markup. If I do that I have a plain, ASCII text file regardless of where it's used. And I can reformat it in emacs however I want. Regards, Rich ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Transaction report export file type
Er yes - I'm running LibreOffice Calc 7.1 on Ubuntu 21.04 and it will open the .html file directly and you can save it as .csv from there - you just have to make sure when you are asked what you want to open the .html file with you click on "Other Application" at the bottom of the dialog box and scroll down until you find the LibreOffice calc menu item and click on it. Cheers David H. On Fri, 25 Jun 2021 at 08:15, Rich Shepard wrote: > On Fri, 25 Jun 2021, David H wrote: > > > Don't know what your objective is but if it helps MS Excel on MacOS will > > David, > > That's fine if you run Apple and Microsoft software; the linux spreadsheets > I use, gnumeric and LibreOffice's Calc won't work with .pdf or anything > other than .xls(x) or .csv. > > Thanks, > > Rich > ___ > gnucash-user mailing list > gnucash-user@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@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.
Re: [GNC] Transaction report export file type
What about the cut and paste from html into Calc ? Cheers David H. On Fri, 25 Jun 2021 at 08:15, Rich Shepard wrote: > On Fri, 25 Jun 2021, David H wrote: > > > Don't know what your objective is but if it helps MS Excel on MacOS will > > David, > > That's fine if you run Apple and Microsoft software; the linux spreadsheets > I use, gnumeric and LibreOffice's Calc won't work with .pdf or anything > other than .xls(x) or .csv. > > Thanks, > > Rich > ___ > gnucash-user mailing list > gnucash-user@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@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.
Re: [GNC] Transaction report export file type
On Fri, 25 Jun 2021, David H wrote: Don't know what your objective is but if it helps MS Excel on MacOS will David, That's fine if you run Apple and Microsoft software; the linux spreadsheets I use, gnumeric and LibreOffice's Calc won't work with .pdf or anything other than .xls(x) or .csv. Thanks, Rich ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Transaction report export file type
On Thu, 24 Jun 2021, David Carlson wrote: I have not tested this, but sometimes one can either open a pdf file with a spreadsheet application or copy a PDF file and paste it into a new spreadsheet. Once that is done it is often relatively easy to clean up stray cells and save in CSV format. David, I don't think that LibreOffice's Calc or gnumeric will do this. Thanks, Rich ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Transaction report export file type
On Thu, 24 Jun 2021, John Ralls wrote: It usually works to copy-and-paste the report into a spreadsheet. John, Oh. Okay. Thanks, Rich ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Transaction report export file type
Rich, Don't know what your objective is but if it helps MS Excel on MacOS will open a txn report html directly - looks ok and you could probably save as csv from there ? Also Numbers won't open it directly but you can highlight everything and paste it into a blank sheet which you could export to csv. Cheers David H. On Fri, 25 Jun 2021 at 07:32, Rich Shepard wrote: > Is there a way to export a transaction report as a .csv or .txt file? I > looked at all options and didn't see any place to select the export format. > When I did export the file it defaulted to .html; that would take a lot of > cleaning and it would be nice to export to .csv or .txt. > > Any thoughts? > > Rich > ___ > gnucash-user mailing list > gnucash-user@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@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.
Re: [GNC] Transaction report export file type
I have not tested this, but sometimes one can either open a pdf file with a spreadsheet application or copy a PDF file and paste it into a new spreadsheet. Once that is done it is often relatively easy to clean up stray cells and save in CSV format. On Thu, Jun 24, 2021 at 4:32 PM Rich Shepard wrote: > Is there a way to export a transaction report as a .csv or .txt file? I > looked at all options and didn't see any place to select the export format. > When I did export the file it defaulted to .html; that would take a lot of > cleaning and it would be nice to export to .csv or .txt. > > Any thoughts? > > Rich > ___ > gnucash-user mailing list > gnucash-user@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. > -- David Carlson ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Transaction report export file type
> On Jun 24, 2021, at 2:31 PM, Rich Shepard wrote: > > Is there a way to export a transaction report as a .csv or .txt file? I > looked at all options and didn't see any place to select the export format. > When I did export the file it defaulted to .html; that would take a lot of > cleaning and it would be nice to export to .csv or .txt. > > Any thoughts? It usually works to copy-and-paste the report into a spreadsheet. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@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.
[GNC] Transaction report export file type
Is there a way to export a transaction report as a .csv or .txt file? I looked at all options and didn't see any place to select the export format. When I did export the file it defaulted to .html; that would take a lot of cleaning and it would be nice to export to .csv or .txt. Any thoughts? Rich ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] dark theme on Linux
Michael, Under the Edit->Preferences dialog there is an option to use the GnuCash built in colour scheme. Turning this off allows the dark Theme from the system to be used in the register display. I am running Linux Mint using Adwaita-dark for the buttons and the Linux Mint-Y-dark for the Windows borders and Mint-Y-Dark-Teal for Icons in the System theme settings. These seem to be picked up by GnuCash without any difficulty. I have made no changes to the defauklt gtk-3.0.css filein .config/gnucash or the stylesheets in.local/share/gnucash. The window appearance with the default GnuCash colours is as per the attached screenshot of a screen fragment. With the Gnucash colors on, the appearance is the same apart from the background colors for the register entries but the windows borders icons and buttons remain unchanged. The link you posted did not link to anything so I am not sure what you have done David On Thu, 2021-06-24 at 11:20 +0200, Michael via gnucash-user wrote: > I have the following configuration: MX Linux 19.4 AHS, GnuCash 4.5, I > have Adwaita-dark theme enabled by default in MX, when I start GNC, the > buttons/menu has no dark theme enabled, tried the solution suggested in > this post , still doesn't work, > how can I enable dark theme in GNC? Please see the attached screenshot. > > ___ > gnucash-user mailing list > gnucash-user@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@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.
[GNC] dark theme on Linux
I have the following configuration: MX Linux 19.4 AHS, GnuCash 4.5, I have Adwaita-dark theme enabled by default in MX, when I start GNC, the buttons/menu has no dark theme enabled, tried the solution suggested in this post , still doesn't work, how can I enable dark theme in GNC? Please see the attached screenshot. ___ gnucash-user mailing list gnucash-user@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.
