Re: [GNC] Alphavantage Problem
> Message: 1 > Date: Sat, 16 Jun 2018 10:33:40 -0700 (MST) > From: samsurd2 > To: gnucash-user@gnucash.org > Subject: Re: [GNC] Alphavantage Problem > Message-ID: <1529170420529-0.p...@n4.nabble.com> > Content-Type: text/plain; charset=us-ascii > > I'm running GC 2.6.16 with Finance-Quote 1.47 on Windows 8.1 and Windows 10 > machines. I don't have an explanation but I do have an observation. > > I've noticed that around the 15th or 16th of every month since the switch from > Yahoo to AlphaVantage, I've had only limited success getting quotes using > Finance-Quote. Admittedly, I have a long list of equities that I track but usually I > get them all on the first try. Occasionally, a second pass is required to get one or > two quotes that are missing initially. However, for whatever the reason, I have > difficulty getting the majority around the 15th or 16th of every month. I usually > request updated quotations once a week early on Saturday morning. Today was > no exception and, as usual, the list for which no quotes were available was a > long one. Fortunately, I'm able to download the complete list of the prior day's > closing values from another source so that I can manually enter the quotes that > Finance-Quote missed. > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User- > f1415819.html > > > -- Hi Samsurd2, You may find these fixes to AlphaVantage helpful: https://lists.gnucash.org/pipermail/gnucash-user/2018-April/075839.html 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] Strange Problem
On 22/06/2018 17:34, Les wrote: John: I never received your reply because for some reason, it ended up in my spam folder. I am not sure what you mean, but I cannot find the stock in question in Price Editor so I cannot check its prices. I have selected to get quotes via AlphaVantage in Security Editor. At any rate, I cannot get prices or input a price manually. Thanks, Les Have you tried using the ISIN number as an identifier? -- Cheerio, Graham --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ 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] Updated to 3.1 - lost lots & report
Hi John, Good! So migration is working with a recent maint build. The first warning is harmless. It complains about a missing setting. However that setting is only introduced in gnucash 3.x so it can't be there in the old metadata files. This should go away automatically you reopen your data file the next time. I don't think you have to revert to gnucash 3.1. The changes in maint are almost all bug fixes so the current state should be in better shape even than 3.1. I would advise to upgrade to 3.2 when it comes out though as just yesterday I found a regression that can crash gnucash when a book has posted invoices and bills. The regression is dealt with in today's nightly and will also be in 3.2. The original issue we attempted to fix (but for which the fix itself caused the regression) remains open: https://bugzilla.gnome.org/show_bug.cgi?id=796248 but is less critical. Regards, Geert Op zaterdag 23 juni 2018 07:07:02 CEST schreef John Bonnett: > Hi Geert, > > I have done as you suggested and I got this window along with the usual ones > > > > The trace file has this > > * 14:26:19 WARN error reading group Page 1 key ShowUnused: > Key file does not have key “ShowUnused” in group “Page 1” > * 14:26:31 WARN [xaccQueryAddAccountMatch()] acct_list has > NULL account > > That second message appears in other trace files and looks like I have a > null account. The first message is new. > > The program seems to be working OK. Is it safe for me to continue with > this version or should I revert to the released v3.1? > > Let me know if you would like me to try anything else. > > John > > On 21/06/2018 1:16 AM, Geert Janssens wrote: > > Thanks for the response. > > > > The trace indeed has no messages related to migration. In retrospect it > > couldn't have :( > > > > The migration code itself runs before logging is set up. So any message > > printed during migration would be sent to the console, but on windows that > > is not available. > > > > There are several other clues though the migration didn't run: > > - no pop-up window summarizing the migration results > > - missing saved report configurations > > - warnings about missing .gcm file > > > > I dug into the code and found I already fixed one issue that would prevent > > the migration right after the release of gnucash 3.1. Can you retry the > > procedure with a recent nightly build ? For example this one; > > https://code.gnucash.org/builds/win32/maint/gnucash-3.1-2018-06-18-git-3.1 > > -171-g1e3a44500+.setup.exe > > > > Make a backup of your active gnucash book, install this version, move > > c:\Users \\AppData\Roaming\GnuCash out of the way and start > > gnucash. Do you see a migration summary window in this case ? > > > > Regards, > > > > Geert > > > > Op zondag 17 juni 2018 03:18:02 CEST schreef Ethan Swint: > >> My response at bottom of post. > >> > >> Message: 3 > >> Date: Sat, 16 Jun 2018 10:53:06 +0200 > >> From: Geert Janssens > >> To: gnucash-user@gnucash.org > >> Cc: John Bonnett > >> Subject: Re: [GNC] Updated to 3.1 - lost lots & report > >> Message-ID: <1761733.q6rmsms...@legolas.kobaltwit.lan> > >> Content-Type: text/plain; charset="us-ascii" > >> > >> Op donderdag 14 juni 2018 10:37:31 CEST schreef John Bonnett: > >>> I found it at this path > >>> > >>> "C:\Users\\.gnucash" > >> > >> Gnucash 3.1 is supposed to migrate from this directory to > >> c:\Users\\AppData\Roaming\GnuCash > >> > >> I don't know why this didn't happen for you. > >> > >>> in it I found this file > >>> > >>> "C:\Users\\.gnucash\saved-reports-2.4" > >>> > >>> which looked a bit suspicious. In it I found Scheme code for my missing > >>> reports. > >>> > >>> Another folder I found in my search was > >>> > >>> "C:\Users\\AppData\Roaming\GnuCash" > >>> > >>> Now this Roaming folder often holds configuration information on > >>> Windows. > >> > >> It > >> > >>> also had recently dated files in it so was probably related to my recent > >>> installation of GnuCash 3.1. > >> > >> This directory should be generated as part of the first-time run of > >> gnucash > >> 3.1. > >> > >> Can you do an experiment to help evaluate the migration step ? > >> Can you > >> 1. quit gnucash if it's still running > >> 2. rename > >> "C:\Users\\AppData\Roaming\GnuCash" > >> to > >> "C:\Users\\AppData\Roaming\GnuCash.bkp" > >> That moves it out of the way of gnucash. > >> 3. Start gnucash > >> => Does it report a migration of meta data ? > >> 4. Quit gnucash > >> 5. Locate the most recent trace file [1] and post it here. > >> > >>> I copied the above mentioned saved reports file to > >>> > >>> "C:\Users\\AppData\Roaming\GnuCash\saved-reports-2.4" > >>> > >>> and next time I opened GnuCash my reports had returned. > >> > >> Indeed. You manually completed the migration. I would like to figure out > >> why > >> this didn't happen in the first place. > >> > >> Thanks, > >> > >> Geert > >> > >> --- > >>
Re: [GNC] Strange Problem
No, I hadn't thought of that. However, I did a search for the company in question and could not find one. The company only came into being on 05/18/2018 as a result of a spinout. Even when I try to get a quote manually using a terminal, there is no data. Les On 06/23/2018 04:30 AM, Graham Balin wrote: On 22/06/2018 17:34, Les wrote: John: I never received your reply because for some reason, it ended up in my spam folder. I am not sure what you mean, but I cannot find the stock in question in Price Editor so I cannot check its prices. I have selected to get quotes via AlphaVantage in Security Editor. At any rate, I cannot get prices or input a price manually. Thanks, Les Have you tried using the ISIN number as an identifier? -- Cheerio, Graham --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ 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] Alphavantage Problem
Chris, Thanks for the information regarding Finance::Quote and Alpha Vantage. I’ll give it a try. BTW, being a cautious type, when I do implement the procedure, I’ll probably save copies of the original .pm files somewhere before overwriting them. Stuff happens and Murphy has a keyboard too. Dave S. Sent from Mail for Windows 10 From: Chris Good Sent: Saturday, June 23, 2018 2:56 AM To: gnucash-user@gnucash.org Cc: samsu...@comcast.net Subject: RE: [GNC] Alphavantage Problem > Message: 1 > Date: Sat, 16 Jun 2018 10:33:40 -0700 (MST) > From: samsurd2 > To: gnucash-user@gnucash.org > Subject: Re: [GNC] Alphavantage Problem > Message-ID: <1529170420529-0.p...@n4.nabble.com> > Content-Type: text/plain; charset=us-ascii > > I'm running GC 2.6.16 with Finance-Quote 1.47 on Windows 8.1 and Windows 10 > machines. I don't have an explanation but I do have an observation. > > I've noticed that around the 15th or 16th of every month since the switch from > Yahoo to AlphaVantage, I've had only limited success getting quotes using > Finance-Quote. Admittedly, I have a long list of equities that I track but usually I > get them all on the first try. Occasionally, a second pass is required to get one or > two quotes that are missing initially. However, for whatever the reason, I have > difficulty getting the majority around the 15th or 16th of every month. I usually > request updated quotations once a week early on Saturday morning. Today was > no exception and, as usual, the list for which no quotes were available was a > long one. Fortunately, I'm able to download the complete list of the prior day's > closing values from another source so that I can manually enter the quotes that > Finance-Quote missed. > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User- > f1415819.html > > > -- Hi Samsurd2, You may find these fixes to AlphaVantage helpful: https://lists.gnucash.org/pipermail/gnucash-user/2018-April/075839.html Regards, Chris Good --- This email has been checked for viruses by AVG. https://www.avg.com ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Corrupted transaction export file - is this a bug, or do I do something wrong
Please ignore last post, now resolved - I forgot the process of opening HTML files generated from reports, all good now - 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.
[GNC] GnuCash frequently crashes. (Jay)
GnuCash frequently crashes. It seems that a crash is provoked most often in the following cases: 1. Attempting to delete a split from a new, unsaved transaction. 2. Attempting to save a transaction duplicated from a previous, unsaved transaction. Doing either of the above actions does not always result in a crash; it’s unpredictable yet frequent. In addition to the obvious interruption of a crash, the workaround is to neurotically save after entering a transaction or two. The more unsaved transactions, the more likely a crash and the greater the loss in time, having to reenter lost transactions. I launched GnuCash using Terminal to look at what John referred to as a “trace file” in a separate post and was able to capture a crash error message provoked by Case 1 above; here’s that message: **gnc.register.ledger:ERROR:/Users/john/Development/Gnucash-Build/Gnucash-3-Mavericks/src/gnucash-3.1/gnucash/register/ledger-core/split-register.c:1072:gnc_split_register_delete_current_split: assertion failed: (!pending_trans)zsh: abort /Applications/Gnucash.app/Contents/MacOS/Gnucash I’ve also attached the Console log within User Reports, also as John suggested in that other post. I hope the message and attached log help (If attachments are passed along to the listserv; I don’t know.). macOS 10.12.5 “Sierra” sincerely, Jay Gnucash_2018-06-23-144606_Apollo.crash Description: Binary data ___ 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 frequently crashes. (Jay)
> On Jun 23, 2018, at 2:51 PM, Jay Kvam wrote: > > GnuCash frequently crashes. It seems that a crash is provoked most often in > the following cases: > > 1. Attempting to delete a split from a new, unsaved transaction. > 2. Attempting to save a transaction duplicated from a previous, unsaved > transaction. > > Doing either of the above actions does not always result in a crash; it’s > unpredictable yet frequent. In addition to the obvious interruption of a > crash, the workaround is to neurotically save after entering a transaction > or two. The more unsaved transactions, the more likely a crash and the > greater the loss in time, having to reenter lost transactions. > > I launched GnuCash using Terminal to look at what John referred to as a > “trace file” in a separate post and was able to capture a crash error > message provoked by Case 1 above; here’s that message: > > **gnc.register.ledger:ERROR:/Users/john/Development/Gnucash-Build/Gnucash-3-Mavericks/src/gnucash-3.1/gnucash/register/ledger-core/split-register.c:1072:gnc_split_register_delete_current_split: > assertion failed: (!pending_trans)zsh: abort > /Applications/Gnucash.app/Contents/MacOS/Gnucash > > I’ve also attached the Console log within User Reports, also as John > suggested in that other post. > > I hope the message and attached log help (If attachments are passed along > to the listserv; I don’t know.). > > macOS 10.12.5 “Sierra” Jay, Please open a bug for this. In addition to the trace file, check the User Reports section of Console to see if there are any GnuCash crash reports. If there are, please examine the stack trace on each and attach a representative report for each to the bug along with the trace file. If there aren’t any crash reports say so in the bug description, it’s an important distinction. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Quicken 2015 for Mac to GnuCash
Hi everyone, I’m trying to migrate from Quicken 2015 for Mac to GnuCash. I’ve seen the recommended way to import is using a qif file, but unfortunately Quicken 2015 for Mac doesn’t offer qif export. I went through the GnuCash Help manual and the GnuCash Tutorials and Concepts Guide, no success. I tried all export formats supported by Quicken 2015 Mac, but didn’t find anything useful : Quicken uses a sqlite3 file as its standard save file. I can export to .qxf (not .qfx) (Quicken For Windows Transfert File) It’s a binary file that GnuCash doesn’t seem to recognize. I can also export to .qmtf (Quicken for Mac 2007 Transfer File). Is a text file similar to the .qif file, but is not recognized by GnuCash. (I even tried to rename the file to .qif, still no success) Finally, I can export to a .csv file (no accounts, just « Register Transactions »). GnuCash’s preview of imported transactions shows nothing, so my .csv file may not be what GnuCash expects. I have about 10 years of history in Quicken, so I would prefer to bring my history to GnuCash instead of starting with an empty database. What’s the easiest way to get my data into GnuCash ? I’ve seen at the end of the Help Manual an example awk script to convert a .csv file to a .qif file. Could bring transactions but will probably need to create accounts manually before importing transactions. I can write awk/sed/vi scripts if needed. The QIF file format is documented quite well on Wikipedia, so I may be able to fix my .qmtf file into a valid .qif file for GnuCash. Quicken 2015 internal format is a sqlite3 database. The file is readable, so if I find where transactions are stored I may be able to while a SQL query to generate a QIF file. Any suggestions ? Thanks, Yves Forget yves_for...@yahoo.ca ___ 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.
