2018-05-15 GnuCash IRC logs
00:09:24 <fell_laptop> CDB-Man_: did you add your alphavantage key in edit.->preferences->quotes or. similar?
00:10:08 <fell_laptop> And you knwo, only one value per day is inserted?
00:10:52 <CDB-Man_> its not a key issue, 80% of my potfolio updates
00:11:10 <CDB-Man_> they successfully pulled the values for 2018-05-14
00:15:46 <fell_laptop> IIRC the thread https://lists.gnucash.org/pipermail/gnucash-devel/2018-May/042022.html has much background information.
00:19:18 <fell> Try to run gnc-fq-dump -v currency USD CAD
00:22:31 <fell> you might need to preceed it by 'ALPHAVANTAGE_API_KEY=##############'
00:23:45 <fell> (I put the key in my bashrc file
00:28:04 *** luc14n0 has quit IRC
00:28:10 *** luc14n0 has joined #gnucash
00:45:25 *** pilotauto has quit IRC
00:48:34 *** boldstripe has quit IRC
00:56:09 <CDB-Man_> fell: so no windows, my command line is this?
00:56:30 <CDB-Man_> perl gnc-fq-dump -v currency USD CAD ALPHAVANTAGE_API_KEY=##############
00:57:07 <fell> Your OS is windos?
00:57:13 <CDB-Man_> yes
00:57:45 <fell> I don't know how to set envirenment variables there.
00:58:47 <fell> Might be something like %ALPHAVANTAGE_API_KEY%=<your key>
01:00:24 <fell> You might set it persistently somewhere in "This Computer" or however it is called.
01:01:02 *** harshitaneja has joined #gnucash
01:02:08 *** Mechtilde has joined #gnucash
01:02:51 <CDB-Man_> will it throw an error if the lack of key is an issue?
01:03:00 <CDB-Man_> i just ran, and 1 USD = (unknown) CAD
01:05:36 *** fell_laptop has quit IRC
01:05:37 <CDB-Man_> fell: so after defining my environment var with the api key, fq-dump returns a value
01:05:45 *** fell has quit IRC
01:06:46 *** fell has joined #gnucash
01:06:49 *** fell_laptop has joined #gnucash
01:06:57 <CDB-Man_> [2018.05.15 01:02:50] <CDB-Man_> will it throw an error if the lack of key is an issue?
01:06:57 <CDB-Man_> [2018.05.15 01:03:00] <CDB-Man_> i just ran, and 1 USD = (unknown) CAD
01:06:57 <CDB-Man_> [2018.05.15 01:05:36] <-- fell_laptop (fell@p200300DFA70F100069D7306FB7BC77E7.dip0.t-ipconnect.de) has quit (Ping timeout: 184 seconds)
01:06:57 <CDB-Man_> [2018.05.15 01:05:36] <CDB-Man_> fell: so after defining my environment var with the api key, fq-dump returns a value
01:07:48 <CDB-Man_> when gnucash fails, the list of "unable to retrieve" can fluctuate, but it alwasy includes the CAD USD item. is the request being truncated? are currencies always asked for last?
01:13:16 <fell> gnc-fq-dump returns a value and gnucash not?
01:13:33 <CDB-Man_> correct
01:13:49 <CDB-Man_> gnucash fails to return a currency value, along with anywhere from 5-15 of my CAD stocks
01:14:04 <CDB-Man_> the US ones along with the remainder of the CAD ones, go thru fine
01:14:26 <CDB-Man_> the CAD ones that fail are inconsistent, so I doubt it's to do with any individual entry
01:14:35 <CDB-Man_> there was no issue last time I ran price updates in Feb 2018
01:14:43 <CDB-Man_> currency consistenctly fails right now
01:16:10 <fell> The alphavantage sources use the same suffixes as yahoo did: https://code.gnucash.org/docs/C/gnucash-help/apas02.html
01:16:32 <CDB-Man_> I changed nothing from Feb, so all suffixes are the same
01:16:42 <CDB-Man_> and everythnig worked 100% inFeb
01:16:57 <CDB-Man_> BCE.TO, for example, for BCE Inc on TSX
01:17:02 *** CDB-Man_ is now known as CDB-Man
01:17:28 <fell> What changed in between? GC version, ...
01:17:28 <CDB-Man> and again: CDB-Man> the CAD ones that fail are inconsistent, so I doubt it's to do with any individual entry
01:17:32 <CDB-Man> GC version
01:17:46 <fell> from to
01:17:47 <CDB-Man> i upgraded to 3.x in april
01:18:08 <CDB-Man> from 2.6.x ... where IIRC x was .10 or .12
01:18:23 <CDB-Man> didnt run another price report until today
01:22:29 <fell> you could look in your tracefile
01:23:04 <CDB-Man> hmm, where can I look for that?
01:24:36 <fell> But one difference in 2.x we asked to store the key in the environment file, now you should set it in preferences.
01:24:56 <CDB-Man> currently I have it in both
01:25:30 <fell> https://wiki.gnucash.org/wiki/Tracefile
01:27:31 *** gjanssens has joined #gnucash
01:27:31 *** ChanServ sets mode: +o gjanssens
01:27:37 <CDB-Man> I see a whole lot of these gnc-report files
01:28:17 <CDB-Man> found the traces
01:29:17 <CDB-Away> * 21:53:09 CRIT <gnc.scm> Illegal Multichoice option set
01:29:18 <CDB-Away> * 21:53:13 CRIT <gnc.scm> Illegal Multichoice option set
01:29:28 <CDB-Man> that's it for what's in the only trace file dated today
01:31:47 <fell> you might try to run in a command shell gnucash --debug --extra
01:32:54 <fell> that would increase the log level
01:33:47 <fell> The multichoice option seems not related.
01:35:47 *** gncbot sets mode: +o fell
01:35:58 <CDB-Man> trying again and seeing what happens
01:36:14 <CDB-Man> well now, just booting it up the log is already 2mb, this seems promising
01:39:54 *** Mechtilde has quit IRC
01:42:03 <CDB-Away> * 00:40:55 INFO <qof.engine> [qof_event_generate_internal] id=2 hi=090cc278 han=6a04941e data=00000000
01:42:03 <CDB-Away> * 00:40:55 INFO <qof.engine> [qof_event_generate_internal] id=1 hi=066921f8 han=6c90d8cf data=00000000
01:42:16 <CDB-Man> i see a bunch of these, the same entries repeat several times
01:50:39 *** Mechtilde has joined #gnucash
02:01:11 *** Mechtilde has quit IRC
02:02:20 <CDB-Man> fell: i am heading to bed now, its 2am here, but for your reference here's an excerpt of the logs: https://pastebin.com/HLcE7QzB
02:07:40 <fell> CDB_Man: I don't see anything suspect, sorry. Have a good night!
02:11:59 *** pilotauto has joined #gnucash
02:18:39 *** storyjesse has quit IRC
02:51:55 *** fabior has joined #gnucash
02:57:33 *** fekepp has joined #gnucash
03:29:08 *** gour has joined #gnucash
03:47:16 *** Mechtilde has joined #gnucash
03:53:33 *** fekepp has quit IRC
03:56:24 *** Mechtilde has quit IRC
04:05:58 *** Mechtilde has joined #gnucash
04:15:53 *** Mechtilde has quit IRC
04:19:49 *** Mechtilde has joined #gnucash
04:20:45 *** fekepp has joined #gnucash
04:24:03 *** ncv has joined #gnucash
04:33:20 *** fekepp has quit IRC
04:33:21 *** fekepp has joined #gnucash
04:37:15 *** Mechtilde has quit IRC
04:46:41 *** pilotauto_ has joined #gnucash
04:48:06 *** pilotauto has quit IRC
05:05:56 *** fabior has quit IRC
05:40:05 *** fabior has joined #gnucash
05:50:18 *** pilotauto_ has quit IRC
05:58:08 *** oozer has joined #gnucash
06:42:58 *** fabior has quit IRC
06:57:48 *** Jimraehl1 has joined #gnucash
06:59:17 *** Jimraehl1 has left #gnucash
07:15:34 *** jotrago has quit IRC
07:37:41 <fell> CDB_Man: https://bugzilla.gnome.org/show_bug.cgi?id=795564
07:41:20 *** fekepp1 has joined #gnucash
07:41:28 *** fekepp has quit IRC
07:41:29 *** fekepp1 is now known as fekepp
07:48:44 *** chris has joined #gnucash
07:50:58 *** chris has quit IRC
07:53:27 *** boldstripe has joined #gnucash
07:53:35 *** Mechtilde has joined #gnucash
07:59:24 *** Mechtilde has quit IRC
07:59:39 *** Mechtilde has joined #gnucash
08:06:18 *** fekepp1 has joined #gnucash
08:06:26 *** Mechtilde has quit IRC
08:06:47 *** fekepp has quit IRC
08:06:50 *** fekepp1 is now known as fekepp
08:19:47 *** Mechtilde has joined #gnucash
08:27:16 *** fekepp has quit IRC
08:28:53 *** Mechtilde has quit IRC
08:29:25 *** fekepp has joined #gnucash
08:32:59 *** mikee_ has joined #gnucash
08:33:08 *** mikee has quit IRC
08:33:48 *** oozer has quit IRC
08:45:07 *** mikee_ has quit IRC
08:53:32 *** Mechtilde has joined #gnucash
08:55:32 *** mikee_ has joined #gnucash
08:56:44 *** fekepp has quit IRC
08:57:46 *** fekepp has joined #gnucash
09:06:43 *** chris has joined #gnucash
09:07:06 <chris> gour: just wondering what is it about current-vs-average.scm is particularly useful?
09:10:59 *** chris has quit IRC
09:14:11 *** kael has joined #gnucash
09:15:02 *** fabior has joined #gnucash
09:15:12 *** gour has quit IRC
09:22:08 *** gour has joined #gnucash
09:24:06 *** fabior has quit IRC
09:58:46 *** chris has joined #gnucash
10:04:56 *** mikee_ is now known as mikee
10:05:06 <mikee> @op
10:05:06 <gncbot> mikee: Error: You don't have the #gnucash,op capability. If you think that you should have this capability, be sure that you are identified before trying again. The 'whoami' command can tell you if you're identified.
10:05:44 <mikee> @op
10:05:45 *** gncbot sets mode: +o mikee
10:11:50 *** Cuare has quit IRC
10:36:24 <warlord> .
10:37:11 *** fabior has joined #gnucash
10:41:39 *** fekepp has quit IRC
10:55:01 *** fabior has quit IRC
10:59:36 <gour> chris: custom-vs-average provides average amount for some specific time span which is handy when preparing budgets...actually, i'd expect to have 'average' option in budget's estimation feature so that it can set average value for some account instead of just estimation from month to month. along with ytd-budget, the budget feature in GC could then be used for envelope budgeting, iow. alway knowing how we perform at some moment (since values are carried over
10:59:37 <gour> from month to month) and more easy way to prepate budget to take into consideration average expenses/incomes based on the past history
11:00:43 *** ArtGravity has joined #gnucash
11:03:06 <chris> gour: how complicated.
11:04:54 *** Mechtilde has quit IRC
11:08:07 *** fekepp has joined #gnucash
11:09:57 *** kael has quit IRC
11:13:24 <gour> chris: what is complicated?
11:14:20 <chris> to me, the amount of effort to get an average expenditure for budgeting is complicated!
11:15:08 <gour> it's more natural to have average as estimated value than non-average...if i pay for e.g. car-insurance once in a year, i want that cost to be distributed evenly during the whole year per month and not to have 11 months with zero cost and then one-time amount in the 12 cost
11:15:49 <gour> chris: read this: https://github.com/simonmichael/hledger/wiki/Budgeting%20and%20forecasting
11:17:26 <gour> as you can see. e.g. in hledger it's very simple to get average amounts
11:17:49 <gour> same as envelope-budgeting and forecasting
11:21:09 <chris> ok fair. good luck!
11:22:09 *** fabior has joined #gnucash
11:28:49 *** fabior has quit IRC
11:32:01 *** kael has joined #gnucash
11:50:19 *** boldstripe_ has joined #gnucash
11:50:25 *** boldstripe has quit IRC
11:50:55 *** boldstripe has joined #gnucash
11:53:13 *** kael has quit IRC
11:53:37 *** boldstripe_ has quit IRC
11:58:50 *** boldstripe has quit IRC
11:59:07 *** boldstripe has joined #gnucash
12:02:37 *** boldstripe has quit IRC
12:03:54 *** boldstripe has joined #gnucash
12:09:02 <gour> chris: maybe it's complicated in the current-vs-average report, but otherwise it's just the question of going through the whole period and divide the total amount by the number of e.g. months, and so for each account, fairly simple
12:12:16 *** chris has quit IRC
12:12:24 *** chris has joined #gnucash
12:13:51 <jralls> fell: No, I didn't see cmarchi's reply. Are you sure it went to core and not just to you?
12:13:52 *** Mechtilde has joined #gnucash
12:15:21 <chris> gour: https://github.com/christopherlam/gnucash/commits/maint-TR-average quick'n'dirty, needs display/subtotal-table, average for row only
12:16:35 <gour> chris: thanks a lot. that looks really good
12:17:22 <chris> repushed. can't do exact->inexact. try again.
12:23:39 *** oozer has joined #gnucash
12:31:00 <chris> ...and avg row and col
12:31:40 *** fekepp has quit IRC
12:37:29 <gour> chris: have to go afk now, will try it later
12:40:38 *** fabior has joined #gnucash
12:43:56 *** chris has quit IRC
12:51:24 *** kael has joined #gnucash
12:53:51 *** gour_ has joined #gnucash
12:56:09 *** gour has quit IRC
13:08:53 *** jotrago has joined #gnucash
13:26:07 *** fabior has quit IRC
13:38:01 *** calvinct has joined #gnucash
13:46:58 <Trel> I had asked a while ago, since the 3.x update, I can't seem to trigger dropdowns with Ctrl+Arrow on Windows anymore. Is there any workaround? (This would trigger for example, the date chooser)
13:55:35 *** kael has quit IRC
13:57:51 *** frakturfreak has joined #gnucash
14:01:09 *** oozer has quit IRC
14:04:55 <fell> jralls: cmarchi CCed core, but I forwarded it to you now. Peerhaps your spam filter has eaten it.
14:07:03 <jralls> fell: No, core bounced it because cmarchi isn't a subscriber.
14:08:14 <jralls> fell: Anyway, thanks for forwarding it.
14:13:38 <fell> OK, I forwarded it to the list, too. But I think, it would be the best, if the release manager would manage G+, too.
14:19:59 <jralls> OK, I guess. As long as you don't make me get on Facebook. I replied to cmarchi saying that he should add me as an admin on the G+ account.
14:29:38 *** kael has joined #gnucash
14:46:52 *** calvinct has quit IRC
15:00:03 <warlord> jralls: what do you know about std::mt19937 ?
15:00:24 <jralls> wardlord: Nothing at all.
15:01:33 <warlord> Obviously OT to gnucash.. But I'm trying to build some code on my F25 system (yeah, I know, 1.5 years old) but the compiler is telling me that it can't find it.
15:01:39 <jralls> But http://www.cplusplus.com/reference/random/mt19937/ tells me it's one of the random generators added in C++11.
15:02:37 *** oozer has joined #gnucash
15:03:33 <warlord> Right. I knew that. ;) But for some reason my F25 C++ installation doesn't seem to like it.
15:06:46 <jralls> warlord: Try including <bits/random.h>
15:07:49 <warlord> Actually, looks like I just needed #include <random>
15:07:58 <warlord> Thank you https://github.com/beniz/deepdetect/issues/210 :)
15:09:55 <jralls> warlord: I expected that you'd already included that since it's the standard location...
15:10:01 <jralls> Anyway, lunchtime.
15:10:07 *** jralls is now known as jralls_afk
15:11:32 <warlord> jralls_afk: Not my code.. I didn't write it, just trying to build it -- and it wasn't building.
15:11:37 <warlord> Anyways, thanks... Got it working now.
15:19:55 *** fekepp has joined #gnucash
15:31:42 *** oozer has quit IRC
15:48:29 *** fabior has joined #gnucash
15:52:02 *** fabior has quit IRC
15:53:29 *** fabior has joined #gnucash
16:04:58 *** calvinct has joined #gnucash
16:10:44 *** gjanssens has quit IRC
16:16:54 *** oozer has joined #gnucash
16:17:21 *** calvinct has quit IRC
16:21:07 *** jralls_afk is now known as jralls
16:25:38 *** frakturfreak has quit IRC
16:32:59 *** kael has quit IRC
16:42:32 *** boldstripe has quit IRC
16:43:43 *** Mechtilde has quit IRC
16:44:23 *** calvinct has joined #gnucash
16:49:01 *** fabior has quit IRC
17:05:55 *** calvinct has quit IRC
17:08:53 *** boldstripe has joined #gnucash
17:11:16 *** boldstripe has quit IRC
17:24:51 *** kael has joined #gnucash
17:41:03 *** chf has quit IRC
17:44:27 *** chf has joined #gnucash
17:51:52 *** ncv has quit IRC
18:22:57 *** kael has quit IRC
18:30:20 *** pilotauto has joined #gnucash
18:33:46 *** kael has joined #gnucash
18:34:17 *** harshitaneja has quit IRC
18:34:20 *** kael has quit IRC
18:34:57 *** harshitaneja has joined #gnucash
19:18:11 *** gour_ has quit IRC
19:40:56 *** badger93 has joined #gnucash
19:43:49 *** badger92 has quit IRC
19:43:50 *** badger93 is now known as badger92
19:55:57 *** boldstripe has joined #gnucash
20:03:14 *** ArtGravity has quit IRC
20:07:59 <warlord> BZ: suck.. suck.. suck.. (I'm downloading all 9000 bugs)
20:15:20 <CDB-Man> <fell> CDB_Man: https://bugzilla.gnome.org/show_bug.cgi?id=795564
20:15:39 <CDB-Man> Fell, the issue #2 seems to describe almost perfectly what I saw
20:15:50 <CDB-Man> I also lack scheme skills
20:16:07 <CDB-Man> And I agree that it always seems to be the same subset that fails
20:16:14 <CDB-Man> Plus or minus a few entries
20:28:47 *** oozer has quit IRC
20:29:00 *** oozer has joined #gnucash
21:05:53 *** gncbot has joined #gnucash
21:09:07 *** fekepp has quit IRC
21:29:04 *** gncbot has joined #gnucash
22:18:27 *** fell_laptop has quit IRC
22:29:32 *** fell_laptop has joined #gnucash
22:34:31 *** Cuare has joined #gnucash
22:56:51 *** boldstripe has quit IRC
23:19:46 *** Skeletron has joined #gnucash