2012-10-04 GnuCash IRC logs
00:55:51 *** fell has quit IRC
00:57:11 *** fell has joined #gnucash
00:57:12 *** gncbot sets mode: +o fell
01:08:48 *** fell has quit IRC
02:13:43 *** ecocode has joined #gnucash
02:20:30 *** john has joined #gnucash
02:20:30 *** gncbot sets mode: +o john
02:27:08 *** linas__ has joined #gnucash
02:27:09 *** linas_ has quit IRC
02:35:37 *** linas_ has joined #gnucash
02:35:37 *** linas__ has quit IRC
03:05:28 *** nafg has quit IRC
03:20:41 *** Fabzgy has joined #gnucash
03:23:36 *** john has quit IRC
03:33:14 *** Krzysiek_K has quit IRC
03:35:12 *** Fabzgy has quit IRC
03:47:34 *** TommyT has quit IRC
04:13:42 *** TommyT has joined #gnucash
04:16:02 *** TommyT has quit IRC
04:18:00 *** Fabzgy has joined #gnucash
04:28:52 *** aqua___ has joined #gnucash
06:14:03 *** timfrost has joined #gnucash
06:16:27 *** aqua___ has quit IRC
06:24:01 *** timfrost has quit IRC
06:48:34 *** Fabzgy has quit IRC
07:08:21 *** Jimraeh1 has left #gnucash
07:08:31 *** aqua___ has joined #gnucash
07:15:05 *** Jimraeh1 has joined #gnucash
08:44:16 *** Fabzgy has joined #gnucash
09:31:18 *** yacahuma has joined #gnucash
09:33:27 *** kpreid has quit IRC
09:34:17 *** kpreid has joined #gnucash
09:36:05 *** jose has joined #gnucash
09:37:16 <jose> hello. I have 2 questions about the sql layout. I was wondering if someone can answer
09:41:37 <jose> 1. Why gc uses guid varchar (32) instead of an autonumber in mysql?
09:41:55 <jose> 2. Why the money is not saved with decimal points?
09:46:13 *** fell has joined #gnucash
09:46:13 *** gncbot sets mode: +o fell
09:49:40 <warlord> jose: 1) because GnuCash uses GUIDs, and 2) Because gnucash uses rational numbers.
09:49:52 <warlord> Gnucash is not a DB App. It's use of DB is PURELY as a datastore.
09:50:03 <warlord> ... All the business logic remains within the GnUCash API/App.
09:50:28 <warlord> So it stores its internal datatypes in the database.
09:53:50 <jose> thank you
09:56:14 *** fell has quit IRC
09:57:12 *** fell has joined #gnucash
09:57:12 *** gncbot sets mode: +o fell
09:57:19 <warlord> you're welcome.
09:57:37 <warlord> Note also that you should not write into the database. You're welcome to read from it, but to write into it you should always use the gnucash API
10:03:53 *** fell has quit IRC
10:08:02 <jose> ok
10:36:22 *** fell has joined #gnucash
10:36:23 *** gncbot sets mode: +o fell
10:59:48 *** fell_ has joined #gnucash
10:59:49 *** fell has quit IRC
10:59:49 *** gncbot sets mode: +o fell_
11:03:20 *** kpreid has quit IRC
11:03:49 *** kpreid has joined #gnucash
11:14:06 *** ErKa has joined #gnucash
11:21:17 *** jose has quit IRC
11:38:18 *** jmd has joined #gnucash
11:45:47 *** ecocode has quit IRC
11:56:50 *** aqua___ has quit IRC
12:11:41 *** bootlfdhfrsa has joined #gnucash
12:20:12 *** benoitg has joined #gnucash
12:32:03 *** hjoki has joined #gnucash
12:36:46 *** Fabzgy has quit IRC
12:43:28 *** john has joined #gnucash
12:43:29 *** gncbot sets mode: +o john
12:47:57 *** Krzysiek_K has joined #gnucash
12:50:12 *** fell_ has quit IRC
12:51:27 *** fell has joined #gnucash
12:51:28 *** gncbot sets mode: +o fell
12:53:27 *** TommyT has joined #gnucash
13:06:24 *** TommyT has quit IRC
13:08:55 *** ErKa has quit IRC
13:14:06 *** fell has quit IRC
13:54:24 *** fell has joined #gnucash
13:54:24 *** gncbot sets mode: +o fell
13:55:32 *** ErKa has joined #gnucash
14:22:21 *** fell has quit IRC
14:41:41 *** Fabzgy has joined #gnucash
15:07:08 *** pnema has joined #gnucash
15:23:48 *** Fabzgy has quit IRC
15:26:35 *** aqua___ has joined #gnucash
15:36:56 *** sobay has joined #gnucash
15:37:41 <sobay> hi, is someone around who knows how to setup gnucash/aqbanking with Deutsche Bank?
15:42:06 <warlord> sobay: I dont see anyone around, sorry. You can try asking on the gnucash-de mailing list?
15:43:25 <sobay> i guess, thanks
15:48:42 <warlord> sorry, it's just a very limit-scope question and I don't see any Germans here in channel.
15:56:18 *** pnema has quit IRC
15:59:12 <sobay> sure, no problem
16:00:48 <sobay> say, is it possible to change the colors on the books pages? this green theme is not really that pleasant to look at imo ;)
16:04:27 *** john has quit IRC
16:04:43 <warlord> possibly in your gtk theme?
16:09:12 *** aqua___ has quit IRC
16:09:24 *** hjoki has quit IRC
16:09:56 *** draget has joined #gnucash
16:10:02 <draget> Goodevening
16:10:37 *** sobay has quit IRC
16:10:52 <draget> I have failed to do connect gnucash to my onlinebanking accounts in several attempts now. Usually, all that HBCI-stuff is magic which is different for every bank. So this time I tried paypal.
16:12:12 <draget> Does anyone have paypal configured in aqbanking and working with gnucash? I did setup an onlinebanking account/user for paypal with the paypay-provided api access information. It seems to have worked. Then I assigned it to an account.
16:12:20 <draget> But *any* online action I do fails.
16:13:39 <draget> getting the account balance (saldoabfrage) says this function is not available for this account. Getting the list of transactions (umsatzabfrage) asks for a password, but then simply fails with 'Status: error - (null)'
16:14:10 <draget> This is all very frustrating after already 3-4 attempts (of each several days of googling, reading and trying) to connecto to any other bank account.
16:17:07 <draget> gnucash --log=info does not produce any more logging output on the console (linux user). 'AWPAYPAL_LOGLEVEL=info GWEN_LOGLEVEL=info gnucash' does produce a few liens of GWEN-relatead infos when gnucash starts, but *nothing* is shown or added when I try to configure/add/query online accounts.
16:17:56 <draget> The only paypal-related bugs I found online were gnuTLS related - I compiled curl with openssl which is used by gnucash if I understood it correctly.
16:18:51 <draget> It did not work over the course of the last 10-15 months maybe (where these said 4 attempts were spread over). Currently gnucash 2.4.11 and aqbanking 5.0.25
16:19:38 *** jmd has quit IRC
16:19:46 <draget> *sighs*
16:21:36 *** john has joined #gnucash
16:21:37 *** gncbot sets mode: +o john
16:24:33 <warlord> draget: I've never even heard of "AWPAYPAL"
16:24:47 <draget> *AQPAYPAL
16:24:54 <warlord> draget: never heard of that, either.
16:25:06 <draget> Typo when writing it here in IRC, my console had AQ…
16:25:18 <draget> It is an aqbanking module for paypal-access.
16:25:22 <warlord> draget: your best bet is going to be asking on the gnucash-user mailing list where you might have more people who have tried
16:25:37 <warlord> Interesting. Didn't even know it existed.
16:26:03 <draget> I wonder if there are actually people using it/hbci or if everyone is just importing thing manually all the time.
16:26:44 <warlord> I know people use hbci
16:26:47 <warlord> and ofx
16:27:19 <warlord> (not me, I think data import like that generally defeats the purpose of reconciliation, because you can never detect bank errors if you are just taking what the bank says)
16:27:55 <draget> OFX being a totally myserious thing to my bank - they have no clue what it is and if they have it. Tho, being from germany, I assume it is something not common here while HBCI is.
16:29:59 <draget> I am somewhat a newbie to accounting. I read through lots of docs and howtos and get the idea of double-accounting… I think :P But since 90% of my money movements happen on my bank-account, I would love to (automatically) have all the movement in gnucash and me simply sorting it.
16:38:51 <draget> Awsome (sarcasm) <.<. I tried importing a .cvs file from my bank - the import-window that shows up is larger than my screen (1366 pixel) and cannot be resized down.
16:38:53 <draget> GUI fail.
16:48:50 <warlord> draget: yeah, OFX is a US thing, generally. In Germany you have HBCI
16:49:26 <warlord> draget: that's a known bug in 2.4; I believe it's been fixed in the dev version. (I reported that a LONG time ago)
16:53:00 <draget> I this a wrong assumption on my side since this is not how accounting works, or does gnucash not really support that kida of idea: I thought I could import my bank transactions. And then sort based on who I sent money to from which account from me, create transaction inside my gnucash-accounts. But instead I can only dump everything onto one account...?
16:53:50 <draget> I maybe I should really enter each and every transaction on my bank-account manually into gnucash. Which is... bleh, alot of work.
17:00:01 *** nafg has joined #gnucash
17:03:33 *** TommyT has joined #gnucash
17:05:49 <warlord> draget: that doesn't make sense.
17:06:28 <warlord> gnucash models money movements. There is a source (e.g. your bank account, cash in wallet, your credit card) and a destination (another bank account, or "Income" or "Expense" account)
17:06:39 <warlord> So e.g. an transaction would be Bank -> Expenses:Groceries
17:06:49 <warlord> or Income:Salary -> Bank
17:06:58 <warlord> or CC -> Expenses:Auto:Petrol
17:07:18 <warlord> The "who" (person or store name) should go in the description.
17:09:00 <draget> Yup, double-accounting, I understood. But when importing, every movement is booked to 'ausgleichskonto' (the account to balance things, no idea how it is called in english). It would be way nicer if I could specify some filter like '<my isp name>' and set it to 'Expenses:Internet' and gnucash would import automatically all transactions to the correct account.
17:11:34 *** Krzysiek_K has left #gnucash
17:13:55 <warlord> draget: you mean "imbalance" -- that's because you aren't telling the importer where to put it.
17:14:35 <warlord> If you turn on Bayesian Matching (which *should* be on by default) then as you mark those transaction gnucash will learn and future imports should get matched similarly to previous matches
17:15:25 <draget> Oh… *tries*
17:15:47 <draget> BTW: Is there a way to clear all transactions from an account without deleting and recreating it?
17:19:30 <draget> It learns only after I once imported, correct? So I'd have to import a few first which I set manually, and then import the rest and see how it learned?
17:19:53 <draget> Becuase right now I have just one file to import (my bankaccount-movements from the last two years)
17:20:42 <draget> Unchecking 'new' will make gnucash not import it - but I have to untick every transaction manually if I want to import only a few to 'train' gnucash. So I better edit the file manually first.
17:20:56 *** pnema has joined #gnucash
17:22:07 <warlord> You could File -> New File to start over. Or File -> Export Accounts to start over with the current Account Tree. But no, no way to delete all transactions just from one account.
17:22:20 <warlord> And yes, it only learns from previous imports.
17:22:32 <warlord> changes to the current import only apply to future imports.
17:25:03 <draget> And there is no way to reset/change the learned bayes-data except from starting all over again?
17:26:06 <warlord> Unfortunately there is no way to reset it from the UI.
17:26:28 <warlord> If you're adventurous you can remove it from the data file ... but make sure you backup your data first.
17:27:02 *** TommyT has quit IRC
17:34:51 <draget> If I pay our (roomie and me) ISP and my roomie transfers me half the needed money each month, the transaction is for money coming to my bankaccount. Now I am wondering from which account I should book it. 'Income:<myroomiename>:Internet'? (and I would also have Income:<myroomiename>:Flat')? Or should I rather go for 'Income:ISP' (which does not really make sense to me, since I do not get money from my ISP). Or maybe this is no income
17:34:52 <draget> at all?
17:35:19 *** Jimraeh1 has quit IRC
17:56:28 <warlord> draget: the way I would book it would be in two transactions: 1) Split from Bank -> Assets:Roomie Owes Me; Expenses:ISP. And then 2) From A:ROM -> Bank
17:56:53 <warlord> So when you pay for your roommie it's only 50% of the expense to you. The other 50% is an asset, because you expect your roomie to pay you for it.
17:56:59 <warlord> (so it's their expense, not yours)
17:57:48 * draget fires up de<->eng translator, since he already tries not to get confused with the english terms
17:58:15 <warlord> gotta run, sorry
17:58:22 <draget> Thanks anyways, alot.
19:26:11 *** pnema has left #gnucash
19:50:55 *** draget has quit IRC
19:51:55 *** benoitg has quit IRC
20:04:57 *** Jimraeh1 has joined #gnucash
20:34:53 *** Rudd-O has joined #gnucash
20:34:56 <Rudd-O> gentlemen
20:35:01 <Rudd-O> I have tried to build gnucash trunk
20:35:04 <Rudd-O> and I have succeeded
20:35:09 <Rudd-O> but then it explodes opening the general ledger
20:35:36 <Rudd-O> can I get help here?
20:35:46 <Rudd-O> or is gnucash just mostly dead now?
20:55:56 *** john has quit IRC
21:07:57 *** ErKa has quit IRC
21:42:22 *** TommyT has joined #gnucash
21:42:52 <warlord> Rudd-O: What OS/Distro?
21:43:09 <warlord> What do you mean mostly dead? 2.4.11 was released not too long ago, 2.4.12 is imminent
21:43:48 *** warlord changes topic to "Free GPL Personal and Small Business Accounting || Please don't ask to ask, just ask and wait! || publically-logged channel || latest stable: 2.4.11 || www.gnucash.org"
21:48:55 *** TommyT has quit IRC
22:26:17 *** nafg has quit IRC
22:26:49 *** nafg has joined #gnucash
22:51:51 *** nafg has quit IRC
23:55:40 *** fell has joined #gnucash
23:55:40 *** gncbot sets mode: +o fell