2016-02-27 GnuCash IRC logs

00:32:17 *** Mechtilde has joined #gnucash
01:36:09 *** ErKa has quit IRC
02:31:27 *** meb has joined #gnucash
03:06:32 *** rubdos has joined #gnucash
03:59:53 *** rubdos has quit IRC
04:00:29 *** gjanssens has joined #gnucash
04:00:29 *** ChanServ sets mode: +o gjanssens
04:03:05 *** rubdos has joined #gnucash
04:39:17 *** fell_ has quit IRC
05:10:15 *** jonas has joined #gnucash
05:11:05 <jonas> I'm trying to add a swedish mutual fund as a gnucash account, but I'm having trouble
05:11:53 <jonas> I'm trying to add it as a type of security, and it has a ISIN-code, but I don't know the display symbol or where to get quotes
05:25:01 *** mlncn has joined #gnucash
06:04:48 *** Jimraehl1 has left #gnucash
06:09:50 *** Jimraehl1 has joined #gnucash
06:17:03 *** mlncn has quit IRC
06:22:44 *** rubdos has quit IRC
06:31:17 *** rubdos has joined #gnucash
06:53:51 *** gnucash has joined #gnucash
08:26:58 <jonas> I can't import my mastercard-transactions directly from the provider into gnucash, but I can whip up a greasemonkey-script to extract the transactions from the card providers homepage
08:27:14 <jonas> is it possible for me to format the transactions in text in such a way that I can easily import them into gnucash?
08:27:31 <jonas> like pasting them in a specific text format, for example
08:27:39 <jonas> any ideas?
08:28:16 <gjanssens> jonas: the best supported import format in gnucash is qif
08:28:30 <gjanssens> Other than that you can also try with ofx format or csv
08:28:58 <gjanssens> csv is probably the best understood by most users, so you may want to try that first
08:29:12 <jonas> CSV sound like a good idea
08:29:25 *** lwells has quit IRC
08:29:49 <gjanssens> As for your earlier question today: I'm not using gnucash for stocks handling so others may have a better suggestion
08:30:46 <gjanssens> Having said that, I believe the display symbol is not required. IIRC it's mostly for your convenience and you can choose whatever you like.
08:30:57 <gjanssens> (Others will surely correct me if I'm mistaken)
08:31:23 <gjanssens> As for where to get quotes, you will have to figure out which stock exchange trades your mutual fund.
08:32:26 <gjanssens> Gnucash can query a number of them, but it needs to know which one has your mutual fund.
08:33:19 <gjanssens> jonas: In addition this will only work if you have finance::quote installed.
08:33:24 <gjanssens> On most linux systems this is a requirement for the gnucash installation and so it will be installed automatically.
08:33:34 <gjanssens> On windows you will have to install in manually
08:34:46 <jonas> I'm using linux, but these are swedish mutual funds so I don't hold out hope that it will be possible to automatically import anything, really
08:35:13 <jonas> I've resigned to having to manually sample and input the prices
08:37:43 *** lwells has joined #gnucash
08:46:15 <jonas> it appears I cannot import a CSV file that I have just created via exporting
08:47:15 <jonas> I reach an entirely greyed out account selection dialog
08:55:09 <gjanssens> jonas: did you set the proper columns on the previous page ?
08:55:38 <gjanssens> The importer is a bit picky (improvements are on the way for the next major release - 2.8)
08:56:33 <jonas> yeah, I missed that, thanks
08:57:18 <jonas> I would have wished that gnucash understood some nice paste format or other, though
08:57:54 <jonas> date;num;desc;transfer acc;r;debit;credit\n or something along those lines
08:58:54 <jonas> I don't see a very good workflow, for mass-importing data from an external system that isn't supported by gnucash, regularly
08:59:21 <jonas> I can work around it though
09:00:02 <jonas> can't say I have any good ideas for a general, flexible way to import data like that, either
09:03:30 <gjanssens> jonas: yes, gnucash is not very optimized for automation
09:03:45 <gjanssens> It's not its core feature unfortunately
09:04:02 <gjanssens> As you are on linux, you may look into the python bindings though
09:04:11 <gjanssens> They may provide you better ways to automate
09:04:45 <gjanssens> Again not all of gnucash' functionality is exposed via this interface, but at least adding transactions is
09:04:51 <jonas> that might be a better path that what I'm thinking
09:04:59 <jonas> thanks for the tip
09:05:10 <gjanssens> you're welcome
09:29:13 <gjanssens> jralls: Tobias Markus has chosen an unfortunate way to get involved, hasn't he ?
09:29:50 <gjanssens> I really hope he's willing to rework his patch set
09:30:05 <gjanssens> as I would really like to see a migration to gtk+3
09:30:42 <gjanssens> However I'm also totally with you that the current state of the patch will cause us more sorrow than benefit.
09:38:56 *** rubdos has quit IRC
09:39:33 *** rubdos has joined #gnucash
10:28:23 <jonas> I'm trying to follow http://svn.gnucash.org/docs/HEAD/simple__test_8py_source.html to programmatically add a transaction to my gnucash accounts
10:29:13 <jonas> it only works halfway, I am able to add the transaction + comment to the specified accounts, but the amounts won't show up
10:30:01 <jonas> the python-code I'm using is http://hastebin.com/coyabawega.py
10:30:25 <jonas> any ideas?
10:33:12 <jonas> ah, I figured it out
10:33:33 <jonas> GncNumeric(123, 0) results in 123/0, not 123.0 as I had assumed
10:33:48 <jonas> rubber duck debugging :)
10:46:45 *** fell has joined #gnucash
10:46:46 *** gncbot sets mode: +o fell
10:48:38 *** meb has quit IRC
10:56:44 *** Mechtilde has quit IRC
11:18:30 *** Mechtilde has joined #gnucash
11:40:20 *** BuschMan has joined #gnucash
11:46:28 *** gjanssens is now known as gjanssens_afk
11:50:17 *** BuschMan has quit IRC
11:51:54 *** gnucash has quit IRC
12:03:07 *** gnucash has joined #gnucash
12:23:12 *** rubdos has quit IRC
12:55:41 *** minot has joined #gnucash
13:27:02 <warlord> jonas: FYI, QIF is well supported, and is a fairly simple text-file format!
13:28:09 <warlord> gjanssens_afk: I'm with you on gtk3. :(
13:28:33 *** bozonius has quit IRC
13:39:40 *** Mechtilde has quit IRC
14:28:19 *** gnucash has quit IRC
14:31:18 *** fabior has joined #gnucash
14:41:48 *** gjanssens_afk has quit IRC
14:50:06 *** fabior has quit IRC
15:05:11 *** MoeD has quit IRC
15:21:44 <jonas> I solved the importing via the python-bindings
15:22:07 <jonas> a greasemonkey-script extracts the relevant data from the mastercard banks webpage as a json-object
15:22:40 <jonas> the python bindings then categorize some of the transactions into commonly used accounts then import the entire thing into gnucash
15:23:09 <jonas> works out pretty well, should save me a lot of effort
15:23:51 <jralls> jonas: Great.
15:43:51 *** minot has quit IRC
16:33:09 *** ErKa has joined #gnucash
16:36:32 <jralls> fell, warlord, why did you guys decide to reject the Torres wiki account?
16:55:58 *** ErKa has quit IRC
17:32:18 *** gnucash has joined #gnucash
17:47:24 <fell> jralls, I only rejected ilntech
17:48:08 <jralls> fell: Yeah, that's him. Real name Msrc Torres.
17:48:29 <fell> alias Marc Torres alias Josh Osborne
17:48:35 <jralls> s/Msrc/Marc/
17:49:17 <jralls> Ah, so he turned out to be less than forthcoming about himself?
17:56:04 <fell> 1. A username = a full company name is problematic, special if the mail is not from the CEO or press officer
17:57:42 <fell> 2 he answered derek as J.O., not M.T.
17:58:06 <fell> IMHO in very poor english.
17:59:41 <jralls> OK. Sounds like he was trying to game us.
17:59:42 <fell> 3. we got the impression he was not interested in the wiki but the program
18:00:57 <fell> So I denied the request with the addition "feel free to create a new account with a less problematic user name."
18:04:18 <fell> Perhaps warlord could configure it in a way where the emails are stored somwhere for review.
18:09:30 <warlord> I thought they would get logged, but apparently not.
18:49:59 *** bertbob has quit IRC
18:50:35 *** mlncn has joined #gnucash
19:04:31 *** bertbob has joined #gnucash
20:37:36 *** MoeD has joined #gnucash
20:39:05 *** gnucash has quit IRC
21:48:21 *** fell_ has joined #gnucash
21:48:52 *** gncbot sets mode: +o fell_
21:50:46 *** fell has quit IRC
21:56:29 *** meb has joined #gnucash
22:26:52 *** meb has quit IRC
23:38:54 *** Mechtilde has joined #gnucash