2018-04-09 GnuCash IRC logs

00:06:25 *** marusich has joined #gnucash
00:30:33 *** boldstripe has quit IRC
00:45:41 *** pilotauto has quit IRC
00:51:28 *** gour has joined #gnucash
00:53:22 *** storyjesse has joined #gnucash
00:57:46 *** Mechtilde has joined #gnucash
01:09:41 *** josephcocoa has quit IRC
01:26:12 *** Mechtilde has quit IRC
01:40:57 *** marusich has quit IRC
01:42:00 <gour> morning
01:43:54 *** fell has quit IRC
01:45:03 *** fell has joined #gnucash
01:45:24 *** gncbot sets mode: +o fell
01:45:51 <gour> i've several years of GC data ending sometime in the Dec 2017 when i migrated to (h)ledger. now i'd like to return back to GC and have 2.1M CSV file exported from hledger containing all the data. what would be the most smooth way to be up-to-date in GC? does CSV importer in 3.0 allow importing txns for all accounts or is it per account only as it is the case, afaict, in 2.6?
01:47:11 <fell> gour, IIRC you will need 1 file per currency.
01:48:27 <gour> fell: ok, that's great, i do not track so many, only three, but how to import, should i use new tree of accounts, importing into existing one...?
01:49:32 <fell> In a new file or your existing?
01:50:07 <gour> yes
01:50:38 <fell> yes for new or existing?
01:51:09 <gour> i wonder what's easier?
01:51:50 <gour> existing file covers up to ~20th Dec 2017, should i import just the difference or everything from the scratch?
01:51:57 <fell> In a new Bayes would have to relearn everything.
01:54:16 <gour> i'm more concerned to have everything up-to-date quickly...hopefully Bayes will catch up soon :-)
01:56:11 <fell> To train Bayes, I would import 1. accounts (and categories) 2. one month to train Bayes, the one Year to train Bayes, then the rest.
02:01:41 <gour> hmmm...then i should maybe import just the difference in order not to lose old Bayes?
02:49:10 *** fabior has joined #gnucash
03:16:15 *** shoonya has quit IRC
03:18:08 *** fekepp has joined #gnucash
03:58:52 *** harshitaneja has joined #gnucash
04:03:26 <fell> gour: If you were happy with your file before, that would be easier.
04:25:28 *** gour has quit IRC
04:40:37 *** bob_ has joined #gnucash
04:42:49 *** gour has joined #gnucash
04:43:25 *** fekepp1 has joined #gnucash
04:43:33 *** fekepp has quit IRC
04:43:34 *** fekepp1 is now known as fekepp
04:54:15 *** fekepp has quit IRC
04:54:52 *** fekepp has joined #gnucash
04:56:02 *** ncv_ has joined #gnucash
05:07:15 *** fekepp has quit IRC
05:07:17 *** fekepp has joined #gnucash
05:15:24 *** fekepp has quit IRC
05:30:52 *** fekepp has joined #gnucash
05:33:28 *** bob_ has quit IRC
05:53:08 *** bob_ has joined #gnucash
06:26:52 *** oozer has joined #gnucash
06:44:38 *** bertbob has quit IRC
06:45:54 *** puck has quit IRC
06:46:26 *** fabior has quit IRC
06:49:03 *** puck has joined #gnucash
07:03:41 *** bob_ has quit IRC
07:06:35 *** warlord has quit IRC
07:09:08 *** bob_ has joined #gnucash
07:16:12 *** fell has quit IRC
07:19:49 *** bob_ has quit IRC
07:51:51 *** boldstripe has joined #gnucash
07:52:10 *** NestorZ has joined #gnucash
07:52:11 *** fell has joined #gnucash
07:52:11 *** gncbot sets mode: +o fell
08:00:33 *** Robert847 has joined #gnucash
08:05:19 *** Robert847 has left #gnucash
08:07:34 *** hoijui__ has joined #gnucash
08:22:42 *** tlvince has joined #gnucash
08:37:25 *** boldstripe has quit IRC
08:38:26 *** boldstripe has joined #gnucash
08:45:09 *** tlvince has quit IRC
08:55:02 *** benoitg has joined #gnucash
09:05:19 *** Robert847 has joined #gnucash
09:05:28 *** Robert847 has left #gnucash
09:09:36 *** kael has joined #gnucash
09:11:09 *** storyjesse has quit IRC
09:11:17 *** storyjesse has joined #gnucash
09:19:34 *** fabior has joined #gnucash
09:47:05 *** bertbob has joined #gnucash
09:55:04 *** hoijui__ has quit IRC
10:05:22 *** fekepp has quit IRC
10:17:02 *** tuxd00d has quit IRC
10:52:15 *** bertbob has quit IRC
10:54:11 *** ArtGravity has joined #gnucash
11:02:37 *** tuxd00d has joined #gnucash
11:08:22 *** bertbob has joined #gnucash
11:13:11 *** storyjesse has quit IRC
11:15:55 *** oozer has quit IRC
11:38:05 *** Mechtilde has joined #gnucash
11:41:24 *** marco82 has joined #gnucash
11:42:33 <fell> jralls, we got reports on gnucash-de, some crashed are caused if saved-reports contain umlauts - non-ASCII-characters.
11:46:26 *** marco82 has quit IRC
12:06:44 *** kael has quit IRC
12:13:54 *** bob_ has joined #gnucash
12:14:31 *** kael has joined #gnucash
12:19:51 *** fabior has quit IRC
12:29:47 <jralls> fell: Thanks, that's a good clue.
12:34:25 *** fabior has joined #gnucash
12:40:47 *** kael has quit IRC
12:42:54 *** bob_ has quit IRC
12:59:12 *** NestorZ has quit IRC
13:05:14 *** NestorZ has joined #gnucash
13:08:10 <gour> dead link (https://github.com/Gnucash/gnucash/blob/master/src/report/utility-reports/hello-world.scm) referenced here: https://wiki.gnucash.org/wiki/Custom_Reports#hello-world_report
13:12:10 *** oozer has joined #gnucash
13:13:35 *** kael has joined #gnucash
13:18:57 *** ncv_ has quit IRC
13:24:06 *** marco82 has joined #gnucash
13:30:32 *** Mechtilde has quit IRC
13:30:45 *** Mechtilde has joined #gnucash
13:31:55 *** hoijui__ has joined #gnucash
13:32:22 *** fabior has quit IRC
13:44:58 *** tonysoar has joined #gnucash
13:45:43 *** tonysoar has quit IRC
13:45:53 *** fekepp has joined #gnucash
13:52:15 *** boldstripe has quit IRC
13:56:37 *** tonysoar has joined #gnucash
13:57:33 *** tonysoar has quit IRC
13:58:58 <fell> gour fixed
14:02:58 <gour> ;)
14:04:43 *** benoitg has quit IRC
14:06:13 *** Robert847 has joined #gnucash
14:06:17 *** Robert847 has left #gnucash
14:08:46 *** benoitg has joined #gnucash
14:14:34 *** benoitg has quit IRC
14:16:35 *** warlord has joined #gnucash
14:20:00 *** Mechtilde has quit IRC
14:23:54 *** yogidave has joined #gnucash
14:26:06 *** yogidave has quit IRC
14:28:58 *** benoitg has joined #gnucash
14:29:38 *** benoitg has quit IRC
14:37:25 *** gjanssens has joined #gnucash
14:37:25 *** ChanServ sets mode: +o gjanssens
14:38:46 <gjanssens> .
14:39:04 *** gjanssens is now known as gjanssens_afk
14:40:15 *** kael has quit IRC
14:43:46 *** frakturfreak has joined #gnucash
14:49:30 *** kael has joined #gnucash
15:09:54 *** boldstripe has joined #gnucash
15:12:57 *** kael has quit IRC
15:13:06 *** boldstripe_ has joined #gnucash
15:13:25 *** boldstripe has quit IRC
15:13:25 *** boldstripe_ is now known as boldstripe
15:19:22 *** fabior has joined #gnucash
15:24:04 <jralls> gjanssens_afk: I'm holding off doing the branch shuffle (maint->2.6, unstable->maint) until you say you're ready.
15:24:15 <jralls> gjanssens_afk: And there's no rush.
15:32:18 *** hoijui__ has quit IRC
15:36:23 *** kael has joined #gnucash
15:43:10 *** harshitaneja has quit IRC
15:43:48 *** harshitaneja has joined #gnucash
15:45:40 *** ncv_ has joined #gnucash
15:47:42 *** harshitaneja has quit IRC
15:48:19 *** harshitaneja has joined #gnucash
15:51:53 *** ncv_ has quit IRC
16:15:10 *** kael has quit IRC
16:35:53 *** marco82 has left #gnucash
16:37:02 *** frakturfreak has quit IRC
16:45:57 *** fabior has quit IRC
16:53:08 *** warlord has quit IRC
16:54:23 *** gjanssens_afk is now known as gjanssens
16:55:03 <gjanssens> jralls: It's good you are holding off on shuffling branches. That gives me some time to discuss it with you
16:55:22 <gjanssens> While I was away I have been thinking about this
16:55:23 <jralls> Yes, that's the idea.
16:55:28 <jralls> Uh-oh.
16:55:31 <jralls> ;-)
16:55:34 <gjanssens> :D
16:55:47 *** gour has quit IRC
16:56:15 <gjanssens> One question I got is this: what's the benefit of a 2.6 branch if we will no longer develop on it ?
16:56:42 <gjanssens> The release tags themselves do indicate from which branch they came, right ?
16:57:54 <jralls> True. I need to re-read the docs about garbage collection go. ISTR that commits that don't lead to a HEAD get culled.
16:58:28 <jralls> s/go/though/
16:58:56 <gjanssens> Oh right. That would have been important for our svn based releases as they would end up on separate branches
16:59:28 <gjanssens> However the git based release are all on maint/unstable and those get merged into master, which continues to exist
17:00:01 <gjanssens> releases*
17:02:40 <jralls> I'm wrong, anything with a reference, including a tag, is preserved. So we can just delete branch maint (and the other old branches) and rename unstable to maint.
17:05:50 <jralls> Well, the other thing we need to talk about is whether we should release 2.6.21. There are two big problems: The two-query SQL statement in numtest chokes MariaDB, and there are a bunch of Python files left out of the tarball because I fixed it on unstable instead of maint.
17:06:49 <jralls> I wouldn't merge either of those changes back into unstable; the first isn't applicable and the second is already fixed.
17:07:08 <jralls> But having a 2.6.21 tag is sufficient to keep them in the repo, so no problem.
17:08:19 <jralls> For earlier releases, from SVN, I think they're not merged back either, but no problem: We just make sure they have a terminal tag and the branch can go away.
17:08:20 <gjanssens> I haven't caught up yet with all the issues.
17:08:53 <jralls> Yeah, no surprise. It's been a bit of a fire-hose the last week. That's why I brought up those two.
17:08:54 <gjanssens> The MariaDB issue is due to the part I added ?
17:09:03 <jralls> 'fraid so.
17:09:10 <gjanssens> Damn :(
17:09:25 <gjanssens> Oh well, that will need finetuning then.
17:09:37 <gjanssens> I'll probably have some time later this week.
17:09:42 <jralls> I've already got the fix committed in my local repo.
17:09:49 <gjanssens> Even better :)
17:10:06 <jralls> And the python fix I just need to do a cherry pick.
17:10:53 <jralls> Oh, that won't work, I'll have to change it by hand... git will never find the right CMakeLists.txt.
17:10:55 <gjanssens> I do think it's fair to make another release for these issues. Otherwise the final 2.6.x release is a regression from the older releases which would leave users in a difficult position
17:11:31 <gjanssens> Sticking to a version that's not gnucash 3.0 aware or going with a crippled version
17:11:45 <gjanssens> not *fully* 3.0 aware at least
17:11:55 <jralls> Worse, the flat-bayes feature release is 2.6.20, so someone on MariaDB who upgrades to 3.x is unable to go back.
17:12:22 *** kael has joined #gnucash
17:12:28 <gjanssens> That's more or less what I was thinking about, your description is better.
17:13:04 <gjanssens> "Unable to go back" of course depends on their backup strategy, but we know what that means in real world
17:13:33 <jralls> :-/
17:13:38 <gjanssens> Back on the topic of branches for a minute
17:14:22 <gjanssens> I'm a bit uncomfortable with "deleting maint and renaming unstable to maint"
17:14:41 <gjanssens> Won't that cause forced repository updates for all our clones ?
17:15:06 <gjanssens> Something I know is frowned upon in general
17:16:27 <gjanssens> That's the second thought I had while away: is maint a useful concept or should we simply make a 3.x branch on which all 3.x related commits will go as long as we support 3.x ?
17:16:39 <gjanssens> That would never need to be renamed, just deleted in the end
17:16:40 <fell> rename it to 2.x or similar?
17:17:32 <gjanssens> fell: yes, that would be one option, though it can also be dropped the moment we stop active development on it.
17:17:42 <gjanssens> Or is that bad as well ?
17:17:48 * gjanssens gets confused now
17:18:36 <fell> there are all this zzz branches
17:19:18 <jralls> Right, which caused a lot of noise when I created them.
17:19:50 <fell> I thought branches are cheep?
17:20:50 <gjanssens> cheap ;)
17:21:12 <gjanssens> They are in terms of processing time, but they do clutter certain command outputs
17:22:13 <jralls> I don't think dropping a branch in the upstream repo necessarily deletes it in a clone, so yeah, while deleting maint wouldn't necessarily be a problem but renaming unstable to maint would cause git to try to merge the new on onto the old one. So the least painful route for clones would be to do the merge first and then delete unstable.
17:24:12 <jralls> Branches are cheap in terms of space: While SVN (used to) create a whole new tree and history going back to commit 0 when you made a branch, git just creates a special tag. The blockchain isn't changed.
17:25:32 <gjanssens> I suppose the zzz branches probably could have been tags as well, at least the zzzoldreleases branches, right ?
17:26:21 <jralls> Yes, I think they could/can, though I think it will generate more noise. We'll probably want to turn off the commit hooks.
17:27:25 <gjanssens> Tue
17:27:30 <gjanssens> Eh, true
17:28:50 <gjanssens> This conversation will have to continue later. I'm about to leave here.
17:29:15 <gjanssens> jralls: what's your opinion on setting up versioned "maint" branches ?
17:29:57 <fell> We have hundred of links .g. from the wiki
17:30:15 <jralls> Yeah, and lots of other places, too.
17:30:57 <gjanssens> Ok, I'll think some more about this. tbc.
17:31:03 <gjanssens> Night chaps
17:31:10 <jralls> Good night.
17:31:14 <fell> Can it somehow become created like an alias?
17:31:25 <fell> GN8!
17:31:32 *** gjanssens has quit IRC
17:37:48 *** Cuare has joined #gnucash
17:44:59 *** harshitaneja has quit IRC
17:59:08 *** Cork has quit IRC
18:02:23 *** tuxd00d has quit IRC
18:03:29 *** Cork has joined #gnucash
18:37:08 <arahael> speaking of cheap branches... check out the feature branch workflow.
18:37:49 <arahael> it is where every single new feature is its own branch, and merged or rebased in right after it has been reviewed.
18:46:35 *** bob_ has joined #gnucash
19:11:02 *** josephcocoa has joined #gnucash
19:13:02 *** kael has quit IRC
19:14:42 *** ArtGravity has quit IRC
19:14:51 *** ArtGravity has joined #gnucash
19:21:53 *** boldstripe has quit IRC
19:22:53 *** boldstripe has joined #gnucash
19:31:45 *** NestorZ has quit IRC
19:32:14 *** puck has quit IRC
19:36:13 *** ArtGravity has quit IRC
19:36:21 *** ArtGravity has joined #gnucash
19:38:02 *** NestorZ has joined #gnucash
19:38:28 *** ArtGravity has quit IRC
19:59:00 *** NestorZ has quit IRC
19:59:05 *** NestorZ has joined #gnucash
20:13:20 *** pilotauto has joined #gnucash
20:43:07 *** puck has joined #gnucash
20:55:10 *** Cuare has quit IRC
21:02:33 *** kus has joined #gnucash
21:12:03 *** kus has quit IRC
21:17:58 *** mipesom has quit IRC
21:21:26 *** garyb43 has joined #gnucash
21:22:33 *** boldstripe has quit IRC
21:23:33 *** boldstripe has joined #gnucash
21:25:12 *** oozer has quit IRC
21:34:32 *** mipesom has joined #gnucash
21:43:28 *** bob_ has quit IRC
21:48:18 <znoteer_> I'm trying to create a new set of accounts in sql format. When the save dialog pops up, xml is the only option in the options list for data format. Is there some incantation to get sql to show up in the options list?
22:02:04 *** garyb43 has quit IRC
22:14:10 *** storyjesse has joined #gnucash
23:06:29 *** wget has quit IRC
23:07:20 *** wget has joined #gnucash
23:56:49 *** warlord has joined #gnucash