[GNC] Transaction report export file type
Last year I found the process of getting a budget report in a spreadsheet confusing ( https://lists.gnucash.org/pipermail/gnucash-user/2020-May/091064.html). I understood it after help from the community and twigging to turning off the white background colour for the cells on the page. It would be worth discussing in the user guide. ___ 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 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.