2015-01-15 GnuCash IRC logs

00:06:46 *** ErKa has joined #gnucash
00:29:27 *** MechtiIde has joined #gnucash
00:52:32 *** GabrieleV has quit IRC
00:52:55 *** GabrieleV_ has joined #gnucash
00:52:55 *** GabrieleV_ is now known as GabrieleV
01:11:59 *** MechtiIde has quit IRC
01:36:23 *** cartsoftware has joined #gnucash
01:39:09 *** ErKa has quit IRC
01:51:12 *** gour has joined #gnucash
02:17:28 *** uXus has quit IRC
02:19:55 *** uXus has joined #gnucash
02:22:36 *** fabior has joined #gnucash
02:25:09 *** cartsoftware has quit IRC
02:29:02 *** cartsoftware has joined #gnucash
02:33:54 *** pacon has joined #gnucash
02:37:18 *** MechtiIde has joined #gnucash
02:48:26 *** cartsoftware has quit IRC
03:09:17 *** cartsoftware has joined #gnucash
03:09:30 *** Krzysiek_K has joined #gnucash
03:37:23 *** cartsoftware has quit IRC
03:37:58 *** cartsoftware has joined #gnucash
03:58:54 *** Krzysiek_K has quit IRC
03:58:55 *** cartsoftware has quit IRC
04:19:43 *** uXus has quit IRC
04:19:48 *** gjanssens has joined #gnucash
04:19:48 *** gncbot sets mode: +o gjanssens
04:20:33 *** StuM has quit IRC
04:21:05 *** StuM has joined #gnucash
04:21:59 *** uXus has joined #gnucash
04:58:00 *** StuM has quit IRC
05:00:00 *** GabrieleV_ has joined #gnucash
05:00:22 *** GabrieleV has quit IRC
05:00:23 *** GabrieleV_ is now known as GabrieleV
05:34:45 *** gour_ has joined #gnucash
05:43:27 *** gour has quit IRC
05:48:57 *** pacon has quit IRC
06:04:50 *** aqua___ has joined #gnucash
06:10:50 *** Jimraehl1 has left #gnucash
06:16:52 *** Jimraehl1 has joined #gnucash
06:19:53 *** fabior has quit IRC
06:26:02 *** rubdos has joined #gnucash
07:06:53 *** mlncn has joined #gnucash
07:08:23 *** rickoehn has joined #gnucash
07:09:23 *** aqua___ has quit IRC
07:18:24 *** andy has quit IRC
07:23:27 *** gour_ is now known as gour
07:29:40 *** somethingrandom has quit IRC
07:31:03 *** andy has joined #gnucash
07:39:03 *** somethingrandom has joined #gnucash
07:54:22 *** lmat_ has quit IRC
08:11:55 *** fuogo has joined #gnucash
08:18:39 <fuogo> I need some help in correcting a problem with the install of Price Retrieval. Running Windows 8.1 and Gnucash 2.6.5. I can provide the install printout with the errors.
08:24:17 <fuogo> http://mibpaste.com/q65s0H
08:30:22 *** andy has quit IRC
08:31:59 <fuogo> why
08:33:36 *** lmat has joined #gnucash
08:37:16 <fuogo> What am I doing wrong? Nothing is coming through.
08:38:46 *** fuogo has quit IRC
08:40:57 *** DonCac has joined #gnucash
08:41:37 *** andy has joined #gnucash
08:47:19 <gjanssens> fuogo: others have reported similar issues on the mailing list
08:47:28 *** DonCac has quit IRC
08:47:33 <gjanssens> Here is an interesting thread: http://lists.gnucash.org/pipermail/gnucash-user/2015-January/057652.html
08:48:19 <gjanssens> According to Michael Seifert this is due to a bug in Date::Time, a perl module required by Finance::Quote
08:48:33 <gjanssens> He managed to work around it, but the work around is quite hacky...
08:49:41 <warlord> gjanssens: fuogo left.
08:49:56 <gjanssens> hey warlord
08:50:11 <gjanssens> Right, fuogo has left the building...
08:50:17 <gjanssens> or rather the chat
08:50:21 <gjanssens> I missed that :(
08:54:48 *** aqua___ has joined #gnucash
09:01:48 *** cartsoftware has joined #gnucash
09:33:01 *** TommyT has joined #gnucash
09:40:57 *** KaiForce has joined #gnucash
09:50:30 *** O01eg has joined #gnucash
10:01:32 *** wol has joined #gnucash
10:31:41 *** KaiForce has quit IRC
10:32:13 *** KaiForce has joined #gnucash
10:34:26 *** MechtiIde has quit IRC
10:35:45 *** aqua___ has quit IRC
10:55:15 *** aqua___ has joined #gnucash
10:58:24 *** somethingrandom has quit IRC
11:02:41 *** Ahmuck has joined #gnucash
11:03:16 <Ahmuck> hi. when i split a transaction it only shows the first entry of the split, not the second. how do i fix this?
11:06:50 <Ahmuck> nm, you tube video shows it. it's a bit awkward that way
11:08:34 <Ahmuck> well, maybe
11:11:26 <Ahmuck> k, got it
11:15:59 <Ahmuck> k, yea, it's messed up. with autofill it's autofilling the next line. transfers between accounts don't work so well because trying to modify the "split" it autofills in appears it's going to be a challange.
11:16:18 *** cartsoftware has quit IRC
11:16:20 *** cartsoftware has joined #gnucash
11:16:59 <TommyT> Ahmuck, just curious what YouTube video you watched.
11:17:12 <Ahmuck> https://www.youtube.com/watch?v=_l9sxlfF9Fw
11:17:27 <TommyT> Ahmuck also what operating system & version GnuCash?
11:18:01 <Ahmuck> So i figured out a way around the autofill thing. fill in the amount, enter and then go back and enter payee and transfer depratment
11:18:09 <Ahmuck> Lubuntu 14.10
11:18:19 <Ahmuck> 2.6.3
11:19:28 <TommyT> the way autofill is SUPPOSED to work is it fills in stuff based on the description, but if you start typing something different OR just click on the next field it won't autofill at all
11:19:39 <TommyT> Is that what you're seeing?
11:20:34 *** wol has quit IRC
11:21:01 <Ahmuck> yes. I am using the same description for Checking Savings and Loan where only the transfer category differs
11:23:23 <ajs> This may be a stupid question, but are there any better/alternative reporting tools for gnucash? Or any nicer looking/formatted report templates I can download?
11:24:50 <TommyT> Ahmuck, I find it easier to use different descriptions for different situations for exactly this reason. Fortunately you can go back and edit them, and autofill will pick up the most recent.
11:25:00 <ajs> I am coming from Moneydance, which has a nice "home page" overview of my finances, including the current budget for the month
11:25:28 <Ahmuck> TommyT: i agree. let's say i am transfering from checking to savings. how would you describe this?
11:26:05 <Ahmuck> online transfers
11:26:40 <TommyT> Ahmuck: If you use the word Transfer when entering in the savings account, it will pick up that word from that register. The checking register's autofill recollection is separate.
11:26:58 <TommyT> SO you don't necessarily have to use a different word
11:27:08 <TommyT> but the context will dictate what autofill does
11:27:53 <Ahmuck> ?
11:28:25 <TommyT> ajs: some folks have been working on new reporting based on database backends, but the backends aren't completely reliable yet
11:28:49 <ajs> TommyT: is this project public yet?
11:29:33 <TommyT> ajs: there have been a lot of discussions on the mailing list, which you can search via Google or another search engine
11:29:37 <ajs> is this the JSON python interface?
11:30:15 <TommyT> ajs: I have read about that one, but I believe that one is considered unofficial
11:32:30 <TommyT> Ahmuck: What i was saying is when you are entering savings account transactions, you can open that account in its own tab or register, and autofill will only "look" at descriptions showing in that one register. But if you are transferring BOTH ways you would want a different phrase, such as "Tx Savings to Checking" or "Tx Checking to Savings"
11:33:39 <TommyT> IAhmuck: I was thinking of situations where I use PayPal on different accounts, and interbank transfers are different
11:35:03 <TommyT> ajs: officially GnuCash is trying to better support database backends such as MySQL and you can use standard SQL reporting tools on those
11:35:09 <jgeidl3> Anyone have experience importing A/R from Quicken
11:37:40 <TommyT> Ahmuck: in practice I don't think I transfer both ways very much, so usually "Transfer" is unambiguous, and I always use two-line mode with auto splits so all the accounts are visible
11:38:25 <Ahmuck> TommyT: i agree, i have used "Transfer Checking to Savings" in the description when transfering from Checking to Savings. It then shows in the Savings windows as "Transfer Checking to Savings" where for clarity it needs to show "Transfer from Checking to Savings" in the savings account.
11:38:56 <Ahmuck> TommyT: as a result I felt my best approach to this language issue was to use "Bank Name" for interbank transfers.
11:39:28 *** MechtiIde has joined #gnucash
11:39:47 <TommyT> Ahmuck: That sounds right. I am speaking purely as a user (not a developer) so I apologize if I used the wrong terms
11:40:05 <Ahmuck> TommyT: I think the problem i ran into today was the first transaction was a split transaction, and then the following transactions also listed as split transactions and there was not a way to click the menu to sort to a different category because of the "split" account description, it's like locked
11:40:18 <Ahmuck> TommyT: i also am speaking as a user
11:41:55 <TommyT> Ahmuck: there are some bugs in version 2.6.3. I don't recall that particular one, but you can get 2.6.5 for Lubuntu from getdeb.net
11:43:07 <TommyT> Ahmuck: you should always be able to see the splits, though I don't have GnuCash open at the moment so I can't recall what it looks like when you don't have auto-split register turned on (in preferences)
11:43:38 <TommyT> Ahmuck: you might have to select the transaction and then click the splits icon in the toolbar
11:46:14 <TommyT> If you have more than one split on any more than just a few transactions, using two-line transaction display and autosplit is almost essential for understanding the entries
11:46:59 <TommyT> (opening gnucash to see if I have terminology correct)
11:49:23 <TommyT> Ahmuck: Edit --> Preferences --> Register Defaults -- check "Double Line mode"
11:49:57 <TommyT> it looks like I don't have Auto-split turned on on this laptop, but I think I usually do
11:53:21 *** aqua___ has quit IRC
11:59:27 *** himaxx has joined #gnucash
12:01:32 *** mlncn has quit IRC
12:16:24 *** mlncn has joined #gnucash
12:20:57 *** mlncn-agaric has joined #gnucash
12:26:09 *** mlncn has quit IRC
12:35:41 *** cartsoftware has quit IRC
12:41:33 *** wol has joined #gnucash
12:44:55 *** calatalee has joined #gnucash
12:46:17 *** calatalee has quit IRC
12:49:24 *** ErKa has joined #gnucash
12:55:13 *** anmorgul has joined #gnucash
13:04:48 *** jgeidl has joined #gnucash
13:16:12 *** rickoehn has quit IRC
13:17:06 *** rubdos has quit IRC
13:23:20 *** lmat has quit IRC
13:47:36 *** gour has quit IRC
13:57:43 <warlord> Ahmuck: Right-Click -> "Delete Transaction Splits" will remove all the splits from the autofill, and then you can go on normally.
14:04:36 <cphuntington97> hate what you don't understand
14:04:41 <cphuntington97> lol sorry wrong window
14:20:34 *** mlncn-agaric has quit IRC
14:25:51 *** lmat has joined #gnucash
14:31:40 <ajs> Anyone know how to fix this, I was importing some stock purchases via OFX file and when gnucash prompted me for the "income" account for the dividends, I assigned the wrong account. Now every time I import new transactions for this broker account, the dividend income continues to go to this wrong account I previously assigned. Is there a way to update gnucash to use a different income account here?
14:32:36 <ajs> I was hoping it would learn to assign the income to the right account by updating the previous imported transactions to reflect the correct destination, but it continues to default to the initial account I selected
14:34:50 *** aqua___ has joined #gnucash
14:35:29 <warlord> ajs: I'm not sure how it remembers that assignment. I know that if you assign the import to the wrong account you can fix it by importing a different OFX and assigning that to the account, then go back and re-import the original.
14:35:39 <warlord> But I'm not sure how it stores the target income account..
14:35:47 <warlord> You can possibly try the same trick.
14:36:59 <ajs> removing the account and re-importing may be worth a shot too?
14:37:40 <warlord> Yes. Or just reverting to a backup file from before you performed the import.
14:38:20 <ajs> thanks, I'll give it a shot
14:39:37 *** KaiForce has quit IRC
14:44:04 *** MechtiIde has quit IRC
14:45:51 *** Caesar has joined #gnucash
14:51:54 *** mlncn-agaric has joined #gnucash
14:53:09 *** aqua___ has quit IRC
14:53:27 *** Ard0nik has quit IRC
14:56:02 <warlord> good luck
15:01:13 *** anmorgul has quit IRC
15:20:00 *** TommyT has quit IRC
15:22:08 *** pacon has joined #gnucash
15:25:36 *** Krzysiek_K has joined #gnucash
15:25:39 *** rickoehn has joined #gnucash
15:35:57 *** pacon has quit IRC
15:37:29 *** benjamin-agaric has joined #gnucash
15:41:58 *** somethingrandom has joined #gnucash
15:43:08 *** mlncn-agaric has quit IRC
15:43:14 *** wol has quit IRC
16:03:48 *** TommyT has joined #gnucash
16:04:52 *** MechtiIde has joined #gnucash
16:12:02 *** gjanssens has quit IRC
16:20:05 *** MechtiIde has quit IRC
16:35:49 *** Ardonik has joined #gnucash
16:43:24 *** Caesar has quit IRC
17:01:20 *** aqua___ has joined #gnucash
17:05:15 *** jimvideo has joined #gnucash
17:11:27 *** Krzysiek_K has quit IRC
17:14:19 *** rickoehn has quit IRC
17:36:07 *** benjamin-agaric has quit IRC
17:47:24 *** aqua___ has quit IRC
17:47:40 *** aqua___ has joined #gnucash
17:52:45 *** TommyT has quit IRC
18:02:15 *** somethingrandom has quit IRC
18:08:12 *** somethingrandom has joined #gnucash
18:14:18 *** benjamin-agaric has joined #gnucash
18:15:39 <Ahmuck> sketch programing language?
18:32:03 *** aqua___ has quit IRC
18:36:18 *** StuM has joined #gnucash
18:59:05 *** hdelamano has joined #gnucash
19:03:22 <Ahmuck> exit
19:03:25 *** Ahmuck has quit IRC
19:31:14 *** hdelamano has quit IRC
19:50:57 *** benjamin-agaric has quit IRC
20:14:46 *** jimvideo has quit IRC
20:30:59 <jgeidl> I know I keep asking the same question but I hope maybe new people will chime in. Has anyone imported A/R from Quicken?
20:31:28 <warlord> jgeidl: quicken doesn't do A/R, it's personal. It doesn't have invoices.
20:49:14 <jgeidl3> warlord, it does do invoices. If you look under Business then Customer you will find invoices
20:50:01 <warlord> In Quicken?
20:50:07 * warlord has never used quicken
20:50:24 <jgeidl3> warlord, sorry, I misunderstood. Quicken Home and Business does have A/R and does invoicing
20:50:24 <warlord> This is the first I've even heard of quicken doing invoices.
20:50:52 <jgeidl3> Been doing it for years but you have to have the home and business version
20:51:50 <warlord> Never heard of it before today
20:52:03 <warlord> I have no clue how it stores or exports them.
20:52:14 <warlord> But the QIF Importer definitely does NOT handle Invoices
20:52:20 <jgeidl3> Works fine, too. Just an awful lot of the rest of Quick is getting really crappy.
20:52:57 *** hdelamano has joined #gnucash
20:53:03 <jgeidl3> the QIF importer imported the A/R just fine but only the payment side of it.
20:53:43 <warlord> Sorry, but it doesn't surprise me.
20:53:55 <warlord> Quicklen probably doesn't do invoices the same way gnucash does.
20:54:16 <jgeidl3> My A/R looks like all I do it take payments (great business model but not very workable). My checking account is fine too since all the payments are in A/R but my sales show no sales since it didn't import the invoice side the transsactions
20:55:05 <warlord> How does quicken put the invoice transaction into the QIF file?
20:55:46 <jgeidl3> Don't know. I think I am going to have to try and export just the A/R and invoices portion of Quicken and see what the file looks like
20:57:03 <warlord> I would gander that the QIF importer doesn't handle whatever it is that quicken does
20:57:16 <jgeidl3> Is there an authority for gnuCash that one might contact to get some ideas of how to correct the problem? Obviously, I am very very new to gnuCash
20:57:46 <warlord> gnucash-devel mailing list, if you're offering to help.
20:57:57 <warlord> You'd need to provide a sample qif, too.
20:58:01 <warlord> the qif importer is in Scheme
20:58:11 <jgeidl3> I ~could~ manually enter 10 years worth of invoices into gnuCash but, for obvious reasons, I sure don't want to.
20:58:33 <jgeidl3> Good idea! I will contact them and I absolutely will help.
20:58:44 <warlord> Or you can just ignore the history and start from scratch on 1/1
21:00:07 <jgeidl3> Can't do that with A/R that has active transactions in it. I have several thousand dollars worth of open invoices for which I am receiving payments
21:00:34 <warlord> jgeidl: and how many invoices would that be? How about just entering in those.
21:00:58 <warlord> (I'll note that when you import "A/R" it will *not* work with gnucash's A/R)
21:01:03 <jgeidl3> I think I will go beat my dog and go to bed and attack this again tomorrow. Maybe someone new will be here that has dealt with this problem. I will also poke around in the developers area
21:01:32 <warlord> jgeidl: unlikely someone else have dealt with it.
21:02:20 <jgeidl3> I could just enter the active items but what do I do when I want to report on customer actively for some period of time in the past, I would only have a small piece of their data.
21:02:37 <jgeidl3> Thanks for the imput
21:02:40 <jgeidl3> input
21:03:05 <warlord> bring up quicken for history.
21:08:51 *** TommyT has joined #gnucash
21:09:18 <jgeidl> Not sure what you mean
21:15:50 *** len has joined #gnucash
21:23:16 *** ErKa has quit IRC
21:42:06 *** benjamin-agaric has joined #gnucash
21:54:57 *** hdelamano has quit IRC
22:01:20 *** andy_ has joined #gnucash
22:06:41 *** andy has quit IRC
22:26:32 *** somethingrandom has quit IRC
22:33:35 *** somethingrandom has joined #gnucash
23:02:11 *** TommyT has quit IRC
23:05:34 *** O01eg has quit IRC
23:34:48 *** GabrieleV_ has joined #gnucash
23:35:23 *** GabrieleV has quit IRC
23:35:24 *** GabrieleV_ is now known as GabrieleV