2018-06-06 GnuCash IRC logs
00:27:12 *** eagles0513875 has joined #gnucash
00:50:02 *** gour has joined #gnucash
01:06:13 *** fell_desktop has quit IRC
01:07:24 *** fell_desktop has joined #gnucash
01:25:20 *** Mechtilde has joined #gnucash
01:30:48 *** fekepp has quit IRC
01:49:58 *** bertbob has quit IRC
01:53:29 *** bertbob has joined #gnucash
01:59:27 *** Mechtilde has quit IRC
02:08:24 *** warlord has quit IRC
02:52:59 *** warlord has joined #gnucash
02:57:19 *** gjanssens has joined #gnucash
02:57:19 *** ChanServ sets mode: +o gjanssens
03:03:39 *** fabior has joined #gnucash
03:06:55 <gjanssens> .
03:10:24 <warlord> good morning, gjanssens
03:47:40 *** eagles0513876 has joined #gnucash
03:48:57 *** eagles0513875 has quit IRC
03:50:47 *** eagles0513876 has quit IRC
03:57:27 *** eagles0513875 has joined #gnucash
04:40:26 *** Mechtilde has joined #gnucash
04:52:32 *** fell_laptop has joined #gnucash
04:53:31 *** Mechtilde has quit IRC
05:01:40 *** fell_laptop has quit IRC
05:03:45 *** fekepp has joined #gnucash
05:12:45 *** fabior has quit IRC
05:14:43 *** gour_ has joined #gnucash
05:17:04 *** gour has quit IRC
05:22:48 *** warlord has quit IRC
05:23:31 *** fekepp has quit IRC
05:26:34 *** fabior has joined #gnucash
05:29:16 *** gour_ is now known as gour
05:31:21 *** fekepp has joined #gnucash
05:37:56 *** pilotauto has quit IRC
06:23:39 *** Jimraehl1 has joined #gnucash
06:26:50 *** Jimraehl1 has left #gnucash
06:29:18 *** User__ has joined #gnucash
06:29:45 *** Dee has joined #gnucash
06:35:38 *** User__ has quit IRC
06:39:24 *** Dee has quit IRC
06:51:27 *** fabior has quit IRC
07:11:16 *** Mechtilde has joined #gnucash
07:15:52 *** oozer has joined #gnucash
07:32:40 *** Mechtilde has quit IRC
07:37:08 *** xmaka has quit IRC
07:38:55 *** xmaka has joined #gnucash
08:09:29 *** warlord has joined #gnucash
08:19:40 *** hjek has joined #gnucash
08:20:21 *** ncv has joined #gnucash
08:27:49 <chris> warlord I'm a late entrant to this game... spoilt by modern guile, some knowledge of TDD and have git. i've never hacked php and don't intend to :)
08:27:51 *** lfs has joined #gnucash
08:28:55 *** lfs has quit IRC
08:29:49 <warlord> chris: A decade ago PHP was all the rage. Being able to make HTML a "live page" by embedding code into the HTML.
08:31:33 *** boldstripe has joined #gnucash
08:34:07 <chris> well for now I'm not so keen on hacking eguile templates. I can finally fix the regular ones well enough...
08:35:48 *** hjek has left #gnucash
08:36:33 <warlord> chris: fair enough
08:46:53 <warlord> If invoice.scm is more CSS capable, then e-guile might be less interesting. Half the point of e-guile was to make it "easier" to create a desired template in HTML using your favorite editor in order to make the invoices look good. If the same thing could be done with CSS then there's very little reason to stick with eguile.
08:51:54 <chris> amen
08:52:20 <chris> this is how your baby has now grown into https://github.com/christopherlam/gnucash/blob/scheme-progress-business-tests/gnucash/report/business-reports/invoice.scm
08:52:44 <chris> can do freetext css, <div class> <span class>
08:53:10 <warlord> chris: my baby -- all grown up! :)
08:53:12 <chris> i'm already looking at webkit capabilities and discovered that libwebkit1 on windows cannot do flexbox
08:53:28 <chris> she's a late bloomer
08:53:30 <warlord> I'll note that at the time, our HTML renderer did not support CSS, which is yet another reason it wasn't done back then.
08:53:46 <warlord> (GTKHtml)
08:54:42 *** fabior has joined #gnucash
08:55:06 <chris> in this iteration, search 'css' and '/markup' for the newest features
08:55:45 <chris> oops hang on letme repush, recheck in 5s
08:56:33 <chris> ok search 'div/markup', all of which can be style using freetext css
09:02:38 <warlord> I'm about to go offline -- heading to the airport to start my trip home.
09:03:48 <chris> cool, have safe trip
09:05:59 *** fell_laptop has joined #gnucash
09:07:35 <warlord> Thanks. I'll be back online either at the NCE airport, or once I get to MAD tonight.
09:07:46 <warlord> (probably both)
09:08:05 <warlord> Flight isn't for 3h32m but I'd rather not be late. ;)
09:08:12 <warlord> ... and I have to be out of my hotel soon anyways.
09:08:20 <warlord> TTFN
09:08:24 *** warlord has quit IRC
09:13:24 *** hampton has joined #gnucash
09:17:52 *** fell_desktop is now known as fell
09:18:11 *** harshitaneja has joined #gnucash
09:18:24 *** gncbot sets mode: +o fell
09:22:28 <fell> chf: I did not forget your templates, but am currntly short of time. So, if some other dev likes to add them, feel free to do it.
09:25:53 <hampton> Hi all. I recently noticed a problem with the Notes field on (double line) transactions. All of the notes in my database have disappeared. I can enter a note just fine, and as long as I stay in gnucash the note sticks around. When I quit and restart the note is gone. Before filing a bug I was trying to look into the sqlite file to see if the problem is writing out the notes, or reading back in the notes, but I can't find the no
09:25:53 <hampton> just by looking into the database. Its been over ten years since I regularly hacked on gnucash, so I thought it would be easier to ask than to try digging in the code. Does anyone know where the transaction notes field is recorded in the database.
09:25:57 <chf> fell, jralls looked into it and didn't want to because they're in no diff format, and I've time problems and would have to read much about making a working patch and pull request. Updateing the SKR49 alone took about 60h in total…
09:27:42 <chf> Everything else you change IS stored correctly, hampton?
09:28:04 <fell> Hamton, which version?
09:28:40 <fell> and which backend?
09:29:00 <hampton> Everything else is correct. Version 3.1-3 on fedora 28, sqlite backend.
09:34:42 *** Mechtilde has joined #gnucash
09:35:36 <fell> hampton, did they really disappear from the datebase (query it by it's usual tools) or are they only not shown in GC like the payments (https://bugzilla.gnome.org/show_bug.cgi?id=795753)
09:38:04 *** Mechtilde has quit IRC
09:38:16 <hampton> Is that the right bug? Its about mysql bulk inserts?
09:38:44 <fell> oops, 795702, wrong line
09:39:11 <hampton> I'm trying to figure out where to look in the sqlite database. If I look at the transactions table, I see the field for the description but not a field for the notes.
09:40:30 <fell> the schema is in https://wiki.gnucash.org/wiki/SQL
09:42:39 <fell> porting xml slots to sql was a terrible thing.
09:49:05 <hampton> Weird. I don't see a notes field at all for the transactions. Anywhere. The business objects have notes, but not the transactions.
09:49:36 <fell> I believe, they are in slots.
09:50:09 <fell> Like everything added after 2.0
09:51:18 <hampton> lol.
09:52:53 <fell> As long as we only supported xml, it was much easier than writing a new xml schema with update rules ...
09:55:55 <hampton> The notes are present in the slots table. I added a couple of new entries to my test database, and I can find them all in slots.
09:56:38 <hampton> Whew. At least I didn't lose a decade of notes.
09:56:56 <hampton> :-D
09:57:12 <fell> So they are stored, but not displaed. Do you hold no backups? ;-)
09:59:41 <hampton> Right. Want me to file the bug?
09:59:51 <fell> yep
10:00:30 <fell> (I never touched the sql stuff)
10:03:57 <fell> ... while a patch would be much better. ;-)
10:04:17 <hampton> BTW, I checked a couple of the tables and I noticed the sql wiki is missing a few fields. Pretty sure I don't have an account.
10:05:19 <hampton> lol. Might take me a while to relearn my way around the source code. There's lots of bitrot there, and I've been filling it in with the MythTV sources.
10:05:45 <hampton> Thanks for the help.
10:06:34 <fell> Hampton is still a wiki admin.m :-)
10:08:21 *** jotrago has joined #gnucash
10:08:44 *** KaiForce has joined #gnucash
10:13:18 <hampton> lol. And I still remember my password.
10:15:09 *** Mechtilde has joined #gnucash
10:23:17 <fell> About https:///lists.gnucash.org/logs/2018/06/04.html#T06:06:48: From http://translationproject.org/html/maintainers.html:... this tarball should contain an up to date POT file.
10:23:37 *** ArtGravity has joined #gnucash
10:24:42 <fell> So for that purpose POTFILES.in is not required.
10:34:02 *** fekepp has quit IRC
10:35:54 *** kael has joined #gnucash
10:36:06 <fell> BTW, jralls didn't you announce the 3.x releases there? They still offer gnucash-2.7.8.pot although they have a gnucash-3.1.tar.bz2.
10:37:10 *** fekepp has joined #gnucash
10:40:18 *** fekepp has quit IRC
10:42:19 *** fekepp has joined #gnucash
10:45:41 <fell> Because I never built GC from a tarball I don't know, if POTFILES.in can be generated from it or if it should be possible.
10:47:27 *** jralls has quit IRC
10:49:13 *** Mechtilde has quit IRC
10:54:12 *** warlord has joined #gnucash
10:54:16 *** kael has quit IRC
10:55:56 *** kael has joined #gnucash
11:08:01 *** boldstripe has quit IRC
11:12:14 *** fabior has quit IRC
11:12:57 * hampton laughs
11:13:12 <hampton> I just built from git and it correctly loads the notes fields.
11:26:36 *** fabior has joined #gnucash
11:37:17 <warlord> Hey hampton!!!
11:37:46 <warlord> Long time, no see! How goes it?
11:37:57 <warlord> (BTW, some of your GNC email is bouncing due to a DNS error)
11:38:21 * hampton waves at warlord
11:39:45 <hampton> Work is good, life is good, enjoying the new house (across town from where I used to be).
11:39:55 <warlord> NIce.
11:40:11 <hampton> I found a really old email on the wiki. I'll check my email on the mailing lists.
11:40:33 <hampton> Hows life in the south? Still enjoying it?
11:41:42 <warlord> I am. Although right this minute I'm in the south of france -- but sitting at the airport to fly back west.
11:41:55 <warlord> I can pm you the bouncing email if you like?
11:42:46 *** ncv has quit IRC
11:43:11 <hampton> Would help. I have a monthly subscription update from Friday that shows the correct address on four lists.
11:46:04 *** ncv has joined #gnucash
11:48:00 <warlord> <hampton-gnucash@rainbolthampton.net>: Host or domain name not found. Name
11:48:00 <warlord> service error for name=rainbolthampton.net type=AAAA: Host not found
11:48:28 <warlord> oops, that didn't quite work.
11:48:39 <hampton> np
11:50:33 *** ncv has quit IRC
11:53:19 *** User__ has joined #gnucash
11:54:50 <warlord> anyways, unclear why code is asking for AAAA, since it doesn't (or shouldn't) have an IPv6 address currently.
11:55:10 <warlord> doens'y
11:58:00 *** User__ has quit IRC
12:00:06 *** Mechtilde has joined #gnucash
12:01:02 <hampton> Did you see my pm?
12:01:29 <warlord> Nope. Just looked.
12:01:57 *** fabior has quit IRC
12:02:51 <warlord> Hmm.. Interesting. I do not see it in any list...
12:03:02 *** ncv has joined #gnucash
12:03:13 *** Mechtilde has quit IRC
12:03:31 <warlord> AHH.. It's a bounce from the Wiki -- you changed the email address.
12:04:09 *** jralls has joined #gnucash
12:04:10 *** ChanServ sets mode: +o jralls
12:08:53 *** jralls has quit IRC
12:11:26 *** ncv has quit IRC
12:15:22 * hampton wonders how many other places have emails with that dead domain name.
12:16:49 <warlord> Did you check GnomeBZ?
12:17:33 <warlord> No, looks like you updated that
12:18:05 <warlord> Anyways, I need to shut down.. Boarding starts in ~5-10 minutes.
12:18:18 <hampton> Have a safe flight.
12:18:23 <warlord> Thanks.
12:18:31 <warlord> TTYL! Don't be a stranger! :)
12:20:12 *** warlord has quit IRC
12:27:06 *** Mechtilde has joined #gnucash
12:34:51 *** calvinct has joined #gnucash
13:00:05 *** Mechtilde has quit IRC
13:19:48 *** jralls has joined #gnucash
13:19:48 *** ChanServ sets mode: +o jralls
13:23:30 *** jralls has quit IRC
13:29:10 *** fabior has joined #gnucash
13:44:37 *** fabior has quit IRC
13:52:23 *** harshitaneja has quit IRC
14:00:14 *** calvinct has quit IRC
14:26:27 *** calvinct has joined #gnucash
14:30:01 *** calvinct has quit IRC
14:30:32 *** calvinct has joined #gnucash
14:32:30 *** jralls has joined #gnucash
14:32:31 *** ChanServ sets mode: +o jralls
14:36:06 *** jralls has quit IRC
14:47:57 *** calvinct has quit IRC
14:52:37 *** frakturfreak has joined #gnucash
15:07:36 *** User__ has joined #gnucash
15:10:42 *** User__ has quit IRC
15:15:25 *** oozer has quit IRC
15:17:13 *** fabior has joined #gnucash
15:17:41 *** fell_laptop has quit IRC
15:26:11 *** fell_laptop has joined #gnucash
15:54:44 *** jralls has joined #gnucash
15:54:45 *** ChanServ sets mode: +o jralls
15:57:46 *** jralls has quit IRC
16:29:08 *** boldstripe has joined #gnucash
16:35:30 *** fabior has quit IRC
16:39:36 *** fekepp has quit IRC
16:42:36 *** fekepp has joined #gnucash
16:43:20 *** gour has quit IRC
17:00:01 *** KaiForce has quit IRC
17:07:40 *** jralls has joined #gnucash
17:07:40 *** ChanServ sets mode: +o jralls
17:10:50 *** jralls has quit IRC
17:28:40 *** oozer has joined #gnucash
17:44:01 *** redarrow has joined #gnucash
18:12:08 *** kael has quit IRC
18:12:31 <gjanssens> hampton: As you discovered jralls fixed the notes issue in git maint. It will be in gnucash 3.2
18:12:45 <gjanssens> The fix is only a few days old :)
18:12:54 *** gjanssens has quit IRC
18:14:37 *** bertbob has quit IRC
18:15:17 *** jralls has joined #gnucash
18:15:17 *** ChanServ sets mode: +o jralls
18:18:18 *** bertbob has joined #gnucash
18:18:21 *** jralls has quit IRC
18:21:37 *** bertbob has quit IRC
18:32:04 *** fekepp has quit IRC
18:38:01 *** bertbob has joined #gnucash
18:51:48 *** pilotauto has joined #gnucash
18:56:37 *** bertbob has quit IRC
18:58:19 *** bertbob has joined #gnucash
19:26:50 *** jralls has joined #gnucash
19:26:50 *** ChanServ sets mode: +o jralls
19:30:01 *** jralls has quit IRC
19:31:12 *** chris has quit IRC
19:47:02 *** boldstripe has quit IRC
20:36:51 *** jralls has joined #gnucash
20:36:51 *** ChanServ sets mode: +o jralls
20:39:51 *** jralls has quit IRC
21:32:52 *** ArtGravity has quit IRC
21:36:26 *** oozer has quit IRC
21:45:33 *** jralls has joined #gnucash
21:45:33 *** ChanServ sets mode: +o jralls
21:48:36 *** jralls has quit IRC
22:47:08 *** fell_laptop has quit IRC
22:52:07 *** jralls has joined #gnucash
22:52:07 *** ChanServ sets mode: +o jralls
22:55:47 *** jralls has quit IRC
23:29:08 *** chris has joined #gnucash
23:35:28 *** jralls has joined #gnucash
23:35:29 *** ChanServ sets mode: +o jralls
23:38:38 *** jralls has quit IRC
23:50:33 *** chris has quit IRC