2019-08-03 GnuCash IRC logs
02:08:42 *** gncbot has joined #gnucash
03:21:26 *** bertbob has quit IRC
03:54:27 *** gncbot has joined #gnucash
03:58:46 *** Aussie_matt has joined #gnucash
04:08:03 *** storyjesse has joined #gnucash
04:17:15 <chris> what example strings are matched in this regex? --> solved
04:25:51 *** fell has joined #gnucash
04:25:51 *** ChanServ sets mode: +o fell
04:55:25 *** gncbot has joined #gnucash
04:59:38 <chris> ~~
05:39:58 *** gncbot has joined #gnucash
05:46:55 *** storyjesse has quit IRC
08:54:59 *** gncbot has joined #gnucash
08:55:02 <warlord> Unfortunately I am away for the next 4 days so if it doesn't stabilize I wont be able to do much until at least Wednesday. And indeed I'll be away from IRC starting in about 30 minutes until late Tuesday.
08:55:35 *** warlord sets mode: +o gncbot
08:55:51 <fell> So we will send you emails or SMS's.
08:55:56 <warlord> Okay, supybot restarted. If it doesn't stick around then it's a network issue and I wont be able to do much about it I'm afraid.
09:00:27 *** fell has quit IRC
09:01:35 *** fell has joined #gnucash
09:01:35 *** ChanServ sets mode: +o fell
09:33:20 *** jervin has joined #gnucash
10:20:15 *** fabior has quit IRC
10:29:46 <chris> jralls I think my recent changes to eguile-html-utilties.scm has created a scheme dependency which causes ninja to complain. I'm not sure how to fix. eguile-html-utilities.scm now depends on eguile-gnc.scm.
10:31:12 <chris> rerun ninja is fine
10:41:21 <chris> if this is too difficult especially with gjanssen's modules juggling in master, I'll remove the eguile-html-utilities.scm dependency, which is fine
10:57:51 <fell> chris, are the invoices ignoring File->Properties->Counters->Invoice Number Format?
11:00:10 <chris> huh I have no idea, I'm not involved in generating invoice numbers
11:01:10 <fell> I thought, you are the schemer...
11:01:31 <chris> the scheme part only defines the number format stored in book kvp
11:01:45 <chris> something else must retrieve it to generate invoice number
11:04:10 <fell> I would expect that part in i.e. https://github.com/Gnucash/gnucash/blob/maint/gnucash/report/business-reports/invoice.scm
11:06:55 <fell> I got the question on ML gnucash-de
11:08:01 <chris> invoice reports have never queried the invoice number format
11:08:20 <chris> I have no idea what uses them
11:22:13 *** phoenix has quit IRC
11:22:13 *** jonas has quit IRC
11:22:13 *** wget_ has quit IRC
11:22:13 *** FoxT has quit IRC
11:22:13 *** CDB-Man_ has quit IRC
11:22:13 *** jralls has quit IRC
11:22:13 *** JayC has quit IRC
11:22:13 *** mdf has quit IRC
11:22:13 *** Derperperd has quit IRC
11:22:13 *** akv has quit IRC
11:22:13 *** markvandenborre has quit IRC
11:22:13 *** sbluhm has quit IRC
11:22:13 *** warlord has quit IRC
11:22:13 *** kapip has quit IRC
11:22:13 *** omnireq has quit IRC
11:22:13 *** Unhammer has quit IRC
11:22:13 *** karelk has quit IRC
11:22:13 *** yyoshino has quit IRC
11:22:15 *** zipppy has quit IRC
11:22:15 *** jethrogb has quit IRC
11:22:15 *** immae has quit IRC
11:22:15 *** Median has quit IRC
11:22:15 *** Farelli_ has quit IRC
11:22:15 *** flips has quit IRC
11:22:15 *** melooni has quit IRC
11:22:15 *** fell has quit IRC
11:22:15 *** bertbob has quit IRC
11:22:15 *** Mechtilde has quit IRC
11:22:15 *** g5pw has quit IRC
11:22:15 *** chris has quit IRC
11:22:15 *** Cork has quit IRC
11:22:15 *** jerryq has quit IRC
11:22:15 *** lagertonne has quit IRC
11:22:15 *** fiddlerwoaroof has quit IRC
11:22:15 *** exarkun has quit IRC
11:22:15 *** ecdhe has quit IRC
11:22:15 *** crossan007_ has quit IRC
11:22:15 *** psmst has quit IRC
11:24:19 *** oozer has joined #gnucash
11:24:19 *** fell has joined #gnucash
11:24:19 *** warlord has joined #gnucash
11:24:19 *** phoenix has joined #gnucash
11:24:19 *** kapip has joined #gnucash
11:24:19 *** bertbob has joined #gnucash
11:24:19 *** Mechtilde has joined #gnucash
11:24:19 *** omnireq has joined #gnucash
11:24:19 *** Unhammer has joined #gnucash
11:24:19 *** wget_ has joined #gnucash
11:24:19 *** CDB-Man_ has joined #gnucash
11:24:19 *** g5pw has joined #gnucash
11:24:19 *** chris has joined #gnucash
11:24:19 *** karelk has joined #gnucash
11:24:19 *** jralls has joined #gnucash
11:24:19 *** yyoshino has joined #gnucash
11:24:19 *** JayC has joined #gnucash
11:24:19 *** Cork has joined #gnucash
11:24:19 *** jerryq has joined #gnucash
11:24:19 *** zipppy has joined #gnucash
11:24:19 *** mdf has joined #gnucash
11:24:19 *** Derperperd has joined #gnucash
11:24:19 *** jethrogb has joined #gnucash
11:24:19 *** markvandenborre has joined #gnucash
11:24:19 *** lagertonne has joined #gnucash
11:24:19 *** immae has joined #gnucash
11:24:19 *** melooni has joined #gnucash
11:24:19 *** flips has joined #gnucash
11:24:19 *** Median has joined #gnucash
11:24:19 *** Farelli_ has joined #gnucash
11:24:19 *** fiddlerwoaroof has joined #gnucash
11:24:19 *** exarkun has joined #gnucash
11:24:19 *** ecdhe has joined #gnucash
11:24:19 *** crossan007_ has joined #gnucash
11:24:19 *** psmst has joined #gnucash
11:24:19 *** irc.eagle.y.se sets mode: +oqovvvvovvv fell warlord warlord bertbob CDB-Man_ g5pw chris jralls JayC mdf flips
11:25:25 *** akv has joined #gnucash
11:27:02 *** phoenix has quit IRC
11:30:15 *** FoxT has joined #gnucash
11:37:26 *** jonas has joined #gnucash
11:38:00 *** sbluhm has joined #gnucash
11:38:00 *** ChanServ sets mode: +v sbluhm
11:48:21 *** omnireq has quit IRC
11:51:42 *** omnireq has joined #gnucash
11:51:43 <jralls> chris, I don't remember the context of the query content, but if you're referring to querying the book AFAIK the only way to do so is via QofQuery. What's "Scheme query"?
11:53:49 <chris> jralls remember my early days of hacking transaction.scm I was doing (define accounts (gnc-account-get-descendants root)) (define splits (map xaccAccountGetSplitList accounts)) ad nauseam
11:54:48 <chris> (filter (lambda (acc) (equal? (xaccAccountGetName acc) accname) accounts) etc instead of xaccQueryAccountMatch
12:03:09 <jralls> There is no xaccQueryAccountMatch, but the reasons for using QofQuery instead of ad-hoc filtering with Scheme are that using QofQuery can be easily converted to SQL queries when I convert the XML backend to generating an in-memory SQL DB.
12:05:57 <jralls> Before that QofQuery will in many cases get the results you want more efficiently because it traverses the split and transaction collections directly instead of through the separate transaction split lists.
12:08:18 <jralls> From a program design standpoint using QofQuery instead of direct API calls reduces the coupling of the report system with the engine API so that the engine API can be rationalized and updated without having to change reports in parallel.
12:15:41 <chris> So, if the multiple QofQueries are causing slowdowns I guess reducing to 1 Query and partitioning the splitlist is still a worthwhile strategy eg aging.scm?
12:22:13 <jralls> Yes, better to get all of the results in 1 QofQuery run and then split that up. Traversing the collections is slow, especially on a large book, so you want to do it only once.
12:23:34 <chris> Ok; late here gtg
12:23:49 <chris> let me know eguile-html-utilities.scm and ninja complaints
12:31:20 <jralls> chris: It's been a week and Travis is happy, so I think you just had a glitch on your machine.
12:36:08 <fell> Edit Invoice uses the Invoice number format.
12:51:54 <fell> and later this Invoice ID is also used in print invoice.
12:52:52 <fell> So the trick seems to be: Do not enter manually the invoice Nr in invoice ID.
13:29:05 *** JayC has quit IRC
13:36:54 *** JayC has joined #gnucash
13:36:55 *** ChanServ sets mode: +v JayC
13:39:04 *** jangid has joined #gnucash
14:04:44 *** frakturfreak has joined #gnucash
14:52:19 *** kapip has quit IRC
15:45:52 *** bertbob has quit IRC
16:10:58 *** jangid has quit IRC
16:12:37 *** fell has quit IRC
16:52:48 *** bertbob has joined #gnucash
16:52:49 *** ChanServ sets mode: +v bertbob
18:34:17 *** jervin has joined #gnucash
18:43:46 *** jervin has quit IRC
19:27:47 *** frakturfreak has quit IRC
19:39:29 *** phoenix has joined #gnucash
19:41:37 *** phoenix has quit IRC
19:42:30 *** frakturfreak has joined #gnucash
19:42:30 *** ChanServ sets mode: +v frakturfreak
19:59:32 *** phoenix has joined #gnucash
20:04:36 *** phoenix has quit IRC
20:15:14 *** cody has joined #gnucash
20:15:17 *** cody has left #gnucash
20:16:06 *** cody has joined #gnucash
20:16:09 *** cody has left #gnucash
20:22:34 *** cody has joined #gnucash
20:22:37 *** cody has left #gnucash
20:33:27 *** cody has joined #gnucash
20:33:30 *** cody has left #gnucash
20:37:58 *** cody has joined #gnucash
20:38:01 *** cody has left #gnucash
21:07:00 *** oozer has quit IRC
21:15:21 *** omnireq has quit IRC
21:16:55 *** omnireq has joined #gnucash
21:17:41 <chris> fwiw the QIF importer matcher is a nicer dialog than the generic matcher, unless #518 is completed
21:19:12 <chris> jralls I had been wondering whether QofQuery was preferable because of planned locality of split-data i.e. QofQuery would avoid retrieving from database until the query is run
21:31:45 *** frakturfreak has quit IRC
22:04:21 *** Aussie_matt has joined #gnucash
22:43:50 *** fell has joined #gnucash
22:43:50 *** ChanServ sets mode: +o fell
23:12:53 *** chris has quit IRC
23:16:12 *** chris has joined #gnucash
23:16:12 *** ChanServ sets mode: +v chris
23:23:17 *** gnomey has quit IRC
23:23:22 *** Aussie_matt has quit IRC
23:27:31 *** gnomey has joined #gnucash
23:46:15 <chris> I can confirm qif-import is now much faster