2018-08-08 GnuCash IRC logs
00:07:59 *** Mechtilde has joined #gnucash
00:11:14 *** Mechtilde has quit IRC
00:45:57 *** Mechtilde has joined #gnucash
00:49:09 *** gour has joined #gnucash
01:33:26 *** fell_laptop has joined #gnucash
01:35:15 *** fell has quit IRC
01:52:44 *** bertbob has quit IRC
02:11:09 *** bertbob has joined #gnucash
02:12:54 *** Mechtilde has quit IRC
02:14:18 *** fell_laptop has quit IRC
02:21:33 *** jotrago has quit IRC
02:24:42 *** immae has quit IRC
02:28:15 *** fell_laptop has joined #gnucash
02:31:06 *** immae has joined #gnucash
02:43:01 *** harshitaneja has joined #gnucash
03:24:49 *** boldstripe has joined #gnucash
03:29:25 *** gjanssens has joined #gnucash
03:29:25 *** ChanServ sets mode: +o gjanssens
03:29:31 <gjanssens> .
03:37:31 *** boldstripe has quit IRC
03:42:01 *** boldstripe has joined #gnucash
03:49:22 *** Mechtilde has joined #gnucash
04:07:54 *** boldstripe has quit IRC
04:14:29 *** boldstripe has joined #gnucash
04:26:46 *** boldstripe has quit IRC
04:51:52 *** fekepp has joined #gnucash
05:08:48 *** gour_ has joined #gnucash
05:11:08 *** gour has quit IRC
05:26:33 *** jotrago has joined #gnucash
05:29:01 *** fell_laptop has quit IRC
05:52:55 *** jotrago has quit IRC
05:53:03 *** pilotauto has quit IRC
05:56:31 *** jotrago has joined #gnucash
06:19:21 *** sixwheeledbeast has joined #gnucash
06:39:41 *** windboy has joined #gnucash
06:40:47 *** chris has quit IRC
06:41:01 *** chris has joined #gnucash
06:55:06 *** Jimraehl1 has joined #gnucash
06:55:47 *** Jimraehl1 has left #gnucash
07:35:32 *** chf1 has quit IRC
07:41:23 *** chf has joined #gnucash
07:59:16 *** oozer has joined #gnucash
08:24:26 *** jotrago1 has joined #gnucash
08:24:52 *** jotrago has quit IRC
08:24:52 *** jotrago1 is now known as jotrago
08:27:53 *** chf has quit IRC
08:32:26 *** chf has joined #gnucash
09:15:49 *** jotrago has quit IRC
09:39:39 *** rudi has joined #gnucash
09:41:18 *** windboy has quit IRC
09:41:53 *** windboy has joined #gnucash
09:45:48 *** Trel has quit IRC
09:54:34 <chris> I'd hope there will never be a future bug report whereby an initial launch, nor one whereby changing only a couple options creates a report crash :-)
09:56:51 *** rudi has quit IRC
10:04:49 *** chris has quit IRC
10:05:25 *** chris has joined #gnucash
10:06:10 *** kael has joined #gnucash
10:15:39 *** jotrago has joined #gnucash
10:22:40 *** jotrago has quit IRC
10:22:46 *** jotrago has joined #gnucash
10:30:37 *** kael has quit IRC
10:31:08 *** kael has joined #gnucash
10:32:53 *** fekepp has quit IRC
10:33:40 *** rudi has joined #gnucash
10:34:48 *** rudi has quit IRC
10:35:24 *** jotrago has quit IRC
10:35:28 *** jotrago has joined #gnucash
10:45:42 *** bahner has joined #gnucash
10:46:39 <gjanssens> chris: do you have any remarks on https://github.com/Gnucash/gnucash/pull/391 before I pull it ?
10:47:15 <chris> I do actually... but don't wish to discourage a newbie
10:47:31 <chris> (dunno if carsten is a newbie, been around for years)
10:48:02 <chris> 1. if testing raw html then perhaps best split multiline.... i'd want to modify html occasionally and wouldn't wish to modify test string every time
10:49:01 <chris> 2. i have a vision of html-document being obsolete in the future, replaced by the very functional sxml construct... but perhaps not useful if reports will one day transition into a mustache-or-other template
10:49:02 *** chf has quit IRC
10:50:21 <chris> 3. yes the html is buggy... eg no doctype... it's neither html5 nor xhtml... but pretends to be xhtml... so it doesn't really matter that the various bugs are mentioned. so, i don't quite understand benefit of testing raw html output.
10:51:23 <chris> in other words, most of the tests are testing the implementation of html-document; while they're accurate, they're imo mostly getters and setters
10:51:32 <chris> on the flip side,
10:52:25 <chris> if there's a drive to improve the existing html-document code, the test suite is actually useful... they will allow refactoring of code while maintaining compatibility
10:52:35 *** chf has joined #gnucash
10:53:15 <chris> not sure if i'm being too picky here
10:53:56 <chris> perhaps the benefit of this type of testing is that it'll maintain report output while someone (e.g. I) will improve/consolidate existing code
10:54:27 <chris> whatare your thoughts?
10:55:46 *** Mechtilde has quit IRC
10:58:47 *** jotrago1 has joined #gnucash
10:59:20 *** jotrago has quit IRC
10:59:21 *** jotrago1 is now known as jotrago
11:11:32 *** ArtGravity has joined #gnucash
11:16:37 *** chf has quit IRC
11:20:13 *** chf has joined #gnucash
11:22:47 *** bahner has quit IRC
11:31:23 *** bahner has joined #gnucash
11:37:56 *** kael has quit IRC
11:40:16 *** O01eg has quit IRC
11:40:23 *** kael has joined #gnucash
11:51:49 *** bahner has quit IRC
11:52:51 <gjanssens> chris: encouraging a newcomer while still aiming for quality code is a subtle balance to strike...
11:53:51 <chris> and I've lived to tell the tale \o/
11:54:23 <gjanssens> Carsten is not really a newcomer indeed, but still he spent effort to come up with the PR (after his patch on the bug got shot down) so it would be good if we can guide him instead of breaking it down again
11:54:45 *** Mechtilde has joined #gnucash
11:55:05 <chris> overall i think the test is harmless, so, I think it's ok overall... perhaps I'd convert \n to genuine newlines which are easier to read and amend (if I change html)
11:55:15 <gjanssens> As for the fate of html-document, that is currently undecided. I like the mustache concept, but we're far from ready to implement it.
11:55:41 <chris> ok i'll feedback then sleep
11:56:05 <gjanssens> So for now it's good to add tests to it.
11:56:21 <gjanssens> And I agree it would be better to have real newlines
11:56:59 <gjanssens> As for the bugginess of the html output: there are a few deliberate hacks in there to work around quirks in the webkit rendering engine
11:57:07 *** O01eg has joined #gnucash
11:57:35 <chris> yup i gathered
11:57:49 <gjanssens> The absence of a doctype is one of those. Setting one can stop webkit from rendering the page at all because of a mismatch between the doctype and the file name extension
12:09:00 *** boldstripe has joined #gnucash
12:10:31 *** calvinct has joined #gnucash
12:13:18 *** tlaxkit has joined #gnucash
12:21:10 *** fell_laptop has joined #gnucash
12:30:14 *** boldstripe has quit IRC
12:40:10 *** Mechtilde has quit IRC
12:44:17 *** calvinct has quit IRC
12:51:58 *** calvinct has joined #gnucash
12:53:46 *** Mechtilde has joined #gnucash
12:56:29 *** boldstripe has joined #gnucash
13:23:59 *** boldstripe has quit IRC
13:24:27 *** boldstripe has joined #gnucash
13:26:15 *** boldstripe has quit IRC
13:27:01 *** boldstripe has joined #gnucash
13:43:24 *** O01eg has quit IRC
13:44:03 *** O01eg has joined #gnucash
13:44:03 *** tlaxkit has quit IRC
13:47:51 *** nomeata has joined #gnucash
14:02:58 *** calvinct has quit IRC
14:26:13 *** kael has quit IRC
14:26:29 *** frakturfreak has joined #gnucash
14:58:36 *** harshitaneja has quit IRC
15:08:07 <gjanssens> Hmm, I have just read gtester will be formally deprecated in glib 2.58. Are we still using it ?
15:08:20 <gjanssens> https://blog.gtk.org/2018/07/11/news-from-glib-2-58/
15:11:19 *** Mechtilde has quit IRC
15:22:56 *** sarah has joined #gnucash
15:27:58 <sarah> I recently upgraded to 3.2 (from 2.6 I believe) and I am having difficulty with my CSV export. I used to be able to filter the split transactions and get a unique line for each part of each transaction. Now I am missing information on some of the lines and can't use this data for pivot tables.
15:27:58 <gncbot> sarah: Sent 1 year, 34 weeks, 5 days, 15 hours, and 38 minutes ago: <warlord> no, gncbot is a bot. Still,we have email lists (forums are really annoying). Also, if you want a question answered you should stick around for more than 20 minutes. As the topic says wait (Possibly a few hours)
15:27:59 <gncbot> sarah: Sent 1 year, 34 weeks, 5 days, 15 hours, and 36 minutes ago: <warlord> The lists are available at https://lists.gnucash.org/mailman/listinfo/gnucash-user -- and there are archives available as well that you can search by google. I'll note that forums/email usually take even longer to get an answer than here on IRC. But of course you logged out 4 minutes before I looked at this window and saw you.
15:30:03 <warlord> Hmm. I wonder if you're the same sarah as almost 2 years ago?
15:30:15 <sarah> For example, if I search my csv for Costco membership fees paid over the years, 2 of the 5 lines I'm expecting are missing date, description, and notes.
15:30:34 <sarah> Last time I used this chat was for canadian index fund price importing.
15:31:05 <sarah> Can't remember when that was
15:34:25 <warlord> did you get an answer then?
15:34:33 <warlord> Anyways, gjanssens is the master of CSV ...
15:36:10 <sarah> We did get it sorted, yes. I'm having difficulty getting some of my new funds to update every time using Alphavantage, but they do work sometimes so I don't think I've done anything wrong in their set up. USD currency fails almost every time too. Is there something I can do about it?
15:37:10 *** Mechtilde has joined #gnucash
15:37:40 <warlord> I think it's an Alphavantage issue.
15:38:27 <sarah> okay. That's what I suspected. If I can't get my csv issue solved, do you know if I will be able to use my v3.2 file in 2.6 if I downgrade?
15:38:46 <warlord> Should be able to use it in 2.6.21
15:39:08 <sarah> Does Alphavantage only work in 3.0+?
15:39:34 <warlord> No, it should work in 2.6 as well. It's an F::Q thing. But the way to set your API key is, IIRC, different.
15:40:14 *** Mechtilde has quit IRC
15:40:54 <sarah> If I leave this chat open for awhile will gjanssens eventually see my csv question?
15:41:00 <gjanssens> sarah: The export format in 3.x has changed
15:41:15 <warlord> sarah: yes :)
15:41:21 <sarah> :)
15:41:40 <sarah> How can I get a unique line with all the columns for each split line?
15:41:40 <gjanssens> The transaction related information is only printed once on the first split
15:42:22 <gjanssens> I'm afraid it's currently not possible to export in such a format from within gnucash
15:42:53 <sarah> Is there a way to manipulate the csv data so that I can use it in a pivot table to analyze my income and expense transactions?
15:42:54 <gjanssens> I think you have a valid use case though, so please file an enhancement request in our bugzilla instance
15:45:51 <sarah> Is my best bet to go back to 2.6?
15:51:22 <gjanssens> It depends. I was looking around on the web and aparently there exist ways to correct this in libreoffice (or excel)
15:51:32 <gjanssens> libreoffice: https://forum.openoffice.org/en/forum/viewtopic.php?t=56950
15:51:47 <gjanssens> excel: https://www.extendoffice.com/documents/excel/771-excel-fill-blank-cells-with-value-above.html
15:53:13 <gjanssens> However if those turn out to be too cumbersome, you may revert back to 2.6 as well (unless 3.x has other new features you desperately need)
15:53:43 <gjanssens> I don't know when I'll find time to improve the csv export yet. There are still plenty of more urgent matters to look into.
15:59:04 <sarah> I will take a look at the links, thank you. I'm continuing to have issues with price updating in 3.2 (and the save and data entry bugs I think are being worked on for next update?) so maybe in the end I will downgrade anyway.
16:07:26 <sarah> If I do end up downgrading, do I need to uninstall 3.2 first? Is there anything I should be wary of in doing this?
16:17:34 <gjanssens> I would uninstall 3.2 first indeed (I presume you are on Windows ?)
16:18:05 <gjanssens> I don't know of particular issues to be wary of.
16:18:31 <gjanssens> But you might ask for other user experiences on the list regarding downgrades
16:23:01 <sarah> I think I got the hang of mass filling in the blanks in the csv file. I didn't know about ctrl-enter. Very handy!
16:24:42 <sarah> That's an easy workaround. (Highlight columns, Go To Special, Select Blanks, =A2, CTRL-Enter.)
16:25:56 <sarah> Thanks again for those resources.
16:31:03 <gjanssens> You're welcome
16:32:46 *** gjanssens has quit IRC
16:47:12 *** frakturfreak has quit IRC
17:10:46 *** gncbot sets mode: +o fell_laptop
17:31:38 *** calvinct has joined #gnucash
17:38:59 *** calvinct has quit IRC
17:39:13 *** chf has quit IRC
17:40:44 *** chf has joined #gnucash
17:42:16 *** chf has quit IRC
17:43:07 *** chf has joined #gnucash
17:59:57 *** sixwheeledbeast has quit IRC
18:00:21 *** sixwheeledbeast has joined #gnucash
18:23:03 *** nomeata has quit IRC
18:44:06 *** pilotauto has joined #gnucash
18:51:06 *** fekepp has joined #gnucash
18:52:09 *** fekepp has quit IRC
20:07:51 *** mipesom has quit IRC
20:11:22 *** mipesom has joined #gnucash
20:16:48 *** gour_ has quit IRC
20:30:31 *** sarah has quit IRC
21:28:54 *** oozer has quit IRC
21:35:04 *** tonysoar has joined #gnucash
21:39:14 *** harshitaneja has joined #gnucash
21:53:24 *** tonysoar has quit IRC
22:41:50 *** ArtGravity has quit IRC
23:42:00 *** storyjesse has joined #gnucash
23:46:04 *** fell_laptop is now known as fell