2014-01-04 GnuCash IRC logs

00:20:21 *** THV has joined #gnucash
01:22:11 *** THV has quit IRC
01:26:13 *** Jimraehl has joined #gnucash
01:31:09 *** fuzzybunny69y has quit IRC
01:31:10 *** Jimraehl has quit IRC
01:39:11 *** fuzzybunny69y has joined #gnucash
02:07:31 *** jmd has joined #gnucash
02:07:52 *** jmd has quit IRC
02:08:28 *** jmd has joined #gnucash
02:09:02 *** jmd has joined #gnucash
02:40:18 *** fell_ has joined #gnucash
02:40:18 *** gncbot sets mode: +o fell_
02:49:14 *** fell has quit IRC
03:49:17 *** jmd` has joined #gnucash
03:52:25 *** jmd` has quit IRC
04:10:01 *** john has quit IRC
04:59:40 <mikee-afk> warlord: john: Re: Bindings, Mark wrote 'em, I poke 'em. :)
05:09:43 *** Krzysiek_K has joined #gnucash
05:38:20 *** Krzysiek_K has quit IRC
06:06:16 *** StuM has quit IRC
06:11:04 *** StuM has joined #gnucash
06:37:36 *** aqua___ has joined #gnucash
07:10:06 *** aqua___ has quit IRC
07:12:19 *** aqua___ has joined #gnucash
07:53:13 *** jmd has quit IRC
08:48:17 *** LiamH has joined #gnucash
08:54:02 *** jmd has joined #gnucash
08:54:11 *** jmd has joined #gnucash
09:01:57 *** Jimraehl has joined #gnucash
09:05:48 *** jmd` has joined #gnucash
09:05:48 *** Jimraehl has quit IRC
09:06:06 *** jmd` has quit IRC
09:06:06 *** jmd has quit IRC
09:09:19 *** Krzysiek_K has joined #gnucash
09:09:46 *** jmd has joined #gnucash
09:22:34 *** aqua___ has quit IRC
09:28:29 *** aqua___ has joined #gnucash
09:36:24 *** aqua___ has quit IRC
09:46:56 <warlord> mikee-afk: thanks for the update ;)
10:09:00 *** BnMcGn has joined #gnucash
10:10:44 *** Krzysiek_K has quit IRC
10:52:58 <BnMcGn> Does gnucash have a scheme repl?
11:02:58 *** Krzysiek_K has joined #gnucash
11:23:37 *** TradeBorG113 has joined #gnucash
11:30:21 <jmd> BnMcGn: So far as I know, it doesn't :(
11:35:04 *** THV has joined #gnucash
11:38:52 *** Krzysiek_K has quit IRC
11:46:19 <BnMcGn> Can I run guile from the command line and load the gnucash libraries somehow?
11:47:09 <BnMcGn> Can be done with python, when the app is not running.
11:48:26 <BnMcGn> Or, at least, with a set of accounts that is not open in the app.
12:14:51 *** mikee-afk has quit IRC
12:15:25 *** mikee-afk has joined #gnucash
12:15:42 <mikee-afk> @op
12:15:42 <gncbot> mikee-afk: Error: You don't have the #gnucash,op capability. If you think that you should have this capability, be sure that you are identified before trying again. The 'whoami' command can tell you if you're identified.
12:15:52 <mikee-afk> @op
12:15:53 *** gncbot sets mode: +o mikee-afk
12:42:15 <warlord> BnMcGn: yes, you can..
12:43:15 <warlord> BnMcGn: run gnucash-env guile .. and then you can load the gnucash modules and then gnc:module-load the rest.
12:43:37 <BnMcGn> Ok.
12:43:52 <BnMcGn> How do I load the gnucash modules?
12:44:00 <warlord> Indeed, earlier versions of gnucash (1.6 and possible even 1.8) were guile scripts!
12:44:29 <warlord> (use-modules (gnucash gnc-module))
12:45:47 *** Krzysiek_K has joined #gnucash
12:46:07 <BnMcGn> Can this be done with something like emacs/geiser so that I have autocomplete?
12:46:56 <BnMcGn> It's nice for exploring.
12:47:21 <warlord> umm.. I didn't know that emacs had guile; I thought it only had elisp
12:47:45 <BnMcGn> It's inferior-lisp or something
12:47:52 <BnMcGn> sort of like slime
12:48:24 <warlord> I doubt it would work there.
12:48:56 <BnMcGn> I know guile can be run in inferior mode under geiser, but I don't know the details.
12:49:48 <BnMcGn> Just wondering if you have a preferred environment, or just run the bare guile interpreter.
12:50:48 <warlord> Generally I just run the bare guile interpreter... Or write an actual script if it's something to be done multiple times. But I start with the CMLI
12:51:06 <BnMcGn> CMLI?
12:51:13 <warlord> Sorry, typo: CLI
12:51:29 <BnMcGn> guile command line?
12:52:29 <warlord> y
12:52:38 <BnMcGn> Hey, since you're here...
12:52:54 <BnMcGn> I tried the qof_query thing...
12:52:58 <BnMcGn> In [48]: gnucash.gnucash_core_c.qof_query_create_for("Vendor")
12:53:00 <BnMcGn> Out[48]: <Swig Object of type 'QofQuery *' at 0x93a3740>
12:53:04 <BnMcGn> In [49]: qq = _
12:53:08 <BnMcGn> In [50]: gnucash.Query(instance = qq)
12:53:10 <BnMcGn> Out[50]: <gnucash.gnucash_core.Query at 0x96fb5ec>
12:53:14 <BnMcGn> In [51]: q = _
12:53:18 <BnMcGn> In [52]: q.set_book(sess.book)
12:53:23 <BnMcGn> In [53]: q.run()
12:53:25 <BnMcGn> Out[53]: []
12:53:26 <BnMcGn> Got an empty list.
12:53:28 <BnMcGn> Wanted to try it in scheme.
12:53:39 <warlord> try GncVendor instead of Vendor
12:53:44 <BnMcGn> K
12:54:13 <warlord> er, sorry, gncVendor
12:54:18 <warlord> (GNC_ID_VENDOR)
12:55:19 <BnMcGn> as a string?
12:56:23 <warlord> You should use GNC_ID_VENDOR (not as a string... it should be a defined variable/symbol)(
12:56:37 <warlord> but it should be defined as 'gncVendor' (as a string)
12:56:53 <warlord> but the symbol is "more correct" in terms of the API
13:00:19 <BnMcGn> Ok, the symbol works. gnucash.gnucash_core_c.GNC_ID_VENDOR
13:00:39 <BnMcGn> Thanks.
13:02:54 *** Krzysiek_K has left #gnucash
13:38:52 *** gnucashed has joined #gnucash
13:38:59 <gnucashed> Hi all
13:46:13 *** gnucashed has quit IRC
14:14:27 *** THV has quit IRC
14:22:34 *** StuM has quit IRC
14:45:46 *** benoitg has joined #gnucash
14:46:59 *** kpreid has quit IRC
14:47:45 *** kpreid has joined #gnucash
14:51:26 *** redlizard has joined #gnucash
14:57:55 <redlizard> In gnucash, how can I configure the list of existing currencies?
15:04:44 *** Gnewbee has quit IRC
15:09:55 <warlord> redlizard: what do you mean?
15:15:42 <redlizard> warlord: I want to use a currency other than the ones on the list, and thus add my own currency to the list.
15:22:00 *** ridler77 has joined #gnucash
15:22:37 <warlord> Let me guess.. Bitcoin?
15:22:45 <redlizard> Among others.
15:22:59 <warlord> Yeah, Gnucash does not support user-added currencies..
15:23:13 <warlord> It supports all ISO currencies.
15:23:33 <warlord> In general for non-ISO currencies you can treat it like a stock.
15:23:56 <redlizard> I have also wanted to use accounts measured in festival tokens, at some point in the past when organizing a festival.
15:23:58 <warlord> (for Bitcoin you probably want to manage MiliBitcoins, 1/1000 BTC, or mBTC)
15:24:19 <warlord> Just use a random existing currency
15:24:22 <redlizard> (i.e. plastic monopoly money.)
15:24:29 <redlizard> Well
15:24:46 <redlizard> I tried that with bitcoin, but the random existing currencies don't really support more than 2 decimal digits.
15:25:22 <warlord> Right, for mBTC you probably want to use a Stock
15:25:30 <redlizard> gnucash will start rounding things to two digits at random times, even with all smallest fractions set to 1E-6.
15:25:41 <warlord> It's not random at all...
15:25:53 <redlizard> "random" as in "unpredictable by me" :)
15:25:56 <warlord> It's quite consistent in how it will round in those cases.
15:26:15 <redlizard> Yeah, I'm sure it is.
15:26:24 <warlord> Anyways, for mBTC, create a stock.
15:26:42 <warlord> (the hard part would be if you actually buy something with BTC, instead of just trading it)
15:26:46 <redlizard> Hm.
15:26:52 <redlizard> Yeah, exactly.
15:27:15 <redlizard> That sounds like a crummy workaround that will cause all sorts of trouble.
15:27:21 <warlord> Nah..
15:27:27 <warlord> Get BTC into the ISO currency list.
15:27:45 <redlizard> Is the list compiled in?
15:27:51 <warlord> Yes
15:28:17 <redlizard> Ah. So I can make a custom build with all my favorite currencies fairly easily?
15:28:40 <warlord> If you're willing to rebuild gnucash... and never share your datafile.
15:28:53 <redlizard> Hm. The latter is a problem.
15:28:53 <warlord> .. and keep patching as gnucash progresses...
15:29:22 <warlord> If you give your datafile to someone who doesn't also have your fake-currency-patch, it wont open the data file
15:29:25 <redlizard> How does gnucash deal with new (or deprecated) currencies across versions?
15:30:12 <redlizard> If I have a datafile made using a new gnucash version (including new currencies), will old gnucash versions refuse to open it?
15:30:41 <warlord> yes, it will
15:30:58 <redlizard> That sounds dangerously unstable.
15:31:03 <warlord> w.r.t. deprecaded currencies, there is a translation list to move to the new one.
15:31:09 <warlord> (also hardcoded)
15:31:19 <redlizard> Move?
15:31:20 <warlord> Currencies change so infrequently that it's not a big deal
15:31:33 <ridler77> I'm learning to use gnucash 2.4.13. I understand the double-entry accounting, and the workflow as I understand it is: Manually enter a transaction, e.g. in Checking I bought a coffee under Dining:Coffee account. Later I get a bank statement and I can manually reconcile it. Or download it using the aqbanking feature, and it will attempt to auto-reconcile the downloaded transactions to the manually entered transactions. But I don't like t
15:31:42 <redlizard> But of course I want my historic books to stay accurate.
15:31:47 <warlord> redlizard: yeah, move... Because the old currency doesn't exist anymore.
15:32:08 <redlizard> The old currency doesn't exist anymore, but historic books using them still exist.
15:32:30 <warlord> ridler77: you stopped after "But I don't like t"
15:32:50 <ridler77> But I don't like to manually enter transactions. Previously, I downloaded transactions from my bank every few days while I still either remember the transaction or have my receipt and then manually assign catagories (using .csv files from bank and Excel sheets).
15:32:51 <warlord> Don't reconcile via import; reconcile via the manual process.
15:32:55 <ridler77> I've connected and downloaded my current transactions from my checking account, but now what do I do since none of the transactions exist in gnucash? I tried accepting them w/out reconciling but they all went to Imbalance-USD.
15:33:38 <warlord> ridler77: You need to assign the expense accounts during the import.. IIRC it's a double-click in the correct column on the right.
15:34:18 <redlizard> warlord: Out of interest, WHY does gnucash not support custom currencies?
15:34:34 <redlizard> Having the list be part of the datafile rather than hardcoded seems like a fairly trivial change.
15:35:05 <warlord> redlizard: It's always done that.
15:35:12 <warlord> (I don't know why)
15:35:19 <warlord> Patches always accepted.
15:35:25 <redlizard> Hysteric reasons? :)
15:36:17 <warlord> It's been that way since at least 1998
15:36:44 <ridler77> Ok so I just made a new gnucash file. having only the wizard simple checking accounts. Assets:Current:Checking, Equity:OpeningBalance, Expenses, Income
15:36:59 <ridler77> How do I download and setup my balance / latest transactinos
15:37:10 <redlizard> So more or less "it's never been a problem so far and all this mucking around with currencies springing up every day is a very recent development"?
15:37:27 <ridler77> open checking / action / online / get balance?
15:37:42 <warlord> ridler77: you'll have to manually set your opening balance.
15:38:02 <warlord> as for latest txns, that depends on your bank.
15:38:46 <warlord> redlizard: until BTC it's never been an issue.. Everyone always used ISO currencies, or would use a random one to keep track of personal currencies.
15:39:15 <redlizard> Fair enough.
15:41:00 <warlord> and ISO currencies change rarely enough.... the list since 1998 is under 10
15:42:28 <ridler77> Ok, so I added a first transaction to Checking with my balance, and set transfer account as Equity:Opening Balances. Do you usually use Opening Balances for all beginning balances? Or do you make sub balance accounts?
15:45:26 *** john has joined #gnucash
15:45:26 *** gncbot sets mode: +o john
15:46:29 *** benoitg has quit IRC
15:48:50 <warlord> ridler77: what you did is fine.. A single Eq:O-B account for all opening balances
15:49:08 <ridler77> So I did Actions->Online -> Download Transactions and it asked for the account (which I had already told it during the online banking wizard). So I selected the checking account. Now there's a pop up that asks about importing balance info. Do I want to import it?
15:49:55 <ridler77> I looked in the manual and online but I couldn't find a walk through of first time transaction downloads into an empty account.
15:50:05 <ridler77> so sorry for the beginner questions :)
15:52:11 <warlord> sorry I dont import transactions so I cannot answer
15:55:46 <ridler77> Ok, I clicked Yes :) Then it added them to the Checking account (with no accounts), but left up the download window. I was able to double click the transactions and add them to expense accounts, then click OK, and they updated in the register
15:57:38 <warlord> cool.
16:45:33 *** redlizard has quit IRC
17:46:07 *** jmd` has joined #gnucash
17:46:15 *** jmd` has quit IRC
18:17:29 *** TradeBorG113 has quit IRC
18:34:31 *** jmd` has joined #gnucash
18:37:39 *** rich has joined #gnucash
18:41:09 <rich> I'm having an apparent problem with the security editor. Only one security under AMEX is showing, but none of those that I've created while creating accounts. Any thoughts? Thanks.
19:10:08 *** BnMcGn has left #gnucash
19:11:28 *** jmd has quit IRC
19:30:27 *** LiamH has quit IRC
19:34:39 <john> rich: What does the account editor show for one of those accounts when you bring up the commodity selector?
19:35:12 *** ridler77 has quit IRC
19:44:14 <rich> Not sure I know what you are asking, but will try to answer with this: When I edit an account that has been set to the Stock account type with a custom security, I click to select the Security/currency. This brings up the Select security window. I created a securiety with type = template and security = BRP #2892. I would like to be able to edit these custom securities.
19:47:55 <john> Oh. "template" is reserved for GnuCash's internal use. You can't edit anything in that type. You'll need to re-create all of the securities with another type name. But having used 'template', why did you expect them to show up under 'AMEX'?
19:48:50 <rich> I didn't. The only thing that show ups is AMEX and one security underneath. Please let me try to explain again...
19:49:33 <john> Maybe you didn't create it? Click on "New" to do that.
19:50:11 <warlord> john: we really REALLY need to fix that bug...
19:50:28 <warlord> Too many users get hit by it.
19:51:27 <rich> When I create a new account and click to select Security/currency, under 'Type' the drop down show AMEX, EUREX, etc., But from the top menu, when I select Tools->Security Editor, the only thing that shows is AMEX with one security that I created under it. I suspect the securities list is corrupt, but don't know. I hope that explains better.
19:51:28 <john> Yeah. Would blocking it in the edit security dialog be enough?
19:52:16 <john> rich: No, it's fine. If there's only one security, then that's all that will show up in the security editor.
19:52:54 <john> When you create more securities in different types, those new types will show up too. Just don't call any of the types "template", OK?
19:53:10 <rich> john: actually I've created numerous securities. And everything seems to work except once I create a security I can't edit them.
19:53:37 <warlord> rich: if you don't actually have any securities under those other namespaces then those namespaces wont show up in the Security Editor..
19:53:51 <warlord> rich: that's because you've created them under "template"
19:54:11 <rich> Ah! OK. I'll try not using template... I'll do it right now...
19:54:51 <warlord> There is no "try", only "do"
19:55:59 <rich> warlord: :-) <insert snappy reply with Star Wars reference here>
19:56:08 <warlord> john: it's clearly been a while since I've tried to build trunk... I didn't have libxslt-devel installed
19:56:39 <rich> That worked. I created a security under AMEX and it shows up fine in the editor. Thank you very much for the help!!
19:56:40 <john> Only 3 months or so.
19:56:52 <john> rich: You're welcome.
19:57:25 <warlord> john: But yes, I think checking in the Security Creation dialog would be sufficient.. Removing "template" from the dropdown would also be a good first step.
19:58:00 *** rich has left #gnucash
19:59:23 <john> OK. It's been a while since you committed a change. Got time to have a whack at it, or are you still battling F20?
20:01:07 <warlord> I'm still battling F20
20:01:42 <warlord> Once I get that moved over I'll try to find some time.. (Always hard to find nowadays -- so many things to do around here)
20:03:22 <john> I just put https://bugzilla.gnome.org/show_bug.cgi?id=555182 on the roadmap for 2.6.1. That should help remind us.
20:03:32 <warlord> ok
20:03:45 <warlord> (I knew it's been in Bz for a while)
20:04:22 <john> There's a *lot* of stuff that's been in Bz for a long time. Kinda embarrassing, really.
20:09:51 <warlord> I know, but given how many full time developers we have....
20:13:36 <john> As in none. Roger. But it's partly because we espouse the "scratch your own itch" philosophy a bit too freely. Bugs are mostly someone else's itch.
20:18:51 <warlord> True...
20:41:05 *** StuM has joined #gnucash
20:53:29 *** fell_ has quit IRC
20:53:34 *** fell_ has joined #gnucash
20:53:35 *** gncbot sets mode: +o fell_
22:17:27 *** LiamH has joined #gnucash
23:45:14 *** fell_ has quit IRC
23:59:28 *** LiamH has quit IRC