2008-02-04 GnuCash IRC logs
00:41:36 *** warlord is now known as warlord-afk
01:17:51 *** klee has joined #gnucash
02:03:52 *** snavin has quit IRC
02:04:00 *** snavin has joined #gnucash
03:18:14 *** kielein has joined #gnucash
05:10:14 *** andi5 has joined #gnucash
05:10:14 *** gncbot sets mode: +o andi5
05:27:20 *** cortana has quit IRC
05:29:18 *** cortilap has joined #gnucash
07:07:31 *** Dave_is_sexy has quit IRC
07:27:41 *** ErKa has joined #gnucash
07:47:27 *** kielein has quit IRC
07:58:37 *** Mr_Virak has joined #gnucash
07:59:21 <Mr_Virak> Hi people, I am trying to install gnucash 2.2.3 in a windows xp, but it is failing
07:59:26 <Mr_Virak> I get the following error:
07:59:37 <Mr_Virak> Microsoft Visual C ++ Runtime LibraryRuntime ErrorProgram C:/Program Files/gnucash/bin/gnucash-bin.exeThis application has requested the Runtime to terminate it in an unusual way.Peale contact the application's support team for more information.Please
07:59:46 <Mr_Virak> when I try to start it
07:59:55 <Mr_Virak> if I try to uninstall
08:00:03 <Mr_Virak> Error: file corba-ob ject.c:line76 (ORGit_register_ob jref): assertion failed: (ob j->ob ject_key ! = NULL)
08:00:17 <Mr_Virak> anyone know if it is a known bug?
08:01:58 *** snavin has quit IRC
08:11:41 *** warlord-afk is now known as warlord
08:12:17 <warlord> Mr_Virak: http://wiki.gnucash.org/wiki/Windows
08:13:44 <Mr_Virak> the interesting thing is that it was working perfectly on friday
08:13:49 <Mr_Virak> the suddenly it died
08:16:39 <warlord> well.... what changed? Did you install any windows updates? Or try changing the version of gnucash?
08:17:28 *** tjanssen has joined #gnucash
08:23:10 *** luke0512 has joined #gnucash
08:23:21 <luke0512> hello
08:23:33 <luke0512> german or english?
08:24:16 <luke0512> anyone here?
08:25:21 <luke0512> ok...i just try...i need some held for importing csv-file in gnucash
08:26:29 <luke0512> i just do it with a macro on openoffice that works for me but is there perharps another and easier way to get the data from csv to gnu?
08:27:12 <luke0512> maybe there is a tool just like the makro but change the date to mt940
08:27:26 <luke0512> up data to mt940
08:28:57 <luke0512> oh an my girlfriend just use gnucash under windows...no ooffice installed
08:32:05 <Mr_Virak> warlord: actually nothing seemed to happen
08:32:24 <Mr_Virak> I just tried to start gnucash and there was an error
08:32:49 <luke0512> linux or windows?
08:33:13 <Mr_Virak> then I tried to reinstall the lates verion
08:33:22 <Mr_Virak> so it came the bug I emtnioned before
08:33:26 <Mr_Virak> ops
08:33:27 <Mr_Virak> mentioned
08:33:59 <warlord> luke0512: Right now the CSV import is only in trunk, not in a released (2.2) version.
08:34:09 <warlord> Mr_Virak: what do you mean, nothing seemed to happen?
08:34:42 <Mr_Virak> I havent update windows or installed/deinstalled anything in my machine
08:36:48 <luke0512> thnaks warlord, so i just do it with the macro on ooffice and hope that the csv import is implemented in a new release or my bak change to mt940
08:37:33 <warlord> Mr_Virak: So it used to work, but now it doesnt? That would imply SOMETHING changed.
08:37:49 <Mr_Virak> yeah I know
08:37:59 <warlord> luke0512: well, you could use some code to convert the CSV to QIF.
08:38:10 <luke0512> i just have another account in a different bank and they work with mt940 and it works fine ;-D
08:38:15 <Mr_Virak> I also felt the same, But I couldn't find anything exaclty
08:38:21 <Mr_Virak> I was just surfing the net
08:38:39 <luke0512> i don't now how to use code in windows
08:38:51 <luke0512> on linux i just know it
08:39:01 <Mr_Virak> I am going throught the wiki sent before in the bugs section
08:39:07 <warlord> luke0512: yes... mt940 is supported (through AqBanking)
08:39:22 <Mr_Virak> trying to see if something solves my problem in there
08:40:15 <luke0512> i think the easiest way to solve the prob under windows is to install ooffice and use the macro cause it works fine
08:40:37 <luke0512> its a little bit work but it works
08:41:26 <luke0512> warlord, do you know if there is a code for converting from csv to mt940?
08:42:07 <warlord> luke0512: dont think so.. but why would you need to when you can convert to qif?
08:42:46 <luke0512> i think it works much easier...i have tried them today for the first time
08:44:20 <warlord> You think mt940 works easier than QIF? *shrugs* The QIF importer works pretty well.
08:44:25 <warlord> Just.. differently.
08:44:49 *** luke512 has joined #gnucash
08:45:01 *** luke512 has quit IRC
08:45:03 *** luke512 has joined #gnucash
08:45:15 *** luke512 has joined #gnucash
08:46:12 *** luke512 has joined #gnucash
08:46:43 *** luke512 has joined #gnucash
08:47:04 <luke512> re..my router hangs me up
08:48:21 <luke512> while using the macro you have to copy some data, change the file format, import in gnucash an answer some questions
08:48:35 <luke512> mt940 only needs 2 klicks
08:48:43 <luke512> and ready
08:51:11 <warlord> The questions only have to be answered once, and then gnucash remembers them for future runs.
08:51:24 <warlord> (although it will ask you to re-confirm them every time)
08:53:41 <luke512> i just answered them every time...so i think i did something wrong?
08:54:01 *** luke0512 has quit IRC
08:54:32 *** luke512 has quit IRC
08:54:34 *** luke512 has joined #gnucash
08:54:53 <jsled> WTF? http://bugzilla.gnome.org/show_bug.cgi?id=513872
08:55:11 <warlord> So, yes, it's a few more clicks, but not too many more. Even with MT940 you still need to specify the income/expense account for every txn
08:56:23 <warlord> Closed.
08:57:40 <luke512> ok...i just have learn and read the manual more carefully...maybe its getting easier...after doing so
08:57:49 <luke512> +to
08:58:19 <warlord> Maybe.
09:02:09 *** twunder has joined #gnucash
09:09:55 *** donfede has joined #gnucash
09:12:51 *** Mr_Virak has quit IRC
09:45:18 *** olsen has joined #gnucash
09:49:02 <olsen> Yesterday i asked if i could pay invoices through the journal and got the answer no... now i wonder why - does anyone have an explanation? The way it happends now seems very unlogical to me.
09:52:44 <jsled> I think the general form of the explanation is that the register just isn't really setup internally to make the kind of changes needed when paying an invoice. So, warlord decided to make it happen through a specific menu item, which would create all the necessary transactiosn and changes on the books.
09:55:52 <olsen> so You're saying You don't think it's final - more like a temporary solution?
09:56:06 <jsled> no, not at all.
09:56:11 <jsled> Er. No, I'm not saying that.
09:56:19 <olsen> ok
09:56:20 <jsled> In fact, I don't even know how you'd read that in what I said.
09:56:51 <olsen> i didn't directly, i was just hoping for it
09:57:13 <warlord> But at this point in time nobody is working on that level of integration.
09:57:28 <warlord> It IS a wish-list item in bugzilla, but it's several years old.
09:58:54 <olsen> say one hired a programmer to do this kind of integration, would it be a contribution to this project then?
10:00:56 <warlord> Provided it fits within the guidelines of our development, architecture, etc.. sure.
10:01:05 <warlord> Contributed code is always good.
10:02:00 <warlord> The way I was envisioning it working is that the register would send out an event at the appropriate time and the business code would see that event and pop up the appropriate dialog to map the transaction to the proper customer.
10:03:22 <warlord> Some of that work has been done, much hasnt.
10:14:34 *** Lo has joined #gnucash
10:16:50 <Lo> Hi! Iwould like to talk about Bug 105334. Is there some work around? Of course, file from my bank are not correct. So I was thinking about prefitlering them. But change TRNTYPE to XFER is not enough to recognize an interbank transfer... What Should I do?
10:19:09 <warlord> Lo: well, as the bug states, nobody sent in a sample file.
10:19:25 <warlord> it's been 5 years.
10:19:26 *** _gunni_ has joined #gnucash
10:23:35 <Lo> warlord: Yep, but the OFX standard is pretty quiet on that. So if I understand well, What I would like is that split with type XFER and name containing an account number be automatically a transfert. Then, on second account import, He would find the other split with type XFER but opposite sign amount. The problem is that the date would not perfectly match (few days difference).
10:24:07 <warlord> Neither the date NOR the TxnID would match.
10:24:42 *** |gunni| has quit IRC
10:25:46 <Lo> Right. So what ? I want to preparse the file as much as possible as it is transferts between accounts I know. I can even write special markers in the MEMO field...
10:26:25 <Lo> Isn't the TxnID just a split id, not a transfert id?
10:27:39 <warlord> You're asking the wrong person.
10:28:51 <Lo> Ok so I suppose I must wait...
10:29:24 <warlord> I suspect you'd be waiting for a long time. Benoit hasn't been working on libofx much for a while, and it's unclear if the issue is in libofx or gnucash.
10:31:01 <Lo> Well...
10:32:44 <Lo> So I suppose I need to dive into the code and see what I can do! Thank for response.
10:34:06 <Lo> Bu the way, Is there a tutorial on writing plugin (C or Scheme) for GnuCash?
10:34:47 <warlord> Not really, but you dont need to write any new plugins.. You'd just need to modify the existing code.
10:36:30 <Lo> Thanks. See you later ;-)
10:40:18 <warlord> i'll be here
10:55:12 *** ErKa has quit IRC
11:18:07 *** BlackBsd has joined #GnuCash
11:24:57 *** BlackBsd has quit IRC
11:33:19 *** Lo has left #gnucash
12:05:28 *** nomeata has joined #gnucash
12:52:39 *** cortilap has quit IRC
13:03:30 *** nomeata has quit IRC
13:08:15 *** cortana has joined #gnucash
13:08:47 *** twunder has quit IRC
13:09:52 *** twunder has joined #gnucash
13:19:00 *** warlord is now known as warlord-afk
13:34:23 *** cortana has quit IRC
13:47:00 *** Jannick has joined #gnucash
13:47:45 <Jannick> Hi, is it possible to automatically split one-line transactions imported with the on-line banking feature for taxation? Thanks!
13:53:41 *** cortana has joined #gnucash
13:56:27 *** cortana has quit IRC
13:57:47 *** cortana has joined #gnucash
13:58:56 *** cortana has joined #gnucash
14:31:57 *** Jannick has quit IRC
14:32:05 *** warlord-afk is now known as warlord
14:32:23 <warlord> @tell Jannick No, you cannot auto-split online txns.
14:32:23 <gncbot> warlord: The operation succeeded.
14:37:54 *** Jannick has joined #gnucash
14:39:30 <Jannick> Warloard: Is there any workaround?
14:39:30 <gncbot> Jannick: Sent 7 minutes ago: <warlord> No, you cannot auto-split online txns.
14:40:21 <warlord> Hand-enter the transactions first and then mark them as duplicates during the import.
14:40:41 <warlord> No, there's no other workaround. OFX and HBCI dont support split transactions.
14:43:13 <luke512> bye @ all....cu
14:43:47 *** luke512 has left #gnucash
15:08:28 *** Def has joined #gnucash
15:10:02 <Jannick> Warlord: What effect does it have when marking manually entered transactions as duplicates during the import?
15:10:56 <warlord> It means you dont get duplicate txns.
15:12:22 <Jannick> Ok, but then I could import online-transactions and manually add the tax split in the general ledger, couldn't I?
15:13:10 <warlord> Yep
15:13:15 <warlord> You could do it that way, too.
15:13:30 <warlord> (although I'd still recommend using the Account register and not the GL)
15:15:48 <Jannick> Ok I understand. Presumably this feature is a minimum requirement that GC could be more accepted here in Germany - for accounting SMEs.
15:16:25 <Jannick> I have already read a lot of postings about GC - and this issue was a no-go for those people.
15:17:23 <warlord> Well, then, send in a patch.
15:17:31 <warlord> (or find someone to implement it)
15:18:33 <Jannick> Yes I know. But I am afraid I am not capable to do it.
15:19:43 <Jannick> I had the idea to find someone here who could do that - since in my view this is one of the most important issues for the acceptance of GC in Germany.
15:20:28 <warlord> I hope you can find someone.
15:20:37 <Jannick> There export2Excel issue is already solved.
15:20:48 <Jannick> So do I! :-)
15:25:26 *** paolob-parroquia has joined #gnucash
15:25:41 <paolob-parroquia> Hi guys!
15:27:13 <paolob-parroquia> Does it represent a problem to work with two gnucash's files open at the same time? I'm seeing that the changes to the account visualization of one file are automatically applied to the other too. Besides that, is there any possibility of data corruption?
15:27:39 <jsled> Two different datafiles?
15:27:45 <jsled> With two different instances of gnucash?
15:27:54 *** Jannick has quit IRC
15:28:06 <paolob-parroquia> jsled, yes.
15:28:24 <paolob-parroquia> jsled, what other possibility do I have?
15:28:39 <jsled> There are some aspects of the UI that are not data-file-specific, and given how they're stored in gconf, I could imagine that the "other" instance would get updated when the first is.
15:28:50 <jsled> paolob-parroquia: None, but I just wanted to make sure. :)
15:29:04 <jsled> Can you give an example of a change that's applied in the other instance?
15:29:30 <paolob-parroquia> jsled, adding a column in the accounts view
15:29:33 <paolob-parroquia> jsled, could I open the two datafiles in the same instances?
15:29:56 <jsled> No, you shouldn't be able to.
15:30:03 <jsled> The lockfile should make it really hard to do that.
15:30:29 <warlord> And the account view column is a global pref.
15:30:34 <warlord> So yes, that would affect both instances.
15:31:22 <paolob-parroquia> ok, thnx
15:31:54 <paolob-parroquia> warlord, anything new about the search bug we were speaking some days ago?
15:32:51 <warlord> Oh, the Account search.. No, no changes.
15:39:25 <paolob-parroquia> warlord, any hope anyone work on that?
15:39:38 <warlord> There is always hope.
15:39:48 <warlord> But I dont think anyone is actively working on it right now.
15:39:55 <paolob-parroquia> ok
15:40:00 *** paolob-parroquia has quit IRC
15:40:15 <jsled> ¡Abandonando!
15:41:30 <warlord> heh
16:07:28 *** Dave_is_sexy has joined #gnucash
16:08:54 <Dave_is_sexy> Hey guys. Anyone know why my income+liabilities might not equal assets+expenses. Should it?
16:09:31 <warlord> It should. It might not if you have multiple commodities and didn't properly account for gains/losses.
16:11:13 *** Karti has joined #gnucash
16:14:26 *** andi5 has quit IRC
16:15:39 <Dave_is_sexy> Hmm.
17:08:36 *** twunder has quit IRC
17:10:46 *** donfede has quit IRC
18:03:26 *** _gunni_ has quit IRC
18:06:51 *** warlord is now known as warlord-afk
18:08:42 *** Dave_is_sexy has left #gnucash
18:16:23 *** twunder has joined #gnucash
18:21:06 *** twunder has quit IRC
18:24:44 *** aindilis has quit IRC
18:33:25 *** sjc has joined #gnucash
19:03:02 *** BlackBsd has joined #GnuCash
19:46:07 *** Karti has quit IRC
19:46:45 *** Karti has joined #gnucash
20:00:20 *** cortana has quit IRC
20:20:54 *** sjc has quit IRC
20:22:07 *** cortana has joined #gnucash
20:53:46 *** chris has quit IRC
21:05:05 *** pdc_ has joined #gnucash
21:07:15 *** pdc has quit IRC
21:11:42 *** BlackBsd has quit IRC
21:27:27 *** Dave_is_sexy has joined #gnucash
21:28:50 <Dave_is_sexy> I've put a foreign currency account 'inside' a local currency account, and it's gotten the exchange rate backwards, even though it's fine elsewhere. How can I fix this? Thanks
21:34:11 *** warlord-afk is now known as warlord
21:34:23 <warlord> Dave_is_sexy: define "backwards"? And in what context?
21:36:48 <Dave_is_sexy> Warlord: In 'Unspecified = 0' i put 'Unspecified-USD = USD 200'. That should come up as 'Unspecified = GBP 100' but is 'Unspecified = GBP 400'
21:37:15 <Dave_is_sexy> And once that's fixed everything will balance perfectly :)
21:40:21 <Dave_is_sexy> I'm leaving foreign transactions in 'Unspecified' cos they don't translate into £s if I allocate them into £ accounts, so I'd have to double up, or manually set the exchange rate for each transaction
21:41:29 <warlord> HUH??
21:41:34 <Dave_is_sexy> lol
21:41:41 <warlord> What does mean, "in Unspecified = 0"???
21:41:43 <Dave_is_sexy> $200 = £100
21:41:50 <warlord> NOTHING should ever be in "Unspecified"
21:41:57 <Dave_is_sexy> it's just in there for now
21:42:15 <Dave_is_sexy> it's a convenient misc account without cluttering my misc account
21:42:36 <Dave_is_sexy> anyway it thinks $200 = £400 which is backwards
21:42:58 <warlord> maybe it's confused because you entered it backwards?
21:43:22 <Dave_is_sexy> it was ok a minute ago, and then i did a foreign transfer and now it's backwards
21:43:27 <warlord> a) you should never have anything in "Unspecified"
21:43:39 <Dave_is_sexy> but the transfer was the right way round
21:43:39 <warlord> Well, did you actualy enter in the correct exchange rate?
21:43:44 <Dave_is_sexy> yes
21:43:48 <warlord> Are you SURE?
21:43:56 <warlord> Show me a screen shot.
21:43:59 <Dave_is_sexy> i got it from an exchange rate archive i found online
21:44:36 <warlord> And are you sure you didn't enter it in backwards?
21:44:46 <warlord> Did you enter in the exchange rate number?
21:44:50 <warlord> directly?
21:45:30 <Dave_is_sexy> the only places rates are entered is in price editor, and in the foreign transfer I just did. But the transfer works out correctly, and says the right think where it says £X = 4Y. That's all fine.
21:46:07 <warlord> If the transfer works out correctly then what's the problem?
21:46:35 <Dave_is_sexy> that when I put the foreign account as a sub-account of a local account it inverts the exchange rate
21:46:53 <Dave_is_sexy> which it didn't used to
21:50:09 <Dave_is_sexy> Just to check, in price editor in Currency > USD > USD should it be set as ~2 or ~0.5? (from £ if £1 ~= $2)
21:50:39 <warlord> I dont know.
21:51:29 <Dave_is_sexy> Hmm
21:51:42 <Dave_is_sexy> Seems to work if I invert that
21:51:49 <Dave_is_sexy> :$
21:52:02 <warlord> Well, then -- sounds like you entered it wrong in the price editor...
21:52:12 <Dave_is_sexy> yes, it would seem so
21:52:40 <Dave_is_sexy> a few extra bits appeared in price editor. i must've deleted the wrong ones
21:52:55 <warlord> heh
21:53:18 <Dave_is_sexy> so if i now alloacte these transactions to expense accounts, it'll all translate into £ all by itself and be ace!
21:55:23 <warlord> ok
22:00:02 <Dave_is_sexy> oh. no, it doesn't auto-convert. :(
22:00:45 <Dave_is_sexy> well time for bed. thanks warlord
22:01:18 *** Dave_is_sexy has left #gnucash
22:12:00 *** warlord is now known as warlord-afk
22:50:56 *** tjanssen has quit IRC
22:53:36 *** benoitg has joined #gnucash
23:06:25 *** klee has quit IRC
23:55:00 *** kmachalica has quit IRC