2013-08-29 GnuCash IRC logs
00:06:00 *** aqua___ has quit IRC
00:55:19 *** ErKa has joined #gnucash
00:57:15 *** aqua___ has joined #gnucash
02:12:05 *** aqua___ has quit IRC
02:20:43 *** john has joined #gnucash
02:20:44 *** gncbot sets mode: +o john
02:45:07 *** john has quit IRC
03:09:36 *** aqua___ has joined #gnucash
03:16:10 *** Topcat has joined #gnucash
03:27:26 *** Topcat has quit IRC
03:28:08 *** Topcat has joined #gnucash
03:38:13 *** aqua___ has quit IRC
03:43:24 *** ErKa has quit IRC
03:51:15 *** aqua___ has joined #gnucash
03:58:11 *** Topcat has quit IRC
03:58:45 *** Topcat has joined #gnucash
04:03:45 *** Topcat has quit IRC
04:04:07 *** Topcat has joined #gnucash
04:06:21 *** angeloreale has joined #gnucash
04:14:09 *** Topcat has quit IRC
04:14:50 *** Topcat has joined #gnucash
04:19:53 *** Topcat has quit IRC
04:20:17 *** Topcat has joined #gnucash
04:25:18 *** Topcat has quit IRC
04:25:53 *** Topcat has joined #gnucash
04:30:56 *** Topcat has quit IRC
04:31:29 *** Topcat has joined #gnucash
04:41:32 *** Topcat has quit IRC
04:41:55 *** Topcat has joined #gnucash
04:46:57 *** Topcat has quit IRC
04:47:33 *** Topcat has joined #gnucash
05:22:00 *** angeloreale has quit IRC
05:27:47 *** Topcat has quit IRC
05:28:10 *** Topcat has joined #gnucash
05:33:11 *** Topcat has quit IRC
05:33:34 *** Topcat has joined #gnucash
06:22:40 *** Topcat has quit IRC
06:23:03 *** Topcat has joined #gnucash
06:23:59 *** Topcat has quit IRC
06:25:12 *** Topcat has joined #gnucash
06:34:18 *** Jimraehl1 has left #gnucash
06:40:33 *** Topcat has quit IRC
06:40:56 *** Topcat has joined #gnucash
06:51:33 *** Topcat has quit IRC
06:52:08 *** Topcat has joined #gnucash
06:57:14 *** Topcat has quit IRC
06:57:19 *** Jimraehl1 has joined #gnucash
06:57:37 *** Topcat has joined #gnucash
07:02:35 *** Topcat has quit IRC
07:03:20 *** Topcat has joined #gnucash
07:08:20 *** Topcat has quit IRC
07:08:54 *** Topcat has joined #gnucash
07:18:56 *** Topcat has quit IRC
07:19:19 *** Topcat has joined #gnucash
07:24:20 *** Topcat has quit IRC
07:24:53 *** Topcat has joined #gnucash
07:26:22 *** Ard0nik has quit IRC
07:26:56 *** Ard0nik has joined #gnucash
07:37:10 *** Topcat has quit IRC
07:59:57 *** Ardonik has joined #gnucash
08:02:42 *** Ard0nik has quit IRC
08:31:02 *** aqua___ has quit IRC
08:55:47 *** aqua___ has joined #gnucash
08:58:54 *** aqua___ has quit IRC
09:28:15 *** angeloreale has joined #gnucash
09:30:47 *** herm has joined #gnucash
09:32:14 <herm> hi! is it possible to script gnucash actions. I would like to call a shell script that gets data from my bank account and then call the CSV import with the results of this script
09:35:10 <warlord> Nope, not in that way. The importers all require user input.
09:35:22 <warlord> You could write a Python script if you really want to script something.
10:01:58 *** Topcat has joined #gnucash
10:02:09 *** aqua___ has joined #gnucash
10:05:15 *** aqua___ has quit IRC
10:12:39 *** gncbot` has joined #gnucash
10:16:41 *** gncbot has quit IRC
10:22:17 *** aqua___ has joined #gnucash
10:28:18 *** Topcat has quit IRC
10:28:41 *** Topcat has joined #gnucash
10:33:41 *** Topcat has quit IRC
10:34:03 *** Topcat has joined #gnucash
10:39:05 *** Topcat has quit IRC
10:39:27 *** Topcat has joined #gnucash
11:07:18 *** Ard0nik has joined #gnucash
11:15:04 *** Ardonik has quit IRC
11:17:13 *** uXus has quit IRC
11:23:35 *** Topcat has quit IRC
11:23:57 *** Topcat has joined #gnucash
11:36:22 *** Topcat has quit IRC
11:36:59 *** Topcat has joined #gnucash
11:41:33 *** Jimraehl1 has quit IRC
11:52:01 *** Topcat has quit IRC
11:52:34 *** Topcat has joined #gnucash
12:02:48 *** Topcat has quit IRC
12:47:05 *** haclong has joined #gnucash
12:47:39 <haclong> hello
12:49:04 <haclong> i'm trying to do something with gnucash
12:49:21 <haclong> i'm buying stocks on a regular basis (once per month)
12:50:29 <haclong> is there a way (in a report) to view how much i have invested into my funds and how much value they are...
12:51:12 <haclong> how much value is easy -> just set the stock value with the correct screen. i do know this part
12:51:17 <haclong> but how much i have invested ?
12:51:53 <haclong> (sorry, i may be difficult to understand since my gnucash is in french)
12:52:41 <warlord> haclong: have you tried the portfolio or advanced portfolio reports?
12:52:53 <haclong> mmh
12:52:55 <haclong> i will
12:53:14 <haclong> i don't have my gnucash right here
12:53:20 <haclong> i may return here later
12:53:25 <haclong> the portfollio report
12:53:50 <haclong> oh, by the way, in my reports, all the lines looks weird as if the lines and the cols are not correctly line up
12:54:02 <haclong> do you know if its normal or do you know how to fix it ?
12:55:13 <haclong> i have gnucash 2.4 on ubuntu
12:55:18 <warlord> Some reports are designed that way -- they indent "extra" based on the level of account.
12:55:26 <warlord> (At least this is what I assume you are seeing)
12:55:47 <haclong> oh ok
13:02:07 *** elementz has joined #gnucash
13:09:22 *** elementz has quit IRC
13:15:05 *** Jimraehl1 has joined #gnucash
14:10:44 *** jmd` has joined #gnucash
14:13:35 *** haclong has quit IRC
14:20:36 *** john has joined #gnucash
14:45:45 *** john has quit IRC
14:56:44 *** john has joined #gnucash
15:00:34 *** Topcat has joined #gnucash
15:22:01 *** Topcat has quit IRC
15:22:42 *** Topcat has joined #gnucash
15:32:57 *** Topcat has quit IRC
15:33:20 *** Topcat has joined #gnucash
15:48:31 *** Topcat has quit IRC
15:49:04 *** Topcat has joined #gnucash
15:54:09 *** Topcat has quit IRC
15:54:43 *** Topcat has joined #gnucash
15:59:48 *** Topcat has quit IRC
16:00:10 *** Topcat has joined #gnucash
16:05:12 *** Topcat has quit IRC
16:05:45 *** Topcat has joined #gnucash
16:15:51 *** Topcat has quit IRC
16:16:14 *** Topcat has joined #gnucash
16:21:17 *** Topcat has quit IRC
16:21:54 *** Topcat has joined #gnucash
16:22:21 *** jmd` has quit IRC
16:25:25 *** leaper has joined #gnucash
16:28:43 <leaper> Hi everybody - I'd like Gnucash to automatically balance my accounts based on description. For example if a booking contains "LIDL" or "SAFEWAY" (supermarkets) I know for 90% it's food, so automatically assign the amount to the "Food" account. is this possible?
16:29:22 *** Topcat has quit IRC
16:31:22 <leaper> I read that assigning accounts to bookings makes Gnucash "learn", but how do i predefine some matches like the above?
16:44:31 <warlord> leaper: how are you entering your transactions?
16:44:49 <warlord> if you're using an importer, there is no way to pre-assign those mappings.
16:45:12 <leaper> HBCI
16:45:31 <leaper> i.e. by directly connecting to my bank via API and downloading the transactions
16:46:14 <warlord> Yep, I know what HBCI is.
16:46:37 <warlord> So, my statement still stands -- there is no way to pre-set mappings. You have to train gnucash manually.
16:46:52 <warlord> (although I've never heard of "Safeway" in germany)
16:51:03 <leaper> it was just an example
16:51:11 <leaper> LIDL, ALDI, etc. :)
16:51:43 <leaper> how do I see the training results? does Gnucash at some point start auto-assigning transactions by itself?
16:52:40 <warlord> There is no UI method to view the training.
16:52:44 <warlord> (or to reset it)
16:53:15 <warlord> and yes, it will start auto-assigning once you start training (the next import)
17:01:07 <leaper> do I start training by starting to assign accounts, or is this a separat eprocess?
17:01:50 <leaper> and: can I tell Gnucash to redo an automatic assignment when it has learnt enough?
17:02:27 <leaper> (I am planning to import 8 years of bookkeeping into Gnucash - and I doubt it'll get everything right the first time. But when I have assigned a few dozen accounts I want it to continue with the imported date.)
17:02:29 <warlord> You just start assigning accounts in the importer..
17:02:31 <leaper> s/date/data/
17:02:41 <warlord> I recommend turning on Bayesian Matching first
17:02:53 <leaper> ok
17:02:55 <warlord> Are you importing via QIF? Or something else
17:03:02 <leaper> CSV, probably
17:03:08 <leaper> from another application
17:03:18 <warlord> Okay.. Import small pieces first..
17:03:23 <leaper> so automatic assignment can't happen once the data is imported?
17:03:28 <warlord> Correct.
17:03:36 <warlord> It's an importer function
17:03:40 <leaper> ok
17:04:32 <leaper> can I write a plugin or script that does the assignment? ;) this might be easier
17:05:41 <warlord> You're better off writing a script to convert the CSV to QIF and adding appropriate QIF Category and QIF Account mappings.. Then you actually *can* pre-assign by creating a properly formed qif account map file.
17:06:48 <warlord> the map allows you to to map QIF Category -> GNC Income/Expense Account, QIF Account -> GNC Asset/Liability, and even Payee/Memo to GNC Income/Expense.. Although the Payee/Memo matching is full-string, not substring
17:07:03 <warlord> If you're comfortable scripting then I'd recommend that approach.
17:08:36 <leaper> hm, I have no idea how the QIF file format looks like
17:10:21 <leaper> but it looks rather simple (quick google search)
17:10:22 <warlord> It's text. it's simple. google is your friend
17:10:27 <leaper> yup
17:10:28 <warlord> :)
17:10:28 <leaper> thanks
17:10:47 <warlord> you;re welcome. I'm going to have to go soon.
17:10:57 <leaper> will this preassignment train the bayes database too?
17:11:02 <leaper> or is it static?
17:11:11 <leaper> last question ;)
17:14:19 <warlord> QIF doesn't use Bayes
17:14:32 <warlord> it's a completely separate importer
17:16:32 <leaper> ok thanks
17:16:35 <leaper> good night ;)
17:16:43 *** leaper has quit IRC
17:47:19 *** john has quit IRC
17:49:18 *** john has joined #gnucash
18:00:17 *** Ard0nik has quit IRC
19:31:47 *** bpburns has quit IRC
20:29:06 *** john has quit IRC
20:36:24 *** Jimraehl1 has quit IRC
22:18:42 *** wizkid238 has quit IRC
22:21:03 *** wizkid238 has joined #gnucash
23:17:06 *** fell has joined #gnucash
23:51:05 *** fell_ has joined #gnucash
23:54:10 *** fell_ has quit IRC
23:55:42 *** fell has quit IRC