2009-12-19 GnuCash IRC logs
00:03:42 *** warlord is now known as warlord-afk
00:16:12 *** blizgerg has quit IRC
06:29:29 *** ecolitan has joined #gnucash
06:44:01 *** bentob0x has joined #gnucash
07:00:17 *** cort has joined #gnucash
07:30:12 *** Jimraehl has left #gnucash
07:47:33 *** JimRaehl2 has joined #gnucash
07:57:37 *** JimRaehl2 has quit IRC
07:59:19 *** JimRaehl2 has joined #gnucash
08:01:23 *** JimRaehl2 has left #gnucash
08:01:43 *** JimRaehl2 has joined #gnucash
09:59:44 *** blizgerg has joined #gnucash
10:40:26 *** twunder has joined #gnucash
10:55:55 *** twunder has quit IRC
11:25:28 *** gjanssens has joined #gnucash
11:25:50 <gjanssens> Hi all
11:26:28 <gjanssens> I am looking into bug #493572
11:27:14 <gjanssens> https://bugzilla.gnome.org/show_bug.cgi?id=493572
11:27:31 <gjanssens> I thought it was going to be an easy one, but I got stuck eventually
11:29:08 <gjanssens> I boils down to function gnc_query_list_select_row in gnc-query-list.c
11:29:55 <gjanssens> In the context of the reconcile proces, this function is called for various events
11:30:08 <gjanssens> * left-mouse-button-release
11:30:19 <gjanssens> * user typed space
11:30:33 <gjanssens> * right-mouse-button-something
11:30:50 <gjanssens> At least these are the ones we're interested in
11:31:40 <gjanssens> The problem is that only when clicking with the left mouse button the event struct is valid
11:31:47 <gjanssens> In the other cases it's NULL
11:36:11 <gjanssens> So I can't distinguish between a space bar or a right-click.
11:37:17 <gjanssens> Going further up the chain I find that gnc_query_list_select_row is assigned to a clistclass->select_row property
11:37:45 <gjanssens> And from there it goes "underground", or at least I don't know how to follow this further
11:38:41 <gjanssens> I don't find much info on GtkClistClass that helps me here.
11:39:07 <gjanssens> To me it seems that the GtkClistClass is not properly passing the event information, but I don't know why.
11:39:57 <gjanssens> So the question: anyone knows how a GtkClistClass works and how I can make it pass a valid event object in case of a right-click ?
11:48:40 <gjanssens> As a sidenote, GtkClist has been deprecated since Gtk+2.0. Is GtkClistClass related to this is some way ?
12:39:10 *** blizgerg- has joined #gnucash
12:41:40 *** blizgerg has quit IRC
12:46:16 *** localhost1 has joined #gnucash
12:47:46 *** localhost has quit IRC
13:15:16 *** blizgerg- has quit IRC
13:26:20 *** BenB has joined #gnucash
13:26:26 *** daedeloth has joined #gnucash
13:27:13 <BenB> is there a way to change the account of several transactions at once?
13:27:48 <BenB> I want to search for a certain name in the description, and then book all transaction with that person/company on another account than currently.
13:29:27 <BenB> also or alternatively, I'd like a filtered view showing only transactions with that string in this account, but with running sum (of just those transactions) just like in an account.
13:30:10 <BenB> reason is: I have an account for telephone bills, but several telcos, and I need to know how much I paid each in the last year..
13:35:07 <gjanssens> Create a transaction report, select only the account for your telephone bills, set the proper date range and sort on description. Will that do ?
13:41:24 <BenB> gjanssens: it's an ugly workaround. none of the above is possible?
13:42:16 <BenB> if it's that cumbersome, I'll create subaccounts per recipient and manually reassign (just the last 2 years)
13:42:25 *** JimRaehl2 has left #gnucash
13:42:33 <BenB> (which still takes a while)
13:43:32 <gjanssens> BenB: I don't understand why it's an ugly work around ? Extracting information is what reports are meant for, and you want to extract your phone information ?
13:43:58 <gjanssens> I don't know of a way change several transactions at once, at least.
13:44:12 <gjanssens> But I don't see the need for it
13:44:29 <gjanssens> in your question, unless there's something I'm missing
13:45:34 <gjanssens> You can have subtotals in the report for each telco
13:46:09 <BenB> gjanssens: it's ugly, because a) I have to create a special report, instead of having the sum in a the normal income report, so I have to create the latter manually and b) the running sum for (say) AT&T starts at $5436 and ends at $7522, and I have to calculate it.
13:46:44 <BenB> gjanssens: in MS Money (which I used 15 years ago), there was an extra field for the recipient.
13:47:37 <BenB> gjanssens: I think the question "how much did I pay this company/person in the last year" is a quite obvious one that should be trivial to answer, without sorting by description (and hoping the name is at the beginning, which it isn't always)
13:48:43 <BenB> I can't have subtotals per telco in the report, from what I can see. all I have in gnucash is the description, and that looks like:
13:49:05 <BenB> RG <invoice number>,SIPID <customer ID> WWW.SIPGATE.DE VIELEN DANK INDIGO NETWORKS GMBH <my name>
13:51:55 <gjanssens> So you mean that each transaction has a different description ? That's ugly. Is this information entered automatically in some way ?
13:52:12 <BenB> of course each transaction has a different description.
13:52:24 <BenB> it's always like that (here in Germany)
13:53:03 <BenB> this information comes directly from the bank, from my account, via HBCI
13:53:20 <BenB> it's the exactly same that's on my bank account statements in paper.
13:54:03 <gjanssens> Right, that's the part I missed. I never used HBCI, so I am not familiar with how it creates transactions.
13:54:44 <gjanssens> If each transaction has a different description, I don't know a solution, sorry.
13:54:44 <BenB> well, even if I'd enter it entirely manually, I'd write "February 2009"
13:54:55 <BenB> gjanssens: ok, thanks for trying
13:55:06 <BenB> gjanssens: would be an RFE, then :)
13:58:18 <gjanssens> Apart from the description, does HBCI set other fields, such as the memo or a notes field ?
13:59:34 <BenB> there is nothing else. the bank gives only the description, one line per transaction. that contains everything in a non-formalized form: recipient/source, description, values etc..
14:00:09 <BenB> like the example I gave above. that's all there is. the paper doesn't have anymore either.
14:01:19 <BenB> but even if the bank did ofer more info, there would not be a field in gnucash.
14:01:26 <BenB> gnucash doesn't have a recipient field.
14:01:53 <gjanssens> Then I don't see a solution indeed. Closest match will be the search function, but it doesn't do a running sum... RFE time indeed
14:02:03 <BenB> gjanssens: with an old RFE I filed - https://bugzilla.gnome.org/show_bug.cgi?id=569200 / 113772 - I could create an account for each recipient, independent of my normal heirarchy.
14:02:48 <BenB> gjanssens: so, there are 2 problems: 1) no way to put the recipient, and look at them like at accounts
14:03:24 <BenB> 2) being able to make a search, and alter the whole set of transactions at once, so that I can reassign all transactions of a certain kind to a new account.
14:04:17 <BenB> or more generally, being able to /select/ a bunch of transactions, and change them all at once in a certain way (usually change the account)
14:09:20 <gjanssens> The next major release of GnuCash will have the ability to use a database as storage. That would help you with problem 2. You could just run the proper SQL statement directly in the database.
14:09:34 <BenB> *snicker*
14:09:38 <gjanssens> That's not an in-GnuCash solution and even not recommended, but it would be possible
14:10:17 <BenB> no problem for me, but for normal users it is :)
14:11:25 <gjanssens> Obviously. That why it's only a workaround, not a solution...
14:12:32 <gjanssens> And I'm afraid my time is up, I have to leave.
14:12:53 <gjanssens> Hopefully someone else can provide you with a better solution.
14:13:24 *** gjanssens has quit IRC
14:13:25 <BenB> gjanssens: thanks for your gentle help!
14:13:35 *** BenB has left #gnucash
14:34:14 *** Timslin has joined #gnucash
14:36:12 *** daedeloth has quit IRC
14:38:43 *** JimRaehl2 has joined #gnucash
14:39:02 *** Timslin has quit IRC
16:41:42 *** bentob0x has quit IRC
16:50:44 *** hobs has joined #gnucash
16:50:59 <hobs> hello
16:51:17 <hobs> need some help understanding how to change language in Gnucash
16:52:00 <hobs> want to switch to spanish in version 2.2.6
16:53:26 *** blizgerg has joined #gnucash
17:02:09 <hobs> can anybody help with this??
17:03:42 <jsled> http://wiki.gnucash.org/wiki/FAQ#Q:_I_want_to_use_GnuCash_in_my_own_language
17:06:32 <hobs> I found that already and have no idea how to find this
17:10:41 <hobs> also found the instructions 4.1 Changing the language on Windows...however there is no file "gnucash.cmd" in the folder "C:\Program Files\gnucash\bin" on my install which is version 2.2.6....is this the problem?...surely there is still a way to change language on 2.2.6...
17:13:41 *** blizgerg has quit IRC
17:13:58 *** blizgerg has joined #gnucash
17:35:52 *** blizgerg has quit IRC
17:44:04 *** blizgerg has joined #gnucash
18:15:19 *** zooko has joined #gnucash
18:15:39 <zooko> Greetings, people of #gnucash! Will anyone sell me a nicely bound copy of the gnucash manual as a book? I want to give it to my wife for Christmas.
18:18:06 <zooko> Okay, how about a nice PDF of the manual so I can print it?
18:23:47 <zooko> Hm I can find pdf's for gnucash v1.8, but that's too old...
18:24:20 <zooko> Oh well. :-(
18:37:48 *** ecolitan has quit IRC
18:40:54 *** zooko has quit IRC
19:10:27 *** warlord-afk is now known as warlord
19:10:33 <warlord> hobs: try gnucash.bat
19:12:36 *** warlord is now known as warlord-afk
19:36:57 <yancho> is there some template to start accounts for a partnership please? if not .. capital accounts of the partners need to be added under equity or assets please?
19:49:21 *** JimRaehl2 has left #gnucash
19:53:52 *** Jimraehl has joined #gnucash
21:58:51 *** cort has quit IRC
22:07:53 *** warlord-afk is now known as warlord
22:07:57 <warlord> yancho: capital == equity
22:24:29 *** blizgerg has quit IRC
22:25:24 *** blizgerg has joined #gnucash
23:32:41 *** warlord is now known as warlord-afk