2017-07-17 GnuCash IRC logs
00:56:52 *** Mechtilde has joined #gnucash
01:09:54 *** Mechtilde has quit IRC
01:15:19 *** Mechtilde has joined #gnucash
01:15:43 *** vym has quit IRC
01:16:12 *** vym has joined #gnucash
01:16:15 *** vym has quit IRC
01:16:50 *** vym has joined #gnucash
01:26:20 *** fell_ has joined #gnucash
01:28:38 *** Mechtilde has quit IRC
01:28:58 *** fell has quit IRC
01:39:01 *** Groan has quit IRC
01:42:05 *** Cuare has quit IRC
01:53:46 *** Mechtilde has joined #gnucash
02:19:04 *** Mechtilde has quit IRC
03:06:59 *** storyjesse has joined #gnucash
03:15:52 *** mrklintscher has quit IRC
03:35:45 *** mrklintscher has joined #gnucash
03:35:52 *** fabior has joined #gnucash
04:03:19 *** fekepp has joined #gnucash
04:07:01 *** DataWraith has joined #gnucash
04:17:50 *** Mechtilde has joined #gnucash
04:19:14 *** jotrago has quit IRC
04:20:16 *** jotrago has joined #gnucash
05:11:29 *** fekepp has quit IRC
05:11:31 *** fekepp has joined #gnucash
05:21:57 *** pilotauto has quit IRC
05:28:51 *** Mechtilde has quit IRC
05:40:11 *** fekepp has quit IRC
05:43:21 *** Aussie_matt has joined #gnucash
05:51:46 *** Mechtilde has joined #gnucash
06:05:53 *** mlncn has joined #gnucash
06:08:11 *** fekepp has joined #gnucash
06:18:03 *** Mechtilde has quit IRC
06:24:23 *** aqua has joined #gnucash
06:28:33 *** fekepp has quit IRC
06:36:05 *** fekepp has joined #gnucash
06:38:59 *** User has joined #gnucash
06:53:00 *** aqua has quit IRC
07:08:38 *** fabior has quit IRC
07:33:42 *** jethrogb has quit IRC
07:50:40 <warlord> .
07:59:22 *** rickoehn has joined #gnucash
09:22:47 *** storyjesse has quit IRC
09:37:12 *** fabior has joined #gnucash
09:49:57 *** Aussie_matt has quit IRC
09:57:17 *** Mechtilde has joined #gnucash
10:08:01 *** Mechtilde has quit IRC
10:26:35 *** User has quit IRC
10:40:25 *** mrklintscher has quit IRC
11:01:59 *** mrklintscher has joined #gnucash
11:04:02 *** d-rock has joined #gnucash
11:06:21 <d-rock> I've followed the guide at https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect_in_GnuCash_2 for setting up OFX and it seems like everything is working. The logs indicate that I can retrieve a list of accounts from my bank, and that the account is associated, but when I get back to the wizard dialog, the "Forward" button is still grayed out and I can't proceed.
11:22:53 *** jotrago has quit IRC
11:23:29 *** DataWraith has quit IRC
11:37:47 <jralls> d-rock: Did you close the AQBanking setup dialogs? IIRC the assistant is modal on that.
11:38:26 <d-rock> Digging through the source, and debugging a bit, it looks like https://github.com/Gnucash/gnucash/blob/2.6.1/src/import-export/aqb/assistant-ab-initial.c#L463 is returning false because I'm not actually setting up any HBCI accounts
11:38:47 <d-rock> jralls: I did close the setup dialog
11:39:03 <d-rock> I'm back to the dialog that says "Start Online Banking Wizard"
11:39:04 *** fekepp has quit IRC
11:39:06 *** fekepp has joined #gnucash
11:50:18 *** User has joined #gnucash
12:07:32 <jralls> d-rock: First of all, 2.6.1 was pretty buggy though I don't think that's one of them. You should upgrade.
12:07:41 <d-rock> LOL. OK
12:08:22 <d-rock> I'm on an older version of Ubuntu. I'll see if I can find 2.6.17 or maybe build it from sources
12:08:27 <d-rock> Thanks!
12:08:50 <jralls> d-rock: But if you have no bank accounts set up then there's nothing for the assistant to do, so the Forward button isn't enabled.
12:09:54 <jralls> d-rock: I don't think Sebastién has put 2.6.17 in getdeb yet, but I'm pretty sure 2.6.15 is there and known to work on Ubuntu 14-04.
12:10:34 <d-rock> Hmmm. The log seems to indicate that it set up an account: 10:09:53 Status for account info request: Success (Code 0, severity "INFO")
12:10:35 <d-rock> The server successfully processed the request.
12:10:35 <d-rock> 10:09:53 Adding account XXX to bank YYY
12:10:35 <d-rock> 10:09:53 Operation finished, you can now close this window.
12:10:48 <d-rock> Sorry, that didn't paste well
12:11:01 <d-rock> But let me try 2.6.15 or newer first
12:18:36 <jralls> d-rock: If you open the AQBanking setup window and select the "Accounts" tab is there at least one account listed?
12:18:49 <d-rock> Nope
12:19:38 <jralls> d-rock: Then there's nothing for the online banking assistant to process. Set up an account and you can proceed.
12:20:12 <d-rock> The guide seems to indicate that it should have set up the account automatically
12:20:35 <d-rock> I did try setting one up manually, but the bank search only lists German banks
12:23:36 <jralls> d-rock: When you created the user did you create it as an HBCI or an OFX-DirectConnect? HBCI is pretty much Germany only, OFX-DirectConnect is mostly USA.
12:24:42 <jralls> d-rock: On the User tab all the way on the right under "Module" it should say aqofxconnect.
12:25:05 <d-rock> Yeah, I created it with OFX-DirectConnect
12:25:35 <d-rock> I'm grabbing 2.6.12 debs right now. Let me try that before digging deeper :)
12:37:19 <d-rock> OK, I get the same issue. I created the user and it auto-downloaded the account list, but no account appears in the "Accounts" tab of the AqBanking Setup dialog
12:38:12 <d-rock> I can try adding an account by hand, but I can't figure out the proper values to put in
12:40:15 <jralls> OK, sounds like that's broken for your bank or maybe just broken. The only important values are the account number and "bank code" which is usually the routing ID. If you have paper checks both are printed across the bottom.
12:40:47 <d-rock> OK, I added those manually and hit "OK", and the account list is still empty :(
12:41:28 <d-rock> Create Account -> <fill in info> -> click "OK" -> <Accounts tab shows no accounts>
12:48:37 <jralls> That's odd, it works for me. So did downloading an account from USAA, though the currency was wrong (€ instead of $) and it didn't fill in the selected user.
12:51:22 <d-rock> I cna run it through gdb again and see if I can get more detail. The logging env variables didn't seem to have any effect
12:53:01 <jralls> All of that is happening in AQBanking, not GnuCash.
12:54:12 <d-rock> Yeah, I meant I'll have to debug AQBanking :(
12:54:45 <jralls> :( indeed. Martin's coding style is... unique.
13:17:33 *** jlerner has joined #gnucash
13:17:57 <jlerner> any consultants out there who can help setup a GNUCash instance for a small US-based business?
13:48:49 <chf> jlerner, there isn't much to set up; the most important thing is to choose an account plan suitable for your business.
13:49:37 <jlerner> just wondering about importing a few years of data
13:50:44 <chf> That's another point… if that is possible depends on the format of the data.
13:52:05 <jlerner> trying to migrate away from Quickbooks Online
13:54:00 <chf> That is probably a problem; can your Quickbooks version export transaction data as CSV?
13:55:23 <jlerner> i don't think so
13:55:26 <chf> If not, there are a few commercial firms providing services for Quickbooks data conversion. There is no open source tool that I am aware of.
13:56:14 <d-rock> jralls: FYI, it turned out to be a permissions issue. Somehow, my "~/.aqbanking/settings/accounts" directory was set 0600 (no exec bit), so it couldn't create the account list
13:56:46 <chf> I've tried that for QB 5 myself; Win2k is the latest Windows version that thing runs on.
13:56:57 <d-rock> I've got the log, so I'll report it as a bug to AQBanking. An error message to the user would have been much better than silently erroring
13:56:58 <jralls> d-rock: Interesting. Glad you found it.
13:57:18 <d-rock> I'm glad it was that simple :)
13:57:31 <d-rock> Debugging AQBanking was getting hairy
13:58:14 <chf> I only managed to do an Excel export, but that is a heavily formatted format intended for printing rather than conversion.
13:58:38 <jlerner> i'm seeing only option to export TO quickbooks :-(
13:59:08 <chf> The problem is that Intuit is quite happy that you can not convert your data; they want to tie you to their product.
14:00:13 <jlerner> i understand
14:02:42 <chf> Easiest solution: print everything, use every export option you can find (just in case), and begin a fresh Gnucash file at the end of a business year with opening balances according to your last closing balances.
14:03:18 <chf> You won't be able to go back in time then with reports and such, of course.
14:03:45 <chf> And you can't search in the old data easily.
14:08:06 <jlerner> yeah - ok thanks
14:12:02 *** frakturfreak has joined #gnucash
14:13:43 *** fekepp has quit IRC
14:15:59 *** frakturfreak has joined #gnucash
14:23:20 *** jlerner has quit IRC
14:24:46 *** bertbob has quit IRC
14:27:18 *** fabior has quit IRC
15:08:56 *** dxu has quit IRC
15:27:28 *** newbie has joined #gnucash
15:36:42 *** newbie has quit IRC
15:38:15 *** bertbob has joined #gnucash
16:11:38 *** rickoehn has quit IRC
16:36:01 *** bertbob has quit IRC
16:36:35 *** bertbob has joined #gnucash
16:40:30 *** frakturfreak has quit IRC
17:05:56 *** O01eg has quit IRC
17:19:10 *** O01eg has joined #gnucash
17:25:34 *** rickoehn has joined #gnucash
18:39:44 *** pilotauto has joined #gnucash
18:42:25 *** rickoehn has quit IRC
18:51:54 *** vym has joined #gnucash
18:52:23 *** vym1 has joined #gnucash
18:52:24 *** vym has quit IRC
19:02:03 *** vym1 has quit IRC
19:19:45 *** Groan has joined #gnucash
19:28:17 *** dwalmsley has joined #gnucash
19:39:46 <dwalmsley> Hi, I've been using GNUCash for sometime to run my budget. My budget is a bit odd, I use virtual accounts (as sub-accounts of my actual bank account) to do envelop budgeting. So in my chequing account there will be a sub account for food, entertainment, car and the rest. It works great, it means I can save money and plan my spending well. The built in way of budgeting doesn’t work for me. The draw back of this system is I can't import transact
19:39:47 <dwalmsley> ions from my bank account. Because the transactions come from one account in my bank but need to be distributed into the correct sub-accounts. Basically this means that during import I have to import them all into an unassigned account then fix up all the transactions so they go into the correct accounts. Not a big problem, but because of this I can never detect duplicates and have to be very careful to never import the same transaction twice. I
19:39:49 <dwalmsley> 'm in the process of building a preprocessor for my bank statements. This will allow me to put the transactions into the correct sub-accounts before going into GNUCash and detect duplicates (the OFX has an FITID I can use) before they get imported. I just wanted to check here first to see if this is sane or I'm re-inventing the wheel and doing something that GNUCash could already do? Thanks for your time, sorry for the wall of text :)
20:14:01 *** mlncn has quit IRC
20:40:53 *** mlncn has joined #gnucash
21:00:36 *** meb has joined #gnucash
21:06:42 *** meb has quit IRC
21:07:34 *** meb has joined #gnucash
21:24:21 <warlord> dwalmsley: Bucket budgeting and importing currently don't really work well together.
21:27:13 <dwalmsley> Thanks warlord. In that case I think I'll make something similar to this https://github.com/hjacobs/gnucash-fiximports. But good to know I'm not trying to solve an already solved problem.
21:30:08 <warlord> Is this QIF? You would need to turn the download into a multi-account qif file to make it work right.
21:32:23 <dwalmsley> I have a QIF option but I think I like the OFX format a little better, it seems more readable to me. Yeah I can either output a multi account file to import or try and use the python bindings to directly put the transaction into my GNUCash file. I'm starting to think it might be more streamlined if I just use the python bindings
21:34:33 <warlord> Seriously? SGML is "more readable" than a simple text file format???
21:39:32 <dwalmsley> Well, given your reaction I may need to investigate further. I've not really got a strong opinion on it yet. The thing I noticed with the ofx file is there is a unique id <FITID>, a quick glance over the qif and I didn’t notice anyting similar. Without an ID from my bank it’ll make it harder to match duplicates.
21:42:24 *** User has quit IRC
21:45:23 <warlord> True, but if you bank screws up and re-uses the FITID, you're screwed. And if your bank doesn't provide a FITID then you can't really use OFX . There are plenty of other ways to detect duplicates.
21:52:09 <dwalmsley> Yeah I am a little worried about trusting my bank to provide unique ids. But at the same time the constantly change transaction dates and when there is an international conversion involved they even can change amounts, so I'm worried about trying to match transactions based on transaction details. If I didn't have a mortgage with them I'd consider switching banks.
21:55:16 <warlord> Or better yet... dont import your data!
22:04:37 <dwalmsley> You'd recomend manual entry?
22:39:58 *** storyjesse has joined #gnucash
23:23:05 <warlord> Yes.
23:23:16 <warlord> Manual entry, and then clear/reconcile against the bank.
23:59:22 *** cyphase has quit IRC