2013-08-23 GnuCash IRC logs

00:29:35 *** Krzysiek_K has joined #gnucash
00:34:46 *** Krzysiek_K1 has quit IRC
00:46:29 *** Krzysiek_K1 has joined #gnucash
00:51:40 *** Krzysiek_K has quit IRC
01:17:49 *** Krzysiek_K has joined #gnucash
01:20:00 *** Krzysiek_K1 has quit IRC
01:42:08 *** lwells has joined #gnucash
01:45:15 <lwells> How unstable is 2.5.3?
02:20:42 *** john has joined #gnucash
02:20:43 *** gncbot sets mode: +o john
02:24:02 *** lwells has left #gnucash
02:36:00 *** Krzysiek_K has left #gnucash
02:45:16 *** john has quit IRC
02:45:27 *** ErKa has quit IRC
04:12:06 *** ErKa has joined #gnucash
05:49:09 *** ErKa has quit IRC
06:39:28 *** aqua___ has joined #gnucash
06:45:51 *** Jimraehl1 has left #gnucash
06:58:48 *** Jimraehl1 has joined #gnucash
07:29:44 *** shanny has joined #gnucash
07:42:03 *** shanny has quit IRC
08:07:55 *** aqua___ has quit IRC
08:43:15 *** Ardonik has quit IRC
08:50:56 *** aqua___ has joined #gnucash
09:22:57 *** aqua___ has quit IRC
09:39:41 *** aqua___ has joined #gnucash
10:09:09 *** arrainey has joined #gnucash
10:15:23 *** aqua___ has quit IRC
10:20:33 *** benoitg has quit IRC
10:26:26 *** aqua___ has joined #gnucash
10:34:28 *** arrainey has quit IRC
10:34:40 *** benoitg has joined #gnucash
10:34:51 *** arrainey has joined #gnucash
10:39:56 *** arrainey has quit IRC
10:40:18 *** arrainey has joined #gnucash
10:40:43 *** Ardonik has joined #gnucash
11:04:03 *** arrainey has quit IRC
11:04:25 *** arrainey has joined #gnucash
11:12:01 *** arrainey has quit IRC
11:12:24 *** arrainey has joined #gnucash
11:23:25 *** arrainey has quit IRC
11:23:48 *** arrainey has joined #gnucash
11:29:13 *** arrainey has quit IRC
11:29:36 *** arrainey has joined #gnucash
11:33:44 *** aqua___ has quit IRC
11:41:39 *** aqua___ has joined #gnucash
11:43:12 *** aqua___ has quit IRC
11:53:32 *** arrainey has quit IRC
11:53:54 *** arrainey has joined #gnucash
12:03:57 *** arrainey has quit IRC
12:04:19 *** arrainey has joined #gnucash
12:09:21 *** arrainey has quit IRC
12:09:44 *** arrainey has joined #gnucash
12:14:44 *** arrainey has quit IRC
12:15:06 *** arrainey has joined #gnucash
12:20:08 *** arrainey has quit IRC
12:20:31 *** arrainey has joined #gnucash
12:25:31 *** arrainey has quit IRC
12:25:54 *** arrainey has joined #gnucash
12:30:56 *** arrainey has quit IRC
12:31:30 *** arrainey has joined #gnucash
12:36:30 *** arrainey has quit IRC
12:37:22 *** arrainey has joined #gnucash
12:49:53 *** arrainey has quit IRC
12:50:26 *** arrainey has joined #gnucash
12:55:26 *** arrainey has quit IRC
12:56:04 *** arrainey has joined #gnucash
13:01:08 *** arrainey has quit IRC
13:01:55 *** arrainey has joined #gnucash
13:07:09 *** ErKa has joined #gnucash
13:14:26 *** arrainey has quit IRC
13:15:00 *** arrainey has joined #gnucash
13:41:23 *** arrainey has quit IRC
13:41:58 *** arrainey has joined #gnucash
13:46:59 *** arrainey has quit IRC
13:47:35 *** arrainey has joined #gnucash
13:52:37 *** arrainey has quit IRC
13:53:12 *** arrainey has joined #gnucash
13:58:13 *** arrainey has quit IRC
13:58:48 *** arrainey has joined #gnucash
14:03:52 *** arrainey has quit IRC
14:04:29 *** arrainey has joined #gnucash
14:09:31 *** arrainey has quit IRC
14:10:08 *** arrainey has joined #gnucash
14:15:08 *** arrainey has quit IRC
14:15:48 *** arrainey has joined #gnucash
14:20:50 *** arrainey has quit IRC
14:21:38 *** arrainey has joined #gnucash
14:26:16 *** john has joined #gnucash
14:26:16 *** gncbot sets mode: +o john
14:36:46 *** arrainey has quit IRC
14:37:30 *** arrainey has joined #gnucash
14:42:32 *** arrainey has quit IRC
14:43:05 *** arrainey has joined #gnucash
14:44:21 *** benoitg has quit IRC
14:58:17 *** arrainey has quit IRC
15:22:36 *** benoitg has joined #gnucash
15:43:30 *** arrainey has joined #gnucash
15:48:30 *** arrainey has quit IRC
15:48:53 *** arrainey has joined #gnucash
15:59:08 *** arrainey has quit IRC
15:59:30 *** arrainey has joined #gnucash
16:09:19 *** arrainey has quit IRC
16:09:40 *** elementz has joined #gnucash
16:09:42 *** arrainey has joined #gnucash
16:15:53 *** arrainey has quit IRC
16:16:15 *** arrainey has joined #gnucash
16:18:52 <elementz> hi all. i have imported a big financial history (~2 years worth of transactions) from my online banking account into gnucash. is there a way to bulk-"classify" the entries of repeat transactions? e.g. all cash withdrawals?
16:20:00 <elementz> what would be my options to modify the account history? can i somehow manipulate the gnucash database?
16:23:56 <warlord> elementz: the best way to do it is to use the importer's ability to learn from previous (in-import) matching of transactions..
16:24:17 <warlord> There is no way to bulk-move transactions.. and modifying the gnucash database from under gnucash is not supported.
16:24:42 <elementz> warlord: hm. is there a different way to access the database?
16:25:12 <warlord> The generally suggested way to do it is to turn on bayesian matching, then importer a small collection of transactions (like a month).. assign those appropriately in the importer, and then you can importer more transactions and the importer should've learned from the first attempt.
16:25:33 <warlord> Only through the GnuCash API (available in C, Scheme, and Python)
16:26:04 <elementz> warlord: i was looking for the python api but could not find a proper documentation.
16:26:41 <warlord> Look at the C API; the python wrapper is literally a wrapper around the C API.. It's not really "python" per se.
16:27:11 <elementz> warlord: hm. would this https://github.com/tdf/pygnclib be the python wrapper?
16:27:26 <warlord> No clue.
16:27:33 <warlord> (if it is or not)
16:27:41 <warlord> The python wrapper is part of GnuCash..
16:27:50 <warlord> configure with --enable-python
16:28:13 <warlord> I have no idea what that github project is
16:29:43 <elementz> warlord: ok. what about the database itself. would that be the .gnucash file? also where would the gnucash xml file be stored and would would that contain (info on transactions or only account configuration)? i could not find any xml file in .gnucash
16:31:20 <elementz> s/would would/what would
16:33:46 <warlord> Assuming you're using XML, then your datafile <yourdatafilename>.gnucash is your datafile (usually gzipped) and it contains all your data (accounts, transactions, securities, prices, etc).
16:33:55 <warlord> Where it lives is all based on where you told GnuCash to put it.
16:34:28 <elementz> warlord: ah ok. so the data is not stored in a SQL Database at all?
16:34:40 <warlord> It depends which backend you use..
16:34:43 <warlord> The default is XML
16:34:59 <warlord> There are SQL backends (although they are not considered "stable", yet)
16:35:19 <warlord> ... people keep finding data loss issues in the SQL backends..
16:35:56 <elementz> ah, good to know. so couldn't is simply modify the XML file e.g. with grep/sed and then gzip it again? or could that create problems?
16:36:46 <warlord> It could create problems.
16:37:00 <warlord> Most likely your references would break.
16:37:15 <warlord> Seriously, the best way to do it is during the import process.
16:37:57 <elementz> hm seems like it. although this is a very inconvenient way of doing things though...
16:38:06 <elementz> anyways. thank you for your help :)
16:38:18 <warlord> It's a one-time operation.... gnucash isn't optimized for that.
16:38:24 <warlord> it's optimized for continual usage..
16:38:29 <warlord> initial imports you do... once.
16:38:37 <warlord> transaction entry you do every day.
16:39:11 <elementz> so does the bayesian classification actually work well?
16:40:14 <warlord> Depends who you ask, and what extra data is in the OFX content
16:40:28 <elementz> ok. guess i'll have to try
16:40:30 <warlord> Some people say it works well. Others say it has a 20-50% error rat
16:40:33 <warlord> rate
16:41:28 *** benoitg has quit IRC
16:46:44 *** arrainey has quit IRC
16:47:07 *** arrainey has joined #gnucash
16:51:55 *** elementz has quit IRC
16:58:12 *** arrainey has quit IRC
16:58:34 *** arrainey has joined #gnucash
17:04:58 *** arrainey has quit IRC
17:05:21 *** arrainey has joined #gnucash
17:10:21 *** arrainey has quit IRC
17:10:44 *** arrainey has joined #gnucash
17:23:29 *** ErKa has quit IRC
17:33:40 *** arrainey has quit IRC
17:34:03 *** arrainey has joined #gnucash
17:39:03 *** arrainey has quit IRC
17:39:26 *** arrainey has joined #gnucash
17:44:27 *** arrainey has quit IRC
17:44:50 *** arrainey has joined #gnucash
17:47:50 *** benoitg has joined #gnucash
18:01:58 *** arrainey has quit IRC
18:02:43 *** arrainey has joined #gnucash
18:07:43 *** arrainey has quit IRC
18:08:17 *** arrainey has joined #gnucash
18:13:19 *** arrainey has quit IRC
18:14:00 *** arrainey has joined #gnucash
18:14:29 *** Ardonik has quit IRC
18:21:49 *** elementz has joined #gnucash
18:29:07 *** arrainey has quit IRC
18:29:45 *** arrainey has joined #gnucash
18:34:46 *** arrainey has quit IRC
18:35:24 *** arrainey has joined #gnucash
18:40:11 *** elementz has quit IRC
18:45:33 *** arrainey has quit IRC
18:46:13 *** arrainey has joined #gnucash
18:51:47 *** ErKa has joined #gnucash
18:51:48 *** arrainey has quit IRC
18:52:19 *** arrainey has joined #gnucash
18:57:13 *** arrainey has quit IRC
19:06:36 *** benoitg has quit IRC
19:10:35 *** john has quit IRC
19:23:27 *** john has joined #gnucash
19:23:28 *** gncbot sets mode: +o john
19:35:22 *** benoitg has joined #gnucash
19:35:23 *** gncbot sets mode: +o benoitg
19:35:37 *** arrainey has joined #gnucash
19:42:39 *** arrainey has quit IRC
20:05:52 *** arrainey has joined #gnucash
20:11:07 *** arrainey has quit IRC
20:11:29 *** arrainey has joined #gnucash
20:16:31 *** arrainey has quit IRC
20:16:53 *** arrainey has joined #gnucash
20:21:54 *** arrainey has quit IRC
20:22:17 *** arrainey has joined #gnucash
20:37:21 *** arrainey has quit IRC
20:37:44 *** arrainey has joined #gnucash
20:42:45 *** arrainey has quit IRC
20:43:09 *** arrainey has joined #gnucash
20:49:49 *** john has quit IRC
20:58:21 *** arrainey has quit IRC
20:58:44 *** arrainey has joined #gnucash
21:03:44 *** arrainey has quit IRC
21:04:06 *** arrainey has joined #gnucash
21:09:07 *** arrainey has quit IRC
21:09:31 *** arrainey has joined #gnucash
21:14:31 *** arrainey has quit IRC
21:14:54 *** arrainey has joined #gnucash
21:19:56 *** arrainey has quit IRC
21:20:18 *** arrainey has joined #gnucash
21:25:19 *** arrainey has quit IRC
21:25:41 *** arrainey has joined #gnucash
21:30:42 *** arrainey has quit IRC
21:31:04 *** arrainey has joined #gnucash
21:36:06 *** arrainey has quit IRC
21:36:28 *** arrainey has joined #gnucash
21:41:29 *** arrainey has quit IRC
21:41:51 *** arrainey has joined #gnucash
21:46:53 *** arrainey has quit IRC
21:47:15 *** arrainey has joined #gnucash
21:57:42 *** arrainey has quit IRC