2010-08-11 GnuCash IRC logs
00:51:42 *** fuzzybunny69y has joined #gnucash
00:53:05 *** Askarii has quit IRC
00:58:04 <fuzzybunny69y> Hey everyone! I am migrating my data from Quicken 2006 XG Realease R1 into GNUCash 2.2.9 and the QIF file I am using has all the accounts in one QIF file and I included the Transations, Account List and Category List. Using the QIF Importer I matched up all the accounts that I could but for some reason after the import it created duplicates of many of my accounts(like Alcohol and Alcohol 2 for example), eventhough during the
00:58:04 <fuzzybunny69y> import process in had matched up the correct categories and accounts. The QIF file I am importing is mainly accounts whose transactions are using CAD and the accounts that I currently have in GNUCash are using NZD. Could this be why it created all the duplicate accounts?
03:14:52 *** Jimraehl1 has joined #gnucash
03:38:06 *** fuzzybunny69y has quit IRC
03:41:54 *** kpreid_ has joined #gnucash
03:47:25 *** kpreid has quit IRC
03:47:26 *** kpreid_ is now known as kpreid
04:20:03 *** Jimraehl1 has quit IRC
04:31:04 *** dkorzhevin has joined #gnucash
04:40:02 *** bentob0x has joined #gnucash
05:18:37 *** bentob0x has quit IRC
05:24:30 *** piropiro has quit IRC
05:40:03 *** Jimraehl1 has joined #gnucash
05:45:34 *** MikeE has joined #gnucash
06:49:14 *** warlord-afk is now known as warlord
06:49:47 *** Jimraehl1 has quit IRC
07:13:06 *** linas has quit IRC
07:13:17 *** linas has joined #gnucash
07:14:08 *** linas has quit IRC
07:14:18 *** linas has joined #gnucash
07:18:45 *** Jimraehl1 has joined #gnucash
07:20:43 *** fbond has joined #gnucash
07:36:48 <warlord> @op linas
07:36:49 *** gncbot sets mode: +o linas
07:38:57 *** warlord has quit IRC
08:04:32 *** Jimraehl1 has left #gnucash
08:10:20 *** Jimraehl1 has joined #gnucash
08:19:00 *** bentob0x has joined #gnucash
08:39:58 *** KaiForce has joined #gnucash
09:17:10 *** raleightile has joined #gnucash
09:17:30 *** raleightile has left #gnucash
09:18:12 *** Jimraehl1 has quit IRC
09:19:34 *** Jimraehl1 has joined #gnucash
09:22:27 *** Askarii has joined #gnucash
09:22:40 *** Askarii has quit IRC
09:29:09 *** david has joined #gnucash
09:35:06 <david> hi, there is a filed Notes on the Account properties dialog. I save my accounts to a database (postgresql). The database Accounts table does not contain a column for the Notes.
09:35:41 <david> I can not find it in any other table. Please where are Notes saved?
09:37:57 *** Askarii has joined #gnucash
09:39:26 <david> Second question:
09:45:34 <david> GUIDs are generated by a libqof library described in guid.h
09:49:13 <david> There is an executable file generating guids
09:50:06 <david> I try to implement a database function using the shared library
09:50:35 <david> (postgres does not allow calling OS commands anymore)
09:50:47 <jsled> guid's are just random data
09:50:57 <jsled> s/'//
09:51:25 <jsled> I'd guess notes are in the generic kvp (key-value pair) data associated with transactions.
09:51:25 <david> yes, I need to generate GUID from within the database /through a database function)
09:51:33 *** Reese1872 has quit IRC
09:51:48 <jsled> I don't know the DB backend or schema enough to guide you in any more detail; hopefully the table has "kvp" in the name.
09:52:49 <jsled> david: but, I implied a question you didn't ask. what's the second question, actually?
09:53:53 <david> which of the functions in guid.h provide the guid in a text datatype?
09:55:16 <david> and whether has someone tried to use GC shared libraries from within PG ?
09:56:04 <jsled> guid_to_string http://cvs.gnucash.org/docs/HEAD/group__GncGUID.html#gf01eb93ad6d9dbf45ce33499fd502dd9 and the following (guid_to_string_buff) are probably what you want.
09:56:14 <jsled> I have no idea about using gnc libs from pg.
09:56:32 <jsled> I would recommend integrating with gnucash at the shared library level, not the database level.
09:56:49 <jsled> an application's database is not a reasonable integration point, unless explicitly crafted as such; gnucash's is not.
09:58:10 <david> guid_to_string_buff is gchar * (which means pointer to string, doesn't ?)
09:59:27 <david> and requires input parameters...
09:59:38 <jsled> pointer to a character, really. by convention a string, yes.
10:02:14 <david> well ... it might be ba ad idea to integrate in db level, but I can't code in C ... so the database backend is seducing
10:04:00 *** ErKa has joined #gnucash
10:18:12 <david> to the 1st ... no KVP table, just accounts, billterms, books, budget_amounts, budgets, commodities, customers, employees, entries, invoices, jobs, lots, orders, prices, recurrences, shedxactions, slots, splits, taxtable_entries, taxtables, transactions, vendors, versions ... but no KVP
10:19:29 *** Slurpee has joined #gnucash
10:22:45 *** kpreid has quit IRC
10:23:22 *** Askarii has quit IRC
10:30:16 <jsled> david: "slots" is what you're after, then, I believe.
10:35:18 <david> KVP are in SLOTS table
10:35:38 <david> yes, thank you
10:38:25 *** raleightile has joined #gnucash
10:38:31 <david> great, jsled, thanks
10:38:31 *** raleightile has left #gnucash
10:38:41 <jsled> you're welcome
10:39:15 *** raleightile has joined #gnucash
10:39:22 *** bp0 has joined #gnucash
10:40:20 <raleightile> anybody want to guess at how much it would cost to implement an invoice or bill copy function, where you could open an existing posted item
10:40:28 <jsled> cost?
10:40:33 <raleightile> and right click, "make new copy"
10:40:46 <raleightile> pay to have the feature developed
10:41:47 *** bp0 has quit IRC
10:41:50 <raleightile> jsled: can you help me word it better?
10:42:04 <jsled> not really, I don't know the business features at all.
10:42:32 <jsled> People have tried bounty-based feature enhancement requests on the mailing lists before a small handful of times; I don't think they've got any traction.
10:42:42 <raleightile> i figured
10:43:03 <raleightile> is it because the $$ is too small
10:43:07 <jsled> I'm not sure its feasible for the current state of gnucash development momentum, but I haven't been following the project very closely for the last couple of years.
10:43:18 <jsled> in part, and usually, yes.
10:44:09 <raleightile> how much do most of these guys make? $300/hr?
10:48:54 *** markjenkinsparit has joined #gnucash
10:53:52 *** kpreid has joined #gnucash
11:31:47 *** kpreid has quit IRC
11:41:29 *** markjenkinsparit has quit IRC
11:52:51 *** markjenkinsparit has joined #gnucash
12:01:10 *** raleightile has left #gnucash
12:19:32 *** david has left #gnucash
12:29:26 *** kpreid has joined #gnucash
12:49:11 *** kpreid has quit IRC
12:49:43 *** kpreid has joined #gnucash
13:22:44 *** ErKa has quit IRC
14:18:54 *** cortana has joined #gnucash
14:59:51 *** cortana has quit IRC
15:07:57 *** cortana has joined #gnucash
15:09:58 *** bp0 has joined #gnucash
15:20:48 *** cortana has quit IRC
15:21:38 *** Askarii has joined #gnucash
15:22:52 *** sjc has joined #gnucash
15:23:03 *** bp0 has quit IRC
15:27:14 *** cortana has joined #gnucash
15:53:23 *** cortana has quit IRC
15:55:03 *** andyt has joined #gnucash
15:59:47 *** cortana has joined #gnucash
16:26:36 *** ErKa has joined #gnucash
16:36:05 *** KaiForce has quit IRC
16:37:38 *** sjc has quit IRC
16:44:33 *** cortana has quit IRC
16:44:44 *** sjc has joined #gnucash
16:44:48 *** monkee has joined #gnucash
16:46:21 *** Reese1872 has joined #gnucash
16:53:49 *** cortana has joined #gnucash
17:02:51 *** Slurpee has quit IRC
17:09:17 *** Askarii has quit IRC
17:11:27 *** dkorzhevin has quit IRC
17:19:33 *** Askarii has joined #gnucash
17:37:21 *** Jimraehl1 has quit IRC
17:45:42 *** ErKa has quit IRC
17:48:21 *** Slurpee has joined #gnucash
18:00:46 *** Askarii has quit IRC
18:06:28 *** cortana has quit IRC
18:07:16 *** Askarii has joined #gnucash
18:17:45 *** cortana has joined #gnucash
18:17:56 *** andyt has quit IRC
18:44:06 *** Askarii has quit IRC
18:51:03 *** bentob0x has quit IRC
19:10:49 *** cortana has quit IRC
20:17:31 *** markjenkinsparit has left #gnucash
20:19:27 *** Askarii has joined #gnucash
20:29:14 *** sjc has quit IRC
20:34:40 *** Jimraehl1 has joined #gnucash
20:45:08 *** Jimraehl1 has left #gnucash
20:46:44 *** Jimraehl1 has joined #gnucash
21:25:43 *** kpreid has quit IRC
21:27:45 *** Jimraehl1 has left #gnucash
21:29:05 *** Jimraehl1 has joined #gnucash
22:14:34 *** Krumar has joined #gnucash
22:46:44 *** kpreid has joined #gnucash
22:58:04 *** Sparxz has quit IRC
23:23:35 *** kpreid_ has joined #gnucash
23:23:36 *** kpreid has quit IRC
23:23:38 *** kpreid_ is now known as kpreid
23:47:56 *** Krumar has quit IRC
23:57:37 *** fbond has left #gnucash
23:58:17 *** fbond has joined #gnucash