2008-05-11 GnuCash IRC logs
00:05:31 *** |gunni| has quit IRC
01:14:02 *** IanL has joined #gnucash
01:17:57 *** warlord-afk is now known as warlord
01:18:49 <warlord> @tell andi5 no... that line is correct. it's the 'TRUE' vs. 'FALSE' that matters.
01:18:49 <gncbot> warlord: The operation succeeded.
01:30:33 *** warlord is now known as warlord-afk
02:59:27 *** IanL has quit IRC
04:41:24 *** kling0n has joined #gnucash
05:10:49 *** cortana has joined #gnucash
05:17:05 *** _McLANE_ has joined #gnucash
05:26:05 *** kling0n has quit IRC
05:26:43 *** ErKa has joined #gnucash
05:28:27 *** kling0n has joined #gnucash
05:34:15 *** kielein has joined #gnucash
05:36:57 *** cortana has quit IRC
05:39:56 *** cortana has joined #gnucash
05:43:19 *** _McLANE_ has quit IRC
06:01:35 *** kling0n has quit IRC
06:02:01 *** kielein has quit IRC
06:04:49 *** kielein has joined #gnucash
07:01:28 *** sirio has quit IRC
07:05:24 *** sirio has joined #gnucash
10:27:14 *** dbreiser has joined #gnucash
10:28:03 <dbreiser> re the missing transactions in ofx streams, I'm pretty sure it's a bug in the matcher code
10:28:14 *** warlord-afk is now known as warlord
10:28:15 <warlord> oh?
10:28:52 <dbreiser> if you have a transaction on 5/10 for 55.67 and another on 5/11 for 54.80, the import matcher will only move one of them to the register
10:29:13 <dbreiser> even though both have truly unique transaction id's
10:29:30 <warlord> Huh! That's very weird.
10:29:55 <dbreiser> I don't think gnucash is storing the unique ID until after the transactions are matched
10:30:32 <dbreiser> the amounts and dates are both within the fuzz factor allowed, and it results in losing some transactions
10:30:57 <dbreiser> I think I have a transaction pair that I can show this on an initially empty gnucash file
10:31:24 <dbreiser> well, the pair of transactions plus a stub ofx file
10:31:25 <warlord> I'm wondering if it does a bad thing -- for each transaction { compare to gnc trasnactions; if ok, add to gnc txn }
10:32:33 <dbreiser> could be. I first noticed it when my wife would take the same amount at the cash machine on consecutive days.
10:32:39 <warlord> instead of: for each txn { compare to gnc txns; if not ok; drop } for each txn { add to register }
10:34:55 <dbreiser> but with posting dates varying, you have to be careful you match the right one of similar transactions
10:35:38 <dbreiser> I think matching speed might have been preferred over completeness of search at some point...
10:36:01 <warlord> But it shouldn't matter.. No "to-be-imported" txn should match another "to-be-imported" txn.
10:36:41 <dbreiser> does the matcher inspect all non-matched existing txns?
10:37:19 <warlord> My guess is that it's not keeping the 'to-be-imported' txns separate from the 'existing' txns.
10:37:52 <dbreiser> I'm thinking if the 54.80 transaction above gets matched to the 55.67 transaction in the register, when the 55.67 txn is next in the ofx stream, it'll have to be matched wrong or not at all
10:39:18 <dbreiser> That wouldn't be the cause of the behavior I'm seeing, more like it is keeping them separate and 2 ofx txns can match the same register txn, so the matcher keeps the last match
10:40:17 <dbreiser> I think the matcher needs something like a tentative match list, where exact amount matches trump fuzzy matches
10:41:07 <dbreiser> and unique ID txns can't be thrown out
10:41:44 <warlord> IMHO the importer ties to-be-imported txns to the register too soon.
10:42:35 <dbreiser> hmm. I guess you're right. that could cause the problem too.
10:44:03 <dbreiser> If I ever learn enough C to create code instead of muck with existing stuff, the matcher will be on my list
10:45:05 <warlord> hehehe.
10:45:44 <dbreiser> maybe we can nudge Charles in that direction once he's happy with qif imports
10:46:21 <dbreiser> gotta go wax a car before the sun moves past the house peak... bbl
10:46:38 <warlord> ok.
11:09:56 *** _McLANE_ has joined #gnucash
11:30:49 *** warlord is now known as warlord-slow
11:50:42 *** jcreigh has quit IRC
12:36:29 *** andi5 has joined #gnucash
12:36:30 *** gncbot sets mode: +o andi5
12:36:51 <andi5> warlord-slow: ping
12:42:10 *** sjc has joined #gnucash
12:46:38 *** warlord-slow is now known as warlord
12:46:40 <warlord> andi5: pong
12:47:00 <andi5> not very slow :)
12:47:35 <andi5> did you see r17149? ... i wonder whether you saw the same
12:48:19 <warlord> I saw. Didn't try it.
12:48:36 <andi5> ok
12:50:34 *** |gunni| has joined #gnucash
12:50:55 <warlord> Did you try to repoduce the problem?
12:51:34 <andi5> actually, i cannot see why the code does not select the reconciled account on both sides for you...
12:51:34 <warlord> (just wondering)
12:51:52 <warlord> Well, the 'far' side *IS* the reconciled account, but that's what it's supposed to do.
12:52:53 <andi5> well, i reproduced the steps you wrote yesterday, and the quickfilling code selected the other account on the desensibilized/grey side
12:53:02 *** cortana has quit IRC
12:53:38 <warlord> Sorry, I dont understand what you mean?
12:53:50 <andi5> i think i do not understand that... if the quickfilling happens on the reconciled account and a two-split txn is matched, then the "other account" should not be the reconciled account, right?
12:53:57 <andi5> *g*
12:54:22 <warlord> ???
12:54:56 <warlord> All i know is that when the dialog first comes up it has the correct two accounts, but then the selected account CHANGES after you quickfill the Description.
12:55:13 <warlord> (in the CC case it's the From account).
12:55:16 <warlord> Let me try your change.
12:55:23 <andi5> one of the two sides is grey for you, right?
12:55:31 <warlord> dunno. Don't have it up
12:56:31 <warlord> no, neither is grey when the window comes up.
12:56:52 <andi5> huh?
12:57:45 <andi5> we are talking about the transfer dialog with the title "CC account - Interest Charge", right?
12:57:52 <warlord> No........
12:57:56 <andi5> hmpf
12:58:32 <warlord> This is the payment,not the interest.
12:59:29 <warlord> The title is "Transfer Funds"
12:59:35 *** _gunni_ has quit IRC
12:59:39 <andi5> ok... (i do not have a cc ;-))
12:59:52 <andi5> i hope my commit is still valid :)
13:00:11 <andi5> let me retry
13:00:49 <warlord> I'm retrying.. Keep in mind that all those calls all use the same xfer dialog.
13:02:13 <andi5> great... it should work now, fully
13:02:20 <andi5> :-D
13:02:28 <warlord> I'll try in a minute once this build finishes.
13:04:53 <warlord> YAY!
13:05:01 <warlord> That fixed it for CCs
13:07:13 <andi5> so i assume, you were talking about 3 different things (i messed them up as well):
13:07:58 <andi5> a) auto-interest transfers happening before reconciliation... one side is grey, but both point to the reconciled account (please correct me if i am talking nonsense)
13:08:25 <andi5> b) cc payments should point to the last used accounts
13:08:53 <warlord> a) I dont know if there was a problem there but it certainly could have had one.
13:08:59 <warlord> b) yes. and that is now fixed.
13:09:11 <andi5> c) after quickfilling in cc payments, the wrong side of the transfer is changed... well, merges with b, actually :)
13:09:42 <andi5> i think b) worked before already... a) is probably a bug, as the source code already includes XXX Fixmes
13:13:16 <warlord> actually, b) already worked. it's c) that's the problem.
13:13:21 <warlord> but that's now fixed, too.
13:13:32 <andi5> warlord: any objections to http://pastebin.ca/1014906 which is supposed to fix http://bugzilla.gnome.org/show_bug.cgi?id=489502
13:14:20 <andi5> well, if there already is something that works for a), the work for a) could be feasible for me :)
13:14:36 <andi5> arrgh, s/a/b/ (without g)
13:15:31 <warlord> andi5: I'm afraid I dontknow. I've not experienced a) so I dont know.
13:15:48 <warlord> (I dont use that functionality)
13:16:10 <andi5> well, i do not even use credit cards :)
13:16:16 <warlord> As for the patch... I dont have the brainpower right now to audit that.
13:16:24 <warlord> (sorry)
13:16:27 <andi5> no problem... just take a look at the business part
13:16:32 <warlord> Ok
13:17:00 <andi5> thanks =)
13:17:33 <warlord> bbl
13:17:34 *** warlord is now known as warlord-slow
13:25:06 *** cortana has joined #gnucash
13:30:51 *** andi5 has quit IRC
13:57:00 *** pestilence has quit IRC
14:02:57 *** qkquest has joined #gnucash
14:03:29 <qkquest> hey all... question that you've all heard over 1000 times..
14:03:52 <qkquest> any way for me to convert a qxf to qif barring text editor
14:06:14 <qkquest> or I suppose qxf to csv would be something
14:09:33 <qkquest> or qxf to txf? google returns a big fail
14:22:54 *** twunder has joined #gnucash
14:37:30 *** qkquest has quit IRC
14:38:17 *** qkquest has joined #gnucash
15:00:24 *** twunder has quit IRC
15:17:49 *** twunder has joined #gnucash
15:43:26 *** warlord-slow is now known as warlord
15:43:58 <warlord> qkquest: GnuCash imports OFX/QFX just fine. Why do you need to translate to QIF?
15:44:21 <warlord> (you probably didn't enable OFX support on ./configure)
15:45:37 *** warlord is now known as warlord-slow
15:49:13 *** qkquest has quit IRC
16:32:14 *** twunder has quit IRC
16:35:22 *** philippm has joined #gnucash
16:37:35 <philippm> Hi. Can anybody please help me with the following: I need to record payment a bill (issued in British Pounds) to be paid to Checking Account in Euros. However, when I process the payment the amount on the Euro account is blank (0). Any ideas?
16:42:39 *** philippm has left #gnucash
16:44:57 *** philippm has joined #gnucash
16:47:00 *** philippm has joined #gnucash
16:55:05 *** andi5 has joined #gnucash
16:55:05 *** gncbot sets mode: +o andi5
16:56:06 *** kielein has quit IRC
17:15:29 *** cortana has quit IRC
17:24:28 *** cortana has joined #gnucash
17:28:09 *** philippm has quit IRC
17:39:22 *** ErKa has quit IRC
17:41:19 *** massis has joined #gnucash
17:42:07 <massis> I have some questions about creating a report, can someone help me??
17:42:37 <andi5> massis: see the topic "Don't meta-ask", just ask :)
17:46:01 <massis> I want to create a report were the expenses are shown per month, but I have no clue how to do this..
17:51:03 <andi5> i suppose the "expense barchart" report is not what you want?
17:52:02 <massis> no because they show for the role time, i need a report expense / month to see how much i´m spending on each category..
17:55:42 *** warlord-slow is now known as warlord
17:56:42 <warlord> massis: you'll need to run the P&L multiple times, or you'll need to modify the P&L report to do what you want. (or use a multi-column report to do this)
17:57:49 <massis> sorry but no clue on what you´re talking, I´m not an expert on programming...
17:58:29 <massis> there´s some way to ask that they develop something like that, I used a Exccell table to do that but i saw the programm and like it..
18:00:49 <warlord> You have three options:
18:01:01 <warlord> 1) Run the P&L Report multiple times, one for each month.
18:01:11 <warlord> 2) Use the Multi-column report to do #1
18:01:23 <warlord> 3) modify the P&L report to set up a table of multiple periods.
18:01:55 *** massis has quit IRC
18:02:40 <andi5> 4) leave
18:03:12 <warlord> There's that, too, I guess.
18:03:52 *** warlord is now known as warlord-slow
18:39:37 *** |McLANE| has joined #gnucash
18:39:38 *** _McLANE_ has quit IRC
19:33:45 *** twunder has joined #gnucash
19:57:52 <warlord-slow> andi5: That patch looks correct.
20:03:13 <andi5> thanks :)
20:24:36 *** sjc has quit IRC
20:28:48 *** cortana has quit IRC
20:29:20 *** twunder has quit IRC
22:24:06 *** andi5 has quit IRC
22:27:11 *** localhost has joined #gnucash
22:57:55 *** _McLANE_ has joined #gnucash
23:06:46 *** |McLANE| has quit IRC
23:49:00 *** warlord-slow is now known as warlord-afk