2018-05-25 GnuCash IRC logs

00:08:20 <linas> I've seen at least one article that there is a lot of pointless panic over GDPR, a lot of confusion and misinformation and rumours spreading around. I'd suggest waiting for the dust to settle, waiting for some clear guidelines and best-practices to emerge
00:18:59 *** storyjesse has quit IRC
00:19:57 *** eagles0513875 has joined #gnucash
00:23:29 *** boldstripe has quit IRC
00:26:08 *** Mechtilde has joined #gnucash
00:46:21 *** Mechtilde has quit IRC
01:03:03 *** Mechtilde has joined #gnucash
01:18:40 *** fell has quit IRC
01:19:50 *** fell has joined #gnucash
01:32:54 *** Mechtilde has quit IRC
01:53:36 *** frakturfreak has quit IRC
02:04:21 *** gjanssens has joined #gnucash
02:04:21 *** ChanServ sets mode: +o gjanssens
02:07:31 <gjanssens> .
02:07:31 <gncbot> gjanssens: Sent 7 hours and 15 minutes ago: <chris1> ... I think is just an invoice report issue. my worry is how the Invoice Posting logic handle these total taxes
02:07:32 <gncbot> gjanssens: Sent 7 hours and 14 minutes ago: <chris1> Xero seems to round individual tax entries. https://developer.xero.com/documentation/api-guides/rounding-in-xero
02:08:28 *** frakturfreak has joined #gnucash
02:20:28 *** jotrago has joined #gnucash
02:27:00 <gjanssens> chris1: I opened a new enhancement request yesterday for supporting different rounding schemes https://bugzilla.gnome.org/show_bug.cgi?id=796391
02:38:30 *** gour has joined #gnucash
02:55:55 <chris1> Ok I'll conclude for now that this issue is very complicated :)
03:04:19 *** fabior has joined #gnucash
03:11:39 <gjanssens> chris1: it is :(
03:14:16 <gjanssens> jralls, warlord: regarding the bugzilla migration, can we change the url to bugs.gnucash.org instead of bugzilla ? I prefer a url refering to the function rather than the software behind it.
03:15:43 <gjanssens> And ideally remove the "bugzilla" in the middle. I know I asked this before. It's best done before final migration, before people start referring to our bugs.
03:23:01 *** fekepp has joined #gnucash
03:40:42 *** mikee has joined #gnucash
03:42:58 <chris1> I think the most useful major upgrade will be to allow modification of tax amounts..... and IMHO the discount mechanism was a mistake
03:45:18 <chris1> discount should have been per-invoice rather than per-entry
03:45:35 <chris1> doing tests on them is challenging
03:52:17 *** ncv has joined #gnucash
04:06:02 *** fabior has quit IRC
04:11:47 <gour> morning
04:12:03 <chris1> gour - I think average could be made a default
04:12:15 <gour> cool
04:12:27 <chris1> always a worry about creature feep
04:12:51 <chris1> the next guy will want standard-deviation too
04:13:36 <gour> i'm interested whether GC can somehow use # of occurence in SX and put it into description field?
04:13:57 <chris1> not unless you become a hacker
04:14:38 <gour> what if one uses Loan Repayment Assistant?
04:14:50 <chris1> any change has to be mostly backward-compatible, forward compatible, applicable across the world
04:17:04 <gour> i'm not sure whether it can create payment plan for the loan using x months where the payment amount is not the same during the loan payment period but it decreases?
04:18:56 <chris1> no
04:20:05 <gour> another thing i am wondering is whether I could use GC for invoicing in my small company - so far i used some PHP app which is abandoned now...i know GC can do invoicing, but sometimes i need to create quote as well - therefore there should be two independent counters - one for each (invoices & quotes)?
04:20:16 <gour> maybe another feature to become hacker...
05:07:27 *** storyjesse has joined #gnucash
05:08:09 *** pilotauto has quit IRC
05:16:11 *** Robert has joined #gnucash
05:20:19 <Robert> I have GnuCash 2.6.1 on Ubuntu 14.04 using a MySql database. I would like to upgrade to GunCash 3.1. Has the database changed? Can I just build 3.1. from source and connect to the database?
05:29:45 <chris1> Robert: the database will have changed slightly; it's advisable to upgrade to 2.6.21 first then to 3.1.... and lots of backups
05:39:23 <Robert> Thanks Chris, how is the database upgraded?
05:55:49 <chris1> Robert: automatically upon first load and save
06:05:09 <Robert> Great, thank you. I will remember all the backups.
06:06:22 <chris1> and if you're db admin, analyse the changes that each upgrade does line-by-line
06:07:11 <Robert> Will do, I am an Oracle DB admin. Can find my way around MySql.
06:18:39 *** storyjesse has quit IRC
07:02:54 *** fekepp has quit IRC
07:34:44 *** User has joined #gnucash
07:40:53 *** User has quit IRC
07:49:55 *** harshitaneja has quit IRC
08:06:16 *** harshitaneja has joined #gnucash
08:06:55 <warlord> gjanssens: I have requested linas add bugs.gnucash.org to DNS
08:07:05 <gjanssens> warlord: thanks
08:07:06 <warlord> I'll look into removing the /bugzilla
08:07:33 <warlord> Last time I tried it I had a security failure.
08:09:39 <gjanssens> warlord: will our test instance already send e-mails (like when changing some aspect of an existing bug) ?
08:10:44 <gjanssens> I want to experiment with making changes (which I know will be undone in the final migration) but I wouldn't want the cc'd people getting messages about that
08:15:07 <gjanssens> warlord: while trying to access https://bugzilla.gnucash.org/bugzilla/attachment.cgi?id=1099 I get a "Forbidden" error
08:15:27 <gjanssens> "You don't have permission to access /bugzilla/attachment.cgi on this server."
08:15:47 <gjanssens> I'm logged in with my account (after a password reset) and seem to have admin rights
08:16:39 <gjanssens> Oh, looks like you're playing with the server, I get the error for each link now, while it worked half an hour ago...
08:16:46 <gjanssens> I'll wait till you're done :)
08:26:13 <chris1> is anyone working on the crasher in the register? try to input any date with year >9999
08:26:39 <gjanssens> chris1: I don't think so
08:27:05 <gjanssens> Current priority is salvaging our bug db before gnome shuts down their bugzilla.
08:27:16 <chris1> ah ok
08:27:28 <gjanssens> Is there a bug report for this already ?
08:28:08 <chris1> no - didn't think to fill bugzilla currently very fluid
08:28:10 <gjanssens> I will be working on the register in my first available decent free time slot
08:28:52 <gjanssens> But I have been pretty occupied outside of the project recently
08:31:40 *** boldstripe has joined #gnucash
08:34:50 *** harshitaneja has quit IRC
08:35:22 <chris1> https://bugzilla.gnome.org/show_bug.cgi?id=796398
08:38:23 <chris1> I should be studying for a course too
08:41:10 <gjanssens> Thanks chris1
08:41:16 *** harshitaneja has joined #gnucash
08:46:45 *** LAGuns has joined #gnucash
08:51:36 <warlord> gjanssens: AHA! I think I got it..
08:51:50 <warlord> Although I don't know if this will actually break anything.
08:52:02 *** kael has joined #gnucash
08:54:20 <gjanssens> warlord: cool. Can I test already ?
08:55:24 <gjanssens> FYI https://bugs.gnucash.org shows me our normal website
08:55:32 <gjanssens> (public one)
08:57:04 <warlord> gjanssens: bugs isn't pointing to the right place, yet. However I got rid of the /bugzilla part
08:58:27 <warlord> I didn't realize the name already existed in our DNS. I had asked LInas to add it; I just asked him to redirect it.
08:58:37 <gjanssens> warlord: ok. https://bugzilla.gnucash.org results in a "Failed to connect" - the generic firefox error
08:59:15 <warlord> gjanssens: Oh? It's working for me..
08:59:51 <gjanssens> Ping works, replies from code.gnucash.org
09:00:40 <warlord> What's your IP address?
09:01:22 <gjanssens> 81.82.192.49
09:03:33 <warlord> gjanssens: you got banned by fail2ban
09:03:44 <warlord> (this is what happened to me, too, when I was playing with it remotely)
09:04:17 <warlord> I've unbanned you. Go retry now.
09:04:41 <gjanssens> Ah, works now
09:04:43 <gjanssens> Thanks
09:05:18 <warlord> Yeah.. If you tried to use it while it was broken you would have blocked yourself.
09:05:38 <gjanssens> Ok, that's probably what happened
09:05:56 <warlord> I've got the apache-auth jail turned on. It works pretty well ;)
09:06:05 <gjanssens> So back to my first question today: will the system already send bugmails ?
09:07:12 <warlord> Yes
09:07:32 <gjanssens> Ok, so I shouldn'd experiment making changes to bugs with large cc lists :)
09:07:33 <warlord> At least I am prettty sure it will.
09:07:47 <warlord> Probably not.. ;)
09:08:01 <warlord> Other thing you can't do (yet) is create new bugs.
09:09:48 <warlord> AFAIK my only open issue is dealing with the attachment status -- I need to figure out what field to call it in the history, and I need to set the appropraite flag.
09:11:57 <gjanssens> Just tried to re-assign a bug from Gnucash to Packaging. When selecting the Packaging product it will not update the available list of components
09:12:13 <gjanssens> Maybe a bugzilla bug rather than a configuration issue though.
09:12:38 <warlord> Do you have javascript enabled?
09:13:28 <warlord> Oh, you're right -- it doesn't for me, either. Maybe a BZ bug.
09:14:13 <gjanssens> No it appears it will be asked in a followup screen.
09:14:20 <gjanssens> False alarm
09:14:22 <warlord> Ah. Okay.
09:15:38 <gjanssens> Out of curiosity did you receive a bug mail for this ? I cleared the cc list before confirming.
09:16:11 <warlord> Yes.
09:16:20 <warlord> 712301
09:16:53 *** kael has quit IRC
09:16:56 *** kael has joined #gnucash
09:17:04 <gjanssens> Yep. So clearing the cc list happens after the bug mail is sent.
09:17:19 <warlord> Yes. I got a "removed" notification. But we knew that.
09:17:37 <gjanssens> You'll probably get another one sent to gnucash-win-maint@gnome.bugs
09:17:38 <warlord> The mail is set after additions are made, and before removals are made.
09:17:49 <warlord> I wont -- I don't watch that.
09:17:54 <gjanssens> Ah I didn't know that.
09:18:09 <gjanssens> (both)
09:18:16 <warlord> And also, none of the watcher data migrated.
09:18:21 *** stepfen has joined #gnucash
09:18:27 <warlord> Everyone will need to manually reset their watchers.
09:18:33 <gjanssens> Right
09:19:01 <gjanssens> That's all been communicated, I remember now...
09:20:36 <stepfen> hi there. anybody willing to help me with Finance-Quote ??? I get gnc-fq-dump currency USD GBP -> 1 USD = <unknown> GBP thanks in advance
09:21:15 <gjanssens> stepfen: have you set up your alphavantage key in your environment ?
09:21:50 <stepfen> nope. never heard of this
09:22:20 <stepfen> I'll have a look . thanks
09:22:20 <gjanssens> https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F
09:23:00 <stepfen> thanks
09:24:49 *** harshitaneja has quit IRC
09:31:21 *** harshitaneja has joined #gnucash
09:31:55 <gjanssens> warlord: the corrected url seems to work fine, thanks
09:32:05 <warlord> gjanssens: great!
09:33:20 <LAGuns> Is there an updated design document located somewhere? The documents that I've found so far seem to be outdated or actually marked with "Do Not Read"
09:33:55 <warlord> LAGuns: not as far as I know
09:36:01 *** Robert has left #gnucash
09:36:01 <stepfen> ok done... I think this needs to be made more obvious instead of being "hiden" in the faq's . For example nothing is mentioned in https://wiki.gnucash.org/wiki/Online_Quotes#Troubleshooting Thanks anyway
09:36:22 *** stepfen has quit IRC
09:40:50 *** max has joined #gnucash
09:40:51 *** max has left #gnucash
09:47:04 *** oozer has joined #gnucash
10:02:13 *** luc14n0 has quit IRC
10:02:25 *** luc14n0 has joined #gnucash
10:07:18 <chris1> once an invoice is created, it's so complicated to apply payment correctly :(
10:08:33 <warlord> Okay, updated https://wiki.gnucash.org/wiki/Bugzilla_Administration
10:15:16 <warlord> jralls.. FYI
10:16:24 <warlord> jralls: FYI, BZ URL changed .. the /bugzilla was removed. Make sure you remove it or you'll be locked out by fail2ban
10:24:20 <chris1> gncEntry - has 2 states for discount (%/$), 3 states for discount strategy (pre/post/equi-tax), 2 states for tax-included = 12 combinations :-O
10:27:57 <gjanssens> chris1: And in the future the may be additional variations for rounding :)
10:28:20 <chris1> >:(
10:34:25 <chris1> I'll be using rgmerk jenny to efficiently create combos :)
10:41:07 *** ArtGravity has joined #gnucash
10:49:12 *** kael has quit IRC
11:04:23 *** fell has quit IRC
11:09:52 <chris1> et voila - https://imgur.com/a/XfNcTBU
11:26:10 <gjanssens> chris1: sweet :)
11:29:52 *** bertbob has quit IRC
11:31:52 *** bertbob has joined #gnucash
12:06:03 *** LAGuns has quit IRC
12:15:13 *** Mechtilde has joined #gnucash
12:24:05 *** fabior has joined #gnucash
12:24:56 <jralls> chris1: I fixed but hadn't pushed the date crasher. Pushed the fix just now.
12:29:49 <jralls> warlord: LAGuns probably found the old texinfo docs in the sources (we should just remove them!). You *do* know about the Doxygen ones...
12:32:19 <jralls> warlord: A nit: It would be nice to replace the favicon on bugzilla.gnucash.org with GnuCash's.
12:32:47 <jralls> Have to run some errands, back in ~2 hrs.
12:52:40 <chris1> ok time to sleep. been trying to create a complex invoice with combos, and apply partial payments. don't know how to apply payment.
12:52:42 <chris1> https://github.com/christopherlam/gnucash/blob/9e451f51f0204b39913ee7ebf9a4b3530b30a0f9/gnucash/report/business-reports/test/test-invoice.scm#L471
12:56:42 *** gour_ has joined #gnucash
12:58:59 *** gour has quit IRC
13:05:00 *** gour_ is now known as gour
13:31:21 <warlord> jralls: Ahh, it's probably broken now because I changed DocumentRoot
13:49:38 *** fabior has quit IRC
14:04:56 *** Mechtilde has quit IRC
14:08:17 *** calvinct has joined #gnucash
14:12:05 *** frakturfreak has quit IRC
14:14:47 *** calvinct has quit IRC
14:18:27 <jralls> warlord: I don't think it ever showed ours.
14:27:25 *** frakturfreak has joined #gnucash
14:27:57 <warlord> Ah, it's hardcoded in there as /usr/src/bugzilla/images/favicon.ico
14:35:08 <jralls> That's rude.
14:45:40 <gjanssens> warlord: mails appear to come from bugzilla-daemon@gnucash.bugzilla.org
14:46:03 <gjanssens> I propose to use a more human-friendly name
14:46:24 <gjanssens> Erh make that bugzilla-daemon@bugzilla.gnucash.org
14:46:54 <gjanssens> Can we have bugs@gnucash.org or something along those lines ?
14:47:09 <jralls> gjanssens: https://bugzilla.gnucash.org/editparams.cgi?section=mta, second option. I like bugs@gnucash.org.
14:48:35 <gjanssens> Makes me wonder also, can we directly update bugs by sending emails ?
14:48:39 <gjanssens> jralls: ah, nice
14:48:58 <gjanssens> Of course the mailsystem should be configured to accept that address
14:49:27 <jralls> BTW, the last option on that page is a "global watchers" list. I propose that we create a psuedo-user "all-bugs@gnucash.org" so that those of us who need to see all bugmail need follow only one.
14:53:54 <warlord> jralls: it is. But I can change out the file.
14:54:16 <warlord> gjanssens: We can change that. Admin -> Prefs -> [something]. You even have the rights to change it. :)
14:54:35 <jralls> warlord: Of course. Every time we upgrade. :-\
14:54:45 <warlord> jralls: nope, that's a persistant setting.
14:55:03 <warlord> gjanssens: w.r.t. reply-by-email -- I think there is an extension to do so. I do not believe it is installed.
14:55:06 <jralls> The mail address is. The favicon isn't.
14:55:18 <warlord> Ah, right. Yes.
14:57:04 <jralls> 4.4 had https://www.bugzilla.org/docs/4.4/en/html/api/email_in.html.
14:58:56 <jralls> The file is still in the repo but the documentation seems to have gone missing.
15:03:52 <gjanssens> Don't spend too much time on that part as far as I'm concerned. It's not an important feature, just nice to have.
15:05:25 <jralls> I think all it requires is for the MTA to route mail to email_in.pl.
15:06:04 *** ncv has quit IRC
15:06:24 <jralls> And of course that the sender formats the mail correctly...
15:06:42 <warlord> jralls: we could set up an a mailman list for all-bugs? ;)
15:07:15 <warlord> gjanssens: It's something we can add later. I'm not worried.
15:07:34 <jralls> warlord: We could, but why?
15:08:26 <jralls> [Answering my own question] I suppose if people wanted to see bug mail but didn't want a BZ account.
15:09:03 <warlord> I was more thinking "so we didn't have to set watchers"
15:09:54 *** mikee has quit IRC
15:12:01 <jralls> I dunno. I want to see everything and I suspect (and hope ;-) ) gjanssens does too. Perhaps you do. I'd expect most others to prefer to focus on the components that they work on; e.g. Bob Fewell might be interested only in GUI bugs.
15:12:34 <jralls> The watchers are a convenient way for people to tailor what components they get mail for.
15:13:06 <gjanssens> You're correct I want to see everything too
15:23:36 <warlord> That presumes we have sufficient granularity in the watchers. Speaking of which -- do we want to rename them from @gnome.bugs to @gnucash.bugs?
15:25:16 <jralls> I'd think so.
15:27:09 <jralls> It should be pretty easy to create a new one if someone wants more granularity than we had at Gnome.
15:49:14 <warlord> jralls: true.
15:52:27 *** oozer_ has joined #gnucash
16:01:39 *** oozer has quit IRC
16:11:05 *** gour has quit IRC
16:15:43 *** calvinct has joined #gnucash
16:31:07 *** gjanssens has quit IRC
16:58:19 *** calvinct has quit IRC
17:10:04 *** vertreko has joined #gnucash
17:28:06 *** harshitaneja has quit IRC
17:34:35 *** harshitaneja has joined #gnucash
17:53:19 *** vertreko has quit IRC
17:55:35 *** badger92 has joined #gnucash
18:13:43 *** ArtGravity has quit IRC
18:22:19 *** harshitaneja has quit IRC
18:27:14 *** oozer_ has quit IRC
19:08:42 *** oozer has joined #gnucash
19:09:04 *** fell_laptop has joined #gnucash
19:11:35 *** jotrago has quit IRC
19:11:38 *** jotrago has joined #gnucash
19:19:03 *** fell_laptop is now known as fell
19:19:23 *** gncbot sets mode: +o fell
19:36:18 <fell> Ahem, my thought was to have bugzilla.gnucash.org as the current instance and bugs.gnucash.org as an alias of it, to be used in docs, wiki, MLs. Then any new bug repo can be testet under another name and after successful conversion bugs. gets set to the new repo.
19:37:10 *** bertbob has quit IRC
19:49:27 *** vertreko has joined #gnucash
20:11:50 *** boldstripe has quit IRC
20:16:28 *** bertbob has joined #gnucash
20:17:34 *** pilotauto has joined #gnucash
20:23:10 *** phebus has quit IRC
20:35:16 *** boldstripe has joined #gnucash
20:50:21 *** bertbob has quit IRC
21:06:41 *** vertreko has quit IRC
21:07:09 *** vertreko has joined #gnucash
21:15:54 *** vertreko has quit IRC
21:23:31 *** bertbob has joined #gnucash
21:36:33 *** fell has quit IRC
21:38:42 *** marusich has joined #gnucash
22:03:57 *** oozer has quit IRC
22:26:12 <warlord> @tell fell -- I don't see the point. If the URL is e.g. https://bugs.gnucash.org/show_bug.cgi?id=XXXXXX --- It's unlikely a different bug system would use the same interface.
22:26:12 <gncbot> warlord: The operation succeeded.
23:57:40 *** boldstripe has quit IRC