2008-08-17 GnuCash IRC logs
00:35:00 *** jcarter has joined #gnucash
00:41:30 *** gergesm_ has joined #gnucash
00:50:08 *** jason has joined #gnucash
00:54:12 <jason> Hi folks
00:54:27 <jason> I recently started having a strange problem with gnucash
00:54:40 <jason> I've been using it for a few months now (great program btw! thanks so much)
00:54:49 <jason> and all of a sudden I can't open any of my files
00:55:07 <jason> it just says Can't parse URL /home/jason/finances.gnucash
00:55:47 <jason> and the console error is Found Finance::Quote version 1.13
00:55:47 <jason> /home/jason/finances.gnucash:1: parser error : Start tag expected, '<' not found
00:56:12 <jason> I even went and downloaded some old backup files of mine and tried them and I get the same thing
00:56:22 <jason> not sure what's going on, any helpful hints would be great
01:01:18 <jason> I've also tried it on a few machines now, so I'm not sure what's up
01:01:21 <jason> all are ubuntu machines
01:20:26 *** warlord has joined #gnucash
01:20:26 *** gncbot sets mode: +o warlord
01:21:42 *** Zoolooc has joined #gnucash
01:49:22 *** warlord is now known as warlord-afk
02:05:34 *** gergesm__ has joined #gnucash
02:05:35 *** gergesm_ has quit IRC
03:00:24 *** Rommedahl has joined #gnucash
03:24:13 *** eduardo has quit IRC
03:32:38 *** gergesm_ has joined #gnucash
03:32:38 *** gergesm__ has quit IRC
03:34:38 *** Zoolooc has quit IRC
03:37:31 *** Zoolooc_ has joined #gnucash
05:39:32 *** Rommedahl has quit IRC
05:49:18 *** mfwitten has quit IRC
05:51:31 *** mathieu_ has joined #gnucash
05:53:08 <mathieu_> Hi, I have an account tree without stock, but with multiple currencies. I trying to figure out how gnucash calculates the retained gains/losses on the balance sheet. Anyone an idea?
05:53:25 <mathieu_> sorry, i meant unrealized gains/losses
05:53:54 <mathieu_> the balance sheet doesn't add up anymore
06:00:57 *** Ozaed_ has joined #gnucash
06:02:42 *** cortana has joined #gnucash
06:09:32 *** Ozaed__ has quit IRC
06:26:04 *** |gunni| has joined #gnucash
06:34:50 *** _gunni_ has quit IRC
06:36:08 <mathieu_> warlord-afk, you were right yesterday, that selinger tutorial makes the unrealized gain realized (in gnucash). It completely fucks up the gnucash balance sheet
06:37:13 <mathieu_> warlord-afk, my conclusion of some testing in gnucash, is that the only valid way is to use the gnucash standard way of multi-currency ...
07:03:39 <mathieu_> Question about unrealized gains/losses:
07:05:56 <mathieu_> May local currency is EUR. Say I convert 100 EUR in 150 USD. At that time my unrealized gain is still zero. The dollar goes up (price editor), and now I have a unrealized gain of 5 EUR. Everything still fine in gnucash. Now, I decide I don't need those dollars anyway, so I put them back in EUR. Now I have 105 EUR. Gnucash still shows 5 EUR unrealized gains. How do I 'realize' this gain?
07:07:18 <mathieu_> If I create an income of 5 EUR, what is the other account then?
07:18:28 *** mathieu_ has quit IRC
07:19:11 *** mathieu_ has joined #gnucash
07:21:42 <gergesm_> mathieu_, the other account is unrealized gain - you move it over from unrealized gain to realized gain
07:23:48 <mathieu_> gergesm_, where do I find this account? 'unrealized gain' is just something calculated on the balance sheet
07:24:51 *** see-g has joined #gnucash
07:24:57 <gergesm_> http://svn.gnucash.org/docs/guide/capgain_example1.html#capgain_exampleunrealized2
07:26:30 <mathieu_> gergesm_, the problem with multiple currencies is that gnucash does not create such an account
07:26:42 <mathieu_> it breaks the balance
07:26:54 <mathieu_> and gnucash fixes it just by added 'unrealized gains' in the balance sheet
07:27:28 <mathieu_> the accounting balance does not hold anymore
07:27:48 <mathieu_> the multiple currency support seems to be fundamentally broken
07:29:59 <cortana> http://www.mathstat.dal.ca/~selinger/accounting/
07:30:29 <mathieu_> cortana, yes i read that yesterday
07:30:38 <mathieu_> <warlord> That "tutorial" is not written by an accountant..
07:30:46 <mathieu_> <warlord> He doesn't differentiate between Realized and Unrealized gains.
07:34:33 <mathieu_> gnucash considers your unrealized gains as realized with his idea
07:39:51 *** Zoolooc_ has quit IRC
08:21:38 *** Rolf has joined #gnucash
08:23:33 *** twunder has joined #gnucash
08:30:09 *** JimRaehl has left #gnucash
08:38:51 *** JimRaehl has joined #gnucash
08:41:26 *** twunder has quit IRC
09:06:06 *** martincleaver has joined #gnucash
09:06:08 <see-g> so let's see if I manage to handle this SVN thingy ... it's downloading the docs now and I'll do a first attempt at translating EN->DE tonight, I hope
09:19:43 *** warlord-afk is now known as warlord
09:21:23 <warlord> mathieu_: When you "sell" the USD and get EUR back then you have a 4-split transaction. There's the two splits for the sale (-100 USD, +105 EUR) and then two splits for the cap gains: (+/- 5 EUR). One of the cap-gains splits goes into the Cap Gains Income Account. The other goes into the USD account.
09:22:48 <warlord> see-g: I think there was an attempt at a DE docs translation a while ago.
09:25:27 <see-g> I meant my first attempt, (the following is true for at least the new users guide) the translation is done in parts only, my dad would need it all in german, though...
09:25:49 <see-g> ...so that's where I come in and try to help out :)
09:27:07 <warlord> see-g: well, what I meant is that there IS a gnucash-docs/guide/de_DE tree
09:27:17 <warlord> But it's pretty empty
09:31:40 *** eduardo has joined #gnucash
09:33:05 <mathieu_> warlord, what you do call 'the USD account'? the one where you already put the -100 USD? Wouldn't make sense, but I don't see which other
09:42:59 <warlord> mathieu_: well, it would be a split of 0$/5EUR
09:44:10 <warlord> (or maybe 0/-5 --- I forget if it's a debit or credit)
09:48:51 <mathieu_> warlord, isn't that a hideous construct?
09:49:13 <warlord> remember that each split has an "amount" (in the current account commodity) and a value (in the txn currency)
09:49:48 <mathieu_> so basically you arbititraly define the capital gain
09:49:53 <mathieu_> gnucash can't check it
09:50:19 <warlord> right now gnucash does not compute the gains (or losses) automatically. C.f. "known issues"
09:52:06 <mathieu_> is there a list of known issues?
09:52:54 <warlord> well, there's bugzilla
09:53:04 <warlord> and the minds of people
09:55:16 <warlord> .. list archives..
09:55:18 <warlord> etc.
09:56:27 <mathieu_> hm didn't have a look at bugzilla yet..
09:56:35 <mathieu_> not indexed by google it seems
10:03:14 <warlord> doesn't surprise me
10:03:20 <warlord> you can search it directly.
10:06:03 *** McLANE has joined #gnucash
10:15:33 <mathieu_> can't find anyone complaining like me (expect the selinger guy ;))
10:16:05 <mathieu_> but the manual also proposes this broken way of working :/
10:16:32 <mathieu_> problem is, it can be quite hard sometimes to compute yourself these gains and losses
10:18:27 <mathieu_> if you first 'buy' 100 USD for this rate, and then 50 USD for another rate and you sell it 80 USD for another rate..
10:19:02 <mathieu_> i think i found a way to adapt these trade accounts to make the different between realized and unrealized
10:19:10 <mathieu_> differenCE
10:19:26 <warlord> ok
10:19:49 <warlord> instead of looking at multiple currencies you can also search on stock/mutual-fund handling.
10:19:54 <warlord> there really is no difference
10:20:16 <mathieu_> and that works properly in gnucash?
10:20:28 <warlord> nope.
10:20:32 <mathieu_> great :)
10:20:44 <warlord> like I said, gnucash treats it all the same.
10:20:58 <mathieu_> oh you meant for search on bugs
10:21:07 <warlord> yes
10:26:15 <mathieu_> IMHO this deserves a big warning in the docs
10:28:18 <mathieu_> it's not normal that one needs two days to figure out that multi-currency support is basically broken
10:28:56 * warlord shrugs
11:01:33 *** martincleaver has quit IRC
11:09:24 *** martincleaver has joined #gnucash
11:11:43 *** eduardo has quit IRC
11:40:10 *** jcarter has joined #gnucash
11:42:28 *** Rommedahl has joined #gnucash
11:48:58 <jcarter> how can I get gnucash to recognize share drives?
11:49:17 <warlord> define "recognize"?
11:49:38 <jcarter> I want to open a file that is in a share drive.
11:50:05 <warlord> This is windows?
11:50:26 <jcarter> I have Ubuntu running on a Mac in VMWare.
11:50:29 <warlord> (if so I'm only going to be able to guess)
11:50:59 <jcarter> Consider that the ´share´ drive is a network drive.
11:51:00 <warlord> Why run it in vmware instead of on the mac directly?
11:51:05 <warlord> is it mounted?
11:51:21 <jcarter> It is mounted, but I can´t figure out where the mount is.
11:51:37 <warlord> run "mount"
11:51:40 <jcarter> And I do have gnucash running directly on the Mac as well.
11:52:19 <jcarter> I ran ´mount´, but it didn´t tell me anything I could understand.
11:52:32 <warlord> it should tell you where the drive is mounted.
11:53:14 <jcarter> /dev/sda1 on / type ext3 (rw,relatime,errors=remount-ro)
11:53:14 <jcarter> proc on /proc type proc (rw,noexec,nosuid,nodev)
11:53:14 <jcarter> varrun on /var/run type tmpfs (rw,noexec,nosuid,nodev,mode=0755)
11:53:14 <jcarter> varlock on /var/lock type tmpfs (rw,noexec,nosuid,nodev,mode=1777)
11:53:15 <jcarter> udev on /dev type tmpfs (rw,mode=0755)
11:53:17 <jcarter> devshm on /dev/shm type tmpfs (rw)
11:53:19 <jcarter> devpts on /dev/pts type devpts (rw,gid=5,mode=620)
11:53:21 <jcarter> lrm on /lib/modules/2.6.24-19-generic/volatile type tmpfs (rw)
11:53:23 <jcarter> securityfs on /sys/kernel/security type securityfs (rw)
11:53:25 *** McLANE has quit IRC
11:53:25 <jcarter> Can you figure that out?
11:54:17 <warlord> your share is not mounted.
11:55:02 <jcarter> It shows up in Places
11:55:25 <warlord> I have no clue what "places" is.
11:55:42 <warlord> but "mount" shows that it is not mounted.. so gnucash wont be able to access it.
11:56:19 <jcarter> In Ubuntu, in the top menu bar is a tab labeled ´Places´. Click on that and you get a drop down panel.
11:56:38 <jcarter> Okay, so how do I mount a network drive?
11:56:56 <warlord> I dont have ubuntu
11:57:06 <warlord> I have no idea how to do it on ubuntu.
11:57:21 <jcarter> Okay. I´ve got some digging to do.
11:57:21 <warlord> From the commandline: mount host:/path /mountpoint
11:57:50 <warlord> What kind of file server? NFS? CIFS?
11:58:41 <jcarter> Mac file system, forgot the type. but I think it´s NFS
12:00:20 <jcarter> jcarter@ubuntu804desktop:~/Documents$ sudo mount jcmac:/Users/jcarter /mnt
12:00:20 <jcarter> [sudo] password for jcarter:
12:00:20 <jcarter> mount: wrong fs type, bad option, bad superblock on jcmac:/Users/jcarter,
12:00:20 <jcarter> missing codepage or helper program, or other error
12:00:20 <jcarter> (for several filesystems (e.g. nfs, cifs) you might
12:00:21 <jcarter> need a /sbin/mount.<type> helper program)
12:00:23 <jcarter> In some cases useful info is found in syslog - try
12:00:25 <jcarter> dmesg | tail or so
12:00:36 <jcarter> Guess it isn´t NFS
12:01:25 <jcarter> I´ll talk to the Ubuntu group about this.
12:01:33 <warlord> Yeah, I'd recommend that.
12:01:36 <warlord> Good Luck.
12:06:52 *** jcarter has quit IRC
12:09:00 *** nbinon1 has quit IRC
12:09:12 *** warlord is now known as warlord-afk
12:47:42 *** twunder has joined #gnucash
12:50:34 <jason> hmm, I asked this question several hours ago, but it looks like many more people have joined since then
12:51:00 <jason> So somehow just a couple days ago gnucash has stopped being able to open my gnucash files
12:51:19 <jason> saying Can't parse the URL /home/jason/finances.gnucash.
12:52:19 <jason> and in the console saying /home/jason/finances.gnucash:1: parser error : Start tag expected, '<' not found
12:52:42 <jason> I've tried this on several computers now, also trying it with some backed up gnucash files I had, all get the same error
12:52:52 <jason> anybody have any ideas?
12:53:04 *** see-g has quit IRC
12:59:16 <twunder> jason: what version of gnucash?
13:04:03 *** warlord-afk is now known as warlord
13:04:04 *** gergesm_ has quit IRC
13:04:14 <warlord> jason: what do you get from "file /home/jason/finances.gnucash"?
13:06:37 *** twunder has quit IRC
13:13:43 *** see-g has joined #gnucash
13:15:37 <jason> warlord: GnuCash 2.2.4
13:15:37 <jason> Built 2008-03-27 from r16997
13:15:45 <jason> finances.gnucash: data
13:16:18 <warlord> Did your disk fill?
13:16:40 <jason> no, 52% available
13:16:50 <jason> also tried several computers
13:17:31 <warlord> "data" sounds wrong. What happens if you try: zcat /home/jason/finances.gnucash
13:18:25 <jason> gzip: finances.gnucash: not in gzip format
13:19:07 <warlord> Umm...
13:19:08 <warlord> Okay...
13:19:11 <warlord> what do you get from:
13:19:15 <warlord> head /home/jason/finances.gnucash
13:19:44 <jason> a whole bunch of random characters and such, looks like it's just binary
13:23:18 <warlord> Ummmm....
13:23:28 <warlord> Definitely sounds like it got corrupted somehow.
13:23:31 <warlord> No idea how.
13:23:40 <jason> huh, bizarre, let me try another older backup file
13:26:55 <jason> hmm, the older file works...
13:27:46 <jason> ah!
13:27:56 <jason> so I store my .gnucash file encrypted
13:28:08 <jason> somehow finances.gnucash.gpg got renamed to finances.gnucash but was still encrypted
13:28:15 <jason> as always, user error
13:28:32 <jason> sorry to waste your time
13:32:19 <jason> good to know for the future that they're stored gziped
13:32:28 <jason> I didn't know what the file was supposed to look like
13:35:40 *** linas has joined #gnucash
13:35:44 <warlord> There ya go.
13:35:46 <warlord> LINAS!
13:35:52 <linas> hey
13:35:56 *** jason has left #gnucash
13:35:57 <warlord> Hey linas.
13:35:59 <linas> amazing what autologin does
13:36:00 <warlord> How are you?
13:36:07 <linas> fine thank you
13:36:16 <linas> was going off to visit the abiword channel
13:37:02 <warlord> ah, so we're not good enough for you anymore? ;-)
13:37:52 <linas> heh
13:38:07 <linas> I am currently doing something completely different
13:38:51 <linas> I'm working on natural language (english) parsing systems
13:38:52 <warlord> You do like to try new things.
13:39:00 <warlord> written or spoken?
13:39:01 <linas> abi uses one for hier grammar-check plugin.
13:39:21 <linas> written
13:40:06 <warlord> Sounds like fun
13:40:49 *** twunder has joined #gnucash
13:41:11 *** martincleaver_ has joined #gnucash
13:41:23 <warlord> Austin still treating you well?
13:44:04 <linas> yeah
13:44:18 <linas> I work at home now, no driving, its reat
13:45:40 <warlord> I still need to get myself to Austin one of these days.
13:47:10 <linas> well, let me know if you come.
13:47:24 <linas> we have an ampty garage apartment in the back. Welcome to use it.
13:47:35 <warlord> cool! Thanks for the offer.
13:47:53 <warlord> Anyways, I need to head out before I lose the whole day.
13:48:55 *** martincleaver has quit IRC
13:54:24 <linas> eh, good idea.
13:54:35 <linas> later.
14:52:21 *** twunder has quit IRC
15:27:05 *** mathieu_ has quit IRC
15:39:09 *** micha has joined #gnucash
16:16:34 *** warlord2 has joined #gnucash
16:16:46 *** warlord has quit IRC
16:23:29 *** martincleaver has joined #gnucash
16:30:46 *** martincleaver_ has quit IRC
17:10:31 *** see-g has quit IRC
17:16:40 *** Rommedahl has quit IRC
17:36:07 *** akpoff has joined #gnucash
17:36:23 <akpoff> Good afternoon
17:36:32 <akpoff> (At least here in Houston)
17:39:10 <akpoff> I've just started using GnuCash on Windows XP and am running into limitations. 1) I can't set an absolute start date in preferences, 2) I can't "Get Quotes" on on currentcy exchanges in the "Price Editor". I'm very new to GnuCash but not to double-entry bookkeeping. I've googled these topics and haven't found anything especially helpful. Any pointers would be great. Thanks!
17:44:01 *** warlord2 is now known as warlord
17:44:02 <warlord> @op
17:44:02 *** gncbot sets mode: +o warlord
17:44:27 <warlord> akpoff: Not sure what you mean by #1. As for #2, did you run [Start] -> All Programs -> Gnucash -> Install Quote Grabber ?
17:45:48 <akpoff> warlord: : Thanks for the note on #2. I missed that one. :(
17:46:29 <akpoff> As for #1, in Preferences under "Accounting Period" you can select a period and set an absolute date. I'm unable to change that for love or money.
17:48:23 <warlord> I think that might be the 2.2.6 date-edit bug.
17:49:00 <akpoff> warlord: Ahh...do I need a patch, or just wait until the next version?
17:49:24 <warlord> You could downgrade to 2.2.5
17:49:28 <warlord> Or wait for 2.2.7
17:49:34 <warlord> there is no "patch"
17:49:45 *** sjc has joined #gnucash
17:49:54 <akpoff> warlord: no problem. Any reason not to downgrade you might advise me against?
17:50:09 <warlord> Honestly, I dont know.
17:50:19 <warlord> I haven't been following 2.2.x too much, and I dont do windows.
17:50:48 <akpoff> warlord: no problem. I'll read the release notes for 2.26 to see whether it mentions any significant fixes.
17:51:10 <akpoff> warlord: thanks again for the notes on #2. That I think I can resolve, once I get perl installed.
17:51:44 <warlord> Make sure you instal 5.5.8
17:51:47 <warlord> (or 5.8.8?)
17:52:35 <akpoff> Thanks, I'll do that.
17:59:52 <warlord> good luck
18:09:01 *** ashikase has left #gnucash
18:15:21 *** jcarter has joined #gnucash
18:16:44 *** akpoff has quit IRC
18:17:44 *** twunder has joined #gnucash
18:37:05 *** warlord is now known as warlord-afk
19:04:31 *** twunder has quit IRC
19:10:12 *** cortana has quit IRC
19:18:41 *** _gunni_ has joined #gnucash
19:27:21 *** |gunni| has quit IRC
20:09:20 *** JimRaehl has left #gnucash
20:17:46 *** JimRaehl has joined #gnucash
20:22:20 *** nbinont has joined #gnucash
20:35:01 *** sjc has quit IRC
20:41:27 *** jrgenolsen_ has quit IRC
21:03:33 *** twunder has joined #gnucash
21:11:06 *** jcarter has quit IRC
21:25:28 *** eduardo has joined #gnucash
21:52:00 *** jcreigh has joined #gnucash
22:48:56 *** martincleaver has left #gnucash
23:22:58 *** twunder has quit IRC
23:31:00 *** jcreigh has quit IRC