Re: [GNC] Rounded Up/Down Share Purchase with Dividend
Hi xboxboy.mageia, In my experience, Australian companies usually retain the difference between the total dividend and the value of the integer no of shares reinvested for you. I track this value for each share in an asset account called Assets:Investments:Residual:[Share Code] The opening and closing residual value usually shows on each dividend. I think some companies allow you to specify to donate this residual to charity. If that is not your preference, most companies return the residual value to your dividend bank account when you change to having 0% of your dividend reinvested. Regards, Chris Good > > Message: 1 > Date: Thu, 8 Jun 2023 01:30:36 +0930 > From: "xboxboy.mageia+GnuCash" > To: "gnucash-user@gnucash.org" > Subject: Re: [GNC] Rounded Up/Down Share Purchase with Dividend > Message-ID: <79a99dd0-0f90-c283-60e3-9f9c937aa...@gmail.com> > Content-Type: text/plain; charset=UTF-8; format=flowed > > Hi Jim, > > that's just it, the $2 does 'vanish'. I don't see it, it's not passed to > me at that time, or any time in the future: > > As for a line to account for that, I guess that's what I'm asking: How > do I create an account to absorb that $2, that then disappears into the > ether? > > I hope that is clearer? > >> On 8/6/23 01:21, Jim DeLaHunt wrote: >> Hello, xboxboy.magela: >> >> You ask how to account for the $2 that has "vanished". This jumps out >> at me as the core of the problem: >> >>> Dividend (franked): Dividend reinvestment account $10 >>> Buy: stock purchase: 1 unit $8, total buy $8 >> If your dividend after franking is $10, and you buy stock for $8, then >> there should be $2 cash left over. You do not show that left over cash >> in your transaction. Where does that money go in real life?? Add a >> line for that in your transaction, and it should balance. >> >> Does this answer your question? >> >> Best regards, >> ??? ?Jim DeLaHunt, Vancouver, Canada >> >>> On 2023-06-07 08:01, xboxboy.mageia+GnuCash wrote: >>> Hi guys, >>> >>> My issue is this: I'll provide an example: Note, I'm in Australia, so >>> we have franked (taxed) dividends that we claim a tax break on. >>> >>> Total dividend $12; made up of >>> >>> Franked dividend $10 >>> >>> Imput credit (tax credit) $2 >>> >>> (So in this example $2 is paid to the tax office by the company, and >>> I receive only $10) >>> >>> But I reinvest this dividend: Say the shares are $8. >>> >>> That means with my $10, I can get 1.25 shares, but it gets rounded >>> down/up to the nearest share. >>> >>> So I get one share for a cost of $8. >>> >>> So normally I'd enter it like this: >>> >>> Expense: tax credit $2 >>> >>> Dividend (franked): Dividend reinvestment account $10 >>> >>> Buy: stock purchase: 1 unit $8, total buy $8 >>> >>> Total dividend income $12 >>> >>> Cost of share(s) $8 (normally from that dividend reinvestment account) >>> >>> (but now I'm $2 unbalanced) >>> >>> How do I account for the $2 that has now 'vanished'. With my other >>> companies, this amount gets put into an account, and I get to apply >>> it to the next dividend. But with this company, they don't do that, >>> the amount is simply 'gone'. >>> >>> Hope that makes sense, any ideas most appreciated, >>> >>> >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> - >>> 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 >> - >> 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can I export a list of vendors and customers?
> Date: Fri, 18 Nov 2022 18:11:15 + > From: "Dr. David Kirkby" > To: GNU Cash User > Subject: [GNC] Can I export a list of vendors and customers? > Message-ID: > > Content-Type: text/plain; charset="UTF-8" > > Is it possible to export the customers as a .csv file in a database, and > also I'd like to export the vendors. There are no transactions with these > yet. > > Dr David Kirkby Ph.D > Email: drkir...@kirkbymicrowave.co.uk Web: > https://www.kirkbymicrowave.co.uk/ > Kirkby Microwave Ltd (Tel 01621-680100 / +44 1621-680100) > Stokes Hall Lodge, Burnham Rd, Chelmsford, Essex, CM3 6DT. > Hi David, I’m not at my PC now but you can run the (from memory) Customer Summary or Vendor Summary reports, then (like all GnuCash reports), use control-A to select all the data, then paste into a spreadsheet. Regards, Chris Good ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] New IngAusOfxFix V2.02 release
Hi, There is a new version of my IngAusOfxFix utility which is for easily modifying an OFX or QFX file from ING Australia bank (and some others) so that it can be imported into GnuCash. V2.02 fixes a crash in IngAusOfxFix when the input file contains non-ascii UTF-8 characters. Specifically, it was crashing when a U+2019 (Right Single Quotation Mark) was read, with error message: IOException: java.nio.charset.MalformedInputException: Input length = 1. This version also changes ENCODING:USASCII to ENCODING:UTF-8 and CHARSET:1252 to ENCODING:NONE as I believe this best allows the libofx routines that GnuCash uses, to import UTF-8 characters. Note that (from my limited testing) non-ascii UTF-8 characters are imported correctly into GnuCash in Linux, but some are dropped or incorrectly translated when importing into GnuCash in MS Windows. The new version 2.02 is available for Linux https://github.com/goodvibes2/IngAusOfxFixLinux/releases and Windows https://github.com/goodvibes2/IngAusOfxFixWin/releases For documentation, see Linux https://github.com/goodvibes2/IngAusOfxFixLinux Windows https://github.com/goodvibes2/IngAusOfxFixWin Just to document, my testing show that in MS Windows 11 GnuCash 4.11, using ENCODING:UTF-8 and ENCODING:NONE, the following characters are dropped: U+2019 Right Single Quotation Mark U+20AC Euro and the following characters are (wrongly?) translated: U+2076 Superscript 6 imports as b (lowercase B) U+00A3 Pound imports as , (comma). The above 4 characters were all imported correctly in Linux. So far, the only non-ascii UTF-8 character I have heard of in an ofx file from ING Australia, is U+2019 (Right Single Quotation Mark). Regards, Chris Good ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to bulk import about 130 Securities entries?
Message: 1 Date: Sun, 14 Aug 2022 19:19:44 -0700 From: Jim DeLaHunt To: gnucash-user@gnucash.org Subject: Re: [GNC] How to bulk import about 130 Securities entries? Message-ID: <137f3e3b-148f-feb2-9950-d7fcb32f6...@jdlh.com> Content-Type: text/plain; charset=UTF-8; format=flowed Kalpesh: Thank you for the advice. > ?see if your broker provides transactions in OFX format instead of CSV. But remember, I am trying to import Securities, not transactions. I am trying to automate what is done manually in Tools -- Security Editor, and pressing the Add button. Best regards, ?Jim DeLaHunt On 2022-08-14 17:34, Kalpesh Patel wrote: > Jim, > > Not sure if anyone has mentioned or not but see if your broker > provides transactions in OFX format instead of CSV. With CSV I imagine > that you will have to perform some pre-processing before importing into GNC. > > You will have much better success in minimizing import clicks and > errors with importation. Hi Jim, Just to hopefully add a little to what Kalpesh said... There is code in the ofx import to handle creating securities which is done before an investment transaction if the security (commodity) does not exist and Preference, Import, "Automatically create new commodities" is ticked. I have never used it but maybe some-one else can supply an example ofx file. I lean towards using a key stroke scripter but I just want to make you aware of this possibility. I've had a quick look at the code and it seems to me it may ask you for some extra info (that is not supplied by the ofx file) and you may well end up having to later correct or supplement the security details anyway. The ofx spec can be downloaded from https://financialdataexchange.org/FDX/About/OFX-Work-Group.aspx after clicking on "The Spec" at the top of the page. All my ofx files are version 1.0.2. Regards, Chris Good ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Request for two new features in GnuCash
> Message: 3 > Date: Sun, 7 Aug 2022 08:47:14 -0700 > From: Stan Brown > To: gnucash-user@gnucash.org > Subject: Re: [GNC] Request for two new features in GnuCash > Message-ID: <95206b08-a037-d3ee-ed88-21fac56d1...@fastmail.fm> > Content-Type: text/plain; charset=UTF-8 > … > Unlike most Windows programs, GC doesn't show you the location of each > file, only its name. (At least that's true in the version I'm running.) > That's why it's important to give the data files different names even if > they're in different folders . > > Stan Brown > Tehachapi, CA, USA > https://BrownMath.com Hi Stan, I definitely agree each GnuCash book should have a different name to reduce confusion. Recent versions of GnuCash show the full location in the status bar (bottom left) when the mouse pointer is over a file in the “File” menu. Regards, Chris Good ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Third party OFX/CVS providers
From: Tom Browder Sent: Sunday, 7 August 2022 12:37 AM To: Chris Good Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Third party OFX/CVS providers On Sat, Aug 6, 2022 at 08:51 Chris Good mailto:goodchri...@gmail.com> > wrote: .., Can you copy the text out of the pdf statement? Getting "organized" text programmatically out of PDF is a giant pain. My current approach is almost completely programmatic. BTW, Raku is the "sister" language of Perl, and it is a "scripting" language. Raku can also use Perl modules so I can use Finance::Quote with it if need be. But, until I can get the bank data working, I won't be needing it. Thanks, Chris. -Tom Hi Tom, I was actually suggesting you just highlight the transactions in the pdf statement and copy/paste them into a spreadsheet or text file before using a scripting language to reformat them but if you can programmatically extract the text that would be better long term. I notice with my PDF statement that (free) Adobe Acrobat DC no longer allows me to select text (as they want me to pay for a fancy tool - BOO) but if you send the pdf to Edge or Chrome you can select just the transaction text. Thanks for the info re Raku. Finance::Quote is just for getting stock prices from websites (usually) so not useful for this task. Are you sure you cannot export transactions from your bank? All mine do although sometimes it is hard to find. Regards, Chris Good ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Third party OFX/CVS providers
> Message: 5 > Date: Fri, 5 Aug 2022 19:47:45 -0500 > From: Tom Browder > To: Gnucash Users > Subject: Re: [GNC] Third party OFX/CVS providers > Message-ID: > > Content-Type: text/plain; charset="UTF-8" > >> On Wed, Aug 3, 2022 at 17:39 Tom Browder wrote: >> >> My current bank (US, Hancock Whitney) unfortunately does not provide >> account data in a digital format other than monthly PDF statements for >> personal accounts. I know third-party programs, such as YNAB (ynab.com), >> can get access my bank while I can't, but I don't want the baggage that >> comes with it. >> > > I changed my mind. I now have an YNAB account and found that is has a > well-documented API. Not only that, I was able to link it successfully to > my two banks and access my checking, savings, and credit card transactions! > It might be possible to use the API to periodically download bank and > credit card transactions into YNAB's standard JSON format, then convert > that into the OFX format, and then upload the OFX into GnuCash. > > I'm proceeding on the project with the hope of success. If anyone is > interested in following it, the Raku (formerly Perl 6, see https://raku.org) > module skeleton is on my Github repo now at > https://github.com/tbrowder/API-YNAB.git. (Note I may soon change the title > to something like YNAB2OFX or YNAB-OFX--suggestions are very welcome.) > > The downside, assuming I have success, is that YNAB has a subscription fee > of about $15 per month plus tax (cancel any time) or $100 plus tax a year, > sums well worth it if I can get a periodic good OFX-to-GnuCash import. > > Best regards, > > -Tom > Hi Tom, Can you copy the text out of the pdf statement? If so, you could probably write a spreadsheet macro to create a csv, ofx or qif file to import. Alternatively, if you are on Linux, use some scripting language like Perl or awk. If you use Finance::Quote to import market prices, you already have Perl installed. Regards, Chris Good ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Backup files in another folder ? solution for Windows
Message: 2 > Date: Fri, 05 Aug 2022 00:47:05 +0200 > From: GNC mailinglist > To: gnucash-user@gnucash.org > Subject: [GNC] Backup files in another folder ? solution for Windows > Message-ID: <875471b7354140d490ddd6c5dd291...@grupawp.pl> > Content-Type: text/plain; charset=UTF-8 > > Hi,Im new to GnuCash but, yep, I was disappointed by the multiple > backup and log files cluttering the directory where the main budget file is > stored. Ive searched and found out nobody even made a workaround. So I > wrote a Powershell (Windows) script watching folder for new files and moving > them to another folder. Take a look at ? github.com > https://github.com/Kaligula0/FolderWatcher ?. The file has an explanation > but feel free to comment here or file a bug there.Best regards, Char > Hi Char, In my humble opinion, If you put each GnuCash book in its own directory, and set the GnuCash preferences to automatically remove older backups and logs, there is no need to move them. BTW, you may be interested in my utility for encrypting and compressing most of the files you need to backup a GnuCash book to an off site cloud storage folder (I.e. Dropbox, OneDrive, Google drive or iCloud) called BackupGnuCash: See https://wiki.gnucash.org/wiki/Published_tools. You do have to be reasonably computer proficient to install my utility. Also there is a lot of backup info in https://wiki.gnucash.org/wiki/Backup Regards, Chris Good ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] questions on 4.1
Hi David, In 3.9, it was changed so that changing 1 split for the bank account (or it’s subaccounts) changed all splits for the bank account (and it’s subaccounts) to the new status, rather than toggling the status of the other splits. Toggling means: c to n and n to c. In 3.11 it was changed so that other splits are NOT modified so that the status of each split can be individually maintained in the reconcile window. Regards, Chris Good From: David Carlson Sent: Monday, 13 June 2022 11:59 AM To: Chris Good Cc: Gnucash Users ; Top Cat Subject: Re: [GNC] questions on 4.1 Chris, Thank you for your input. However, your reference to a bug that was created in release 3.9 and reverted in 3.11 may not be identical to the behavior that Top Cat saw in release 3.7 which seems to be different in release 4.1. Is it possible that the reversion in 3.11 did not exactly return to the behavior of releases prior to release 3.9? If so, which is correct or at least preferable? On Sun, Jun 12, 2022, 8:21 PM Chris Good mailto:goodchri...@gmail.com> > wrote: From: gnucash-user mailto:gmail@gnucash.org> <mailto:gmail@gnucash.org <mailto:gmail@gnucash.org> > <mailto:gnucash-user-bounces+gylemc <mailto:gnucash-user-bounces%2Bgylemc> <mailto:gnucash-user-bounces%2Bgylemc <mailto:gnucash-user-bounces%252Bgylemc> > =gmail@gnucash.org <mailto:gmail@gnucash.org> <mailto:gmail@gnucash.org <mailto:gmail@gnucash.org> > > > on behalf of Top Cat mailto:t...@fractalcat.io> <mailto:t...@fractalcat.io <mailto:t...@fractalcat.io> > <mailto:t...@fractalcat.io <mailto:t...@fractalcat.io> <mailto:t...@fractalcat.io <mailto:t...@fractalcat.io> > > > Sent: Saturday, June 11, 2022 12:44 PM To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> <mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > <mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> <mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > > mailto:gnucash-user@gnucash.org> <mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > <mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> <mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > > > Subject: [GNC] questions on 4.1 I have been using gnucash since 2.x with a MySQL database I recently build a new machine and updated to 4.1, and have run into several issues 1. On the accounts page, I can no longer show the account numbers, or sort by them 2. On reconciliations, paired transactions (like transfers from one subaccount to another) no longer clear "both sides" when one is checked - it requires manually marking both sides separately. Is this correct behavior? Are there settings I am missing? do I need to reinstall/save and restore data? Any help would be appreciated ___ Hi Top Cat, Re 2.: This behaviour changed in 3.9. and again in 3.11 as detailed in Bug 797648 https://bugs.gnucash.org/show_bug.cgi?id=797648. BTW, The changes in each release are listed at https://www.gnucash.org/news.phtml. Regards, Chris Good ___ gnucash-user mailing list gnucash-user@gnucash.org <mailto: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] questions on 4.1
From: gnucash-user mailto:gmail@gnucash.org> <mailto:gnucash-user-bounces+gylemc <mailto:gnucash-user-bounces%2Bgylemc> =gmail@gnucash.org <mailto:gmail@gnucash.org> > > on behalf of Top Cat mailto:t...@fractalcat.io> <mailto:t...@fractalcat.io <mailto:t...@fractalcat.io> > > Sent: Saturday, June 11, 2022 12:44 PM To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> <mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > mailto:gnucash-user@gnucash.org> <mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > > Subject: [GNC] questions on 4.1 I have been using gnucash since 2.x with a MySQL database I recently build a new machine and updated to 4.1, and have run into several issues 1. On the accounts page, I can no longer show the account numbers, or sort by them 2. On reconciliations, paired transactions (like transfers from one subaccount to another) no longer clear "both sides" when one is checked - it requires manually marking both sides separately. Is this correct behavior? Are there settings I am missing? do I need to reinstall/save and restore data? Any help would be appreciated ___ Hi Top Cat, Re 2.: This behaviour changed in 3.9. and again in 3.11 as detailed in Bug 797648 https://bugs.gnucash.org/show_bug.cgi?id=797648. BTW, The changes in each release are listed at https://www.gnucash.org/news.phtml. Regards, Chris Good ___ 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] GnuCash Backup
Message: 1 Date: Tue, 22 Feb 2022 10:49:42 -0700 From: Mario Nigrovic To: gnucash-user@gnucash.org Subject: [GNC] (no subject) Message-ID: Content-Type: text/plain; charset="UTF-8" Many years ago, I had used gnucash, and was pretty happy with it. I was very careful to make regular backups of my data, and so, when my disk inevitably crashed, I was not too worried. However, I was mortified to discover that, although all my transaction data had been saved, all my custom reports were lost, as they had been stored separately in a secret undisclosed location, I later discovered to be elsewhere in my home directory. Recently, I have decided to try again to use gnucash, but I would like very much to ensure ALL my data is backed up. So I hit upon the idea of running the tool under a custom value of $HOME, but I was then shocked to discover that even with this method, gnucash was able to remember previous locations of my database file, which suggests that the tool is also using some kind of other mechanism to save historical data, and that makes me very nervous about actually being able to do proper backups of everything related to the tool. Doing some sleuthing using strace, I was able to find the previous database location delivered through some socket connection, and that really scares me, since it is now possible critical data is stored via some other Linux service and I will have no way to trace out where this may be to avoid future nasty surprises. I have not seen any documentation about backup strategies other than the aromatic saving of previous data files, yet I do see that there was data being stored at least in ~/.local, so I'm hoping someone on this list may be able to point me to some more thorough discussion of ALL the places user data from gnucash may be stored. Thanks for your help! -- Mario Hi Mario, Backups are discussed in https://wiki.gnucash.org/wiki/Backup You may also like the tool I wrote for backing up (just about) all the possible files that hold GnuCash configuration: Linux: https://github.com/goodvibes2/BackupGnuCashLinux Windows: https://github.com/goodvibes2/BackupGnuCashWin I know this is not the simplest to understand but that's how it is. If you cannot figure out what to do, just follow the instructions for Version 2.x in java 11 and using the Precompiled Binaries. Regards, Chris Good ___ 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] Possible to display two account registers on screen?
Message: 10 Date: Thu, 03 Feb 2022 17:17:03 -0500 From: Dan Black To: , , Liz Subject: Re: [GNC] Possible to display two account registers on screen? Message-ID: Content-Type: text/plain; format=flowed; charset="UTF-8" If the only thing in the second account is your messed up import, you can delete that account and have it put the transactions in the original account. Then remove the duplicates. Dan On February 3, 2022 5:08:53 PM Liz wrote: > On Thu, 3 Feb 2022 17:02:22 -0500 > Art Chimes wrote: > >> I'm trying to clean up some issues with an import-gone-bad which left >> me with two accounts for the same mutual fund. There are, I think, >> some duplicate transactions and others that appear in only one of the >> two accounts, and I want to consolidate this. It will simplify matters >> and speed up the process if I can see both accounts side by side. I >> know I can print up a transaction report, and use that as a reference, >> but is it possible to display the two accounts ? GnuFund GNUFX and >> GnuFund GNUCX ? on screen? >> >> If not, is it a feature GnuCash should have or is it just me? >> >> Thank you > > You can open multiple copies of a file. > You will get a warning dialogue. > At that point, choose "read only" for the second one. > > Then you are reasonably safe, read from one, edit the other. > > Liz Hi Art, This is already available. Use the options under the Windows menu. New Window: open a new window and from there you can open the register you want Or New Window with Page: will open the current tab in a new window Regards, Chris Good ___ 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] Proper Way to Record Capital Gains/Losses?
Message: 9 Date: Wed, 5 Jan 2022 09:16:50 -0500 From: Dustin Henning To: "gnucash-user@gnucash.org" Subject: [GNC] Proper Way to Record Capital Gains/Losses? Message-ID: Content-Type: text/plain; charset=UTF-8; format=flowed Up until about 6 months ago, I was running an old 2.x version of GnuCash, but when I upgraded from Win7 to MacOS Big Sur, I also upgraded GnuCash, and I'm currently running 4.9.? Yesterday, I went to record my first capital gain/loss transaction since that move, and I found that the method I am using no longer works.? I thought I started using the method I was previously using based on documentation and/or advice from here, but that may not be the case. Historically, I have posted two separate transactions in the stock/fund account. The first transaction was a normal transaction removing the number of shares sold from the stock/fund account and adding the amount of currency received to the brokerage account, so in a theoretical transaction selling 10 shares @ $10 with a $1 commission, the split would look like this (using - for null fields): Account ?? Shares??? Price??? Buy??? Sell Stock? 10??? ??? 9.9?? ?? -? 99 Brokerage? -??? -??? 99 - The second transaction was only to tie the capital gain to the stock/fund account, and it would look like this for a $10 short term gain (again using - for null fields): Account Shares??? Price??? Buy??? Sell Stock? - -??? 10 - STCG?? - -??? -? 10 The buy/sell columns would be reversed for a loss.? IIRC, all I had to do in order to enter this transaction in 2.x was remove a default 1 from one of the columns, but there is no longer a default 1 to remove and the stock/fund side of the split always calculates for the Shares and Price columns in this scenario (I don't even see a way to bypass that when entering from the relevant capital gain/loss account).? As I can't figure out a way to enter a transaction like this in 4.9, I assume the method I have used historically is incorrect.? I noticed that the Shares and Price columns don't calculate on both sides of the split if I accidentally use the same account on both sides, so I thought maybe I could merge the two transactions moving forward, but it seems those columns do calculate on both split entries for the stock/fund account when I try to set it up as a four way split. The good news is my old transactions don't break when I look at them, but I need a path forward regardless of whether or not I need to adjust past transactions.? Assuming the behavior I'm dealing with isn't a bug (and I've been doing this wrong), could someone advise on how I should do this moving forward or point me at the correct documentation? -- Dustin, I think this is the same problem as reported in https://bugs.gnucash.org/show_bug.cgi?id=798406 : 4.9 inappropriately converts dollars to shares at $1 a piece in pure cash transactions Regards, Chris Good ___ 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] A repository for user-contributed files
Message: 5 Date: Sun, 2 Jan 2022 16:48:31 -0600 From: David Carlson To: brad Cc: Gnucash Users Subject: Re: [GNC] A repository for user-contributed files Message-ID: Content-Type: text/plain; charset="UTF-8" No page links to that page. I wonder how I found it myself. https://wiki.gnucash.org/wiki/Published_tools On Sun, Jan 2, 2022 at 4:33 PM brad wrote: > Is that page linked to on another wiki page? Perhaps it doesn't get > attention because no one knows it is there > > On 12/31/21 08:19, David Carlson wrote: > > There is a page in the GnuCash WIKI for user "Tool" submissions. It > > does not get as much attention as it deserves. It is located here: > > < https://wiki.gnucash.org/wiki/Published_tools> > > > > On Fri, Dec 31, 2021 at 5:16 AM Dr. David Kirkby < > > drkir...@kirkbymicrowave.co.uk> wrote: > > > >> On Thu, 30 Dec 2021 at 05:59, Adrien Monteleone < > >> adrien.montele...@lusfiber.net> wrote: > >> > >>> Thanks for the link, and I'll take a look, but I am curious... > >>> > >>> Why not just post that info on the Wiki in that place? > >>> > >>> What happens if your company site goes down/dark? > >>> > >>> Do the various tips not still apply to GnuCash which has no > >>> relation to your company? > >>> > >>> Are you opposed to sharing your tips and tricks with the broader > GnuCash > >>> community? > >>> > >>> Do you mind if they are posted on the GnuCash wiki directly? > >>> > >>> Regards, > >>> Adrien > >> > >> I think if you take a look, you will realise that the intension was > >> to share them, requesting others to take backups, in case I die and > >> the website goes down. So I was obviously not expecting them to be > >> specific > to > >> my company, the fact I was requesting others to take backups. > >> > >> Sending an email to this list, adding an entry to the Wiki were all > >> mentioned. > >> > >> When I asked about a repository, I was told one didn?t exist. > >> Someone suggested GIT, someone else mentioned the ownership of git. > >> > >> I was just offering some storage area if it was wanted. > >> > >> Dave > >> > >> > >> -- > >> Dr. David Kirkby, > >> Kirkby Microwave Ltd, > >> drkir...@kirkbymicrowave.co.uk > >> https://www.kirkbymicrowave.co.uk/ > >> Telephone 01621-680100./ +44 1621 680100 > >> > >> Registered in England & Wales, company number 08914892. > >> Registered office: > >> Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 > >> 6DT, > United > >> Kingdom Hi David(s), If you go to any wiki page, on the left is a link: What links here That shows that Published_tools is linked to from 4 other wiki pages. Regards, Chris Good *Gentle Reminder to everybody* Take pity on those who use digest emails. Please delete all text from other messages in replies to GnuCash digest emails. ___ 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] Flatpak/Flatseal Gnucash fails to launch
Message: 9 Date: Tue, 30 Nov 2021 07:53:49 -0500 From: Elmar mailto:etsc...@gmail.com> > To: "Fross, Michael" mailto:mich...@fross.org> > Cc: Geert Janssens mailto:geert.gnuc...@kobaltwit.be> >, gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> Subject: Re: [GNC] Flatpak/Flatseal Gnucash fails to launch Message-ID: <9c6e9d70-148e-030a-4d41-6659998a3...@gmail.com <mailto:9c6e9d70-148e-030a-4d41-6659998a3...@gmail.com> > Content-Type: text/plain; charset=utf-8; format=flowed On 11/30/21 7:51 AM, Fross, Michael wrote: > Don?t forget the ?run? command. In your paste it was missing.? See > Geert?s command. > Oops - here's better.? I got messed up first with flaptak, instead of flatpak :) > ets@Shinobi ~ $ flatpak run org.gnucash.GnuCash > error: While opening repository /home/ets/.local/share/flatpak/repo: > opening repo: opendir(objects): No such file or directory Hi Elmar, Flatpak works fine for me in my Mint 20.2 VM. Although I don’t have flatseal (and I don’t really need it). I searched for your error message and found several possible solutions. This seems the most likely to help: https://github.com/flatpak/flatpak/issues/3585#issuecomment-621545087 : Looks like your repo config was somehow deleted. If you don't care about saving the apps in your user installation you can just do rm -rf ~/.local/share/flatpak. Otherwise you can do echo -e "[core]\nrepo_version=1\nmode=bare-user-only" > ~/.local/share/flatpak/repo/config but you'll also have to re-add any remotes you had configured (e.g. flathub). Note I have just updated the Installation section of https://wiki.gnucash.org/wiki/Flatpak as I have discovered flatpak keeps both ‘user’ and ‘system’ remotes, so when you add flathub as a remote, you need to use the appropriate command to add a ‘user’ or ‘system’ remote depending on if you want to make gnucash a ‘user’ or ‘system’ app. User flatpak app’s can only be run by the user that installs it, while system app’s can be run by any user. Regards, Chris Good ___ 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] How do you do this - differentiate scheduled transaction versus no scheduled one
Hi, A suggestion I’ve followed since I saw it on this list years ago, is to put SCHED in the Num field. I used to remove it after I have ensured it was correct, but now I leave it there permanently to help me understand where it came from if there is any confusion later on. Regards, Chris Good > > Message: 1 > Date: Fri, 15 Oct 2021 09:31:57 +0100 > From: "Maf. King" > To: 'Gnucash Users' > Cc: Kalpesh Patel > Subject: Re: [GNC] How do you do this - differentiate scheduled >transaction versus no scheduled one > Message-ID: <1763186.QZUTf85G27@janus> > Content-Type: text/plain; charset="UTF-8" > >> On Thursday, 14 October 2021 15:19:03 BST Kalpesh Patel wrote: >> >> >> 1 - My habits when it comes to payments for example credit card, mortgage, >> other bills, etc. is to scheduled it out in advance from the appropriate >> institutions that hold my bank accounts, such as checking, savings, etc. at >> a future date but within due date. In the sub-account register for the bank >> account, I like to some-how want to be able to differentiate that I have >> already scheduled up a transaction versus other transaction that is needed >> to be scheduled out. > > > Hi, > > If I careate a transaction in GC (eg to pay a credit card bill) before I have > it set up with my bank, I use the letters "NSUY" in the transaction notes/ > memo space (short for Not Set Up Yet) to remind me to create with the bank. > > then those letters can be edited out at some point when I have told the bank > to pay. I guess you could use the Num field in the same way. > > 0.02 > Maf. ___ 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] Reconciliation Changes
Hi David, I don’t believe the way the transactions are loaded into the reconcile screen has changed. I remember there was a problem with the calculated reconciled balance some time ago which was something to do with the reconciled date, but I don’t think that has anything to do with Lisa’s problem. Re the user who is having problems with postponing a reconciliation. It has yet to be proven this isn’t a user error. I would think that if there was a problem like that, many people would have reported it by now. The code that was reverted for 3.11 was to do with propagating the reconcile status to other splits. It is very unlikely this has anything to do with postponing a reconciliation. Regards, Chris Good From: David Carlson Sent: Friday, 15 October 2021 5:27 PM To: Chris Good Cc: Derek Atkins ; D. ; Steve Welch via gnucash-user Subject: Re: [GNC] Reconciliation Changes For completeness I should have mentioned that for accounts which have sub-accounts like those that envelope budgeters will probably have, the user should view the account in a 'with sub-accounts view' to see everything that is happening in the 'with sub-acconts' reconciliation window. On Fri, Oct 15, 2021 at 12:57 AM David Carlson mailto:david.carlson@gmail.com> > wrote: No, Chris. In release 3.8 and earlier when the user first clicks on the Reconcile icon and the pop-up appears to set the date, balance, etc., then clicks OK, the Reconcile window opens with every transaction that is dated before the reconciliation date and marked "c" in the Reconcile box is automatically checked to be reconciled. Thus the user normally will only need to check or uncheck any transactions that do not match the bank statement. If the user was importing transactions so they were marked "c" when they were imported or marking existing transactions "c" if they think they saw them in their smartphone banking app, those transactions are already applied to the target balance calculation and do not need to be manually checked.for reconciliation. That is how it worked in release 3.8 and earlier. There is another thread that apparently indicates that in the current release if some transactions were manually marked as reconciled and the user chooses Postpone, when he returns he will find his previous markings lost. In release 3.8 those manually marked transactions will still be marked when returning to the reconciliation. It appears that the code was not reverted exactly to the way it was in release 3.8. On Thu, Oct 14, 2021 at 10:45 PM Chris Good mailto:goodchri...@gmail.com> > wrote: Hi David (Carlson), Not sure what you mean by “automatic marking that happens when the reconciliation process is initiated”? Perhaps you mean the marking of transactions as cleared when they are imported? Regards, Chris Good From: David Carlson mailto:david.carlson@gmail.com> > Sent: Friday, 15 October 2021 3:00 AM To: Derek Atkins mailto:de...@ihtfp.com> > Cc: D. mailto:sunfis...@yahoo.com> >; Steve Welch via gnucash-user mailto:gnucash-user@gnucash.org> >; Chris Good mailto:goodchri...@gmail.com> > Subject: Re: [GNC] Reconciliation Changes I wonder if there is some confusion here between manually marking (or un-marking) account and sub-account transactions as reconciled (or not) vs the automatic marking that happens when the reconciliation process is initiated. The purpose of the pause before committing the reconciliation is to allow the user to uncheck the items that have not cleared to bring the cleared balance to match the outside bank statement or the user's desired result. I hope that GnuCash still pre-marks all un-reconciled account transactions (and sub-account transactions if they exist and the appropriate box is checked) dated before the reconciliation date when the reconciliation is started, as manually marking possibly hundreds of transactions at the beginning of the process would definitely be a pain. I do agree that each sub-account transaction line should be separately manually changeable. Because I am still running release 3.8 I cannot observe for myself how it works now, but release 3.8 does at least pre-mark all un-reconciled account transactions before the reconciliation date. I do not have sub-accounts in my data. On Thu, Oct 14, 2021 at 6:53 AM Derek Atkins mailto:de...@ihtfp.com> > wrote: Chris, Lisa, Yes, I agree with David here. It is absolutely quite common (and for DECADES has been the suggested way to do "envelope budgeting" in GnuCash) -- to have subaccounts of your Bank (or other Asset) account for your budget items. I realize that I did instigate your change in PR-713, however to reiterate my original message, "I do not agree with this change AND think it will introduce another bug" (emphasis added here). I still think the origin
Re: [GNC] Reconciliation Changes
Hi David (Carlson), Not sure what you mean by “automatic marking that happens when the reconciliation process is initiated”? Perhaps you mean the marking of transactions as cleared when they are imported? Regards, Chris Good From: David Carlson Sent: Friday, 15 October 2021 3:00 AM To: Derek Atkins Cc: D. ; Steve Welch via gnucash-user ; Chris Good Subject: Re: [GNC] Reconciliation Changes I wonder if there is some confusion here between manually marking (or un-marking) account and sub-account transactions as reconciled (or not) vs the automatic marking that happens when the reconciliation process is initiated. The purpose of the pause before committing the reconciliation is to allow the user to uncheck the items that have not cleared to bring the cleared balance to match the outside bank statement or the user's desired result. I hope that GnuCash still pre-marks all un-reconciled account transactions (and sub-account transactions if they exist and the appropriate box is checked) dated before the reconciliation date when the reconciliation is started, as manually marking possibly hundreds of transactions at the beginning of the process would definitely be a pain. I do agree that each sub-account transaction line should be separately manually changeable. Because I am still running release 3.8 I cannot observe for myself how it works now, but release 3.8 does at least pre-mark all un-reconciled account transactions before the reconciliation date. I do not have sub-accounts in my data. On Thu, Oct 14, 2021 at 6:53 AM Derek Atkins mailto:de...@ihtfp.com> > wrote: Chris, Lisa, Yes, I agree with David here. It is absolutely quite common (and for DECADES has been the suggested way to do "envelope budgeting" in GnuCash) -- to have subaccounts of your Bank (or other Asset) account for your budget items. I realize that I did instigate your change in PR-713, however to reiterate my original message, "I do not agree with this change AND think it will introduce another bug" (emphasis added here). I still think the original change you made in PR-670 was wrong. But regardless, here we are now. In your particular case in bug #797648 I (still) don't understand why this is a single transaction. If you are using two payment methods to two expense accounts, that to me is two transactions. They could be processed at different times, post at different times, and they are absolutely for different items. I don't even know how you can place such an order (well, except, I guess, if you're at a restaurant and order separate checks -- but even in that case I don't see why you need to enter it as a single transaction). The use-case of envelope budgeting is definitely more common than your use case, so we should definitely support that. Perhaps I can propose some additional logic: If *ALL* the splits in a transaction are within the Reconciliation account (sub)tree, then when you click on one, it should be as if you click on all of them. That would help Lisa's use-case of moving money from one envelope into another, or from the main account into an envelope. However, this (new?) logic will not help in the case of a purchase where you're buying things from different envelope budgets in a single transaction (e.g. you're buying toothpaste and gas in the same transaction). I'm not sure how to get this and Chris' desire (and my desire) together, because I feel they are all mutually exclusive processes. I will just point out that in the reconcile window, all the splits of the same transaction will be next to each other, so if you're buying toothpaste and gas together, the splits for Assets:Bank:Checking:Toothpaste and Assets:Bank:Checking:Gas will be next to each other and should be easy enough to check manually (because they would both be credits in the same transaction). -derek On Thu, October 14, 2021 7:26 am, D. via gnucash-user wrote: > Chris, > > I believe she's implementing envelope budgeting > (https://www.thebalance.com/what-is-envelope-budgeting-1293682) using sub > accounts. A fair number of users of Gnucash do this, which has been > discussed on the lists over the years. > > David T. > > > Original Message > From: Chris Good mailto:goodchri...@gmail.com> > > Sent: Thu Oct 14 03:11:57 EDT 2021 > To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > Subject: Re: [GNC] Reconciliation Changes > > Hi Lisa, > > This change was done under https://bugs.gnucash.org/show_bug.cgi?id=797648 > for reasons explained in the bug. > The first fix went live in 3.9 which forced all splits in a transaction to > the new selected reconciled state when one of them was changed, rather > than > just toggling the reconciliation status of all the splits for the account > being reconciled. > This was deemed incorrect, so a change was
Re: [GNC] Reconciliation Changes
Hi David T, Derek & Lisa, David, Thanks for pointing out that Lisa is doing "envelope budgeting". I have seen various references to that in this email list over the years but as I don't do any budgeting, I have not paid much attention to it. I can find no reference to that in the GnuCash guide or help manuals, perhaps as it seems to be a common method of budgeting, and as GnuCash is so flexible, it is assumed to be available and already familiar to accountants. Derek, "Forcing all splits of a transaction to have the same reconcile status is WRONG." I agree. That's why my PR 713 https://github.com/Gnucash/gnucash/pull/713 removes the functionality of automatically doing anything to the reconciliation status of other splits in the transaction for the account being reconciled (or it's subaccounts) when you change the status of a particular split. Re my example in https://bugs.gnucash.org/show_bug.cgi?id=797648#c0 : I end up with a transaction looking like: Account Reconciled --- -- Expenses:Misc:Person1n Expenses:Misc:Person2n Liabilities:CrCard:Person1 c Liabilities:CrCard:Person2 n Because after importing a single transaction which is payable by both Person1 and Person2 like: Account Reconciled ----- Expenses:Miscn Liabilities:CrCard c I then split the expenses split into Person1 and Person2 so I can track the expenses for each person, and then split the CrCard split into subaccounts for each person so then the balance of the person subaccounts in the CrCard at month end (after subtracting credit card payments) shows how much each person has spent during the month. Because I also split each savings account split into each person i.e. Assets:Current Assets:Bank Acct1:Person1 Assets:Current Assets:Bank Acct1:Person2 When I pay the credit card, I do a transfer from Assets:Current Assets:Bank Acct1:Person1 to Liabilities:CrCard:Person1 And Assets:Current Assets:Bank Acct1:Person2 to Liabilities:CrCard:Person2 This way I know how much of the savings account and the credit card is attributable to each person at any point in time. I end up with 1 of the CrCard splits being Cleared and the other Not Reconciled because I forget to change the split to Cleared when I create it. I will note that I am not a control freak (as far as I know) but my wife, after a bad experience with a previous partner, wanted me to do this so she could track her own share of the savings and credit card accounts. Possibly there are many more people doing envelope budgeting that what I'm doing. The only way I can think to keep both camps happy is to have a reconciliation option say "Change all splits together" so both functionalities are catered for. I'll look at that if it gets a reasonable level of support... or somebody has a better option? Regards, Chris Good -Original Message- From: Derek Atkins Sent: Thursday, 14 October 2021 10:53 PM To: D. Cc: Chris Good ; Steve Welch via gnucash-user Subject: Re: [GNC] Reconciliation Changes Chris, Lisa, Yes, I agree with David here. It is absolutely quite common (and for DECADES has been the suggested way to do "envelope budgeting" in GnuCash) -- to have subaccounts of your Bank (or other Asset) account for your budget items. I realize that I did instigate your change in PR-713, however to reiterate my original message, "I do not agree with this change AND think it will introduce another bug" (emphasis added here). I still think the original change you made in PR-670 was wrong. But regardless, here we are now. In your particular case in bug #797648 I (still) don't understand why this is a single transaction. If you are using two payment methods to two expense accounts, that to me is two transactions. They could be processed at different times, post at different times, and they are absolutely for different items. I don't even know how you can place such an order (well, except, I guess, if you're at a restaurant and order separate checks -- but even in that case I don't see why you need to enter it as a single transaction). The use-case of envelope budgeting is definitely more common than your use case, so we should definitely support that. Perhaps I can propose some additional logic: If *ALL* the splits in a transaction are within the Reconciliation account (sub)tree, then when you click on one, it should be as if you click on all of them. That would help Lisa's use-case of moving money from one envelope into another, or from the main account into an envelope. However, this (new?) logic will not help in the case of a purchase where you're buying things from different envelope budgets in a single transaction (e.g. you're buying toothpaste and gas in the same transaction). I'm not sure how to get this
Re: [GNC] Reconciliation Changes
Hi Lisa, This change was done under https://bugs.gnucash.org/show_bug.cgi?id=797648 for reasons explained in the bug. The first fix went live in 3.9 which forced all splits in a transaction to the new selected reconciled state when one of them was changed, rather than just toggling the reconciliation status of all the splits for the account being reconciled. This was deemed incorrect, so a change was made in 3.11 where changing the reconciliation status of a split in a transaction had no effect of other splits in the transaction for the account being reconciled. I wouldn't recommend running an old version like 3.10. Never upgrading until you have to greatly increases your risk of falling foul of a security issue (or just a bug) that may have already been fixed. I don't upgrade immediately a new version is available, but I do after a little while so it is likely that any major problems with a new release will have been found and probably fixed. It seems unusual to create different subaccounts in a bank account for different types of expenses. I believe it is more usual to split your income and expenses into different income and expense accounts, and do your budgeting based on the totals of those accounts. Regards, Chris Good Message: 6 Date: Tue, 12 Oct 2021 20:31:44 -0700 From: Lisa Reynoso To: David Carlson Cc: DaveC49 , Gnucash Users Subject: Re: [GNC] Reconciliation Changes Message-ID: <916d45e4-a319-4ab9-bfb9-fd7a6557f...@gmail.com> Content-Type: text/plain; charset=utf-8 Well, my computer reformatted, so I had to start over. But in almost two decades, I started over several times, and this last time is the only time this problem occurred. I can?t imagine that had anything to do with it. I?m going to look at an old hard drive I saved from a couple computers back and see if I have an old installation file and see what it does if I do. Or what happens if I import old files from years back (if they are still there). I?ll let you know how it goes. Lisa Sent from my iPhone > On Oct 12, 2021, at 5:35 PM, David Carlson wrote: > > ? > Sub accounts under the same bank account are not the same as transfer s to outside accounts. > > If I recall correctly, they must be of the same type as the parent account. I think that should still work as before in reconciliations. Were you able to import your table of accounts from an old file or did you start over, possibly different somehow this time? > > > >> On Tue, Oct 12, 2021, 7:18 PM Lisa Reynoso wrote: >> Okay, first, I don?t know what version I had before. It was about 2 years ago that I downloaded it, and my hard drive was wiped, so I have no idea. >> >> Second, you completely misunderstood my problem. I understand the reconciliation process intricately; I?ve been using it for a decade and a half. I understand about clicking the ?include sub accounts? box; it?s the sub account feature that turned me on to the program, since I was doing that on paper as my mother did; a computer was so much faster, since it did most of the math for me. I like math, but it gets tedious entering numbers in a calculator. But I digress. >> >> There are two basic examples to illustrate. I have a checking account, divided into various sub accounts, such as gas, groceries, clothing, school bill, etc. When I deposit a paycheck, I split the deposit into various accounts. Likewise when i purchase both food and toothpaste at the grocery store; toothpaste doesn?t come from the food budget. When I want to reconcile the checking, I used to be able to check one of those splits and have them all highlight. So if I checked the toothpaste transaction, the grocery charge would check as well. Of course the expense account wouldn?t reconcile; I wasn?t referring to that. >> >> But the other example is when I transfer money within the checking account from one sub account to another. Like my original gas to groceries (or vice versa) analogy. In that case, when I would check the credit, the debit would check automatically as well, and the balance on the reconciliation would not change, because no money actually entered or left the checking. It was just moved around within it. Now I have to check one and then scroll down to find the other. I make several dozen of these transactions every month, and it is tedious to have to check them both. >> >> I downloaded version 4.4 when this problem first made itself felt. I downloaded 3.11 today, and it still doesn?t do what it used to. I have Windows 10; I don?t know if an earlier version will work or not. >> >> Lisa >> >> Sent from my iPhone >> >> > On Oct 12, 2021, at 2:09 PM, davidcousen...@gmail.com wrote: >> > >> > ?Lisa >> > >> > It may help if you can tell us what the previous version was and >> > which version you have now upgr
Re: [GNC] OFX Import with Investment Transactions
Hi Robin, +1 for Jean's comments. Re the crash after reverting to 4.7: This should not happen. The maintainers try hard to ensure you can always revert to a previous version, especially from a minor version upgrade. To revert to a previous major version, provision is made so you can always revert to the last minor revision of a previous major version. See https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgra de There were some problems with trading accounts fixed in 4.7, see https://bugs.gnucash.org/show_bug.cgi?id=798221 Do you use trading accounts? If that is not your problem, perhaps you could open a bug and provide a trace file (see https://wiki.gnucash.org/wiki/Tracefile or preferably a stacktrace. Regards, Chris Good Message: 5 Date: Sat, 2 Oct 2021 11:51:40 -0700 From: Jean L To: gnucash-user@gnucash.org Subject: Re: [GNC] OFX Import with Investment Transactions Message-ID: <08cf656d-09e4-c1a8-054b-51edf5f30...@gmail.com> Content-Type: text/plain; charset=utf-8; format=flowed Yes, there's a new behavior with OFX import. The match dialog shows up for each target account, so if you're importing securities the dialog will show up for each security. This could be a real annoyance if there are many different securities, so we may want to change that behavior. The new behavior was introduced to fix an issue when a single OFX file had transfers between accounts. I see two issues here: 1) The fact that the match dialog runs for each target account (see comment above) 2) The fact that some of your imported transactions were simply ignored. About 2): Did you try to continue with the import after the first matching dialog? Did it then go to the next securities? Or did you just abort thinking something was wrong (not expecting the new behavior of seeing the matching dialog for each security instead of all together as before) If that was not the case (i.e., you tried continuing but nothing else happened) one reason why this could happen is if the FITID used for the imported transactions were already present in the target account. This is new in the latest version: transactions that were previously imported are no longer shown the matching dialog. In your case this seems erroneous. So either it's a bug (i.e., the FITID of the imported transactions are NOT found in any of the transactions of the account you're imported into, so they should show) or it's a problem with the OFX data that the transactions seem to reuse existing FITIDs. The fact that things work normally when you import into a blank account would indicate that indeed, the FITID of the imported transactions already exist in your target account. SO, could you re-try importing with the latest version, but making sure you continue clicking OK for each match dialog? Does this work or not? If not, then we'll need to check whether the FITID of the new imported transactions somehow have been used before in the previously imported transactions. To see that, you'd need to pick one that was not imported (looking at the OFX file), get its FITID, and see in your account database (save it as an xml file so it can be looked at with a regular editor) whether that FITID exists. Jean On 10/2/2021 8:58 AM, Robin Chattopadhyay wrote: > Ubuntu 20.04 LTS (VMWare virtual machine in case that matters) > Gnucash 4.8 > libofx 0.9.15 > > I tried importing an OFX file from my 401K provider this morning and I got > a message box that said it had imported 2 transactions for a single > security in the file and there were no additional transactions to process. > This was incorrect as there were 18 new transactions across nine securities > (along with a number of other transactions that had already been imported > previously). > > I tried a number of things to resolve (after taking a backup, of course): > 1 - Tools > Import Map Editor and deleted all of the associations for this > file. When I re-imported, I was prompted to map each security in the file > to the correct account. No issues there. But when importing the OFX file > again, I had the same experience as described above > 2 - Created a blank file and attempted to import the file there. Through > the import process, I created new securities and new accounts, nothing > unexpected there. Then the generic transaction importer dialog popped up, > but with just the two transactions for the same security cited in the > original problem dialog. I imported those, clicked OK and then the generic > transaction importer dialog came up *again* but only with transactions for > a single, different security. I imported those and repeated the process for > each security with transactions in the file. Each time the generic > transaction importer dialog came up, it only had transactions for a single > security. This is definitely new behavior that I didn't see in 4.6. > Previously the
Re: [GNC] Capital gain with Return of Capital
Message: 10 Date: Mon, 20 Sep 2021 08:55:41 -0700 From: Fred Tydeman To: Jean-David Beyer Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Capital gain with Return of Capital Message-ID: Content-Type: text/plain; charset="utf-8" On Mon, Sep 20, 2021 at 8:26 AM Jean-David Beyer via gnucash-user < gnucash-user@gnucash.org> wrote: > > was return of capital. I have not yet learned how to enter a return of > > capital in GnuCash > > Do you not just subtract the capital returned from the cost basis? > Correct. Linux Gnucash Help Tutorial Investments Return of Capital This refers to a transaction where an investment returns capital to the investor and doesn't have any accounting implications other than reducing the cost basis. The number of shares held is not changed. A Return of Capital transaction can be entered in the stock register by entering the stock split with Shares 0 Price 0 Sell Return of Capital value The other side of the double entry would usually be a debit to the brokerage bank account. Attached is a screen shot of the account with the buy, rtn of cap, sell. The capital gain shown is what Quicken calculated (not Gnucash). -- next part -- A non-text attachment was scrubbed... Name: Screenshot from 2021-09-20 08-52-30.png Type: image/png Size: 83067 bytes Desc: not available URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210920/56e78e fd/attachment.png> Hi Fred, This is a known problem. Please see https://bugs.gnucash.org/show_bug.cgi?id=797166 Stock scrubbing does not handle Return of Capital Transactions I suggest instead of doing a Return of Capital, do 2 dummy transactions: 1. sell all the stock at the cost that was paid so there is no capital gain from this transaction 2. Buy the same qty at the new reduced cost (ie less capital returned) Then when you subsequently sell, scrubbing should work. Guide 9.7.2.8. Considerations: Says 5. The automatic capital gains calculations can handle straightforward buy, sell, and return of capital transactions but any transaction that affect the number of shares, even simple splits, will cause it to produce wrong answers so those cases must be handled manually. But I think this means: return of capital transactions (with a reduction in stock qty) are handled. Regards, Chris Good ___ 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] Financial Account Structure for Australian Shares and EFTs
Message: 7 Date: Fri, 27 Aug 2021 22:39:23 +1000 From: flywire To: Gnucash Users Subject: Re: [GNC] Financial Account Structure for Australian Shares and ETFs Message-ID: Content-Type: text/plain; charset="utf-8" Thanks Chris, that helps me understand it a bit more but a little differently. I see Franking Credits as Income. Maybe someone with a formal accountancy background has an opinion. So, Income account has Franked, Unfranked (from Bank) and Franking Credit (from Asset). I'm not sure how taxes should be accounted for but I have an Expense:Tax:Personal account and normally get a refund which I put through as a credit. I can see that should clear the [Asset] Franking Credit account. Let's see if the screenshot below comes through with a dividend for 100 MQG shares: [image: image.png] btw, Google search isn't returning anything for Franking over the last year: https://www.google.ca/search?q=site:lists.gnucash.org/pipermail/gnucash-user +franking=lnt=qdr:y=1003 > -- next part -- A non-text attachment was scrubbed... Name: image.png Type: image/png Size: 15301 bytes Desc: not available URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210827/fb73b6 b3/attachment-0001.png> -- Hi Flywire, I think you're probably right that Franking Credits should be income, but for my personal accounts, it doesn't matter. I also tried searching for Franking Credits (including site:lists.gnucash.org in the search string as recommended) but doesn't seem to work. Strange... Regards, Chris Good ___ 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] Financial Account Structure for Australian Shares and EFTs
Message: 11 Date: Thu, 26 Aug 2021 23:37:15 +1000 From: flywire To: Gnucash Users Subject: [GNC] Financial Account Structure for Australian Shares and ETFs Message-ID: Content-Type: text/plain; charset="UTF-8" The guide leaves stock and mutual fund financial account structure very open and search only showed one Franking/Franked thread in the recent past. I'm wondering what people do in practice. Share dividends looks doable: Bank deposit = Unfranked + Franked - Tax Withheld. Franked has unpaid Franking Credits. Where does the contra account for Franking Credits sit? (I use a fairly simple account tree.) ETFs: have about 10 tax codes that don't bear much resemblance to actual payments. How do people handle these? (I realise financial records only go so far preparing for tax. It's looking like a spreadsheet.) I'm not looking at tracking physical shares/ETFs in GnuCash. -- Hi Flywire, Please see my response https://lists.gnucash.org/pipermail/gnucash-user/2021-August/097360.html I don't know anything about EFT's... Regards, Chris Good ___ 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] Balance not updating
Hi Nike, Glad you have resolved your problem. Unless this problem is happening often, it is not worth spending any time trying to fix. It may have been caused by something other than a GnuCash program problem, such as a hardware or operating system problem. Regards, Chris Good -Original Message- From: Vinayak Vatsal Sent: Sunday, 15 August 2021 11:59 PM To: Chris Good Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Balance not updating Thanks for the suggestion. This problem seems to have mysteriously disappeared. It persisted through one full session, and an eventual crash, but relaunching GnuCash seems to have fixed it. I don’t really know what happened; maybe some transient data corruption? > On Aug 13, 2021, at 7:14 PM, Chris Good wrote: > > Message: 1 > Date: Wed, 11 Aug 2021 08:53:14 -0700 > From: Vinayak Vatsal > To: gnucash-user@gnucash.org > Subject: [GNC] Balance not updating > Message-ID: <435ff31b-9eb2-4c06-90e3-51b6d8081...@mac.com> > Content-Type: text/plain; charset=utf-8 > > Hello, > > I have recently encountered the following problem: > > Importing OFX transactions into one of my credit card accounts results > in an error, where the correct credit or withdrawal is shown, but the > balance column just comes up as zero. > > This is a recent thing, and I suspect it has something to do with the > fact that the credit card was recently issued (the old one expired) > and there?s a new ID number somewhere that is confusing. > > I tried things like changing the account ID to some random value and > reimporting, and also just importing a CSV file with the same data, > but the problem persists. > > I can manually enter transactions without any problem. > > Any ideas how to fix this? > > Thank you. > > Nike > > > Hi Nike, > > I'm not sure I understand your problem, but maybe your transactions > are being imported into a different account than you are expecting. > > If you go into Tools, "Import Map Editor", and select "Online", you > can see the accounts that you have previously selected to match the > bank id's in your .ofx files. > If you delete the incorrect match, your next ofx import will ask you > to select the matching account again. > > If I'm not understanding your problem, perhaps a partial screen dump > would help us understand? > > Regards, Chris Good > ___ 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] Balance not updating
Message: 1 Date: Wed, 11 Aug 2021 08:53:14 -0700 From: Vinayak Vatsal To: gnucash-user@gnucash.org Subject: [GNC] Balance not updating Message-ID: <435ff31b-9eb2-4c06-90e3-51b6d8081...@mac.com> Content-Type: text/plain; charset=utf-8 Hello, I have recently encountered the following problem: Importing OFX transactions into one of my credit card accounts results in an error, where the correct credit or withdrawal is shown, but the balance column just comes up as zero. This is a recent thing, and I suspect it has something to do with the fact that the credit card was recently issued (the old one expired) and there?s a new ID number somewhere that is confusing. I tried things like changing the account ID to some random value and reimporting, and also just importing a CSV file with the same data, but the problem persists. I can manually enter transactions without any problem. Any ideas how to fix this? Thank you. Nike Hi Nike, I'm not sure I understand your problem, but maybe your transactions are being imported into a different account than you are expecting. If you go into Tools, "Import Map Editor", and select "Online", you can see the accounts that you have previously selected to match the bank id's in your .ofx files. If you delete the incorrect match, your next ofx import will ask you to select the matching account again. If I'm not understanding your problem, perhaps a partial screen dump would help us understand? Regards, Chris Good ___ 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] Importing Multiple Accounts in a single OFX/QFX file
Hi, Re https://bugs.gnucash.org/show_bug.cgi?id=105334#c13 import multiple account OFX files with transfers between the accounts, duplicate transactions are generated The problem is that when you import OFX transactions for 2 bank accounts from the same file, if there is a transfer between the 2 bank accounts, the 'Generic transaction matcher' window does not detect that the transaction in the transactions for the 2nd bank account is a duplicate and defaults to wanting to add it (a duplicate transaction) when it should default to matching it against the first transaction. This is because the first transaction has not yet been stored in the GnuCash datafile. A suggestion solution to this problem is to match and store each account's transactions 1 at a time, rather than putting all transactions in the ofx file in the matcher window at the same time. I'm wondering if this would be unacceptable to some people? By the way, I didn't realise you could select multiple .ofx files at once in the OFX import. Some people may find that useful. It seems they have to be in the same directory. Regards, Chris Good ___ 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] DRP accounts, portfolio reports and making sense of the numbers
Message: 3 Date: Sat, 7 Aug 2021 10:39:50 +1000 From: Andrew Clark To: GnuCash users group Subject: [GNC] DRP accounts, portfolio reports and making sense of the numbers Message-ID: Content-Type: text/plain; charset="utf-8" Somehow my previous email was sent before I had finished typing it. I have an investment of NAB shares that I acquired as part of their employee incentive program years ago and I'm trying to figure out the best way to record it in GnuCash. The shares were worth $3000 at the time of allotment. They were released to me at the value of $2732.85. They pay a regular dividend twice a year. That dividend is reinvested as part of a dividend reinvestment program (DRP). Any remainder from the DRP is held over until the next cycle. So take the payment on 2008-12-17. There was 24.25 held over from the previous cycle. The dividend was also 24.25. Total to reinvest is 48.50. Shares 2 @ 18.64 = 37.28 Remainder held until next cycle 48.50 - 37.28 = 11.22. [image: image.png] Now, in the portfolio report, if I set the date ot the date of that transaction, I get: [image: image.png] 'Money in' should be $2732.85 but it includes the 13.03 that was used from the held over dividend? I don't feel like it should, as I have not contributed any money into the system. The accounts are laid out as below: [image: image.png] Should the DRP Holding account have a different type? Should it be located somewhere else? Is there a better way to record this? -- Cheers, Andrew. -- next part -- A non-text attachment was scrubbed... Name: image.png Type: image/png Size: 30466 bytes Desc: not available URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210807/55a796 37/attachment.png> -- next part -- A non-text attachment was scrubbed... Name: image.png Type: image/png Size: 25054 bytes Desc: not available URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210807/55a796 37/attachment-0001.png> -- next part -- A non-text attachment was scrubbed... Name: image.png Type: image/png Size: 5261 bytes Desc: not available URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210807/55a796 37/attachment-0002.png> -- Hi Andrew, I'm also in Australia. I call "DRP Holding" "DRP Residual". I don't know which is more correct. This is for my personal accounts. I am not an accountant. Please check with you accountant. My structure is as follows: Assets Investments Brokerage Investor1 NAB ... DRP Residual NAB Franking Credit Investor1 ... Income Dividend NAB Franked Unfranked ... Liabilities Franking Credit Tax Owed Investor1 ... As it is easy to restructure your chart of accounts just by changing the account parent, give that a go (backup first). As part of each dividend transaction, I: 1. only add 1 split for DRP Residual, which is the change in residual 2. Track Franking Credits: Assets:Investments:Franking Credit:Investor1Dr Liabilities:Franking Credit Tax Owed:Investor1Cr After tax is paid and franking credits are used (30th June), clear out franking credits Assets:Investments:Franking Credit:Investor1Cr Liabilities:Franking Credit Tax Owed:Investor1Dr I use a different self-written system for tracking Franking credits so you may like to add further subaccounts to your Franking Credit accounts for stock code. Regards, Chris Good ___ 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] Transactions for multiple accounts in 1 ofx file?
When I went to create a bug for this I found one already exists: https://bugs.gnucash.org/show_bug.cgi?id=105334 Import multiple account OFX files with transfers between the accounts, duplicate transactions are generated Regards, Chris Good -Original Message- From: Chris Good Sent: Sunday, 1 August 2021 5:49 PM To: 'Kalpesh Patel' Cc: gnucash-user@gnucash.org Subject: RE: Transactions for multiple accounts in 1 ofx file? Hi Kalpesh Patel, Your hiccup sounds exactly like the problem I have described. 2 people have now said they have transactions from multiple bank accounts in the 1 .ofx file, so there are probably many more who do not subscribe to this email list and who also may come across this problem. I will raise a bug to document it. If Covid-19 lockdown continues for much longer I may have enough time to try to fix this myself. Regards, Chris Good -Original Message- From: Kalpesh Patel Sent: Sunday, 1 August 2021 5:05 AM To: goodchri...@gmail.com Cc: gnucash-user@gnucash.org Subject: Re: Transactions for multiple accounts in 1 ofx file? I use it in this manner all the time and works great. I use an old program called pocketsense, which I modified a bit, which goes out to multiple institutions, downloads from each in ofx format and then combines them into single ofx file to import it into gnucash. Literally speaking they all are concatenation of individual files into one. It has been working fine since version 3.5 (or earlier I think). Only hickup that I see now and then is If transaction are across two accounts (example a transfer) in ofx then gnucash doesn't cross correlate them but if that happens then I disable import for the "seconds" account, finish first import and then perform second import of the same file and then it cross correlates automatically. Nice thing with ofx import in gnucash is that you can import same file multiple times but not get duplicated entries for the same transaction. I have tested combined ofx file that has investment account, banking account and a credit card account and if anything it is one of the robust feature of gnucash, IMHO. - Excuse the typos. It's the mobile thingy! ___ 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] Transactions for multiple accounts in 1 ofx file?
Hi Kalpesh Patel, Your hiccup sounds exactly like the problem I have described. 2 people have now said they have transactions from multiple bank accounts in the 1 .ofx file, so there are probably many more who do not subscribe to this email list and who also may come across this problem. I will raise a bug to document it. If Covid-19 lockdown continues for much longer I may have enough time to try to fix this myself. Regards, Chris Good -Original Message- From: Kalpesh Patel Sent: Sunday, 1 August 2021 5:05 AM To: goodchri...@gmail.com Cc: gnucash-user@gnucash.org Subject: Re: Transactions for multiple accounts in 1 ofx file? I use it in this manner all the time and works great. I use an old program called pocketsense, which I modified a bit, which goes out to multiple institutions, downloads from each in ofx format and then combines them into single ofx file to import it into gnucash. Literally speaking they all are concatenation of individual files into one. It has been working fine since version 3.5 (or earlier I think). Only hickup that I see now and then is If transaction are across two accounts (example a transfer) in ofx then gnucash doesn't cross correlate them but if that happens then I disable import for the "seconds" account, finish first import and then perform second import of the same file and then it cross correlates automatically. Nice thing with ofx import in gnucash is that you can import same file multiple times but not get duplicated entries for the same transaction. I have tested combined ofx file that has investment account, banking account and a credit card account and if anything it is one of the robust feature of gnucash, IMHO. - Excuse the typos. It's the mobile thingy! ___ 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] Transactions for multiple accounts in 1 ofx file?
Hi David (Cousens), The problem only occurs if you have transactions exported from multiple bank accounts in a single .ofx file. I have found this in GnuCash 4.5 but don't know about other versions. There were modifications to ofx processing in 4.2. Regards, Chris Good Message: 12 Date: Sat, 31 Jul 2021 23:37:36 +1000 From: David Cousens To: gnucash-user@gnucash.org Subject: Re: [GNC] Transactions for multiple accounts in 1 ofx file? Message-ID: Content-Type: text/plain; charset="UTF-8" Chris, I import OFX files from my bank with transfer transactions between three bank accounts and between all of those accounts and a credit card account reasonably regularly. I reconcile all accounts and have never noticed any discrepancies in the past. Is this any particular GnuCash version? I haven't imported anything for a month or two so haven't yet imported using V4.4 or 4.5 . David Cousens On Sat, 2021-07-31 at 18:29 +1000, Chris Good wrote: > Hi, > > > > I'd like some feedback from people who use the ofx/qfx file import, > > or any other type of import that uses the 'Generic import transaction > matcher' > > window. > > I've been fixing a problem and found another possible problem which I'd like > to determine is a problem that needs to be fixed. > > The ofx import handles transactions for multiple bank accounts in the 1 > file. > > If you have a transfer transaction between 2 bank accounts and the > transactions for both bank accounts are included in the 1 file, the > 'Generic import transaction matcher' window doesn't detect the second > > transaction should be a match of the transaction from the first accounts > transactions. > > Does anyone actually get and import a single ofx/qfx file from their bank, > or somehow > create a file, which includes the transactions for 2 bank accounts? > > Regards, > Chris Good > ___ 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] Transactions for multiple accounts in 1 ofx file?
Hi David, Thanks for your input. If the problem I described was fixed, you would still be able to flag those import transactions as to be ‘Added’ instead of ‘Matched’ (although the 2nd would default to ‘Match’ (Update and/or Reconcile instead of ‘Add’) and you would then still be able to do your manual procedure merging the Memo fields. It doesn’t sound too difficult to append the Memo fields together when matching them, assuming the program had already been modified to allow matching of 2 transactions in the same import. I seem to recall there is already an enhancement type bug to merge the transaction description and memo fields when matching an imported transaction to an existing transaction. Regards, Chris Good > On 31 Jul 2021, at 8:15 pm, David Carlson wrote: > > Chris, yes, I do regularly download OFX files from my bank that include > transactions from several checking and saving accounts in one file. It > happens that often there are transfers between accounts, and usually there > are already existing transactions in GnuCash as I planned the transfers > earlier to prepare for tax payments or whatever. The transfer transactions > appear as duplicates in the files and each has separate memo text that > differs depending on whether the transaction is the 'From' transaction or the > transaction is the 'To' transaction. > > Because there are existing transactions to match to, it would be possible > during the import process to avoid resulting duplicate entries by judicious > matching, but it happens that I want to retain memo text from both sides in > the split lines, so I deliberately treat both sides as new and manually merge > them as a post import operation. If it were possible to merge them during > the import and retain the split memos from both sides it would simplify my > work flow. > . > I would definitely miss the multiple account import feature if it were lost. > > On Sat, Jul 31, 2021 at 3:30 AM Chris Good wrote: >> Hi, >> >> >> >> I'd like some feedback from people who use the ofx/qfx file import, >> >> or any other type of import that uses the 'Generic import transaction >> matcher' >> >> window. >> >> I've been fixing a problem and found another possible problem which I'd like >> to >> >> determine is a problem that needs to be fixed. >> >> >> >> The ofx import handles transactions for multiple bank accounts in the 1 >> file. >> >> If you have a transfer transaction between 2 bank accounts and the >> >> transactions for both bank accounts are included in the 1 file, the >> >> 'Generic import transaction matcher' window doesn't detect the second >> >> transaction should be a match of the transaction from the first accounts >> >> transactions. >> >> >> >> Does anyone actually get and import a single ofx/qfx file from their bank, >> or somehow >> >> create a file, which includes the transactions for 2 bank accounts? >> >> >> >> Regards, >> >> Chris Good >> >> >> >> ___ >> 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.
[GNC] Transactions for multiple accounts in 1 ofx file?
Hi, I'd like some feedback from people who use the ofx/qfx file import, or any other type of import that uses the 'Generic import transaction matcher' window. I've been fixing a problem and found another possible problem which I'd like to determine is a problem that needs to be fixed. The ofx import handles transactions for multiple bank accounts in the 1 file. If you have a transfer transaction between 2 bank accounts and the transactions for both bank accounts are included in the 1 file, the 'Generic import transaction matcher' window doesn't detect the second transaction should be a match of the transaction from the first accounts transactions. Does anyone actually get and import a single ofx/qfx file from their bank, or somehow create a file, which includes the transactions for 2 bank accounts? Regards, Chris Good ___ 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] Australian cash residuals - Non- GnuCash question
Hi Geoff, Thanks very much. You have answered all my questions and also some I'd only thought about. Regards, Chris Good ___ 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] Australian cash residuals - Non- GnuCash question
Hi, I apologize in advance for this non GnuCash question but I searched the internet and could not find an answer and I don't think I could get an answer I would trust from the Australian share registries help lines. I wonder if any Australian investors can help me with this. If you reinvest your dividends and have multiple share holdings in a particular company under different SRN's (Security Ref Nos), is the cash residual (difference between total dividend amount and the value of the shares added because of the dividend reinvestment) held by SRN (Investor/Company/SRN) or just a total per investor (Investor/Company)? For those non Australians, who may be wondering, this cash residual occurs because, in my experience, all Australian companies dividend reinvestment plans only reinvest a whole no of shares. (Although there has been 1 company that actually rounds up the no of shares issued, so actually gives you more shares than the dividend total - a real pain to account for). I'd like to know because I've recently had to start dealing with multiple SRN's per company and I have another System I wrote (MS Access if anyone Aussie is interested - pls email me direct) which I need to modify to handle the multiple SRN's per company. I suppose different share registries could do different things, so I'm really mostly interested in what ComputerShare & Link do. Regards, Chris Good ___ 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] Can anyone help with this issue please - GNC-FQ Not able to collect data
Hi David, >From memory Finance::Quote 1.51 is broken and the nice maintainer is working on 1.52. The problems were to do with missing dependencies for some cpan modules. In the meantime you might try, from a cmd.exe window: cpan upgrade to upgrades all modules. Note that the correct syntax to use gnc-fq-dump to get an exchange rate is: cd C:\Program Files (x86)\gnucash\bin set ALPHAVANTAGE_API_KEY=__Your_Actual_Key__ perl gnc-fq-dump currency USD EUR See https://wiki.gnucash.org/wiki/Online_Quotes#Helper_Scripts Another thing to check is your version of Strawberry perl. Use perl -v to check the version. Maybe you need to upgrade to the latest Strawberry perl. You can uninstall your current Strawberry perl from Start, Settings, Apps. Regards, Chris Good Message: 2 Date: Sun, 18 Jul 2021 15:30:43 +0100 From: "david.rom...@davidjromano.com" To: Geoff Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data Message-ID: <12969517-6727-42c5-a202-04b3b75f8...@davidjromano.com> Content-Type: text/plain; charset=us-ascii Thanks Geoff, yes I think I did though I will recheck this. I've also tried this with an alternative key in case the first was the problem. David Sent from my iPhone > On 18 Jul 2021, at 13:55, Geoff wrote: > > Hi David > > Did you remember to set your alphavantage key as an environment variable when testing with Perl from the command line? > > Can you try this: > > C:\Program Files (x86)\gnucash\bin>set > ALPHAVANTAGE_API_KEY=__Your_Actual_Key__ > > C:\Program Files (x86)\gnucash\bin>echo %ALPHAVANTAGE_API_KEY% > __Your_Actual_Key__ > > C:\Program Files (x86)\gnucash\bin>echo (currency "USD" "GBP") | perl > gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-03-10 > 08:40:01") (last . #e0.72002) (currency . "GBP"))) > > C:\Program Files (x86)\gnucash\bin>echo (currency "EUR" "RON") | perl > gnc-fq-helper (("EUR" (symbol . "EUR") (gnc:time-no-zone . "2021-03-10 > 08:45:05") (last . #e4.8841) (currency . "RON"))) > > > Also, it is normal to get the blank command window when doing Get Quotes on Windows. > > Regards > > Geoff > = > >> On 18/07/2021 8:04 pm, david.rom...@davidjromano.com wrote: >> I'm having a problem with GNC-FQ not being able to retrieve currency >> data for the GBP / EUR currency pair. >> I had previously used FQ back when the data source was Yahoo, but >> when the Yahoo died I stopped using it. >> I now need to pick up GBP and EUR rates so I've installed the >> components required to get the Alphavantage feed to work - or so I hoped! >> Here's where I've got to so far: >> 1.I updated GNU Cash to current 4.6. >> 2.I installed Strawberry Perl version 5.32.1.1 >> 3.I'm Running Windows 10 Professional 21H1 build 19043.110 >> 4.I added my aphhavantage key in Preferences \ Online Quotes >> 5.I ran perl gnc-fq-check and got the following result: >> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-check ("1.51" "aex" >> "alphavantage" "amfiindia" "asegr" "asx" "aufunds" "australia" >> "bamosz" "bet" "bloomberg" "bourso" "bse" "bseindia" "canada" "canadamutual" >> "comdirect" "cse" "deka" "dutch" "dwsfunds" "europe" "fetch_live_currencies" >> "fidelity" "fidelity_direct" "finanzpartner" "fondsweb" "fool" "ftfunds" >> "fundata" "fundlibrary" "goldmoney" "greece" "hu" "hufund" "hungary" >> "hustock" "iexcloud" "india" "indiamutual" "known_currencies" >> "morningstarau" "morningstarjp" "mstaruk" "nasdaq" "nseindia" "nyse" "nzx" >> "onvista" "oslobors" "romania" "seb_funds" "six" "tiaacref" "tmx" >> "tradeville" "troweprice" "troweprice_direct" "tsp" "ukfunds" "unionfunds" >> "usa" "usfedbonds" "yahoo_json" "za") >> 6.I ran perl gnc-fq-update and got the following result: >> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-update Database was >> generated on Sat, 17 Jul 2021 11:42:13 GMT
Re: [GNC] Fwd: Re: Where does Gnucash remember what it did
Message: 6 > Date: Sat, 19 Jun 2021 01:53:31 -0500 (CDT) > From: beto > To: gnucash-user@gnucash.org > Subject: Re: [GNC] Fwd: Re: Where does Gnucash remember what it did >last - I want it to forget! > Message-ID: <1624085611597-0.p...@n4.nabble.com> > Content-Type: text/plain; charset=us-ascii > > I am running GnuCash in a flatpak. > > It keeps track of the recently opened files in: > >~/.var/app/org.gnucash.GnuCash/config/glib-2.0/settings/ > > Edit the 'org/gnucash/history' entries. > Hi Beto, See https://wiki.gnucash.org/wiki/Configuration_Locations#GSettings Regards, Chris Good ___ 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] Should the gnc-fq-* helper scripts be invoked as commands, or as an arg to perl?
Message: 4 Date: Sun, 13 Jun 2021 23:43:03 -0700 From: Jim DeLaHunt To: gnucash-user@gnucash.org Subject: Re: [GNC] Should the gnc-fq-* helper scripts be invoked as commands, or as an arg to perl? Message-ID: <108f1340-0815-46e8-2107-73c50dba2...@jdlh.com> Content-Type: text/plain; charset=utf-8; format=flowed ... On 2021-06-13 22:42, Chris Good wrote: ... > I'm pretty sure prefixing commands with the setting of environment variables > (e.g. XYZ=abc command) does not work in Windows. Interesting. How does one do "gnc-fq-dump currency" on Windows? How does one provide the AlphaVantage key? ... Best regards, ?Jim DeLaHunt Hi Jim, You have to set the key in the cmd environment before invoking gnc-fq-dump. E.g. cd \Program Files (x86)\gnucash\bin set ALPHAVANTAGE_API_KEY=## gnc-fq-dump alphavantage CSCO Regards, Chris Good ___ 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] Should the gnc-fq-* helper scripts be invoked as commands, or as an arg to perl?
Message: 9 Date: Sun, 13 Jun 2021 20:44:18 -0700 From: Jim DeLaHunt To: gnucash-user@gnucash.org Subject: Re: [GNC] Should the gnc-fq-* helper scripts be invoked as commands, or as an arg to perl? Message-ID: <96cbda1f-b16d-68be-da69-1e38fdf0e...@jdlh.com> Content-Type: text/plain; charset=utf-8; format=flowed On 2021-06-13 00:39, Jim DeLaHunt wrote: > Am I correct in guessing that GnuCash 4.5 internally invokes these > scripts (maybe just gnc-fq-helper) as an argument to a perl command? After a fairly quick read of the source code, I think the answer is, "Yes, for over 14 years". I see in gnucash/price-quotes.scm:120-122: ??? (define (start-quoter) ??? ? (set! quoter ??? ??? (gnc-spawn-process-async (list "perl" "-w" gnc:*finance-quote-helper*) #t))) I interpret this as meaning that GnuCash fetches quotes by spawning a process with arguments like: perl -w /path/to/helpers/gnc-fq-helper ...[args giving security for which to get quotes]... It looks to me like this code has been much the same since commit c38bcd3 on 2007-04-28.? Looking at the code it replaced, I suspect that GnuCash used to invoke the scripts directly, without the "perl" "-w" part. But that was long ago. There are comments in libgnucash/quotes/gnc-fq-help.in:75,92 which imply direct invocation. They have examples like: $ echo '(alphavantage "CSCO" "JDSU" "^IXIC")' | ./gnc-fq-helper But that will only get read by developers, who aren't as easily misled as non-developer users. > If so, should the wiki page > https://wiki.gnucash.org/wiki/Online_Quotes use the same invocation? I am now of the opinion that, yes, it should. I think that we should guide users to invoke the helper scripts is a similar way to how GnuCash actually invokes them. This will help reduce user confusion, by making their results more closely match GnuCash's results. I propose to change every invocation on that page from a bare name of the helper script e.g. gnc-fq-dump currency USD EUR to something like perl -w gnc-fq-dump currency USD EUR I will also make sure there is a clear explanation that the above abbreviates the path to the helper scripts and the AlphaVantage key. The actual invocation is actually more like: $ ALPHAVANTAGE_API_KEY=01234ABCD perl -w /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump currency USD EUR I will also deemphasise the mention of the shebang (#!). It looks like the invocation which GnuCash actually uses does not rely on shebang, so we should not be leading users to pay attention to it. Are there objections to me being bold and making such changes? Best regards, ?Jim DeLaHunt Hi Jim, Thanks for contributing to the documentation! I think: perl -w gnc-fq-dump currency USD EUR is going to confuse non-technical people just as much. And using /Path/To/Perl/perl -w /Path/To/HelperScripts/gnc-fq-dump currency USD EUR for every example is unnecessarily complicated. I suggest you just add a section at the start of https://wiki.gnucash.org/wiki/index.php?title=Online_Quotes#Helper_Scripts that gives explicit instructions and examples for Linux and macOS like it current does for Windows. Or maybe the later examples should all be stated to be for Linux and have specific instructions for Windows and macOS at the start of Helper_Scripts... I'm pretty sure prefixing commands with the setting of environment variables (e.g. XYZ=abc command) does not work in Windows. Running the helper scripts I'm open to any better suggestions. Regards, Chris Good ___ 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] Enable Online Stock Price Updating in GnuCash
Message: 11 Date: Fri, 4 Jun 2021 04:37:09 + From: Jai Rao To: "GnuCash-User@GnuCash.Org" Subject: [GNC] Enable Online Stock Price Updating in GnuCash Message-ID: Content-Type: text/plain; charset="us-ascii" Sir / Madam, I am trying to enable Online Stock Price Updating in GnuCash - (in Windows 10). * I have installed Strawberry Perl * Then I ran the "Install Online Price Retrieval for GnuCash" - from the Start Menu * This goes thru a long process in the CMD Prompt (Shell) window * It seems to make it to the end - see picture below: * [cid:6644e8d2-a3a2-4004-9571-53b898113207] * Then I open a new CMD Prompt and type: "perldoc Finance::Quote" * It says that there is no documentation for this * I then tried to go to the GnuCash Wiki page - but I was not able to get anyhere. I also could not figure out how to do the Root Shell to run "gnc-fq-update" Can you please let me know what to do? Thanks, Jai Rao -- next part -- A non-text attachment was scrubbed... Name: image.png Type: image/png Size: 78003 bytes Desc: image.png URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210604/c358e8 8c/attachment.png> -- next part -- A non-text attachment was scrubbed... Name: Outlook-q35xlm5e.png Type: image/png Size: 68180 bytes Desc: Outlook-q35xlm5e.png URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210604/c358e8 8c/attachment-0001.png> -- next part -- A non-text attachment was scrubbed... Name: Outlook-udrywjix.png Type: image/png Size: 68180 bytes Desc: Outlook-udrywjix.png URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210604/c358e8 8c/attachment-0002.png> -- next part -- A non-text attachment was scrubbed... Name: Outlook-0cdyg2x0.png Type: image/png Size: 68180 bytes Desc: Outlook-0cdyg2x0.png URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210604/c358e8 8c/attachment-0003.png> -- Hi Jai Rao, I don't think you need to run qnc-fq-update with Administrative privileges (the Windows equivalent of Linux root), but to do so: Click in the Cortana Ask me anything field to the right of the Start button, begin typing "cmd", a search menu should appear. The menu should display "Command Prompt". Right click on "Command Prompt", and select "Run as administrator". I suggest you use the instructions in https://wiki.gnucash.org/wiki/Online_Quotes#Helper_Scripts to run gnc-fq-check to see if there is a problem with your Finance::Quote installation, and it that doesn't find an error, use gnc-fq-dump to test, like say: perl gnc-fq-dump alphavantage IBM (There was a typo in https://wiki.gnucash.org/wiki/Online_Quotes#Source_Alphavantage.2C_US that made it difficult to see the Windows alphavantage instructions on that page which I have now fixed.) If you find a problem, we should be able to help you fix it. Regards, Chris Good ___ 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] I didn't like the dark theme. How to force using the default theme ?
Hi Marozsas, Please also see https://bugs.gnucash.org/show_bug.cgi?id=798202. You might like to add yourself to the CC List on the bug so you get emailed when the bug is updated. Regards, Chris Good Message: 1 Date: Mon, 7 Jun 2021 06:31:55 -0400 From: Parker Graham To: marozsas , gnucash-user@gnucash.org Subject: Re: [GNC] I didn't like the dark theme. How to force using the default theme ? Message-ID: Content-Type: text/plain; charset="utf-8"; Format="flowed" If you add (if not there) or change the gtk-3.0.css file to your /home//name//.var/app/org.gnucash.GnuCash/config/gnucash, or wherever the GnuCash config folder is on your computer to file attached you will have a good screen rendering. You can tweak the file to personalize it more if you want. On 6/5/21 7:15 AM, marozsas wrote: > <http://gnucash.1415818.n4.nabble.com/file/t27813/Screenshot_20210605_ > 080029.png> > Hi there ! > I'm using KDE with Breeze-Dark. > However, GnuCash in this dark theme displays a black foreground text > on black background . Impossible to read. > If I change KDE's default theme to something like Breeze, GnuCash > displays selected text as white foreground text on blue background, > which is the default and it is nice. > I would keep Breeze-Dark as the desktop's default theme but I need to > fix this weird choice of black text on black background in selections. > Alternatively, appliyng a light theme to whole gnucash is acceptable. > I've tried to add to .config/gtk-3.0/settings.ini the following, > without any > change: > gtk-application-prefer-dark-theme=false > gtk-theme-name=breeze-twilight > > -- > Sent from: > http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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] Transparent background on selected Transfer choice
Message: 11 > Date: Sat, 29 May 2021 13:46:14 + (UTC) > From: "David G. Pickett" > To: "gnucash-user@gnucash.org" > Subject: Re: [GNC] Transparent background on selected Transfer choice > Message-ID: <554837847.809085.1622295974...@mail.yahoo.com> > Content-Type: text/plain; charset=UTF-8 > > I never warmed to flaptak or snap with their huge repositories of historic > files, or compile your own, which means you are off the standard update > stream.? (I have compiled personal fixes into many distributed packages, know > my way around configure and all that, but I should not have to go there to > get basic good operation of current code.)? I wanted an update on the > standard update stream. > > The last bug report suggestion does fix it, so it could be distributed with > 3.8b and possibly other versions to fix this. > Hi David, I don’t understand your reticence to use flatpak. In my opinion, it is a wonderful way to be able to keep up with latest fixes and features, and also be able to run a specific older version if there is an issue that makes the latest and greatest no good for your situation, as occasionally happens. Admittedly, there are some known issues with flatpak, see https://wiki.gnucash.org/wiki/Flatpak#Known_Issues 3.8B as in Ubuntu 20.04 repository is from Dec 2019. There will be no re-release of such an old version. It may be possible to ship a fix for this problem with the next 4.6 release, but I’m not sure there is a mechanism that would enable an update to an existing gtk css file. Also, doing so may causes problems for users of other themes. Regards, Chris Good ___ 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] question - how do I move one or more transactions between accounts?
Message: 1 > Date: Sat, 29 May 2021 10:32:25 -0500 > From: David Carlson > To: DaveC49 > Cc: Gnucash Users > Subject: Re: [GNC] question - how do I move one or more transactions > between accounts? > Message-ID: > > Content-Type: text/plain; charset="UTF-8" > > The method described by DaveC49 is about the only practical way to do it. > > However, if you want to change the account for a split line from the > current account to a different account, it is faster to first jump to one > of the other accounts in that transaction before changing. Changing the > "home" is much slower, and waiting for the transaction to disappear is a > pain in the neck. > >> On Sat, May 29, 2021, 5:13 AM DaveC49 wrote: >> To move one split of a transaction from one account to another if you edit >> the transaction in the register for the account of the split which is going >> to be unchanged. A all you have to do is change the account in the Account >> column. Delete the existing selected account and you should get a drop down >> list which will allow you to select the new account for the split. There is >> no bulk cut and paste type operation AFAIK. Hi David Carlson, There is no waiting for the “transaction to disappear” on my i7 computer with an ssd and 16 GB ram. Regards, Chris Good ___ 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] Transparent background on selected Transfer choice
Message: 11 Date: Sat, 15 May 2021 10:50:17 +0100 From: Eric Coates To: Chris Good , gnucash-user@gnucash.org Cc: dgpick...@aol.com Subject: Re: [GNC] Transparent background on selected Transfer choice Message-ID: <4f4a5131-ceb7-c176-f877-c6c8d6e55...@talktalk.net> Content-Type: text/plain; charset=utf-8; format=flowed Good Morning In response to Chris Good's enquiry: At initial startup this morning the theme selected was Light and the transparency effect was apparent; Changed the theme to Dark and rebooted, the transparency effect was still apparent; Changed the theme to Standard and rebooted, the transparency effect was still apparent; Changed the theme back to Light and rebooted , the transparency effect was still apparent. As earlier reported I upgraded Ubuntu to 21.04, what I hadn't noticed was that GnuCash had been upgraded to 4.4 (Finance Quote is at 1.49). probably inconsequential but ... just for completeness. Take care Eric = On 14/05/2021 22:50, Chris Good wrote: > Message: 4 >> Date: Fri, 14 May 2021 14:19:49 + (UTC) >> From: "David G. Pickett" >> To: "gnucash-user@gnucash.org" >> Subject: Re: [GNC] Transparent background on selected Transfer choice >> Message-ID: <399211476.334118.1621001989...@mail.yahoo.com> >> Content-Type: text/plain; charset=UTF-8 >> >> Yes, I am 'as out of the box', and no, dark and light have the same problem. >> >> >> -Original Message- >> From: David G. Pickett >> To: gnucash-user@gnucash.org >> Sent: Thu, May 13, 2021 9:45 am >> Subject: Transparent background on selected Transfer choice >> >> I run GNUCash on Ubuntu LTS Linux, and when I select a transfer choice, the background under the choice goes transparent, showing the transaction screen below, see attached; not at all helpful! >> >> -- > Hi, > > David: what version of Ubuntu? > > David + Eric (twistedw...@talktalk.net), are you restarting GnuCash after changing the theme? > > Regards, Chris good Hi David (dgpick...@aol.com) + Eric (twistedw...@talktalk.net), Can you please test the fix Geert found in https://bugs.gnucash.org/show_bug.cgi?id=797493#c12 and let us know how you go? Can you reconfirm the Linux distro and version too please so I can document in the bug. Regards, Chris Good ___ 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] Transparent background on selected Transfer choice
Message: 4 > Date: Fri, 14 May 2021 14:19:49 + (UTC) > From: "David G. Pickett" > To: "gnucash-user@gnucash.org" > Subject: Re: [GNC] Transparent background on selected Transfer choice > Message-ID: <399211476.334118.1621001989...@mail.yahoo.com> > Content-Type: text/plain; charset=UTF-8 > > Yes, I am 'as out of the box', and no, dark and light have the same problem. > > > -Original Message- > From: David G. Pickett > To: gnucash-user@gnucash.org > Sent: Thu, May 13, 2021 9:45 am > Subject: Transparent background on selected Transfer choice > > I run GNUCash on Ubuntu LTS Linux, and when I select a transfer choice, the > background under the choice goes transparent, showing the transaction screen > below, see attached; not at all helpful! > > -- Hi, David: what version of Ubuntu? David + Eric (twistedw...@talktalk.net), are you restarting GnuCash after changing the theme? Regards, Chris good ___ 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] Transparent background on selected Transfer choice
Hi David(s), David Carlson, Did you see https://bugs.gnucash.org/show_bug.cgi?id=797493#c4 which mentions themes? I tested this in Windows 10 and could not duplicate it. I did duplicate this problem in Ubuntu 20.04 and found a couple of work-arounds. Please see https://bugs.gnucash.org/show_bug.cgi?id=797493#c6 Regards, Chris Good From: David Carlson Sent: Friday, 14 May 2021 7:21 AM To: Chris Good Cc: Gnucash Users ; David Subject: Re: [GNC] Transparent background on selected Transfer choice I did not see anything about themes in that bug report https://bugs.gnucash.org/show_bug.cgi?id=797493 except in a reference to another bug report where the user admitted to choosing a non-standard desktop theme. I did see the problem myself briefly recently but now I forgot when. I suspect that I may have seen it on Windows rather than Linux. Tht referenced bug report stated that when the user switched to the Adwaita theme (which, IIRC, is the default theme for several Linux desktops) the problem disappeared. Thus IMHO the theme concern does not apply to 797493 I don't change desktop themes often, if ever or themes for GnuCash, I leave it as 'out of the box', and I believe if David Pickett did too, then I think it is a GnuCash bug On Thu, May 13, 2021 at 10:17 AM Chris Good mailto:goodchri...@gmail.com> > wrote: Message: 4 > Date: Thu, 13 May 2021 13:45:04 + (UTC) > From: "David G. Pickett" mailto:dgpick...@aol.com> > > To: "gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> " > mailto:gnucash-user@gnucash.org> > > Subject: [GNC] Transparent background on selected Transfer choice > Message-ID: <964888588.96833.1620913504...@mail.yahoo.com > <mailto:964888588.96833.1620913504...@mail.yahoo.com> > > Content-Type: text/plain; charset="utf-8" > > I run GNUCash on Ubuntu LTS Linux, and when I select a transfer choice, the > background under the choice goes transparent, showing the transaction screen > below, see attached; not at all helpful! > -- next part -- > A non-text attachment was scrubbed... > Name: Screenshot from 2021-05-13 09-41-41.png > Type: image/png > Size: 249379 bytes > Desc: not available > URL: > <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210513/ae179ec6/attachment.png> > > Hi David, This looks like https://bugs.gnucash.org/show_bug.cgi?id=797493 which is a problem with your theme. Regards, Chris Good ___ gnucash-user mailing list gnucash-user@gnucash.org <mailto: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] Transparent background on selected Transfer choice
Message: 4 > Date: Thu, 13 May 2021 13:45:04 + (UTC) > From: "David G. Pickett" > To: "gnucash-user@gnucash.org" > Subject: [GNC] Transparent background on selected Transfer choice > Message-ID: <964888588.96833.1620913504...@mail.yahoo.com> > Content-Type: text/plain; charset="utf-8" > > I run GNUCash on Ubuntu LTS Linux, and when I select a transfer choice, the > background under the choice goes transparent, showing the transaction screen > below, see attached; not at all helpful! > -- next part -- > A non-text attachment was scrubbed... > Name: Screenshot from 2021-05-13 09-41-41.png > Type: image/png > Size: 249379 bytes > Desc: not available > URL: > <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210513/ae179ec6/attachment.png> > > Hi David, This looks like https://bugs.gnucash.org/show_bug.cgi?id=797493 which is a problem with your theme. Regards, Chris Good ___ 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] BackupGnuCash v2.1.0 Released - Adds support for Linux Flatpak
Hi, I've updated my BackupGnuCash app to version 2.1.0. The changes are: 1. Add support for backing up GnuCash configuration files when GnuCash is installed as a Flatpak on Linux. BackupGnuCash is run from outside the Flatpak sandbox. Note that the GnuCash sandbox has full access to the files outside the sandbox (with the exception of some blacklisted directories e.g. /etc) so there is no problem with the GnuCash sandbox accessing a GnuCash data file (usually xxx.gnucash) if it is outside the sandbox. 2. 7z[.exe] command: Move password arg from after archive to before. This is required for Linux Ubuntu 20.04 p7zip-full 16.02+dfsg-7build1 to fix "No more files" error. This is probably also needed for Ubuntu 20.04 derivatives like Mint 20. The app is a modular java app, it is distributed as a runtime image which includes the required java runtime, so it is not necessary to have java installed on your system. Please see: Linux: https://github.com/goodvibes2/BackupGnuCashLinux/tree/master/src/backupgnuca sh Windows: https://github.com/goodvibes2/BackupGnuCashWin/tree/master/src/backupgnucash Regards, Chris Good ___ 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] Trouble Installing Online Price Retrieval Tool
Hi Sudesh, Everything you should need to know to set up your stocks in GnuCash is covered in https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_invest.html Everything you should need to know about using Finance::Quote is covered in https://wiki.gnucash.org/wiki/Online_Quotes Regards, Chris Good Message: 9 Date: Wed, 5 May 2021 07:58:44 -0500 From: David Carlson To: Sudesh Chandar Cc: "gnucash-user@gnucash.org" , Geoff Subject: Re: [GNC] Trouble Installing Online Price Retrieval Tool Message-ID: Content-Type: text/plain; charset="UTF-8" Sudesh, I think you have completed the installation correctly. Since you also obtained a key from Alpha Vantage you should be able to use their service to download prices if they provide the ones that you want. For some stock quotes you may get better results using one of the other services that the finance-quote software can access. Ask here about specific quotes on specific exchanges. For example, I use Yahoo as json service for quotes on the US exchanges because I download about 30 prices at a time. On Wed, May 5, 2021, 5:19 AM Sudesh Chandar via gnucash-user < gnucash-user@gnucash.org> wrote: > Hello Geoff, > Many thanks for the fast reply. > Actually the Perl scripts ran longer than 30 minutes much closer > to 3 hours and after all that It threw up an error about "Alpha > Vantage API Key". I had to manually visit the alphavantage website > and request a key and update Gnucash app under edit/preferences. > Is this normal? > Once I updated the key It seems work okay now. > Like I said before, I am still a newbie at this, My next step is how > to setup a stock symbol in the price database/Get quotes button? > Currently pressing the button only gives me currency conversion > between USD and INR. > Thanks, > - SudeshOn Wednesday, May 5, 2021, 01:00:54 PM GMT+5:30, Geoff < > cleanoutmys...@gmail.com> wrote: > > Hi Sudesh > > Some of the required Perl modules take a considerable time to install > and the process may appear to "freeze" when in fact it is only "resting". > > Can you try again - you need to run the "gnc-fq-update" script located > in the "C:\Program Files (x86)\gnucash\bin\" directory - and send a > screenshot if it is still hanging after 30 minutes. > > Thanks > > Geoff > = > > On 5/05/2021 5:09 pm, Sudesh Chandar via gnucash-user wrote: > > Hello Group, > > I am a new user of GNU cash and have recently downloaded and > > installed > Gnucash ver 4.5 on a windows 10 64 bit machine. > > I am trying to run the script for Installing online price retrieval > > and > the command line freezes after a while. > > It installed the Strawberry perl just fine and the install check and > version check passes ok and then it copies all the *.pm files just ok. > > Where it hangs is after the message "C:\Strawberry\c\bin\gmake.exe > > -- > OK' > > What am I missing? > > I also checked the Gnucash app under the help menu/ about and the > "Finance::Quote" module is not installed. > > Any Help from the group as to why this is happening and how to > > resolve > it? > > Regards,Sid > > _ ___ 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] Mutual fund quotes in the U. S.
Hi David, I suggest you use gnc-fq-dump to see if Finance Quote (FQ) is returning a date (and time?) for your mutual funds. If GnuCash does not get a date from FQ, then it defaults the date to today. In this case, I suggest the solution would be to have FQ yahoo_JSON modified to provide an appropriate date, based on the time. It could be quite a complicated mod though. What do you do if the user time zone is not in the US? What about weekends and public holidays? An alternative may be to use a different FQ source (alphavantage?). The problem could also be that FQ is returning a date (and time) but GnuCash is changing the date based on your time zone, but I think that is unlikely as I think it tries to default the time to 11:59 or 10:59am on all dates to avoid that problem just about everywhere in the world. It may be helpful to also save your GnuCash data as uncompressed xml and see what the date/time is in the price database record. You can raise a FQ issue at https://github.com/finance-quote/finance-quote/issues See also https://wiki.gnucash.org/wiki/Online_Quotes You may like to ensure you are running the latest GnuCash and FQ. Regards, Chris Good > Message: 7 > Date: Sat, 24 Apr 2021 08:57:21 -0400 > From: Jack Frillman > To: David Carlson > Cc: Gnucash Users > Subject: Re: [GNC] Mutual fund quotes in the U. S. > Message-ID: <1bc5ad5a-508d-d272-20ad-bf4951122...@me.com> > Content-Type: text/plain; charset=utf-8; format=flowed > > It can get the prices for both stocks and mutual funds. The lookup is > done by ticker symbol. > > GNUC's csv price importer requires a date to be present in the csv file > so I'm not sure what you are asking in your second question. > > Below is a sample of a couple of lines from the csv file. It's has the > bare minimum of information the csv price importer requires. > > This is the format of each line: > TICKER,PRICE,TYPE,DATE,CURRENCY > > ARSIX,15.73,Ray Jay,2021/04/22,USD > BAFGX,35.07,Ray Jay,2021/04/22,USD > > > On 4/24/21 2:11 AM, David Carlson wrote: >> Jack, >> >> Your scripts offer an opportunity to massage the data, if needed.? Out >> of curiosity, can you import both stock prices and mutual fund >> prices?? And can you keep the timestamps in your CSV files? >> >> On Fri, Apr 23, 2021 at 8:55 PM Jack Frillman > <mailto:jcf_m_li...@me.com>> wrote: >> >>It may be doing what I'm doing and making the date of the closing >>price as the day the script is run. >> >>I don't run it using cron. I run it manually and if I forget a day >>I don't worry about it. >>I just run one of these two commands from the terminal. >> >>getquotes -y??? <-- ? gets the prices from Yahoo >>..OR. >>getquotes -m?? <-- ? gets the prices from Market Watch >> >>Then I import the resulting csv file that appears on my desktop. >> >>I have two places to get the quotes so if one is unreachable for >>some reason I have a backup source. >> >> >>On 4/23/21 9:43 PM, David Carlson wrote: >>>I am not sufficiently comfortable with BASH, Chron jobs, etc to >>>be willing to set up an outside utility to do that.? I manually >>>download prices inside the GnuCash price database using Yahoo as >>>JSON as the source.? If I forget to do it in the late evening I >>>sometimes try to do it in the morning before the market opens as >>>I have several stock prices that I am also tracking.? That is how >>>I discovered the incorrect dates on the mutual funds prices,? I >>>am not sure if, for example, GnuCash downloads a stock price >>>during the day, does it replace it with a closing price if it >>>downloads again after the market closes.? I suspect it may not >>>even keep the timestamps that come with the prices, so there may >>>not be any clue about that. >>>On Fri, Apr 23, 2021 at 8:18 PM Jack Frillman via gnucash-user >>>mailto:gnucash-user@gnucash.org>> wrote: >>>I'm not sure what you are using to updated the your prices >>>but I wrote a >>>python script & a bash script that get the quotes and put >>>them into a >>>csv file for importing into GNUCash and I don't have that >>>date issue. I >>>run the scrips in the evening when the markets are closed. >>>On 4/23/21 8:59 PM, David Carlson wrote: >>>> I noticed recently that if I download mutual fund prices >>>after about 7 AM >>>> central daylight time the p
Re: [GNC] Transaction Reconcile behavior differences
> Message: 7 > Date: Tue, 23 Feb 2021 09:46:12 -0800 > From: "Stephen M. Butler" > To: gnucash-user@gnucash.org > Subject: Re: [GNC] Transaction Reconcile behavior differences > Message-ID: > Content-Type: text/plain; charset=utf-8; format=flowed > >> On 2/23/21 4:13 AM, John Nickell wrote: >> I recently switched from GnuCash on Linux Mint to GnuCash on Windows. I >> brought the same GnuCash data file over between computers. >> >> My checking account is setup in GnuCash as a parent account with multiple >> sub accounts to the checking account. >> When reconciling (including sub accounts) on Linux if I selected a >> transaction that had multiple splits or was simply a transfer among sub >> accounts, all of the transaction splits that were part of that same >> transaction would also be marked as reconciled. (i.e. their box would be >> checked and the reconcile balance would reflect a $0 change.) >> >> When reconciling on Windows I'm having to reconcile each split individually >> and if the transaction is between two sub accounts within the checking >> account I must reconcile both the debit and the credit action separately. >> >> Is this expected and desired on the Windows version of GnuCash, or is there >> a setting I'm missing so that a reconciling "part" of a transaction >> reconciles all of the transaction within the account? >> >> I'm not looking for a reconciliation in my checking account to reconcile >> the transaction split in the savings account, but for transaction splits >> that are within the same parent checking account being reconciled I'd like >> to see similar behavior as I saw on the Linux version. Or at least >> understand this is 'expected'. >> >> I've made pretty heavy use of these split transaction types and this >> unexpected difference in transferring OS's has slowed down my >> reconciliation process. >> >> If an example helps: >> I us a single transaction to transfer a $1000 paycheck into three sub >> accounts. $300 for Automobile, $500 for Savings, $200 for Food. All are >> still within the same parent checking account. In Linux checking the box to >> reconcile the $200 food transaction would also check the Automobile, >> Savings and $1000 split. > I would consider that a bug on the Linux side.? I sometimes generate a > multi-part transaction that has two parts on the checking side. Those > two parts take different path and one general reconciles several days > before the other. > > I, personally, would want to reconcile each split separately. > >> In my experience with Windows all 4 transaction >> splits must be "checked" individually. >> >> Checking >>>> Food >>>> Automobile >>>> Savings >> Thanks >> ___ >> > -- > Stephen M Butler, PMP, PSM > stephen.m.butle...@gmail.com > kg...@arrl.net > 253-350-0166 > --- > GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 > Hi John, This was done intentionally. Please see discussion in bug https://bugs.gnucash.org/show_bug.cgi?id=797648 and the referenced pull requests. Regards, Chris Good ___ 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] [GNC} Cannot get online quotes
Message: 2 Date: Fri, 25 Sep 2020 09:49:55 +0200 From: Emilio Dorigatti To: gnucash-user@gnucash.org Subject: [GNC] Cannot get online quotes Message-ID: <06fa361c-71b1-8c1c-da32-d7170830b...@gmail.com> Content-Type: text/plain; charset=utf-8; format=flowed Hi all, I am trying to setup online quotes as per the guide [1]. I am at the latest version # gnc-fq-update Reading '/root/.cpan/Metadata' ? Database was generated on Fri, 25 Sep 2020 01:29:03 GMT Date::Manip is up to date (6.82). Finance::Quote is up to date (1.49). And no errors are returned from check: $ gnc-fq-check ("1.49" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asx" "aufunds" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "bse" "bsero" "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct" "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france" "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" "greece" "hex" "hu" "hufund" "hungary" "hustock" "iexcloud" "indiamutual" "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarau" "morningstarch" "morningstarjp" "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds" "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse" "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" "yahoo_json" "yahoo_yql" "za" "za_unittrusts") However, dumping fails with all sources: $ gnc-fq-dump -v europe AMZN Parsing of undecoded UTF-8 will give garbage when decoding entities at /usr/share/perl5/site_perl/HTML/TreeBuilder.pm line 108. Finance::Quote fields Gnucash uses: ??? symbol: AMZN (deduced)?? <=== required ? date: ** missing **??? <=== recommended ? currency: ** missing **??? <=== required ? last: **missing**? <=\ ?? nav: **missing**? <=== one of these price: **missing**? <=/ ? timezone:? <=== optional ** This stock quote cannot be used by GnuCash! All fields returned by Finance::Quote for stock AMZN stock?? field? value -?? -? - AMZN errormsg: HTTP session failed AMZN last: **missing** AMZN? nav: **missing** AMZN??? price: **missing** AMZN? success: 0 And obviously fails within GnuCash, too. I don't know how I am supposed to specify the currency? Or perhaps there are connection issues to the servers? Thank you for working on GnuCash, it's an amazing piece of software! Emilio. [1]: https://wiki.gnucash.org/wiki/Online_Quotes Hi Emilio, Source europe also fails with AMZN for me but source alphavantage works. You have to set your ALPHAVANTAGE_API_KEY in the environment for gnc-fq-dump and in the Online Quotes tab of GnuCash Preferences for GnuCash. Does that work for you? Regards, Chris Good ___ 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] Alpha Vantage problems
Hi Bob, Good to know. Can you give an example of a stock and the symbol you used that used to work please? Regards, Chris Good Message: 9 Date: Tue, 7 Jul 2020 13:06:11 +0100 From: Robert Dean To: gnucash-user@gnucash.org Subject: Re: [GNC] Alpha Vantage problems Message-ID: Content-Type: text/plain; charset=utf-8; format=flowed Hi, I have also lost access to Alphavantage stocks on LSE. It last worked on 24 June, but failed on the 25th. I have checked both my stocks with gnc-fq-dump and neither work, so I have changed to Yahoo-json. I'm using Gnucash 3.10 on Fedora 32. Regards Bob Dean On 07/07/2020 12:01, Chris Good wrote: > Hi Adrian, how are you getting quotes from excel? Have you got your > alphavantage API key specified in GnuCash preferences? > > I suggest the next stage would be to test each of the stocks you want > to use Alphavantage for, with gnc-fq-dump. > > Regards, Chris Good > > On Tue., 7 Jul. 2020, 7:39 pm Adrian Holbrook, > > wrote: > >> Thanks Chris, I think my installation of Finance;;Quote is working >> fine as I get quotes from other sources such as Morningstar and Yahoo >> JSON without any problem. I think it must be an Alphavantage problem >> and the next stage is to try and get quotes using excel and see if >> that works. In the short term I have changed my source to Yahoo JSON >> and that is working. I would just like to be able to get Alphavantage >> working as well so that if one fails I have a backup source. >> >> Regards >> >> Adrian >> >> >> >> On Tue, Jul 7, 2020 at 9:10 AM Chris Good wrote: >> >>> Message: 3 >>> Date: Tue, 7 Jul 2020 07:58:33 +0100 >>> From: Adrian Holbrook >>> To: gnucash-user@gnucash.org >>> Subject: [GNC] Alpha Vantage problems >>> Message-ID: >>> >> a...@mail.gmail.com> >>> Content-Type: text/plain; charset="UTF-8" >>> >>> I have been using Alphvantage for about a year now to get quotes >>> without any problems - I had to add in the 15 second delay that was >>> suggested to stop it failing - but since then it has been 100% >>> reliable. I normally download around 50 prices at a time about once >>> a week. The last successful download was on June 12th and since then >>> all attempts have failed. >>> >>> All my shares are on the LSE. I have not checked trying to get >>> quotes from NYSE but that would be my next test. >>> I am using Gnucash 4.0 and Finance::Quote 1.49 >>> >>> Regards >>> >>> Adrian >>> >>> Hi Adrian, >>> >>> Please follow instructions at >>> https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting >>> >>> Regards, Chris Good ___ 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] Alpha Vantage problems
Hi Adrian, I'm afraid I have no idea if AlphaVantage can now or has ever been able to supply prices for stocks on the London Stock Exchange. It would be good to know an example stock? Maybe some-one else can help? I have never been able to figure out a way to get prices for stocks on the Australian Stock Exchange either. Using the yahoo_json .AX suffix doesn't seem to work for AlphaVantage. If there is a way to do either of these things, it would be good to know and I could document it in the wiki. Regards, Chris Good Message: 11 Date: Tue, 7 Jul 2020 14:58:27 +0100 From: Adrian Holbrook To: Chris Good Cc: GnuCash User Mailing List Subject: Re: [GNC] Alpha Vantage problems Message-ID: Content-Type: text/plain; charset="UTF-8" Thanks fo the advice. I was going to download the alpphvantage addon for Excel but instead used gnc-fq-dump. I can get all the NYSE stocks but nothing off the LSE using the suffix .L. Fails every time;. Adrian On Tue, Jul 7, 2020 at 12:01 PM Chris Good wrote: > Hi Adrian, how are you getting quotes from excel? Have you got your > alphavantage API key specified in GnuCash preferences? > > I suggest the next stage would be to test each of the stocks you want > to use Alphavantage for, with gnc-fq-dump. > > Regards, Chris Good > > On Tue., 7 Jul. 2020, 7:39 pm Adrian Holbrook, > > wrote: > >> Thanks Chris, I think my installation of Finance;;Quote is working >> fine as I get quotes from other sources such as Morningstar and Yahoo >> JSON without any problem. I think it must be an Alphavantage problem >> and the next stage is to try and get quotes using excel and see if >> that works. In the short term I have changed my source to Yahoo JSON and that is working. >> I would just like to be able to get Alphavantage working as well so >> that if one fails I have a backup source. >> >> Regards >> >> Adrian >> >> >> >> On Tue, Jul 7, 2020 at 9:10 AM Chris Good wrote: >> >>> Message: 3 >>> Date: Tue, 7 Jul 2020 07:58:33 +0100 >>> From: Adrian Holbrook >>> To: gnucash-user@gnucash.org >>> Subject: [GNC] Alpha Vantage problems >>> Message-ID: >>> >> a...@mail.gmail.com> >>> Content-Type: text/plain; charset="UTF-8" >>> >>> I have been using Alphvantage for about a year now to get quotes >>> without any problems - I had to add in the 15 second delay that was >>> suggested to stop it failing - but since then it has been 100% >>> reliable. I normally download around 50 prices at a time about once >>> a week. The last successful download was on June 12th and since then >>> all attempts have failed. >>> >>> All my shares are on the LSE. I have not checked trying to get >>> quotes from NYSE but that would be my next test. >>> I am using Gnucash 4.0 and Finance::Quote 1.49 >>> >>> Regards >>> >>> Adrian >>> >>> Hi Adrian, >>> >>> Please follow instructions at >>> https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting >>> >>> Regards, Chris Good ___ 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] Alpha Vantage problems
Hi Adrian, how are you getting quotes from excel? Have you got your alphavantage API key specified in GnuCash preferences? I suggest the next stage would be to test each of the stocks you want to use Alphavantage for, with gnc-fq-dump. Regards, Chris Good On Tue., 7 Jul. 2020, 7:39 pm Adrian Holbrook, wrote: > Thanks Chris, I think my installation of Finance;;Quote is working fine as > I get quotes from other sources such as Morningstar and Yahoo JSON without > any problem. I think it must be an Alphavantage problem and the next stage > is to try and get quotes using excel and see if that works. In the short > term I have changed my source to Yahoo JSON and that is working. I would > just like to be able to get Alphavantage working as well so that if one > fails I have a backup source. > > Regards > > Adrian > > > > On Tue, Jul 7, 2020 at 9:10 AM Chris Good wrote: > >> Message: 3 >> Date: Tue, 7 Jul 2020 07:58:33 +0100 >> From: Adrian Holbrook >> To: gnucash-user@gnucash.org >> Subject: [GNC] Alpha Vantage problems >> Message-ID: >> > a...@mail.gmail.com> >> Content-Type: text/plain; charset="UTF-8" >> >> I have been using Alphvantage for about a year now to get quotes without >> any >> problems - I had to add in the 15 second delay that was suggested to stop >> it >> failing - but since then it has been 100% reliable. I normally download >> around 50 prices at a time about once a week. The last successful download >> was on June 12th and since then all attempts have failed. >> >> All my shares are on the LSE. I have not checked trying to get quotes from >> NYSE but that would be my next test. >> I am using Gnucash 4.0 and Finance::Quote 1.49 >> >> Regards >> >> Adrian >> >> Hi Adrian, >> >> Please follow instructions at >> https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting >> >> Regards, Chris Good >> >> ___ 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] Alpha Vantage problems
Message: 3 Date: Tue, 7 Jul 2020 07:58:33 +0100 From: Adrian Holbrook To: gnucash-user@gnucash.org Subject: [GNC] Alpha Vantage problems Message-ID: Content-Type: text/plain; charset="UTF-8" I have been using Alphvantage for about a year now to get quotes without any problems - I had to add in the 15 second delay that was suggested to stop it failing - but since then it has been 100% reliable. I normally download around 50 prices at a time about once a week. The last successful download was on June 12th and since then all attempts have failed. All my shares are on the LSE. I have not checked trying to get quotes from NYSE but that would be my next test. I am using Gnucash 4.0 and Finance::Quote 1.49 Regards Adrian Hi Adrian, Please follow instructions at https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting Regards, Chris Good ___ 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] GunCash 4.0 Paper Clip and Link glyphs for file/web transaction associations
Hi John, Thanks for the info. It seems from https://emojipedia.org/paperclip/ & https://emojipedia.org/link/ that Microsoft is the only vendor with a paperclip or link emoji that has a black background. Thanks also for the GnuCash history info. It's always interesting to me. Regards, Chris Good -Original Message- From: John Ralls Sent: Saturday, 4 July 2020 1:02 PM To: Chris Good Cc: gnucash-user@gnucash.org Subject: Re: [GNC] GunCash 4.0 Paper Clip and Link glyphs for file/web transaction associations Each vendor has their own emoji-block glyphs. The one you're seeing looks pretty similar to https://emojipedia.org/microsoft/windows-10-may-2019-update/paperclip/. As for why it's being drawn directly on the sheet, that's because the GnuCash register is substantially older that GtkTreeView. You might remember Register2, Bob Fewell's attempt to rewrite it to use GtkTreeView for GnuCash 2.6. He wasn't able to make it stable enough and set it aside. It's still in the codebase: Run gnucash --extra and the Extra menu has "Open Account with Register2". Regards, John Ralls > On Jul 3, 2020, at 6:05 PM, Chris Good wrote: > > Hi Adrien, > > Wow, how did I not notice I used GunCash instead of GnuCash in the subject. > > I wonder why the glyph is better in Linux than Windows - maybe > some-one knows... > I wonder if it is possible to somehow install the Ubuntu font or > whatever contains the emoji section of Unicode into Windows. > > The Ubuntu 'Character Map' application shows the glyphs in Unicode category: > 'Symbol, Other' under Unicode Block 'Miscellaneous Symbols and Pictographs'. > > I also wonder why GnuCash writes to the sheet directly rather than > using a treeview? > I'm currently trying to change it so there is a visual indication of > an attachment without having to go into double line view. > I cannot get it to make any difference using css but I can use code to > change the font to Italic, so now I'm working on how to get it to do > that to the Description only when there is an attachment. This seems > the best I can do at the moment. > > Regards, Chris Good > > Message: 4 > Date: Fri, 3 Jul 2020 09:24:40 -0500 > From: Adrien Monteleone > To: GnuCash Users > Subject: Re: [GNC] > > Message-ID: <38e5d134-3f25-4f25-aa5b-af9ed7020...@lusfiber.net> > Content-Type: text/plain; charset=utf-8 > > The glyphs are part of the emoji section of Unicode. I don?t expect > changing the base font is going to affect them. > > I?m not sure how to specify just an emoji set. > > I?m also not sure if GTK CSS allows rotations and other transforms > like web CSS, but you might give it a try. However, there doesn?t seem > to be any CSS hook exposed for the cell where the glyphs are placed on > the register sheet, so I don?t think you can target them with specificity. > > Regards, > Adrien > >> On Jul 3, 2020 w27d185, at 3:31 AM, Chris Good >> > wrote: >> >> Has anyone figured out how to make the new paper clip and link glyphs >> look better in Windows 10? >> >> In Linux Ubuntu 18.04 they look great but in Windows 10 they look >> pretty bad, especially the paper clip. >> >> Please see attached. >> >> >> >> C:\Users\cgood\AppData\Roaming\Gnucash\gtk-3.0.css contains : >> >> * { >> >> font: 16px arial, sans-serif; >> >> } >> >> >> >> Changing the font from 'arial' *does* effect most characters but not >> the PaperClip or Link glyphs. >> >> >> >> Here's the definition of the glyphs from >> src/gnucash/register/register-core/assoccell.h >> >> #define GLYPH_PAPERCLIP "\360\237\223\216" // Codepoint U+1F4CE >> >> #define GLYPH_LINK "\360\237\224\227" // Codepoint U+1F517 > > ___ > 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] Gnucash 4.0 Paper Clip and Link glyphs for file/web transaction associations
Hi Ken, I'm afraid I'm in the group that finds reconciling very useful. I want to know if anyone is charging me when they shouldn't be, without having to check my phone all the time. Admittedly it happens so infrequently I could probably do without it, but I sleep better with it. I know a developer is considering restructuring the columns to make better use of wider displays. Maybe that will help you in future. Myself, I don't really want to use the whole screen, but who knows, I often find I automatically dislike change but end up liking it. Regards, Chris Good -Original Message- From: py...@cox.net Sent: Saturday, 4 July 2020 11:32 AM To: 'Chris Good' ; gnucash-user@gnucash.org Subject: RE: [GNC] Gnucash 4.0 Paper Clip and Link glyphs for file/web transaction associations Chris -- don't want to cause an uproar here - since this subject might have been brought up before -- but IMO it would be nice to replace the reconcile column with the attachment column. With the advent of on-line banking and real time charges via online payment services like Paypal -- I have not "reconciled" my "checkbook" in over 10 years. I can check my balance daily; I always know and can see when something clears my account; I always know what the balance available is; and -- I only get online statements. So, again, IMO, the reconcile column is meaningless and should/could be replaced. I have used the reconcile function only once and found it useless -- at least for me. But alas, I know many others will probably disagree. Ken -Original Message- From: gnucash-user On Behalf Of Chris Good Sent: Friday, July 3, 2020 6:06 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] GunCash 4.0 Paper Clip and Link glyphs for file/web transaction associations Hi Adrien, Wow, how did I not notice I used GunCash instead of GnuCash in the subject. I wonder why the glyph is better in Linux than Windows - maybe some-one knows... I wonder if it is possible to somehow install the Ubuntu font or whatever contains the emoji section of Unicode into Windows. The Ubuntu 'Character Map' application shows the glyphs in Unicode category: 'Symbol, Other' under Unicode Block 'Miscellaneous Symbols and Pictographs'. I also wonder why GnuCash writes to the sheet directly rather than using a treeview? I'm currently trying to change it so there is a visual indication of an attachment without having to go into double line view. I cannot get it to make any difference using css but I can use code to change the font to Italic, so now I'm working on how to get it to do that to the Description only when there is an attachment. This seems the best I can do at the moment. Regards, Chris Good Message: 4 Date: Fri, 3 Jul 2020 09:24:40 -0500 From: Adrien Monteleone To: GnuCash Users Subject: Re: [GNC] Message-ID: <38e5d134-3f25-4f25-aa5b-af9ed7020...@lusfiber.net> Content-Type: text/plain; charset=utf-8 The glyphs are part of the emoji section of Unicode. I don?t expect changing the base font is going to affect them. I?m not sure how to specify just an emoji set. I?m also not sure if GTK CSS allows rotations and other transforms like web CSS, but you might give it a try. However, there doesn?t seem to be any CSS hook exposed for the cell where the glyphs are placed on the register sheet, so I don?t think you can target them with specificity. Regards, Adrien > On Jul 3, 2020 w27d185, at 3:31 AM, Chris Good wrote: > > Has anyone figured out how to make the new paper clip and link glyphs > look better in Windows 10? > > In Linux Ubuntu 18.04 they look great but in Windows 10 they look > pretty bad, especially the paper clip. > > Please see attached. > > > > C:\Users\cgood\AppData\Roaming\Gnucash\gtk-3.0.css contains : > > * { > > font: 16px arial, sans-serif; > > } > > > > Changing the font from 'arial' *does* effect most characters but not > the PaperClip or Link glyphs. > > > > Here's the definition of the glyphs from > src/gnucash/register/register-core/assoccell.h > > #define GLYPH_PAPERCLIP "\360\237\223\216" // Codepoint U+1F4CE > > #define GLYPH_LINK "\360\237\224\227" // Codepoint U+1F517 ___ 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/l
Re: [GNC] GunCash 4.0 Paper Clip and Link glyphs for file/web transaction associations
Hi Adrien, Wow, how did I not notice I used GunCash instead of GnuCash in the subject. I wonder why the glyph is better in Linux than Windows - maybe some-one knows... I wonder if it is possible to somehow install the Ubuntu font or whatever contains the emoji section of Unicode into Windows. The Ubuntu 'Character Map' application shows the glyphs in Unicode category: 'Symbol, Other' under Unicode Block 'Miscellaneous Symbols and Pictographs'. I also wonder why GnuCash writes to the sheet directly rather than using a treeview? I'm currently trying to change it so there is a visual indication of an attachment without having to go into double line view. I cannot get it to make any difference using css but I can use code to change the font to Italic, so now I'm working on how to get it to do that to the Description only when there is an attachment. This seems the best I can do at the moment. Regards, Chris Good Message: 4 Date: Fri, 3 Jul 2020 09:24:40 -0500 From: Adrien Monteleone To: GnuCash Users Subject: Re: [GNC] Message-ID: <38e5d134-3f25-4f25-aa5b-af9ed7020...@lusfiber.net> Content-Type: text/plain; charset=utf-8 The glyphs are part of the emoji section of Unicode. I don?t expect changing the base font is going to affect them. I?m not sure how to specify just an emoji set. I?m also not sure if GTK CSS allows rotations and other transforms like web CSS, but you might give it a try. However, there doesn?t seem to be any CSS hook exposed for the cell where the glyphs are placed on the register sheet, so I don?t think you can target them with specificity. Regards, Adrien > On Jul 3, 2020 w27d185, at 3:31 AM, Chris Good wrote: > > Has anyone figured out how to make the new paper clip and link glyphs > look better in Windows 10? > > In Linux Ubuntu 18.04 they look great but in Windows 10 they look > pretty bad, especially the paper clip. > > Please see attached. > > > > C:\Users\cgood\AppData\Roaming\Gnucash\gtk-3.0.css contains : > > * { > > font: 16px arial, sans-serif; > > } > > > > Changing the font from 'arial' *does* effect most characters but not > the PaperClip or Link glyphs. > > > > Here's the definition of the glyphs from > src/gnucash/register/register-core/assoccell.h > > #define GLYPH_PAPERCLIP "\360\237\223\216" // Codepoint U+1F4CE > > #define GLYPH_LINK "\360\237\224\227" // Codepoint U+1F517 ___ 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] GunCash 4.0 Paper Clip and Link glyphs for file/web transaction associations
Has anyone figured out how to make the new paper clip and link glyphs look better in Windows 10? In Linux Ubuntu 18.04 they look great but in Windows 10 they look pretty bad, especially the paper clip. Please see attached. C:\Users\cgood\AppData\Roaming\Gnucash\gtk-3.0.css contains : * { font: 16px arial, sans-serif; } Changing the font from 'arial' *does* effect most characters but not the PaperClip or Link glyphs. Here's the definition of the glyphs from src/gnucash/register/register-core/assoccell.h #define GLYPH_PAPERCLIP "\360\237\223\216" // Codepoint U+1F4CE #define GLYPH_LINK "\360\237\224\227" // Codepoint U+1F517 Regards, Chris Good ___ 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] Error Retrieving Price Quotes - Windows 10
Hi Davy, Looks to me like Bloomberg has changed their website so it no longer works unless you are using it interactively. There’s probably not much Finance::Quote can do about it but it may be useful letting other people know about it by raising an issue at https://github.com/finance-quote/finance-quote/issues I suggest you try to find another source for ALLAMAI:LX. Good luck. Regards, Chris Good From: Davy Roid Sent: Wednesday, 17 June 2020 11:10 AM To: Chris Good Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Error Retrieving Price Quotes - Windows 10 I am still running 3.10. It seems that I am getting the following error from bloomberg.pm <http://bloomberg.pm> When I try to run "perl gnc-fq-dump -v bloomberg ALLAMAI:LX", it returns something like "Are you a Robot?" "We've detected unusual activity from your computer network" "To continue, please click the box below to let us know you're not a robot" Any suggestions? On Wed, Jun 17, 2020 at 8:55 AM Chris Good mailto:goodchri...@gmail.com> > wrote: Message: 1 Date: Wed, 17 Jun 2020 00:37:43 +0800 From: Davy Roid mailto:davyr...@gmail.com> > To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> Subject: [GNC] Error Retrieving Price Quotes - Windows 10 Message-ID: mailto:camylkkeejncwfnut7xxhecjhv7y00anqpzk3o0eht3onefmt%...@mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" I got the following errors while running gnucash --add-price-quotes (under windows environment) WARN Could not kill child process: Access is denied. ERROR There was a system error while retrieving the price quotes. The system was working perfectly fine the day before. I hard reset the PC once as it was completely frozen. Any idea how to fix it ? Davy Hi Davy, Have you just upgraded to GnuCash 3.905? It now gives an error message if you need an Alpha Vantage API key and the args for getting quotes from a batch job have changed. See https://wiki.gnucash.org/wiki/Online_Quotes#Updating_enabled_Quotes_from_out side_GnuCash Try running Get Quotes from within GnuCash to see if there is an error msg. See https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting Regards, Chris Good ___ 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] Get quotes problem with testing version 3.905
Message: 8 Date: Wed, 17 Jun 2020 08:53:24 +0930 From: John Bonnett To: gnucash-user@gnucash.org Subject: Re: [GNC] Get quotes problem with testing version 3.905 Message-ID: Content-Type: text/plain; charset=utf-8; format=flowed Here is my previous email with the graphics replaced by some relevant text. > I installed v3.905 to help with testing. I have a problem with getting > online quotes which worked fine with the latest release version. > Everything else has been OK so far. > > I get this message now: > ERROR:: ALPHAVANTAGE_API_KEY must be set for currency and quotes; see https://wiki.gnucash.org/wiki/Online_Quotes#Source_Alphavantage.2C_US > > Although that URL provides lots of good information, none of my active > stocks, for which I am trying to get online quotes, are using > Alphavantage. I do have some inactive/obsolete stocks which are > defaulting to Alphavantage. Most of my active stocks are from the > Australian exchange ASX. I have one on NASDAQ for which I am using > Yahoo-json but that does not seem to work and did not on the release > version either. Here are the versions in my About dialog: > Version 3.905 Build ID: 3.905+(2020-06-14) Finance::Quote: 1.47 > Should I try to remove all reference to Alphavantage from even > inactive stocks? > > John Bonnett > Hi John, If you haven't got a free Alpha Vantage API key and do have stocks that need it, you either need to get an API key or untick 'Get Quotes' in the security editor for those stocks using source alphavantage. If you have accounts using multiple currencies, then you also need to untick 'Get Quotes' in the security editor for all the currencies if you don't want exchange rates to be downloaded. 3.905 now gives you an error message rather that failing with an obscure error msg. See https://wiki.gnucash.org/wiki/Online_Quotes#Source_Alphavantage.2C_US Regards, Chris Good ___ 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] Price Database
Message: 6 Date: Tue, 16 Jun 2020 17:04:09 -0500 From: Les To: gnucash-user@gnucash.org Subject: [GNC] Price Database Message-ID: Content-Type: text/plain; charset=utf-8; format=flowed Hi All: For at least 2 weeks, I have been unable to obtain a quote for HKD (Hong Kong dollar). Is anyone else having this problem?? Any suggestions? Thanks, Les Linux Mint 19.3? GC 3.10 (Flatpak) Hi Les, Works for me (this is in Linux): ALPHAVANTAGE_API_KEY=ATALQOFWCSKL2VZ4 ./gnc-fq-dump currency HKD AUD 1 HKD = 0.18765 AUD See https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting Regard, Chris Good ___ 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] Error Retrieving Price Quotes - Windows 10
Message: 1 Date: Wed, 17 Jun 2020 00:37:43 +0800 From: Davy Roid To: gnucash-user@gnucash.org Subject: [GNC] Error Retrieving Price Quotes - Windows 10 Message-ID: Content-Type: text/plain; charset="UTF-8" I got the following errors while running gnucash --add-price-quotes (under windows environment) WARN Could not kill child process: Access is denied. ERROR There was a system error while retrieving the price quotes. The system was working perfectly fine the day before. I hard reset the PC once as it was completely frozen. Any idea how to fix it ? Davy Hi Davy, Have you just upgraded to GnuCash 3.905? It now gives an error message if you need an Alpha Vantage API key and the args for getting quotes from a batch job have changed. See https://wiki.gnucash.org/wiki/Online_Quotes#Updating_enabled_Quotes_from_out side_GnuCash Try running Get Quotes from within GnuCash to see if there is an error msg. See https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting Regards, Chris Good ___ 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] Trouble opening ancient files
Message: 5 Date: Mon, 15 Jun 2020 23:56:34 -0500 From: Adrien Monteleone To: GnuCash Users Subject: Re: [GNC] Trouble opening ancient files Message-ID: <23fbb3da-53a4-47c1-99e4-b0a1cac1f...@lusfiber.net> Content-Type: text/plain; charset=utf-8 That first 2002 file is indeed ancient. (the 2005 file is no spring chicken either) For both cases, you?d have to find the ?newest? version of GnuCash that will open each file, then upgrade GnuCash in steps (possibly some leaps skipping bug-fix releases) and open each file with each version. At some point, file conversions will be done so they are readable by newer versions, and not backwards compatible. Eventually you?ll arrive at the 3.x series and then you can jump to 3.10. You?ll have to start this further back for the 2002 file and then eventually you?ll be able to open up each with the same version. You might get lucky and only have to make 2 or three steps. Sorry I can?t help pinpoint a version to target to get started, or help with which versions you can skip. The wiki may provide some help if you dig, (as in reading old change logs) otherwise maybe someone familiar with those older files can help with specifics. Regards, Adrien > On Jun 15, 2020 w25d167, at 3:49 PM, Thomas Klausner wrote: > > Hi! > > I have been using gnucash for a very long time, and recently I tried > opening some of my first files -- but couldn't. Many old files worked, > but not these two and their related .xac files. > > I see two different symptoms. > > One file has an timestamp from 2002. I don't recognize the file > format, it's a binary format, but gzip cannot unpack it > The error I get from gnucash (3.10) is: > > "No suitable backend was found for /path/to/file." > > A hexdump of the file starts with: > > 00 00 00 0a 00 00 00 04 00 00 00 ab 00 08 00 00 || > 0010 00 09 41 75 73 67 61 62 65 6e 00 00 00 00 04 31 |..Ausgaben.1| > 0020 30 30 00 00 00 00 01 00 00 00 00 01 00 00 00 00 |00..| > 0030 04 46 52 46 00 00 00 00 01 00 00 00 00 00 00 00 |.FRF| > 0040 00 01 00 00 00 05 00 00 00 d6 00 08 00 00 00 06 || > 0050 45 73 73 65 6e 00 00 00 00 04 31 31 30 00 00 00 |Essen.110...| > > where I'm quite sure that "Ausgaben" is an account name and FRF is a > unit of currency, so probably Account number 100 in the Unit of FRF. > > > The second file has a timestamp from 2005. It is plaintext XML. The > error from gnucash is: > > "This file/URL appears to be from a newer version of GnuCash. You must > upgrade your version of GnuCash to work with this data." > > The file starts with: > > --- begin quote --- > > > 1 > > 61535f2d2589fccc34164e57b1255f25 > 1 > 38 > 1023 > > NASDAQ > Fond > Fond > 10 > > --- end quote --- > > Then follows a gnc:pricedb and some accounts like > > --- begin quote --- > > Ausgaben > be0508dcdbc39e35f677dd6f334d36e5 > EXPENSE > >ISO4217 >ATS > > 100 > 100 > Ausgaben > > --- end quote --- > > Any suggestions on how to get versions of these files that could be > opened by gnucash 3.10? > > Thank you, > Thomas Hi Thomas, Maybe you're opening the wrong file... GnuCash data files used to be .xac files. See https://wiki.gnucash.org/wiki/FAQ#Basics:_Filenames.2C_Directories.2C_... Also https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgra de Regards, Chris Good ___ 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] --add-price-quotes prints nothing and always fails with no info
-Original Message- From: Chris Good Sent: Saturday, 6 June 2020 5:16 PM To: gnucash-user@gnucash.org Cc: h...@topbug.net Subject: RE: [GNC] --add-price-quotes prints nothing and always fails with no info Message: 4 Date: Fri, 5 Jun 2020 08:44:43 -0700 From: John Ralls To: Hong Xu Cc: gnucash-user@gnucash.org Subject: Re: [GNC] --add-price-quotes prints nothing and always fails with no info Message-ID: Content-Type: text/plain; charset=us-ascii > On Jun 4, 2020, at 2:06 PM, Hong Xu wrote: > > Hi! > > I tried to play with automatic stock price retrieval, but it always > failed (although gnc-fq-dump works well). > > When I run "gnucash --debug --add-price-quotes > /path/to/my/gnucash/file", I got the following output: > > Found Finance::Quote version 1.49. > > Then "echo $?" prints "1". > > gnc-fq-dump works well: > > $ gnc-fq-dump yahoo_json AMZN > Finance::Quote fields Gnucash uses: > symbol: AMZN <=== required > date: 06/04/2020 <=== recommended > currency: USD <=== required > last: 2460.6 <=\ >nav: <=== one of these > price: <=/ > timezone: <=== optional > > Is there any way to get more debug information? My system is Debian > 10, and "gnucash -v" outputs: By default GnuCash logs to a file: https://wiki.gnucash.org/wiki/Tracefile. If you want the output to go to the terminal add `--logto=stderr` to the command line. Regards, John Ralls Hi Hong, (apologies if this is not the correct way to address you) If it works in gnc-fq-dump, but not from Get Quotes button, maybe there is a problem with how the stock is set up in the Security Editor. Please attach (do not paste into message) a screen dump showing the setup in the security editor. Note that (I think) in old versions of GnuCash, a problem with 1 stock could cause them all to fail, so it is worthwhile unticking 'Get Quotes' on all the securities and keep importing and ticking 'Get Quotes' on additional securities to find the problem ones. Regards, Chris Good This of course is assuming they don't already all work from the 'Get Quotes' button... Regards, Chris Good ___ 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] --add-price-quotes prints nothing and always fails with no info
Message: 4 Date: Fri, 5 Jun 2020 08:44:43 -0700 From: John Ralls To: Hong Xu Cc: gnucash-user@gnucash.org Subject: Re: [GNC] --add-price-quotes prints nothing and always fails with no info Message-ID: Content-Type: text/plain; charset=us-ascii > On Jun 4, 2020, at 2:06 PM, Hong Xu wrote: > > Hi! > > I tried to play with automatic stock price retrieval, but it always failed (although gnc-fq-dump works well). > > When I run "gnucash --debug --add-price-quotes /path/to/my/gnucash/file", I got the following output: > > Found Finance::Quote version 1.49. > > Then "echo $?" prints "1". > > gnc-fq-dump works well: > > $ gnc-fq-dump yahoo_json AMZN > Finance::Quote fields Gnucash uses: > symbol: AMZN <=== required > date: 06/04/2020 <=== recommended > currency: USD <=== required > last: 2460.6 <=\ >nav: <=== one of these > price: <=/ > timezone: <=== optional > > Is there any way to get more debug information? My system is Debian 10, and "gnucash -v" outputs: By default GnuCash logs to a file: https://wiki.gnucash.org/wiki/Tracefile. If you want the output to go to the terminal add `--logto=stderr` to the command line. Regards, John Ralls Hi Hong, (apologies if this is not the correct way to address you) If it works in gnc-fq-dump, but not from Get Quotes button, maybe there is a problem with how the stock is set up in the Security Editor. Please attach (do not paste into message) a screen dump showing the setup in the security editor. Note that (I think) in old versions of GnuCash, a problem with 1 stock could cause them all to fail, so it is worthwhile unticking 'Get Quotes' on all the securities and keep importing and ticking 'Get Quotes' on additional securities to find the problem ones. Regards, Chris Good ___ 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] Can Finance::Quote look up bond prices by CUSIP?
Message: 7 Date: Wed, 3 Jun 2020 10:52:18 -0400 From: peterb To: gnucash-user@gnucash.org Subject: [GNC] Can Finance::Quote look up bond prices by CUSIP? Message-ID: Content-Type: text/plain; charset="UTF-8" Can Finance::Quote be used to look up bond prices? If so, how can I configure the security in GnuCash to get this done? A related question is how can I use it to fetch currency prices. Thanks! -Peter Hi Peter, Yes to CUSIP. Please see https://wiki.gnucash.org/wiki/Online_Quotes#Finding_the_right_Source_and_Sym bol If you have stocks in different currencies (I think this works by checking the currency of the parent account as stocks have their own commodity/currency being the stock symbol usually), when you do 'Get Quotes' in the Price Database, GnuCash will also get any currency conversions necessary, and they are visible in the Price Database window. See https://wiki.gnucash.org/wiki/Online_Quotes#Helper_Scripts for gnc-fq-dump commands for getting currency conversion rates. They is plenty of other info in the FAQ, see https://wiki.gnucash.org/wiki/FAQ If you cannot get the prices or currency conversion rates you want, please tell us in this mailing list which specific stocks or currencies you are after. Regards, Chris Good ___ 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] Unable to set start and end date in Income Statement report
Message: 11 Date: Mon, 1 Jun 2020 16:47:06 -0700 From: John Ralls To: stepbystepf...@comcast.net Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Unable to set start and end date in Income Statement report Message-ID: Content-Type: text/plain; charset=us-ascii > On Jun 1, 2020, at 2:01 PM, Michael or Penny Novack wrote: > > >> Yes, I have already tried that. Clicking the dot in the middle does nothing. > > Try again (you are going to laugh at yourself when you get this) > > SOMETIMES this sort of "button" is what is known as "radio", two states, on or off, and you click on it to switch between state. > > BUT also sometimes there are paired buttons, one of which must be on > while the other is off. That is the case here. You get to change which > one is "on" by clicking whichever is "off" << that turns it on and its > partner off >> You got it backwards. A radio button [1] is one of a group of buttons exactly one of which must be selected. A toggle button is called a checkbox [2]. I used w3schools.com references because they have nice demo code built in; the actual controls used in GnuCash are GtkRadioButton [3] and GtkCheckButton [4]. Regards, John Ralls [1] https://www.w3schools.com/tags/att_input_type_radio.asp [2] https://www.w3schools.com/tags/att_input_type_checkbox.asp [3] https://developer.gnome.org/gtk3/stable/GtkRadioButton.html [4] https://developer.gnome.org/gtk3/stable/GtkCheckButton.html Hi, I don't know what version you are using but I seem to remember there was a recent bug that this sounds like. You might like to try upgrading to a more recent version. Regards, Chris Good ___ 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] Finance::Quote source asx or australia
Hi, Last thing I remember was that finance quote source asx or Australia (which are now the same thing since yahoo stopped working) either didn't work or was unreliable. It seems to be working OK now. So I can update the documentation, can people who use either asx or Australia as source for stock quotes please let me know if it is working reliably now. I'd also like to know if it works reliably with say > 10 stocks. If your unhappy about putting this info on the mailing list, please email me directly at goodchri...@gmail.com Regards, Chris Good ___ 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] Probl?me export / import dans GNU CASH
Message: 1 Date: Fri, 29 May 2020 16:01:37 +0200 From: BCT To: "gnucash-user@gnucash.org" Subject: [GNC] Probl?me export / import dans GNU CASH Message-ID: <889c5d198787311429e8375dc54c8...@mwinf5d26.me-wanadoo.net> Content-Type: text/plain; charset="utf-8" Bonjour, Etant nouveau dans une association qui utilisait votre logiciel, j'ai, pour rendre service, fait un export des comptes et des transactions en fichier csv croyant pouvoir importer ces donn?es dans un autre logiciel. Or, ce nouveau logiciel ne correspond pas ? ce que souhaite l'assoc (trop cher). Maintenant la comptable essaye ? nouveau d'utiliser GNU CASH et toutes les transactions, clients et comptes ont disparu. Je pense donc qu'en exportant les data, votre logiciel efface les data de GNU CASH. J'essaye donc de remettre les data via les fichiers exports de GNU CASH mais cela ne fonctionne pas bien. Le log me dit qu'il y a des erreurs (format de date ou nombre de colonnes) et donc je n'arrive plus ? importer ces data. Quelqu'un aurait une id?e sur ce que je pourrais essayer afin de remettre GNU CASH comme avant l'exportation et donc ne pas re-saisir les comptes et transactions ?.. gr.. Merci d'avance. Jean Luc RICURT Provenance?: Courrier pour Windows 10 Bonjour, Avec l'aide de Google Translate (with the help of Google Translate) L'exportation ne supprime pas les transactions de GnuCash. Quelque chose d'autre a dû se produire. Regards, Chris Good ___ 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] AQbanking Amex OFX Download Badly Broken
Message: 5 Date: Sun, 24 May 2020 00:19:33 -0400 From: "Alan" To: "'Gnucash Users'" Subject: [GNC] AQbanking Amex OFX Download Badly Broken Message-ID: <0fbc01d63182$87ba6ea0$972f4be0$@bigtowers.net> Content-Type: text/plain; charset="us-ascii" Tried the Aqbanking section on GnuCash 3.10 with my Amex account. It was encouraging to see the latest version of Aqbanking now recognizes the content in the OFX download (last broken version could only read the headers). Was about to congratulate the development team, but then I noticed something very wrong with the few hundred transactions I had just loaded into GnuCash. None of the payees matched anything that could be matched up with any previously entered, downloaded and audited transactions. Closer inspection revealed something very wrong, and repeated on every transaction record downloaded. I compared individual transactions in my Aqbanking debug log to the ones that GnuCash had downloaded. GnuCash apparently concatenated each memo field followed by a space, followed by the transaction payee name. None of the downloaded data ended up in a valid transaction memo field. This is badly broken, and totally unusable. I examined the debug log to see how well Aqbanking has been communicating with the bank. Headers show the session established and completed properly. Transaction records and fields were being presented correctly, amounts were correctly associated with the real payees, and Amex was proving a fully formed payee name followed by a fully formed memo field . The transaction ID number was also transferred consistently in the field, though GnuCash appears to be ignoring it. Someone had to go to a lot of trouble to do this, rather than just place each usable transaction field data into the closest matching ledger fields (even the transaction ID can be useful for simple dupe checking). That's all that we're looking for. Download the data, populate the record fields, and get back to business. So I'm at a total loss how anyone could have deliberately taken clearly defined fields and data (that should easily match the "Description" and "Notes" fields within GnuCash account ledgers), and pretty much destroy them, along with the user data sets that also have to be deleted and recreated. Hi Alan, I import downloaded .ofx files, as my bank doesn't offer direct connection, but I think GnuCash does the same thing with direct connect as importing a downloaded .ofx file. I believe (but this is just my idea) the fields are imported into the transaction Note field (View, Double Line) in order to not override the split Memo fields on existing transactions. The transaction ID number, if this is supposed to be the unique code for a transaction in an account, should be in an 'FITID' tag. The OFX libraries (libofx) were probably not designed for GnuCash, so we have to map as best we can. It may be worthwhile creating an enhancement type bug specifying how you'd like 'REFNUM' handled. Regards, Chris Good ___ 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] Gnucash logs
From: Geert Janssens Sent: Thursday, 30 April 2020 7:24 PM To: gnucash-user@gnucash.org Cc: Chris Good ; 'David T.' ; 'David H' Subject: Re: [GNC] Gnucash logs Op donderdag 30 april 2020 06:04:10 CEST schreef Chris Good: > Hi Geert, > > > > I think options 2-5 are too disruptive and more work than the benefits > deserve. > > > > Re option 1, > > I’d prefer to put logs and backups in separate folders. Maybe (going with > your name) book.dir/backup and book.dir/log. Many people seem to be > confused about what all these long filenames are when mixed together. > I see I didn't mention this, but that making separate subdirectories for those was also intended in my suggestion. > > > Also putting the metadata (book.gcm) in book.dir would make if hard to > notice, so I think it should be in the folder holding book.gnucash (or > maybe a separate ‘metadata’ subfolder as some people think the metadata > file is their book). I'm not decided on whether this is a good idea yet. I was throwing it in for further consideration. Note that if we do switch to a model with a data file and associated directory for other stuff, the metadata file could just be called that - metadata.gcm. It's already in the directory with the same name as the book. No need to keep that file itself named as the book is. For that matter even the log and backups files could be reduced in file name length to only the timestamp. The same applies, the base directory (book.dir) uniquely identifies which book they belong to. > > Not having all the metadata files for multiple books in the same folder > means it is more fiddly to share metadata between multiple books by giving > the books the same name (books in different directories) but there is > probably nobody doing that anyway (as it is easy to get confused about > which book is open). > Well, actually you can't. GnuCash has guards in place that make each file name in the current metadata directory unique. The filename is just a first indication. The actual match between your book and the metadata file is done by comparing the root account's GUID in your book with the GUID stored in the metadata file. So if you would have two books named "book.gnucash", you will end up with a "books.gcm" and a "books-1.gcm" metadata file. As they are created for diferent books, they will both store a unique GUID. When opening either book, gnucash will check both metadata files for the one that has your book's GUID stored in it. And yes, you could thus circumvent that safety measure by manipulating your books to have the same root account GUID. But that's not what the system was designed for so we can ignore that hack in this discussion :) Regards, Geert > > > Regards, > > Chris Good > > From: Geert Janssens <mailto:geert.gnuc...@kobaltwit.be> > > Sent: Wednesday, 29 April 2020 7:57 PM > To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > Cc: Chris Good mailto:goodchri...@gmail.com> >; > 'David T.' mailto:sunfis...@yahoo.com> >; > 'David H' mailto:hell...@gmail.com> > Subject: Re: [GNC] > Gnucash logs > > Hi, > > For the file based books (xml and sqlite) there are several approaches: > > 1. Have a book.gnucash and a book.dir side by side, per book you create. > > book.gnucash is your actual data file. > > book.dir is a directory containing extra files related to this data file. > These include log files, backup files and can potentially be extended to > hold attachments and possibly book metadata > > Advantages: > > - all data related to one book is stored together in one place. No > intermingling of (meta)data with other books. Makes it easy to move a book > to somewhere else > > - as the main book is outside of the the directory it's easy to spot your > book to open it. > > Disadvantage: per book you will have two items: a file and a directory. At > the file management level you always have to treat them as one (move them > together, back them up together,...) > > 2. Have a directory book.gnucash and store all data in there in a structured > form (logs in their own subdirectory,...). To save a book, you enter the > book's name and gnucash will create that directory for you. Inside the > directory your book will now have a generic name (as the directory already > indicates the unique name) as would log files and backup files. To open a > book, you select the directory in gnucash and it will open the actual book > inside of it for you. Backup management could be integrated in gnucash. > > Advantages: > > - like option 1, all data related to a single b
Re: [GNC] Gnucash logs
Hi Geert, I think options 2-5 are too disruptive and more work than the benefits deserve. Re option 1, I’d prefer to put logs and backups in separate folders. Maybe (going with your name) book.dir/backup and book.dir/log. Many people seem to be confused about what all these long filenames are when mixed together. Also putting the metadata (book.gcm) in book.dir would make if hard to notice, so I think it should be in the folder holding book.gnucash (or maybe a separate ‘metadata’ subfolder as some people think the metadata file is their book). Not having all the metadata files for multiple books in the same folder means it is more fiddly to share metadata between multiple books by giving the books the same name (books in different directories) but there is probably nobody doing that anyway (as it is easy to get confused about which book is open). Regards, Chris Good From: Geert Janssens Sent: Wednesday, 29 April 2020 7:57 PM To: gnucash-user@gnucash.org Cc: Chris Good ; 'David T.' ; 'David H' Subject: Re: [GNC] Gnucash logs Hi, For the file based books (xml and sqlite) there are several approaches: 1. Have a book.gnucash and a book.dir side by side, per book you create. book.gnucash is your actual data file. book.dir is a directory containing extra files related to this data file. These include log files, backup files and can potentially be extended to hold attachments and possibly book metadata Advantages: - all data related to one book is stored together in one place. No intermingling of (meta)data with other books. Makes it easy to move a book to somewhere else - as the main book is outside of the the directory it's easy to spot your book to open it. Disadvantage: per book you will have two items: a file and a directory. At the file management level you always have to treat them as one (move them together, back them up together,...) 2. Have a directory book.gnucash and store all data in there in a structured form (logs in their own subdirectory,...). To save a book, you enter the book's name and gnucash will create that directory for you. Inside the directory your book will now have a generic name (as the directory already indicates the unique name) as would log files and backup files. To open a book, you select the directory in gnucash and it will open the actual book inside of it for you. Backup management could be integrated in gnucash. Advantages: - like option 1, all data related to a single book is encapsulated closely together. - only one single element on the file system level to remember: the book.dir is your book. Makes it slightly easier to move things around, make backups and so on. Disadvantage: double-clicking a file to open it in gnucash will no longer work. The file manager will just open the directory for you and the data in there is now private to gnucash. You could argue that you can make a double-click on the book file inside the directory would then open gnucash for you. It could at the expense of vastly more complicated load code. It now has to check for both a file or directory being opened and do the right thing in both cases. 3 Same as 2, except this time the directory will be zipped. Advantages: - like option 1, all data related to a single book is encapsulated closely together. - only one single element on the file system level to remember: the book.dir is your book. Makes it slightly easier to move things around, make backups and so on. - double-click would work again Disadvantages: - The single file could become rather huge. Particularly if you also choose to include the attachments in there - Manual backup and log management becomes harder (one has to know how to unzip the gnucash file, akin to how libreoffice documents are zipped up directories) - Embedding backups directly in the data file feels wrong. 4. The approach where one single global log directory is created (like in GNC_DATA_DIR) and one single global backup directory. All log and backup files will be written to these global directories. Advantages: - the directory containing your book(s) will be fully uncluttered. It will effectively only contain your book(s). No more backups or logs. So easy on the eye and easy to understand. As you don't need backups often, you can find them when needed. Disadvantages: - your book and its backups get separated. So if you need to manage your backups you have to search for them in another directory - if you have multiple books the logs/backups of all books get lumped together. For backup or cleanup purposes this is more messy. You have to take care to only select the backups/logs for the books you are interested in. - a real risk of file name clashes. If you have two same-named books in separate directories, their logs and backups will overlap or even conflict. There are technical solutions for this (we use one for the metadata files) but it's cludgy. 5
Re: [GNC] Gnucash logs
-Original Message- From: David T. Sent: Wednesday, 29 April 2020 4:11 PM To: Chris Good ; 'David H' Cc: 'Gnucash Users' Subject: Re: [GNC] Gnucash logs If the setting were per book and user-configurable, then a user could choose to set each data file to use a different set of folders, by changing the file default from "logs" to "logs-file1" Does the Attachments functionality provide a blueprint for how this could work for backups and logs? It seems to me that there is a setting somewhere that allows the user to point to a particular folder for external file association (although my attempts at locating that setting have failed). But your point about the logs and backups having different filenames is apt as well. David T. On 4/29/2020 8:55 AM, Chris Good wrote: > From: David H > Sent: Wednesday, 29 April 2020 12:49 PM > To: Chris Good > Cc: Gnucash Users > Subject: Re: [GNC] Gnucash logs > > > > Chris, > > > > How would you see this working with my 2 data files that I have in the same > gnucash folder ??? Would the subdirectory(ies) include the name of the data > file to clearly identify them or would all log/backup files be lumped in > together in a single subdirectory ? When I save my gnucash file under > another name using save as would it create the required subdirectories for > the new data file if they are separate subdirectories ? > > > > My own situation is that I've set the log files to be deleted after 30 days > which seems to work on Mac Catalina. My data files are in a dedicated folder > in my Documents folder and I must confess that I have NEVER had a need to go > looking for backup files or log files since starting with Gnucash in 2010. > > > > Cheers David Halverson. > > > > On Wed, 29 Apr 2020 at 11:48, Chris Good <mailto:goodchri...@gmail.com> > wrote: > > Original Message > From: Michael or Penny Novack <mailto:stepbystepf...@comcast.net> > > Sent: Tue Apr 28 22:11:04 GMT+05:30 2020 > To: "D." mailto:sunfis...@yahoo.com> > > Cc: Gnucash Users <mailto:gnucash-user@gnucash.org> > > Subject: Re: [GNC] Gnucash logs > > On 4/27/2020 10:50 PM, D. wrote: >> Michael, >> >> I take your point; we users will often create duplicated file names >> for > different content. I believe that many users only keep one set of > books. I don't have any statistics on general GnuCash usage to be able > to say whether more users have one file or many. >> However, given that operating systems prevent identical file names to >> coexist in a folder, it would seem to me that there is a simple >> remedy to overlapping log files: per book log folder settings. In >> your case, business1financials/ledger.gnucash would use >> business1financials/logs and organization1financials/ledger.gnucash >> would use organization1financials/logs >> >> Problem solved. >> > Yes, but that is solving the problem by a different method (not > writing the log files to a dedicated directory for all log files but > writing them into a subdirectory of the directory containing the data file). > Would be easy for gnucash when starting to check for the existence of > this subdirectory, if not there, create it. Much as it checks for the > existence of a lock file. > > Had THAT been suggested you would not have seen an objection from me. > But about "almost all users have only one set of books" I have to laugh. > If all those rare situations never existed, designing/writing software > would be a snap. Software solution have to ALWAYS work. A commonly > quoted rule of rule of thumb, 80% of the design/write time will be > handling just 20% of the cases, but in my experience, 50% of the time > will be handling those that are 1% or less. > > Michael > > Hi, > > I like the idea of putting logs in a 'log' subdirectory of the data > file folder and also putting the backups in a 'backup' subdirectory of > the data file folder. GnuCash would create these on startup if needed. > > If I could get general approval in principle, I could even start work on it. > > Regards, Chris Good > > ___ > > > > Hi David H, > > > > The backup filenames and log filenames already include the book name and I > see no reason to change that. > > People could still have multiple books in the same directory, although I > suggest best practice is to put each book’s data file in a separate directory. > > > > Regards, Chris Good > Hi David T, Adding new options and a directory selection dialog seems like a lot of extra work,
Re: [GNC] Gnucash logs
From: David H Sent: Wednesday, 29 April 2020 12:49 PM To: Chris Good Cc: Gnucash Users Subject: Re: [GNC] Gnucash logs Chris, How would you see this working with my 2 data files that I have in the same gnucash folder ??? Would the subdirectory(ies) include the name of the data file to clearly identify them or would all log/backup files be lumped in together in a single subdirectory ? When I save my gnucash file under another name using save as would it create the required subdirectories for the new data file if they are separate subdirectories ? My own situation is that I've set the log files to be deleted after 30 days which seems to work on Mac Catalina. My data files are in a dedicated folder in my Documents folder and I must confess that I have NEVER had a need to go looking for backup files or log files since starting with Gnucash in 2010. Cheers David Halverson. On Wed, 29 Apr 2020 at 11:48, Chris Good mailto:goodchri...@gmail.com> > wrote: Original Message From: Michael or Penny Novack mailto:stepbystepf...@comcast.net> > Sent: Tue Apr 28 22:11:04 GMT+05:30 2020 To: "D." mailto:sunfis...@yahoo.com> > Cc: Gnucash Users mailto:gnucash-user@gnucash.org> > Subject: Re: [GNC] Gnucash logs On 4/27/2020 10:50 PM, D. wrote: > Michael, > > I take your point; we users will often create duplicated file names for different content. I believe that many users only keep one set of books. I don't have any statistics on general GnuCash usage to be able to say whether more users have one file or many. > > However, given that operating systems prevent identical file names to > coexist in a folder, it would seem to me that there is a simple remedy > to overlapping log files: per book log folder settings. In your case, > business1financials/ledger.gnucash would use business1financials/logs > and organization1financials/ledger.gnucash would use > organization1financials/logs > > Problem solved. > Yes, but that is solving the problem by a different method (not writing the log files to a dedicated directory for all log files but writing them into a subdirectory of the directory containing the data file). Would be easy for gnucash when starting to check for the existence of this subdirectory, if not there, create it. Much as it checks for the existence of a lock file. Had THAT been suggested you would not have seen an objection from me. But about "almost all users have only one set of books" I have to laugh. If all those rare situations never existed, designing/writing software would be a snap. Software solution have to ALWAYS work. A commonly quoted rule of rule of thumb, 80% of the design/write time will be handling just 20% of the cases, but in my experience, 50% of the time will be handling those that are 1% or less. Michael Hi, I like the idea of putting logs in a 'log' subdirectory of the data file folder and also putting the backups in a 'backup' subdirectory of the data file folder. GnuCash would create these on startup if needed. If I could get general approval in principle, I could even start work on it. Regards, Chris Good ___ Hi David H, The backup filenames and log filenames already include the book name and I see no reason to change that. People could still have multiple books in the same directory, although I suggest best practice is to put each book’s data file in a separate directory. Regards, Chris Good ___ 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] Gnucash logs
Original Message From: Michael or Penny Novack Sent: Tue Apr 28 22:11:04 GMT+05:30 2020 To: "D." Cc: Gnucash Users Subject: Re: [GNC] Gnucash logs On 4/27/2020 10:50 PM, D. wrote: > Michael, > > I take your point; we users will often create duplicated file names for different content. I believe that many users only keep one set of books. I don't have any statistics on general GnuCash usage to be able to say whether more users have one file or many. > > However, given that operating systems prevent identical file names to > coexist in a folder, it would seem to me that there is a simple remedy > to overlapping log files: per book log folder settings. In your case, > business1financials/ledger.gnucash would use business1financials/logs > and organization1financials/ledger.gnucash would use > organization1financials/logs > > Problem solved. > Yes, but that is solving the problem by a different method (not writing the log files to a dedicated directory for all log files but writing them into a subdirectory of the directory containing the data file). Would be easy for gnucash when starting to check for the existence of this subdirectory, if not there, create it. Much as it checks for the existence of a lock file. Had THAT been suggested you would not have seen an objection from me. But about "almost all users have only one set of books" I have to laugh. If all those rare situations never existed, designing/writing software would be a snap. Software solution have to ALWAYS work. A commonly quoted rule of rule of thumb, 80% of the design/write time will be handling just 20% of the cases, but in my experience, 50% of the time will be handling those that are 1% or less. Michael Hi, I like the idea of putting logs in a 'log' subdirectory of the data file folder and also putting the backups in a 'backup' subdirectory of the data file folder. GnuCash would create these on startup if needed. If I could get general approval in principle, I could even start work on it. Regards, Chris Good ___ 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] Missing Bank Interest Transactions When Importing with QFX
Message: 2 Date: Mon, 27 Apr 2020 18:51:41 -0700 From: Keith Fetterman To: GnuCash users group Subject: [GNC] Missing Bank Interest Transactions When Importing with QFX Message-ID: <5fc46e9e-f08a-4ba1-b13e-0dad30c1f...@gmail.com> Content-Type: text/plain; charset=us-ascii When I import the transactions from my bank using QFX, the small interest transactions are not appearing in the import screen? The amounts are usually less than a $1 dollar. Does anyone know why this is? Is there a threshold somewhere that might be filtering them out? I discovered it with GnuCash 3.8 and 3.9 on MacOS. Hi Keith, Perhaps they are not being imported because the transaction has the same as a previous transaction? FITID's must be unique for each transaction in an account. Is your bank ING? The interest transactions from ING Australia bank have this problem. I have a java program that I run on my .ofx file before I import into GnuCash to fix this problem. QFX is effectively the same as OFX I believe. See https://github.com/goodvibes2/IngAusOfxFixLinux Or https://github.com/goodvibes2/IngAusOfxFixWin Note my fix program has not been tested in MacOS but should work. Regards, Chris Good ___ 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] Unable to download more than 5 currency exchange rates
Hi Davy, The problem with doing too many currency lookups in a short time should be fixed in Finance::Quote 1.50 but I don't think there is any schedule for when that will be. The last part of the fix was committed on Mar 22, see https://github.com/finance-quote/finance-quote/commits/master Regards, Chris Good Message: 7 Date: Mon, 27 Apr 2020 12:56:09 +0800 From: Davy Roid To: gnucash-user@gnucash.org Subject: Re: [GNC] Unable to download more than 5 currency exchange rates Message-ID: Content-Type: text/plain; charset="UTF-8" I learnt this from AlphaVantage.pm and it may not be the best solution. Adding a sleep(13) statement right before the" my $reply = $us->request" (at around line 262) in the Quote.pm will solve the problem. On Sun, Apr 26, 2020, 16:38 davygc wrote: > Again, I am new to GC. I am trying to setup the chart of account and is > facing a problem - unable to download more than 5 currencies exchange rate. > I did some experiments. I was unable to download the exchange rate after I > removed the Alpha Vantage API key. Therefore, I guess the exchange rate is > handled by Alpha Vantage. But on the other hand, I was able to download 5 > currencies + 2 stock price through Alphavantage. When I disabled some of > the > currencies, then I will be able to download the rest (still up to a total > of > 5). > > It seems that the quote for exchange rate is not handled by Alphavantage.pm > and the cause of the problem is the limitation of 5 quote per minute. > > Any suggestion? > Also, which script is responsible for downloading the exchange quote? > > Thanks. > > > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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] Backdated manual price entries
Message: 5 Date: Tue, 31 Mar 2020 10:01:25 -0500 From: David Carlson To: James Edmunds Cc: "gnucash-user@gnucash.org" Subject: Re: [GNC] Backdated manual price entries Message-ID: Content-Type: text/plain; charset="UTF-8" Jimmy, Are you using the Price Database editor? That doesn't even know whether you own shares. On Tue, Mar 31, 2020 at 9:13 AM James Edmunds wrote: > I use F:Q 1.49 and GNC 2.6.12 running on Ubuntu 16.04 . I upgraded > from Ubuntu 14.04 to 16.04 in August 2019 , During the upgrade I > removed the existing GNC 2.6.12 ( from Ubuntu 14.04 ) using the Ubuntu > Software Centre and installed GNC 2.6.12 ( from Ubuntu 16.04 ) using > the Ubuntu Software Centre. > > > In both 14.04 and 16.04 I successfully used F:Q to upload prices for > all of my securities which I had set ? Get online quotes? and most of > currencies which I had set ? Get online quotes? most of the time . > > > Up to early 2019 I was able to manually input back dated prices for > both securities and currencies > > eg input a 31 Dec 19 price in Mar 2020. > > > Now I am not able to do this . I do not know the exact date of the change. > > > I find that for securities I can only input a backdated price if there > are no holdings in the security. > > > For currencies I can input a backdated price for some currencies but > not others I cannot. > > > Any help or suggestion would be appreciated. > > ___ > 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 -- Hi Jimmy, There were several bugs in the Price Database that have been fixed. Eg https://bugs.gnucash.org/show_bug.cgi?id=797046 fixed in late 3.4 maint builds. Unfortunately Ubuntu 18.04 only has Gnucash 2.6.21, 19.10 (unstable) has 3.7 and 20.04 will have 3.8b. 3.7 should have all the fixes you need. I suggest upgrading to Ubuntu 19.10 or wait for 20.04, or try flatpack, or compile from source... See https://code.gnucash.org/builds/flatpak/maint/ Regards, Chris Good ___ 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] IngAusOfxFix updated for Java 11 + 2 new features - Release 2.01
Hi, I've updated my IngAusOfxFix app to java 11 which is the default version of java on Ubuntu 18.04 and derivatives like Mint 19, so it is no longer necessary to 'hold' Linux java packages at Java 8. IngAusOfxFix is my app that fixes problems in .ofx files from ING Australia so that they can be imported into GnuCash. The new IngAusOfxFix version is 2.01. As the V2.01 app is now a modular java app, it is distributed as a runtime image which includes the required java runtime, so it is not necessary to have java installed on your system. There are 2 new features also: 1. There is an option to split the input data into (company name which gets imported into GnuCash transaction 'Description' field), and (the rest of gets imported into the 'Memo' field of the bank account split). Without a field in a transaction, GnuCash duplicates the field in both the transaction 'Description' and the 'Memo' field of the bank account split. 2. Replace bad tag in the with a space as it causes GnuCash to fail to import the field. Please see: Linux: https://github.com/goodvibes2/IngAusOfxFixLinux Windows: https://github.com/goodvibes2/IngAusOfxFixWin Regards, Chris Good <>___ 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] BackupGnuCash updated for Java 11
Hi, I've updated my BackupGnuCash app for java 11 which is the default version of java on Ubuntu 18.04 and derivatives like Mint 19. As the app is now a modular java app, it is distributed as a runtime image which includes the required java runtime, so it is not necessary to have java installed on your system. The new BackupGnuCash version is 2.0.0. Please see: Linux: https://github.com/goodvibes2/BackupGnuCashLinux/tree/master/src/backupgnuca sh Windows: https://github.com/goodvibes2/BackupGnuCashWin/tree/master/src/backupgnucash Regards, Chris Good ___ 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] Duplicate emails in GnuCash Digests
> On 5 Feb 2020, at 6:11 AM, Derek Atkins wrote: > > Hi Chris, > This is the first I've heard of this issue. > I will take a look at it, but I do not have time immediately to do so. > Have you seen any pattern in the duplication? Certain people, or > certain sources? Maybe someone who uses nabble or gmane? > Thanks for reporting. > -derek > > "Chris Good" writes: > >> Hi, >> >> For quite a while now (at least several months), there have duplicated >> emails in the GnuCash digests. >> For instance, in the email below message 3 is a duplicate of 2, and 6 is a >> duplicate of 5. >> >> It doesn't seem to happen all the time but I often notice this for emails >> from D, Geert and John Ralls, although John Ralls' message 4 here is not >> duplicated. >> >> I'd really appreciate it if someone could fix this. >> >> Regards, >> Chris Good Hi Derek, Thanks for looking at this. Unfortunately, the only thing I can see in common, is that the duplicates seem to be often from the same people. Most often, D & Geert. Regards, Chris Good ___ 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] Duplicate emails in GnuCash Digests
Hi, For quite a while now (at least several months), there have duplicated emails in the GnuCash digests. For instance, in the email below message 3 is a duplicate of 2, and 6 is a duplicate of 5. It doesn't seem to happen all the time but I often notice this for emails from D, Geert and John Ralls, although John Ralls' message 4 here is not duplicated. I'd really appreciate it if someone could fix this. Regards, Chris Good -Original Message- From: gnucash-user On Behalf Of gnucash-user-requ...@gnucash.org Sent: Saturday, 1 February 2020 4:00 AM To: gnucash-user@gnucash.org Subject: gnucash-user Digest, Vol 202, Issue 74 Send gnucash-user mailing list submissions to gnucash-user@gnucash.org To subscribe or unsubscribe via the World Wide Web, visit https://lists.gnucash.org/mailman/listinfo/gnucash-user or, via email, send a message with subject or body 'help' to gnucash-user-requ...@gnucash.org You can reach the person managing the list at gnucash-user-ow...@gnucash.org When replying, please edit your Subject line so it is more specific than "Re: Contents of gnucash-user digest..." Today's Topics: 1. Access the Company Name in python (gc...@nailedtotheperch.com) 2. Re: Edit number of recently opened books (D) 3. Re: Edit number of recently opened books (D) 4. Re: Edit number of recently opened books (John Ralls) 5. Re: Edit number of recently opened books (D) 6. Re: Edit number of recently opened books (D) -- Message: 1 Date: Thu, 30 Jan 2020 17:41:59 -0400 From: gc...@nailedtotheperch.com To: gnucash-user@gnucash.org Subject: [GNC] Access the Company Name in python Message-ID: <76b8557c7e16096b559c3066b5dd7...@nailedtotheperch.com> Content-Type: text/plain; charset=US-ASCII; format=flowed What is the most straight forward way to access (read) the company name in python. I can see it the XML, but that seems a little fragile. I'm talking about the company name entered in File->Properties->Book Option->Business not a Vendor or Customer Name. Could somebody give me a quick pointer to the module and method. Thanks -- Message: 2 Date: Fri, 31 Jan 2020 08:47:07 +0530 From: D To: Greg W Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Edit number of recently opened books Message-ID: <7d2db7fd-084d-487a-91fc-e431cdec4...@yahoo.com> Content-Type: text/plain; charset=UTF-8 Have you tried this: https://www.howtogeek.com/231700/how-to-change-the-number-of-recent-items-in -os-x/ On Jan 31, 2020, 01:43, at 01:43, Greg W wrote: >I've tried searching around and haven't found anywhere that seems to >suggest how to edit then number of recently opened books that show up >in the File menu on OSX: > >[image: Menubar.png] >Can I change that 4 to a 6 or more somehow? > >Thanks, >Greg > > >--- >- > >___ >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. -- Message: 3 Date: Fri, 31 Jan 2020 08:47:07 +0530 From: D To: Greg W Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Edit number of recently opened books Message-ID: <7d2db7fd-084d-487a-91fc-e431cdec4...@yahoo.com> Content-Type: text/plain; charset=UTF-8 Have you tried this: https://www.howtogeek.com/231700/how-to-change-the-number-of-recent-items-in -os-x/ On Jan 31, 2020, 01:43, at 01:43, Greg W wrote: >I've tried searching around and haven't found anywhere that seems to >suggest how to edit then number of recently opened books that show up >in the File menu on OSX: > >[image: Menubar.png] >Can I change that 4 to a 6 or more somehow? > >Thanks, >Greg > > >--- >- > >___ >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. -- Message: 4 Date: Thu, 30 Jan 2020 19:23:02 -0800 From: John Ralls To: D Cc: Greg W , gnucash-user@gnucash.org S
Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions
As when I originally replied to this thread, it seems there was some special non printable character in the subject ( from when I copy/pasted/edited the subject on my iPad) that caused the subject to become "(no subject)", I am reposting this with (hopefully) the correct subject so the posts appear together in the mail archive. Regards, Chris Good Message: 11 Date: Sun, 10 Nov 2019 06:31:07 +1000 From: David H To: Chris Good Cc: Gnucash Users Subject: Re: [GNC] (no subject) Message-ID: Content-Type: text/plain; charset="UTF-8" Chris, You are correct, highlight tab you want in a new window and click Windows >> New Window with Page. Cheers Dave H. On Sun, 10 Nov 2019 at 06:24, Chris Good wrote: > Hi Fran, > > Something I didn't realize you could do for a long time was to open 2 > reports in separate side by side windows so you can easily visually compare > them. I'm not at my computer now but I think the options to do this are > under the Window or View menus. > > Regards, > > Chris Good > --- > > > > Message: 8 > > Date: Sat, 9 Nov 2019 18:17:02 + (UTC) > > From: Fran_3 > > To: Gnucash Users , Adrien Monteleone > > > > Subject: Re: [GNC] How to compare 2 Transaction Reports to find orphan > >transactions > > Message-ID: <1766876513.1811024.1573323422...@mail.yahoo.com> > > Content-Type: text/plain; charset=UTF-8 > > > > Adrian, you said... "instead do a Find operation then run an Account > Report instead of a Transaction Report. (since Find can filter on more > fields)" > > My comment: > > I did not know about the "Account Report"? option... It seems it only > appears under the Reports Menu if you are looking at a register (aka > account)... like the check register or AP or AR register... or after you do > a Ctl F (Find) operation... > > This is very useful. > > Thanks for this tip Adrian ! > > Fran3 > > > >On Saturday, November 9, 2019, 10:14:16 AM EST, Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > > > I would say consider the criteria you used to create the set of > transactions for each report, then try to craft a report using the options > that gives you only those that don?t lie in the joint set. > > > > If *every* transaction on both reports is between two and only the *same > two* accounts then you might do better with using regex and/or instead do a > Find operation then run an Account Report instead of a Transaction Report. > (since Find can filter on more fields) > > > > My personal mileage is better with running Find operations from the > Accounts tab rather than a particular register. > > > > If however, the two reports have transactions all sharing one account in > common (say checking) but not other splits, you might want to investigate > the Account Filter option. So while filtering on other data might appear to > get you what you want, sometimes filtering by the ?other? split narrows > things down much faster. With a Transaction Report (as opposed to Find then > Account Report) you can filter based on including or not including > transactions which have splits in other accounts. > > > > Otherwise, the spreadsheet approach is likely the simplest. If you know > how to use command-line tools, you could use the spreadsheet step just for > saving in CSV format, then using a cli `diff` tool to show you what is > different between the two files. (MacOS as well as most if not all BSD & > Linux distributions have this built-in. I?m not sure about Windows) > > > > Such tools are very fast and each one has its own features. The output > takes some getting used to as most are not super ?clean? on screen, but > once you do it enough, you?ll be able to use them more effectively. > > > > You could jump straight to using `diff` and get used to it, and it will > help get the job done, but the better option is to think carefully about > what you are trying to find and then crafting a Find or Report that gets > you there from within GnuCash. > > > > Regards, > > Adrien > > > > > > > >> On Nov 9, 2019 w45d313, at 8:53 AM, Fran_3 via gnucash-user < > gnucash-user@gnucash.org> wrote: > >> > >> I want to compare Transaction Report A to Transaction Report B > >> and find transactions that appear on one report but not on the other... > aka orphan transactions > >> In past I have either... > >> - Done a screen capture of each, pasted them side by side in PC Paint > and marked off matching transactions one by one... > >> - Or printed them out and done the same with pen
[GNC] (no subject)
Hi Fran, Something I didn't realize you could do for a long time was to open 2 reports in separate side by side windows so you can easily visually compare them. I'm not at my computer now but I think the options to do this are under the Window or View menus. Regards, Chris Good --- > > Message: 8 > Date: Sat, 9 Nov 2019 18:17:02 + (UTC) > From: Fran_3 > To: Gnucash Users , Adrien Monteleone > > Subject: Re: [GNC] How to compare 2 Transaction Reports to find orphan >transactions > Message-ID: <1766876513.1811024.1573323422...@mail.yahoo.com> > Content-Type: text/plain; charset=UTF-8 > > Adrian, you said... "instead do a Find operation then run an Account Report > instead of a Transaction Report. (since Find can filter on more fields)" > My comment: > I did not know about the "Account Report"? option... It seems it only appears > under the Reports Menu if you are looking at a register (aka account)... like > the check register or AP or AR register... or after you do a Ctl F (Find) > operation... > This is very useful. > Thanks for this tip Adrian ! > Fran3 > >On Saturday, November 9, 2019, 10:14:16 AM EST, Adrien Monteleone > wrote: > > I would say consider the criteria you used to create the set of transactions > for each report, then try to craft a report using the options that gives you > only those that don?t lie in the joint set. > > If *every* transaction on both reports is between two and only the *same two* > accounts then you might do better with using regex and/or instead do a Find > operation then run an Account Report instead of a Transaction Report. (since > Find can filter on more fields) > > My personal mileage is better with running Find operations from the Accounts > tab rather than a particular register. > > If however, the two reports have transactions all sharing one account in > common (say checking) but not other splits, you might want to investigate the > Account Filter option. So while filtering on other data might appear to get > you what you want, sometimes filtering by the ?other? split narrows things > down much faster. With a Transaction Report (as opposed to Find then Account > Report) you can filter based on including or not including transactions which > have splits in other accounts. > > Otherwise, the spreadsheet approach is likely the simplest. If you know how > to use command-line tools, you could use the spreadsheet step just for saving > in CSV format, then using a cli `diff` tool to show you what is different > between the two files. (MacOS as well as most if not all BSD & Linux > distributions have this built-in. I?m not sure about Windows) > > Such tools are very fast and each one has its own features. The output takes > some getting used to as most are not super ?clean? on screen, but once you do > it enough, you?ll be able to use them more effectively. > > You could jump straight to using `diff` and get used to it, and it will help > get the job done, but the better option is to think carefully about what you > are trying to find and then crafting a Find or Report that gets you there > from within GnuCash. > > Regards, > Adrien > > > >> On Nov 9, 2019 w45d313, at 8:53 AM, Fran_3 via gnucash-user >> wrote: >> >> I want to compare Transaction Report A to Transaction Report B >> and find transactions that appear on one report but not on the other... aka >> orphan transactions >> In past I have either... >> - Done a screen capture of each, pasted them side by side in PC Paint and >> marked off matching transactions one by one... >> - Or printed them out and done the same with pen & paper >> - Or exported the reports and then imported them into a spreadsheet and >> marked matching transactions one by one >> All of this is a bunch of work... >> >> Is there an easier way? >> Thanks for any help - Fran3 ___ 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] How to find transactions where any split in register has a memo containing xxxx
Hi, >From a register, I want to find (Control-F) all transactions in the current register that have a split with a memo containing say ''. GnuCash seems it only looks in splits for the register account? I would expect it to look in splits for all accounts in the register. I have tried the 'Account' and 'All Accounts' options but no joy. GnuCash 3.6 on Windows. I cannot find any fixed 3.6 or 3.7 bugs that seem to be relevant. Regards, Chris Good ___ 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] Newbie Q: some transactions imported to wrong
Message: 10 Date: Sat, 7 Sep 2019 18:23:02 -0500 (CDT) From: David Cousens To: gnucash-user@gnucash.org Subject: Re: [GNC] Newbie Q: some transactions imported to wrong category Message-ID: <1567898582174-0.p...@n4.nabble.com> Content-Type: text/plain; charset=us-ascii Bitmancer, If you open the regster for the account to which you imported the transactions. If you set the preferences using Edit->Preferences->Register defaults and set the Auto-split register radio button when you click on a transaction line, it will open to display both splits of the transaction on separate lines. If you click on the account you wish to change adown arrow appears on the right handside and clicking on that will open an account tree display in which you can select the desired destination account. GnuCash does not have categories but expense and income accounts serve the same purpose and you can create groups of expense accounts. For future reference when you are importing transactions GnuCash has a matcher which will try to assign that account on the basis of past account assignments. That information is stored when you click OK in the matcher to complete the import so if you have not assigned the correct accounts in the matcher process before importing them, that information will not be stored. Hence future imports will continue to be assigned to the wrong accounts on import. The matcher uses a statistical process to match the accounts and it can be "trained" by importing more data correctly. Assigning the correct account from the register rather than in the import matcher will not train the matcher to correctly assign the transfer accounts. Under Edit->Preferences->Online Banking you will find a setting "use bayesian matching". which should be set. I think it is the default. Other wise it uses a simpler and less adaptive method to assign the account. David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html Hi Bitmancer, If you're using GnuCash V3.x, you can also use Tools, Import Map Editor to delete entries that are causing mapping to wrong account name. Regards, Chris Good ___ 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] GC CTD lost saved reports
> > > Message: 4 > Date: Sun, 02 Jun 2019 22:34:14 +0200 > From: Geert Janssens > To: gnucash-user@gnucash.org > Cc: Elmar > Subject: Re: [GNC] GC CTD lost saved reports > Message-ID: <2151924.l4l8crl...@legolas.kobaltwit.lan> > Content-Type: text/plain; charset="us-ascii" > > Op zondag 2 juni 2019 20:37:44 CEST schreef Elmar: >> OK, this is a weird. I was editing some of the options in a report, >> specifically unhighlighting one account and highlighting another to >> include, and tried to save the report. GC crashed to desktop. >> Reopening it (open anyway), now GC tells me that I have no saved reports >> at all! Looking in .gnucash folder, I see saved-reports-2.4 (and its >> backup file) dated in 2018, so they are there, and they are in the >> backup 7zip archive dated 15APR2019 (created by BackupGnuCash.jar along >> with the .gnucash.gcm and the .gnucash files itself). OTOH aqbanking >> works fine. This is GC 3.5 running under Linux Mint 19.1 Mate desktop. >> How do I get my reports back? - Elmar > > For gnucash 3.x and up gnucash looks for this file in > $HOME/.local/share/gnucash > Are files in that directory also backed up by BackupGnuCash.jar ? You should > restore to that directory as well if you want gnucash to find your saved > reports again. > > Regards, > > Geert Hi Elmar and Geert, Yes latest BackupGnuCash (1.3.1) handles all the default locations for GnuCash 3.x Configuration files. See https://github.com/goodvibes2/BackupGnuCashLinux Or https://github.com/goodvibes2/BackupGnuCashWin Regards, Chris Good ___ 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] Fwd: Bonus share entry
-Original Message- From: D Sent: Thursday, 7 March 2019 12:26 PM To: Chris Good ; Gnucash Users Subject: Re: [GNC] Fwd: Bonus share entry Chris, That's a bad idea. It messes up the lots as you note, it screws up the acquisition dates (important for tax purposes in the US), and ultimately it's not what happened. Since it is possible to add zero cost shares using tab (instead of enter), there is no reason to use this approach. You certainly don't *have* to use it. David On March 7, 2019, at 2:29 AM, Chris Good wrote: Message: 6 > Date: Wed, 6 Mar 2019 22:00:16 +1030 > From: Gnucash Xboxboy Mageia > To: Derek Atkins > Cc: gnucash-user@gnucash.org > Subject: Re: [GNC] Fwd: Bonus share entry > Message-ID: > > > Content-Type: text/plain; charset="utf-8" > >> On Wed, Mar 6, 2019 at 9:38 PM Derek Atkins wrote: >> >> The cost may be zero, but the value is not. >> Maybe just enter them as 0.01? >> >> -derek >> Sent using my mobile device. Please excuse any typos. >> On March 6, 2019 6:07:28 AM Gnucash Xboxboy Mageia >> wrote: >> >>> Hi all, >>> I have some bonus shares that were issued with no cost to me: >>> >>> I am having trouble entering them without a cost. When I put 0 as >>> the >> cost, >>> on the next line 1 appears, and I am unable to get rid of it. >>> >>> Perhaps I'm doing this the wrong way, and need to be entering them >>> as a share split? >>> >>> In this case, I had 100 shares, and got issued 16 for no cost: so I >>> have >>> 116 in total. >>> >>> Any ideas? >>> >>> Thanks, >>> Xboxboy >>> ___ >>> 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. > Hi Derek, > > I've attached a picture, I don't think I'm explaining very well. > > Please see attached. > > What can I do about that imbalance line? > Many thanks, > Xboxboy > -- next part -- A non-text attachment was > scrubbed... > Name: Screenshot_20190306_215426.png > Type: image/png > Size: 34424 bytes > Desc: not available > URL: > <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20190306/ > 8a2c7c73/attachment.png> > Hi XBoxBoy, If the tax authorities have agreed that you are getting these bonus shares for zero cost, then to keep the cost correct in GnuCash you will have to do a dummy sell of all your existing shares at cost, and then in another transaction, buy them, including the bonus qty, at the same cost. Assuming this is for your personal accounting, it probably doesn't matter which account you use for the other side in each transaction - you could probably use either a bank account (and if you reconcile that bank account, flag the transactions as reconciled even though they never appear on a bank statement) or an Equity:Opening Balances account - you should check with your accountant. Doing this will mean manually keeping track of lots bought and sold when determining costs of future sales. Regards, Chris Good Hi David, You're right, I was confusing this with the problem where the Advanced Portfolio Report doesn't handle Return Of Capital transactions, but it seems to handle zero cost and price transactions OK. Sorry for the bad advice XBoxBoy. Regards, Chris Good ___ 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] Fwd: Bonus share entry
Message: 6 > Date: Wed, 6 Mar 2019 22:00:16 +1030 > From: Gnucash Xboxboy Mageia > To: Derek Atkins > Cc: gnucash-user@gnucash.org > Subject: Re: [GNC] Fwd: Bonus share entry > Message-ID: > > Content-Type: text/plain; charset="utf-8" > >> On Wed, Mar 6, 2019 at 9:38 PM Derek Atkins wrote: >> >> The cost may be zero, but the value is not. >> Maybe just enter them as 0.01? >> >> -derek >> Sent using my mobile device. Please excuse any typos. >> On March 6, 2019 6:07:28 AM Gnucash Xboxboy Mageia >> wrote: >> >>> Hi all, >>> I have some bonus shares that were issued with no cost to me: >>> >>> I am having trouble entering them without a cost. When I put 0 as the >> cost, >>> on the next line 1 appears, and I am unable to get rid of it. >>> >>> Perhaps I'm doing this the wrong way, and need to be entering them as a >>> share split? >>> >>> In this case, I had 100 shares, and got issued 16 for no cost: so I have >>> 116 in total. >>> >>> Any ideas? >>> >>> Thanks, >>> Xboxboy >>> ___ >>> 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. > Hi Derek, > > I've attached a picture, I don't think I'm explaining very well. > > Please see attached. > > What can I do about that imbalance line? > Many thanks, > Xboxboy > -- next part -- > A non-text attachment was scrubbed... > Name: Screenshot_20190306_215426.png > Type: image/png > Size: 34424 bytes > Desc: not available > URL: > <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20190306/8a2c7c73/attachment.png> > Hi XBoxBoy, If the tax authorities have agreed that you are getting these bonus shares for zero cost, then to keep the cost correct in GnuCash you will have to do a dummy sell of all your existing shares at cost, and then in another transaction, buy them, including the bonus qty, at the same cost. Assuming this is for your personal accounting, it probably doesn't matter which account you use for the other side in each transaction - you could probably use either a bank account (and if you reconcile that bank account, flag the transactions as reconciled even though they never appear on a bank statement) or an Equity:Opening Balances account - you should check with your accountant. Doing this will mean manually keeping track of lots bought and sold when determining costs of future sales. Regards, Chris Good ___ 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] BackupGnuCash updated for GnuCash V3
Hi, I've updated my BackupGnuCash app to handle GnuCash V3 configuration files as well as V2. It can also backup the GnuCash Windows registry or the Linux dconf settings. The new BackupGnuCash version is 1.3.1. Please see: Linux: https://github.com/goodvibes2/BackupGnuCashLinux/tree/master/src/backupgnuca sh Windows: https://github.com/goodvibes2/BackupGnuCashWin/tree/master/src/backupgnucash Regards, Chris Good ___ 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] Currency Database empty
Message: 11 Date: Sat, 16 Feb 2019 11:40:52 -0500 From: Keith Bellairs To: John Ralls Cc: gnucash-user email group Subject: Re: [GNC] Currency Database empty Message-ID: Content-Type: text/plain; charset="UTF-8" John, xml backend. not running with -debug but trace has some of these: * 10:50:08 WARN [gnc_dmy2time64_internal()] Date computation error from Y-M-D 201-12-11: Year is out of valid range: 1400.. * 10:56:13 CRIT xmlNodePtr time64_to_dom_tree(const char *, const time64): assertion 'time != INT64_MAX' failed * 10:56:13 CRIT xmlNodePtr time64_to_dom_tree(const char *, const time64): assertion 'time != INT64_MAX' failed But the date error does not seem to be coming from the Price Database tool. (Restarted gnc, went to price tool, tired to add currency exchange, failed - but no CRIT trace. The WARN appeared when gnc was started and before using price tool.) Keith On Sat, Feb 16, 2019 at 11:25 AM John Ralls wrote: > > > > On Feb 16, 2019, at 8:02 AM, Keith Bellairs wrote: > > > > Version: 3.4 > > Build ID: 3.4+ (2018-12-30) > > Finance::Quote: 1.47 > > MacOS 10.14.3 (recent update) > > > > Recently moved up from gnc 2 to 3.4. Opened Price Database tool and ran > get > > quotes, as I have done for years. Got the alert box that it couldn't get > > CAD. That's not a surprise. Update to prices was completed and I went to > > hand enter a new CAD/USD price. No CAD or USD price history shows (there > > should have been 15 years worth). So I selected ADD to at least have the > > current exchange rate. After clicking Apply and / or OK, no exchange rate > > was added and the set of exchange rates is still empty. > > > > Is this known? Is there a fix? > > I thought that I'd seen something similar from last month but I can't find > it. What backend are you using? Are there any useful messages in the trace > file [1]? > > Regards, > John Ralls > > [1] https://wiki.gnucash.org/wiki/Tracefile > > Hi Keith & John, (John probably already knows this but just in case) Maybe this is https://bugs.gnucash.org/show_bug.cgi?id=797046 ? Is there a 3.4 build for MacOS after the original 3.4? Regards, Chris Good ___ 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] lost data
Hi John, I'm pretty sure there is no secret list of all the gnucash data files you've opened. You might like to check you just are not seeing some transactions because of a filter you've applied: In the register, View Filter By If you still cannot see some transactions, the list of recently opened files is held (In Windows) int the registry. This may help: https://lists.gnucash.org/pipermail/gnucash-user/2018-May/077231.html See my mail at the end. Regards, Chris Good Message: 10 Date: Fri, 25 Jan 2019 10:22:12 +0800 From: John Sears To: gnucash-user@gnucash.org Subject: Re: [GNC] lost data Message-ID: <32da9d3b-4650-292e-e82d-6b325c4f5...@yahoo.com> Content-Type: text/plain; charset=utf-8; format=flowed Thanks, Fairly sure its gone somewhere, and I have written over it somehow,? as I have all the associated files in pdf format, but no transactions in the accounts :(..? old pc used to do a regular backup, but ... Thanks anyway, and perhaps there is a list.. which hopfully someone can point me to, before I start searching my harddrive with a partition microscope. Thanks, John On 25/1/19 10:13 AM, Adrien Monteleone wrote: > As far as I know, only those four, so if you?ve been opening files searching for ?the one? you might have tainted the list. Perhaps one of the more seasoned users or devs knows if there is a larger master URI list. > > One final thing to consider is to check your balances. Are they otherwise correct? Run a transaction report and only show activity in Q4 (or a P/Income Statement) Do you get blank results or does something show up to indicate the data is there? If you get decent reporting, perhaps the register you are viewing is set to some filter. > > Other than that, without a backup... > > Regards, > Adrien > >> On Jan 24, 2019, at 8:07 PM, John Sears via gnucash-user wrote: >> >> Hi , >> >> Yep I've already tried this, and found various previous versions ( backups - which I obviously did not do often enough) .. but none on my computer with any log files or the transactions for Q4. I was rather hoping that GNU cash would list the files with the URI somewhere ( beyond the 4 that it does show under the file tab). Im assuming that the four listed files are dydnamic and it only keeps the four URI's? >> >> >> Thanks, >> >> John >> >> >> >> On 25/1/19 9:51 AM, Adrien Monteleone wrote: >>> You could use your file manager search function to look for *.gnucash files. >>> >>> But within GnuCash, do this: >>> >>> Try to open one of the files in your history list in the File menu. >>> If it exists still in that same place, it will open, if not, it will >>> tell you the URI of where it was expected to find it. This might >>> give some clue as to where to go looking. (I just did this and >>> discovered I had moved a file into a ?finances? subdirectory of its >>> former location) >>> >>> If it opens successfully, but you need to know where it is stored, go to Find > Open and you?ll see above the file list is a button based ?breadcrumb? trail showing you the file path. >>> >>> Regards, >>> Adrien >>> >>>> On Jan 24, 2019, at 6:38 PM, John Sears via gnucash-user wrote: >>>> >>>> Hi All, >>>> >>>> A few months ago, I moved the location of my GNUcash file (along with the addressing of the associated linked files - you may remember a post about this). I have been living a fairly hectic life since, moving country, massively downsizing etc, and a fairly annoying pc problem. I am sure that I did a lot of work on GNU Cash in Q4, but noticed the other day that all of these transactions were missing and that my GNUCash was pointing at an old GNUCash file. I've looked everywhere on my computer and USBs for the file that I think might contain the transactions that I am sure I put in ( It was a lot of work, so I don't want to just retype them again), but I just cannot find the file. >>>> >>>> I notice that GNUCash highlights the last 4 files that have been >>>> opened ( under the file tab) . Is there a way to see all the files >>>> that have been opened historically and their location in the file >>>> directory. I just cannot find the correct file or any logs for the >>>> data that I entered in Q4, and at least if I know the possible >>>> paths, I might be able to ascertain if the data has somehow managed >>>> to be deleted from that location, and then determine my way forward >>>> >>>> >>>> Thanks! >>>> >>>> john ___ 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] Cant get online quotes to work
> > > Message: 1 > Date: Sun, 20 Jan 2019 18:05:32 +0800 > From: Kevin Thorne > To: "gnucash-user@gnucash.org" > Subject: Re: [GNC] Cant get online quotes to work > Message-ID: <5c4447ef.1c69fb81.7de3f.a...@mx.google.com> > Content-Type: text/plain; charset="utf-8" > > > OS: Win 10 > GnuCash 3.4 > F:Q 1.47 > Perl 5 v26.1 > > Have set the Alphavantage key in GnuCash under preferences > > Trying to get stock updates from Australia and USA > > ANZ.AX - ASX > BRK-B? - NYSE > > Seems all is working from CMD and alphavantage outside GnuCash. > > I have tried to follow all suggestions but cant get this working, is > anyone able to assist? > > Thanks you > > Kevin > > Sent from Mail for Windows 10 > > > -- next part -- > A non-text attachment was scrubbed... > Name: FQ2.PNG > Type: image/png > Size: 20835 bytes > Desc: not available > URL: < > http://lists.gnucash.org/pipermail/gnucash-user/attachments/20190120/bb0ad161/attachment.png > > > -- next part -- > A non-text attachment was scrubbed... > Name: FQ3.PNG > Type: image/png > Size: 20420 bytes > Desc: not available > URL: < > http://lists.gnucash.org/pipermail/gnucash-user/attachments/20190120/bb0ad161/attachment-0001.png > > > -- next part -- > A non-text attachment was scrubbed... > Name: FQ1.PNG > Type: image/png > Size: 5522 bytes > Desc: not available > URL: < > http://lists.gnucash.org/pipermail/gnucash-user/attachments/20190120/bb0ad161/attachment-0002.png > > > -- next part -- > A non-text attachment was scrubbed... > Name: fq4.GIF > Type: image/gif > Size: 16596 bytes > Desc: not available > URL: < > http://lists.gnucash.org/pipermail/gnucash-user/attachments/20190120/bb0ad161/attachment.gif > > > > Hi Kevin, GnuCash always uses AlphaVantage as source for all currency exchange rates. You'll notice there is nowhere to specify source for exchange rates. Do all your exchange rates work using using alphavantage from the commandline? Do all your stocks work from the commandline using the source that is specified? It is a good idea to use the down arrow in the top right hand corner of the security editor to show extra fields like the source to ensure you have the correct source and symbol for all stocks. Regards, Chris Good ___ 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] Australian Stock Quotes
Message: 8 Date: Wed, 16 Jan 2019 17:56:37 +0530 From: "David T." To: normanj Cc: Gnucash Users Subject: Re: [GNC] Australian Stock Quotes Message-ID: Content-Type: text/plain; charset=utf-8 Norman, Glad to help. In the future, be sure to ?Reply All? so that your message gets back to the list. That way, everyone gets to hear the denouement. David > On Jan 16, 2019, at 5:35 PM, Norman Jessup wrote: > > Thanks David, > > This is very helpful > > regards, > > Norman Jessup > > > > > > On 16/1/19 10:24 pm, David T. wrote: >> Norman, >> >> While the ?FinanceQuote Update? module might not have been changed since 2010, *Finance Quote* (which actually performs quote retrieval for GnuCash) most certainly has been updated numerous times since then. If you *run* ?FinanceQuote Update,? it will ? update Finance Quote for you. The most recent version of Finance::Quote is 1.47, and is dated November 12, 2017. >> >> Please note that there has been a huge amount of discussion about F::Q over the last year and a half (which is probably what underlies your note about it stopping working); to keep the story short, Yahoo! decided to stop providing price quotes. From the resulting hullaballoo, F::Q changed primary quote providers, either to AlphaVantage or to Yahoo! Json. You will need to reset your commodities each to use a currently-valid source. Much of this is explained on the wiki at https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F <https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F> Note Paragraph 3. >> >> Cheers, >> David T. >> >>> On Jan 16, 2019, at 9:10 AM, normanj mailto:njes...@tpg.com.au>> wrote: >>> >>> A year or two (or three) ago the share price tool stopped working for >>> Australian shares. I saw some forum posts suggesting that source of >>> Australian quotes was no longer available and needed to be changed. >>> >>> While there have been several new version of GnuCash released since >>> then, the FinanceQuote Update module does not appear to have changed since 2010. >>> >>> I've tried without success to modify the tool myself. Is anyone >>> able to point me towards detailed instructions about what I need to do to fix this? >>> or possibly where I can download a more up-to-date version of the tool? >>> >>> Thank you >>> >>> >>> >>> >>> >>> -- >>> Sent from: >>> http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html >>> <http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html> >>> ___ Hi Norman, There is already a fix (from me) for using the ASX as a source in Finance::Quote which has been merged [1] and is waiting (since Jul 16, 2018) for a new release (1.48?). The (main?) F::Q maintainer Erik Colson has said he no longer has time and asked for volunteers to take over. A couple of months ago (I think) some-one did volunteer but I haven't seen any progress yet. As it has been a while, it is possible my latest fix no longer works either. I haven't tested the ASX lately as there are 2 alternatives: 1) Yahoo_JSON 2) AlphaVantage (you may need to put a sleep into the perl code if you have many stocks). If you are still interested in modifying F::Q: a) You will need to program in perl (you must know that already but I'm saying this for others) and know a little about html. b) The git repository is here: [2] There is some useful info in the README.md at the bottom of this page. [1] https://github.com/finance-quote/finance-quote/pull/82 [2] https://github.com/finance-quote/finance-quote Regard, Chris Good ___ 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] Mnemonics Tip for GnuCash 3 users
GnuCash 3 uses GTK3. GTK Mnemonics are underlined characters in a label, used for keyboard navigation. Examples of labels which may include a mnemonic are the text on a button, the label of a field, and the text in a menu line. The mnemonic is activated by pressing the mnenomic activator key (Alt for Linux and Windows, Command (I think) for MacOS) at the same time as the underlined character. Since GTK 3.10 the underlines of the mnenomics are only visible after pressing the mnenomic activator key. The way this works doesn't seem to be well documented, but give it a go and you'll soon see the keyboard shortcuts that were always visible in GnuCash versions before 3. Regards, Chris Good ___ 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] Next release of F::Q
Erik Colson <mailto:gnucash-user%40gnucash.org?Subject=Re:%20Re%3A%20%5BGNC%5D%20Next%20 release%20of%20F%3A%3AQ=%3C87r2iy8y6t.fsf%40ecocode.net%3E> eco at ecocode.net wrote on gnucash-user Thu Aug 16 05:20:42 EDT 2018 Hello all, I'm on some extended vacation and will be back home next week. My intent is to release F::Q from master at the end of this month. The alphavantage module has undergone some modifications which should make it more reliable since we can now tell the module at which speed it can question the alphavantage API. Before releasing F::Q, I would like as many feedback as possible on the best working arguments. You can therefor play with the following variables in the Alphavantage.pm file: my $maxQueries = { quantity =>20 , seconds => 65}; # no more than x queries per y seconds Probably we should now set quantity to 5 and seconds to 61, but maybe there are some better values? The values above seem to work pretty well on my automated home system. Sometimes queries get rejected, but the module is now smart enough to insert a delay if alphavantage API refuses to answer queries. The purpose of next release is to fix the problems with Alphavantage speed control, so I won't add any other commits to other modules for this release. I've seen some messages on github concerning Alphavantage.pm and will read those while enhancing the module. best -- erik colson Hi Erik, Thanks for working on this. I have done some testing using the current github master Quote.pm & AlphaVantage.pm. Here are my results: I have 16 stocks but only 1 currency. Using the F::Q 1.47 code: Only the first 5 stocks worked, the others failed. Using your mods (& my variations in timing), there was never a failure to return all the quotes requested. Yay! Using your timing of no more than 20 queries per 65 seconds: real3m0.735s real2m20.476s real2m19.217s real2m17.692s real2m19.923s Using timing of no more than 5 queries per 60 seconds: real3m2.503s real3m2.320s real2m9.449s real2m32.282s Using timing of no more than 5 queries per 59 seconds: real2m59.858s Using timing of no more than 20 queries per 50 seconds: real3m1.121s real2m38.678s Looks like your 20 in 65 seconds is pretty good, which doesn't seem to agree with https://www.alphavantage.co/premium/ which says: In certain high-frequency use cases that exceed our standard call-frequency limit (5 requests per minute), we offer a dedicated, premium API key which allows various tiers of API calls per minute. Can you please release the new version asap? Can you please also merge https://github.com/finance-quote/finance-quote/pull/79 (yahooJSON.pm returns date 00/00/2000 in Windows) as this also fixes perl warnings which can cause GnuCash to hang when multiple quotes (>15) are requested. Regards, Chris Good ___ 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] help with software
Hi Allison, In case you have trouble following the mail thread below, Sounds like a bug that is already fixed in latest version. Problem occurs in MS Windows when GnuCash is closed while it is minimized, say by right clicking on Gnucash icon in task bar, and selecting 'Close'. Either upgrade to latest version or edit .gcm file to replace both -32000 values with 0. I think you can find this bug in http://bugs.gcucash.org by searching for 'minimized' - I think I entered this bug with American spelling even though I'm Australian, as I guess there are many more American users than English. Regards, Chris Good > Message: 6 > Date: Sun, 26 Aug 2018 18:47:13 -0400 > From: D > To: David Carlson , Rich Shepard > > Cc: Gnucash Users > Subject: Re: [GNC] help with software > Message-ID: <7420bna204062en10q8ujgje.1535323633...@email.android.com> > Content-Type: text/plain; charset=utf-8 > > Allison, > > You mention that you click on "the icon on the bar," so I wonder if you are > encountering an odd window position, as discussed at > https://lists.gnucash.org/pipermail/gnucash-user/2018-June/077584.html > > David > > On August 26, 2018, at 6:16 PM, David Carlson > wrote: > > Allison, > > Windows 10 just released an update that did not install well on some > computers. > > Assuming that is not your problem, the next question is when you say > clicking on the file does nothing, are you referring to your data file > (which you hopefully put in some subfolder under your documents). > > David C > > >>> On Sun, Aug 26, 2018, 3:46 PM Rich Shepard wrote: >>> >>> On Sun, 26 Aug 2018, Allison Cawdrey wrote: >>> >>> I am windows user. Not sure what version. I downloaded it about a month >>> ago, so would have used most recent. I don't see anything. I click on >> icon >>> in my start bar and nothing happens. When I try to open it directly from >>> file, I get the same response. Nothing happens. >> >> Allison, >> >> Okay. I know nothing about Windows; haven't used it since 3.1. This >> information is helpful and someone on the mail list will now have a better >> basis for helping you. >> >> You have a start menu, I presume. Have you looked at all the menus there >> to see where GC might be installed? There is probably a utility that can >> tell you where an executable program is installed, but I know only the >> linux >> tools for doing this. >> >> Please keep all messages on the mail list so others can both contribute >> and learn from your experiences. >> >> 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] Lost Files
> Message: 3 > Date: Tue, 17 Jul 2018 21:19:29 +0100 > From: Michael Berkson > To: gnucash-user@gnucash.org > Subject: [GNC] Lost Files > Message-ID: <19067f7d-1b8d-4c94-a732-b7113b1bf...@tiscali.co.uk> > Content-Type: text/plain; charset=utf-8; format=flowed > > I have lost all ledger and log files between 13 Oct 2017 and 15 July > 2018.? Unbelievably, they are also missing from my off-line back up. > > On 14 July 2018, I tried to open GnuCash.? The sequence appeared normal > until completion of user data download, when the file opened as a > minimized icon on the task bar, which I could not expand or read.?? > Since then every attempt to open GnuCash brings up? the 13 Oct 2017 > version updated only by scheduled credits. > > I am using GnuCash 3.1.? My operating System is Windows 10 Professional > and my preferred browser is Firefox 61.0.1 (32-bit). > > I have run a System Restore and two lost file programs, EaseUS Data > Recovery and DiskDigger, without success. > > Can you please help me to retrieve my missing accounts. > > -- > Thanks > > Michael Berkson > > Southernwood > 5 Woollards Lane > Great Shelford > CAMBRIDGE > CB22 5LZ > > Tel (Home) 01223 844503 > Office 01223 840510 > Mobile 07505 948170 > e-mail michael.berk...@tiscali.co.uk > Hi Michael, I suspect your data files are OK but they are not where you think they are. Sounds like you have hit a bug that has already been fixed in the latest version. Either update to 3.2 or edit your .gcm file and replace both -32000 figures with 0 before starting GnuCash. See https://bugs.gnucash.org/show_bug.cgi?id=796256 Regards, Chris Good ___ 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.