2008-11-10 GnuCash IRC logs
00:23:34 *** warlord is now known as warlord-afk
02:01:37 *** ninja has joined #gnucash
02:32:47 *** Rolf1 has joined #gnucash
03:35:46 *** bentob0x has joined #gnucash
03:44:33 *** lenscape has joined #gnucash
03:45:38 <lenscape> Upgrading from 2.2.4 to 2.2.7 (Suse 11.0 x64), RPM wants to remove qwenhywfar and aqbanking. Would you expect that?
03:46:00 *** ErKa has joined #gnucash
03:52:08 <lenscape> ah - it looks like the modules have changed names. >phew<
04:12:56 <lenscape> I've switched PCs. My accounts files were on a server and they're accessible and OK. However, my custom reports have vanished. Where would they be?
04:13:04 <lenscape> ...and how can I get them back?
04:18:10 *** kielein has joined #gnucash
05:03:32 *** Rolf1 has quit IRC
05:05:08 *** Rolf1 has joined #gnucash
05:23:50 *** puck has quit IRC
05:35:58 *** IanL has joined #gnucash
05:58:17 *** IanL has quit IRC
05:59:56 *** ninja has quit IRC
06:11:27 *** ninja has joined #gnucash
06:21:28 *** ninja has quit IRC
06:42:42 *** ninja has joined #gnucash
06:52:34 *** ErKa has quit IRC
06:53:43 *** ninja has quit IRC
07:05:46 *** ninja has joined #gnucash
07:24:47 *** ninja has quit IRC
07:27:08 *** JimRaehl has left #gnucash
07:27:39 *** twunder has joined #gnucash
07:33:16 *** JimRaehl has joined #gnucash
07:35:01 *** kielein has quit IRC
07:35:17 *** ninja has joined #gnucash
07:38:35 *** twunder has quit IRC
07:46:03 *** ninja has quit IRC
07:58:17 *** ninja has joined #gnucash
08:12:18 *** ninja has quit IRC
08:28:40 *** ninja has joined #gnucash
08:55:46 <Rolf1> gnucash saves times in UTC?
09:02:51 <Rolf1> scrap that question
09:03:01 *** warlord-afk is now known as warlord
09:03:47 <Rolf1> good morning warlord
09:04:05 <warlord> hi Rolf1. How are you?
09:04:07 <Rolf1> I remember there was a long debate about timezones and how gnucash should handle that, recently
09:04:16 <Rolf1> I am doing fine. How are you?
09:04:25 <Rolf1> What was the outcome of the debate?
09:04:35 <Rolf1> It seems that the SQL-backend saves in UTC
09:04:49 <Rolf1> That means all my dates are -1 now :-/
09:05:00 <Rolf1> When accessing from OOo, for example
09:05:10 <Rolf1> Inside GC, things appear to be fine
09:07:40 <warlord> I'm not sure what the SQL engine is storing. Internally (in RAM) it's keeping dates in localtime, and in the XML file is uses localtime as well (but MIDNIGHT)
09:08:00 <warlord> So in the XML file you'll see something like 2008-01-01 05:00:00 -0500
09:08:14 <warlord> (or, rather, that's what *I'll* see)
09:09:23 <Rolf1> In the XML I have
09:09:26 <Rolf1> <trn:date-posted>
09:09:26 <Rolf1> <ts:date>2008-07-01 00:00:00 +0200</ts:date>
09:09:26 <Rolf1> </trn:date-posted>
09:09:40 <Rolf1> In SQL that becomes
09:10:09 <Rolf1> 20080630220000
09:10:28 <warlord> Ummm... That looks wrong. Why would you have 00:00:00 +0200?
09:10:33 <Rolf1> IOW, two hours behind, it is considered to be in the second quarter, when it should be in the thirs
09:10:42 <Rolf1> d
09:11:00 <Rolf1> Don't ask me, I'm just pasting the data I grabbed from the XML
09:11:01 *** ErKa has joined #gnucash
09:11:31 <Rolf1> r17663
09:11:44 <Rolf1> Maybe anything changed recently?
09:13:37 <warlord> Huh.. 00:00:00 +0200 is 22:00:00 on the previous day. So yes, that WOULD be 2008-06-30 22:00:00 UTC. So the conversion is correct.
09:15:32 <warlord> i'm not sure what, if anything, changed.
09:18:38 *** localhost1 has joined #gnucash
09:19:55 <Rolf1> Well, the conversion may be correct. But the day I entered was of course July 1st
09:20:02 <Rolf1> That is also what is being displayed
09:20:05 <Rolf1> in GC
09:20:19 <Rolf1> and that is what I want for my report
09:20:39 <Rolf1> I guess, I'll need to report another bug so we can collectively figure this out
09:20:49 <Rolf1> bug report
09:20:53 <warlord> Yeah...
09:20:55 <warlord> Please do.
09:21:04 <warlord> That timestamp just looks completely bogus.
09:21:26 <warlord> it's reporting midnight UTC but claiming it's in your local TZ..
09:21:55 *** ErKa has quit IRC
09:23:02 <Rolf1> I wonder how it came to this
09:23:24 <Rolf1> I'll send a mail to -dev first
09:23:54 <warlord> I don't know.
09:24:07 <warlord> I'm not running current trunk, so I dont think I'm seeing this.
09:25:00 *** localhost has quit IRC
09:25:57 <Rolf1> warlord: locale is independent of timezone or isn't it?
09:26:13 <Rolf1> I sometimes start gnucash with LC_ALL=C LANG=C
09:26:29 <warlord> Yes, locale is independent of TZ.
09:26:30 <Rolf1> I don't think that should affect it
09:26:32 <Rolf1> OK
09:26:36 <Rolf1> thanks for confirming
09:26:46 <Rolf1> 't was the only thing I could think of right now
09:26:51 <warlord> Yeah..
09:30:50 *** ErKa has joined #gnucash
10:32:08 *** gncbot` has joined #gnucash
10:32:08 *** gncbot has quit IRC
10:51:50 <warlord> @nick gncbox
10:51:51 *** gncbot` is now known as gncbox
10:51:54 <warlord> @nick gncbot
10:51:55 *** gncbox is now known as gncbot
10:51:58 *** warlord sets mode: +o gncbot
11:09:08 *** benjamin has joined #gnucash
11:09:44 *** warlord is now known as warlord-afk
11:12:14 *** ErKa has quit IRC
12:06:24 *** benjamin has quit IRC
12:50:12 *** warlord-afk is now known as warlord
12:51:51 *** bentob0x has quit IRC
13:29:26 *** twunder has joined #gnucash
13:32:01 <lenscape> I've switched PCs. My accounts files were on a server and they're accessible and OK. However, my custom reports have vanished. Where would they be?
13:32:16 <lenscape> ...and how can I get them back?
13:33:42 <warlord> They would be in your homedir.
13:33:52 <jsled> They're in ~/.gnucash/saved-reports-2.0.scm, I believe.
13:34:22 <lenscape> can I just copy them across or are there references to them in other files?
13:35:02 <warlord> Yes
13:36:56 <lenscape> Thanks
13:44:19 *** cortana has joined #gnucash
14:07:25 *** Zoolooc has joined #gnucash
14:38:58 *** puck has joined #gnucash
15:00:34 *** sjc has joined #gnucash
15:41:18 *** Zoolooc has quit IRC
15:41:35 *** Zoolooc has joined #gnucash
17:39:27 *** twunder has quit IRC
18:06:51 *** warlord is now known as warlord-afk
18:33:04 *** talso has quit IRC
18:39:28 *** Zoolooc has quit IRC
18:40:01 *** Zoolooc has joined #gnucash
18:40:59 *** ninja has quit IRC
18:44:46 *** Rolf1 has quit IRC
18:52:10 *** ninja has joined #gnucash
19:05:00 *** twunder has joined #gnucash
19:06:07 *** cortana has quit IRC
19:23:46 *** twunder has quit IRC
19:29:43 *** twunder has joined #gnucash
19:44:04 *** twunder has quit IRC
20:14:40 *** sjc has quit IRC
20:20:41 *** twunder has joined #gnucash
20:40:47 *** Zoolooc has quit IRC
21:07:43 *** BlackBsd has joined #GnuCash
21:23:15 *** ninja has quit IRC
21:33:03 *** ninja has joined #gnucash
22:57:04 *** twunder has quit IRC
23:22:56 *** wizkid238 has quit IRC
23:43:02 *** ninja has left #gnucash