2019-03-27 GnuCash IRC logs
01:14:32 *** storyjesse has joined #gnucash
01:31:21 *** boldstripe has quit IRC
01:32:46 *** boldstripe has joined #gnucash
01:51:59 *** nicoroumeau has joined #gnucash
01:57:38 *** nicoroumeau has quit IRC
01:58:37 *** nicoroumeau has joined #gnucash
02:13:28 *** nicoroumeau has quit IRC
02:19:18 *** storyjesse has quit IRC
02:41:57 *** fell_desktop has quit IRC
02:42:20 *** fell has quit IRC
02:42:43 *** bertbob has quit IRC
02:43:13 *** fell_desktop has joined #gnucash
02:43:41 *** fell has joined #gnucash
02:43:41 *** ChanServ sets mode: +o fell
02:48:51 *** bertbob has joined #gnucash
02:48:51 *** ChanServ sets mode: +v bertbob
03:19:13 *** gjanssens has joined #gnucash
03:19:13 *** ChanServ sets mode: +o gjanssens
03:19:39 <gjanssens> .
03:32:31 *** boldstripe has quit IRC
03:33:57 *** boldstripe has joined #gnucash
04:03:04 *** warlord has quit IRC
04:03:08 *** warlord has joined #gnucash
04:03:08 *** gncbot sets mode: +o warlord
04:15:22 *** fabior has joined #gnucash
04:41:42 *** mklnos has joined #gnucash
04:53:59 *** Aussie_matt has quit IRC
05:33:42 *** boldstripe has quit IRC
05:35:07 *** boldstripe has joined #gnucash
05:37:42 *** fabior has quit IRC
05:40:49 *** fabior has joined #gnucash
05:50:28 *** fabior has quit IRC
05:55:50 *** fabior has joined #gnucash
06:05:01 *** intangir has quit IRC
06:15:58 *** bertbob has quit IRC
06:17:15 *** bertbob has joined #gnucash
06:17:15 *** ChanServ sets mode: +v bertbob
06:19:46 *** Jimraehl1 has joined #gnucash
06:20:10 *** Jimraehl1 has left #gnucash
06:49:45 *** oozer has joined #gnucash
07:01:10 *** nimish2711 has joined #gnucash
07:05:15 *** jervin has joined #gnucash
07:06:24 *** lcanaska has joined #gnucash
07:11:45 *** storyjesse has joined #gnucash
07:27:30 *** jervin has quit IRC
07:40:30 *** fabior has quit IRC
07:40:38 *** boldstripe has quit IRC
07:43:13 *** boldstripe has joined #gnucash
07:49:24 <warlord> .
08:00:19 *** warlord has quit IRC
08:03:35 *** warlord has joined #gnucash
08:03:35 *** gncbot sets mode: +o warlord
08:06:34 *** chris has joined #gnucash
08:06:34 *** ChanServ sets mode: +v chris
08:06:39 <chris> .
08:06:39 <gncbot> chris: Sent 11 hours and 17 minutes ago: <jralls> I'm not going to have time to work on that either until after release + taxes.
08:39:56 *** gnomey has quit IRC
08:45:09 *** gnomey has joined #gnucash
08:54:08 *** jervin has joined #gnucash
08:57:38 *** jervin has quit IRC
08:57:50 *** jervin has joined #gnucash
09:02:43 <chris> good progress to save reports into kvp tree instead of live scheme :)
09:03:24 <warlord> cool!
09:19:22 <chris> I even found bug in your code... did you mean to overwrite the 'list' keyword in https://github.com/Gnucash/gnucash/commit/d461f68d6f93659172b509e46f8e68321e42ffb4#diff-6549144649808b01099eb92cfc057d26R606 ? note 3 lines later code tries to use 'list' which is now overwritten ^_^
09:19:50 <chris> never been tested in 17 years
09:42:05 *** mklnos has quit IRC
09:54:09 *** jervin has quit IRC
09:56:19 *** fabior has joined #gnucash
10:01:04 *** fabior has quit IRC
10:11:05 *** fabior has joined #gnucash
10:14:08 *** storyjesse has quit IRC
10:25:04 *** jerryq has quit IRC
10:35:49 *** fabior has quit IRC
10:38:57 *** fabior has joined #gnucash
10:48:54 *** kael has joined #gnucash
10:48:54 *** ChanServ sets mode: +v kael
10:49:16 *** lcanaska has quit IRC
10:51:16 *** kael has quit IRC
10:58:00 <chris> So I wouldn't claim to understand pros/cons of kvp/sql-tables, but the report->kvp seems a good choice... at most there would be maybe 102- options needing to be saved per saved-report.
10:59:07 <chris> I've now completed book-saved-reports using kvp only. next job is to fix this for embedded-reports.
11:03:25 <warlord> chris, the issue is the length of the table row. If you're storing scheme in a single string, it might be "too big"
11:05:42 <chris> Thence kvp save: https://pastebin.com/raw/QfaZ7cjF :)
11:06:57 <chris> thanks to your foresight I didn't have to write the serialization routines for each option-type
11:09:29 <warlord> you're welcome :)
11:12:31 <chris> "at most there would be maybe *10-20* options needing to be saved per saved-report."
11:13:14 <warlord> .. which should be under the 4k limit (assuming you have separate keys per report)
11:13:48 *** jerryq has joined #gnucash
11:14:21 *** mklnos has joined #gnucash
11:15:28 <chris> I guess https://en.wikipedia.org/wiki/Varchar is the cause
11:20:22 *** fabior has quit IRC
11:27:52 <gjanssens> chris: nice to see you make progress here :)
11:28:16 <gjanssens> However I'm not too fond of your use of hierarchical slots
11:28:33 <gjanssens> We were trying to move away from this as it's a nightmare in sql
11:28:55 *** kael has joined #gnucash
11:28:55 *** ChanServ sets mode: +v kael
11:29:53 <gjanssens> If you really want to use slots, at best make a toplevel frame for saved-reports and the one slot below this containing the complete report definition
11:30:21 <gjanssens> Initially perhaps as the executable guile string we had or otherwise immediately as a json blob
11:35:44 *** kael has quit IRC
11:38:13 <chris> my preference would be json blob because it will also be doubly useful for saving tabbed-reports
11:39:19 <chris> isn't json-in-xml or json-in-sql a bad hack?
11:40:17 <warlord> I think a json-blob is fine
11:40:26 <warlord> or even a CBOR blob
11:59:02 *** mklnos has quit IRC
12:00:25 <chris> gjanssens the executable guile string is exactly the state of my branch until HEAD^3
12:01:50 <chris> the issue will still be 4K limit
12:01:54 <gjanssens> chris: my apologies, I haven't had time to actually look at the code...
12:02:42 <gjanssens> the 4K limit may be an issue, we don't know yet :)
12:02:53 <chris> that's fine. i'm working away hence productive this week
12:03:13 <chris> i can limit to 1-slot-per-report
12:03:38 <chris> initially 1-slot=serialized, then 1-slot=json-string
12:03:39 <gjanssens> That's what I suggested, though perhaps not very clearly...
12:03:50 <gjanssens> And there's no need for a counter slot
12:04:06 <gjanssens> All slots in the "saved-reports" frame will be saved-reports
12:05:12 *** ArtGravity has joined #gnucash
12:05:12 *** ChanServ sets mode: +v ArtGravity
12:09:43 <chris> I just tried... (qof-book-get-option b '("custom-templates")) doesn't give me the whole subtree, it segfaults. So I'll use counter.
12:11:52 <chris> off now
12:14:07 <gjanssens> I don't like it, but if that's how the function currently works...
12:18:03 *** chris has quit IRC
12:36:04 *** jervin has joined #gnucash
12:52:03 *** luc14n0 has quit IRC
12:59:42 *** mklnos has joined #gnucash
13:12:58 *** boldstripe has quit IRC
13:13:54 *** boldstripe has joined #gnucash
13:24:11 *** nicoroumeau has joined #gnucash
13:26:47 *** nicoroumeau has quit IRC
13:36:47 *** oozer has quit IRC
13:38:21 *** fabior has joined #gnucash
13:46:57 *** jervin has quit IRC
13:47:15 *** jervin has joined #gnucash
13:48:29 *** jervin has quit IRC
13:48:39 *** jervin has joined #gnucash
13:54:45 *** fabior has quit IRC
14:15:30 *** nicoroumeau has joined #gnucash
14:20:54 *** calvinct has joined #gnucash
14:20:57 *** nicoroumeau has quit IRC
14:30:39 *** bertbob has quit IRC
14:34:31 *** bertbob has joined #gnucash
14:34:32 *** ChanServ sets mode: +v bertbob
14:41:16 *** nicoroumeau has joined #gnucash
15:02:40 *** jervin has quit IRC
15:05:08 *** nicoroumeau has quit IRC
15:06:27 *** frakturfreak has joined #gnucash
15:06:27 *** ChanServ sets mode: +v frakturfreak
15:13:38 *** boldstripe has quit IRC
15:15:04 *** boldstripe has joined #gnucash
15:17:43 *** gjanssens has quit IRC
15:28:07 <fell> Which tooltip is better:
15:28:20 <fell> 1. Import a DTAUS file into GnuCash and transmit its orders by Online Banking
15:28:31 <fell> 2. Import a DTAUS file into GnuCash and send the transfers online through Online Banking.
15:30:23 <fell> jrall, did you already split aqb?
15:31:41 <fell> jralls
15:32:24 *** oozer has joined #gnucash
15:37:48 *** nicoroumeau has joined #gnucash
15:43:36 <fell> if not, can you rebase before splitting?
15:58:55 *** jervin has joined #gnucash
16:06:48 *** calvinct has quit IRC
16:20:44 *** mklnos has quit IRC
16:42:54 *** puck has quit IRC
16:43:24 *** nicoroumeau has quit IRC
16:59:49 *** puck has joined #gnucash
17:05:05 *** tienne has joined #gnucash
17:08:25 *** nicoroumeau has joined #gnucash
17:32:26 *** jervin has quit IRC
17:39:50 *** mklnos has joined #gnucash
17:41:01 *** Aussie_matt has joined #gnucash
17:43:31 *** jervin has joined #gnucash
17:54:01 *** tienne has quit IRC
17:55:15 *** jerryq has quit IRC
17:58:24 *** fell has quit IRC
17:58:44 *** fell has joined #gnucash
17:58:44 *** ChanServ sets mode: +o fell
18:00:06 *** nimish2711 has quit IRC
18:01:05 *** frakturfreak has quit IRC
18:17:36 *** nicoroumeau has quit IRC
18:40:26 *** gnomey has quit IRC
18:45:02 *** gnomey has joined #gnucash
19:01:06 *** User_ has joined #gnucash
19:03:55 *** mklnos has quit IRC
19:09:06 *** User_ has quit IRC
19:24:02 *** badger92 has quit IRC
19:24:53 *** badger92 has joined #gnucash
19:53:41 *** jervin has quit IRC
20:08:28 *** Agfarmer18 has joined #gnucash
20:09:23 *** Agfarmer18 has quit IRC
20:10:39 *** ArtGravity has quit IRC
21:37:49 *** jerryq has joined #gnucash
21:55:59 *** storyjesse has joined #gnucash
22:01:54 *** guak has joined #gnucash
22:05:21 *** boldstripe_ has joined #gnucash
22:05:29 *** boldstripe has quit IRC
22:05:31 *** boldstripe_ is now known as boldstripe
22:21:31 *** boldstripe_ has joined #gnucash
22:21:46 *** boldstripe has quit IRC
22:21:46 *** boldstripe_ is now known as boldstripe
22:39:25 *** oozer has quit IRC
22:42:18 *** badger92 has quit IRC
22:42:32 *** guak has quit IRC
22:42:51 *** badger92 has joined #gnucash
23:02:45 *** jervin has joined #gnucash
23:12:43 *** jervin has quit IRC