2020-07-20 GnuCash IRC logs
00:51:26 *** angel has quit IRC
00:51:32 *** Mechtilde has joined #gnucash
01:08:27 *** sbluhm has joined #gnucash
01:08:27 *** ChanServ sets mode: +v sbluhm
01:11:27 *** sbluhm has quit IRC
01:22:59 *** fell has quit IRC
01:24:18 *** fell has joined #gnucash
01:24:19 *** ChanServ sets mode: +o fell
01:54:55 *** Mechtilde has quit IRC
02:07:21 *** jervin has joined #gnucash
02:17:52 *** lmat has quit IRC
02:17:56 *** lmat has joined #gnucash
02:53:09 *** Mechtilde has joined #gnucash
04:04:17 *** dtux has quit IRC
05:01:20 *** Mechtilde has quit IRC
05:04:14 *** bertbob has joined #gnucash
05:04:15 *** ChanServ sets mode: +v bertbob
05:12:47 *** jannick has joined #gnucash
05:14:55 *** Mechtilde has joined #gnucash
06:02:51 *** ramontjunior has joined #gnucash
06:06:09 *** Aussie_matt has quit IRC
06:10:20 *** Mechtilde has quit IRC
06:12:50 *** jervin has quit IRC
06:13:26 *** jervin has joined #gnucash
06:36:45 *** angel has joined #gnucash
06:45:57 *** Mechtilde has joined #gnucash
06:49:35 *** Mechtilde has quit IRC
07:09:34 *** angel has quit IRC
07:10:20 *** Mechtilde has joined #gnucash
07:15:29 *** Mechtilde has quit IRC
07:16:14 *** Mechtilde has joined #gnucash
07:21:27 *** jannick has quit IRC
07:35:47 *** Mechtilde has quit IRC
07:40:43 <chris> warlord/jralls: instead of embedding webkit, it *may* be a safe option to open up a webserver port and be *very* picky about input/output :-O e.g. output only html, input options via gtk dialog as usual
07:41:35 <chris> alternatively, we may simply use webkit as usual, but for more complex reports (eg sankey.js), just require open in web browser
07:51:18 <warlord> Other alternative would be to call out to the default system browser.. But that doesn't allow interactive reports (like opening up registers, etc)
07:56:35 <chris> it does actually... http server will parse http(s)://localport/gnc-register?guid=???
07:58:19 *** Mechtilde has joined #gnucash
08:17:32 *** angel has joined #gnucash
08:25:37 *** jannick has joined #gnucash
08:47:26 *** angel has quit IRC
08:51:42 <jannick> Hi, what is the best and most elegant way to import a bulk of association file paths (each of which belongs to a transaction) into a GC file? Many thanks!
08:52:45 <warlord> chris, ah, yeah, true..
09:18:00 *** David1 has joined #gnucash
09:18:56 *** David has quit IRC
09:18:56 *** David1 is now known as David
09:32:54 <fell> jannick: writing a python script?
09:33:52 <fell> Although Scheme might be more elegant. ;-9
09:35:24 <jannick> fell: which requires an executable compiled with python binding. Not the case for windows nightlies I believe.
09:36:30 <jannick> fell: scheme scripts work for data retrieval only I guess, while I do not speak scheme at all, though.
09:37:17 *** jw4 has quit IRC
09:38:14 *** jw4 has joined #gnucash
09:46:00 <grepular> If I switch to a postgres backend, is it safe to point two copies of gnucash at the same db? Atm I'm syncing my gnucash dir between my desktop and laptop using syncthing, but if I close my laptop lid without shutting down gnucash, the lock file remains, which makes gnucash on my desktop unhappy...
09:55:49 <warlord> grepular, only if one copy of gnucash is running at a time.
10:01:08 <grepular> Hmm. Would limiting the db user that gnucash uses to one connection allowed offer any protection there?
10:01:28 <grepular> I suppose it depends if it opens and maintains a connection whilst running, or if it makes short-lived connections only when fetching or updating data
10:01:55 <warlord> You MUST ensure that only one gnucash is running at a time.
10:02:02 *** joo has quit IRC
10:02:32 <warlord> I dont know if limiting to 1 connection will work. It may.
10:03:00 <grepular> Hmm. A little frustrating. I guess I'll just stick with synthing for now, and try to remember to shut down gnucash when I'm not using it
10:11:23 *** User has joined #gnucash
10:15:38 <warlord> Gnucash is not a multi-user app.
10:15:39 <warlord> Sorry.
10:19:31 <Simon> grepular: run a script on suspend on the laptop?
10:26:32 *** Agfarmer18 has joined #gnucash
10:27:30 *** User has quit IRC
10:44:16 *** Mechtilde has quit IRC
10:45:09 *** Mechtilde has joined #gnucash
10:46:05 *** Agfarmer18 has quit IRC
10:51:51 *** Mechtilde has quit IRC
10:53:15 *** Agfarmer18 has joined #gnucash
10:58:02 *** Mechtilde has joined #gnucash
11:02:15 *** Agfarmer18 has quit IRC
11:02:48 *** Agfarmer18 has joined #gnucash
11:03:13 *** Mechtilde has quit IRC
11:10:40 *** jannick has quit IRC
11:17:48 *** Agfarmer18 has quit IRC
11:29:12 <chris> CDB-Man_ https://github.com/Gnucash/gnucash/pull/759 proof of concept. cannot be merged in due to software dependency instability. currently cannot convert currencies. it would be useful to know a reasonable currency-conversion strategy.
11:32:13 *** jannick has joined #gnucash
11:37:07 *** kael has joined #gnucash
11:37:08 *** ChanServ sets mode: +v kael
11:38:14 *** Agfarmer18 has joined #gnucash
11:38:38 *** jannick has quit IRC
11:39:55 *** joo has joined #gnucash
11:51:25 *** MatheusSN has joined #gnucash
11:56:18 *** Agfarmer18 has quit IRC
11:56:54 *** CDB-Work has joined #gnucash
11:56:55 *** ChanServ sets mode: +v CDB-Work
11:58:00 <CDB-Man_> CDB-Work : [11:29:12] <+9d54b3chris> CDB-Man_ https://github.com/Gnucash/gnucash/pull/759 proof of concept. cannot be merged in due to software dependency instability. currently cannot convert currencies. it would be useful to know a reasonable currency-conversion strategy.
11:58:59 *** calvinct has joined #gnucash
11:59:46 <CDB-Work> well chris, on currency, we run into the same issue with b/s and i/s on what rates to use, and that daily rates and period average rates arent available
12:00:19 <CDB-Work> that's fundamental really to any "proper" currency conversion. otherwise, it's whatever we currently have available as the best (only) alternative
12:02:04 *** ramontjunior has quit IRC
12:02:17 <CDB-Work> what's the green and red mean?
12:12:28 *** jralls_afk is now known as jralls
12:14:57 <jralls> CDB-Work, do you mean in the PR diffs?
12:16:00 <CDB-Man_> PR?
12:17:05 <warlord> Pull Request
12:19:24 <CDB-Man_> It's not immediately obvious to me that the green and red coding in the PR Sankey chart means
12:21:59 <CDB-Man_> To me what* the
12:22:18 <CDB-Man_> I thought it was debit credit indicators, that's not the case
12:22:51 <jralls> chris, using the default browser would require that we add an http server to gnucash and listen on a port. I don't know offhand how to do that on Windows.
12:23:05 <CDB-Man_> chris: I go on vacation next week, so I'm hoping to pickup on where I left off in the ticket
12:23:26 <warlord> jralls, they support the standard socket interface.
12:23:44 <warlord> Doesn't Boost have a Network API? ;)
12:24:10 *** MatheusSN has quit IRC
12:24:48 *** Agfarmer18 has joined #gnucash
12:25:12 <CDB-Man_> chris: assuming the same coincidence of bug tracker being offline when I go work on it, doesn't happen coincidentally again. Lightning does not strike twice in the same spot, right??
12:25:50 * CDB-Man_ looks in war Lord's direction
12:28:34 <jralls> warlord: Yeah, https://www.boost.org/doc/libs/1_70_0/doc/html/boost_asio.html should work and it says it supports MinGW.
12:29:25 <warlord> there we go! :)
12:29:34 <warlord> Worst case there is libghttpd, IIRC.
12:30:49 *** jervin has quit IRC
12:34:09 <jralls> I'd rather use boost::asio. It supports the networking ts that will eventually go into C++ stdlib.
12:39:12 <jralls> Either way, though, it's a substantial project and I don't see resources available to implement it any time soon.
12:53:20 <CDB-Work> hmm, speaking of substantial projects, how would the suggested implementation of daily and historical price lookups rate in terms of difficulty, with 10 being complex and 1 being simple?
12:58:46 *** calvinct has quit IRC
13:00:24 *** laerling has quit IRC
13:01:42 <jralls> Daily is scriptable now with a cron job/scheduled task. Historical would need changes to F::Q as well as to GnuCash, but shouldn't be too hard.
13:03:56 <CDB-Work> Neat, some positive news! this morning i found 2 spiders in my cup. also dropped an egg on the floor. Also woke up late
13:04:06 <CDB-Work> so some good news to offset a rough morning
13:12:05 *** storyjesse has quit IRC
13:14:00 *** Mechtilde has joined #gnucash
13:22:34 *** Agfarmer18 has quit IRC
13:44:26 <fell> jralls,there is a https://metacpan.org/pod/Finance::QuoteHist.
13:45:14 <jralls> Cool, except it doesn't appear to do currency.
13:46:21 <fell> call yahoo* with cccddd=X
13:50:26 <fell> also, the still unwritten ECB module could deliver historical reference rates.
13:51:52 <jralls> Looks like it's unmaintained since 2017, actually supports only Yahoo! and screen-scrapes. Did you test it?
13:53:20 <fell> No, it is at the lower end of my todo list.
13:55:00 *** jw4 has quit IRC
13:56:32 *** jw4 has joined #gnucash
14:12:57 <jralls> Interesting, I followed the code and hand-built a url. It works, returning a CSV. So another version of Yahoo! finance query that's not dead.
14:16:21 *** Mechtilde has quit IRC
14:22:10 *** Mechtilde has joined #gnucash
14:22:17 *** frakturfreak has joined #gnucash
14:22:18 *** ChanServ sets mode: +v frakturfreak
14:41:55 *** jervin has joined #gnucash
15:05:21 *** spathoche[m] has joined #gnucash
15:05:23 *** spathoche[m] has left #gnucash
15:11:50 *** Agfarmer18 has joined #gnucash
15:13:46 *** Agfarmer18 has quit IRC
15:56:23 *** Mechtilde has quit IRC
16:24:55 *** CDB-Work has quit IRC
16:25:15 *** CDB-Work has joined #gnucash
16:25:15 *** ChanServ sets mode: +v CDB-Work
16:37:12 *** Agfarmer18 has joined #gnucash
16:53:58 *** Mechtilde has joined #gnucash
16:57:00 *** Mechtilde has quit IRC
16:59:35 *** frakturfreak has quit IRC
17:05:40 *** calvinct has joined #gnucash
17:23:11 *** Mechtilde has joined #gnucash
17:26:13 *** Mechtilde has quit IRC
17:35:08 *** calvinct has quit IRC
17:58:13 *** Wilco has joined #gnucash
17:58:20 <Wilco> Hi
17:59:24 <Wilco> Thank you for gnucash, and the 4.0 update which has much improved receivable aging reports..
17:59:41 <Wilco> I am having 2 issues still, one is "You have requested a password token too recently to request another. Please wait 10 minutes then try again.
17:59:44 <Wilco> in bugzilla :)
18:00:02 <Wilco> no emails are ever sent
18:00:16 <Wilco> the other issue is that reports are off by one month and one day
18:00:22 <Wilco> at least in charts
18:01:02 <Wilco> so for example in the income chart I see numbers that are correct for june 2020 under 2020-05-01
18:01:15 <Wilco> and 2020-04-01 has the one for may 2020..
18:01:32 *** meneldur has joined #gnucash
18:01:50 <Wilco> and 2020-06-01 has the amount on the first transaction on 2020-06-01, but not even an entire day actually
18:02:01 <Wilco> it's a bit weird. It's also wrong in the table under the chart
18:02:15 *** Mechtilde has joined #gnucash
18:02:18 <Wilco> but the profit & loss report shows the correct values for every selected period
18:05:15 *** Mechtilde has quit IRC
18:05:22 <Wilco> does anybody else also see this?
18:13:27 <meneldur> Hello! I'm having a hard time using GNUCash daily with an autocomplete feature I can't disable anywhere. Not on the account column but autocomplete from past transactions. While typing, the app randomly autocompletes the entry, so I end writing in the middle of the completed phrase. 4.0+(2020-06-27) on Fedora 32 KDE
18:16:28 <Wilco> meneldur: I don't have this problem on debian 10 MATE, but how does that present itself? when it autocompletes, is the completion still selected? does your cursor stay where you're typing?
18:18:07 *** Agfarmer18 has quit IRC
18:21:19 <meneldur> When I start tyiping an entry with identical beginning, the whole phrase is selected. Typing relatively fast (slower than my default speed) keeps the phrase selected, but typing slightly faster drops selection and starts adding characters wherever I was
18:25:24 <meneldur> Wilco: I recorded the screen while this happened
18:35:07 *** TownsendHardware has quit IRC
18:37:47 *** TownsendHardware has joined #gnucash
18:45:29 *** Mechtilde has joined #gnucash
18:47:44 *** kael has quit IRC
18:48:17 *** TownsendHardware has quit IRC
18:48:32 *** Mechtilde has quit IRC
18:49:07 *** TownsendHardware has joined #gnucash
19:01:40 *** Aussie_matt has joined #gnucash
19:36:47 *** Mechtilde has joined #gnucash
19:39:47 *** Mechtilde has quit IRC
20:10:53 *** Mechtilde has joined #gnucash
20:13:54 *** Mechtilde has quit IRC
20:14:24 *** zoid has quit IRC
20:15:25 *** zoid has joined #gnucash
20:15:25 *** ChanServ sets mode: +v zoid
20:16:43 <chris> CDB-Work: no idea how sankey.js colorizes the chart boxes
20:17:11 <chris> CDB-Work: We can convert split amounts to report-currency using pricedb at split-date
20:19:07 <CDB-Work> that works, the issue being of course to populate pricedb with prices on every split date
20:19:41 <CDB-Work> this actually has me thinking of another issue that i dont think has been contemplted yet
20:20:57 <CDB-Work> if you run (any) report in the register's home currency, then in theory, pricedb should have a price entry for every fx date on every split date that exists in the entire book, assuming an initial one time fix of the book is done upon initial conversion
20:21:20 <CDB-Work> that said, if someone were to run (any) report in a currency other than book home currency, where would all the prices come from?
20:21:26 <chris> TR uses nearest
20:21:54 <chris> 'nearest' can jump 2 currencies
20:22:12 <chris> i.e. CAD->USD->GBP
20:22:15 <chris> gtg
20:22:23 <CDB-Work> example, if my home currency is CAD and i have USD transactions, then running a balance sheet in CAD will obviously work. running multi column also works. but what if i run a balance sheet in USD? or worse, i run one in EUR?
20:22:46 <CDB-Work> my pricedb currently has 0 EUR>anything prices
20:22:52 <CDB-Work> no EUR to CAD, or to USD, etc
20:24:08 <CDB-Work> under current rules we would simply do nearest in time. which would in this example, probably mean pulling a price today from alphavantage, and using that for my EUR report. if im running a report dated today it's passible. but if im running a balance sheet report dated dec 31st then it's pretty far off
20:24:17 <CDB-Work> advance this thinking 1 step further
20:25:04 <CDB-Work> if i am running a balance sheet that looks to convert each split on a per split basis using fx rates at that split, that's a lot of retro lookups. so i would think then the "failsafe" would be to use nearest price, which is current behaviour
20:25:43 <CDB-Work> since realistically, any "one time" fixes on conversion to a newer version of gnucash with historic price lookups, is only practical doing it once for 1 currency, namely the book's home currency (e.g. CAD for me)
20:28:23 <CDB-Work> this is all just me thinking out loud
21:11:51 *** jervin has quit IRC
21:47:19 *** joo has quit IRC
21:50:36 *** Aussie_matt has quit IRC
21:50:41 *** Aussie_matt has joined #gnucash
22:16:10 *** lmat has quit IRC
22:17:55 *** lmat has joined #gnucash
22:19:07 *** David has quit IRC
22:19:11 *** David has joined #gnucash
22:22:52 *** Agfarmer18 has joined #gnucash
22:26:45 *** Agfarmer18 has quit IRC
22:31:55 *** lmat has quit IRC
22:35:00 *** lmat has joined #gnucash
22:39:41 *** meneldur has quit IRC
23:14:25 *** lmat has quit IRC
23:14:27 *** lmat has joined #gnucash
23:34:16 *** Mechtilde has joined #gnucash
23:37:17 *** Mechtilde has quit IRC
23:42:43 *** CDB-Work has quit IRC
23:52:35 *** joo has joined #gnucash
23:54:09 *** dtux has joined #gnucash