2014-06-11 GnuCash IRC logs

00:00:01 *** benoitg has quit IRC
00:44:01 *** MechtiIde has quit IRC
01:01:24 *** O01eg has quit IRC
01:06:59 *** gjanssens has joined #gnucash
01:06:59 *** gncbot sets mode: +o gjanssens
01:20:15 *** Krzysiek_K has joined #gnucash
01:40:29 *** floh1111 has joined #gnucash
01:47:53 *** ErKa has quit IRC
01:56:18 *** Krzysiek_K has quit IRC
03:05:33 *** floh1111 has quit IRC
03:13:03 *** floh1111 has joined #gnucash
03:42:31 *** StuM has quit IRC
03:42:37 *** StuM has joined #gnucash
04:16:36 *** floh1111_ has joined #gnucash
04:19:53 *** aqua___ has joined #gnucash
04:22:33 *** floh1111 has quit IRC
04:30:41 *** aqua___ has quit IRC
04:35:57 *** floh1111_ has quit IRC
04:40:42 *** todd_ has quit IRC
04:41:00 *** todd has joined #gnucash
04:44:56 *** wol has joined #gnucash
05:10:47 *** Jimraehl1 has left #gnucash
05:14:56 *** Jimraehl1 has joined #gnucash
05:19:40 *** fell_ has joined #gnucash
05:19:42 *** gncbot sets mode: +o fell_
05:30:22 *** Jimraehl1 has quit IRC
06:16:17 *** floh1111 has joined #gnucash
06:34:57 *** himaxx has joined #gnucash
06:37:21 *** floh1111 has quit IRC
06:40:01 *** wol has quit IRC
06:40:39 *** Ard0nik has quit IRC
06:45:45 *** wol has joined #gnucash
06:48:28 *** Ardonik has joined #gnucash
06:52:28 *** himaxx has quit IRC
07:26:35 *** floh1111 has joined #gnucash
07:27:05 <lmat> jralls: cool.
08:47:01 *** wol has quit IRC
09:13:49 *** linas_ has joined #gnucash
09:13:49 *** linas__ has quit IRC
09:20:20 *** benoitg has joined #gnucash
09:52:22 *** ErKa has joined #gnucash
10:00:24 *** benoitg has quit IRC
10:15:48 *** jmd has joined #gnucash
10:17:01 *** aqua___ has joined #gnucash
10:20:23 *** jmd` has joined #gnucash
10:33:46 *** jmd` has quit IRC
10:35:59 *** jmd` has joined #gnucash
10:38:11 *** wol has joined #gnucash
10:47:12 *** aqua___ has quit IRC
10:49:59 <lmat> I'm looking at my gnucash file, and see an account, "Root Account"
10:50:13 <lmat> It's not marked as 'hidden' or 'placeholder'. Can I post to it ?
10:50:25 <lmat> How do I test for it ? Does it have a known GUID?
10:52:25 <lmat> oh, it's account type= ROOT. I'll filter by that to avoid it.
11:21:39 *** StuM has quit IRC
11:22:18 *** StuM has joined #gnucash
11:23:22 *** wol has quit IRC
11:23:35 *** wol has joined #gnucash
11:50:45 *** StuM has quit IRC
12:02:08 *** jmd has quit IRC
12:09:40 *** Bodhi-Baum has joined #gnucash
12:11:06 *** wol has joined #gnucash
12:20:02 *** benoitg has joined #gnucash
12:28:13 *** Krzysiek_K has joined #gnucash
12:42:09 *** wol has quit IRC
12:42:46 *** MechtiIde has joined #gnucash
13:02:33 *** Krzysiek_K has quit IRC
13:19:24 <lmat> In transactions table, it refers to a guid currency. Where is that currency defined?
13:19:32 <lmat> Is it a well-known value? Or is it somewhere in the database?
13:19:39 <lmat> I don't see a table called currencies, for instance.
13:27:54 <lmat> warlord, where are you? I NEEEd YOU!! ^_^
13:31:37 *** lmat has quit IRC
13:34:35 *** isaacd has joined #gnucash
13:45:13 *** ErKa has quit IRC
13:51:31 *** lmat has joined #gnucash
13:53:03 <lmat> so, sqlite3 myfile.gnucash <<< ".schema" | grep currency; doesn't show any currency files, although there are 6 lines that use "currency", and two of those use currency_guid.
13:53:13 <lmat> s/files/tables/
14:11:10 *** lmat has quit IRC
14:13:17 *** ErKa has joined #gnucash
14:16:26 *** lmat has joined #gnucash
14:21:33 *** Krzysiek_K has joined #gnucash
14:22:25 *** Krzysiek_K has left #gnucash
14:26:15 <lmat> gjanssens: Do you know where currency guids are found/
14:28:51 <gjanssens> lmat: currencies are a kind of commodities
14:29:05 <gjanssens> lmat: you can look at the commodities table to find your currency guids
14:42:27 *** aqua___ has joined #gnucash
14:53:17 *** Bodhi-Baum has quit IRC
14:53:44 <lmat> gjanssens: excellent, thanks!
14:55:00 <lmat> gjanssens: I'm putting together a script to generate sample data.
15:04:23 <gjanssens> lmat: you're welcome
15:04:37 *** gjanssens is now known as gjanssens_
15:24:30 *** aqua___ has quit IRC
15:25:40 <lmat> hey, it's working ;)
15:26:59 *** aqua___ has joined #gnucash
15:30:49 *** aqua___ has quit IRC
15:32:05 *** aqua___ has joined #gnucash
15:50:12 *** fell__ has joined #gnucash
15:50:13 *** gncbot sets mode: +o fell__
15:51:26 *** gjanssens_ has quit IRC
15:51:58 <retrospectacus> is there a preferred backend for gnucash? XML or mysql?
15:59:48 *** fell_ has quit IRC
16:03:24 *** fell__ has quit IRC
16:04:03 *** benoitg has quit IRC
16:08:40 *** MechtiIde has quit IRC
16:24:41 *** Krzysiek_K has joined #gnucash
16:52:20 *** aqua___ has quit IRC
16:55:40 *** StuM has joined #gnucash
17:30:03 *** floh1111 has quit IRC
17:49:37 *** warlord has joined #gnucash
17:49:37 *** gncbot sets mode: +o warlord
19:41:31 *** ErKa has quit IRC
20:17:46 *** uXuss has quit IRC
20:21:40 *** kpreid has quit IRC
21:53:36 *** fell__ has joined #gnucash
21:53:37 *** gncbot sets mode: +o fell__
23:05:50 *** ErKa has joined #gnucash
23:14:14 *** kpreid has joined #gnucash
23:29:35 *** uXus has joined #gnucash
23:30:27 *** kpreid has quit IRC
23:39:06 *** ErKa has quit IRC
23:39:19 *** MechtiIde has joined #gnucash