2017-08-23 GnuCash IRC logs

00:14:15 *** jralls has joined #gnucash
00:17:21 *** jralls has quit IRC
00:22:37 *** bhardwajs has quit IRC
00:26:44 *** bhardwajs has joined #gnucash
00:41:21 *** jralls has joined #gnucash
00:42:46 *** Mechtilde has joined #gnucash
00:44:27 *** jralls has quit IRC
01:01:55 *** mutiny has quit IRC
01:08:27 *** jralls has joined #gnucash
01:11:33 *** jralls has quit IRC
01:27:10 *** jotrago has quit IRC
01:34:42 *** Mechtilde has quit IRC
01:35:36 *** jralls has joined #gnucash
01:38:42 *** jralls has quit IRC
02:02:46 *** jralls has joined #gnucash
02:05:50 *** jralls has quit IRC
02:29:53 *** jralls has joined #gnucash
02:32:57 *** jralls has quit IRC
02:49:58 *** gjanssens has joined #gnucash
02:49:58 *** ChanServ sets mode: +o gjanssens
02:50:25 <gjanssens> .
02:57:13 *** jralls has joined #gnucash
03:00:19 *** jralls has quit IRC
03:18:05 *** jralls has joined #gnucash
03:26:02 *** bhardwajs has quit IRC
03:34:59 *** jralls_ has joined #gnucash
03:35:08 *** jralls has quit IRC
03:43:51 *** jralls_ has quit IRC
03:43:56 *** jralls has joined #gnucash
03:47:54 *** jotrago has joined #gnucash
03:49:17 *** fabior has joined #gnucash
04:06:31 *** jotrago has quit IRC
04:23:23 *** jotrago has joined #gnucash
04:45:08 *** pilotauto has quit IRC
04:46:16 *** jotrago1 has joined #gnucash
04:46:54 *** jotrago has quit IRC
04:46:55 *** jotrago1 is now known as jotrago
05:04:06 *** jotrago has quit IRC
05:07:09 *** jotrago has joined #gnucash
05:11:51 *** storyjesse has joined #gnucash
05:14:55 *** jotrago has quit IRC
05:15:59 *** jotrago has joined #gnucash
05:33:44 *** jralls has quit IRC
06:51:41 *** Jimraehl1 has joined #gnucash
06:52:33 *** fabior has quit IRC
06:53:12 *** Jimraehl1 has left #gnucash
07:20:47 *** storyjesse has quit IRC
07:39:27 *** karelk has quit IRC
07:43:42 *** karelk has joined #gnucash
07:54:22 *** rickoehn has joined #gnucash
08:25:44 *** jotrago1 has joined #gnucash
08:26:14 *** jotrago has quit IRC
08:26:15 *** jotrago1 is now known as jotrago
08:38:19 *** jotrago1 has joined #gnucash
08:38:45 *** jotrago has quit IRC
08:38:46 *** jotrago1 is now known as jotrago
09:02:22 *** User has joined #gnucash
09:22:08 *** User has quit IRC
09:27:08 *** Mechtilde has joined #gnucash
09:32:31 <warlord> .
09:40:51 *** fabior has joined #gnucash
09:49:55 *** Mechtilde has quit IRC
09:51:45 *** jotrago1 has joined #gnucash
09:52:19 *** jotrago has quit IRC
09:52:20 *** jotrago1 is now known as jotrago
10:07:12 *** Mechtilde has joined #gnucash
10:11:38 *** bhardwajs has joined #gnucash
10:12:49 *** Mechtilde has quit IRC
10:31:34 *** mib_st544t has joined #gnucash
10:32:55 *** mib_st544t has quit IRC
10:33:56 *** karelk has quit IRC
10:43:07 *** jotrago has quit IRC
11:08:05 *** KaiForce has joined #gnucash
11:32:47 *** wget has quit IRC
11:34:05 *** wget has joined #gnucash
12:08:09 *** Cuare has joined #gnucash
12:09:50 *** ArtGravity has joined #gnucash
12:23:57 *** Cuare has quit IRC
12:32:14 *** Mechtilde has joined #gnucash
12:42:29 *** karelk has joined #gnucash
12:49:13 *** bhardwajs has quit IRC
13:07:07 *** Cuare has joined #gnucash
13:23:40 *** jotrago has joined #gnucash
14:10:22 <jonas> Interesting, looks like with the latest master, I can have 8 decimals without truncation..as long as I use the sqlite3 backend
14:10:31 <jonas> if I try the same thing with xml, it gets truncated
14:12:51 *** tuxd00d has quit IRC
14:21:55 *** frakturfreak has joined #gnucash
14:41:02 *** fabior has quit IRC
14:42:34 *** Mechtilde has quit IRC
15:25:02 <jonas> obvious solution, save my existing xml workbook as sqlite3
15:25:50 <jonas> outcome, all existing and new accounts using a currency with 8 decimals only allow 2 decimals in the converted workbook :(
15:26:22 <jonas> works just fine in a new one though, but I don't know how to import all those transactions
15:36:04 <jonas> looking at the database, whenever I input a value in one of the accounts set to a 8 decimal currency, it gets truncated to 2 decimals and the row for that commodity gets updated in the commodities sqlite table from a fraction of 100000000 to 100
15:43:26 <warlord> It sounds like some other piece of data (like a SCU) isn't properly getting migrated to SQL.
15:44:19 <jonas> I'm not sure what an SCU is, I can't find a table that seems to match that?
15:46:34 <jonas> I tried setting the fraction to 3 decimals instead of 8 decimals, and in that case it doesn't get changed back to 2 decimals
15:49:49 <jonas> same if I set it to 6 decimals, doesn't truncate then either
15:58:26 *** jralls has joined #gnucash
15:59:05 *** ChanServ sets mode: +o jralls
16:00:36 <jralls> jonas: SCU is "smallest currency unit", which is a bit of a misnomer because it's really the largest denominator allowed for the commodity.For most currencies it's 100, though for many it's 1.
16:04:09 <jralls> Many crypto currencies use 10^9, and GnuCash 2.6 and earlier's rational calculations aren't able to handle that in all cases without unacceptable rounding so it's been capped at 10^6.
16:06:07 <jralls> While the number system has been upgraded to safely handle computations with a max denominator of 10^10, and the SQL backend has been rewritten and also supports it, there are a bunch of places where there are hard-coded 10^6 denominators or "sigfig-6" rounding. Those all need to be cleaned up before we can release 2.8.
16:07:04 <jralls> If you want to help test it would be great if you can file bug reports that document places where you find that a denominator > 10^6 doesn't work right.
16:39:38 *** gjanssens has quit IRC
16:57:43 *** jralls_ has joined #gnucash
16:58:14 *** jralls has quit IRC
17:02:46 *** frakturfreak has quit IRC
17:04:38 *** jralls has joined #gnucash
17:04:39 *** jralls_ has quit IRC
17:27:07 *** tuxd00d has joined #gnucash
17:46:44 *** jralls has quit IRC
17:49:34 *** jralls has joined #gnucash
17:55:08 *** rickoehn has quit IRC
17:59:56 <jonas> ah
18:01:13 <jonas> in that case the SCU is set to the right value(10^8) in the commodities sqlite table, but ends up reset to 10^2 whenever I enter a new transaction using that currency
18:01:28 <jonas> I'll putz around a bit with it and produce a test case if I can't resolve it
18:02:14 <jralls> jonas: Bear in mind that the SCU of the other currency might be coming into play.
18:02:44 <jonas> the one being converted to/from?
18:03:25 <jonas> in this case it seems to happen when I use an old workbook that has been migrated from old version and saved to sqlite instead of xml, but when I try the same thing using a newly created workbook it works well
18:03:40 <jralls> Yes. It depends on which account you start the transaction from: That account's currency becomes the transaction currency and the exchange rate is in terms of the transaction currency.
18:03:54 <jonas> interesting
18:05:06 <jralls> Is the resulting number of decimals correct when you save but incorrect when you close the file (maybe by quitting GnuCash) and reopen it (maybe by starting GnuCash back up)?
18:05:35 <jonas> it is correct when I save and close, incorrect when I reopen the file
18:06:13 <jralls> OK, then there's something going on in the XML backend. Please file a bug.
18:15:04 <jonas> easy to reproduce, lemme write it up
18:22:37 <jralls> Bedtime. Good Night.
18:22:45 *** jralls has quit IRC
18:31:53 <jonas> night
18:31:56 <jonas> also here it is: https://bugzilla.gnome.org/show_bug.cgi?id=786708
18:36:54 *** pilotauto has joined #gnucash
23:00:29 *** storyjesse has joined #gnucash
23:07:04 *** tuxd00d has quit IRC
23:09:13 *** tuxd00d has joined #gnucash
23:16:43 *** ArtGravity has quit IRC