2023-04-08 GnuCash IRC logs
00:21:01 *** miklcct has quit IRC
00:21:28 *** miklcct has joined #gnucash
00:21:28 *** ChanServ sets mode: +v miklcct
01:47:15 *** fell has quit IRC
01:48:35 *** fell has joined #gnucash
01:48:35 *** ChanServ sets mode: +o fell
02:25:03 *** NoobAlice has quit IRC
03:28:49 *** gandalf has joined #gnucash
05:31:07 *** rtrev has joined #gnucash
05:38:21 *** rtrev has quit IRC
06:50:54 *** warlord has quit IRC
07:49:24 *** Kaligula has joined #gnucash
07:50:00 *** ChanServ sets mode: +v Kaligula
07:50:06 <Kaligula> .
07:54:14 *** Kaligula has quit IRC
09:26:19 *** jervin has quit IRC
09:26:32 *** jervin has joined #gnucash
10:56:08 *** Simon has quit IRC
10:58:30 *** Simon has joined #gnucash
10:58:30 *** ChanServ sets mode: +v Simon
11:47:17 *** jervin has quit IRC
11:52:04 *** NoobAlice has joined #gnucash
11:52:04 *** ChanServ sets mode: +v NoobAlice
12:31:31 *** jervin has joined #gnucash
13:23:36 *** jralls sets mode: +o gncbot
13:34:16 *** palerider has joined #gnucash
14:04:51 *** Kaligula has joined #gnucash
14:05:12 *** ChanServ sets mode: +v Kaligula
15:22:33 *** gandalf1 has joined #gnucash
15:23:01 *** gandalf has quit IRC
15:23:01 *** gandalf1 is now known as gandalf
15:52:02 *** gandalf has quit IRC
16:08:27 *** jervin has quit IRC
19:55:33 <CDB-Man> chris: multicolumn income statement is showing the FX I have for 2020-12-30 instead of 2020-12-31. the legacy IS report shows the 31st rate correctly. jralls does this have something to do with the timezone change you mentioned a month ago?
19:57:13 <CDB-Man> weird that its only doing it for my 2020 year end values, not 2021. the 30th and 31st prices for 2020 and 2021 are both FQ downloaded rates
19:58:33 *** Kaligula has quit IRC
20:01:41 <chris> CDB-Man: I'd bet it's TZ yes
20:02:38 <chris> if you were to open the datafile in XML, look for a <price> near 2020-12-30 cf 2021-12-31 and report the TZ info
20:02:59 <chris> <price:time>
20:03:22 <CDB-Man> how can I unpack the .gnucash file?
20:23:34 <chris> you could copy to .zip !
20:32:48 <CDB-Man> like rename the extension to .zip?
20:36:37 <chris> yes
20:38:45 <chris> assuming you're using xml rather than sql
20:40:34 <CDB-Man> well a straight rename didnt work
20:40:59 <CDB-Man> i vaguely remember someone saying something about compressed save files
20:42:39 <chris> then try Edit > Preferences > General > compress [false]
20:42:58 <chris> ok it's likely .gz rather than .zip
20:43:12 <CDB-Man> no compression did not work, will try gz
20:43:30 <CDB-Man> .gz did not work
20:43:33 <CDB-Man> .tar.gz ?
20:43:49 <CDB-Man> nope
20:44:47 <chris> save as > xml
20:45:43 <CDB-Man> looks like uncompressed i can open in notepad++
20:48:09 <CDB-Man> <ts:date>2020-12-31 22:09:54 +0000</ts:date>
20:48:14 <CDB-Man> <ts:date>2020-12-30 23:46:32 +0000</ts:date>
20:52:30 <chris> yeah not sure what time the exchange converter is picking up
20:52:56 <CDB-Man> actually, i think i quoted the wrong stamp
20:53:27 <CDB-Man> nope, that's the right one
20:54:10 <CDB-Man> jralls had explained it at one point. if there's something i could change it to, or perhaps even just changing the Dec 30th price from an FQ price to a manual price
21:10:01 <chris> the dilemma is whether we'd consider the canonical datafile to be incorrect; and whether the report should adapt to it, or the datafile should be scrubbed
21:10:20 <chris> IIRC the F::Q was fixed fairly recently
21:10:27 <chris> to store more reliable datetimes
21:10:27 *** palerider has left #gnucash
21:12:54 <CDB-Man> [2023.04.08 21:10:20] <chris> IIRC the F::Q was fixed fairly recently <-- yes, jralls and i had talked about it in this channel.... back in January or so
22:02:42 *** marek has quit IRC