2015-03-03 GnuCash IRC logs
00:07:26 *** himaxx has quit IRC
00:36:00 *** O01eg has quit IRC
01:24:12 *** MechtiIde has joined #gnucash
01:58:23 *** ErKa has quit IRC
02:08:34 *** Krzysiek_K has joined #gnucash
02:09:53 *** Krzysiek_K has left #gnucash
02:14:32 *** MechtiIde has quit IRC
03:23:53 *** pacon has joined #gnucash
03:38:03 *** cartsoftware has joined #gnucash
03:45:07 *** cartsoftware has quit IRC
03:45:36 *** cartsoftware has joined #gnucash
04:03:40 *** lmat has joined #gnucash
04:07:22 *** lmat_ has quit IRC
04:18:18 *** fabior has joined #gnucash
04:56:49 *** fabior has quit IRC
04:57:51 *** StuM has quit IRC
04:59:05 *** fabior has joined #gnucash
05:01:53 *** pacon has quit IRC
05:06:40 *** cartsoftware has quit IRC
05:07:35 *** cartsoftware has joined #gnucash
05:55:09 *** GabrieleV_ has joined #gnucash
05:55:10 *** GabrieleV has quit IRC
05:55:11 *** GabrieleV_ is now known as GabrieleV
06:03:10 *** aqua_ has quit IRC
06:07:02 *** lwells_ has joined #gnucash
06:10:12 *** lwells has quit IRC
06:53:30 *** Jimraehl1 has left #gnucash
06:56:00 *** himaxx has joined #gnucash
06:57:57 *** himaxx has quit IRC
07:03:57 *** Jimraehl1 has joined #gnucash
07:31:24 *** StuM has joined #gnucash
07:45:27 *** cartsoftware has quit IRC
07:48:44 *** rickoehn has joined #gnucash
08:11:40 *** aqua_ has joined #gnucash
08:28:03 *** himaxx has joined #gnucash
08:31:54 *** fabior has quit IRC
08:40:28 *** lmat has quit IRC
08:43:12 *** andy has quit IRC
08:48:13 *** aqua_ has quit IRC
08:55:35 *** aqua_ has joined #gnucash
08:58:02 *** andy has joined #gnucash
09:00:35 *** cartsoftware has joined #gnucash
09:00:39 *** grantbow has quit IRC
09:11:34 *** ErKa has joined #gnucash
09:16:12 *** GabrieleV has quit IRC
09:16:41 *** GabrieleV has joined #gnucash
09:27:28 *** fabior has joined #gnucash
09:30:31 *** StuM has quit IRC
09:31:42 *** GabrieleV_ has joined #gnucash
09:31:43 *** GabrieleV has quit IRC
09:31:43 *** GabrieleV_ is now known as GabrieleV
09:56:21 *** gjanssens has joined #gnucash
09:56:21 *** gncbot sets mode: +o gjanssens
09:59:20 *** lmat has joined #gnucash
10:04:56 *** wol has joined #gnucash
10:14:52 *** cartsoftware has quit IRC
10:15:57 *** Hinnerk has joined #gnucash
10:16:01 <Hinnerk> hi
10:16:33 <Hinnerk> @warlord: I gave up manual pruning of the import-bayes-map and am currently working on a little perl script to do the job.
10:16:33 <gncbot> Hinnerk: Error: "warlord:" is not a valid command.
10:16:38 <Hinnerk> warlord: I gave up manual pruning of the import-bayes-map and am currently working on a little perl script to do the job.
10:17:09 <Hinnerk> if GnuCash loads the xml, is this a good sign concerning well-formed xml?
10:17:25 <Hinnerk> or is gnucash quite tolerant and may crash later?
10:18:06 <warlord> it's not very tolerant. if it loads without error then it is *probably* well formed.
10:18:11 <Hinnerk> ok
10:22:42 *** cartsoftware has joined #gnucash
10:24:43 *** lmat has quit IRC
10:32:26 *** O01eg has joined #gnucash
11:20:39 <Hinnerk> will be back later...
11:20:41 *** Hinnerk has quit IRC
11:28:09 *** jimvideo has joined #gnucash
11:35:28 *** ErKa has quit IRC
11:43:36 *** wol has joined #gnucash
11:51:44 *** MechtiIde has joined #gnucash
11:55:28 *** Hinnerk has joined #gnucash
11:55:31 <Hinnerk> rehi
11:55:48 <Hinnerk> ok, I think I have my first version of a perl script pruning bayes.
11:56:03 <Hinnerk> current it can eliminate based on two rules:
11:56:25 <Hinnerk> account (or parent account) appears in a given text file. This is used for obsolete accounts.
11:56:53 <Hinnerk> remove slot which have a low weight. I currently delete everything with a weight of up to 2.
11:57:14 <Hinnerk> that saved - uncompressed - 2 MB of 16,5 MB.
11:57:51 <Hinnerk> There is much space for more. Personally I think all tokens using a daytime should be killed as well.
12:00:58 <Hinnerk> and i still think "/" should be a separator and a token.
12:02:14 <Hinnerk> much good information is lost to the fact that after some customer id a /monthyear follows.
12:02:45 <Hinnerk> to the highly significant token of the customer id keeps being ignored essentially.
12:04:07 <Hinnerk> but that is of course out of scope of my script. it needs to be fixed in gnucash directly.
12:09:05 <warlord> indeed
12:13:47 <Hinnerk> damn, one of my last changes broke the xml - not sure where yet...
12:15:07 *** wol1 has joined #gnucash
12:18:58 *** wol has quit IRC
12:20:47 <Hinnerk> doesn't look broken :/
12:20:48 *** lmat has joined #gnucash
12:35:07 <warlord> xmllint?
12:47:50 <Hinnerk> I think i got it, just checking...
12:48:44 <Hinnerk> yepp, looks good.
12:48:55 <Hinnerk> I "extreme-pruned" to find the mismatch :)
12:49:10 <Hinnerk> now need to back to normal
12:52:15 <Hinnerk> is there a way to test the import without actually importing productive data from my checking account?
12:52:34 <warlord> Hinnerk: use a backup file
12:52:58 <Hinnerk> ok ,that is "since last run" is alwys stored locally, not with the bank?
12:54:36 <warlord> Correct
12:54:52 <warlord> Well, I shouldn't be so quick to say so.
12:54:54 <warlord> *probably*
12:54:57 <warlord> it might depend on the bank
12:55:08 <Hinnerk> hm
12:55:30 <Hinnerk> is this now just a common paranoid disclaimer or should i actually watch out?
12:59:50 <Hinnerk> some stats:
13:00:20 <Hinnerk> The script removed with "normal" settings 6237 accounts, leading to complete remvoal of 4167 tokens.
13:00:45 <Hinnerk> uncompressed size reduction 1,8 MB.
13:00:54 <Hinnerk> (of 16,6 MB)
13:10:41 *** lmat has quit IRC
13:25:04 <Hinnerk> ok.
13:25:09 <Hinnerk> so i did the following:
13:25:20 <Hinnerk> I removed all trx from my checking account in gnucash
13:25:27 <Hinnerk> and reimported them.
13:25:38 <Hinnerk> after having pruned bayes.
13:26:02 <Hinnerk> there are some surprises. but the vast majorty is imorted green.
13:26:17 <Hinnerk> a few ones I'm suprised it didn't recognise.
13:27:10 <Hinnerk> but it now imported as green trx which it couldn't recognise earlier.
13:27:24 <Hinnerk> so I'm happy - I assume the other ones it will "relearn".
13:27:46 <Hinnerk> maybe I'll give it another short with slightly more lenient settings.
13:28:08 <warlord> cool
13:31:21 *** ErKa has joined #gnucash
13:34:26 *** KaiForce has joined #gnucash
13:36:33 <Hinnerk> I lowered the threshold for minimum weight, but it didn't improve the result.
13:36:40 <Hinnerk> I think 3 as a minimal weight is ok.
13:36:47 <Hinnerk> everything else can be prund.
13:37:03 <Hinnerk> I also removed a buch off accs which are either obsolete
13:37:19 <Hinnerk> or which should never get any direct trx anyway (e.g. Ausgleichskonto-EUR)
13:37:58 <Hinnerk> I considered also pruning short tokens, but that turned out not to be a good idea.
13:38:12 <Hinnerk> especially withdrawls are sometimes cryptic
13:38:27 <Hinnerk> and can only be recognised by letters like "GA" or "PGA".
13:38:34 <Hinnerk> so they stay in.
13:38:51 <Hinnerk> anyway, if their weigth is low, they'll be pruned the other way anyway.
13:39:19 <Hinnerk> this also got rid of all the tokens containing timestamps...
13:39:45 <Hinnerk> anyone wants the script?
13:40:02 <warlord> Hinnerk: you can try asking on gnucash-user to see if anyone wants it
13:40:46 <Hinnerk> i think it'd rather post it on dev - I don't feel comfy with giving it users not backing up their data and breaking it or something stupid.
13:50:44 *** aqua_ has quit IRC
13:53:52 <warlord> okay
13:53:55 <warlord> that's fine too
14:08:42 *** lmat has joined #gnucash
14:12:13 <Hinnerk> just sent it out.
14:16:46 <Hinnerk> I don't see the post. Is it being withheld?
14:17:01 <Hinnerk> Wow, mailing lists...
14:31:30 *** lmat_ has joined #gnucash
14:35:20 *** lmat has quit IRC
14:39:41 <Hinnerk> one more interesting fact:
14:39:54 <Hinnerk> I disabled the pruning of low weights.
14:40:03 <Hinnerk> and only removed obsolete accounts.
14:40:19 <Hinnerk> This fixed my problem with the trx which weren't recognised.
14:40:39 <Hinnerk> But the matching otherwise didn't get better than with a minimum weight of 3 or 4.
14:40:48 <Hinnerk> so, these can definitely go.
14:41:05 <Hinnerk> I also no wonder about how the algo actually calculates the result.
14:41:17 <Hinnerk> For Vodafone e.g. i have highly signifiacnt tokens.
14:41:27 <Hinnerk> but it isn't recognised.
14:41:33 <Hinnerk> strange.
14:41:59 <Hinnerk> I'm considering doubling weights that are 5 or higher...
14:42:13 <Hinnerk> I wonder if that would make a difference.
14:44:52 *** MechtiIde has quit IRC
14:45:45 <warlord> and there's your email
14:45:46 *** ErKa has quit IRC
14:45:59 <Hinnerk> with a bunch of typos :)
14:52:07 <Hinnerk> ok, doubling high weights is a stupid idea.
14:53:15 <warlord> lol
14:56:57 <kimmo2_> hey, I'm looking for a feature that'll automatically itemize and input a year's worth of expenses... anyone?
14:57:09 <kimmo2_> bonus points for automatic scanning without my intervention
14:57:20 <warlord> kimmo2_: that's called "hiring a data entry assistant" :)
14:57:31 <kimmo2_> oooh
14:57:52 <kimmo2_> the deadline in finland for annual VAT filers was monday
14:58:08 <kimmo2_> so I spent the last week scanning, remembering, etc
15:00:09 <warlord> oops!
15:01:02 <kimmo2_> then again, it only hurts one week a year
15:02:15 <kimmo2_> and according to my excel, by actually doing the work, I generated deductions at double my normal hourly rate, and that's tax free so it's not that bad
15:11:59 *** fell_ is now known as fell
15:13:56 <fell> Hinnerk: You could write down you research results in a wiki page "Bayes" or similar and attach your script there.
15:15:05 <fell> You can see an example in http://wiki.gnucash.org/wiki/Account_Hierarchy_Template
15:15:28 <perth> :/ Cant find the setting that controlls autocompletion (of the account field). Anyone know where that is off the top of their head?
15:17:10 <perth> Search dialog! :)
15:17:56 <warlord> perth: what do you mean "controls autocompleton of the account field"? What kind of "control" are you looking for?
15:19:00 <perth> Expenses:Asomething is automatically chosen when I Type the 'E''x'. Instead of staying in Expenses I'm kicked into Expenses:Asomething. Super anoying
15:19:34 <perth> Set the search dialog to 2 and Ex keeps me at Expenses so I cat type ':' and then the first next letter
15:19:58 <perth> Did I explain that clearly enough?
15:21:54 <Hinnerk> now I tested adding some bonus (3) if the weight was at least 6. this also produced false positives, so should be avoided.
15:23:52 <Hinnerk> fell: From where should I link that article? I don't just want to produce something that is completely lost unless you directly search for it.
15:24:21 <perth> Hinnerk: what if you do that in instances where the token meets certain requirements and make it a default off option to your script?
15:24:40 <perth> Or accepts input, finds those tokens, and increases their wight.
15:24:59 <warlord> perth: It will always autocomplete fully, but if you just type the ':' it will stop. E.g., you can always type E x : G r to get to Expenses:Groceries
15:25:22 <Hinnerk> well, I need a rule. there are thousands of tokens and accounts in Bayes.
15:25:33 <Hinnerk> I'm beyond hand-fixing these (tried that yesterday).
15:25:39 <perth> warlord: Correct, except that I was typing E x and getting into Expenses:1stSubItem
15:26:18 <perth> By getting into I mean my cursor posistion was .. at the end? let me double check
15:26:19 <warlord> perth, yes, that is what will show, but as soon as you type the : G it will put you into a different place in the tree.
15:26:27 <perth> wasn't
15:26:38 <warlord> what version of gnucash? and what OS/Distro?
15:27:09 <fell> Hinnerk: I could create a link in http://wiki.gnucash.org/wiki/GnuCash#Documentation Scripting and Programming:
15:27:10 <warlord> (this feature works for me on Fedora)
15:28:37 *** Krzysiek_K has joined #gnucash
15:29:41 <perth> warlord: set it back and it's not doing it any more... Guncash 2.6.4 on Gentoo
15:30:49 <warlord> "not doing it anymore"?
15:31:33 <perth> Ex does what it's supposed to. The cursor remains in Expenses instead of jumping to the end of Expenses:1stItem
15:31:43 <warlord> okay..
15:31:48 <Hinnerk> I'm going through "Published Tools".
15:32:10 <perth> Yep :) sorry, if it comes back I'll try to put something together for a bug report, seems that's what you were after
15:33:01 *** ErnstNeger has joined #gnucash
15:33:13 <warlord> THanks
15:33:35 <warlord> There were issues with this with some versions of gtk/gdk back in the 2.0 days.. But I haven't seen the issue in a long time.
15:34:28 <perth> Huh
15:34:37 <perth> Wonder what happens if i set search depth to 0
15:35:04 <perth> Forces 1, wonder what 0 would do
15:35:50 <perth> Also of not, it was ignoring Equity and jumping straight to Expenses. Not sure how the systems setup, that might be relavent
15:36:08 <gjanssens> warlord, perth: I think autofill sometimes still fails like that on occasion
15:36:23 <gjanssens> I sometimes run into it as well
15:36:49 <gjanssens> Looks like a timing issue, but I have not much more to add...
15:37:06 * perth shakes his head
15:37:16 <perth> Bugs like this can be the hardest
15:37:18 <fell> Hinner, just a note: Ususally you should complete the abstract on wiki edits.
15:41:32 <perth> Wish I had hierarchical per account reversed balance settings...
16:05:48 *** himaxx has joined #gnucash
16:09:33 <Hinnerk> wiki question: how to embed code?
16:09:47 <Hinnerk> what is the proper tag for it?
16:10:18 *** fabior has quit IRC
16:10:54 *** himaxx has quit IRC
16:15:39 <Hinnerk> http://wiki.gnucash.org/wiki/Bayes
16:18:00 *** Krzysiek_K has quit IRC
16:23:49 *** fell_ has joined #gnucash
16:23:51 *** gncbot sets mode: +o fell_
16:24:44 *** jlo has joined #gnucash
16:25:01 *** lwells_ has quit IRC
16:25:04 <Hinnerk> fell: http://wiki.gnucash.org/wiki/Bayes
16:27:56 *** fell has quit IRC
16:28:00 <fell_> Hinnerk: In theory there is a wiki module with syntax highlighting, but I don't know, if warlord installed it. So usually I take <pre>some code</pre>
16:31:01 <Hinnerk> any, i think it's ok the way it is.
16:31:15 <Hinnerk> just wanted to avoid code being interpreted as wiki tags
16:35:02 *** fell_ is now known as fell
16:37:29 <fell> I would prefer to have something like "#!/usr/bin/perl" in the first line. Then it is a recognized MIME type.
16:37:51 *** ErKa has joined #gnucash
16:38:48 *** gjanssens has quit IRC
16:39:16 <Hinnerk> fell:done.
16:42:13 <fell> Nice! Now we can extract a bunch of enhancement requests ...
16:48:56 *** Hinnerk_ has joined #gnucash
16:52:01 *** wol1 has quit IRC
16:57:03 *** KaiForce has quit IRC
16:58:01 *** Hinnerk has quit IRC
17:03:33 <Hinnerk_> are there still gnucash version out there without python binding?
17:05:15 <warlord> Hinnerk_: We do not ship python bindings for Mac or Windows
17:05:21 <Hinnerk_> I'm looking at importing historical stock prices, and the FAQ states "if your GnuCash version is built with Python binding..."
17:05:25 <Hinnerk_> oh
17:05:41 <Hinnerk_> now that would be usefull information in the space. will add that.
17:07:59 <warlord> They are "available" *IF* you build gnucash with the bindings. We dont by default for various reasons (namely that we would have to ship the full python env to make it work)
17:09:08 <Hinnerk_> well, that's going a bit far for a FAQ asking if you can import historical prices. Your answer now is: Yes, but on windows you first have to build GnuCash yourself...
17:13:47 <warlord> Actually it's both Mac and Windows.
17:14:02 <warlord> (and that presupposes that it *was* built with python support on Linux)
17:25:29 *** lmat_ has quit IRC
17:30:35 *** jlo has quit IRC
17:33:23 <Hinnerk_> has anyone used Finance::QuoteHist?
17:33:40 <Hinnerk_> I'm wondering if it is possible to use Yahoo Europe with it.
17:37:32 *** cartsoftware has quit IRC
17:44:00 *** StuM has joined #gnucash
17:54:52 *** rickoehn has quit IRC
18:16:43 *** GabrieleV_ has joined #gnucash
18:16:52 *** GabrieleV has quit IRC
18:16:52 *** GabrieleV_ is now known as GabrieleV
18:16:55 *** ErnstNeger has quit IRC
18:36:18 <Hinnerk_> anyway: Back to reports...
18:36:51 <Hinnerk_> is it possible to create something like a breakpoint to debug the scheme calculations?
19:04:30 *** jlo has joined #gnucash
19:23:46 *** keret has joined #gnucash
19:25:30 *** andy has quit IRC
19:27:00 *** Hinnerk_ has quit IRC
19:29:24 *** keret1 has quit IRC
19:37:24 *** jchonig has quit IRC
19:39:42 *** jchonig has joined #gnucash
19:59:02 *** StuM has quit IRC
20:00:23 *** jralls has joined #gnucash
20:18:21 <jralls> Hi from Tokyo!
20:19:09 <warlord> Konichiwa!
20:20:27 <jralls> Hmm,, guess I won't be interacting with the Europeans here much. They come up at my midnight and go to bed right when I'm getting up.
20:21:11 <warlord> What time is it there right now? It's 20:20 here in ATL
20:21:22 <warlord> (I know it's Wed, there)
20:21:42 <jralls> Right. It's 10:25AM right now.
20:22:12 <warlord> Ok, so exactly 12 hours from EST
20:22:23 <warlord> That means you're only 6 hours off from CEST
20:23:17 <warlord> (it's 4am for gjanssens and fell, for example) So they SHOULD be getting up in about 5-6 hours, which should be early afternoon for you.
20:23:23 <jralls> No, 8 hours. Japan Standard Time is UTC + 9, and CEST is UTC + 1.
20:24:20 <warlord> oh, oops, right, it's 20:00 is 8pm, not 10pm. (I'm just tired)
20:26:59 <jralls> It depends on when gjannsens gets around to IRC. Sometimes he's on in his morning, but most often only in the evening. Today he joined at 0956 EST and signed off at 1536, but it's true that I've seen in the logs that he's been on at 0100 EST.
20:27:56 <warlord> True.
20:28:02 <warlord> So how was your flight to NRT?
20:29:08 <jralls> Very nice. ANA has a new service from SJC, which is much more convenient than SFO. But if they don't get more folks to use it it won't last long. I don't think that there were more than 40 pax on the plane, a 787.
20:29:20 <jralls> Haven't seen a flight that empty since deregulation.
20:30:37 <warlord> WOW!
20:30:58 <warlord> That reminds me of a flight from TLV to JFK back in 1988 where I got a full row to myself on a 747
20:34:20 <warlord> Never been on a 787 -- was it a nice plane?
20:34:25 <jralls> There were lots of empty rows yesterday, everywhere except premium economy, where we were. There were about two dozen rows in business class and only 5 people.
20:34:51 <warlord> I bet they got awesome service.
20:35:10 <jralls> It's pretty spiffy. The windows are about 3x older planes and have LCDs instead of shades.
20:35:14 <jralls> Bet they did.
20:36:33 <jralls> Though having a row to yourself doesn't mean as much up there where everyone gets his own little capsule.
20:37:40 <warlord> True
20:38:06 <warlord> anyways, family time shortly. Enjoy your stay in Tokyo.
20:51:58 <jralls> Thanks. Tokyo's just a pit-stop, we're headed down to Kyoto tomorrow.
20:55:13 <warlord> Ah! Shinkansen down?
21:02:19 *** jralls has quit IRC
21:14:55 *** ErKa has quit IRC
21:18:18 *** jlo has quit IRC
21:28:49 *** jlo has joined #gnucash
21:38:52 *** lmat has joined #gnucash
22:08:16 *** gncbot` has joined #gnucash
22:08:17 *** gncbot has quit IRC
22:23:36 *** lmat has quit IRC
22:27:17 *** lwells has joined #gnucash
22:30:18 *** ErKa has joined #gnucash