2008-02-26 GnuCash IRC logs
00:15:52 <warlord> .
00:15:57 *** warlord is now known as warlord-afk
00:26:42 *** def_ has quit IRC
01:12:48 *** snavin-6d has quit IRC
01:12:48 *** wizkid240 has quit IRC
01:12:48 *** joerlend_ has quit IRC
01:12:48 *** hachi has quit IRC
01:12:48 *** zarchne has quit IRC
01:12:48 *** jcreigh has quit IRC
01:12:49 *** snavin-6d has joined #gnucash
01:12:49 *** wizkid240 has joined #gnucash
01:12:49 *** joerlend_ has joined #gnucash
01:12:49 *** hachi has joined #gnucash
01:12:49 *** zarchne has joined #gnucash
01:12:49 *** jcreigh has joined #gnucash
02:25:49 *** snavin-6d has quit IRC
02:27:06 *** snavin-6d has joined #gnucash
02:29:31 *** _McLANE_ has joined #gnucash
02:30:20 *** Def has joined #gnucash
03:25:18 *** _McLANE_ has quit IRC
04:19:57 *** cortana has quit IRC
04:28:30 *** ErKa has joined #gnucash
05:06:48 *** cortilap has joined #gnucash
05:26:59 *** snavin-6d has quit IRC
05:41:12 *** snavin-6d has joined #gnucash
06:31:29 *** twunder has joined #gnucash
06:40:11 *** twunder has quit IRC
07:17:55 *** _McLANE_ has joined #gnucash
07:52:04 *** paulproteus__ has joined #gnucash
07:52:50 *** paulproteus_ has quit IRC
07:59:16 *** snavin-6d has quit IRC
08:08:37 *** snavin-6d has joined #gnucash
08:11:44 *** guillaume_ has quit IRC
08:15:13 *** vinci has joined #gnucash
08:17:27 *** benoitg has left #gnucash
08:31:08 *** tpfennig_ has joined #gnucash
08:31:39 *** benoitg has joined #gnucash
08:42:03 *** warlord-afk is now known as warlord
08:48:33 *** wizkid240 is now known as wizkid238
09:20:54 *** donfede has joined #gnucash
09:53:28 *** snavin-6d has quit IRC
10:03:58 *** zarchne has quit IRC
10:14:15 *** guillaume has joined #gnucash
10:29:27 *** grandcanuck has joined #gnucash
10:42:01 *** joerlend_ has quit IRC
10:45:37 *** XiXaQ has joined #GnuCash
11:17:25 *** _McLANE_ has quit IRC
11:18:35 *** rik has joined #gnucash
11:24:22 <rik> Is there a way to do my own import/direct data write and/or another way to avoid the hundreds of dialog boxes I get when trying to use GnuCash's import ?
11:29:47 <jsled> hundreds of dialog boxes?
11:30:18 <warlord> This is OFX?
11:30:46 <rik> Er, no, trying to get initial Quicken data
11:31:14 <warlord> Ummm... then what hundreds of dialog boxes are you talking about?
11:31:54 <rik> For each and every security, it comes up with a box asking various questions such as ticker and exchange. I have literally hundreds of these to go through.
11:34:09 <warlord> yes, you need to create all the securities.
11:34:21 <warlord> There's no way around that, unless you just dont want to import your security accounts.
11:35:11 <rik> OK, but can I do that outside of this dialog box arrangement. Can I create a database of my own that has these references and import that somehow ? So far I only get to the letter F before my fingers start to wear out and something that streamlines this would be very helpful.
11:36:13 <rik> I definitely want to import all securities. They are the ONLY things I am interested in.
11:36:47 *** cortilap has quit IRC
11:37:04 <warlord> Yes and no. Yes, you can pre-populate your gnucash data file with all the securities.. HOWEVER the only way to do that is via the "create commodity" dialog.
11:37:14 <warlord> So, you need to go through the dialog interface either way.
11:37:24 <warlord> GnuCash requires more information than QIF provides.
11:37:33 <rik> Hum. More dialogs.
11:37:40 <warlord> Although you COULD just click "ok" right away and then go back and modify them later.
11:38:24 <rik> Yes I realize more data is needed, but I can generate that myself using some other program.
11:38:59 <rik> Yes, I was just clicking OK
11:39:44 <rik> OK, another approach. Would trying to compile GnuCash under Cygwin be a nightmare and/or what are the prospects of being able to create a new handler for that aspect ?
11:41:25 *** cortilap has joined #gnucash
11:53:17 <warlord> under CYGWIN? That would be a nightmare... But that's because we use MinGW and that doesn't interact well with Cygwin.
11:53:56 <warlord> As for generating that extra data yourself using some other program.... the problem is that there's no interface to import that data into gnucash.
11:54:20 <rik> Thanks. I suspected that might be the case. What if we cut the problem down to size and just focussed on an API to the GnuCash data ?
11:54:31 <warlord> you could TRY to hand-edit the data file (it's just XML)..
11:54:44 <warlord> Oh, that API already exists.
11:54:48 <warlord> gnc-commodity.h
11:56:40 <rik> Ah. OK. That sounds good. Is there any stubs, examples, or essentially similar bits of program lying around that might be relevant ?
12:03:02 <warlord> sorry. no.
12:03:41 <warlord> but there's both a C interface and a Scheme interface.. So you could write a small Scheme script to add a menu item to add your items.
12:04:07 <rik> OK. Many thanks for your help. XML also sounds good. So, looks as though there are at least two possible solutions here (ok 3 based on last message :-)
12:06:47 *** tpfennig_ has quit IRC
12:07:33 <warlord> * nods *
12:09:46 <rik> OK. Signing off. Thanks.
12:11:01 *** rik has quit IRC
12:34:25 *** twunder has joined #gnucash
12:47:14 *** twunder has quit IRC
12:54:29 *** warlord is now known as warlord-afk
13:04:46 *** cortilap has quit IRC
13:36:20 *** cortana has joined #gnucash
13:41:27 *** jsled has quit IRC
13:52:11 *** jsled has joined #gnucash
13:52:12 *** gncbot sets mode: +o jsled
13:57:42 *** wizkid239 has joined #gnucash
13:59:18 *** ErKa has quit IRC
14:00:56 *** _gunni_ has joined #gnucash
14:05:46 *** wizkid238 has quit IRC
14:16:35 *** Zoolooc_ has joined #gnucash
14:22:21 *** sjc has joined #gnucash
14:48:37 *** billy has joined #gnucash
14:50:16 *** andi5 has joined #gnucash
14:50:16 *** gncbot sets mode: +o andi5
14:51:32 *** billy has quit IRC
15:25:00 *** warlord-afk is now known as warlord
15:25:21 *** jsled has quit IRC
15:25:37 *** jsled has joined #gnucash
15:25:37 *** gncbot sets mode: +o jsled
15:33:17 *** XiXaQ has quit IRC
15:42:47 *** XiXaQ has joined #GnuCash
15:50:47 *** sjc has quit IRC
15:53:40 *** twunder has joined #gnucash
15:58:56 *** sjc has joined #gnucash
16:56:11 *** twunder has quit IRC
16:57:02 *** grandcanuck has quit IRC
17:17:36 *** guillaume has quit IRC
17:32:30 *** _gunni_ has quit IRC
17:57:43 *** andi5 has quit IRC
18:00:31 *** chris has quit IRC
18:05:41 *** donfede has quit IRC
18:17:41 *** guillaume has joined #gnucash
18:46:58 *** benoitg has quit IRC
18:47:09 *** benoitg has joined #gnucash
19:16:32 *** Zoolooc_ has quit IRC
19:19:55 *** tpfennig_ has joined #gnucash
19:31:04 *** vinci has quit IRC
19:44:42 *** wizkid238 has joined #gnucash
19:52:29 *** wizkid239 has quit IRC
20:22:37 *** tpfennig__ has joined #gnucash
20:29:33 *** sjc has quit IRC
20:31:23 *** tpfennig_ has quit IRC
21:08:13 *** zarchne has joined #gnucash
21:19:20 *** eris_ has joined #gnucash
21:20:07 <eris_> when you add a catagory to a transaction, how do you make that catagory follow all the transactions with that same description
21:20:38 <jsled> GnuCash doesn't have categories. Do you mean Expense account?
21:20:50 <jsled> And where are you doing this adding? In an importer, or the register?
21:20:56 <jsled> If importer, which one?
21:21:23 <eris_> on the "transfer" column'
21:21:28 <eris_> that looked like catagores
21:21:31 <eris_> is that not?
21:22:03 <jsled> No, GnuCash does't have what quicken calls categories; we use Expense accounts for a similar purpose.
21:22:24 <jsled> If you've not read the tutorial and concepts guide, it's a good read <http://www.gnucash.org/docs/v2.0/C/gnucash-guide/>.
21:23:03 <jsled> So, do the other transactions – the ones with the same description – already exist, or no?
21:23:19 <eris_> yes
21:23:30 <eris_> we imported the data from 2 years ago fwd
21:24:06 <jsled> Ah.
21:24:18 <jsled> Well, there's no good way to update all the existing transactions in bulk.
21:24:32 <eris_> ouch
21:24:42 <eris_> how is the data stored?
21:24:44 <eris_> mysql?
21:24:54 <eris_> i can do it manually if needed
21:25:02 <jsled> If you're in a position to do the import again, the importer itself will keep mappings (by description)... so if you do them in batches, you can train it.
21:25:19 <jsled> The datafile is XML. I'd not suggest modifying it in this case.
21:25:40 <eris_> ya, one little slip
21:25:42 <eris_> lol
21:25:44 <eris_> thanks
21:25:50 <eris_> i will reimport and play with that
21:25:53 <jsled> The data is QIF?
21:25:57 <eris_> was
21:25:58 <eris_> yes
21:26:08 <jsled> Keep in mind that it only applies the mappings to *subsequent* import files.
21:26:08 <eris_> imported from online banking
21:26:26 <eris_> so we import one month, and and fix it
21:26:30 <eris_> then add the rest
21:26:31 <jsled> Like, if you have the same description 3 times in one file, you'll have to map it all 3 times during the import of that file.
21:26:32 <jsled> Right.
21:26:41 <eris_> :)
21:26:42 <eris_> that works
21:26:48 <eris_> thank you!!
21:27:06 <jsled> you're welcome.
21:27:32 *** eris_ has quit IRC
21:31:59 <warlord> actually, the description should only need to be mapped once.
21:32:06 <warlord> the qif importer does collect them.
22:05:09 *** benoitg has left #gnucash
22:14:06 *** joerlend_ has joined #GnuCash
22:14:07 *** XiXaQ has quit IRC
22:42:40 *** rvaniwaa has joined #gnucash
22:47:14 *** rvaniwaa has quit IRC