2018-09-11 GnuCash IRC logs
00:00:22 *** Mechtilde has joined #gnucash
00:05:38 *** Mechtilde has quit IRC
00:10:35 *** arahael1 has joined #gnucash
00:12:20 *** arahael has quit IRC
00:14:30 *** Mechtilde has joined #gnucash
00:40:40 *** jralls has quit IRC
00:52:39 *** philippirrip has quit IRC
00:53:24 *** kus has quit IRC
00:55:15 *** kus has joined #gnucash
00:55:18 *** philippirrip has joined #gnucash
01:06:22 *** mdforbis_ has quit IRC
01:24:00 *** mdf has joined #gnucash
01:24:27 *** Mechtilde has quit IRC
01:26:02 *** jralls has joined #gnucash
01:26:03 *** ChanServ sets mode: +o jralls
01:26:06 *** mdf has quit IRC
01:26:16 *** mdf has joined #gnucash
01:30:43 *** jralls has quit IRC
01:35:48 *** Mechtilde has joined #gnucash
01:39:44 <fell> Guten Morgen, Mechtilde!
01:40:05 <Mechtilde> Guten Morgen Frank
01:40:42 <fell> Hast du Netzwerkprobleme? Du verschwindest öfters und erscheist kurz darauf wieder.
01:41:00 <Mechtilde> weil mir noch was einfällt
01:41:16 <Mechtilde> und dann der autoconnect zuschlägt
01:41:19 <fell> Das kenne ich. :-)
01:42:02 <fell> Verfolgst du die Doku-Diskussion auf Devel?
01:43:44 <Mechtilde> nur wenig
01:44:36 *** fell_laptop has joined #gnucash
01:45:09 <fell_laptop> Als Übersetzer bin ich wenig begeistert, wenn Sunfish alles neu schreiben will.
01:45:30 *** gncbot sets mode: +o fell_laptop
01:45:50 *** fell was kicked by fell_laptop (User terminated!)
01:50:56 *** fell_laptop is now known as fell
01:52:38 <Mechtilde> das betrifft ja dann alle Übersetzer
01:53:22 <Mechtilde> ich ahbe aber gerade ein paar andere Baustellen
01:54:43 <fell> Da möchte ich dich jetzt nicht von abhalten.
02:00:14 <Mechtilde> erstmal afk
02:00:27 <fell> Viel Spaß!
02:03:14 *** Mechtilde has quit IRC
02:11:08 *** gjanssens has joined #gnucash
02:11:09 *** ChanServ sets mode: +o gjanssens
02:11:21 <gjanssens> .
02:17:25 *** JayC has quit IRC
02:19:06 <fell> Gjanssens, you could ask older Wallons about english parts in french manuals. ;-)
02:21:17 <gjanssens> fell: I could if I knew older Wallons that use gnucash :)
02:21:57 <gjanssens> But seriously: what is worse: incomplete documentation or on partly translated but complete translation ? I really don't know.
02:28:24 *** jotrago has quit IRC
02:32:04 <fell> If I really had understood the olink example in the TDG, I would use it for interlingual linking.
02:36:53 *** JayC has joined #gnucash
02:40:32 *** chf has quit IRC
02:41:06 *** chf has joined #gnucash
02:43:20 *** JayC has quit IRC
02:45:45 *** JayC has joined #gnucash
03:02:54 *** Mechtilde has joined #gnucash
03:32:27 *** Mechtilde has quit IRC
03:45:21 *** boldstripe has joined #gnucash
03:47:20 *** immae has quit IRC
03:52:45 *** immae has joined #gnucash
03:53:45 *** ncv has joined #gnucash
03:54:36 *** immae has quit IRC
03:55:19 *** immae has joined #gnucash
03:57:55 *** immae has quit IRC
03:59:03 *** immae has joined #gnucash
04:23:38 <gjanssens> Wow, my brain wasn't working straight this morning...
04:24:30 <gjanssens> I meant that sentence to read: what is worse: fully translated but incomplete documentation or only partially translated but complete documentation ? I really don't know.
04:29:07 *** immae has joined #gnucash
04:41:05 <fell> gjanssens: but the meaning was clear from the context.
04:42:50 <fell> I just realized a blocker, which I had for weeks: terms like db2html invoked the question "Which database?", but it means docbook to html.
05:22:04 *** pilotauto has quit IRC
05:29:21 *** jralls has joined #gnucash
05:29:21 *** ChanServ sets mode: +o jralls
05:33:25 *** jralls has quit IRC
05:49:17 *** jotrago has joined #gnucash
05:49:51 *** boldstripe has quit IRC
06:01:37 *** fabior has joined #gnucash
06:28:10 <chris> fell etc I was reading irc log in google chrome and everything was autotranslated in english ;-)
06:38:00 *** fabior has quit IRC
06:49:42 *** fekepp has joined #gnucash
06:52:24 *** fekepp has quit IRC
06:52:43 *** fekepp has joined #gnucash
07:00:07 *** oozer has joined #gnucash
07:07:53 <warlord> .
07:11:34 *** storyjesse has joined #gnucash
07:32:42 *** fell has quit IRC
07:39:36 *** ncv has quit IRC
07:40:05 *** ncv has joined #gnucash
07:43:24 *** Mechtilde has joined #gnucash
07:46:23 *** fell has joined #gnucash
07:46:31 *** Mechtilde has quit IRC
07:57:24 *** fell has quit IRC
07:59:53 *** fell has joined #gnucash
08:14:02 *** Mechtilde has joined #gnucash
08:15:01 *** boldstripe has joined #gnucash
08:16:30 *** boldstripe has quit IRC
08:17:06 *** jotrago has quit IRC
09:06:43 *** jotrago has joined #gnucash
09:32:51 *** jralls has joined #gnucash
09:32:51 *** ChanServ sets mode: +o jralls
09:35:51 *** jralls has quit IRC
09:56:03 *** chf has quit IRC
09:56:34 *** chf has joined #gnucash
10:13:10 *** zipppy has quit IRC
10:27:48 *** zipppy has joined #gnucash
10:34:50 *** fabior has joined #gnucash
10:40:52 *** sixwheeledbeast has quit IRC
10:44:54 *** wget has quit IRC
10:44:54 *** chf has quit IRC
10:44:54 *** chf has joined #gnucash
10:44:54 *** wget has joined #gnucash
10:50:00 *** Mechtilde has quit IRC
11:24:52 *** storyjesse has quit IRC
11:37:38 *** greenshoe has joined #gnucash
11:38:28 <greenshoe> Invoiced? - X means the item is attached to this invoice, an empty box means the item is not attached to this invoice. If the box is empty you can attach the item to the invoice by first selecting the item row and then clicking in this box.”
11:38:49 <greenshoe> Well that was not the behavior I expected from my irc client.
11:39:06 <warlord> greenshoe: Oh?
11:39:14 <warlord> What behavior did you expect? ;)
11:40:00 <greenshoe> I expected that to paste *after* what I had just typed... soo what I meant to ask was, what does that item "Invoiced?" mean? I see the description I pasted above in https://www.gnucash.org/docs/v3/C/gnucash-help/busnss-ap-bills1.html
11:40:38 <greenshoe> But I'm not sure I understand. Also when entering a bill it is not clickable for me.
11:40:59 <greenshoe> What would it mean for the item NOT to be attached to this invoice. And by "invoice" are we talking about the bill?
11:41:42 <warlord> It's all about chargebacks
11:41:57 <warlord> You get to decide which chargebacks get attached to which invoice.
11:44:33 *** greenshoe has quit IRC
11:45:14 *** greenshoe has joined #gnucash
11:45:15 *** greenshoe has joined #gnucash
11:46:23 *** fabior has quit IRC
11:48:41 *** greenshoe has quit IRC
11:49:50 *** jralls has joined #gnucash
11:49:50 *** ChanServ sets mode: +o jralls
11:50:59 *** greenshoe has joined #gnucash
11:57:51 <jralls> gjanssens, fell: I've always assumed that fully-translated but obsolete is more useful than partly-translated but up-to-date as long as it's not too obsolete. But I'm worried that the Italian and Japanese docs are getting too obsolete.
12:10:48 <greenshoe> warlord: So since I don't have Accounts Receivable set up, then I wouldn't use the feature, because this feature is only for charging back to clients, correct?
12:11:22 <warlord> Correct, if you only have A/P and don't have A/R then you'd never use chargebacks.
12:19:24 *** greenshoe has quit IRC
12:19:33 *** greenshoe has joined #gnucash
12:19:37 *** greenshoe has quit IRC
12:19:58 *** greenshoe has joined #gnucash
12:21:09 *** fabior has joined #gnucash
12:22:58 *** greenshoe has quit IRC
12:25:09 *** Mechtilde has joined #gnucash
12:35:38 *** greenshoe has joined #gnucash
13:01:30 *** fabior has quit IRC
13:12:22 *** greenshoe has quit IRC
13:12:29 <jralls> gjanssens: Did you make any progress with the slow sqlite3 load?
13:21:41 *** chf has quit IRC
13:22:05 *** chf has joined #gnucash
13:24:08 *** calvinct has joined #gnucash
13:27:44 *** calvinct has quit IRC
13:35:59 *** ncv has quit IRC
14:23:21 *** frakturfreak has joined #gnucash
14:49:18 *** jethrob has quit IRC
14:49:28 <gjanssens> jralls: I haven't dne much with the sqlite3 stuff yet.
14:49:58 <gjanssens> But the trace suggests it's not one single slow query but thousands of individual slot queries
14:50:16 <gjanssens> More on that later
14:50:21 <gjanssens> Time for supper
14:53:18 <jralls> OK. Not surprised.
15:04:36 *** Mechtilde has quit IRC
15:08:04 * warlord wonders if it makes sense to make a clean break -- develop a DB-based app back end for GnuCash and just use the XML as an import/export format... But drop QOF .
15:13:02 *** greenshoe has joined #gnucash
15:16:02 *** greenshoe has quit IRC
15:22:02 *** greenshoe has joined #gnucash
15:25:02 *** greenshoe has quit IRC
15:30:23 <gjanssens> warlord: I believe that's the ultimate goal of all the refactorings
15:30:55 <warlord> gjanssens: including dropping QOF?
15:31:16 *** greenshoe has joined #gnucash
15:31:51 <jralls> warlord: *Especially* dropping QOF!
15:33:04 <jralls> As you pointed out on the user list the other day, QOF is inefficient with large data sets.
15:35:44 <jralls> I was also reflecting on what a pain it is that QOF returns object pointers and one has to then manipulate those to extract the data one needs to write a report.
15:39:19 <jralls> So you query the transactions posted in a date range. Then you iterate through the list of transactions to get the splits, checking each one to see if it's for the account you're interested in (and you had to query for the account ptr first to be able to do that). Then you iterate over the split list to get the amount. Oh, back to each split's parent transaction to find out what currency the value is in.
15:39:44 <jralls> It's no wonder so few people can write a custom report!
15:45:31 <warlord> jralls: The original search function was limited to splits/transactions, and it could short-circuit by searching an Account SplitList when you limited the accounts in question.
15:45:48 <warlord> This got lost in the conversion to the generic QOF Search.
15:47:46 <jralls> Too bad, but I suspect it would be more work to bring that back than to just enable searching with SQL.
15:48:10 <warlord> I think so, too.
15:48:36 <warlord> (it was lost because it was a special-case, and I didn't want to keep around a special-case)
15:57:05 <jralls> I guessed that it was something like that.
15:59:22 <jralls> But even with that specialization the search still returned a list of Split* that you had to query one at a time to get the amounts, values, and the parent-transaction's currency and the split-account's commodity.
15:59:58 <jralls> So no matter what the report writer needs to have a good understanding of the engine API to succeed. That's a high bar.
16:01:16 *** calvinct has joined #gnucash
16:05:31 <gjanssens> Yeah, gnucash contributions are reserved for athletes :s
16:16:29 <warlord> Sure, but even with SQL I don't see how that would be any different -- modulo using something like "SELECT X,Y,Z from ..."
16:17:04 <jralls> That's the usual way to use SQL...
16:19:44 *** calvinct has quit IRC
16:24:05 <warlord> True.
16:27:00 <jralls> gjanssens: Back to loading slots. Are the bazillion queries coming from splits or business objects?
16:33:49 <gjanssens> jralls: I haven't analyzed it fully. Would you like a copy of the trace to see for yourself ?
16:33:59 <jralls> Sure.
16:34:02 <gjanssens> The first long list of slot querying happens for lots
16:34:21 <jralls> Are there lots of lots?
16:34:35 <jralls> (Meaning many, not nested.)
16:36:01 <gjanssens> I think so
16:36:14 <gjanssens> Each invoice/bill creates its own lot
16:36:29 <gjanssens> The tracefile is on its way via email
16:41:18 <gjanssens> According to sqlitebrowser there are 24409 lots in this book
16:41:58 <gjanssens> And 23487 invoices
16:44:22 *** frakturfreak has quit IRC
16:45:39 *** oozer has quit IRC
16:45:59 <gjanssens> Ok time to go.
16:46:01 <gjanssens> Night!
16:46:40 *** gjanssens has quit IRC
17:00:28 *** jethrob has joined #gnucash
17:02:05 *** greenshoe has quit IRC
17:11:16 *** greenshoe has joined #gnucash
17:28:09 *** calvinct has joined #gnucash
17:28:52 *** calvinct has quit IRC
17:29:23 *** KevinDB has quit IRC
17:32:32 *** calvinct has joined #gnucash
17:36:00 *** KevinDB has joined #gnucash
17:39:28 *** calvinct has quit IRC
18:07:24 *** greenshoe has quit IRC
18:11:07 *** oozer has joined #gnucash
18:12:35 *** greenshoe has joined #gnucash
18:38:41 *** pilotauto has joined #gnucash
19:20:54 *** greenshoe has quit IRC
19:23:29 *** greenshoe has joined #gnucash
19:23:52 *** greenshoe has quit IRC
19:23:52 *** greenshoe has joined #gnucash
20:49:29 *** greenshoe has quit IRC
20:55:15 *** kael has joined #gnucash
21:00:38 *** oozer has quit IRC
21:03:46 *** bertbob has quit IRC
21:05:11 *** bertbob has joined #gnucash
21:08:20 *** bertbob has quit IRC
21:18:19 * chris now knows how to speed up net-charts and category-barchart x1000
21:19:36 <chris> old code was calculating intervals/balances by qof-querying splits for every account/interval/date
21:19:52 <chris> (drumroll) introduce xaccAccountGetBalanceAsOfDate
21:20:25 <chris> now we just need testing
21:23:02 *** bertbob has joined #gnucash
21:38:24 <chris> these charts are now instaneous :)
21:39:08 *** Derperperd has quit IRC
21:39:43 *** Derperperd has joined #gnucash
21:42:07 *** badger92 has quit IRC
22:11:56 <chris> (for me) ^_^
22:29:01 *** bertbob has quit IRC
22:30:22 *** bertbob has joined #gnucash
22:49:51 *** greenshoe has joined #gnucash
22:52:51 *** greenshoe has quit IRC
23:30:00 *** storyjesse has joined #gnucash