2007-07-07 GnuCash IRC logs
00:57:52 *** kam_ has quit IRC
02:16:42 *** linmint has quit IRC
02:45:01 *** roxy_ has joined #gnucash
03:23:10 *** roxy_ has quit IRC
04:13:35 *** vinci has joined #gnucash
06:00:33 *** gunnicom| has joined #gnucash
06:51:03 *** Rolf has joined #gnucash
08:55:38 *** andi5 has joined #gnucash
08:55:39 *** gncbot sets mode: +o andi5
08:59:45 *** warlord-afk is now known as warlord
08:59:47 <warlord> .
09:05:57 *** tpfennig_ has joined #gnucash
09:14:39 *** vinci has quit IRC
09:34:18 *** linmint has joined #gnucash
10:10:32 *** chris has joined #gnucash
10:10:32 *** gncbot sets mode: +o chris
11:16:11 *** BlackBsd has joined #GnuCash
11:26:52 *** Rolf has quit IRC
11:27:04 *** Sathamoth has joined #gnucash
11:34:41 <Sathamoth> Hi. I'm using GnuCash 2.0.5 (installed via MacPorts) on Mac OS X 10.4.10. I'm having some problems with precision in my Investment Portfolio report. The report is displayed in EUR (that's what I want). I have three stocks, two of them in EUR and one in USD. Stock prices are set via the Price Editor and are correct. EUR <-> USD exchange rate is also set correctly. However, the report displays invalid value of USD stocks (numbers will follow).
11:35:06 <Sathamoth> The current value of a stock is 40.66 USD, there are 31 stocks, and the latest exchange rate is EUR = 0.7286 USD, so the correct total value would be 40.66 * 31 * 0.7286 = 918,37 EUR. However, the report displays 918.51 EUR. Any ideas where those 14 cents went?
11:36:55 <Sathamoth> or actually, why there's extra 14 cents :]
11:40:37 <warlord> 31.0 stocks?
11:40:56 <Sathamoth> warlord: yes, 31.00
11:41:31 <warlord> just making sure.
11:41:41 <warlord> which report is this?
11:41:56 <Sathamoth> the Investment Portfolio report which came by default with 2.0.5
11:42:41 <warlord> Which price source do you have set in the report options?
11:42:54 <Sathamoth> Most recent
11:43:26 <warlord> What happens if you change it to "nearest in time"?
11:43:27 <Sathamoth> and the latest exchange rate is set in Price Editor to 0.7286
11:43:39 <Sathamoth> nothing changes
11:43:57 <warlord> is anything printed on your terminal?
11:44:00 <Sathamoth> nope
11:44:07 <warlord> :(
11:44:17 <warlord> It certainly sounds like a report bug to me.
11:44:21 <Sathamoth> oh, wait
11:44:27 <Sathamoth> "apps file failure"
11:44:34 <Sathamoth> that's printed when I refresh the report
11:44:46 <warlord> Hmm...
11:45:07 <Sathamoth> but I don't think that's related to GnuCash calculation functions ;)
11:45:24 <Sathamoth> it looks like some Fluxbox error msg
11:45:56 <warlord> Could you create a small datafile that shows the problem? Like a handful of accounts, a transaction or two, and a couple PriceDB entries?
11:46:11 <warlord> ... and then file a bug report and attach the datafile to the bug report?
11:46:32 <warlord> honestly, I can't see what math would produce the error you have, but I'd need to see data that produced the problem.
11:46:46 <Sathamoth> yeah I think I'll do that.. I cannot confirm this with 2.1.5 because I had some problems installing it via MacPorts
11:47:42 <Sathamoth> I'll try to narrow it down later today, gotta go now.. thanks for help
11:48:58 <warlord> Your'e welcome. Thanks!
12:10:01 *** andi5 has left #gnucash
12:25:59 *** palatin has joined #gnucash
12:33:59 *** ural0 has joined #gnucash
12:35:29 *** ural0 has left #gnucash
12:41:59 *** peter_ has joined #gnucash
12:43:02 <peter_> Hi, I have run into a problem with gnucash2.0 with the raw xml files
12:43:28 <peter_> In the past I used a XSl style sheet to transform the raw files to gnumeric
12:43:59 <peter_> but today I think this is the first year we use 2.0 - I can not open the relevant fiules
12:44:21 <peter_> They appear to be in some zipped format which I do not recognise
12:44:30 <peter_> Anyone an idea?
12:44:32 <jsled> peter_: run `file /path/to/filename`
12:44:39 <jsled> hint: they're just gzipped.
12:44:50 <jsled> In Edit > Preferences you can turn the compression off.
12:45:01 <jsled> Or you can just rename the file to end in .gz, then run `gunzip` on the command line.
12:45:13 <peter_> ok I'll try this. Thanks!
12:45:45 <jsled> (or do something like $(cat file.gnucash | gunzip -c | xsltproc xform.xslt - > file.gnumeric)
12:45:51 <jsled> , or whatever.)
12:48:45 <warlord> or "zcat file | ..."
12:50:57 <peter_> taht worked. Thanks :-)
13:18:27 <peter_> Argh... the next problem turned up. I used Jason's XSL from xslfactory which is advertised in the Wiki in the past very successfully. One simply had to add a few lines to the xml file and then run the xsl sheet past it with xalan and that was that. I had then gnumeric files which I converted into Excel spreadsheets for my accountant. Suddenly this doe snot work
13:19:34 <peter_> Changes to the format which became obvious to me between 1.8 and 2.0 is that there is now a complete XML definition instead of a oneline gnc-v2 in the begin,
13:24:59 <peter_> Any idea what I need to do? Thanks!
13:37:18 <peter_> Essentially I get an empty gnumeric file
13:38:32 <peter_> XSLT Message: beginning in /Source tree node: #document. (file:///home/peter/Documents/Work/MyAccounts/gnucash2gnumeric_0.6.xsl, line 138, column 29.)
13:38:32 <peter_> XSLT Message: gnc-v2 - ACCOUNT_MODESource tree node: gnc-v2. (file:///home/peter/Documents/Work/MyAccounts/gnucash2gnumeric_0.6.xsl, line 411, column 33.)
13:56:02 *** peter_ has quit IRC
14:16:05 *** bonez44 has joined #gnucash
15:01:32 *** bonez44 has quit IRC
15:13:44 *** sjc has joined #gnucash
15:31:54 *** warlord has quit IRC
16:50:03 *** palatin has quit IRC
17:42:45 *** gunnicom_ has joined #gnucash
17:47:58 *** tpfennig_ has quit IRC
17:51:56 *** gunnicom| has quit IRC
18:25:29 *** Nathor has joined #gnucash
18:26:45 *** Nathor has quit IRC
20:29:55 *** hampton has joined #gnucash
20:30:47 *** hampton has left #gnucash
21:11:33 *** sjc has quit IRC
23:03:37 *** BlackBsd has joined #GnuCash
23:17:48 *** Wilddev has joined #gnucash
23:17:48 *** gncbot sets mode: +o Wilddev