2015-07-26 GnuCash IRC logs
00:01:05 *** fell_ has quit IRC
00:56:27 *** mlncn_ has quit IRC
01:46:59 *** dgtlmoon has quit IRC
02:27:12 *** MechtiIde has joined #gnucash
03:36:20 *** MechtiIde has quit IRC
03:41:25 *** MechtiIde has joined #gnucash
05:33:33 *** MechtiIde has quit IRC
05:38:51 *** fabior has joined #gnucash
05:45:21 *** MechtiIde has joined #gnucash
05:52:52 *** andy has joined #gnucash
06:03:38 *** andy has quit IRC
06:06:07 *** rubdos has joined #gnucash
06:12:52 *** andy has joined #gnucash
06:40:57 *** MechtiIde has quit IRC
06:50:00 *** mlncn has joined #gnucash
07:18:44 *** dgtlmoon has joined #gnucash
07:26:23 *** himaxx has joined #gnucash
07:35:20 *** himaxx has quit IRC
07:47:31 *** fabior has quit IRC
07:56:32 *** MechtiIde has joined #gnucash
08:05:10 *** himaxx has joined #gnucash
08:05:26 *** himaxx has quit IRC
08:42:31 *** storyjesse has joined #gnucash
08:58:24 *** fabior has joined #gnucash
08:59:49 *** ErKa has joined #gnucash
09:06:04 *** mlncn has quit IRC
09:15:45 *** Jimraehl1 has left #gnucash
09:16:23 *** Jimraehl1 has joined #gnucash
10:13:36 *** ErKa has quit IRC
10:28:35 *** ErKa has joined #gnucash
10:31:44 *** MechtiIde has quit IRC
10:34:33 *** MechtiIde has joined #gnucash
11:07:25 *** MechtiIde has quit IRC
11:57:52 *** ErKa has quit IRC
12:14:51 *** mlncn has joined #gnucash
12:18:07 *** storyjesse has quit IRC
12:21:15 *** rubdos has quit IRC
12:31:42 *** himaxx has joined #gnucash
12:48:26 *** himaxx has quit IRC
12:53:01 *** ErKa has joined #gnucash
14:01:19 *** ErKa has quit IRC
14:34:48 *** Elrond has joined #gnucash
14:38:08 <Elrond> My google-skills seem to be broken today. I want to have a complete (indented, if possible) listing of all accounts and the totals for a given period. I can do that a bit using the Transaction report and hiding all columns for the individual transactions, but that seems like a workaround. Any hints?
14:44:50 *** fabior has quit IRC
14:47:41 *** fell__ has quit IRC
14:48:41 *** fell__ has joined #gnucash
14:53:39 *** nomeata has joined #gnucash
15:02:08 *** rubdos has joined #gnucash
15:24:34 *** rubdos has quit IRC
15:28:39 <jralls> Elrond: What sort of "totals" do you mean? Are you looking for cash flow?
15:36:05 *** cigarshark has joined #gnucash
15:39:28 <Elrond> jralls - For each account: One number, the sum of all splits in that account for the given time period.
15:40:42 <Elrond> jralls: The Account tree has an optional column "Total (Period)" which basicly does what I want. Just I would prefer to have this in a report and be able to change the period per report.
15:40:47 <jralls> Elrond: That's meaningful only for Income and Expense accounts.
15:41:31 <Elrond> jralls: It's meaningful to me on other accounts too. It gives the final change on that account.
15:43:26 <jralls> Elrond: So you're looking for cash flow broken out by individual asset, liability, and equity accounts?
15:45:09 <Elrond> jralls: Maybe. "cash flow" sounds like "I want to know where money for my assets came from / went to". I don't want to know that in that report. I just want to know the sum.
15:47:24 <jralls> Elrond: Right. I don't think there's a canned report for that. Your transaction report work-around is probably the closest.
15:49:49 *** himaxx has joined #gnucash
15:51:29 <Elrond> jralls: Okay. Is it worth filing a wishlist bug for this?
15:53:50 <jralls> Elrond: Can't do any harm as long as there isn't one already.
15:55:02 <Elrond> jralls: Okay. I don't promise writing it up soonish. I have plenty of other bugs/patches to file on other projects first.
15:56:03 <jralls> Elrond: That's OK, I wouldn't promise that it would get acted on any time soon, either. The currently active devs have other priorities.
15:56:48 <Elrond> jralls - Just out of curiosity: What are those current priorities?
15:58:50 <jralls> Elrond: http://wiki.gnucash.org/wiki/Roadmap
16:00:11 <jralls> Elrond: No one's likely to write new reports until the report system is replaced. It's just too much of a PITA.
16:00:49 <Elrond> jralls: Ohh, okay.
16:07:44 <Elrond> Ahh, seeing python on the reports listed. Yeah. I wrote some personal python-gnucash tools. :-)
16:14:21 <jralls> Elrond: The bigger deal will be SQL instead of QOFQuery. An option for you would be to use a SQL backend and make your report in SQL.
16:15:13 <Elrond> jralls: I could create my report using python-gnucash, right.
16:16:43 <Elrond> I just looked at the source of the main transaction report. I considered stripping it down to my workaround edition and pimping it with some things from other reports. But 1500 lines of scheme raised E_WAY_TOO_MUCH_SCHEME on me. ;o)
16:17:44 <jralls> Elrond: That too, but it would be easier with naked SQL directly querying the DB. In Gnucash-python you'd have to deal with QOFQuery to find your records, then parse the results, compute the totals, and format the output.
16:19:40 <Elrond> jralls: I would probably be dumb and just iterate over all transactions and filter/sum away. ;) I already did that for some of my personal analysis tools. ;)
16:20:23 <jralls> Elrond: I guess that would be easier in the short term than learning SQL if you don't already know it.
16:21:21 <Elrond> I know sql somewhat. Would probebly end up in me creating sqlalchemy-models for gnucash. Not to mention my current gnucash files are xml files.
16:26:53 <jralls> Elrond: The last is easy to fix, just save as and change the backend to SQLite. You could reopen the XML file for continuing to work while you play with the SQL.
16:28:03 <Elrond> jralls: Yeah. Is the sql schema stable? Las time I looked at the sqlite things, I think, I missed some things.
16:33:37 <jralls> I'm not familiar with sqlalchemy, but the basic query would just be something like "select a.name, sum(s.total) from accounts a and splits s and transactions t where s.account_guid = a.guid and s.tx_guid = t.guid and t.post_date > 2015-07-01 and t.post_date < 2015-08-01"
16:34:20 <jralls> That doesn't include the self-join on accounts to sort out the hierarchy.
16:34:54 *** ErKa has joined #gnucash
16:37:13 <jralls> Oops, s.total doesn't exist. SQL math on our rationals (s.value_num and s.value_denom) can be a bit tricky, but sum(s.value_num / s.value_denom) would probably be close enough for most purposes.
17:11:30 <Elrond> tihi. :)
17:11:44 <Elrond> Thanks anyway and good night!
17:11:49 *** Elrond has left #gnucash
17:12:07 *** mlncn has quit IRC
17:16:32 *** mlncn has joined #gnucash
17:23:25 *** mlncn has quit IRC
17:34:35 *** cigarshark has quit IRC
17:47:49 *** nomeata has quit IRC
18:52:50 *** ErKa has quit IRC
18:59:52 *** puck has joined #gnucash
22:48:37 *** storyjesse has joined #gnucash
23:24:33 *** bozonius has quit IRC