2017-02-09 GnuCash IRC logs

00:37:24 *** O01eg has quit IRC
01:12:00 *** fell_ has joined #gnucash
01:14:29 *** fell has quit IRC
01:36:48 *** Mechtilde has joined #gnucash
01:59:00 *** cartsoftware has quit IRC
02:09:08 *** Mechtilde has quit IRC
02:37:11 *** cartsoftware has joined #gnucash
03:08:00 *** mrklintscher has quit IRC
03:20:58 *** bertbob has quit IRC
03:25:09 *** mrklintscher has joined #gnucash
03:26:34 *** gjanssens has joined #gnucash
03:26:34 *** ChanServ sets mode: +o gjanssens
03:35:49 *** bertbob has joined #gnucash
03:52:20 *** Unhammer has joined #gnucash
04:24:58 *** fekepp has quit IRC
04:25:00 *** fekepp has joined #gnucash
04:34:08 *** bertbob has quit IRC
04:38:27 *** bertbob has joined #gnucash
04:41:50 *** bertbob has quit IRC
04:43:55 *** fabior has joined #gnucash
04:48:47 *** mrklintscher has quit IRC
04:52:36 *** mrklintscher has joined #gnucash
04:56:20 *** bertbob has joined #gnucash
05:37:50 *** goblin has joined #gnucash
05:39:27 <goblin> hello everyone :-) I have 5 years worth of bank statements to import. I can convert it to QIF (I know regular expressions!), but when importing it, Gnucash seems to be asking me to create an account for every payee manually. I have about 100 different accounts these statements refer to. How can I get Gnucash to just automatically create an account for each IBAN it sees on input?
05:40:11 *** mrklintscher has quit IRC
05:40:14 <goblin> or can I import all those different accounts from a CSV perhaps?
05:41:07 <goblin> the "N" line from QIF seems to be ignored, right? So I can't put the IBAN there
05:42:45 *** mrklintscher has joined #gnucash
05:44:54 <goblin> similarly, with CSV import, what does the "Account" setting for a column do? It didn't seem like it did much beyond using the first value
05:56:36 <goblin> oh, reading step 4 at http://www.gnucash.org/docs/v2.6/C/gnucash-help/import-qif.html - how can I produce a QIF that'll get me the "Match QIF accounts with GnuCash accounts" option, rather than the one that shows up now (Match payees/memos to GnuCash accounts)?
06:18:06 <goblin> ok it's in the S field it seems
06:22:55 <goblin> or L, got it :-)
06:48:53 *** Jimraehl1 has joined #gnucash
06:49:11 *** Jimraehl1 has quit IRC
06:50:58 <goblin> hmm, how do I tell GnuCash that the QIF file it's importing is in UTF8? Setting the BOM resulted in import failure
06:51:15 <goblin> without the BOM, I get '?' for each non-ASCII character
06:56:49 <goblin> oh, sorry, setting the locale properly helped
07:10:14 <goblin> can I have GnuCash display Deposit rows with a different font color than Withdrawal rows?
07:39:43 *** fekepp has quit IRC
07:43:50 <warlord> goblin: LCategory (or SCategory) -- will map to a GnuCash Income/Expense Account. E.g. you can use LExpenses:Groceries
07:45:01 <goblin> yup, figured that out from some examples :-)
07:45:33 <warlord> ok
07:46:19 *** fabior has quit IRC
07:46:31 <goblin> can I move accounts around once they've been created? the script has given me tons of IBAN numbers which I'd like to categorize into parent accounts and whatnot
07:46:48 <warlord> Yes. You can re-parent accounts at will
07:47:01 <warlord> (although it will upset any QIF mappings you made)
07:47:21 <goblin> how do you do that?
07:47:39 <goblin> I tried drag&dropping, I tried under Edit Account, I can't seem to find the option
07:47:42 <warlord> Edit the account you want to move and select a new parent.
07:47:58 <goblin> ah, that way, thanks!
07:48:15 <goblin> I was trying to edit the parent one
07:53:35 *** rickoehn has joined #gnucash
08:07:36 *** fekepp has joined #gnucash
08:24:12 *** fekepp1 has joined #gnucash
08:24:47 *** fekepp has quit IRC
08:24:48 *** fekepp1 is now known as fekepp
08:50:42 <lmat> Is it common that the backtrace from guile is incorrect?
09:00:53 *** fabior has joined #gnucash
09:02:40 <warlord> lmat: it's never "incorrect", but it might not be the actual cause; it's only where the exception occurred, not necessarily WHY
09:04:58 <warlord> lmat: do you have a public IP or are you behind a NAT?
09:05:24 <warlord> @op
09:05:25 *** gncbot sets mode: +o warlord
09:39:56 *** kael has joined #gnucash
10:38:30 *** kael has quit IRC
10:55:53 *** kael has joined #gnucash
10:56:35 *** Mechtilde has joined #gnucash
11:04:16 *** mrklintscher has quit IRC
11:06:17 *** kael has quit IRC
11:06:26 *** O01eg has joined #gnucash
11:10:53 *** tuxd00d has quit IRC
11:32:42 *** Mechtilde has quit IRC
11:34:31 *** gjanssens sets mode: +o fell_
11:37:51 *** Mechtilde has joined #gnucash
11:52:24 *** kael has joined #gnucash
11:54:27 *** kael has quit IRC
12:00:08 *** linas has joined #gnucash
12:00:16 <warlord> Hi Linas
12:00:23 <linas> hi warlord!
12:00:39 *** cartsoftware has quit IRC
12:00:48 <linas> neever saw your response to my rambling email
12:00:50 <warlord> My fiber got installed yesterday. I was going to email you later
12:01:00 <warlord> About systemd? ;)
12:01:05 <linas> ooh! OK
12:01:27 <linas> I am slowly making freinds with systemd
12:01:53 <warlord> I was going to ask if you could email me the scripts/configs you used for your port-knocker. I was thinking that I'd set up a secondary 'www.gnucash.org' over here, so we could "share the load"
12:02:37 <linas> no exactly a "load" -- reliability would be the issue.
12:02:53 <warlord> there is that, too :)
12:02:59 *** tuxd00d has joined #gnucash
12:03:29 <warlord> I was also going to reach out about setting up https and how we would handle that if we have multiple servers serving "www.gnucash.org" traffic
12:03:40 <linas> but yes, I'll send you them, and my notes. I keep a diary of all the stuff I run
12:03:55 <warlord> Sounds good. (I do, too)
12:04:18 <linas> Today, I get 12 more cores for my main compute server, so I'm excited
12:04:42 <warlord> YAY!
12:05:44 <gjanssens> linas: wow :)
12:05:50 <warlord> I've got 16 true cores on my VM, but Linux sees 32 (hyperthreading, I guess)
12:06:24 * gjanssens is still on a rusty old 4-core system :(
12:07:05 <warlord> gjanssens: so does my laptop
12:07:52 <gjanssens> warlord: nice for you, I was referring to my server...
12:08:09 <warlord> Oh. I think the old vm server had 8 cores
12:10:54 <gjanssens> You can send it to me, that would double my performance :D
12:11:03 <gjanssens> Oh well, no complaints.
12:11:15 <gjanssens> It's doing what it should do
12:11:56 <gjanssens> I plan to upgrade it this year or next. But it's not urgent
12:23:43 <warlord> LOL. It took me ~8 years to upgrade my VM hardware.
12:26:51 *** tuxd00d has quit IRC
12:31:53 <gjanssens> warlord, linas: although my home server is not a good candidate and my home network is too slow I also manage a colocated server
12:32:17 <gjanssens> I'd be interested in providing gnucash services from there as well to add a 3rd server to the redundancy pool
12:32:28 <gjanssens> What do you think about that ?
12:32:57 *** tuxd00d has joined #gnucash
12:36:58 *** mlncn has quit IRC
12:39:33 <warlord> Do you have any bandwidth caps/constraints?
12:39:49 <warlord> I've got 1gbps symmetric service with no data caps.
12:40:08 <warlord> (although apparently they wont delegate reverse DNS for IPv6)
12:47:19 <gjanssens> Bandwidth is unlimited until 30TB/month
12:48:02 <gjanssens> I have managed to configure it for IPv6 but I don't know the finer details of that protocol just yet
12:49:01 <gjanssens> When I cross the 30TB, bandwith will be restriced to 10Mbs
12:49:29 <warlord> Linas, do you have a feel for how much data www uses?
12:50:17 <warlord> I run in the 500GB-1TB/mo range here.
12:50:29 *** tuxd00d has quit IRC
12:54:42 *** tuxd00d has joined #gnucash
12:54:52 <linas> warlord, one moment ..
12:55:32 <linas> Hey, I graph server stats on a web page -- mrtg -- I'm not sure I thought you had access to that
12:56:02 <linas> it includes not just usage, but the number of ssh passwd guessing attempts per minute, the number ti icmp redirects, etc.
12:56:21 *** kael has joined #gnucash
12:57:43 <linas> warlord, yearly average for gnucash.org is 52kByte/sec
12:59:11 <linas> or 135 GByte/month or 1 Tbit/month
12:59:26 *** tuxd00d has quit IRC
12:59:39 <warlord> That works out to... . yeah.. 135GB/mo is easy to handle.
12:59:48 <gjanssens> Yep
13:00:02 <linas> yeah, the machine that this is in is 98% idle
13:00:28 <warlord> So then the question would be TLS.
13:00:54 <linas> well, that's with tls turned on
13:01:19 <linas> I don't know how many peope access with http vs https, I don't track that stat
13:01:32 <warlord> Yes, I meant -- if we add additional servers -- how would we handle TLS? We'd probably need to share keys between the servers?
13:01:44 <linas> slightly off-topic: what are the best data dashboard tools you know of?
13:01:55 <linas> Like mrtg, but more general?
13:02:12 *** kael has quit IRC
13:03:24 *** tuxd00d has joined #gnucash
13:03:35 <linas> ah, warlord -- do you want to literally split traffic, so that half goes to each, or do you want to build a fail-over mechanism?
13:03:42 <warlord> What kind of data are you trying to display? I use mrtg for lots of stuff
13:04:23 <warlord> linas: I was thinking split traffic, but I think you need similar infrastructure for a fail-over.
13:04:46 <linas> I need to build a machine-learning data analysis dashboard, I need to automate my mostly-manual process for viewing the dat results
13:05:48 <warlord> I use mrtg for a bunch of stuff -- you can get it to run scripts. The downside is that it only gives you 2 readings per graph.
13:05:50 <linas> warlord: we could run sshfs between the two sites. I used sshfs some 6-8 years ago, and it worked great
13:06:40 <warlord> linas: Sure.. Or just a periodic rsync. I was thinking one would be the master server and the others would rsync off it.
13:06:51 <linas> i.e. that would be one way to copy certificates from one machine to another
13:07:02 <warlord> *nods*
13:07:06 <linas> or rsync
13:07:15 <warlord> I like rsync-over-ssh personally.
13:07:32 <warlord> (easiest to automate)
13:07:47 <linas> I've used rsync only very rarely
13:08:32 <linas> I've never had to do much inter-site automation
13:10:03 *** fekepp has quit IRC
13:12:00 <warlord> rsync is nice in that it only copies what changed so if only 1 file changed that's all that gets copied across.
13:13:46 <warlord> I've also almost completely migrated over to letsencrypt for all my certificate management. I wont know if my cron job renewal works for a couple months.
13:19:22 *** fabior has quit IRC
13:28:51 *** mlncn has joined #gnucash
13:36:56 *** kael has joined #gnucash
13:38:21 *** kael has quit IRC
13:39:09 *** tuxd00d has quit IRC
13:41:41 <warlord> gjanssens: can you ping6 code.gnucash.org ?
13:43:15 *** kael has joined #gnucash
13:46:53 <linas> ah you have ipv6!
13:47:15 <warlord> I do -- via a Hurricane-Electric (tunnelbroker) tunnel.
13:47:18 <linas> or is that through hurricane?
13:47:22 <linas> ok
13:47:47 <warlord> AT&T wont delegate reverse DNS for IPv6, so I can't use their "native" service.
13:48:14 <warlord> But I just migrated my HE tunnel from comcast to AT&T and it's working.
13:48:44 <warlord> Of course I've yet to actually *USE* the gigabit speeds.
13:59:22 <gjanssens> warlord: yes I can ping it
14:01:02 <gjanssens> however does code also have an IPv6 address ?
14:01:53 <gjanssens> Nevermind. Found it.
14:02:19 <gjanssens> ping6 works fine both with code.gnucash.org and via it's IPv6 address directly
14:04:04 <warlord> great. That means the tunnel is working after reconfiguring it over the new network.
14:07:02 *** avionii has quit IRC
14:08:48 *** avionii has joined #gnucash
14:10:00 *** kael has quit IRC
14:18:57 *** tuxd00d has joined #gnucash
14:21:26 *** avionii has quit IRC
14:22:07 *** avionii has joined #gnucash
14:29:08 *** fekepp has joined #gnucash
14:45:16 *** fabior has joined #gnucash
15:05:38 *** kael has joined #gnucash
15:27:17 *** Mechtilde has quit IRC
15:45:15 *** kael has quit IRC
16:00:16 *** fell_ is now known as fell
16:01:49 <fell> gjanssens, IIRC there is also a mirror at the TU Vienna, but I didn't check it for longer.
16:04:48 <fell> http://gd.tuwien.ac.at/gnu/gnucash/gnucash/
16:07:23 <fell> at least they offer tgz's of our releases
16:10:38 <linas> warlord, realize your gigabit os ovrsubscribed; I'll bet you actually have a PON passive optical network
16:11:05 <linas> which you are sharing with 10 or 100 of your neighbors.
16:12:47 <linas> trouble with PON, as I learned: if any one unit goes bad, the entire neighborhood goes down
16:13:22 <linas> kind-of-like the bad-old-days of ethernet, where everyone shared the same single ethernet coax cable.
16:14:36 <linas> in my case, they had to send a tech door to door, to disconnect each NID to see if it was the one that was screaming
16:15:10 <linas> going down for a reboot now
16:15:47 *** linas has quit IRC
16:16:39 <gjanssens> fell: that mirror still exeist apparently
16:16:47 <gjanssens> It's only hosting sources though
16:17:08 <gjanssens> warlord and I were considering hosting www.gnucash.org
16:17:30 <gjanssens> so it would still be available if linas' site has connection issues
16:19:46 <fell> Yes, I think it is a good idea to have a mirror outside the US as you don't know, which idea their "president" will have tomorrow.
16:20:08 <gjanssens> :)
16:20:17 <gjanssens> or rather :(
16:21:11 <fell> Eg.g an electronic fence around the rest of the world ;-)
16:33:11 *** ThomasKeller has quit IRC
17:39:12 *** fabior has quit IRC
17:50:31 *** gjanssens has quit IRC
17:58:51 *** rickoehn has quit IRC
18:05:35 *** kael has joined #gnucash
18:16:38 *** kael has quit IRC
21:21:53 *** cyphase has joined #gnucash
22:18:51 *** lwells has quit IRC
22:19:02 *** fekepp has quit IRC
22:19:09 *** fekepp has joined #gnucash
22:21:44 *** lwells has joined #gnucash
23:11:03 *** linas has joined #gnucash