2020-02-28 GnuCash IRC logs

00:00:00 *** omnireq_ has quit IRC
00:00:11 *** omnireq_ has joined #gnucash
00:44:06 *** sbluhm has joined #gnucash
00:44:06 *** ChanServ sets mode: +v sbluhm
00:51:34 *** sbluhm has quit IRC
00:52:24 *** Mechtilde has joined #gnucash
01:02:00 *** omnireq_ has quit IRC
01:02:20 *** omnireq_ has joined #gnucash
01:23:30 *** omnireq_ has quit IRC
01:24:59 *** omnireq_ has joined #gnucash
01:33:49 *** fell has joined #gnucash
01:33:49 *** ChanServ sets mode: +o fell
01:36:00 *** fell_laptop has quit IRC
01:42:57 *** Mechtilde has quit IRC
02:02:30 *** sbluhm has joined #gnucash
02:02:30 *** ChanServ sets mode: +v sbluhm
02:06:30 *** omnireq_ has quit IRC
02:06:41 *** omnireq_ has joined #gnucash
02:26:39 *** gjanssens has joined #gnucash
02:26:39 *** ChanServ sets mode: +o gjanssens
02:27:30 *** omnireq_ has quit IRC
02:27:41 *** omnireq_ has joined #gnucash
02:44:52 *** fell has quit IRC
02:47:04 <gjanssens> .
02:49:00 *** omnireq_ has quit IRC
02:49:11 *** omnireq_ has joined #gnucash
02:51:11 *** fell has joined #gnucash
02:51:11 *** ChanServ sets mode: +o fell
03:10:30 *** omnireq_ has quit IRC
03:10:41 *** omnireq_ has joined #gnucash
03:22:32 *** Maschinenhans has joined #gnucash
03:31:30 *** omnireq_ has quit IRC
03:32:59 *** omnireq_ has joined #gnucash
03:34:44 *** sbluhm has quit IRC
03:43:59 *** Mechtilde has joined #gnucash
03:52:07 *** sbluhm has joined #gnucash
03:52:07 *** ChanServ sets mode: +v sbluhm
03:54:00 *** omnireq_ has quit IRC
03:54:30 *** omnireq_ has joined #gnucash
04:29:34 *** Aussie_matt has quit IRC
04:30:49 *** bertbob has quit IRC
04:31:06 *** sbluhm has quit IRC
04:33:55 *** bertbob has joined #gnucash
04:33:56 *** ChanServ sets mode: +v bertbob
04:38:51 *** bertbob has quit IRC
04:45:39 *** bertbob has joined #gnucash
04:45:40 *** ChanServ sets mode: +v bertbob
04:49:09 *** sbluhm has joined #gnucash
04:49:09 *** ChanServ sets mode: +v sbluhm
04:57:00 *** omnireq_ has quit IRC
04:57:15 *** omnireq_ has joined #gnucash
05:07:20 *** ramontjunior has joined #gnucash
05:12:16 *** FH_thecat has joined #gnucash
05:14:13 *** User_ has joined #gnucash
05:18:30 *** omnireq_ has quit IRC
05:18:41 *** omnireq_ has joined #gnucash
05:46:50 *** User_ has quit IRC
06:00:30 *** omnireq_ has quit IRC
06:00:50 *** omnireq_ has joined #gnucash
06:22:00 *** omnireq_ has quit IRC
06:22:13 *** omnireq_ has joined #gnucash
06:38:57 *** Jimraehl1 has joined #gnucash
06:40:13 *** Jimraehl1 has quit IRC
08:06:55 *** jervin has joined #gnucash
08:20:03 *** phoenix has joined #gnucash
08:24:13 *** jervin has quit IRC
08:26:54 *** sbluhm has quit IRC
08:33:56 *** KaiForce has joined #gnucash
08:43:00 *** omnireq_ has quit IRC
08:43:11 *** omnireq_ has joined #gnucash
09:02:33 *** Maschinenhans has quit IRC
09:04:00 *** omnireq_ has quit IRC
09:04:50 *** omnireq_ has joined #gnucash
09:26:00 *** omnireq_ has quit IRC
09:26:11 *** omnireq_ has joined #gnucash
09:34:41 <warlord> .
09:44:42 *** jervin has joined #gnucash
09:46:46 *** jervin has quit IRC
09:46:59 *** jervin has joined #gnucash
09:47:00 *** omnireq_ has quit IRC
09:47:14 *** TheDcoder has joined #gnucash
09:47:30 *** omnireq_ has joined #gnucash
09:49:06 <TheDcoder> Hi, I have two accounts and when I transfer money from one of them to the other account I see that the transaction appears to be exactly the same on both sides (except for the "Transfer" column)
09:49:44 <TheDcoder> The problem is that in the actual bank statements, the description/memo is different, and I want to preserve them in GnuCash
09:50:06 <TheDcoder> but if I change the descrption in one account it gets updated on the other side too :-/
09:51:05 <TheDcoder> Is it possible to that I can have two separate "entries" for the same logical transaction? that should solve my problem...
09:58:00 *** jervin has quit IRC
10:02:43 <TheDcoder> Found that a split transaction serves the purpose nicely :)
10:05:19 *** jervin has joined #gnucash
10:07:45 *** jervin has quit IRC
10:08:30 *** omnireq_ has quit IRC
10:08:44 *** omnireq_ has joined #gnucash
10:13:48 *** storyjesse has joined #gnucash
10:14:39 <chris> TheDcoder: split transaction? how about instead of transaction's description, use the split's memo?
10:15:57 *** storyjesse1 has joined #gnucash
10:16:15 <TheDcoder> chris: aren't both "description" and "memo" the same thing?
10:16:48 <chris> nopes
10:16:49 *** storyjesse has quit IRC
10:16:49 *** storyjesse1 is now known as storyjesse
10:16:53 <TheDcoder> If I split the transaction, I get to enter a different number/action and description/memo for the same transaction
10:16:54 <warlord> TheDcoder, no. The Description is for the whole transaction, the split memo is for each individual split
10:16:59 <TheDcoder> for each account
10:17:03 <TheDcoder> oh
10:17:11 <TheDcoder> then yes, I am using the split memo :)
10:17:21 <warlord> That's what it is there for.
10:17:37 <TheDcoder> the description seems to be a combination of both memos
10:17:49 <chris> nopes
10:17:56 <warlord> No, the description is its own field.
10:17:58 <TheDcoder> I am not familiar with the terms, so I apologise :)
10:18:41 <TheDcoder> I don't see a separate field for memo in the table... only "description"
10:18:55 <chris> click the toolbar "Split"
10:19:47 <TheDcoder> I did, the table column still says description but I see two different descriptions for each account
10:20:10 <TheDcoder> this is in the "split view" for the transaction
10:20:25 <warlord> TheDcoder, when you go into the field it will change the heading.
10:20:28 <TheDcoder> and this is what I am expecting it to do too
10:20:51 <chris> warlord: I never noticed the heading change
10:20:53 <TheDcoder> warlord: Ah! Right, it changes to memo
10:21:09 <TheDcoder> and "Num" changes to "Action"
10:21:14 <warlord> chris, yeah, the headings change based in the "line" you are on.
10:21:28 <TheDcoder> thanks for clearing that up warlord
10:21:31 <warlord> TheDcoder, right, that is yet another split-level field available.
10:21:38 <chris> one of these "Gnucash works in mysterious ways"
10:22:07 <TheDcoder> I am using Action just like the num field, to store the reference number for the transaction
10:22:08 <warlord> not at all mysterious. quite logical, IMHO
10:22:24 <warlord> sure, if there are unique references per account.
10:22:37 <TheDcoder> I agree
10:22:49 <TheDcoder> yup, I have unique references per account
10:23:22 * chris wonders if Action should get its own Transaction-Report filter
10:23:33 <chris> (maybe later)
10:23:40 <TheDcoder> by the way, can I use split transactions to split into more than 2 accounts?
10:23:51 <chris> yups
10:23:54 <TheDcoder> nice
10:24:05 <chris> they must, of course, balance
10:24:17 <TheDcoder> yes, of course
10:24:36 <TheDcoder> another question, can I make GnuCash calculate my income tax liability? :o
10:24:57 <chris> if you're willing to program it, yes...
10:25:04 <TheDcoder> basically take the sum of transactions from particular accounts and display a percentage of it
10:25:21 <TheDcoder> chris: oh, I am not afraid of code :)
10:25:32 <TheDcoder> which feature is responsible for this?
10:26:01 <chris> the reporting infrastructure, coded in guile.
10:26:24 <TheDcoder> thanks, I will check it out
10:26:40 <TheDcoder> I am not familiar with guile, how similar is it to normal programming languages?
10:27:05 <TheDcoder> is it even a programming language?
10:27:06 <TheDcoder> :)
10:27:17 <chris> it's a lisp
10:27:21 <TheDcoder> or is it just a very complex filter with its own syntax
10:27:42 <TheDcoder> chris: I see, I have not worked with lisp before, so it should be interesting
10:33:16 <warlord> technically it is Scheme
10:33:22 <warlord> (which is a lisp dialect)
10:34:57 <TheDcoder> it sounds familiar
10:35:22 <TheDcoder> any popular languages which are descendents of scheme?
10:35:26 <TheDcoder> (except guile)
10:35:42 <TheDcoder> ...maybe SQL syntax is a descendent?
10:39:56 *** omnireq_ has quit IRC
10:42:33 <warlord> no, I dont think SQL is anything like guile/lisp
10:42:41 <warlord> to me, SQL looks more like COBOL
10:48:24 <warlord> chris, what is the QIF importer bug, specifically? (which is the "offending code")?
10:48:58 <chris> my bad english. old code is difficult, 983c7ce0b was the offending code that I mixed up my English in my reply.
10:49:38 <chris> importer bug: whereby QIF txn S field is empty, it now can't import.
10:49:44 <chris> IIUC
10:55:40 <warlord> Are we sure this is the change that breaks it?
10:57:29 <warlord> Hopefully jralls can find the email
10:57:31 <chris> probably. I tested reverting it and importing another QIF. I'm compiling to test now.
10:57:38 <warlord> ok
10:57:52 <warlord> I dont see anything obviously wrong with his change..
10:58:38 <warlord> Although it should probably only use the default-unspec-acct if 'cat' is empty, too.
10:59:01 <warlord> Also, why did he change from memo-map to cat-map?
10:59:04 <chris> well this is all greek to me
10:59:20 <warlord> it's not greek -- it's scheme! ;)
10:59:23 <warlord> cat is the category
10:59:40 <chris> yeah the qif stuff is hard
10:59:42 <warlord> there is a memo-map and a cat-map
10:59:54 <warlord> Oh, I know... I spent many many MANY hours on it a long long time ago.
11:01:29 <chris> -insert-taken-meme-here-
11:01:38 <warlord> lol
11:04:16 <chris> well, confirm, reverting this change allows import.
11:04:34 <chris> (and the "Converting filename.QIF" step is slow that I will want to speed up)
11:05:50 <warlord> If reverting that change gets this QIF to load, then we need to figure out that other qif, too, in order to not regress *that* bug.
11:06:14 <chris> exactly
11:07:19 *** Mechtilde has quit IRC
11:08:03 <chris> well off now.
11:13:36 *** omnireq has joined #gnucash
11:15:33 *** jervin has joined #gnucash
11:16:12 *** jervin has quit IRC
11:19:10 *** phoenix has quit IRC
11:19:41 *** phoenix has joined #gnucash
11:22:01 *** sbluhm has joined #gnucash
11:22:01 *** ChanServ sets mode: +v sbluhm
11:22:01 *** brandoncooper has joined #gnucash
11:22:47 *** phoenix has quit IRC
11:24:25 <chris> aha: "Converting filename.QIF" step is slow because creating a txn is slow.
11:25:02 <brandoncooper> Hello, nice to say hello. I'm new around here. I'm trying to use mysql for ganucash on a mac system.
11:25:02 <brandoncooper> I've been looking for documentation but I didn't find anything useful. Could someone here tell me if there is documentation on how to set up mysql on gnucash on mac? Thanks a lot to all of you!
11:27:05 *** phoenix has joined #gnucash
11:28:54 *** phoenix has quit IRC
11:29:34 *** phoenix has joined #gnucash
11:33:37 *** phoenix has quit IRC
11:33:55 *** phoenix_ has joined #gnucash
11:33:56 <warlord> brandoncooper, I believe you need to supply the libdbi mysql DBD library
11:35:01 *** calvinct has joined #gnucash
11:38:29 *** phoenix_ has quit IRC
11:39:10 *** phoenix_ has joined #gnucash
11:41:33 *** phoenix_ has quit IRC
11:41:35 *** phoenix has joined #gnucash
11:42:48 <brandoncooper> warlord, thanks! I'm going to try over there :)
11:43:42 *** jralls has quit IRC
11:45:30 *** sbluhm has quit IRC
11:48:05 <TheDcoder> warlord: (replying to your comment about SQL/guile) I see, I must have confused it something else then
11:48:18 <TheDcoder> Thank you for the help, I have to go now, bye!
11:48:26 *** TheDcoder has quit IRC
12:14:11 *** keiffer has joined #gnucash
12:15:38 *** guak has joined #gnucash
12:38:01 *** storyjesse has quit IRC
12:40:08 *** ArtGravity has joined #gnucash
12:40:08 *** ChanServ sets mode: +v ArtGravity
12:46:50 <warlord> chris, did you see Macho's email to -user?
12:47:02 <warlord> (on Feb 22)
12:47:06 *** calvinct has quit IRC
12:49:42 *** phoenix_ has joined #gnucash
12:50:09 *** phoenix has quit IRC
12:51:06 *** phoenix has joined #gnucash
12:51:53 *** sbluhm has joined #gnucash
12:51:54 *** ChanServ sets mode: +v sbluhm
12:56:51 *** Mechtilde has joined #gnucash
13:02:12 *** phoenix has quit IRC
13:03:08 *** sbluhm has quit IRC
13:09:31 *** phoenix has joined #gnucash
13:10:53 *** sanchom has joined #gnucash
13:11:37 <sanchom> I'm running 2.6.15 and about to upgrade to 3.8. Any database incompatibilities etc that I need to be worried about?
13:11:42 *** Couto[m] has quit IRC
13:12:05 *** peter-butler[m] has quit IRC
13:12:08 *** MatrixTravelerbot[m] has quit IRC
13:12:09 *** mmkodali[m] has quit IRC
13:12:13 *** sunyibo[m] has quit IRC
13:12:13 *** JulianHofer[m] has quit IRC
13:12:14 *** ElonSatoshi[m] has quit IRC
13:12:33 *** luwum[m] has quit IRC
13:13:42 *** sbluhm has joined #gnucash
13:13:42 *** ChanServ sets mode: +v sbluhm
13:14:03 <warlord> 3.8 should be able to read a 2.6.15 DB just fine.
13:16:37 *** phoenix has quit IRC
13:23:21 <sanchom> 3.8 looks so good compared to 2.6
13:27:10 <warlord> :)
13:33:26 *** Maschinenhans has joined #gnucash
13:41:03 *** Couto[m] has joined #gnucash
13:41:41 *** brandoncooper has quit IRC
13:48:04 *** sanchom has quit IRC
13:54:00 *** brandoncooper has joined #gnucash
14:11:56 *** kael has joined #gnucash
14:11:56 *** ChanServ sets mode: +v kael
14:21:07 *** frakturfreak has joined #gnucash
14:21:07 *** ChanServ sets mode: +v frakturfreak
15:00:43 *** ramontjunior has quit IRC
15:28:46 *** bertbob has quit IRC
15:34:15 *** bertbob has joined #gnucash
15:34:16 *** ChanServ sets mode: +v bertbob
15:37:18 *** bertbob has quit IRC
15:55:51 *** fell has quit IRC
16:15:21 *** Agfarmer18 has joined #gnucash
16:20:54 *** fell has joined #gnucash
16:20:54 *** ChanServ sets mode: +o fell
16:23:57 *** Mechtilde has quit IRC
16:25:55 *** fell has quit IRC
16:26:49 *** fell has joined #gnucash
16:26:49 *** ChanServ sets mode: +o fell
16:45:56 *** bertbob has joined #gnucash
16:45:56 *** ChanServ sets mode: +v bertbob
16:49:41 *** Maschinenhans has quit IRC
17:02:37 *** frakturfreak has quit IRC
17:12:35 *** oozer has joined #gnucash
17:21:26 *** gjanssens has quit IRC
17:21:57 *** sbluhm has quit IRC
17:45:19 *** phoenix has joined #gnucash
17:47:58 *** phoenix has quit IRC
17:48:14 *** kael1 has joined #gnucash
17:48:14 *** ChanServ sets mode: +v kael1
17:48:21 *** kael has quit IRC
17:48:21 *** kael1 is now known as kael
17:51:21 *** kael has quit IRC
17:51:41 *** phoenix has joined #gnucash
17:55:08 *** phoenix has quit IRC
17:58:42 *** ArtGravity has quit IRC
17:58:46 *** calvinct has joined #gnucash
18:00:54 *** kael has joined #gnucash
18:00:54 *** ChanServ sets mode: +v kael
18:12:43 *** phoenix has joined #gnucash
18:20:19 *** phoenix has quit IRC
18:29:36 *** calvinct has quit IRC
18:33:05 *** brandoncooper has left #gnucash
18:42:08 *** fell has quit IRC
18:50:58 *** Aussie_matt has joined #gnucash
19:00:11 *** omnireq has quit IRC
19:12:44 *** phoenix has joined #gnucash
19:18:10 *** KaiForce has quit IRC
19:20:50 *** phoenix has quit IRC
19:38:24 *** kael has quit IRC
19:49:35 *** omnireq has joined #gnucash
20:11:34 *** omnireq has quit IRC
20:11:45 *** omnireq has joined #gnucash
20:21:21 *** Aussie_matt has quit IRC
20:23:24 <chris> warlord: sure did, negotiations are completed
20:32:05 *** guak has quit IRC
20:51:51 *** TownsendHardware has quit IRC
21:02:02 *** keiffer has quit IRC
21:04:59 *** miklcct has quit IRC
21:06:14 *** miklcct has joined #gnucash
21:06:14 *** ChanServ sets mode: +v miklcct
21:28:13 *** oozer has quit IRC
22:07:21 <chris> this is statprof from a slow part of qif-import: https://pastebin.com/raw/ciyCJ8a2
22:21:41 <chris> @tell gjanssens QIF-import is slow at xaccTransCommitEdit. I wonder how CSV-import and OFX-import handle large imports - do they run xaccTransBeginEdit and xaccTransCommitEdit as well? do they have a cancellable progress bar?
22:21:41 <gncbot> chris: The operation succeeded.
22:29:03 <chris> warlord. re: 983c7ce0 changing qif-memo-map to qif-cat-map doesn't quite cut it.
23:09:05 *** Agfarmer18 has quit IRC