2008-07-05 GnuCash IRC logs
00:24:37 *** caldr has left #gnucash
00:31:44 *** JimRaehl has left #gnucash
00:38:23 *** JimRaehl has joined #gnucash
01:35:35 *** localhost has joined #gnucash
01:40:00 *** localhost1 has quit IRC
02:29:21 *** echinos has quit IRC
02:32:06 *** echinos has joined #gnucash
03:01:28 *** rkirti has joined #gnucash
03:40:02 *** echinos_ has joined #gnucash
03:40:03 *** echinos has quit IRC
03:46:48 *** echinos has joined #gnucash
03:47:01 *** echinos_ has quit IRC
04:41:59 *** ErKa has joined #gnucash
04:45:05 *** cortana has joined #gnucash
05:12:07 *** cortana has quit IRC
05:15:14 *** cortana has joined #gnucash
05:24:05 *** ErKa has quit IRC
05:54:30 *** McLANE has joined #gnucash
06:28:41 *** nomeata has joined #gnucash
07:14:23 *** cortana has quit IRC
07:17:06 *** cortana has joined #gnucash
07:17:30 *** Rolf has quit IRC
07:21:44 *** McLANE has quit IRC
07:26:43 *** User has joined #gnucash
07:35:00 *** rkirti has quit IRC
07:35:53 <User> hello
07:36:08 <User> I have one question about using gnucash
07:39:05 *** endy_c has joined #gnucash
07:39:18 <User> ..
07:41:33 *** User has quit IRC
07:48:07 *** endy_c has left #gnucash
08:16:39 *** User has joined #gnucash
08:16:49 <User> anybody online?
08:27:08 *** User has left #gnucash
08:53:43 *** JimRaehl has left #gnucash
09:01:57 *** JimRaehl has joined #gnucash
09:01:59 *** JimRaehl has left #gnucash
09:07:10 *** warlord-afk is now known as warlord
09:47:07 *** JimRaehl has joined #gnucash
09:54:15 *** McLANE has joined #gnucash
09:58:22 *** Rolf has joined #gnucash
10:11:13 *** warlord is now known as warlord-afk
10:57:43 *** _gunni_ has joined #gnucash
10:58:14 *** refdoc has joined #gnucash
11:06:31 *** |gunni| has quit IRC
11:43:16 *** refdoc has quit IRC
11:54:27 *** rkirti has joined #gnucash
12:17:25 *** warlord-afk is now known as warlord
12:30:19 * Sememmon pokes warlord
12:56:11 *** rkirti has quit IRC
12:56:52 *** rkirti has joined #gnucash
13:05:21 *** kirtibr has joined #gnucash
13:05:43 *** localhost has quit IRC
13:06:02 *** rkirti has quit IRC
13:07:22 *** kirtibr is now known as rkirti
13:08:48 *** localhost has joined #gnucash
13:34:32 *** andrewsw has joined #gnucash
13:34:32 *** gncbot sets mode: +o andrewsw
13:34:45 *** andrewsw is now known as andrewsw-afk
13:35:28 *** andrewsw-afk is now known as andrewsw
13:39:07 *** andrewsw is now known as andrewsw-afk
13:45:50 *** andrewsw-afk has left #gnucash
14:56:18 *** cortana has quit IRC
15:03:16 *** aggieryan has joined #gnucash
15:03:23 *** sjc has joined #gnucash
15:04:34 <aggieryan> I would like to create a custom report that would scan transactions and find a particular keyword and report those transactions containing the keyword. Can someone tell me if this is possible, and if so, how to do it? I'm an engineer, but I'm not a Scheme expert and am not familiar with the codebase.
15:08:28 <warlord> Sememmon: AFAIK there's no way to see projected balances from SXes, short of getting them to pre-"fire" into your CoA early.
15:08:41 <warlord> If you think you've found a bug, file a bug report. Supply a test data file too if you can.
15:09:10 <warlord> aggieryan: Yes, that would be doable.
15:09:35 <warlord> You'd need to generate a query that looks for transactions with that text entry. and then display them.
15:10:09 <warlord> OR.... You could do Edit -> Find Transactions and enter in your search criteria, and then run Reports -> Register Report
15:12:15 <aggieryan> warlord: thanks, I'm going to try this now
15:14:59 <aggieryan> okay, I tried doing this, but the register report is displaying all transactions for a certain period and not just those transactions meeting my criteria
15:15:57 <aggieryan> let's say I searched for "@emily" and then went to Reports -> Register Report. It displays transactions not having "@emily" in them.
15:18:26 <aggieryan> Please let me know if I'm not doing this correctly
15:19:07 <aggieryan> I would also be interested in what it takes to write a query, but I'm not finding any good information via Google right now.
15:23:03 *** andi5 has joined #gnucash
15:23:03 *** gncbot sets mode: +o andi5
15:24:46 <aggieryan> warlord: btw, I'm running 2.2.5 on Win32
15:25:34 <warlord> Did you run the report from the resulting search results page?
15:26:38 <aggieryan> Yes, from the main Accounts tab I did Edit -> Find and then put in "@emily", and it displayed all transactions with that string
15:26:56 <aggieryan> from the Search Results tab I then went to Reports -> Transaction Report
15:27:13 <aggieryan> and it's also displaying transactions now having that string, such as my mortgage payments
15:27:19 <aggieryan> *now = not
15:28:22 <warlord> That's not the report you wanted.
15:28:45 <warlord> It's "Reports -> Account Report"
15:28:50 <warlord> At the bottom of the Report menu
15:29:10 <warlord> (sorry, I said "register" report before.. That's because it's in register.scm
15:32:01 <aggieryan> Okay, I got it. It appears to be working like I want it to!
15:32:11 <aggieryan> nice, it even sums it all up for me
15:32:52 <aggieryan> this is how I am emulating Quicken's ability to report based on "tags"
15:33:24 <aggieryan> it's not entirely useful, but it allows me to put a bit more information into the Notes section and then use it as a keywords section
15:33:58 <warlord> There ya go!
15:34:06 <warlord> Feel free to write up about this on the wiki!
15:34:36 <aggieryan> ok, I didn't know the wiki was open to editing. I'll check that out.
15:38:09 <aggieryan> warlord: I'm assuming you're a maintainer/developer. The Account Report does not seem to really be an account report per se; rather, it looks more like a report based upon the search query in this case. It also might be a good idea to have a report button directly on the search screen (although purists won't like this).
15:39:04 <aggieryan> I guess the idea is that it's displaying those accounts that have the search query.
15:42:06 <warlord> This is true, which is why I keep calling it a Register Report, because it really is a report based on the current Register settings.
16:00:47 *** McLANE has quit IRC
16:24:12 *** McLANE has joined #gnucash
16:37:59 *** jrgenolsen has quit IRC
16:48:45 <andi5> Rolf: ping
16:52:48 <warlord> yow! andi5 -- you're here!
16:52:54 * andi5 is back :-D
16:53:05 <andi5> sort of
16:53:24 <warlord> Welcome back.
16:53:27 <warlord> Have a good holiday?
16:54:52 <andi5> holiday? what is that?
16:55:40 <andi5> i guess it is time to prepare some 2.2.6 release or so?
16:55:52 <warlord> Oh, maybe..
16:58:15 <andi5> so how are you?
16:59:42 <warlord> I am well.. but about to head out shortly to maybe get a camera.
16:59:57 <warlord> you do know that I'm going to be in Frankfurt in a few weeks?
17:00:05 <andi5> buy one for me as well, please :-)
17:00:10 <warlord> hahah
17:00:28 <andi5> yes, i know that... but i guess i will not be able to leave here the following weeks =)
17:00:54 <warlord> Ah well.
17:00:56 <andi5> so you do not visit hamburg again?
17:00:59 <warlord> Anyways, I'll be back in an hour.
17:01:04 <andi5> ok, have fun!
17:01:16 <warlord> Not this trip. I had to cut out a week of holiday time due to timing issues. :)(
17:01:18 <warlord> :(
17:01:24 <andi5> :-(
17:01:24 <warlord> anyways, I'll be back.
17:01:26 *** warlord is now known as warlord-afk
17:27:16 *** jrgenolsen has joined #gnucash
17:42:47 *** rkirti has quit IRC
17:55:38 *** dbreiser has joined #gnucash
17:57:06 <dbreiser> andi5: the aqbanking3 branch seems to always assume I'm collecting data from a checking account, so attempts to get investment account data result in an OFX "Bad request" error for ofxdirectconnect sessions
17:57:34 <andi5> huh...
17:57:38 <andi5> i thought that worked for me
17:57:50 <dbreiser> could be the server
17:58:03 <dbreiser> I'm going to ameritrade, that has no checking accounts
17:58:18 <dbreiser> banks that support investments might handle it better
17:58:21 <andi5> dbreiser: can you start gnucash from gdb?
17:58:29 <andi5> or attach to it?
17:58:44 <dbreiser> I think so, but I'll have to look up the incantation. a moment...
17:59:24 <andi5> hm... it should be as easy as starting up gdb, and then run "attach P", where P is the pid of the gnucash process
18:00:13 <andi5> oh, i suppose the matching is still correct showed when running the online banking setup druid?
18:00:19 <andi5> showed correctly, i mean
18:01:00 <dbreiser> the account matching is correct in the druid
18:02:29 <andi5> that would be a desaster if you accidentally transferred money from the wrong account :-)
18:02:51 <dbreiser> ofx doesn't do transfers yet
18:03:21 <dbreiser> ok, I'm running under ${prefix}/bin/gnucash-env gdb ${prefix}/bin/gnucash-bin
18:03:22 <andi5> yes, but if there is a bug in the new code, then it will affect all types of aqbanking accounts in the same way
18:04:00 <andi5> ok, try to add a breakpoint at gnc_ab_getbalance
18:05:01 <dbreiser> gdb 101 -- since I ran gnucash inside gdb, how do I interrupt it to set a breakpoint?
18:05:12 <andi5> i suppose ctrl-c will interrupt it
18:05:21 <andi5> even on windows this happens now, iirc
18:05:27 <andi5> with a little trick at least =)
18:06:07 <andi5> so ctrl-c ; b gnc_ab_getbalance ; c
18:06:45 <dbreiser> yep. seems to work. I have a breakpoint at line 50 of gnc-ab-getbalance.c
18:07:12 <andi5> did it stop there?
18:09:31 <dbreiser> hmm. fumbling around here. No, it's a normal OFX error trap, not a program stop
18:10:06 <dbreiser> the online banking connection window ends with "Resetting provider queues"
18:10:42 <andi5> hm... but when you clicked on the corresponding menu item, gnucash should have been interrupted at your breakpoint, right?
18:11:11 <andi5> up to that point, no ofx or connection window is active already
18:11:39 <dbreiser> I do Actions/Online actions/Get Transactions... and then enter password
18:11:55 <andi5> hm.... you remember what function i chose? :)
18:12:08 <andi5> i tend to choose the easier functions...
18:12:16 <andi5> yours would be gnc_ab_gettrans, iirc
18:12:27 <dbreiser> I don't think getbalance has ever worked for me
18:12:36 <andi5> oh?
18:12:40 <dbreiser> because libofx hasn't supported it
18:12:42 <andi5> ofx :-D
18:13:07 <dbreiser> yeah :(
18:13:37 <andi5> guess what, all these funny menu items work more or less with hbci :-D
18:14:12 <andi5> so, i am sorry for suggesting the wrong breakpoint
18:14:52 <dbreiser> then I'm guessing I need to bug Martin, who has been quiet lately (not responding to my libchipcard queries, anyway)
18:15:18 <dbreiser> OK, I'm at the breakpoint
18:15:23 <andi5> i would just like to know whether gnucash picks up the correct accounts
18:15:57 <andi5> what does "p (gchar*) xaccAccountGetFullName(gnc_acc)" print out?
18:15:58 <dbreiser> I think it does. I'm pretty sure the error is in construction of the OFX request stream.
18:16:22 <dbreiser> Assets:Investments:Retirement - Dave:Ameritrade
18:16:27 <dbreiser> which is the right account
18:16:39 <andi5> ok, now process ("n") until ab_acc is assigned
18:16:50 <andi5> proceed
18:17:52 <dbreiser> OK, I have the ab_acc assignment statement showing
18:18:07 <andi5> continue until the error block has been skipped
18:18:13 <andi5> do not press c please :)
18:18:54 <dbreiser> next n gives: * 18:18:22 MESSG <gnc.import.aqbanking> gnc_ab_get_ab_account: No AB_ACCOUNT found for UID 108, trying bank code
18:19:15 <andi5> oh
18:19:32 <dbreiser> any chance we're dueling with the old aqbanking data store in ~ ?
18:19:49 <andi5> what does "p AB_Account_GetAccountNumber(ab_acc)" give you?
18:20:20 <dbreiser> my real investment account number
18:20:38 <andi5> the correct one?
18:20:41 <dbreiser> yes
18:20:49 <andi5> ok, blame martin ;-)
18:21:02 <dbreiser> OK. I'll post to aqbanking-devel
18:21:09 <dbreiser> time for dinner
18:21:11 <andi5> thanks =)
18:21:11 <dbreiser> thanks
18:21:14 <andi5> ciao dave
18:22:03 *** motin_0 has joined #gnucash
18:34:54 <andi5> Q: does anyone disagree with http://bugzilla.gnome.org/show_bug.cgi?id=540719 ?
18:56:44 *** andi5 has quit IRC
19:04:41 *** twunder has joined #gnucash
19:30:33 *** twunder has quit IRC
20:05:32 *** cortana has joined #gnucash
20:16:23 *** twunder has joined #gnucash
20:25:28 *** Zoolooc__ has quit IRC
20:26:06 *** McLANE has quit IRC
20:27:21 *** McLANE has joined #gnucash
20:32:18 *** |gunni| has joined #gnucash
20:39:50 *** _gunni_ has quit IRC
20:45:00 *** dbreiser has quit IRC
20:47:26 *** McLANE has quit IRC
21:09:52 *** sjc has quit IRC
21:15:02 *** Lee_Biernbaum has joined #gnucash
21:16:28 *** Lee_Biernbaum is now known as leebier
21:20:57 <leebier> I am having trouble imporing OFX files involving stocks/funds in a Win32 version. The druid crashes Gnucash entirely. I haven't had any problem with the OFX import for bank accounts.
21:21:23 *** nomeata has quit IRC
21:27:17 <leebier> the only error is the typical MS "program encounterd an error" stuff, nothing specific (WinXP)
21:27:41 *** warlord-afk is now known as warlord
21:27:50 <warlord> leebier: what's printed in gnucash.trace?
21:28:25 <warlord> also, what version of gnucash?
21:28:27 <leebier> ah, is there a log file I should be aware of :)
21:28:56 <warlord> leebier: yes...... gnucash.trace. See the Wiki.
21:29:17 <leebier> excellent, 2.2.5 btw
21:29:33 <leebier> i'll check out the trace, i'll be back here then, i'm sure
21:30:09 <warlord> ok
21:30:55 <leebier> this would be the wiki post that says "tell them you're a windows user and can't do it"? \
21:31:38 <warlord> Ummm. no...
21:32:53 <leebier> ah, i'm looking at the wrong trace then?
21:33:34 <warlord> gnucash.trace is the gnucash log file.. not a gdb backtrace.
21:33:35 <leebier> ah, i see it
21:33:36 <leebier> yeah
21:35:28 <leebier> hmm, it's a lengthy file, but i'd been running it for quite a while
21:35:39 <leebier> i'm gonna cause the crash again on a fresh run, see what i can pull out
21:37:17 <leebier> * WARN <qof.engine> [guid_init()] only got 2216 bytes.
21:37:19 <leebier> The identifiers might not be very random.
21:38:02 <leebier> that was a line break in the error, not my editorializing :)
21:42:44 <leebier> warlord: http://pastebin.com/m17b06b0e
21:42:53 <leebier> that is the full file contents
21:46:29 <warlord> That's an ignorable warning
21:47:36 <leebier> that's the only one in the file
21:49:11 <leebier> where's the next place to look?
22:00:40 <warlord> I'm afraid I dont know. Try sending to gnucash-user mailing list?
22:02:00 <leebier> fair enough, that sound slike a sunday project.
22:02:02 <leebier> tahnks warlord
22:07:27 <warlord> you're welcome
22:37:19 *** monolithic has joined #gnucash
22:40:36 <monolithic> Where do I tell gnucash what my actual mortgage monthly payment at?
22:42:42 <warlord> it computes it for you.
22:43:30 <monolithic> warlord, unless I'm entering the wrong values, it's always off by a few dollars.
22:44:08 <warlord> perhaps the interest rate is being truncated, either by you, gnucash, or the bank?
22:45:36 <monolithic> In the mortgage druid, for the amount, I assume it's asking for the current payoff amount?
22:45:49 <warlord> No, it's asking for the original loan amount.
22:46:09 <warlord> Then you can tell it how many payments are left.
22:46:18 <monolithic> Oh, ok.
23:01:06 *** leebier has quit IRC
23:05:43 <Sememmon> warlord: thx =]
23:06:15 <warlord> you're welcome
23:08:15 <monolithic> Argh!!! This is driving me batty! But, I'll eventually get it.
23:08:29 <monolithic> Thanks anyway, warlord.
23:09:07 <warlord> maybe jsled can help -- he wrote the SX code.
23:10:43 <monolithic> My prob is, I've had this mortgage for 9 years now. After year 3, every year the api changes. On top of that, I just started using gnucash, and thought I could just start fresh with this month.
23:11:48 <monolithic> Hate to say it, but MS Money does it nice by asking what your actual monthly payment is, and figureing from there.
23:11:59 <monolithic> Although, I ain't changing back. :)
23:13:22 *** twunder has quit IRC
23:16:46 <warlord> Yeah, when the SX druid was written the guy didn't really understand how mortgages worked.
23:17:09 <warlord> Another issue is that we don't have a "get_account_balance_as_of_date()" function for SX formulas
23:34:08 *** caldr704 has joined #gnucash
23:38:23 <echinos> #part #gnucash
23:38:25 <echinos> oops
23:38:29 *** echinos has left #gnucash