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] Credit Card Accounts Missing
Sounds like gnucash did not open the correct data file for some reason. The most likely reason s are specific to your local configuration, of which we have no knowledge. Check to see if your backups are good. On Tue, Jun 7, 2022, 6:42 PM Les wrote: > Hey All: > > This morning, I had a new credit card statement and was going to > reconcile. However, when I went to the the Liabilities account, there > were no credit card accounts listed. Bizarre. The display was only > Liabilities: Auto Loan. > > I am a long time user of GC and have never encountered this before > today. I am using GC the latest version from Flatpak on Linux Mint 19.3. > > Thanks for any help. > > Les > ___ > 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] Credit Card Accounts Missing
Did you perhaps accidentally hide it? Or maybe you hide zero-value accounts? View -> Filter By -> Other -derek On Mon, June 6, 2022 12:54 pm, Les wrote: > Hey All: > > This morning, I had a new credit card statement and was going to > reconcile. However, when I went to the the Liabilities account, there > were no credit card accounts listed. Bizarre. The display was only > Liabilities: Auto Loan. > > I am a long time user of GC and have never encountered this before > today. I am using GC the latest version from Flatpak on Linux Mint 19.3. > > Thanks for any help. > > Les > ___ > 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. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] Credit Card Accounts Missing
Hey All: This morning, I had a new credit card statement and was going to reconcile. However, when I went to the the Liabilities account, there were no credit card accounts listed. Bizarre. The display was only Liabilities: Auto Loan. I am a long time user of GC and have never encountered this before today. I am using GC the latest version from Flatpak on Linux Mint 19.3. Thanks for any help. Les ___ 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] Problems accessing anything on gnucash website
Eric, Please always 'reply-to-list' or 'reply-all' and always send new messages to the list address rather than to individual users. This keeps the discussion on the list for all to see so anyone can help out, and others might benefit from the suggestions. As to your question, I'm not sure what you're trying to do as you don't need to 'login' to the site for anything. Some of those links, if you hover, you'll see point to wiki.gnucash.org, which appears to be down at the moment. Unfortunately, this also takes down the mailing list, so I'm copying you this one time. (normally, I only reply to the list) Note, an IRC channel is also available which doesn't rely on that same server. You can get help there. -- Regards, Adrien On 6/6/22 8:32 PM, Eric Hammond wrote: Hi, Sorry to pick on you, your email was handy, thank you. I have tried to get into the gnucash.org links: With Firefox Only “Information” section: “home” and “news” work With Opera “Information” section: “home”, “news”, “screenshots & features” & “donations” “Downloads” section: both options work “Support” section: only “Documentation” works “Development” section: only “Browse Source Code” works With Tor Browser site wont load. With Brave: same as Opera I have a few more browsers, I decided to ask for help instead. I don’t find a way to login. Thanks for your help, Eric Hammond 670 Rainier Lane Port Ludlow, WA 98365 (949) 244-3595 e...@jehammond.net “Be the change that you wish to see in the world.” ― Mahatma Gandhi ___ 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.
[GNC] [MAINT] Unplanned network outage for code.gnucash.org
Hi All, tl;dr: Double-whammy of UPS failing and then AT Router failing kept me offline for two days, including code.gnucash.org. Finally received the new router around 5pm so the network is back up, but the UPS is still failing so equipment currently is up but not protected. Long version: Around 10:30pm on Sunday night by TV displayed "Network Cable Unplugged". I didn't think anything of it until the show I was streaming stopped a few minutes later. I went down to the basement to discover that everything plugged into the UPS was powered off. After fighting with the UPS (the 'on' button didn't do anything) I figured out how to reset it by unplugging it and the plugging it in again. This got everything up and running, but the AT router would not authenticate to the network so I couldn't get online. I thought it might've been a result of my ER-4 so I removed that from the equation, but it didn't help. After an hour on the phone with a nice AT tech in Slovenia I had a new modem on order and I finally got to bed at 12:30 knowing there wasn't anything else I could do. The tech said I should have the modem by Tuesday, but it was possible I could get it Monday. Monday morning I called AT to try to get tracking info, but my modem order was still processing. I called back again Monday afternoon and got FedEx tracking for the box, which was being sent to me from California. The modem arrived today around 5pm, and I quickly installed it, only to find that no, it did not have my static IP config in there. So I called back to AT and got another tech who was able to get me configured. I verified it was working while he was on the phone, and then worked with him on a few additional configuration changes, and verified my billing (which of course AT screwed up, too, but he claims to have fixed it -- I'll check that tomorrow). However, during all this, the UPS powered-down my equipment several times over the past couple days, including at least four times in a 3-hour spread from 3:20-6pm. I finally decided that the UPS wasn't helping so I unplugged all the equipment from the UPS and into my mainline (unprotected) circuit, while I work on figuring out why the UPS keeps turning off. So for now: 1) network is up, but I might be subject to NAT tables filling up until I can return to using my ER-4 gateway. 2) systems are up, but are not UPS protected 3) code is back up and running. I'm going to have several maintenance windows going forward to return the ER-4 into service, and, eventually, once I get the UPS repaired (whatever that means). Any network outage due to the former should be relatively short. However I will have to take all my hardware down to change where it's plugged in. -derek PS: Yes, I really should look into a backup to my main fiber network, although that wouldn't have helped with the UPS turning off its outputs! -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] edit --> find --> description contains fails to show accounts receivable items
Is this a feature, or a bug? When I select assets then do a find search, I can find an item, "cart, poly strapping", being bought, and the cost of goods sold entry when it leaves inventory, but the AR account is also a sub account of assets and has the description on the invoice line item and the payment line item and they do not show. ___ 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] Transfer Dates
Then edit the CSV for the proper Descriptions & Accounts before importing. More than likely, that can be scripted or at least accomplished with some creative copy/paste (or spreadsheet formulas/macros) to speed things up if the file is really large. *Note! - it is always advised to import smaller batches repeatedly to train the importer. Trying to import say, 10 years worth of data, is going to be a pain. The time savings of the importer learning your transactions comes from repeated importing. (teaching it what it guesses wrong as you go) The usual advice is one month at a time, but I'd say that depends on account activity. Be your own judge of how many transactions you want to train the importer with at a time. Probably something like 100 transactions would be a reasonable 'top-limit' though that may be a bit high depending on your stamina and pain threshold for repetitive work. Regards, Adrien On 6/5/22 7:40 PM, viking...@san.rr.com wrote: @Gyle, The suggested approach may work well when entering the transactions manually and then reconciling. However, I am not entering the transactions manually. I am importing all the bank transactions, including the transfers, from several CSV files to an empty GnuCash file. ___ 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] Transfer Dates
That's what the Description line is for. I suppose you can use it for all sorts of things, but personally I only use it as a 'payee' line, that is, whomever is receiving my funds. If I'm the one receiving, then it is a 'payor' line, the one giving me money. Sticking to that, you should easily be able to see where in-transit funds are coming from and going to. If that still isn't good enough, create sub-accounts for either sources or destinations. Regards, Adrien On Mon, 6 Jun 2022 at 07:55, wrote: A disadvantage of using a “Funds in Transit account” is that I wouldn’t easily see where the money was going (I am transferring between more than two banks). ___ 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.
