2017-10-29 GnuCash IRC logs
01:33:37 *** eatin has joined #gnucash
01:35:15 *** eatin has quit IRC
02:18:52 <Chris> @tell jralls - I've summarised Doug's changes at https://github.com/christopherlam/gnucash-multicolumn/issues/1 - my main concerns relate to (1) confusing and untested algorithms, all requiring separate derivatives of transaction.scm and most filters can be backported without difficulty
02:18:52 <gncbot> Chris: The operation succeeded.
02:21:48 *** Mechtilde has joined #gnucash
02:22:09 <Chris> (2) the code quality / strings also need a lot of polish. e.g. errant close-parens everywhere :-O, spell mistakes, unclear description/purpose of report/tooltips...
02:22:20 <Chris> @tell jralls (2) the code quality / strings also need a lot of polish. e.g. errant close-parens everywhere :-O, spell mistakes, unclear description/purpose of report/tooltips...
02:22:20 <gncbot> Chris: The operation succeeded.
02:23:46 <Chris> @tell jralls (3) all/most rely on gncdatetime-utilities.scm which seems an extension of some dateutil functions to support his preferred date selectors, and during testing a few months ago, we weren't sure where to store this library... placing within Program Files\gnucash led to crashy windows etc
02:23:46 <gncbot> Chris: The operation succeeded.
02:25:10 *** Mechtilde has quit IRC
02:27:40 <Chris> @tell jralls summary - some ideas can be easily backported; others e.g. consolidate-transactions is I think similar to & better than income-statement.scm because it can accept more account types
02:27:40 <gncbot> Chris: The operation succeeded.
02:28:15 <Chris> @tell jralls anyway lots of work involved :)
02:28:15 <gncbot> Chris: The operation succeeded.
02:42:54 *** Mechtilde has joined #gnucash
03:41:40 *** Mechtilde has quit IRC
03:55:43 *** Mechtilde has joined #gnucash
04:28:25 *** carwynnelson has joined #gnucash
04:31:26 *** carwynnelson has quit IRC
04:46:02 *** Mechtilde has quit IRC
05:05:50 *** Mechtilde has joined #gnucash
05:13:07 *** Mechtilde has quit IRC
05:29:08 *** karelk has joined #gnucash
05:34:08 *** rietta has joined #gnucash
05:51:06 *** Mechtilde has joined #gnucash
05:54:29 *** Mechtilde has quit IRC
06:08:31 *** carwynnelson has joined #gnucash
06:36:42 *** carwynnelson has quit IRC
06:37:37 *** karelk has quit IRC
06:52:39 *** carwynnelson has joined #gnucash
07:16:39 <mikee> @op
07:16:40 *** gncbot sets mode: +o mikee
07:28:11 *** finster has joined #gnucash
07:44:21 *** gjanssens has joined #gnucash
07:44:21 *** ChanServ sets mode: +o gjanssens
07:44:33 <gjanssens> .
08:01:45 *** jwhitmore has joined #gnucash
08:10:27 *** carwynnelson has quit IRC
08:13:51 *** carwynnelson has joined #gnucash
08:22:18 *** carwynnelson has quit IRC
09:03:50 *** karelk has joined #gnucash
09:44:44 *** mrklintscher11113 has joined #gnucash
09:52:54 *** User has joined #gnucash
09:53:12 *** fbruetting has joined #gnucash
09:57:14 *** storyjesse has joined #gnucash
09:58:03 *** nomeata has joined #gnucash
09:58:43 *** Mechtilde has joined #gnucash
09:59:59 *** shakes808 has joined #gnucash
10:03:32 *** shakes808 has quit IRC
10:06:47 *** Mechtilde has quit IRC
10:11:39 *** storyjesse has quit IRC
10:11:50 *** Mechtilde has joined #gnucash
10:22:39 *** carwynnelson has joined #gnucash
10:25:41 *** carwynnelson has quit IRC
10:41:47 *** Mechtilde has quit IRC
11:02:18 *** fbruetting has quit IRC
11:27:30 *** Mechtilde has joined #gnucash
11:49:42 *** nomeata has quit IRC
12:03:17 *** jwhitmore has quit IRC
12:27:13 *** fbruetting has joined #gnucash
12:30:46 *** Mechtilde has quit IRC
12:34:40 *** Mechtilde has joined #gnucash
12:43:39 *** User has quit IRC
12:58:46 *** fekepp has quit IRC
13:08:46 *** carwynnelson has joined #gnucash
13:09:38 *** carwynne_ has joined #gnucash
13:09:38 *** carwynnelson has quit IRC
13:17:56 *** carwynne_ has quit IRC
13:23:50 *** jralls has joined #gnucash
13:23:50 *** ChanServ sets mode: +o jralls
13:23:55 <jralls> .
13:23:55 <gncbot> jralls: Sent 16 hours and 17 minutes ago: <lmat> Removing delimiters: sqlite3 books.sqlite <<< select * from slots; ; returns http://sprunge.us/BePC. In xml, delimiters aren't part of the backend, but SQL uses them. Earlier you said, KVPFrames are stored hierarchically in both XML and SQL. That it's a problem for SQL is a separate issue. It looks like SQL does not store them hierarchically. What do you recommend?
13:23:56 <gncbot> jralls: Sent 14 hours and 54 minutes ago: <Chris> hm not exactly; i've mainly lifted the idea of string-matching; I need to go out now; but can summarise my views about all of his reports later
13:23:57 <gncbot> jralls: Sent 11 hours and 5 minutes ago: <Chris> - I've summarised Doug's changes at https://github.com/christopherlam/gnucash-multicolumn/issues/1 - my main concerns relate to (1) confusing and untested algorithms, all requiring separate derivatives of transaction.scm and most filters can be backported without difficulty
13:23:58 <gncbot> jralls: Sent 11 hours and 1 minute ago: <Chris> (2) the code quality / strings also need a lot of polish. e.g. errant close-parens everywhere :-O, spell mistakes, unclear description/purpose of report/tooltips...
13:23:59 <gncbot> jralls: Sent 11 hours ago: <Chris> (3) all/most rely on gncdatetime-utilities.scm which seems an extension of some dateutil functions to support his preferred date selectors, and during testing a few months ago, we weren't sure where to store this library... placing within Program Files\gnucash led to crashy windows etc
13:24:00 <gncbot> jralls: Sent 10 hours and 56 minutes ago: <Chris> summary - some ideas can be easily backported; others e.g. consolidate-transactions is I think similar to & better than income-statement.scm because it can accept more account types
13:24:01 <gncbot> jralls: Sent 10 hours and 55 minutes ago: <Chris> anyway lots of work involved :)
13:24:35 *** meb has joined #gnucash
13:25:53 *** mebX has quit IRC
13:29:30 *** Groan has joined #gnucash
13:32:54 *** Mechtilde has quit IRC
13:34:20 <jralls> lmat: No, the SQL backend is (or was, see Bob Fewell's email to the dev list) storing the path to subkeys but it's still creating a hierarchy: Notice in your example how the guid_val field in the import-map record is the value of the obj_guid field in import-map/desc, whose guid_val becomes the obj_guid of the 6 integer keys in the import-map/desc frame.
13:34:48 *** Mechtilde has joined #gnucash
13:36:03 <Groan> Hello. trying to get BoA NY transactions downloaded. When I do retrieve accounts, it doesn't appear to bring in any although i get quired for pw and cert acceptance
13:36:15 <jralls> lmat: Each of those keys contains a / in the name that is not a delimiter: There is no import-map/desc/NEW frame.
13:37:58 <Groan> when I try to dl transactions, I get, "The online banking import returned no transactions for the selected time period."
13:43:02 <jralls> Groan: AQBanking defaults to beginning the transaction retrieval as the end date of the last retrieval even if that was unsuccessful, so make sure that you're not trying to retrieve transactions only for today. Beyond that, examine the transfer log in the window to make sure that you got correctly authenticated and your request was successful. The dialog box about no transactions being returned is from GnuCash's transaction
13:43:02 <jralls> matcher and doesn't provide any diagnosis of the AQBanking session.
13:43:22 <Groan> thanks. jralls.
13:43:56 <jralls> Chris: Thanks for the review.
14:04:55 <Groan> does gnucash support express webconnect?
14:12:31 <jralls> Groan: No, only OFX Directconnect.
14:14:01 <Groan> that would explain that.
14:14:42 <Groan> so BoA only allows webconnect and express webconnect
14:16:04 *** jwhitmore has joined #gnucash
14:16:40 <Groan> doesn't sound like gnucash is a solution for me.
14:16:43 <Groan> :/
14:20:29 *** O01eg has joined #gnucash
14:24:43 *** fekepp has joined #gnucash
14:37:09 *** fbruetting has quit IRC
15:11:58 *** fekepp1 has joined #gnucash
15:12:21 *** fekepp has quit IRC
15:12:22 *** fekepp1 is now known as fekepp
15:18:18 *** carwynnelson has joined #gnucash
15:18:25 *** Mechtilde has quit IRC
15:21:19 *** carwynnelson has quit IRC
15:21:39 *** fekepp has quit IRC
15:22:43 *** Mechtilde has joined #gnucash
15:23:52 *** fekepp has joined #gnucash
15:34:22 *** Mechtilde has quit IRC
15:35:05 *** Mechtilde has joined #gnucash
15:50:57 *** Mechtilde has quit IRC
15:51:20 *** Mechtilde has joined #gnucash
15:55:18 *** Mechtilde has quit IRC
16:55:15 *** fekepp has quit IRC
17:06:20 *** carwynnelson has joined #gnucash
17:26:01 *** gjanssens has quit IRC
17:35:20 *** pilotauto has joined #gnucash
17:44:46 *** mrklintscher11113 has quit IRC
17:57:41 *** mrklintscher11113 has joined #gnucash
18:16:04 *** MrBusiness2 has quit IRC
18:38:26 *** mrklintscher11114 has joined #gnucash
18:39:34 *** mrklintscher11113 has quit IRC
18:51:58 *** fekepp has joined #gnucash
18:52:12 *** jwhitmore has quit IRC
18:55:12 *** carwynnelson has quit IRC
19:12:10 *** Groan has quit IRC
19:12:20 *** Groan has joined #gnucash
19:15:27 *** Groan has quit IRC
19:17:38 *** Groan has joined #gnucash
19:45:14 *** Groan has quit IRC
19:50:51 *** Groan has joined #gnucash
20:03:36 *** Groan has quit IRC
20:03:39 *** Groan has joined #gnucash
20:12:04 *** rietta has left #gnucash
20:17:38 *** carwynnelson has joined #gnucash
20:20:44 *** carwynnelson has quit IRC
20:24:15 *** fekepp has quit IRC
20:52:51 *** meb has quit IRC
20:53:40 <jralls> lmat: I found the error that was causing the ubuntu/autotools travis test to fail: It was a missing entry in POTFILES.skip. I was confused by the dump of the test log, which I didn't recognize until I compared it with a passing run.
21:19:20 <Chris> jralls: wish to canvas some core opinion on https://github.com/christopherlam/gnucash/pull/6 - didn't wish to clutter main github
21:19:27 *** Chris is now known as Chris_afk
21:45:22 *** jchonig has quit IRC
22:33:56 <lmat> jralls: I hadn't taken a close look a the slots schema; it's really special. Duplicate obj_guids? It seems like the schema could use some work.
22:34:41 <lmat> jralls: non-kvp-frame, non-glist entries should point to their parent glist/frame (rather than frames pointing to their children!).
22:35:40 <lmat> jralls: Excellent find on POTFILES. I'm surprised that took so long to find! Many eyes have peered over these failures.
23:02:59 *** rietta has joined #gnucash
23:07:03 *** meb has joined #gnucash
23:08:55 <rietta> What’s the best way to reconcile 2-3 invoice payments with the bank? When US-based clients pay by paper check (yes, still the norm) they sometimes come in the mail on the same day. Suppose I record the payments A, B, and C through the Customer invoice / payment screens. Now when I import the transactions from the bank and go to reconcile it is off count because the bank shows a single entry for “Commerical Deposit” that is the sum of the checks without
23:08:56 <rietta> meta data to seperate them. What’s the best way to match these up? (this happens almost monthly so it is annoying enough to figure out)
23:11:42 <rietta> So I had invoices for $1000, $2000.50, and $900, then the bank will show Commerical Deposit for $3,900.50. Then I either have to delete that which gets imported again with the next QFX or somehow map the subparts to the payments recorded through the Customber -> Process Payment workflow.
23:18:01 <lmat> rietta: I'm not sure how that will work with the business features: I've not used them. In my case, I figure it out in my head when I come to that item on the bank statement, and check all splits that apply.
23:18:10 <lmat> rietta: I agree that it's a hastle.