2007-07-28 GnuCash IRC logs
00:03:00 <jsled> lol. It's the #gnucash motto: http://xkcd.com/c293.html
00:13:56 <nDuff> hrm. not doing the huge log file thing again on a restart, but also not working properly. And throwing an error: "Adding client to server's list failed, CORBA error: IDL:omg.org/CORBA/COMM_FAILURE:1.0"
00:14:18 * nDuff curses the circumstances that conspire to keep his home machine win32.
00:14:50 <jsled> well, it works great on 'nix ... so feel free to switch over. ;)
00:15:30 <nDuff> jsled: yeah, I know; I was using gnucash on linux years ago. (not sure how many years, but think it was 1.2-series code at the time)
00:15:43 <jsled> multi-gigibyte is unusual; if you look at some of the lines, are they ... repetitive ... in any way?
00:15:54 <nDuff> jsled: ...but the wifely one wants her Sims, and The Sims does funky things that WINE says they'll never support.
00:16:12 <jsled> There's options to dump huge amount of detail to the tracefile, but they're obviously not on by default.
00:16:33 <nDuff> jsled: don't know. killed the file with the expectation that it'd be easily reproducible, and now it isn't.
00:16:58 <nDuff> right now I'm following up on the CORBA thing; seems to be a relevant ML thread at https://lists.gnucash.org/pipermail/gnucash-devel/2006-October/018699.html
00:17:07 <jsled> And/or. http://wiki.gnucash.org/wiki/Windows
00:17:26 <jsled> (http://wiki.gnucash.org/wiki/Windows#GConf.2FORBit_COMM_FAILURE in particular)
00:18:11 <nDuff> yup, found it.
00:22:11 <nDuff> the symptoms match perfectly; unfortunately, killing the processes and the lock file doesn't appear to clear the issue.
00:23:23 <jsled> :( Sorry ... I'm not a windows hacker. :/
00:23:37 <nDuff> completely understood; I'm not either if I can avoid it.
00:23:57 <nDuff> anyhow, there's a fair bit of beef in the ORBit2 bug, so I can try following up there.
00:24:05 * nDuff wanders off to dinner for a few minutes.
00:24:14 <jsled> nDuff: take care.
00:50:53 <nDuff> thankee.
00:51:26 * nDuff rebooting now -- downgrading the ORBit libraries didn't work, and it's the all-purpose fix here on Windows! (blerg)
00:52:22 *** nDuff has quit IRC
01:24:51 <blahdeblah> Hi. When i do a transaction report and exclude transactions matching certain accounts, it excludes the entire transaction even if it is a split transaction with some splits that are relevant to the report. Is there a way i can work around this (e.g. different report, choosing options)?
01:30:46 <blahdeblah> And following on from that, i'd really like to see the data in the split, not just report on the relevant total.
01:47:43 *** kielein has joined #gnucash
02:23:40 *** Jaran has quit IRC
02:34:57 *** ErKa has joined #gnucash
03:07:38 *** kielein has quit IRC
03:26:19 *** ErKa has quit IRC
04:41:43 *** Jaran|zZzZZz has joined #gnucash
04:51:50 *** palatin has joined #gnucash
09:07:08 *** ErKa has joined #gnucash
09:44:04 *** cortana has quit IRC
09:51:17 *** cortana has joined #gnucash
10:17:47 *** Bombadil has joined #gnucash
10:18:12 <Bombadil> what's the current state of the SQL backend?
10:25:35 <Bombadil> ah, I just found #90375
10:25:43 <Bombadil> but is there anything new?
10:26:08 <Bombadil> please answer even if I'll be gone. I will read the logs...
10:30:59 *** warlord-afk is now known as warlord
10:31:11 <warlord> Bombadil: the gda-dev backend is under development, but reallly slow
10:32:08 <Bombadil> what's gda?
10:32:15 * Bombadil is googeling
10:33:06 <Bombadil> I see
10:37:00 <Bombadil> I fear it is (and ever will be) doomed to be slow by gda
10:39:07 <Bombadil> ... but anyway: better than no SQL :-)
10:40:24 <warlord> what do you mean, doomed to be slow by dga?
10:40:25 <warlord> gda?
10:41:16 <warlord> The slowness is the rate of development.
10:41:32 <Bombadil> oh
10:42:06 <warlord> (unless there's some other slowness of which you are aware?)
10:42:06 <Bombadil> probably I misunderstood "slow" here
10:42:28 <Bombadil> I thought about data access using gda
10:43:45 <warlord> Why would that be slow?
10:43:59 *** blahdeblah has quit IRC
10:44:28 *** blahdeblah has joined #gnucash
10:44:30 <Bombadil> the major goal of gda seems to be to provide a unified interface
10:45:42 <Bombadil> but I don't know any details, so don't worry...
10:46:02 <warlord> Okay...
10:46:17 <warlord> Just making sure you didn't have some insider information.
10:46:43 <Bombadil> yes, I don't have any
10:47:30 <warlord> blahdeblah: I think it depends on the flags you use. there are tons of them. But in particular there's a flag for 'any split matches' and one for 'all splits match'.
10:47:32 <Bombadil> I were just suggesting arround and looking for reasons for "slowness"
10:47:54 <warlord> Oh, the current bitrotted PG backend is slow, but that has nothing to do with GDA
10:48:38 <Bombadil> some time ago I used that, but - yea - it's bitrotted
10:48:56 <warlord> yep. Last time it was really working was like 1.6.
10:49:08 <Bombadil> I were using it with 1.8.x
10:49:53 <Bombadil> but it didn't convice me in that state, so I switched back to usual files
10:50:24 <warlord> Yeah, and nowadays it just doesnt work at all.
10:51:25 <warlord> E.g., there's no way to enter a postgres:// URL.
10:53:41 <Bombadil> The main reason why a SQL backend would be so valuable is because I want to have the possibility to add transactions without using a GUI
10:54:30 <warlord> You can't do that even with PG.
10:54:38 <warlord> And that wont be supported with GDA, either.
10:54:44 <warlord> You might want to look into CashUtil.
10:54:53 <Bombadil> I read about that
10:54:54 <warlord> (a command-line data entry program)
10:55:01 <warlord> But that's not supported by us..
10:55:12 <Bombadil> but I assume it's not up to date at the moment, thus unusable
10:55:19 <warlord> I have no idea.
10:55:23 <warlord> it's not our project.
10:55:31 <Bombadil> sure
10:56:32 <Bombadil> but maybe you could think about giving users an "official" way of adding transactions without using a GUI...
10:56:40 <Bombadil> ... would be quite handy
10:58:20 <warlord> honestly, i'd rather reduce the number of bugs by about two orders of magnitude first. Even reducing by ONE order of magnitude would be good.
10:58:26 <Bombadil> that's just an explanation why I asked for the state of SQL support
10:58:29 <warlord> We dont have enough developers to do that
10:59:00 <warlord> Oh, I understand. I'm just letting you know that that's not supported, so if you DO do that and it destroys your data in subtle ways, it's not our fault ;)
10:59:27 <Bombadil> allright ;)
11:06:08 <warlord> anyways, gotta run. have a great day
11:06:10 *** warlord is now known as warlord-afk
11:07:18 *** Bombadil has quit IRC
11:32:26 *** mjoseph has quit IRC
11:34:25 *** mjoseph has joined #gnucash
11:51:47 *** gunnicom| has joined #gnucash
12:00:58 *** gunnicom_ has quit IRC
12:57:41 *** dv_ has quit IRC
13:46:01 *** palatin has quit IRC
13:52:56 *** phil has joined #gnucash
13:53:16 <phil> How do I get quotes for shares Yahoo knows as LSE:THUS.L?
13:53:27 *** warlord-afk is now known as warlord
13:54:30 <warlord> phil: make sure the id is correct? It might be case-dependent.
13:54:31 <phil> I can't figure out how it can be done... running 2.0.5
13:54:46 <phil> It seems to be entirely UPPER
13:55:53 <phil> It's irretrievable in any case, it seems
13:56:35 <phil> I just can't see how it can be done.
13:56:39 <phil> With an older version I could
13:56:52 <warlord> well, you can test it with gnc-fq-dump
13:57:05 <warlord> an older version of...???
13:57:07 <warlord> gnucash?
13:57:09 <phil> gnc-fq-dump?
13:57:19 <phil> Yes, an older version of gnucahs
13:57:21 <phil> gnucash
13:57:29 <warlord> The issue is more F::Q
13:58:16 <phil> Hmmm...
13:58:32 <phil> If I do gnc-fq-dump yahoo THUS.L it shows up
13:59:04 <warlord> Well, there you go. Use that.
13:59:23 <phil> ,,, as it does with europe THUS.L
13:59:30 <phil> Yes, but how do I "use" it?
14:00:02 <phil> What Type is it?
14:00:22 <warlord> Type?
14:00:40 <phil> As in the drop-down - AMEX, EUREX...
14:00:46 <warlord> doesnt matter.
14:01:34 <phil> Now trying to get quotes
14:01:58 <phil> Unable to retrieve quotes for these items: EUREX:THUS.L
14:02:15 <warlord> What's in gnucash.trace?
14:04:46 <phil> Many Error: xaccAccountTypesCompatibleWith(): bad account type: -1
14:05:36 <warlord> Umm..... this is a 2.2 file pulled back into 2.0
14:05:40 <warlord> ?
14:05:50 <phil> No - it's a 2.0 file
14:06:43 <warlord> You've never used 2.1 or 2.2?
14:06:50 <warlord> account type -1 is broken.
14:06:57 <warlord> Means you have a damaged data file.
14:07:05 <phil> Never used 2.1
14:07:11 <phil> (nor 2.2)
14:07:23 <phil> OK - what's the magic command to mend it?
14:07:45 <warlord> And if gnc-fq-dump works, I have no idea why gnucash wouldnt
14:08:27 <warlord> magic command to mend what? the account type -1? I have no idea where that's even coming from.
14:09:16 <phil> This damaged data file
14:10:03 <warlord> Well, I have no idea what even caused it..
14:10:12 <warlord> Maybe if you track down what's broken in your data file..
14:10:36 <phil> gnucash caused it itself. I don't see how I can track down anything
14:11:17 <warlord> Well, maybe it did, I've never heard of this happenig to anyone EXCEPT in a 2.1/2 -> 2.0 backwards mobility.
14:11:27 <warlord> Gnucash 2.0 wont create a 'type -1'
14:11:47 <phil> How do I go about chasing it?
14:11:48 <warlord> If you could point out the content of your datafile that isn't parsed, maybe i can help track it down, but I can't divine the problem.
14:12:06 <warlord> Piecemeal? Make a copy of your data file and start removing pieces.
14:12:12 <phil> I am sure that there is no such content
14:13:28 <warlord> well, the -1 is coming from somewhere
14:13:31 <phil> Merely loading my datafile causes no errors
14:14:17 <warlord> now you're saying two different things..
14:14:58 <phil> You told me my datafile was corrupt. I am asserting that if it is, it is in a way which does not show up
14:15:52 <warlord> You said you got this: <phil> Many Error: xaccAccountTypesCompatibleWith(): bad account type: -1
14:16:06 <warlord> when does that happen?
14:17:23 *** ErKa has quit IRC
14:18:02 <phil> I suspect (and will now try to prove) it's when I set up a new Security
14:18:14 <warlord> Huh
14:18:43 <phil> Well, it's set up OK
14:18:51 <phil> It must be when I try to get a price
14:19:34 <phil> Hmmmm! For some inexplicable reason, it has now started to work
14:20:31 <warlord> Heheh!
14:26:49 <phil> It now tells me I have GBP 13.58 in the company
14:28:18 <phil> I am sure I have some European cents in a wallet somewhere
14:29:17 <Sathamoth> it's such a great feeling to reconcile all checking and credit card accounts and see that they actually match the reality without any adjustments :]
14:29:43 <Sathamoth> maybe I should get out more :)
15:29:50 *** jakin has joined #gnucash
15:35:10 *** nowhere_man has quit IRC
15:51:10 *** warlord is now known as warlord-afk
16:38:05 *** lasindi has quit IRC
17:33:16 <blahdeblah> warlord-afk: Re: 'any split matches' vs. 'all splits match' - i can't find any reference to that in the reporting options. (I'm using GC 2.0.5 (r15617) - is it a new feature?)
17:59:26 *** Esaj has joined #gnucash
18:33:04 *** estr4ng3d has joined #gnucash
18:38:48 <estr4ng3d> I want to see how much my expenses are during a certain period. I could set a filter to show transactions from date X to date Y, but thats only possible on subaccounts. How can I get the sum at the parent account level?
18:56:01 *** phil has quit IRC
19:21:47 *** ozzloy has joined #gnucash
19:38:29 *** gunnicom| has quit IRC
19:41:06 *** digitect has joined #gnucash
20:10:16 *** digitect has left #gnucash
21:31:15 *** lasindi has joined #gnucash
21:43:43 *** lasindi_ has joined #gnucash
21:49:36 *** lasindi has quit IRC
22:49:20 *** lasindi_ has quit IRC
22:53:23 *** Esaj has quit IRC
23:10:56 *** jakin has quit IRC