2015-11-29 GnuCash IRC logs

01:05:09 *** fell_ has quit IRC
01:52:47 *** meb has quit IRC
02:14:59 *** MechtiIde has joined #gnucash
02:52:21 *** gour has joined #gnucash
04:36:53 *** uXus has quit IRC
04:40:10 *** uXus has joined #gnucash
04:42:44 *** srbaker has joined #gnucash
04:43:15 <srbaker> Heya folks.
04:43:45 <srbaker> I'm still having a real problem figuring out the best way to manage the fact that I want to track my finances, and my bank gives me absolutely shit data.
04:45:01 <srbaker> Is writing a script myself ot pre-process the CSVs the best option I have?
04:45:07 <srbaker> That seems incredibly tedious and error-prone :(
05:07:34 *** fabior has joined #gnucash
06:06:04 *** karelk has quit IRC
06:06:22 *** karelk has joined #gnucash
06:08:56 <srbaker> Also, I'm thinking about using the Notes field to add tagging support. I don't suppose anyone else has done this?
06:12:49 <srbaker> In order to do this, I'd like some sample code for a plugin that adds GUI components.
06:17:18 *** gour1 has joined #gnucash
06:17:56 *** finster has left #gnucash
06:18:48 *** gour has quit IRC
06:30:44 *** ErKa has joined #gnucash
06:31:39 <srbaker> Okay, now I'm getting a serious annoyance.
06:31:49 <srbaker> Sometimes when I change the description of a transaction, it re-orders my trnasactions.
06:31:58 <srbaker> the order htey're in is *absolutely* important to never change.
06:35:33 <srbaker> Sigh. This is not less stressful than just not knowing where my money is going at all.
07:23:45 <srbaker> And I just did a CSV import, where it didn't preserve the order in the CSV. How is this not a well known problem?
07:23:48 <srbaker> :(
07:28:14 <warlord> srbaker: or even better -- don't import your data at all. enter it manually via the receipts and then reconcile with your statement every month.
07:28:17 *** fabior has quit IRC
07:28:37 <srbaker> warlord: that's what i did when i used YNAB
07:28:58 <srbaker> warlord: do you know why it re-orders my transactions from my CSV?
07:29:02 <warlord> If your bank gives you bad data, this is easier
07:29:07 <srbaker> yeah, i suppose.
07:29:26 <warlord> Transaction order is based on post-date, number, enter-date, ...
07:29:37 <srbaker> weird.
07:29:45 <srbaker> why is it re-ordering sometimes when i edit a description?
07:29:56 <warlord> That I dont know..
07:30:00 <srbaker> hrm
07:30:02 <srbaker> i guess i could use Num
07:30:07 <srbaker> but i don't want to
07:30:10 <warlord> It shouldn't do that..
07:30:29 <warlord> You shouldn't have to.. once the txn is in there it should stay in order.
07:30:29 <srbaker> this is why i stopped using YNAB
07:30:37 <warlord> no clue what YNAB is
07:30:48 <warlord> What version of gnucash are you using? and what OS/Distro?
07:30:49 <srbaker> a budgeting program. it orders by Date, then Description.
07:31:10 <srbaker> 2.6.9 on Debian stretch
07:32:52 <srbaker> warlord: do you find any value in having the exact data from the bank in the Memo field?
07:33:00 <warlord> GnuCash orders by Date Posted, Number, Date Entered, Description, then GUID
07:33:06 <warlord> srbaker: no
07:33:08 <srbaker> date/amount ought to be enough to track down
07:33:16 <srbaker> okay, then i'll ignore them
07:33:21 <warlord> I dont care what date the txn hits the bank.
07:33:22 <srbaker> and i figured out why it's reordering these two
07:33:26 <warlord> I only care when *I* think it happened.
07:33:30 <srbaker> oooh.
07:33:31 <warlord> Oh? Why is that
07:33:44 <srbaker> so the data i get from my bank is fucked:
07:33:57 <srbaker> Date, other date, number, description, amount, balance.
07:34:04 <srbaker> description is sequential *except* the first transaction
07:34:12 <srbaker> so that's why it's getting my first two txns out of order
07:34:19 <srbaker> here's the other fucked up thing.
07:34:31 <srbaker> Date, Other Date are the date it cleared, and Other Date, i have no idea
07:34:44 <srbaker> but in the description it's (MERCHANT) / (DATE)
07:35:11 <srbaker> 2015-08-04, 2015-08-04, AIRBNB /15-08-03
07:35:25 <warlord> Interesting....
07:35:26 <srbaker> the first is the one my bank statement cares about. the one in the descriptoin is the one where i think it happened.
07:35:42 <srbaker> the second date is some ... weird one. i don't know why.
07:35:42 <warlord> Sounds like it..
07:35:47 <warlord> That is f*d up
07:35:59 <warlord> Is the second date ever different from the first?
07:36:04 <srbaker> yes.
07:36:10 *** warlord sets mode: +o gncbot
07:36:14 <srbaker> often.
07:36:20 <srbaker> on weekends.
07:36:44 <warlord> I was going to say, maybe the first is the date the bank received it, and the second is the banking-day it was processed
07:36:55 <srbaker> i think that's true, but reverse.
07:37:12 <srbaker> first is the "cleared" date. the second appears to be the date the bank got it.
07:37:17 <warlord> okay.
07:37:30 <warlord> regardless, gnucash cares about neither of those.. ;)
07:37:31 <srbaker> so there's one there where it happened friday morning (that's in the descr), second column is saturday, first is monday.
07:37:35 <srbaker> yeah. true.
07:37:43 <warlord> (well, you could use the cleared date as your posted date)
07:38:02 <srbaker> so the reason i wanted to put the date that the bank has in gnucash, so the transactions line up
07:38:53 <warlord> But you can't guarantee that. For example, if you write a check, it could be weeks before it gets cashed. But you want it in your accounts so you dont overdraw.
07:39:06 <srbaker> here's another screwed up thing. most of the time the description contains useful information about where i spent money
07:39:11 <warlord> So really, it's not worth the effort to make sure your account lines up with the bank's
07:39:15 <srbaker> like Sånetrafiken.
07:39:18 <srbaker> no problem.
07:39:24 <srbaker> but when i travel, the description contains the city. sometimeds.
07:39:25 <warlord> anyways, I need to run. Sorry.
07:39:31 <srbaker> so i have a week of transactions that say EDINBURGH
07:39:33 <srbaker> useful.
07:39:35 <srbaker> warlord: thanks :)
07:39:40 <warlord> good luck.
07:40:16 <srbaker> tack :)
07:40:18 <warlord> Oh, w.r.t. using Notes for Tags... You could do that, but honestly if you're going to add a GUI piece for tags it would be better to also add a new data field to store it instead of overloading the Notes field.
07:40:21 <warlord> Bitte.
07:41:24 <srbaker> ooh, interesting. i did not know adding data fields was an option
08:21:48 *** srbaker has quit IRC
08:32:57 *** srbaker has joined #gnucash
08:39:07 *** fabior has joined #gnucash
08:54:11 *** karelk has quit IRC
08:54:16 *** Jimraehl1 has left #gnucash
08:57:12 *** Jimraehl1 has joined #gnucash
09:18:47 *** fell has joined #gnucash
09:28:31 *** fabior has quit IRC
09:40:14 *** fell_ has joined #gnucash
09:42:07 *** fell has quit IRC
09:46:39 *** ErKa has quit IRC
09:52:56 *** karelk has joined #gnucash
11:06:27 *** srbaker has quit IRC
11:24:38 *** MechtiIde has quit IRC
11:58:58 *** fabior has joined #gnucash
12:19:40 *** MechtiIde has joined #gnucash
12:25:59 *** ErKa has joined #gnucash
12:29:11 *** ErKa has quit IRC
12:31:58 *** ErKa has joined #gnucash
12:36:53 *** ErKa has quit IRC
12:39:33 *** ErKa has joined #gnucash
12:49:12 *** codesmythe has joined #gnucash
12:51:50 *** autoditac__ has joined #gnucash
12:52:51 *** ErKa has quit IRC
13:00:13 *** mlncn_ has joined #gnucash
13:01:35 *** ErKa has joined #gnucash
13:05:15 *** ErKa has quit IRC
13:11:31 *** ErKa has joined #gnucash
13:52:42 *** ErKa has quit IRC
14:00:19 *** MechtiIde has quit IRC
14:57:31 *** srbaker has joined #gnucash
15:35:08 *** nomeata has joined #gnucash
16:02:05 *** gour1 has quit IRC
16:07:33 *** Uranio has joined #gnucash
16:08:33 <Uranio> hi there, what about gnucash manual in spanish?
16:10:46 <Uranio> how could I write
16:34:42 *** mlncn_ has quit IRC
16:35:02 *** mlncn_ has joined #gnucash
16:35:51 *** Uranio has quit IRC
17:02:23 *** nomeata has quit IRC
17:47:41 *** fabior has quit IRC
18:40:31 *** jeffsf has joined #gnucash
18:51:09 <jralls> @tell Uranio If you're willing to translate the Help and/or the Tutorial and Context Guide the easiest way to get the source is to fork our gnucash-docs repo on Github. You can submit the translations as a pull request.
18:51:09 <gncbot> jralls: The operation succeeded.
19:00:32 <jralls> warlord: There's something wrong with the wiki. It's returning "A database query error has occurred. This may indicate a bug in the software." Code seems to be responding OK otherwise.
19:21:08 *** mlncn_ has quit IRC
20:13:38 <jralls> warlord: Can't pull either: /var/lib/gitolite3/.gitolite/logs/gitolite-2015-11.log: Read-only file system
20:14:31 <jralls> warlord: Either the disk is full or it's corrupted. I'll put this in email too.
20:16:15 *** himaxx has joined #gnucash
20:16:40 *** himaxx has quit IRC
20:20:32 <warlord> jralls: thanks. I'll look at it.
20:20:39 <warlord> I had an error on another VM last week.
20:20:48 <warlord> Most likely it needs a reboot and fsck.
20:20:57 <jralls> OK.
20:26:39 <warlord> Actually, one of my VM host disks appears to have failed!
20:26:50 <warlord> I'll see if I have a replacement lying around (I should!)
20:31:53 *** autoditac__ has quit IRC
20:32:08 <warlord> of course a shutdown is taking forever (because the disk is readonly)
20:39:41 *** gncbot has joined #gnucash
20:40:36 *** jralls sets mode: +o gncbot
20:41:06 <jralls> Obviously didn't require a disk swap, at least not right away.
20:45:15 <warlord> correct; my disks are all mirrored.
20:45:33 <warlord> I have a spare in hand that I'm preparing to swap in.. but I need to clean it off first.
21:00:05 *** mlncn has joined #gnucash
22:16:26 <codesmythe> jralls: on recent xml to cpp commit, gnc-backend-xml.cpp is pulling in gnc-prefs.h (line 90) outside extern "C", causing link errors for me.
23:01:10 <warlord> jralls: I just repaired the database. Try now?
23:41:46 *** codesmythe has quit IRC