2018-02-23 GnuCash IRC logs

00:11:54 *** harshitaneja has joined #gnucash
00:28:04 *** marusich has quit IRC
00:28:22 *** marusich has joined #gnucash
00:36:04 *** marusich has quit IRC
00:36:21 *** marusich has joined #gnucash
00:40:07 *** marusich has quit IRC
00:40:24 *** marusich has joined #gnucash
00:50:02 *** marusich has quit IRC
00:50:54 *** marusich has joined #gnucash
00:58:05 *** josephcocoa has quit IRC
01:09:49 *** fell has quit IRC
01:10:38 *** fell has joined #gnucash
01:12:16 *** chris has joined #gnucash
01:13:11 *** jotrago has joined #gnucash
01:26:54 *** Mechtilde has joined #gnucash
01:41:38 *** harshitaneja_ has joined #gnucash
01:42:57 *** harshitaneja has quit IRC
01:44:00 *** harshitaneja_ is now known as harshitaneja
01:45:23 *** harshitaneja has quit IRC
01:46:12 *** harshitaneja has joined #gnucash
01:47:15 *** Mechtilde has quit IRC
02:03:57 *** chris has quit IRC
02:04:59 *** chris has joined #gnucash
02:07:06 *** bertbob has quit IRC
02:14:45 *** bertbob has joined #gnucash
02:17:56 *** bertbob has quit IRC
02:30:58 *** woodrec has joined #gnucash
02:32:15 *** bertbob has joined #gnucash
02:33:04 *** woodrec has quit IRC
02:37:33 *** fekepp has joined #gnucash
02:59:57 *** chris has quit IRC
03:08:30 *** gjanssens has joined #gnucash
03:08:30 *** ChanServ sets mode: +o gjanssens
03:09:01 <gjanssens> .
03:12:47 *** chris has joined #gnucash
03:32:34 <arahael> gjanssens: Sent 5 hours, and 47 minutes ago: <arahael> (perforce lets you lock a file for edit)
03:37:33 *** bob_ has joined #gnucash
03:40:34 <chris> gjanssens: I'll amend and repush in a few minutes
03:41:40 *** bob_ has quit IRC
03:42:28 *** bob_ has joined #gnucash
03:47:14 <gjanssens> chris: thanks
03:48:17 <chris> cmake looks like FORTRAN...
04:19:11 <arahael> Looks more like the C Preprocessor to me.
04:36:29 <chris> by FORTRAN i meant COBOL
04:41:17 <chris> gjanssens: #286 is now ripe. my TR-unittest is now rebased on it, and I'll get cracking in spare time :)
04:43:58 * arahael loves those numbers that match the computers he used to use.
05:04:43 <arahael> When using the "Stock" account type, what does the "Shares" column mean?
05:06:13 <arahael> Ah, the number of shares.
05:37:50 *** pilotauto has quit IRC
05:44:58 <arahael> Woohoo! Double-Entry bookkeeping rules! :)
05:45:17 <arahael> There was a _mysterious_ transaction in an account... But double entry bookkeping helped find where it went to!
05:53:54 <gjanssens> \o/
06:00:53 <arahael> It's curious how the transaction description becomes nearly irrelevant once it's in double-entry.
06:02:33 *** bob_ has quit IRC
06:29:54 <chris> arahael: this is only thanks to the unique gnucash character which forces us to create numerous Expense accounts
06:42:22 *** gncbot sets mode: +o fell
06:43:30 <arahael> chris: Hmm? Maybe... In this case, it was a transaction in my stock trading account... Marked as a payment.
06:44:07 <arahael> chris: And I didn't want to have paid the broker that much! But double-entry has revealed that it was in my checking account, so it must've been a payment... To me. :)
07:00:59 <chris> ah I don't use gnucash to track stocks, I can't understand their statements
07:01:29 <chris> but good on you to track their fees precisely!
07:04:59 *** User_ has joined #gnucash
07:06:13 <arahael> chris: There aren't that many. ;)
07:06:52 <arahael> chris: But I sent my bank statment through gnucash... Put all the 'stock' transactions in a stock account... And then went through the stocks and noticed that the 'payment' was already listed.
07:07:18 <arahael> chris: And considering that a regular brokerage fee is $11... The $340 fee was... excessive.
07:07:26 <arahael> So I'm pleased it came to me.
07:07:51 <arahael> G'night!
07:16:28 *** tlaxkit has joined #gnucash
07:18:50 *** harshitaneja has quit IRC
07:19:31 *** darshan has joined #gnucash
07:21:05 *** darshan has quit IRC
07:33:53 *** User_ has quit IRC
07:47:18 *** GabrieleV has quit IRC
07:49:44 *** GabrieleV has joined #gnucash
07:51:13 <warlord> arahael: No, you absolutely do NOT want merges to happen!!! That *WILL* destroy your datafile!!
08:20:57 *** tlaxkit has quit IRC
08:27:47 *** josephcocoa has joined #gnucash
08:37:49 *** oozer has joined #gnucash
08:37:56 *** bob_ has joined #gnucash
09:12:45 *** fabior has joined #gnucash
09:22:32 *** Jimraehl1 has joined #gnucash
09:23:28 *** Jimraehl1 has left #gnucash
09:40:20 *** josephcocoa has quit IRC
09:48:11 *** fabior has quit IRC
10:33:27 *** fabior has joined #gnucash
10:42:38 *** bob_ has quit IRC
11:07:46 *** Mechtilde has joined #gnucash
11:12:33 *** oozer has quit IRC
11:43:51 *** O01eg has quit IRC
12:00:37 *** O01eg has joined #gnucash
12:05:05 *** O01eg has quit IRC
12:10:48 *** christopher has quit IRC
12:12:25 *** frakturfreak has joined #gnucash
12:14:23 *** frakturfreak has quit IRC
12:18:43 *** O01eg has joined #gnucash
12:46:40 *** ajm has joined #gnucash
12:48:46 <jralls> arahael: Perforce is closed-source proprietary software. One can't even buy it online, one must call one of their sales reps just to get a price quote. That's not something we can recommend.
12:51:50 *** gjanssens has quit IRC
12:52:48 <ajm> I wonder if anyone could help with a fairly nasty problem I'm having with Gnucash? I've been using it happily since about 2004 for basic small business purposes, invoicing etc... I've just been pushed into upgrading to 2.7.4 by Gentoo trying to get rid of the old webkit-gtk and now it seems whatever gnucash file I open gets corrupted and won't open a second time (although it does seem to open perfectly the first time.)
12:53:12 <ajm> more precisely, gnucash complains it can't parse the file, it still seems to be valid XML
12:55:44 <ajm> the gnucash.trace is here: https://pastebin.com/aGCk5YFt
12:56:54 *** fabior has quit IRC
12:57:19 *** oozer has joined #gnucash
12:58:08 <lmat> ajm: 2.7.4 is an unstable version and should not be used on your data files (about which you care). Copy your original data files and test 2.7.x if you like.
12:58:35 <lmat> ajm: Thanks for testing. Would you create a bugzilla bug?
12:59:29 <ajm> I appreciate it's an unstable version, as I say I was pushed into it by the distro marking it "stable" although they are aware it's not officially stable
12:59:39 <ajm> I will create a bug
12:59:51 <lmat> ajm: Thanks! Yeah, the whole webkit situation is regrettable.
13:02:04 <ajm> I dare say my data file is a bit large at 2MB for the .gnucash but wouldn't have thought it ridiculously so?
13:05:41 <jralls> ajm: So change distros. The Gentoo folks are forcing you to be an alpha-tester. You shouldn't accept that.
13:07:41 <ajm> well, forced is of course a slight exageration, although I was highly unimpressed by this particular move
13:08:10 <ajm> I could have just left things as they were, but I've generally found Gnucash to be very reliable over many years so took the chance
13:09:07 <jralls> ajm: Your tracefile indicates you're trying to open a backup of a backup file from 2011. The 'xac' extension from 2011 means that it's a GnuCash 2.2 file.
13:10:17 <ajm> even though the actual end extension is .gnucash?
13:10:40 <ajm> I've tried doing a "save as" and then opening that .gnucash file - this does the same thing
13:11:04 <jralls> ajm: Do you understand how GnuCash's backup mechanism works?
13:11:28 <ajm> not in the least! All these years I've just opened Gnucash and it comes up with my data
13:11:56 <ajm> obviously I've backed things up, but just taken the whole directory
13:12:45 <jralls> No, this is GnuCash's backup system. It saves previous versions of your file so that you can easily roll back if something happens that corrupts your file.
13:13:45 <ajm> So how can I identify my actual data file ?
13:14:00 <jralls> It works like this: When you first save a file you give it a name. If you don't specify an extension it adds "gnucash" as an extension. A long time ago it added .xac (for X-accounting, GnuCash's original name).
13:15:47 <jralls> When you save a new file, Gnucash renames the old file with a timestamp. So if your file is named foo.gnucash, when you save your previous file is renamed foo.gnucash.201802213101323.gnucash.
13:17:13 <ajm> hmm, OK... I have over 300 of those .xac files and 43 .gnucash!
13:17:55 <jralls> If you open that renamed file, modify it, and save you get foo.gnucash.2018022213101323.gnucash.20180223104518.gnucash.
13:18:33 <ajm> yes, that seems sensible enough... but the "save as" I did, of the file that did appear to open perfectly - shouldn't that create a valid new .gnucash file in the current format?
13:19:12 <ajm> it just seemed strange that after the upgrade everything opened perfectly - all my reports, open invoice etc all as they were
13:19:36 <ajm> until I quit and opened gnucash again and it choked (and chokes)
13:20:35 <ajm> (got to go AFK for a while, but appreciate the information so far)
13:24:56 <jralls> I need to run some errands as well.
13:25:02 *** jralls is now known as jralls_afk
13:25:17 *** woodrec has joined #gnucash
13:42:07 *** woodrec has quit IRC
13:46:47 *** woodrec has joined #gnucash
13:48:19 *** woodrec has quit IRC
13:49:41 *** woodrec has joined #gnucash
14:23:59 *** jralls_afk is now known as jralls
14:38:24 <ajm> I did notice when trying to add a vendor bill that the date is now coming up as 1st Jan 1970 instead of today's date by default... I suppose this must somehow be tied in with the "CRIT <gnc.io> [dom_tree_handlers_all_gotten_p()] Not defined and it should be: entry:date "?
14:39:57 <jralls> ajm: Not necessarily. Besides, that message is from a failed attempt to load something, though because of the filename I'm not sure what and I'm not sure you know either.
14:40:51 <jralls> ajm: Please see my request for more info on the bug.
14:41:53 <ajm> OK, just got that and will respond.
14:53:53 *** Mechtilde has quit IRC
14:57:47 <ajm> jralls: I've uploaded that trace (had to gzip it to get it under size limit, trust that's OK.)
15:17:38 <jralls> ajm: No prob, I'm studying it now.
15:22:53 <jralls> ajm: Your earlier comment about trying to add a vendor bill and the date coming up empty: Maybe that is related. Is that new vendor bill in the saved file?
15:41:16 <ajm> No, it isn't in this file (I went back to the original version and repeated the bare minimum of steps to produce that trace)
15:43:01 <jralls> Hmm. I just created a test file with a vendor bill and it has an entry:date, so that's not the problem.
15:43:59 <jralls> So this time you opened the original file, did a save-as, quit GnuCash, and restarted it with the command line I gave you?
15:44:31 <ajm> yes, opening the newly saved-as file with the command
15:45:11 *** woodrec has quit IRC
15:46:49 <ajm> I just thought it was a bit of a coincidence that gnucash didn't seem to know what day it was when creating the vendor bill, and then was showing a CRIT about dates when trying to open any file saved by the new version
15:48:44 <jralls> OK, then there are two things to try. A diff between the old and new might be instructive. Depending on how many bills and invoices you have in the data file you might be able to examine the new file with less and find the entry that's missing an entry:date, then look at it in the old file and see what's recorded as the entry:date. Maybe there's a date-parsing problem.
15:49:28 <ajm> it's a pity the file is so large, it makes this kind of comparison a bit harder
15:50:37 <ajm> I will try and do that tomorrow if I can get a minute, got to quit for the night now - thanks again for the help so far
15:51:46 <jralls> The way I'd do the second is open it with less (or zless if it's compressed) then search for entry:guid. The entry:date element should be right after each one. When you find one with it missing you can copy the guid to the clipboard then switch to the old file and search for the guid.
16:13:27 *** warlord2 has joined #gnucash
16:13:29 *** warlord__ has joined #gnucash
16:14:41 *** ChanServ sets mode: +qo warlord2 warlord2
16:14:47 *** warlord has quit IRC
16:14:51 *** warlord2 is now known as warlord
18:52:53 *** Cuare has joined #gnucash
19:40:38 *** josephcocoa has joined #gnucash
19:49:52 <chris> jralls - before I start writing, I wish to lay out strategy for unit test - will have 1 env, will craft some txns with predetermined amounts, to/from accounts, and repeatedly run the whole renderer with various combinations of filtering/sorting/display options.
19:50:41 <chris> the table will be retrieved and interrogated repeatedly from predetermined values
19:51:11 *** tong has joined #gnucash
19:52:01 <jralls> chris: OK. That's more implementation test than unit test, but that's OK. The approach is correct.
20:47:48 *** chris has quit IRC
20:48:35 *** chris has joined #gnucash
21:57:23 *** oozer has quit IRC
22:03:21 *** Robert1 has joined #gnucash
22:03:50 *** Robert1 has left #gnucash
23:09:02 *** bertbob has quit IRC
23:24:19 *** bertbob has joined #gnucash