2017-03-12 GnuCash IRC logs
00:13:22 *** gnomey has quit IRC
00:14:33 *** gnomey has joined #gnucash
00:30:39 *** gnomey has quit IRC
00:32:30 *** tuxd00d has quit IRC
00:33:52 *** gnomey has joined #gnucash
01:04:35 *** gnomey has quit IRC
01:05:27 *** gnomey has joined #gnucash
01:15:28 *** gnomey has quit IRC
01:16:25 *** gnomey has joined #gnucash
01:21:50 *** ImageJPEG has joined #gnucash
01:22:59 *** gnomey has quit IRC
01:24:55 *** gnomey has joined #gnucash
01:27:16 *** fell_ has joined #gnucash
01:29:13 *** fell has quit IRC
01:39:12 *** gnomey has quit IRC
01:45:25 *** gnomey has joined #gnucash
01:50:02 *** gnomey has quit IRC
01:52:38 *** gnomey has joined #gnucash
03:01:10 *** gnomey has quit IRC
03:02:55 *** ImageJPEG has quit IRC
03:07:55 *** gnomey has joined #gnucash
03:29:35 *** librarian-bob has joined #gnucash
03:31:11 *** gnomey has quit IRC
03:31:56 *** gnomey has joined #gnucash
03:35:04 *** gnomey has quit IRC
03:35:54 *** librarian-bob has quit IRC
03:39:48 *** gnomey has joined #gnucash
03:46:11 *** gnomey has quit IRC
03:48:55 *** gnomey has joined #gnucash
03:53:38 *** gnomey has quit IRC
03:55:25 *** gnomey has joined #gnucash
03:56:44 *** redarrow has quit IRC
04:04:51 *** bertbob has quit IRC
04:06:54 *** bertbob has joined #gnucash
04:07:25 *** gnomey has quit IRC
04:14:54 *** redarrow has joined #gnucash
04:18:26 *** gnomey has joined #gnucash
04:21:09 *** Mechtilde has joined #gnucash
04:27:37 *** gnomey has quit IRC
04:28:11 *** redarrow has quit IRC
04:28:57 *** gnomey has joined #gnucash
04:45:41 *** gnomey has quit IRC
04:59:57 *** gnomey has joined #gnucash
05:07:45 *** gnomey has quit IRC
05:13:57 *** gnomey has joined #gnucash
05:18:47 *** gnomey has quit IRC
05:23:39 *** fabior has joined #gnucash
05:28:58 *** gnomey has joined #gnucash
05:36:53 *** gnomey has quit IRC
05:39:59 *** gnomey has joined #gnucash
05:46:09 *** mlncn has quit IRC
05:48:41 *** gnomey has quit IRC
05:52:00 *** gnomey has joined #gnucash
05:59:54 *** mlncn has joined #gnucash
06:02:28 *** fabior has quit IRC
06:09:03 *** gnomey has quit IRC
06:15:59 *** gnomey has joined #gnucash
06:24:12 *** gnomey has quit IRC
06:26:59 *** gnomey has joined #gnucash
06:41:49 *** gnomey has quit IRC
06:46:30 *** gnomey has joined #gnucash
06:47:35 *** gjanssens has joined #gnucash
06:47:35 *** ChanServ sets mode: +o gjanssens
06:53:16 *** f3px has joined #gnucash
06:53:41 *** gnomey has quit IRC
07:00:59 *** Mechtilde has quit IRC
07:04:29 *** gnomey has joined #gnucash
07:14:16 *** gnomey has quit IRC
07:16:30 *** gnomey has joined #gnucash
07:25:50 *** gnomey has quit IRC
07:35:47 *** gnomey has joined #gnucash
07:43:33 *** gnomey has quit IRC
07:47:53 *** gnomey has joined #gnucash
07:54:51 *** gnomey has quit IRC
07:57:31 *** gnomey has joined #gnucash
08:03:34 *** gnomey has quit IRC
08:06:01 *** gnomey has joined #gnucash
08:16:14 *** gnomey has quit IRC
08:27:36 *** gnomey has joined #gnucash
08:30:52 *** gnomey has quit IRC
08:36:03 *** Mechtilde has joined #gnucash
08:42:32 *** gnomey has joined #gnucash
08:45:54 *** gnomey has quit IRC
08:48:32 *** gnomey has joined #gnucash
08:51:33 *** gnomey has quit IRC
08:51:51 *** bertbob has quit IRC
08:53:31 *** gnomey has joined #gnucash
08:59:55 *** User_ has joined #gnucash
09:01:50 *** gnomey has quit IRC
09:03:32 *** gnomey has joined #gnucash
09:13:48 *** gnomey has quit IRC
09:15:15 *** gnomey has joined #gnucash
09:15:49 *** bertbob has joined #gnucash
09:17:08 *** Jimraehl1 has joined #gnucash
09:19:06 *** bertbob has quit IRC
09:23:11 *** gnomey has quit IRC
09:27:39 *** gnomey has joined #gnucash
09:35:08 *** bertbob has joined #gnucash
09:37:48 *** gnomey has quit IRC
09:40:31 *** gnomey has joined #gnucash
09:41:29 *** mlncn has quit IRC
09:46:57 *** gnomey has quit IRC
09:56:01 *** gnomey has joined #gnucash
10:01:55 *** gnomey has quit IRC
10:09:31 *** gnomey has joined #gnucash
10:11:50 *** mlncn has joined #gnucash
10:14:08 *** gnomey has quit IRC
10:23:03 *** Mechtilde has quit IRC
10:24:28 *** Mechtilde has joined #gnucash
10:28:01 *** gnomey has joined #gnucash
10:32:02 *** gnomey has quit IRC
10:51:01 *** gnomey has joined #gnucash
10:56:42 *** gnomey has quit IRC
10:57:09 *** gnomey has joined #gnucash
10:58:38 *** miklcct has quit IRC
11:05:06 *** miklcct has joined #gnucash
11:07:58 *** gnomey has quit IRC
11:26:03 *** gnomey has joined #gnucash
11:30:25 *** gnomey has quit IRC
11:39:03 *** gnomey has joined #gnucash
11:45:37 *** gnomey has quit IRC
12:00:40 *** To7 has joined #gnucash
12:08:08 *** Mechtilde has quit IRC
12:13:19 *** Mechtilde has joined #gnucash
12:16:34 *** Mechtilde has quit IRC
12:20:33 *** gnomey has joined #gnucash
12:22:29 *** Mechtilde has joined #gnucash
12:25:41 *** gnomey has quit IRC
12:42:39 *** Mechtilde has quit IRC
12:48:04 <jralls> gjanssens: I had a random thought this morning: How much harder would it be to convert to gtkmm3 instead of gtk3?
12:49:02 *** gnomey has joined #gnucash
12:53:10 *** gnomey has quit IRC
12:53:32 *** gnomey has joined #gnucash
12:57:20 *** gnomey has quit IRC
12:59:45 *** tuxd00d has joined #gnucash
13:02:37 *** gnomey has joined #gnucash
13:08:23 *** gnomey has quit IRC
13:14:43 *** tuxd00d has quit IRC
13:19:32 *** gnomey has joined #gnucash
13:23:03 *** gnomey has quit IRC
13:47:11 *** bertbob has quit IRC
13:52:31 *** bertbob has joined #gnucash
13:55:34 *** bertbob has quit IRC
14:04:00 *** tuxd00d has joined #gnucash
14:07:32 *** gnomey has joined #gnucash
14:11:43 *** gnomey has quit IRC
14:11:46 *** bertbob has joined #gnucash
14:16:10 *** mlncn has quit IRC
14:31:08 <gjanssens> jralls: quite a bit harder
14:31:28 <gjanssens> for gtk3 we only need to update a couple of deprecated api's
14:31:46 <gjanssens> for gtk3mm we'd have to redo each and every gui element
14:32:19 <jralls> OK. I wonder if we can mix gtk and gtkmm... but let's leave that for another time.
14:32:35 <gjanssens> Yes, that thought crossed my mind as well
14:32:54 <gjanssens> And I agree it's better to try that later
14:43:34 *** gnomey has joined #gnucash
14:47:16 *** gnomey has quit IRC
14:54:48 *** fabior has joined #gnucash
15:05:15 *** frakturfreak has joined #gnucash
15:27:35 *** gnomey has joined #gnucash
15:31:17 *** gnomey has quit IRC
15:41:34 *** gnomey has joined #gnucash
15:43:02 *** tuxd00d has quit IRC
15:45:43 *** gnomey has quit IRC
15:48:56 <jralls> codesmythe: I'm having an issue with cmake: FIND_PACKAGE(LibXslt) is unsetting PKG_CONFIG_EXECUTABLE, preventing use of GNC_PKG_CHECK_MODULES after the call. Any ideas how to fix?
15:51:04 *** gnomey has joined #gnucash
15:58:46 *** gnomey has quit IRC
16:04:07 *** tuxd00d has joined #gnucash
16:06:34 *** gnomey has joined #gnucash
16:13:38 *** gnomey has quit IRC
16:13:55 *** warlord has quit IRC
16:15:05 *** fabior has quit IRC
16:16:33 *** gnomey has joined #gnucash
16:19:42 *** gnomey has quit IRC
16:22:33 *** gnomey has joined #gnucash
16:27:13 *** gnomey has quit IRC
16:36:33 *** gnomey has joined #gnucash
16:39:00 *** tuxd00d has quit IRC
16:46:30 *** gnomey has quit IRC
16:47:57 *** gnomey has joined #gnucash
16:51:41 *** Kaell2 has joined #gnucash
16:52:02 *** gnomey has quit IRC
16:53:07 *** tuxd00d has joined #gnucash
16:53:34 *** gnomey has joined #gnucash
17:10:39 *** gnomey has quit IRC
17:12:50 *** frakturfreak has quit IRC
17:13:21 *** tuxd00d has quit IRC
17:14:03 *** User_ has quit IRC
17:15:19 *** User has joined #gnucash
17:17:32 *** tuxd00d has joined #gnucash
17:22:04 *** gnomey has joined #gnucash
17:26:39 *** User has quit IRC
17:36:55 *** gnomey has quit IRC
17:40:04 *** gnomey has joined #gnucash
17:48:01 *** gnomey has quit IRC
17:50:34 *** gnomey has joined #gnucash
18:09:17 *** User has joined #gnucash
18:17:24 *** gnomey has quit IRC
18:18:35 *** gnomey has joined #gnucash
18:33:28 *** gnomey has quit IRC
18:34:36 *** gnomey has joined #gnucash
18:39:25 *** huff has joined #gnucash
18:42:49 <huff> Has anyone had success getting OFX downloading from Edward Jones investment broker to work? I can get it with Quicken, but all attempts through GC and alternatives from GC's wiki fail.
18:44:38 *** gnomey has quit IRC
18:45:04 <jralls> huff: When you get the data with Quicken do you log in to the broker's website first?
18:45:05 *** gnomey has joined #gnucash
18:46:15 <jralls> huff: Did you try the setup parameters from http://www.ofxhome.com/index.php/institution/view/608
18:46:24 <huff> No. Sadly when logging into their website all you can get is XLS or CVS with sketchy data (insufficient details). There is a separate login process for direct OFX downloading.
18:47:28 <huff> Yes, I tried the parameters listed. I can get a dialog, but only get an error code in the response results.
18:47:49 <jralls> huff: I was trying to distinguish between OFX DirectConnect, which AQBanking supports, and OFX WebConnecct, which it doesn't. The user-visible difference is in how you authenticate.
18:48:51 <huff> As best I can tell, it looks from the Quicken transaction logs like QfW sends a message to Intuit and then sends one to EdJones that looks like a two-factor conversation going on that validates that I'm using an approved version of Quicken. Can't do that with GC.
18:49:31 <huff> AQBanking was one of the ways I tried.
18:50:10 <huff> I also tried a python script that I beat into unrecognizability trying to tweak it into success.
18:51:00 <jralls> Yeah, another way for Intuit to lock-in customers. You're not likely to be able to defeat that, Intuit understand how to secure their communications.
18:51:38 <huff> The python script started out as ofx-batch that I downloaded off the web.
18:51:55 <jralls> Your best hope is if you have an especially large account you can threaten to move it unless they make it possible to get your transactions.
18:52:36 <huff> Sadly, not enough commas in my balance to think that might work.
18:53:19 <huff> Haven't had any luck trying to reach anyone in EdJones IT to talk to about it either. The broker reacts like I'm talking martian.
18:54:06 <huff> It's really frustrating when you're a software engineer and you can't figure out a way to solve a computer communication problem.
18:54:18 <jralls> So fire them. I don't know offhand what brokers support OFX DirectConnect, I don't use it for my brokerage accounts.
18:56:11 <huff> Investment transactions are something I don't understand well enough, or I might have just done it all by hand, but having started with QfW, I have seen enough that I dread the thought. I might have to just settle for periodically updating the cash value balance after tossing all the individual stock data.
18:56:51 *** mlncn has joined #gnucash
18:57:52 <jralls> The Tutorial and Concept Guide has a section on handling investments that you should study. GnuCash isn't really oriented towards users who don't understand their transactions.
18:58:20 <jralls> But tries to facilitate their learning...
18:58:32 <huff> I'll take a look.
18:58:40 *** gjanssens has quit IRC
18:59:57 *** huff has quit IRC
19:08:50 *** gnomey has quit IRC
19:09:08 *** gnomey has joined #gnucash
19:33:04 *** gnomey has quit IRC
19:34:08 *** gnomey has joined #gnucash
19:45:32 *** tuxd00d has quit IRC
20:18:37 *** User has quit IRC
20:26:45 *** gnomey has quit IRC
20:27:06 *** gnomey has joined #gnucash
20:31:08 *** tuxd00d has joined #gnucash
20:50:34 *** huff has joined #gnucash
20:51:34 <huff> Ok. Tried using my bashed up python script again. After googling the error code (2003), it looks like I
20:51:51 <huff> somehow have not properly identified my account.
20:52:21 <huff> However, the transcript looks the same as the "successful" QfW transcript from a couple of days ago.
20:52:57 <huff> I'm wondering if I'm not properly formatting things like the date fields or the UID fields.
20:54:03 <huff> Or, worse, there needs to be only certain control characters at the end of the lines (CR only? LF only? CRLF? LFCR?).
20:54:50 <jralls> huff: Maybe wireshark instead of just a transcript?
20:55:24 <huff> Does that involve a lot of setup? I've heard of it, but never tried it.
20:56:16 <huff> Also, can I use it on a linux box to capture the QfW exchange as well as the exchange from my python script (running on the linux box)?
20:59:55 <jralls> Depends. It'll capture the python script no problem. It can capture the Windows traffic if it can see it, but if you've got your net wired with a switch it can't. You can use https://www.microsoft.com/en-us/download/details.aspx?id=4865 on the Windows box to capture that traffic.
21:00:07 <huff> Would it matter that my OFX query had "<DTSTART>20170209" whereas the QfW version of the OFX query had "<DTSTART>20170306092925.147[-6:CST]"?
21:00:50 <huff> Meaning that I didn't have the hhmmss.nnn[GMT-Offset] part?
21:01:10 <jralls> No idea. I wouldn't think so, but it all depends on how the server's OFX library is set up.
21:01:46 <huff> Hmmm. Guess I can try to expand that part, too.
21:05:12 <huff> Also, I'd been using a time stamp for the value in the NEWFILEUID whereas the QfW started with an <anonymous0000000...> login that supplied "NONE" for the NEWFILEUID and OLDFILEUID fields and got a TRNUID value back that appears to
21:06:15 <huff> have been used as a starting value that had the first 8-character hexadecimal value incremented for subsequent NEWFILEUIDs and TRNUIDs.
21:07:34 <huff> e.g. TRNUID recieved = 70F34C70-7C9E-1000-8FF9-EFF16A370026, next query had NEWFILEUID:70F34C71-7C9E-1000-8FF9-EFF16A370026 and <TRNUID>70F34C72-7C9E-1000-8FF9-EFF16A370026.
21:09:39 *** kael has joined #gnucash
21:12:11 <jralls> I don't quite follow on the TRNUIDs. Is QfW feeding those back to the server or is the server just streaming them?
21:12:25 <huff> Looking into the Network Monitor package now. Will probably wait until tomorrow for a fresh start and then try capturing both the QfW and ofx-batch.py exchanges with Edward Jones and see what I can glean from those.
21:13:53 <huff> Sorry. Regarding the UIDs, QfW sends a query with a userid of "anonymous" with a bunch of zeroes on the end. The response reports success and in the response is a TRNUID with the value I reported above.
21:14:43 <huff> Then the next QfW query of Edward Jones uses that TRNUID (with the first 8 character hexadecimal value incremented) as the NEWFILEUID.
21:15:10 <huff> Then the TRNUID sent in the second query is the TRNUID incremented a second time.
21:16:16 <huff> So 70F34C70 becomes 70F34C71... used for the NEWFILEUID and becomes 70F34C72... for the TRNUID in the second query.
21:16:50 <jralls> OK. That's probably how the server is maintaining session state.
21:17:24 *** Heisenburg has joined #gnucash
21:18:58 <huff> Hmmm. Maybe I need to emulate that and run a dummy query to start in order to get a value from the server and do the hex math on it to manufacture values for my query rather than just using a static datetime stamp generated at the start of the ofx-batch.py script.
21:22:01 <huff> Oh well, looks like I have my "entertainment" for this week mapped out. Depending on how much gets done and how fast, but doubt I'll be back to discuss any further problems for a few days, or if I'm lucky to report the problem solved.
21:22:28 <jralls> Good luck. I think you'll need it.
21:22:45 <huff> Thanks for the feedback and the pointer for the Network Monitor tool.
21:22:47 <huff> Bye
21:22:54 *** huff has quit IRC
21:27:10 *** tuxd00d has quit IRC
21:27:35 *** gnomey has quit IRC
21:28:07 *** gnomey has joined #gnucash
21:34:10 *** Heisenburg has quit IRC
22:17:55 *** warlord has joined #gnucash
22:17:56 *** gncbot sets mode: +o warlord
22:38:44 *** kael has quit IRC
22:40:46 *** codesmythe has quit IRC
22:41:26 *** codesmythe has joined #gnucash
22:43:15 <codesmythe> jralls: I don't have any ideas for your PKG_CONFIG_EXECUTABLE problem off the top of my head. Any luck resolving t?
22:46:10 *** Artefact2 has quit IRC
22:50:28 *** To7 has quit IRC
22:52:24 *** Artefact2 has joined #gnucash
23:04:41 *** gnomey has quit IRC
23:05:10 *** gnomey has joined #gnucash
23:40:28 *** warlord has quit IRC
23:54:47 *** gnomey has quit IRC
23:56:11 *** gnomey has joined #gnucash
23:59:06 *** codesmythe has quit IRC