2014-01-21 GnuCash IRC logs

00:01:12 *** Rebootus has quit IRC
00:01:44 *** Rebootus has joined #gnucash
00:02:28 *** benoitg1 has quit IRC
00:08:47 *** Rebootus has quit IRC
00:09:20 *** Rebootus has joined #gnucash
00:26:25 *** Rebootus has quit IRC
00:26:58 *** Rebootus has joined #gnucash
00:35:54 *** Jimraehl1 has joined #gnucash
00:38:01 *** vladatnyc has joined #gnucash
00:39:58 <vladatnyc> I can't seem to figure out how to use the account options in the split search. For example, if i want to find all transactions which includes accounts A and B how would i do that? thanks!
01:19:27 *** Rebootus has quit IRC
01:19:59 *** Rebootus has joined #gnucash
01:27:01 *** Rebootus has quit IRC
01:27:34 *** Rebootus has joined #gnucash
01:31:03 *** ErKa has quit IRC
01:39:39 *** Rebootus has quit IRC
01:40:12 *** Rebootus has joined #gnucash
01:52:17 *** Rebootus has quit IRC
01:52:50 *** Rebootus has joined #gnucash
01:59:55 *** Rebootus has quit IRC
01:59:56 *** fell has quit IRC
02:00:27 *** Rebootus has joined #gnucash
02:00:30 *** fell_ has joined #gnucash
02:00:30 *** gncbot sets mode: +o fell_
02:07:32 *** Rebootus has quit IRC
02:08:04 *** Rebootus has joined #gnucash
02:15:07 *** Rebootus has quit IRC
02:15:40 *** Rebootus has joined #gnucash
02:27:45 *** Rebootus has quit IRC
02:28:17 *** Rebootus has joined #gnucash
02:30:42 *** aqua___ has joined #gnucash
02:41:36 *** fell__ has joined #gnucash
02:41:36 *** gncbot sets mode: +o fell__
02:49:38 *** fell_ has quit IRC
02:55:41 *** Rebootus has quit IRC
02:56:14 *** Rebootus has joined #gnucash
03:03:31 *** jmd has joined #gnucash
03:13:23 *** Rebootus has quit IRC
03:13:55 *** Rebootus has joined #gnucash
03:15:05 *** jmd has quit IRC
03:17:30 *** fell__ has quit IRC
03:39:56 *** gjanssens has joined #gnucash
03:39:56 *** gncbot sets mode: +o gjanssens
03:56:17 *** Rebootus has quit IRC
03:56:49 *** Rebootus has joined #gnucash
03:58:07 *** aqua___ has quit IRC
04:03:56 *** Rebootus has quit IRC
04:04:28 *** Rebootus has joined #gnucash
04:09:28 *** jralls has quit IRC
04:16:33 *** Rebootus has quit IRC
04:17:05 *** Rebootus has joined #gnucash
04:24:12 *** Rebootus has quit IRC
04:24:45 *** Rebootus has joined #gnucash
04:29:45 *** aqua___ has joined #gnucash
04:46:52 *** Rebootus has quit IRC
04:47:25 *** Rebootus has joined #gnucash
05:04:32 *** Rebootus has quit IRC
05:05:04 *** Rebootus has joined #gnucash
05:11:51 *** aqua___ has quit IRC
05:32:15 *** Rebootus has quit IRC
05:32:48 *** Rebootus has joined #gnucash
05:43:12 <xnox> My "Accounts" tab shows future balance. But since I have transactions set up for 4 months in advance it's negative. Can I have a "today" column as well (as in current balances)?
05:43:18 <xnox> or is there a report that can show me that
05:44:28 <xnox> Oh, i did balance sheet as up to today, and that shows what I want =)
05:49:56 *** Rebootus has quit IRC
05:50:28 *** Rebootus has joined #gnucash
05:51:58 <xnox> ..
05:52:21 <xnox> Actually, i can just edit columns on the accounts tab, under the top right arrow =) handy, added present and future minimum =)
05:57:32 *** Rebootus has quit IRC
05:58:05 *** Rebootus has joined #gnucash
06:10:10 *** Rebootus has quit IRC
06:10:42 *** Rebootus has joined #gnucash
06:14:56 *** jmd has joined #gnucash
06:27:55 *** Rebootus has quit IRC
06:28:27 *** Rebootus has joined #gnucash
06:35:31 *** Rebootus has quit IRC
06:36:03 *** Rebootus has joined #gnucash
06:40:13 *** jmd has quit IRC
06:48:19 *** Rebootus has quit IRC
06:48:28 *** Jimraehl1 has left #gnucash
06:48:51 *** Rebootus has joined #gnucash
06:58:50 *** LiamH has joined #gnucash
07:03:22 *** aqua___ has joined #gnucash
07:11:13 *** Jimraehl1 has joined #gnucash
07:21:21 *** Rebootus has quit IRC
07:21:53 *** Rebootus has joined #gnucash
07:28:54 *** Rebootus has quit IRC
07:29:25 *** Rebootus has joined #gnucash
07:30:55 *** fell__ has joined #gnucash
07:30:55 *** gncbot sets mode: +o fell__
07:36:28 *** Rebootus has quit IRC
07:37:01 *** Rebootus has joined #gnucash
07:39:55 *** aqua___ has quit IRC
07:49:09 *** aqua___ has joined #gnucash
07:59:31 <warlord> vladatnyc: you cannot do that in the search, because the "Transaction Search" is really a "Split Search", and a single split is not going to match against multiple accounts.
08:00:11 <warlord> Rebootus: PLEASE TURN OFF YOUR THUNDERBIRD IRC CLIENT
08:07:53 *** ambimorph has joined #gnucash
08:14:32 *** Rebootus has quit IRC
08:15:05 *** Rebootus has joined #gnucash
08:20:02 *** fell__ is now known as fell
08:28:53 *** warlord sets mode: +b *!*Thunderbi@*2601:8:8400:bc4:3993:5499:c386:eb25
08:28:53 *** Rebootus was kicked by warlord (warlord)
08:29:11 *** warlord sets mode: +b *!*Thunderbi@2601:8:8400:bc4:*
08:29:55 <vladatnyc> warlord: so then what's the difference between "All Accounts" and "Account" in the search? Seems like the former implies that multiple accounts will be matched no?
08:31:11 <warlord> vladatnyc: All Accounts is used in a different context. I dont think it will work in a standard Txn Search
08:31:18 <warlord> But the UI is generic
08:32:20 <warlord> I'd have to go look at the code to see for sure; it's POSSIBLE that All Accounts might give you what you want... MAYBE..
08:33:32 <vladatnyc> warlord: ok i'll play around with it and see.... but just so that i have a starting point, the "Accounts" will return all transactions which have a split with one of the the selected accounts is that accurate?
08:34:06 <warlord> I rescind my previous statement. All Accounts is what you want.
08:35:03 <warlord> Yes, using "Account" is like saying "select * from Splits where Split.account=<Account1> or Split.account=<Account2>... (assuming you have multiple accounts selected)
08:35:16 <warlord> ... and assuming they are selected in the same line.
08:35:48 <warlord> If they are in MULTIPLE lines then you'll get: select * from Split where Split.account = Account1 AND Split.account = Account2, which is always the empty set.
08:36:48 <warlord> Using All Accounts, it will do a more complicated search, finding searching on multiple splits in a single transaction where all accounts match. So if you want to find all transactions between Account1 and Account2 you'd use All Accounts
08:37:35 <vladatnyc> ok just tried the all accounts out of the My Accounts tab and that did the trick
08:37:59 <vladatnyc> one last questions, is there anyway to select Account A and all sub accounts
08:38:29 <vladatnyc> so idea would be to run a search where let's say one of the accounts is anything under Assets and the other account is anything under Some Expense?
08:39:54 <warlord> Not in the find dialog.
08:40:36 <warlord> Why would you want such a search? That would effectively be the vast majority of your transaction; might as well just open the General Ledger.
08:40:39 <vladatnyc> is there a more advanced interface? for example can i use raw SQL to search for transactions and have them be returned?
08:41:49 <warlord> No
08:42:01 <warlord> What exactly are you trying to do?
08:43:33 <vladatnyc> i'm trying to implement "Tags" for my transactions, since GnuCASH doesn't have that one suggestion i came accross is to implement the tags as a set of accounts and then have transactions that "transfer" transactions out of expense accounts and into the Tag accounts
08:43:58 <warlord> Yeah, um, that's probably not a good way to do it.
08:44:09 <warlord> A better way would be something in the transaction notes field.
08:44:33 <warlord> Or better yet, actually implement Tags and donate the code.
08:45:32 <vladatnyc> i did some searching on it and it seems like people have at numerous times tried to implement it but seems like for some reason its a controversial topic, not sure why
08:46:03 <vladatnyc> i thought about notes and its not a very structured approach
08:46:19 <vladatnyc> but given the limitations on the search it might be the way to go
08:46:20 <warlord> No, it's not at all a controversial topic. Nobody has tried to implement it
08:46:51 <vladatnyc> hmmm... maybe i'll give it a shot then
08:47:02 <warlord> How is your C?
08:47:07 <vladatnyc> rusty :)
08:47:28 <warlord> The hardest part is going to be coming up with the "right way" to input, select, store, and search on tags
08:47:34 <vladatnyc> might be a good excuse to brush up
08:47:46 <warlord> Is it a single string of tokens? Or a list of strings.. Or...
08:50:27 <warlord> .. some more complicated data structure (such that you can easily rename tags, which means you have a display name and a GUID, like all the other objects.
09:15:03 *** jmd has joined #gnucash
09:16:00 *** jmd has joined #gnucash
09:16:22 *** vladatnyc has quit IRC
09:46:44 *** aqua___ has quit IRC
10:08:42 *** gjanssens is now known as gjanssens_
10:15:23 *** ambimorph has quit IRC
10:16:51 *** ambimorph has joined #gnucash
10:26:53 *** ambimorph has quit IRC
10:29:11 *** jmd has quit IRC
10:35:46 *** ErKa has joined #gnucash
10:42:55 *** lawsa has joined #gnucash
10:56:40 *** anujk has joined #gnucash
11:15:48 *** benoitg has joined #gnucash
11:16:59 *** ErKa has quit IRC
11:20:23 *** lawsa has quit IRC
11:23:07 *** aqua___ has joined #gnucash
11:31:34 *** aqua_ has joined #gnucash
11:36:13 *** aqua___ has quit IRC
11:42:42 *** ErKa has joined #gnucash
11:45:54 *** LiamH has quit IRC
11:50:34 *** ambimorph has joined #gnucash
11:54:54 *** LiamH has joined #gnucash
12:02:45 *** benoitg1 has joined #gnucash
12:02:48 *** benoitg has quit IRC
12:04:45 *** benoitg1 has quit IRC
12:05:05 *** benoitg has joined #gnucash
12:09:33 *** aqua_ has quit IRC
12:10:57 *** LiamH has quit IRC
12:25:28 *** LiamH has joined #gnucash
12:46:40 *** benoitg1 has joined #gnucash
12:46:41 *** benoitg has quit IRC
13:07:32 *** ggherdov has quit IRC
13:07:38 *** aqua___ has joined #gnucash
13:07:47 *** ggherdov has joined #gnucash
13:08:15 *** jmd has joined #gnucash
13:22:11 *** jralls has joined #gnucash
13:22:11 *** gncbot sets mode: +o jralls
13:23:59 *** Krzysiek_K has joined #gnucash
13:36:31 *** benoitg1 has quit IRC
14:09:38 *** KaiForce has joined #gnucash
14:20:36 *** lawsa has joined #gnucash
14:46:50 *** todd_ has joined #gnucash
14:46:54 *** TradeBorG113 has joined #gnucash
14:47:14 *** todd has quit IRC
14:57:14 *** todd_ has quit IRC
15:08:09 *** haclong has joined #gnucash
15:08:40 *** todd has joined #gnucash
15:23:20 *** benoitg has joined #gnucash
15:24:04 *** ErKa has quit IRC
15:31:43 *** ErKa has joined #gnucash
15:32:08 *** todd has quit IRC
15:32:15 *** todd has joined #gnucash
15:34:15 *** anujk has quit IRC
15:34:35 *** aqua___ has quit IRC
15:37:51 <fell> Hi ops!
15:38:34 <fell> I just added a section about SEPA: http://wiki.gnucash.org/wiki/De/HBCI#SEPA-Umstellung_Anfang_2014
15:39:50 <fell> If there are users with questions about SEPA, send them first there and later to gnucash-de, where more experts are.
15:39:51 *** haclong has quit IRC
15:41:50 <warlord> fell: thanks..
15:42:12 <fell> Always welcome!
15:42:18 <warlord> :)
15:51:05 *** TradeBorG113 has quit IRC
15:58:42 <fell> Also http://wiki.gnucash.org/wiki/FAQ#GnuCash_Localization_.28L10n.29_and_Font_Issues got extensions. :-)
15:59:45 <jmd> What the first url is basically saying, I think, is "it might not work".
16:01:17 <fell> No, it should work after some adjustments.
16:02:53 <fell> But it is not very well tested, e.g. Ing-Diba can not be reached currently. But Cstim knows the problem.
16:12:20 *** jmd has quit IRC
16:16:46 *** gjanssens_ has quit IRC
17:10:27 *** KaiForce has quit IRC
17:54:11 *** lawsa has quit IRC
18:35:29 *** benoitg has quit IRC
19:42:50 *** ErKa has quit IRC
20:51:29 *** wizkid239 has joined #gnucash
20:51:30 *** wizkid238 has quit IRC
21:14:21 *** ambimorph has quit IRC
21:22:17 *** ErKa has joined #gnucash
22:23:00 *** kpreid has quit IRC
22:23:33 *** kpreid has joined #gnucash
22:40:38 *** ErKa has quit IRC
23:05:31 *** LiamH has quit IRC
23:20:48 *** Neptune has joined #gnucash