Re: [GNC] Today's search....for .lck
OH, I now find the Tax Account folder has been deleted. I have no recollection, but it must have happened. I'll go through the backup files on Backblaze. Sorry, as I said, I have no recollection Barry On 07/08/2023 23:05, Adrien Monteleone wrote: Barry, At one point you advised you had GnuCash files in: C:\Users\Barry Mahon\Documents\Tax accounts and returns\ now, you are saying it is: C:\users\administrato\documents These are 2 separate locations and two separate 'users' on this machine. Where do you *think* your GnuCash file is supposed to be? (full qualified path please) And what do you *think* its file name is supposed to be? (just the file name here is fine) And for completeness, can you trigger that 'cannot write to file' warning that you originally reported, and send us a screenshot? Thanks. Regards, Adrien On 8/7/23 10:56 AM, Mahon Finbar via gnucash-user wrote: is where the only one which "fits" i.e. where GNU FEB 12 2019.gnucash is. There are literally hundreds of others On 07/08/2023 17:33, David Carlson wrote: What is the complete path/filename for the files? ___ 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.
[GNC] Strange prices update issue (possibly with TSP)
So I am seeing a strange issue updating prices on my system. For each try, every third one succeeds but other two fails and this is very consistent behavior all the time on my system. I am on Windows 11 and using GNC v4.14 (time to upgrade? There is a good reason why I need to stay there) with F::Q v1.57_02. I turned on debugging (via --log=gnc.price-quotes=debug --log=gnc.scm=debug; looks like latter one is applicable to GNC v4.14) and below is the output from the trace file. Am I correct to interpret that TSP source is failing two out of three times? I see result as being * 10:03:17 DEBUG results: #f which indicates it failed to retrieve prices for that source but other sources (currency, alphavantage, and yahoo json) are fine. That raises two questions: 1) Is prices update all or nothing operation, i.e., if there are multiple sources and for those ones that succeed, does GNC still update its prices database from sources that succeeded? 2) Is there a way to peg the debug file name, possibly with a fully qualified path, and whether to tell it to overwrite or append if pegged name one exist? * 10:01:46 DEBUG rpt-subdir=gnucash/reports/standard * 10:01:46 DEBUG mod-dir=c:\Program Files (x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard * 10:01:46 DEBUG dir-files=(view-column trial-balance transaction taxinvoice register reconcile-report receivables receipt price-scatter portfolio payables owner-report new-owner-report new-aging net-charts lot-viewer job-report invoice income-statement income-gst-statement ifrs-cost-basis general-ledger general-journal equity-statement dashboard customer-summary category-barchart cashflow-barchart cash-flow budget budget-income-statement budget-flow budget-barchart budget-balance-sheet balsheet-pnl balsheet-eg balance-sheet balance-forecast advanced-portfolio account-summary account-piecharts) * 10:01:46 DEBUG rpt-subdir=gnucash/reports/example * 10:01:46 DEBUG mod-dir=c:\Program Files (x86)\gnucash\share/guile/site/2.2\gnucash/reports/example * 10:01:46 DEBUG dir-files=(welcome-to-gnucash sample-graphs hello-world daily-reports average-balance) * 10:01:46 DEBUG rpt-subdir=gnucash/reports/locale-specific/us * 10:01:46 DEBUG mod-dir=c:\Program Files (x86)\gnucash\share/guile/site/2.2\gnucash/reports/locale-specific/us * 10:01:46 DEBUG dir-files=(taxtxf) * 10:01:46 DEBUG rpt-subdir=gnucash/report/stylesheets * 10:01:46 DEBUG mod-dir=c:\Program Files (x86)\gnucash\share/guile/site/2.2\gnucash/report/stylesheets * 10:01:46 DEBUG dir-files=(plain head-or-tail footer css) * 10:01:53 DEBUG gnc:fq-check-sources results: (1.57_02 aex alphavantage amfiindia asegr asx aufunds australia bamosz bet bloomberg bourso bse bseindia bvb canada canadamutual comdirect cse deka dutch dwsfunds europe fetch_live_currencies fidelity fidelity_direct finanzpartner fondsweb fool france ftfunds fundata fundlibrary goldmoney googleweb greece hu hufund hungary hustock iexcloud india indiamutual known_currencies marketwatch morningstarau morningstarch morningstarjp morningstaruk mstaruk nasdaq nseindia nyse nzx onvista oslobors romania seb_funds sinvestor six tesouro_direto tiaacref tmx tradegate tradeville treasurydirect troweprice troweprice_direct tsp tsx twelvedata ukfunds unionfunds usa xetra yahoo_chart yahoo_json yahooweb za) * 10:01:53 MESSG Found Finance::Quote version 1.57_02 * 10:02:36 DEBUG ALPHAVANTAGE_API_KEY=NOTAREALAPIKEY * 10:02:36 DEBUG handling-request: (tsp C S L2030 I) * 10:02:42 DEBUG results: ((C (symbol . C) (gnc:time-no-zone . 2023-08-09 12:00:00) (last . 691951/1) (currency . USD)) (S (symbol . S) (gnc:time-no-zone . 2023-08-09 12:00:00) (last . 704343/1) (currency . USD)) (L2030 (symbol . L2030) (gnc:time-no-zone . 2023-08-09 12:00:00) (last . 53747/1250) (currency . USD)) (I (symbol . I) (gnc:time-no-zone . 2023-08-09 12:00:00) (last . 380083/1) (currency . USD))) * 10:02:42 DEBUG handling-request: (alphavantage BRK-B) * 10:02:43 DEBUG results: ((BRK-B (symbol . BRK-B) (gnc:time-no-zone . 2023-08-09 12:00:00) (last . 17901/50) (currency . USD))) * 10:02:43 DEBUG handling-request: (yahoo_json ^RUT IDCC ^VIX ^GDAXI NDAQ ^FTSE ^DJI ^N225 ARKF ^CMC200 ^FCHI ^GSPC ^IXIC ^TNX ^HSI ^RUT SLV ^XAX MET GLD ^NYA BHF FSPSX VFINX FSEVX VTIAX VIVAX MFEKX VEXAX VGPMX JNGLX VFSAX VISVX VWIGX JDSNX OIERX VFSVX VGSLX VISGX DODFX NAESX ASVDX VBTLX VMFXX VIAAX VIMAX OIEJX CXXRX FZILX FSIVX FPADX VVIAX VEXMX VSIAX SMVSX VFWAX VGENX VPMCX ODIIX FNILX VEMAX VGTSX VTSAX VEUSX VTSMX VDADX FSMAX VGSIX FPMAX VEIEX VSMAX VEURX VSGAX HACAX FZIPX FZROX ABNIX VBMFX FXAIX FUSVX SPAXX FSTVX VFIAX CSDIX VLCAX VWNFX MDIZX JSVUX PRNHX VEXPX FSKAX FTIHX VGHCX VLACX VGXRX VGRLX BK) * 10:02:54 DEBUG results: ((^RUT (symbol . ^RUT) (gnc:time-no-zone . 2023-08-10 12:00:00) (last . 9713861/5000) (currency . USD)) (IDCC (symbol . IDCC) (gnc:time-no-zone . 2023-08-10 12:00:00) (last . 1713/20) (currency . USD)) (^VIX (symbol . ^V
Re: [GNC] Bug in GnuCash 5.3 Stock Assistant
While reading my posting again in the list, I found the reason for the
GNC_ERROR_ARG error. The current stock assistant version doesn't accept
the empty value for the fees and fills in the word "fehlt" ("missing").
Version 5.1 did not show this behavior beforehand. Entering the value of
zero ("0") in 5.3 leads to the generation of the transaction including
the corresponding splits with no errors.
So there remains just the minor issue of not showing the number of
shares... And telling the wrong transaction type in German
("Aktienteilung" means shares split, not long buy).
___
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] Today's search....for .lck
Barry, Be sure you aren't confusing the two users on your system! (one is "Barry Mahon" and the other is "administrato") Regards, Adrien On 8/10/23 2:59 AM, Mahon Finbar via gnucash-user wrote: OH, I now find the Tax Account folder has been deleted. I have no recollection, but it must have happened. I'll go through the backup files on Backblaze. Sorry, as I said, I have no recollection Barry On 07/08/2023 23:05, Adrien Monteleone wrote: Barry, At one point you advised you had GnuCash files in: C:\Users\Barry Mahon\Documents\Tax accounts and returns\ now, you are saying it is: C:\users\administrato\documents These are 2 separate locations and two separate 'users' on this machine. Where do you *think* your GnuCash file is supposed to be? (full qualified path please) And what do you *think* its file name is supposed to be? (just the file name here is fine) And for completeness, can you trigger that 'cannot write to file' warning that you originally reported, and send us a screenshot? ___ 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] Today's search....for .lck
On 8/10/2023 11:12 AM, Adrien Monteleone wrote: Barry, Be sure you aren't confusing the two users on your system! (one is "Barry Mahon" and the other is "administrato") Regards, Adrien Barry. although you are a single human being with multiple user log ins on your computer, the computer does not "know" that all of these users are a single human. As far as your computer is concerned, different people. Take my household as an example. I am the administrator on all of our computers. I am also an ordinary user on the one I mainly use and my wife is an ordinary user of the one she mainly uses. On my computer, the two accounts are a single human user but on my wife's, two different humans. If you have an ordinary ;pg in and an administrator log in it is important for you to keep in your mind "which am I logged in to at this moment?". Ideally you are not logged in as administrator except for the brief times when you need administrator rights and you do all your ordinary work while logged in as an ordinary user. LOL, back in my working days that was real important. In addition to my regular log in I had a "prod" log in for emergency use. A mistake made while I was logged in "prod" could be real serious. Michael D Novack ___ 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] Strange prices update issue (possibly with TSP)
Kalpesh, It does indeed look like the tsp module failed to return anything in the second and third tries. You're correct that gnc:scm is the right logger for GnuCash 4. gnc:price-quotes works only in GnuCash 5. For GnuCash to process a partial result from F::Q, F::Q needs to produce a valid response for each symbol; the response includes a Success variable; GnuCash will process symbols with Success=1 and present a message box containing the symbols for which F::Q returned Success=0. In the two cases where the TSE module failed it returned something that gnc-fq-helper wasn't able to parse so it posted a Scheme #f (meaning false, the equivalent of Python's None type) and logged an "unknown" error. GnuCash 5 would do a better job passing on the error but whether it could process the quotes returned from the other sources would depend on the JSON emitted by F::Q. FWIW I tried your "tsp C S L2030 I" query three times from the command line just now and got three valid responses. You can tell GnuCash to write a specific file with the --logto=/path/to/file option. It will overwrite if you pass an existing path and the only way to prevent that would be to write a wrapper script in your favorite scripting language that does the filename substitution. Regards, John Ralls > On Aug 10, 2023, at 07:50, Kalpesh Patel wrote: > > So I am seeing a strange issue updating prices on my system. For each try, > every third one succeeds but other two fails and this is very consistent > behavior all the time on my system. I am on Windows 11 and using GNC v4.14 > (time to upgrade? There is a good reason why I need to stay there) with F::Q > v1.57_02. I turned on debugging (via --log=gnc.price-quotes=debug > --log=gnc.scm=debug; looks like latter one is applicable to GNC v4.14) and > below is the output from the trace file. Am I correct to interpret that TSP > source is failing two out of three times? I see result as being * 10:03:17 > DEBUG results: #f which indicates it failed to retrieve prices for > that source but other sources (currency, alphavantage, and yahoo json) are > fine. > > > > That raises two questions: > > 1) Is prices update all or nothing operation, i.e., if there are > multiple sources and for those ones that succeed, does GNC still update its > prices database from sources that succeeded? > > 2) Is there a way to peg the debug file name, possibly with a fully > qualified path, and whether to tell it to overwrite or append if pegged name > one exist? > > > > > > > > * 10:01:46 DEBUG rpt-subdir=gnucash/reports/standard > > * 10:01:46 DEBUG mod-dir=c:\Program Files > (x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard > > * 10:01:46 DEBUG dir-files=(view-column trial-balance transaction > taxinvoice register reconcile-report receivables receipt price-scatter > portfolio payables owner-report new-owner-report new-aging net-charts > lot-viewer job-report invoice income-statement income-gst-statement > ifrs-cost-basis general-ledger general-journal equity-statement dashboard > customer-summary category-barchart cashflow-barchart cash-flow budget > budget-income-statement budget-flow budget-barchart budget-balance-sheet > balsheet-pnl balsheet-eg balance-sheet balance-forecast advanced-portfolio > account-summary account-piecharts) > > * 10:01:46 DEBUG rpt-subdir=gnucash/reports/example > > * 10:01:46 DEBUG mod-dir=c:\Program Files > (x86)\gnucash\share/guile/site/2.2\gnucash/reports/example > > * 10:01:46 DEBUG dir-files=(welcome-to-gnucash sample-graphs > hello-world daily-reports average-balance) > > * 10:01:46 DEBUG rpt-subdir=gnucash/reports/locale-specific/us > > * 10:01:46 DEBUG mod-dir=c:\Program Files > (x86)\gnucash\share/guile/site/2.2\gnucash/reports/locale-specific/us > > * 10:01:46 DEBUG dir-files=(taxtxf) > > * 10:01:46 DEBUG rpt-subdir=gnucash/report/stylesheets > > * 10:01:46 DEBUG mod-dir=c:\Program Files > (x86)\gnucash\share/guile/site/2.2\gnucash/report/stylesheets > > * 10:01:46 DEBUG dir-files=(plain head-or-tail footer css) > > * 10:01:53 DEBUG gnc:fq-check-sources results: (1.57_02 aex > alphavantage amfiindia asegr asx aufunds australia bamosz bet bloomberg > bourso bse bseindia bvb canada canadamutual comdirect cse deka dutch > dwsfunds europe fetch_live_currencies fidelity fidelity_direct finanzpartner > fondsweb fool france ftfunds fundata fundlibrary goldmoney googleweb greece > hu hufund hungary hustock iexcloud india indiamutual known_currencies > marketwatch morningstarau morningstarch morningstarjp morningstaruk mstaruk > nasdaq nseindia nyse nzx onvista oslobors romania seb_funds sinvestor six > tesouro_direto tiaacref tmx tradegate tradeville treasurydirect troweprice > troweprice_direct tsp tsx twelvedata ukfunds unionfunds usa xetra > yahoo_chart yahoo_json yahooweb za) > > * 10:01:53 MESSG Found Finance::Quote version 1.57_02 > > * 10:02:36 DEBUG ALPHAVANTAGE_API_KEY=NOTAREALAPIKEY > > * 1
Re: [GNC] Bug in GnuCash 5.3 Stock Assistant
There are a lot of issues with the Stock Transaction Assistant in 5.3, see e.g.
https://bugs.gnucash.org/show_bug.cgi?id=798988 and
https://bugs.gnucash.org/show_bug.cgi?id=799054. There are plenty more that
I've noticed and it's what I'm working on this week (and probably next week).
I've added your note about requiring a 0 entry in fees to the latter bug to
remind me.
I can't reproduce the shares problem, see attached.
The current de.po has:
msgid "Buy"
msgstr "Kauf"
and
msgid "Stock split"
msgstr "Aktienteilung"
That seems to be match what you about buy vs. shares split. Perhaps you're
mislead by the paragraph at the top of the dialog where Aktientelung refers to
transaction splits? That's explaining what's represented in that page of the
dialog, not the transaction type.
Regards,
John Ralls
> On Aug 10, 2023, at 07:57, Carsten Hütter wrote:
>
> While reading my posting again in the list, I found the reason for the
> GNC_ERROR_ARG error. The current stock assistant version doesn't accept the
> empty value for the fees and fills in the word "fehlt" ("missing"). Version
> 5.1 did not show this behavior beforehand. Entering the value of zero ("0")
> in 5.3 leads to the generation of the transaction including the corresponding
> splits with no errors.
>
> So there remains just the minor issue of not showing the number of shares...
> And telling the wrong transaction type in German ("Aktienteilung" means
> shares split, not long buy).
>
> ___
> 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] Strange prices update issue (possibly with TSP)
John, Appreciate that details. That is going to be quite helpful. The difficult part in debugging this is that when I do query three times from the command line, it succeeds without any issue for me as well, but when I update prices from GNC, it fails two times and then succeeds third time consistently. So this is not an issue with throttling from TSP source which you validated as well. Is there more in terms of debugging this by any chance? Can I use STDERR and STDOUT from Perl to emanate messages to console but not interfere with what JSON comes back or butcher the response back to gnc-fq-helper so it doesn't bomb to run a full cycles from GNC to test? Any help in debugging is appreciated. Looks like I may need to debug the TSP.pm module under the hood to figure out what might be going on and most likely with the response coming back from the request to https://www.tsp.gov/data/fund-price-history.csv URI. -Original Message- From: john Sent: Thursday, August 10, 2023 12:54 PM To: Kalpesh Patel Cc: gnucash-u...@lists.gnucash.org Subject: Re: [GNC] Strange prices update issue (possibly with TSP) Kalpesh, It does indeed look like the tsp module failed to return anything in the second and third tries. You're correct that gnc:scm is the right logger for GnuCash 4. gnc:price-quotes works only in GnuCash 5. For GnuCash to process a partial result from F::Q, F::Q needs to produce a valid response for each symbol; the response includes a Success variable; GnuCash will process symbols with Success=1 and present a message box containing the symbols for which F::Q returned Success=0. In the two cases where the TSE module failed it returned something that gnc-fq-helper wasn't able to parse so it posted a Scheme #f (meaning false, the equivalent of Python's None type) and logged an "unknown" error. GnuCash 5 would do a better job passing on the error but whether it could process the quotes returned from the other sources would depend on the JSON emitted by F::Q. FWIW I tried your "tsp C S L2030 I" query three times from the command line just now and got three valid responses. You can tell GnuCash to write a specific file with the --logto=/path/to/file option. It will overwrite if you pass an existing path and the only way to prevent that would be to write a wrapper script in your favorite scripting language that does the filename substitution. Regards, John Ralls > On Aug 10, 2023, at 07:50, Kalpesh Patel wrote: > > So I am seeing a strange issue updating prices on my system. For each > try, every third one succeeds but other two fails and this is very > consistent behavior all the time on my system. I am on Windows 11 and > using GNC v4.14 (time to upgrade? There is a good reason why I need to > stay there) with F::Q v1.57_02. I turned on debugging (via > --log=gnc.price-quotes=debug --log=gnc.scm=debug; looks like latter > one is applicable to GNC v4.14) and below is the output from the trace > file. Am I correct to interpret that TSP source is failing two out of > three times? I see result as being * 10:03:17 DEBUG results: > #f which indicates it failed to retrieve prices for that source but > other sources (currency, alphavantage, and yahoo json) are fine. > > > > That raises two questions: > > 1) Is prices update all or nothing operation, i.e., if there are > multiple sources and for those ones that succeed, does GNC still > update its prices database from sources that succeeded? > > 2) Is there a way to peg the debug file name, possibly with a fully > qualified path, and whether to tell it to overwrite or append if > pegged name one exist? > > > > > > > > * 10:01:46 DEBUG rpt-subdir=gnucash/reports/standard > > * 10:01:46 DEBUG mod-dir=c:\Program Files > (x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard > > * 10:01:46 DEBUG dir-files=(view-column trial-balance > transaction taxinvoice register reconcile-report receivables receipt > price-scatter portfolio payables owner-report new-owner-report > new-aging net-charts lot-viewer job-report invoice income-statement > income-gst-statement ifrs-cost-basis general-ledger general-journal > equity-statement dashboard customer-summary category-barchart > cashflow-barchart cash-flow budget budget-income-statement budget-flow > budget-barchart budget-balance-sheet balsheet-pnl balsheet-eg > balance-sheet balance-forecast advanced-portfolio account-summary > account-piecharts) > > * 10:01:46 DEBUG rpt-subdir=gnucash/reports/example > > * 10:01:46 DEBUG mod-dir=c:\Program Files > (x86)\gnucash\share/guile/site/2.2\gnucash/reports/example > > * 10:01:46 DEBUG dir-files=(welcome-to-gnucash sample-graphs > hello-world daily-reports average-balance) > > * 10:01:46 DEBUG > rpt-subdir=gnucash/reports/locale-specific/us > > * 10:01:46 DEBUG mod-dir=c:\Program Files > (x86)\gnucash\share/guile/site/2.2\gnucash/reports/locale-specific/us > > * 10:01:46 DEBUG dir-files=(taxtxf) >
[GNC] Will GNU CASH work on a Chromebook
Running Version 115.0.5790.160 ___ 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] Will GNU CASH work on a Chromebook
I wouldn't think so. It's not an app like that. -derek Sent using my mobile device. Please excuse any typos. On August 10, 2023 20:21:33 "Floyd Beck Jr. via gnucash-user" wrote: Running Version 115.0.5790.160 ___ 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] Strange prices update issue (possibly with TSP)
Kalpesh, You should be able to print diagnostics using `print STDERR ...`. Part of the problem with price-quotes.scm's error handling was that it didn't even look at gnc-fq-helper's stderr. The order in the tracefile you posted showed that tsp returned prices on the *first* try and failed on the subsequent two: > * 10:02:36 DEBUG handling-request: (tsp C S L2030 I) > > * 10:02:42 DEBUG results: ((C (symbol . C) (gnc:time-no-zone . > 2023-08-09 12:00:00) (last . 691951/1) (currency . USD)) (S (symbol . S) > (gnc:time-no-zone . 2023-08-09 12:00:00) (last . 704343/1) (currency . > USD)) (L2030 (symbol . L2030) (gnc:time-no-zone . 2023-08-09 12:00:00) (last > . 53747/1250) (currency . USD)) (I (symbol . I) (gnc:time-no-zone . > 2023-08-09 12:00:00) (last . 380083/1) (currency . USD))) [snip] > > * 10:03:11 DEBUG handling-request: (tsp C S L2030 I) > > * 10:03:17 DEBUG results: #f [snip] > * 10:03:37 DEBUG handling-request: (tsp C S L2030 I) > > * 10:03:43 DEBUG results: #f Regards, John Ralls > On Aug 10, 2023, at 12:13, Kalpesh Patel wrote: > > John, > > Appreciate that details. That is going to be quite helpful. > > The difficult part in debugging this is that when I do query three times > from the command line, it succeeds without any issue for me as well, but > when I update prices from GNC, it fails two times and then succeeds third > time consistently. So this is not an issue with throttling from TSP source > which you validated as well. Is there more in terms of debugging this by any > chance? Can I use STDERR and STDOUT from Perl to emanate messages to console > but not interfere with what JSON comes back or butcher the response back to > gnc-fq-helper so it doesn't bomb to run a full cycles from GNC to test? Any > help in debugging is appreciated. > > Looks like I may need to debug the TSP.pm module under the hood to figure > out what might be going on and most likely with the response coming back > from the request to https://www.tsp.gov/data/fund-price-history.csv URI. > > -Original Message- > From: john > Sent: Thursday, August 10, 2023 12:54 PM > To: Kalpesh Patel > Cc: gnucash-u...@lists.gnucash.org > Subject: Re: [GNC] Strange prices update issue (possibly with TSP) > > Kalpesh, > > It does indeed look like the tsp module failed to return anything in the > second and third tries. > > You're correct that gnc:scm is the right logger for GnuCash 4. > gnc:price-quotes works only in GnuCash 5. > > For GnuCash to process a partial result from F::Q, F::Q needs to produce a > valid response for each symbol; the response includes a Success variable; > GnuCash will process symbols with Success=1 and present a message box > containing the symbols for which F::Q returned Success=0. In the two cases > where the TSE module failed it returned something that gnc-fq-helper wasn't > able to parse so it posted a Scheme #f (meaning false, the equivalent of > Python's None type) and logged an "unknown" error. GnuCash 5 would do a > better job passing on the error but whether it could process the quotes > returned from the other sources would depend on the JSON emitted by F::Q. > > FWIW I tried your "tsp C S L2030 I" query three times from the command line > just now and got three valid responses. > > You can tell GnuCash to write a specific file with the --logto=/path/to/file > option. It will overwrite if you pass an existing path and the only way to > prevent that would be to write a wrapper script in your favorite scripting > language that does the filename substitution. > > Regards, > John Ralls > > >> On Aug 10, 2023, at 07:50, Kalpesh Patel wrote: >> >> So I am seeing a strange issue updating prices on my system. For each >> try, every third one succeeds but other two fails and this is very >> consistent behavior all the time on my system. I am on Windows 11 and >> using GNC v4.14 (time to upgrade? There is a good reason why I need to >> stay there) with F::Q v1.57_02. I turned on debugging (via >> --log=gnc.price-quotes=debug --log=gnc.scm=debug; looks like latter >> one is applicable to GNC v4.14) and below is the output from the trace >> file. Am I correct to interpret that TSP source is failing two out of >> three times? I see result as being * 10:03:17 DEBUG results: >> #f which indicates it failed to retrieve prices for that source but >> other sources (currency, alphavantage, and yahoo json) are fine. >> >> >> >> That raises two questions: >> >> 1) Is prices update all or nothing operation, i.e., if there are >> multiple sources and for those ones that succeed, does GNC still >> update its prices database from sources that succeeded? >> >> 2) Is there a way to peg the debug file name, possibly with a fully >> qualified path, and whether to tell it to overwrite or append if >> pegged name one exist? >> >> >> >> >> >> >> >> * 10:01:46 DEBUG rpt-subdir=gnucash/reports/standard >> >> * 10:01:46 DEBUG mod-d
[GNC] Will GNU CASH work on a Chromebook
Try https://github.com/joshuabach/gnucash-web ___ 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] Balance sheet shows 1c imbalance when JPY foreign currency accounts are present
This is not uncommon, different banks have different rounding policies and GnuCash can't guess what they might be for your bank. The solution is to tell GnuCash the value in both currencies and let it calculate the price, because while currency amounts have to be rounded, prices don't. Regards, John Ralls > On Aug 9, 2023, at 20:11, socket-grips0c--- via gnucash-user > wrote: > > Hello, I am encountering some rounding discrepancies when using foreign > currency bank accounts. This means balance sheet total assets don’t match > balance sheet total liabilities. > > The issue arises when I have two bank accounts in JPY and using AUD as my > home currency. Certain combinations of JPY account balances and exchange > rates produce a balance sheet with 1c rounding differences. > > This is problematic as it means I can’t generate balance sheets that balance > reliably. This means I’m unable to finalise accurate books to provide to an > accountant. > > Reports will show different values based on report options, but expected > behaviour would be for balance sheets to always balance. I would also expect > balance sheet and balance sheet (multicolumn) to produce the same totals. > > The desired fix would be able to run the standard balance sheet report and > have it consistently produce assets = liabilities. > > A test uncompressed XML file with only two transactions is attached. I have > not turned on trading accounts in this test book, but I have observed the > same behaviour in my personal books with trading accounts turned on. > > Screenshot 1 > Accounts and balances. > > Screenshot 2 > Standard balance sheet set to default settings. Report correctly combines > foreign currency balances to generate correct subtotal. So the subtotals are > correct based on foreign currency total holdings. But this means the subtotal > of assets is 1c (0.01) different to the subtotal of liabilities. The balance > sheet does not balance. > > Screenshot 3 > Balance sheet (multicolumn) shows correct totals, but subtotals ignore > foreign currency totals. Subtotals appear to roll up based on local currency > converted amounts, not underlying foreign currency totals. This is different > behaviour to the standard balance sheet. > > Screenshot 4 > Trial balance using last up to report date currency conversion shows matching > totals, but these differ by 1c from balance sheet (multicolumn). Difference > appears to relate to 1c unrealised gain. > > Screenshot 5 > Trial balance using weighted average of past transactions conversion shows > totals that differ by 1c. Also shows fractional exchange rate. > > Screenshot 6 > General journal shows 1c lower total. > > <1. two bank accounts in > JPY.png><2. balance sheet in home currency AUD shows 1c error.png><3. balance > sheet multicolumn shows totals correct.png><4. trial balance totals dont > equal balance sheet totals using last up to report date currency conversion > option but show 1c unrealised gain.png><5. trial balance using weighted > average currency conversion shows different totals.png><6. general journal > shows differing exchange rates due to real numbers used internally in > gnucash.png>___ > 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] Will GNU CASH work on a Chromebook
There are ways to run linux apps in ChromeOS. I'm not sure if anyone has attempted such with GnuCash. Regards, Adrien ___ 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] Will GNU CASH work on a Chromebook
How did I forget? https://lists.gnucash.org/pipermail/gnucash-user/2018-October/080544.html It seems someone has at least as of GnuCash 3.2 via Flatpak on ChromeOS. Regards, Adrien On 8/10/23 11:36 PM, Adrien Monteleone wrote: There are ways to run linux apps in ChromeOS. I'm not sure if anyone has attempted such with GnuCash. ___ 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] Today's search....for .lck
Yes, I appreciate that. Over the years my 'user' name has been changed. Administrato is the one used as the baseline. However the Gnu files were originally under the Barry Mahon user. Barry On 10/08/2023 17:12, Adrien Monteleone wrote: Barry, Be sure you aren't confusing the two users on your system! (one is "Barry Mahon" and the other is "administrato") Regards, Adrien On 8/10/23 2:59 AM, Mahon Finbar via gnucash-user wrote: OH, I now find the Tax Account folder has been deleted. I have no recollection, but it must have happened. I'll go through the backup files on Backblaze. Sorry, as I said, I have no recollection Barry On 07/08/2023 23:05, Adrien Monteleone wrote: Barry, At one point you advised you had GnuCash files in: C:\Users\Barry Mahon\Documents\Tax accounts and returns\ now, you are saying it is: C:\users\administrato\documents These are 2 separate locations and two separate 'users' on this machine. Where do you *think* your GnuCash file is supposed to be? (full qualified path please) And what do you *think* its file name is supposed to be? (just the file name here is fine) And for completeness, can you trigger that 'cannot write to file' warning that you originally reported, and send us a screenshot? ___ 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.
