Re: [GNC] Export as text or CSV
On 6/7/2022 2:52 AM, davidcousen...@gmail.com wrote: Fred Will a balance sheet report do what you want? That has the balances of all accounts as of a specified date which can be set in the report options as well as the account depth required. David Cousens ALERT -- A Balance Sheet report will have all the real/standing accounts (type asset, liability, equity). It would not, for example, show accounts of type income or expense (temporary accounts of fundamental type equity) but instead replace all of these with a single gains/losses "account" under equity (account in quotes because there is no such account in your CoA; it's the net of all income or expense accounts) Michael ___ 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] Export as text or CSV
On Tue, Jun 7, 2022 at 2:44 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Reports are HTML. > As I have found out (trying lots of reports and options). > They open quite easily in spreadsheet apps. > Oh! I would never have assumed that a spreadsheet could import html. > You can then massage as needed to remove extraneous spacing columns and > then convert to CSV. > GnuCash->Reports->Account Summary (with altered options)->Export (to file) Google Sheets->File->Import->Upload->Drag & drop file gets me what I want. Thanks. ___ 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] Export as text or CSV
On Sun, Jun 5, 2022 at 5:00 PM Stan Brown wrote: > > On 2022-06-05 15:19, Fred Tydeman wrote: > > Is there a way to export either the Accounts main screen or an Accounts > > Summary report as either a plain text file or a CSV file? > > > > The best I have found so far is Select via mouse the text on the multiple > > screens, > > then Ctrl-C to copy to clipboard, then Ctrl-V to paste into a file in an > > editor. > > Unfortunately, that process ends up wrapping lines (to perhaps 80 > > characters). > > Isn't there an editor command to set line length? I'll bet if you set > line length to a large number before pasting, the lines won't wrap. > The editor has an "unlimited" line length. My guess is the clipboard has the line length issue. > I don't know which release of GC you have, but in 2.6.19 I can click > into the Accounts tab, then click File » Export » Export Account Tree to > CSV. I don't suppose that capability would have been removed from later > releases. > Still there. But that export has no account values. ___ 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] Export as text or CSV
Fred Will a balance sheet report do what you want? That has the balances of all accounts as of a specified date which can be set in the report options as well as the account depth required. David Cousens On Sun, 2022-06-05 at 18:47 -0700, Fred Tydeman wrote: > On Sun, Jun 5, 2022 at 5:02 PM David H wrote: > > > Fred, > > > > File >> Export >> Export to CSV doesn't do it for you ? > > > > Already tried that. It does not have the account values. > ___ > 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] Export as text or CSV
Fred Will a balance sheet report do what you want? That has the balances of all accounts as of a specified date which can be set in the report options as well as the account depth required. David Cousens On Sun, 2022-06-05 at 18:47 -0700, Fred Tydeman wrote: > On Sun, Jun 5, 2022 at 5:02 PM David H wrote: > > > Fred, > > > > File >> Export >> Export to CSV doesn't do it for you ? > > > > Already tried that. It does not have the account values. > ___ > 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] Export as text or CSV
Reports are HTML. They open quite easily in spreadsheet apps. You can then massage as needed to remove extraneous spacing columns and then convert to CSV. (you can also select-all and then paste non-formatted text into a spreadsheet if you don't want to save first) If you do the copy/paste method, most spreadsheets should offer you options for importing the text so you can clean up a few formatting issues. (though not all) You could also export a report and script the stripping of formatting spaces, converting it to CSV. (I'm pretty sure there is already an app that can convert HTML tables to CSV, thus saving having to 're-make the wheel') There are also ways to get your data outside of the GnuCash GUI. There is a CLI interface and Python bindings. I haven't used either, but some here on the list have. There is also a separate app called Piecash, which can extract data from GC. Hope one of those will get you what you need. Regards, Adrien On 6/5/22 5:19 PM, Fred Tydeman wrote: Is there a way to export either the Accounts main screen or an Accounts Summary report as either a plain text file or a CSV file? The best I have found so far is Select via mouse the text on the multiple screens, then Ctrl-C to copy to clipboard, then Ctrl-V to paste into a file in an editor. Unfortunately, that process ends up wrapping lines (to perhaps 80 characters). ___ 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] Export as text or CSV
On Sun, Jun 5, 2022 at 5:02 PM David H wrote: > Fred, > > File >> Export >> Export to CSV doesn't do it for you ? > Already tried that. It does not have the account values. ___ 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] Export as text or CSV
Fred, File >> Export >> Export to CSV doesn't do it for you ? Cheers David H. On Mon, 6 Jun 2022 at 08:20, Fred Tydeman wrote: > Is there a way to export either the Accounts main screen or an Accounts > Summary report as either a plain text file or a CSV file? > > The best I have found so far is Select via mouse the text on the multiple > screens, > then Ctrl-C to copy to clipboard, then Ctrl-V to paste into a file in an > editor. > Unfortunately, that process ends up wrapping lines (to perhaps 80 > characters). > ___ > 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] Export as text or CSV
On 2022-06-05 15:19, Fred Tydeman wrote: > Is there a way to export either the Accounts main screen or an Accounts > Summary report as either a plain text file or a CSV file? > > The best I have found so far is Select via mouse the text on the multiple > screens, > then Ctrl-C to copy to clipboard, then Ctrl-V to paste into a file in an > editor. > Unfortunately, that process ends up wrapping lines (to perhaps 80 > characters). Isn't there an editor command to set line length? I'll bet if you set line length to a large number before pasting, the lines won't wrap. I don't know which release of GC you have, but in 2.6.19 I can click into the Accounts tab, then click File » Export » Export Account Tree to CSV. I don't suppose that capability would have been removed from later releases. -- Stan Brown Tehachapi, CA, USA https://BrownMath.com ___ 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] Export as text or CSV
Is there a way to export either the Accounts main screen or an Accounts Summary report as either a plain text file or a CSV file? The best I have found so far is Select via mouse the text on the multiple screens, then Ctrl-C to copy to clipboard, then Ctrl-V to paste into a file in an editor. Unfortunately, that process ends up wrapping lines (to perhaps 80 characters). ___ 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.