2019-11-25 GnuCash IRC logs
00:15:53 *** Gerd has quit IRC
00:29:53 *** Mechtilde has joined #gnucash
00:30:54 *** fell has quit IRC
00:32:20 *** Gerd has joined #gnucash
00:54:50 *** Gerd has quit IRC
01:00:39 *** fell has joined #gnucash
01:00:39 *** ChanServ sets mode: +o fell
01:03:13 *** frakturfreak has quit IRC
01:11:26 *** Gerd has joined #gnucash
01:12:28 *** omnireq_ has joined #gnucash
01:13:41 *** omnireq has quit IRC
01:24:04 *** Mechtilde has quit IRC
01:24:27 *** Mechtilde has joined #gnucash
01:27:29 *** Mechtilde has quit IRC
01:33:09 *** pohly1 has joined #gnucash
01:36:56 *** fell_laptop has joined #gnucash
01:36:57 *** ChanServ sets mode: +o fell_laptop
01:38:39 *** fell has quit IRC
01:38:59 *** Gerd has quit IRC
01:45:09 *** Mechtilde has joined #gnucash
01:49:05 *** Mechtilde has quit IRC
02:03:22 *** avma has joined #gnucash
02:10:42 *** fell_laptop has quit IRC
02:29:16 *** bertbob has quit IRC
02:30:30 *** bertbob has joined #gnucash
02:30:31 *** ChanServ sets mode: +v bertbob
02:33:33 *** bertbob has quit IRC
02:41:32 *** bertbob has joined #gnucash
02:41:33 *** ChanServ sets mode: +v bertbob
02:43:16 *** omnireq_ has quit IRC
02:43:26 *** omnireq_ has joined #gnucash
02:51:25 *** sbluhm has joined #gnucash
02:51:26 *** ChanServ sets mode: +v sbluhm
02:52:19 *** bertbob has quit IRC
02:52:32 *** fell_laptop has joined #gnucash
02:52:32 *** ChanServ sets mode: +o fell_laptop
02:57:31 *** bertbob has joined #gnucash
02:57:32 *** ChanServ sets mode: +v bertbob
03:01:11 *** sbluhm has quit IRC
03:17:58 *** sbluhm has joined #gnucash
03:25:46 *** omnireq_ has quit IRC
03:26:38 *** omnireq has joined #gnucash
03:26:39 *** ChanServ sets mode: +v omnireq
03:47:46 *** omnireq has quit IRC
03:47:56 *** omnireq has joined #gnucash
03:47:56 *** ChanServ sets mode: +v omnireq
03:54:32 *** fell_laptop has quit IRC
04:08:46 *** omnireq has quit IRC
04:08:57 *** omnireq has joined #gnucash
04:08:58 *** ChanServ sets mode: +v omnireq
04:12:07 <avma> hi, can anyone help with an sql issue?
04:24:34 *** Mechtilde has joined #gnucash
04:52:01 *** ChanServ sets mode: +v avma
04:59:24 <avma> can anyone help with an SQL issue?
05:07:24 <Mechtilde> avma, what is your problem?
05:13:14 <avma> I'm trying to create a report that combines bills line item and vendor names
05:14:23 <avma> the problem is that not all vendors are showing in the report, some time names are blank
05:15:20 <avma> SELECT
05:15:20 <avma> bill,invoices.guid AS inv_guid,invoices.owner_guid,vendors.guid AS vend_guid,invoices.id,vendors.name,owner_type,
05:15:20 <avma> date,description,(quantity_num/quantity_denom) AS 'Bill Quantity',
05:15:20 <avma> (b_price_num/b_price_denom) AS 'Uint Cost'
05:15:20 <avma> FROM
05:15:22 <avma> entries
05:15:24 <avma>
05:15:26 <avma> JOIN invoices ON invoices.guid = bill
05:15:28 <avma> left JOIN vendors ON vendors.guid = invoices.owner_guid
05:29:39 *** misterwhatever has joined #gnucash
05:29:58 *** Mechtilde has quit IRC
05:30:44 *** biomanu has joined #gnucash
05:30:44 *** ChanServ sets mode: +v biomanu
05:35:16 *** misterwhatever has quit IRC
05:38:41 *** KevinDB has quit IRC
05:39:59 *** KevinDB has joined #gnucash
05:40:00 *** ChanServ sets mode: +v KevinDB
05:53:01 <chris> ninja checking maint->master. if everything's fine i'll push.
06:07:26 *** biomanu has quit IRC
06:26:57 *** mahmoud has joined #gnucash
06:35:46 *** biomanu has joined #gnucash
06:35:46 *** ChanServ sets mode: +v biomanu
06:46:12 *** misterwhatever has joined #gnucash
07:08:13 *** KevinDB has quit IRC
07:09:20 *** JayC has quit IRC
07:09:31 *** KevinDB has joined #gnucash
07:09:32 *** ChanServ sets mode: +v KevinDB
07:29:38 *** oozer has joined #gnucash
07:31:16 *** omnireq has quit IRC
07:31:26 *** omnireq has joined #gnucash
07:31:27 *** ChanServ sets mode: +v omnireq
07:39:10 *** Mechtilde has joined #gnucash
07:42:16 <chris> jralls I think I should really maintain a
07:42:36 <chris> 'Changelog' to describe notable fixes/report highlights
07:47:49 <chris> avma you're better off waiting for jralls, I don't use sql
07:49:31 <avma> ok thanks Chris
07:52:00 <chris> fell your dupe report is probably a remnant of future-scheduled-txn-summary, sx-summary.scm, now deleted and merged onto account-summary.scm. clean up your build dir.
07:52:20 <chris> @tell fell your dupe report is probably a remnant of future-scheduled-txn-summary, sx-summary.scm, now deleted and merged onto account-summary.scm. clean up your build/installdir/cache.
07:52:20 <gncbot> chris: The operation succeeded.
08:07:10 <chris> balsheet-pnl.scm getting more clever every time :)
08:13:46 *** omnireq has quit IRC
08:14:01 *** omnireq has joined #gnucash
08:14:02 *** ChanServ sets mode: +v omnireq
08:29:23 *** misterwhatever has quit IRC
08:29:39 *** JayC has joined #gnucash
08:29:40 *** ChanServ sets mode: +v JayC
08:41:42 *** oozer has quit IRC
08:46:34 *** warlord has quit IRC
09:00:09 *** jervin has joined #gnucash
09:02:45 *** jervin has quit IRC
09:09:37 *** mauritslamers has quit IRC
09:09:46 *** Mechtilde has quit IRC
09:10:03 *** Mechtilde has joined #gnucash
09:15:43 *** Gerd has joined #gnucash
09:25:39 *** warlord has joined #gnucash
09:27:36 *** warlord has quit IRC
09:27:39 *** warlord has joined #gnucash
09:36:16 *** omnireq has quit IRC
09:36:27 *** omnireq has joined #gnucash
09:36:28 *** ChanServ sets mode: +v omnireq
09:36:43 *** jervin has joined #gnucash
09:43:05 *** avma has quit IRC
09:57:16 *** omnireq has quit IRC
09:57:27 *** omnireq has joined #gnucash
09:57:28 *** ChanServ sets mode: +v omnireq
10:01:52 *** kael has joined #gnucash
10:01:53 *** ChanServ sets mode: +v kael
10:18:16 *** omnireq has quit IRC
10:18:27 *** omnireq has joined #gnucash
10:18:29 *** ChanServ sets mode: +v omnireq
10:23:13 *** sbluhm has quit IRC
10:23:13 *** jervin has quit IRC
10:23:19 *** jervin has joined #gnucash
10:25:00 *** omnireq has quit IRC
10:31:51 *** fell_laptop has joined #gnucash
10:31:51 *** ChanServ sets mode: +o fell_laptop
10:40:33 *** sbluhm has joined #gnucash
10:40:33 *** ChanServ sets mode: +v sbluhm
11:06:04 *** sbluhm has quit IRC
11:06:39 *** jervin1 has joined #gnucash
11:06:52 *** Gerd has quit IRC
11:07:03 *** jervin has quit IRC
11:07:03 *** jervin1 is now known as jervin
11:10:42 *** omnireq has joined #gnucash
11:10:42 *** ChanServ sets mode: +v omnireq
11:26:16 *** Mechtilde has quit IRC
11:28:32 *** calvinct has joined #gnucash
11:28:53 *** bertbob has quit IRC
11:33:14 *** oozer has joined #gnucash
11:42:55 *** calvinct has quit IRC
11:43:26 *** calvinct has joined #gnucash
11:44:14 *** bertbob has joined #gnucash
11:44:15 *** ChanServ sets mode: +v bertbob
11:49:06 *** calvinct has quit IRC
11:49:20 *** calvinct has joined #gnucash
11:53:58 *** guak has joined #gnucash
11:56:58 *** bertbob has quit IRC
12:05:28 *** bertbob has joined #gnucash
12:05:29 *** ChanServ sets mode: +v bertbob
12:06:06 *** jervin has quit IRC
12:23:18 *** omnireq has quit IRC
12:24:35 *** omnireq has joined #gnucash
12:24:35 *** ChanServ sets mode: +v omnireq
12:28:18 *** Mechtilde has joined #gnucash
12:30:16 *** omnireq_ has joined #gnucash
12:31:29 *** omnireq has quit IRC
12:35:00 *** Gerd has joined #gnucash
12:37:15 *** kael has quit IRC
12:53:26 *** KevinDB has quit IRC
12:54:53 *** KevinDB has joined #gnucash
12:54:53 *** ChanServ sets mode: +v KevinDB
13:04:16 *** jervin has joined #gnucash
13:04:47 *** sbluhm has joined #gnucash
13:04:47 *** ChanServ sets mode: +v sbluhm
13:08:48 *** omnireq__ has joined #gnucash
13:09:59 *** omnireq_ has quit IRC
13:12:20 *** biomanu has quit IRC
13:25:04 *** jervin has quit IRC
13:26:03 *** calvinct has quit IRC
13:27:00 *** calvinct has joined #gnucash
13:42:10 *** phebus has joined #gnucash
13:42:10 *** ChanServ sets mode: +v phebus
13:42:27 *** fell_laptop has quit IRC
13:46:04 *** fell has joined #gnucash
13:46:04 *** ChanServ sets mode: +o fell
13:47:14 <fell> .
13:47:14 <gncbot> fell: Sent 16 hours and 55 minutes ago: <warlord> Hahaha.. Glad they got it working.
13:47:15 <gncbot> fell: Sent 5 hours and 54 minutes ago: <chris> your dupe report is probably a remnant of future-scheduled-txn-summary, sx-summary.scm, now deleted and merged onto account-summary.scm. clean up your build/installdir/cache.
13:48:25 <fell> chris: yes, after ninja clean they were gone.
13:49:31 *** calvinct has quit IRC
13:53:14 *** Gerd has quit IRC
14:03:11 <jralls> @tell avma I don't have a well-populated business database to test against, but your query looks sane (though for clarity owner_type should be invoices.owner_type). You say that not all vendor.name entries are populated, but what about vend_guid? Is owner_type always 4?
14:03:11 <gncbot> jralls: The operation succeeded.
14:15:51 *** gjanssens has joined #gnucash
14:15:51 *** ChanServ sets mode: +o gjanssens
14:16:03 *** gjanssens sets mode: +o gncbot
14:29:22 *** Gerd has joined #gnucash
14:52:04 *** frakturfreak has joined #gnucash
14:52:05 *** ChanServ sets mode: +v frakturfreak
14:53:48 <gjanssens> .
14:56:40 *** Gerd has quit IRC
15:02:22 <gjanssens> fell: IIRC the change from ISO4217 to CURRENCY was done for consistency.
15:03:07 <gjanssens> The sql backend has been writing CURRENCY since its inception. The xml backend was writing ISO4217.
15:04:00 <gjanssens> Based on the comments in the xml code ISO4217 was used as a compatibility hack with gnucash 1.8. As we're long past supporting that version I decided it was time for a cleanup.
15:04:28 <fell> gjanssens: From my understanding CURRENCY was the name for something not very well designed in version <1.8
15:04:36 <gjanssens> Modern gnucash still understands ISO4217, but won't write it out to file/db itself
15:04:47 *** sbluhm has quit IRC
15:05:16 <gjanssens> Perhaps, I was not involved in the gnucash project yet back then.
15:05:38 <gjanssens> I merely followed the suggestions I found in the codebase.
15:05:47 <fell> That old CURRENCY git replaced by the well defined ISO4217 in 1.8
15:06:06 <fell> I fear you misread it.
15:07:08 <gjanssens> No, I did not misread it. The comment clearly says writing ISO4217 was compat mode for 1.8
15:07:44 *** fabior has joined #gnucash
15:07:56 <gjanssens> https://github.com/Gnucash/gnucash/commit/f3eeda3a9e8e27dc982f070836b63d88ae79a3ed#diff-386a8b6d9b8ffbe451041bde1589e72aL343
15:08:06 *** sbluhm has joined #gnucash
15:08:06 *** ChanServ sets mode: +v sbluhm
15:08:11 <jralls> IIRC we discussed it here at the time.
15:08:56 *** misterwhatever has joined #gnucash
15:09:03 <gjanssens> We did indeed
15:12:49 <fell> On the whole 2.x series, the we wrote ISO4217 in the files as also all templates are.
15:13:17 <gjanssens> https://lists.gnucash.org/logs/2017/05/04.html#T12:22:39
15:13:52 <gjanssens> fell: as the old discussion shows, internally gnucash has been using CURRENCY as namespace for a very long time
15:14:17 <gjanssens> It was only in the xml backend that this internal name was converted to ISO4217 for backwards compatibility
15:14:41 <gjanssens> The xml backend has equally been able to load files with the CURRENCY namespace for a very long time
15:15:01 <gjanssens> So again, my change was to bring consistency and use only one namespace.
15:15:13 <fell> ISO is a well defined standard, currency is something very vagely.
15:15:19 <gjanssens> As most of the code had alreade settled for CURRENCY, that's what I went for
15:16:00 <gjanssens> Honestly I don't think that matters much. It's just a name to refer to internally.
15:16:16 <fell> At the beginning of 2.x there only XML, no other backends
15:16:36 <gjanssens> It's not exposed to users via the gui, and I would think most users would find ISO4217 te be pretty cryptic.
15:17:03 <gjanssens> s/te/to/
15:17:26 <jralls> It's just a symbol in the code. Any human-language meaning is peripheral.
15:18:15 <fell> I could imagine in a few years it get replaced by a new stadard, which include crypo currencies and then you will have to do the 1.8 hack again.
15:19:24 <gjanssens> I don't see why we would have to change our namespace for that ? CURRENCY would actually fit better, as that allows us to simply tuck another standard behind it
15:19:59 <gjanssens> The "iso" bit in our code is afaict limited to the xml file defining the currencies, which currently is restricted to ISO4217 currencies
15:20:16 <fell> Because the symbols then would have a different meaning
15:20:56 <jralls> ISO doesn't work that way.
15:20:56 <fell> They may be 4 Letters long or whatever.
15:21:17 <gjanssens> I think you're giving much more meaning to the symbol that it deserves
15:22:12 *** calvinct has joined #gnucash
15:22:13 <gjanssens> We expose a number of predefined currencies to the user. Currently that happens to be the ISO4217 currencies
15:22:56 <gjanssens> Rereading your comment, so you would think that when a new currencies standard comes it EUR could suddenly mean something different in the new standard ?
15:23:34 <gjanssens> And that such an ISO goof would have been the reason the gnucash devs had to choose a different namespace for currencies ?
15:24:38 <gjanssens> (Back in the 1.8 days I mean)
15:26:42 <fell> Some people think $ is a currency symbol, but it is not unique.
15:26:58 <fell> Then there was the C$ hack, ...
15:27:45 *** calvinct has quit IRC
15:27:47 <gjanssens> True, still a not fully solved issue. But what does that have to do with a namespace name ?
15:28:30 <jralls> '$' is a currency symbol. It's just used for lots of different currencies. That's in part why the ISO 4217 committee was formed *40 years ago* to create a standard set of symbols for data interchange.
15:29:01 *** rpg has joined #gnucash
15:29:24 *** kapip has quit IRC
15:29:31 <jralls> That standard is now in use world-wide. Changing it would be enormously disruptive. It's darn near impossible that the committee would change the format.
15:29:39 <rpg> I seem to have accidentally deleted my gnucash database. I have hourly snapshot backups but ... where is the SQL data?
15:30:00 <jralls> rpg: Depends. What backend are you using?
15:30:23 *** calvinct has joined #gnucash
15:30:39 <rpg> I'm on a Mac, and TBH I don't know which backend I'm using -- used to be XML but at some point that was deprecated on the Mac and I was auto-switched.
15:31:30 <jralls> rpg: Not true. There is no auto-switch and the XML backend is still the default.
15:31:48 <rpg> @jralls: Wouldn't that be a `.gnucash` file, then?
15:31:48 <gncbot> rpg: Error: "jralls:" is not a valid command.
15:31:53 <rpg> jralls: Wouldn't that be a `.gnucash` file, then?
15:32:35 *** fell has quit IRC
15:32:55 *** fell has joined #gnucash
15:32:55 *** ChanServ sets mode: +o fell
15:33:04 <fell> A namespace currency would allow a symbol "$", but in ISO 4217 it is USD, CAD , ...
15:33:05 <jralls> rpg: A .gnucash file can be either XML or SQLite3. If it's XML, `file foo.gnucash` will tell you that it's a GnuCash file; if it's SQLite3 it will tell you that it's a SQLite3 database.
15:33:24 <jralls> fell: Where is that code?
15:34:05 <rpg> jralls: My log files are all in ~/personal/finance, which is where I thought my database was, but apparently it's no longer there.
15:34:11 <fell> That is not from code, but theory
15:35:23 *** fabior has quit IRC
15:35:45 <gjanssens> fell: as I wrote in the old conversation if we ever add code to allow a user-defined currency namespace, I would not call it "CURRENCY", exactly because that would clash with older versions of gnucash which internally have been using CURRENCY for ages as the namespace name
15:35:48 <jralls> fell: From your imagination, you mean. CURRENCY is a symbol in code. The code defines what it means. Period.
15:36:43 <gjanssens> That user-defined namespace would be something completely new, like USER_CURRENCY or whatever
15:37:20 <gjanssens> And even in that namespace symbols will have to be uniqe. So at best the user could use "$" exactly once as symbol
15:38:29 <gjanssens> short-hand symbols could be duplicate though if the user wishes to do so. But that would cause quite some confusion so I don't think many users would want that.
15:39:39 <gjanssens> (we call those local symbols in code)
15:40:54 *** omnireq__ has quit IRC
15:41:21 <gjanssens> Anyway, I'm leaving it at that for tonight. It'll be a busy day tomorrow so I'm off to bed early.
15:41:22 <rpg> jralls: The latest gnucash.gnucash file in my backup is listed as last modified in August 2018. Does that make sense? I made transactions last night...
15:41:25 <gjanssens> Good night all!
15:41:43 <jralls> Good night gjanssens.
15:42:04 *** gjanssens has quit IRC
15:42:23 *** calvinct has quit IRC
15:42:45 *** calvinct has joined #gnucash
15:43:02 <jralls> rpg: Sounds like your GnuCash file isn't where you think it is.
15:43:17 <rpg> jralls: Agreed. But I don't know where to look for it.
15:43:48 <rpg> Seems like there should be some config file or *something* that would say where Gnucash was looking for it.
15:48:14 *** omnireq has joined #gnucash
15:49:42 <jralls> Yeah, it's in defaults. Try `defaults read org.gnucash.Gnucash | grep history`
15:50:12 <warlord> rpg, have you tried the Recent Files list?
15:50:52 *** sbluhm has quit IRC
15:51:05 *** omnireq_ has joined #gnucash
15:51:16 <rpg> jralls: Unfortunately, all the entries there are /org/gnucash/history/fileN = "";
15:51:48 *** omnireq has quit IRC
15:53:14 <rpg> warlord: It won't be in the Recent Files list, I don't think, because whatever it was, it deleted when I removed some subdirectories from a directory copied from my old laptop. Somehow it seems like I was loading it from somewhere in this `~/old/` directory, but I don't know where (or why).
15:54:31 <jralls> rpg: And I guess ~/old isn't in your TimeMachine config. You may be screwed.
15:56:12 <jralls> If the file history in defaults is empty you must have tried opening GnuCash > 9 times since deleting the directory. Is ~/Library/Preferences in your TimeMachine config?
15:56:26 <rpg> jralls: No, it *is* in my Time Machine config but... I don't know where to look in it. Library personal/finance?
15:57:24 <rpg> Whew! Thanks -- I got it back. It was in a subdirectory of finance.
15:57:30 <rpg> Thanks for all the help.
15:57:35 <jralls> Yay.
15:58:07 *** omnireq__ has joined #gnucash
15:58:56 <jralls> For additional insurance consider saving it periodically to an offsite service like Google Drive or Dropbox. I keep mine in an encrypted dmg for extra security.
15:59:02 <rpg> I'm not sure what I did that triggered the problem -- somehow perturbing this old directory caused the new one to be affected. Such a relief to have it back, and worth all the money paid for Time Machine...
15:59:18 *** omnireq_ has quit IRC
15:59:52 <rpg> jralls: Thanks, I save my drive here with snapshots on Time Machine and keep an encrypted hard drive back up at my office in case of fire, disk failure, electrical power surge, etc.
16:00:08 <rpg> But an encrypted back up in the cloud sounds like another good idea.
16:00:19 *** ArtGravity has joined #gnucash
16:00:19 *** ChanServ sets mode: +v ArtGravity
16:00:47 <jralls> LOCKSS -- Lots of Copies Keeps Stuff Safe. ;-)
16:01:39 *** calvinct has quit IRC
16:01:50 <jralls> The nice thing about the better services is that they do that too, replicating your data across multiple data centers.
16:27:18 *** Mechtilde has quit IRC
16:36:57 *** Gerd has joined #gnucash
16:40:50 *** KevinDB has quit IRC
16:42:18 *** KevinDB has joined #gnucash
16:42:18 *** ChanServ sets mode: +v KevinDB
16:55:21 *** pohly1 has quit IRC
17:05:20 *** guak has quit IRC
17:47:46 *** guak has joined #gnucash
17:47:55 *** warlord has quit IRC
17:53:23 *** calvinct has joined #gnucash
17:54:50 *** Gerd has quit IRC
17:58:37 *** kael has joined #gnucash
17:58:37 *** ChanServ sets mode: +v kael
17:59:24 *** leolein has joined #gnucash
18:02:13 *** ChanServ sets mode: +v leolein
18:15:59 *** calvinct has quit IRC
18:22:37 *** ArtGravity has quit IRC
18:32:37 *** kael has quit IRC
18:41:11 *** frakturfreak has quit IRC
18:55:48 *** frakturfreak has joined #gnucash
19:12:09 *** warlord has joined #gnucash
19:13:40 *** Simon has quit IRC
19:22:23 *** Simon has joined #gnucash
19:22:23 *** ChanServ sets mode: +v Simon
19:31:03 *** omnireq__ has quit IRC
19:42:43 *** oozer has quit IRC
19:48:42 *** rpg has quit IRC
20:29:31 *** guak has quit IRC
20:34:26 *** omnireq has joined #gnucash
21:08:53 *** frakturfreak has quit IRC
21:22:45 *** frakturfreak has joined #gnucash
21:22:45 *** ChanServ sets mode: +v frakturfreak
21:45:15 *** misterwhatever has quit IRC
21:53:45 *** kapip has joined #gnucash
21:55:16 *** Guest23 has joined #gnucash
22:46:41 *** Guest23 has quit IRC
22:59:42 *** oliver has quit IRC
23:01:24 *** oliver has joined #gnucash
23:12:08 *** omnireq_ has joined #gnucash
23:13:20 *** omnireq has quit IRC
23:31:25 *** omnireq_ has quit IRC
23:33:01 *** omnireq_ has joined #gnucash
23:38:53 *** Gerd has joined #gnucash
23:53:55 *** omnireq_ has quit IRC
23:54:45 *** omnireq_ has joined #gnucash