2019-11-20 GnuCash IRC logs
00:51:08 *** storyjesse has quit IRC
00:57:20 *** Unhammer has quit IRC
00:59:11 *** Unhammer has joined #gnucash
00:59:11 *** ChanServ sets mode: +v Unhammer
01:00:13 *** jervin has joined #gnucash
01:00:36 *** jervin has quit IRC
01:03:48 *** Mechtilde has joined #gnucash
01:15:30 *** boldstripe has quit IRC
01:16:25 *** boldstripe has joined #gnucash
01:41:14 *** omnireq has joined #gnucash
01:44:01 *** waeking has quit IRC
01:44:20 *** fell has quit IRC
01:45:27 *** fell has joined #gnucash
01:45:27 *** ChanServ sets mode: +o fell
01:50:23 <fell> ankenyr, where do you see an error in "Status for signon request: Success (Code 0, severity "INFO")"?
01:51:09 <ankenyr> Yup
01:52:21 <ankenyr> This is a brokerage account via Schwab if that makes any difference, even weirder the OFX XML file retrievable via ofxtools shows no transaction when imported even though the statement shows things like the stocks. I am new to this so maybe I just don't understand that it cannot import stocks?
01:54:02 <ankenyr> err sorry guess I didn't read your reply correctly
01:54:12 <ankenyr> kinda late and been taking care of the 6 month old all day
01:54:23 <fell> I do not use directOFX. so you would better ask on the gnucasch-user mailing list
01:54:45 <ankenyr> aahh ok =/
01:56:13 <ankenyr> For others who may be looking here is what it has after it gets a response
01:56:36 <ankenyr> Uploaded file: https://uploads.kiwiirc.com/files/4edf5d0c57bef2854927d5009193ab22/pasted.txt
01:57:20 <fell> Are you sure, there are transactions in the file? Probably it is only showing the current state.
01:58:35 <fell> Ah, the error is later: Status for transaction statement request: General account error (Code 2002, severity "ERROR")
01:59:49 <fell> But as I said I do not know the OFX error codes, but some other guys on the ML.
02:01:25 <fell> You did already read https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings etc?
02:10:12 <ankenyr> Yea I did, didn't seem to work
02:12:47 *** pohly1 has joined #gnucash
02:12:52 <ankenyr> need to head to sleep its 11pm here. Will continue to try and debug things tomorrow while I got time (on paternity leave) if I can find an actual bug I will make sure to report it and try and create a fix. Not very familiar with C though so not sure
02:13:36 <ankenyr> will post something on the mailing list tomorrow too
02:15:24 *** Mechtilde has quit IRC
02:25:17 *** gggg has quit IRC
02:26:56 *** gggg has joined #gnucash
03:03:25 *** jralls has quit IRC
03:06:56 *** jralls has joined #gnucash
03:06:56 *** ChanServ sets mode: +o jralls
03:12:26 *** omnireq_ has joined #gnucash
03:13:38 *** omnireq has quit IRC
03:16:10 *** boldstripe has quit IRC
03:17:06 *** boldstripe has joined #gnucash
03:21:11 *** Unhammer has quit IRC
03:23:06 *** Unhammer has joined #gnucash
03:46:08 *** gjanssens has joined #gnucash
03:46:10 *** ChanServ sets mode: +o gjanssens
03:54:28 *** fell has quit IRC
04:18:22 *** bertbob has quit IRC
04:31:38 *** bertbob has joined #gnucash
04:31:39 *** ChanServ sets mode: +v bertbob
04:52:20 *** Mechtilde has joined #gnucash
04:53:26 *** storyjesse has joined #gnucash
05:07:57 *** GabrieleV has quit IRC
05:16:51 *** boldstripe has quit IRC
05:17:46 *** boldstripe has joined #gnucash
05:18:59 *** biomanu has joined #gnucash
05:19:00 *** ChanServ sets mode: +v biomanu
05:31:11 *** Mechtilde has quit IRC
06:08:38 *** chf has quit IRC
06:09:45 *** chf has joined #gnucash
06:26:13 *** omnireq_ has quit IRC
06:26:24 *** omnireq_ has joined #gnucash
06:26:45 *** Mechtilde has joined #gnucash
06:41:46 *** User_ has joined #gnucash
06:45:35 *** GabrieleV has joined #gnucash
06:47:05 *** Jimraehl1 has joined #gnucash
06:47:13 *** omnireq_ has quit IRC
06:47:24 *** omnireq_ has joined #gnucash
06:48:18 *** Jimraehl1 has quit IRC
06:56:50 *** Mechtilde has quit IRC
07:17:31 *** boldstripe has quit IRC
07:18:26 *** boldstripe has joined #gnucash
07:26:41 *** CarwynNelson has joined #gnucash
07:26:41 *** ChanServ sets mode: +v CarwynNelson
07:26:43 *** CarwynNelson has quit IRC
07:39:19 *** AndroUser2 has joined #gnucash
07:47:30 <chris> I have another trick up my sleeve for balsheet-pnl.scm: multicolumn income statement *can* show parent accounts with subtotals as clicky links, which will generate a transaction report with the selected accounts
07:50:05 <chris> https://imgur.com/a/iNHt1p3
08:26:38 <warlord> .
08:26:54 *** ChanServ sets mode: +qo warlord warlord
08:26:56 *** warlord sets mode: +o gncbot
08:28:45 *** jervin has joined #gnucash
08:30:40 *** Mechtilde has joined #gnucash
08:36:03 *** jervin has quit IRC
08:37:07 *** jervin has joined #gnucash
08:38:25 *** jervin has quit IRC
08:38:52 *** Mechtilde has quit IRC
08:48:57 *** User_ has quit IRC
08:51:43 *** oozer has joined #gnucash
09:07:22 *** jervin has joined #gnucash
09:12:34 *** jervin has quit IRC
09:19:04 <chris> warlord: do you still use gnucash on day-to-day basis?
09:20:42 <warlord> I do... Mostly for personal use. I don't have many biz txns any more as my consulting biz is sitting mostly idle.
09:25:54 <chris> nice... and what's YOUR wishlist? :)
09:27:02 <warlord> To fix the 3.x regression in the reconcile window where, when you add or modify a transaction in the register, the reconcile window list now resets back to the top instead of keeping focus where you were.
09:31:00 <chris> ah there's nothing in bugzilla on this ;)
09:32:34 <warlord> chris, yes there is.. https://bugs.gnucash.org/show_bug.cgi?id=797236
09:33:35 *** Gerd has joined #gnucash
09:58:40 *** oozer has quit IRC
10:08:48 *** omnireq_ has quit IRC
10:12:46 *** Gerd has quit IRC
10:16:11 *** Mechtilde has joined #gnucash
10:24:34 *** Mechtilde has quit IRC
10:25:14 *** kael has joined #gnucash
10:25:14 *** ChanServ sets mode: +v kael
10:44:06 *** storyjesse has quit IRC
10:56:53 *** kael has quit IRC
11:01:23 *** Gerd has joined #gnucash
11:07:30 <gjanssens> jralls: I'm slowly progressing with my guile-to-bindings extraction
11:08:04 <gjanssens> Right now I'm working on libgnucash/gnc-module
11:08:42 <gjanssens> In the source itself is fairly straight forward to separate the guile wrapper from the module code
11:08:59 <gjanssens> The tests for gnc-module are more convoluted
11:09:34 <gjanssens> And IMO the tests are not very unit-like
11:10:03 <gjanssens> So I wanted to discuss this with you before I start clearing that out
11:10:45 <gjanssens> The code shows its origins in the days of gnucash being a guile program
11:11:09 <gjanssens> Several of the tests do something like
11:11:14 <gjanssens> 1. load a module
11:11:52 <gjanssens> 2. call a swigified function inside that module and see if that works
11:12:27 <gjanssens> Variants are loading a module that depends on another module and then test if running a swigified function inside that depency also works
11:12:46 <gjanssens> To me that's testing too much in one bite:
11:13:25 <gjanssens> You either test loading a module and see whether you can call a C function in that module or you test whether code can be successfully swigified
11:14:17 <gjanssens> Those are two separate things and it's one of gnucash' design problems these are constantly convoluted.
11:15:12 <gjanssens> So my idea is to start by redoing the module loading test with normal C-only modules
11:15:31 <gjanssens> And I am mostly wondering if that isn't sufficient
11:16:51 <gjanssens> Loading swigified code is tested in several other tests not directly related to gnc-module, so I don't really see a reason to add this to gnc-module loading tests
11:17:49 <gjanssens> Unless you'd think such a test would cover something not covered by the separate unit tests ?
11:20:11 <gjanssens> Or to put it differently: I see only two elements the need to be tested:
11:20:15 <gjanssens> 1. can gnc-module successfully load a module/chain of dependent modules
11:21:10 <gjanssens> 2. can guile load swigified code (which in itself is not a gnc-module)
11:22:24 *** boldstripe has quit IRC
11:23:09 <gjanssens> The gnc-module tests have a mixture of this: the C tests try to load one or more modules and then use scm_c_ (!) functions to test if guile can find the swigified functions that happen to be part of the gnc-module but which to guile itself are not gnc-modules at all
11:23:19 *** boldstripe has joined #gnucash
11:25:09 <gjanssens> In addition it has tests directly from guile for the same. These make slightly more sense to me, although I believe using gnc-modules inside guile code is a poor design choice
11:25:15 * gjanssens is working on fixing that...
11:31:22 *** oozer has joined #gnucash
11:40:40 *** fell has joined #gnucash
11:40:40 *** ChanServ sets mode: +o fell
12:09:12 *** Mechtilde has joined #gnucash
12:15:00 *** guak has joined #gnucash
12:16:10 *** Gerd has quit IRC
12:55:38 *** biomanu has quit IRC
12:56:33 *** Gerd has joined #gnucash
13:04:50 *** jervin has joined #gnucash
13:06:52 *** jervin has quit IRC
13:06:59 *** jervin has joined #gnucash
13:15:57 *** jervin has quit IRC
13:16:04 *** jervin has joined #gnucash
13:16:41 *** fell has quit IRC
13:23:04 *** boldstripe has quit IRC
13:24:00 *** boldstripe has joined #gnucash
13:27:09 *** Gerd has quit IRC
13:35:25 *** jervin has quit IRC
14:03:01 *** calvinct has joined #gnucash
14:03:54 *** mauritslamers has joined #gnucash
14:03:54 *** ChanServ sets mode: +v mauritslamers
14:08:21 *** frakturfreak has joined #gnucash
14:08:21 *** ChanServ sets mode: +v frakturfreak
14:14:48 *** jethrogb has quit IRC
14:52:23 *** Mechtilde has quit IRC
14:52:24 *** sbluhm has joined #gnucash
14:52:25 *** ChanServ sets mode: +v sbluhm
14:57:25 *** Mechtilde has joined #gnucash
15:03:53 *** kael has joined #gnucash
15:03:53 *** ChanServ sets mode: +v kael
15:12:33 *** calvinct has quit IRC
15:13:37 *** jethrogb has joined #gnucash
15:23:45 *** boldstripe has quit IRC
15:24:39 *** boldstripe has joined #gnucash
15:29:14 *** calvinct has joined #gnucash
15:43:14 *** sbluhm has quit IRC
15:54:26 *** ArtGravity has joined #gnucash
15:54:26 *** ChanServ sets mode: +v ArtGravity
15:56:42 *** oliver has joined #gnucash
15:57:58 <oliver> hi
15:59:48 <oliver> I've got problem using Gnucash 2.6.21 with onlinebanking in Germany... HBCI says the product is not FinTS-registered :-(
16:00:09 <warlord> oliver, yes, you will need 3.7
16:00:14 <warlord> You need AqB
16:00:15 <oliver> ah ok
16:00:20 <warlord> (need an updated AqB)
16:01:40 <oliver> I read that AqB 5.8.1 is needed, but didn't find out which AqB version is used by Gnucash 3.7 for Windows
16:01:47 <oliver> will try 3.7 now
16:13:50 <gjanssens> jralls: on the subject of gnc-module tests - I have rewritten the c-interface tests for gnc-module on my gnc-module-begone branch
16:14:40 <gjanssens> https://github.com/gjanssens/gnucash/tree/gnc-module-load-begone
16:15:14 <gjanssens> It tests
16:15:17 <gjanssens> 1. loading a module and running a function from that loaded module
16:15:22 <gjanssens> 2. unloading a module
16:16:14 <gjanssens> 3. loading a module with a module depedency (which should hence automatically be loaded as well) and running a function from both loaded modules
16:16:38 <gjanssens> This doesn't involve any guile code and IMO is sufficient to test the c side of gnc-module
16:18:09 <gjanssens> Question is whether we should now still add tests to add the guile wrapper complexity to the mix in the sense that we should test running a guile command that is in fact a wrapper for a c function in one of the modules
16:18:32 <gjanssens> Rather than just considering testing wrappers for c functions a separate test
16:19:38 <gjanssens> Obviously there's a third test that still makes sense: test whether the guile wrapper for gnc_module_load itself works correctly. That bit has moved to bindings.
16:22:42 *** fell has joined #gnucash
16:22:42 *** ChanServ sets mode: +o fell
16:24:19 *** gjanssens has quit IRC
16:29:36 *** calvinct has quit IRC
16:30:16 *** fell has quit IRC
16:32:20 *** fell has joined #gnucash
16:32:20 *** ChanServ sets mode: +o fell
16:34:39 *** pohly1 has quit IRC
16:34:48 <oliver> after some experimenting with Gnucash 3.7 I now get error -109 about "could not get exclusive access"... does that ring any bells
16:34:49 <oliver> ?
16:40:24 *** fell has quit IRC
16:40:50 *** fell has joined #gnucash
16:40:51 *** ChanServ sets mode: +o fell
16:41:40 *** fell has quit IRC
16:41:56 *** fell has joined #gnucash
16:41:56 *** ChanServ sets mode: +o fell
16:43:00 *** Mechtilde has quit IRC
16:43:39 *** fell has quit IRC
16:43:46 *** fell has joined #gnucash
16:43:46 *** ChanServ sets mode: +o fell
16:44:07 *** Mechtilde has joined #gnucash
16:45:05 *** fell_laptop has joined #gnucash
16:45:05 *** fell has quit IRC
16:45:05 *** ChanServ sets mode: +o fell_laptop
16:45:52 *** fell_laptop is now known as fell
16:47:12 *** Mechtilde has quit IRC
16:54:47 *** calvinct has joined #gnucash
16:56:17 *** kael has quit IRC
17:00:18 <fell> hm, from https://code.gnucash.org/builds/win32/build-logs/maint/2019-11/build-maint-2019-11-19-03-01-02.log:
17:00:28 <fell> *** module gnucash-git not built due to non buildable aqbanking *** [14/16]
17:02:09 *** calvinct has quit IRC
17:03:12 <fell> and in build-maint-2019-11-20-03-01-02.log, too. jralls?
17:06:28 *** CDB-Man_ has quit IRC
17:06:30 *** CDB-Man has joined #gnucash
17:06:30 *** ChanServ sets mode: +v CDB-Man
17:08:42 *** frakturfreak has quit IRC
17:15:33 <fell> libtool: install: ranlib /c/gcdev64/gnucash/maint/inst/_jhbuild/root-libchipcardC:/gcdev64/gnucash/maint/inst/lib/gwenhywfar/plugins/78/ct/ddvcard.a
17:15:34 <fell> C:\gcdev64\msys2\mingw32\bin\ranlib.exe: 'C:\gcdev64\gnucash\maint\inst\_jhbuild\root-libchipcardC;C:\gcdev64\msys2\gcdev64\gnucash\maint\inst\lib\gwenhywfar\plugins\78\ct\ddvcard.a': No such file
17:17:07 <fell> libtool: warning: '../../lib/client/libchipcard.la' has not been installed in '/c/gcdev64/gnucash/maint/inst/lib'
17:21:54 <fell> The first error:
17:21:55 <fell> libtool: install: ranlib /c/gcdev64/gnucash/maint/inst/_jhbuild/root-libchipcardC:/gcdev64/gnucash/maint/inst/lib/gwenhywfar/plugins/78/ct/ddvcard.a
17:21:56 <fell> C:\gcdev64\msys2\mingw32\bin\ranlib.exe: 'C:\gcdev64\gnucash\maint\inst\_jhbuild\root-libchipcardC;C:\gcdev64\msys2\gcdev64\gnucash\maint\inst\lib\gwenhywfar\plugins\78\ct\ddvcard.a': No such file
17:21:58 <fell> make[4]: *** [Makefile:449: install-crypttokenpluginLTLIBRARIES] Error 1
17:24:25 *** boldstripe has quit IRC
17:25:21 *** boldstripe has joined #gnucash
17:46:47 *** User_ has joined #gnucash
17:51:21 *** User_ has quit IRC
17:58:12 *** Gerd has joined #gnucash
18:02:24 <oliver> ok, die normale 3.7 crasht, wenn man HBCI verwendet; aber mit der neuesten maint-Version gehts besser
18:02:56 <oliver> (uh, sorry for German text)
18:03:53 <oliver> so with latest maint version I can set up the HBCI access with Skatbank, but the "Online-Aktionen"-Menu has lots of insensitive menu items now
18:10:47 *** bertbob has quit IRC
18:11:43 *** AndroUser2 has quit IRC
18:20:02 *** bertbob has joined #gnucash
18:20:03 *** ChanServ sets mode: +v bertbob
18:21:46 <warlord> fell, is there a 3.7-1 for windows that works with HBCI?
18:24:13 *** mr_sm1th has joined #gnucash
18:24:13 *** ChanServ sets mode: +v mr_sm1th
18:27:49 *** AndroUser2 has joined #gnucash
18:30:20 <oliver> btw. are there important differences between the versions for Win, Mac, Linux? Those are the OSs I could get access to, in case Gnucash works better on one of these
18:32:26 <warlord> Well, GnuCash is primarily implemented in Linux. But we do have a Mac developer. Windows is more like a 2nd class citizen.
18:37:12 *** Gerd has quit IRC
18:39:35 *** bertbob has quit IRC
18:46:16 <ankenyr> So I was trying to debug my issue a bit more while the kid was asleep today. All I can figure so far without diving into the code is that gnucash might not support brokerage investment syntax? I could get transactions in my checking account with schwab to work but getting all my stocks has been impossible.
18:49:48 <ankenyr> Need to try and read the ofx spec when I get another free block. Looking at the one I downloaded using the python library ofxtools and a QFX (which I understand it OFX extended a bit) from a different account that parses correctly, there seems to be very different fields
18:52:49 *** bertbob has joined #gnucash
18:52:49 *** ChanServ sets mode: +v bertbob
18:54:26 *** mr_sm1th has quit IRC
18:56:17 <ankenyr> ok yea, looks like the stuff I am getting from Schwab via ofxtools is defined in 13.9.2.2 Investment Statement Response <INVSTMTRS> https://www.ofx.net/downloads/OFX%202.2.pdf
18:57:05 *** chf1 has joined #gnucash
18:57:07 <ankenyr> Can anyone attest that this should be supported? If not when I get another bit of time I will start diving into the code if I can, baby is due to wake up soon
18:57:11 *** chf has quit IRC
19:05:19 <fell> Oliver: Currently the Flathub-maint-nightly is most recent.
19:05:55 <fell> Windows seems not to build correctly.
19:08:46 <fell> Warlord: To get progress with PSD2 issuses in FinTS (ex HBCI) is thereason to build the nightlies with betas from the aqbanking family.
19:22:12 <fell> ankenyr: If you download an OFX file from there, can you import it or do you get errors, too?
19:29:00 <ankenyr> If I download the OFX file from my Schwab brokerage account and try to import it using File> Import> Import OFX/QFX I get no transactions listed in the "Generic import transaction matcher" screen
19:47:45 *** ArtGravity has quit IRC
20:03:03 <chris> FWIW there are major slowdowns in balsheet-pnl related to get-cell-anchor-fn for balancesheet. it will always scan account->splitlist. i'll try optimise.
20:16:02 *** guak has quit IRC
20:22:45 <ankenyr> @fell in case notifications for all messages are off
20:22:45 <gncbot> ankenyr: Error: "fell" is not a valid command.
20:23:34 <ankenyr> fell: let me know if you would want a sample of the file i see with redacted/chaned info
20:27:06 <fell> ankenyr: Where I live, people use FinTS/HBCI. So you would better ask on the mailing list, where other directOFX users are around.
20:30:28 <fell> Obvisious (see wiki) some of them can at least download "normal" accounts, but also investments?
20:31:19 <fell> If yes, are there additional steps required?
20:32:39 <fell> Which formats are usable a) by the importer, b) by directOFX?
20:32:42 <fell> ...
20:34:50 <fell> Ideally one of you would finally update the wiki. :-)
20:56:47 *** oozer has quit IRC
21:19:32 *** boldstripe_ has joined #gnucash
21:19:47 *** boldstripe has quit IRC
21:19:47 *** boldstripe_ is now known as boldstripe
21:20:49 *** AndroUser2 has quit IRC
21:22:30 *** omnireq has joined #gnucash
21:24:55 <ankenyr> fell Happy to update the wiki all day long if I could figure this out. Maintain an open source library myself called Capirca
22:02:16 *** jervin has joined #gnucash
22:15:28 <ankenyr> fell: I figured it out, I totally goofed on something. I re-read the link a couple more times just to double check my procedure and went along with it on a fresh gnucash file. I feel dumb, used a diff tool to compare the stuff in the wiki to what I have in my file
22:19:49 *** omnireq has quit IRC
22:20:28 <ankenyr> huh ok so it has the transactions but it doesn't give me the amount of stocks actually purchased.
22:21:26 *** storyjesse has joined #gnucash
22:21:47 *** gggg has quit IRC
22:22:21 <fell> I could imagine, aqbankings ofx component was not intended to trade commodities.
22:23:16 <fell> but I never looked in the sources of that component..
22:23:45 <ankenyr> could do them manually, do you keep track of stocks in your gnucash account?
22:24:20 <ankenyr> If so do you have a recommendation on how to setup the accounts, looks like the best way would be to have a parent of the account, then sub accounts for each stock?
22:24:42 <fell> yes, I get the quotes by F::Q, but enter the trades manually.
22:27:17 <fell> Yep, and in DE we additionally have to distinguish buys before a special date in a separate account from that after that date.
22:31:32 *** jervin has quit IRC
22:31:45 <ankenyr> I am guessing the protocol the DE banks use is easier than OFX? When I called Schwab as my first step they had no idea what I was talking about
22:34:57 *** oliver has quit IRC
22:36:40 *** oliver has joined #gnucash
22:40:33 <fell> Oh, today the banks wish you use their mobile app, before their website. We others have always been exots.
22:41:23 <fell> But they created one standard, which is used by all devices.
22:43:13 <fell> Only recently an update produced terrible troubles: EU's PSD2 directive.
23:15:55 *** mattcen has joined #gnucash
23:18:14 *** ChanServ sets mode: +v mattcen
23:18:45 *** mattcen has left #gnucash
23:18:54 *** mattcen has joined #gnucash
23:18:54 *** ChanServ sets mode: +v mattcen
23:26:08 <mattcen> Hey folks, I'm trying to "Import Transactions from CSV" on GnuCash 3.7 on MacOS. The accounts names in the CSV match those in the GnuCash database, but it still wants me to manually map them (and there are lots). How can I make it auto-map them?
23:37:34 <ankenyr> If it would take too long because there are too many transactions, could you use a simple script to split the CSV into account specific sub CSVs since the accounts are provided as a column?
23:40:16 <fell> Both: To train the Bayesian algorithm start your import with small chunks and assign the accounts correctly.
23:41:04 <fell> When you see, th algorithem assigns them in the right way, you can take greater chunks.
23:42:28 *** fell has quit IRC
23:46:19 <mattcen> ankenyr: I *could* do that, but it'd take longer to go through the wizard for 276 CSVs than it would to manually specify 276 accounts in a single wizard run :)
23:47:08 <ankenyr> no worries, just my own suggestion, fell has a much better suggestion, and wow lots of accounts
23:47:19 *** fell has joined #gnucash
23:47:19 *** ChanServ sets mode: +o fell
23:47:36 <ankenyr> I am still a newb at gnucash myself
23:48:18 <mattcen> oh, I didn't realise fell was talking to me; now I read it again, I see what you mean. Thanks; I'll give that a shot!