2007-12-06 GnuCash IRC logs
02:46:18 *** andrewsw is now known as andrewsw-afk
02:53:50 *** Zoolooc__ has quit IRC
03:38:10 *** warlord has joined #gnucash
03:48:59 *** ErKa has joined #gnucash
04:28:22 *** kielein has joined #gnucash
04:35:03 *** conrad sets mode: +o warlord
04:35:07 *** conrad sets mode: +o gncbot
04:41:43 *** andi5 has joined #gnucash
05:18:54 *** pdc__ has quit IRC
05:21:35 *** pdc__ has joined #gnucash
06:18:56 *** cortilap has joined #gnucash
06:23:03 *** boana has joined #gnucash
06:24:56 <boana> Hello, hope I am doing this right?
06:26:11 <boana> bye
06:26:14 *** boana has left #gnucash
06:27:00 *** nin has joined #gnucash
06:45:47 *** nin has quit IRC
07:23:38 *** twunder has joined #gnucash
07:25:47 *** Def has quit IRC
07:42:41 *** twunder has quit IRC
07:51:52 *** Def has joined #gnucash
08:37:14 *** twunder has joined #gnucash
09:34:40 *** IanL has joined #gnucash
09:47:09 <IanL> I'm kind of curious. Why are saved reports saved to a separate file rather than the main file?
09:47:28 <jsled> because they exist independent of all data files. :)
09:47:45 <jsled> They're basically a new report... at the application instance, rather than the datafile.
09:48:03 <jsled> If you save a "my preferred expense report", one could imagine wanting to use it with different datasets.
09:48:30 <jsled> Though it's unlikely, true.
09:48:31 <IanL> right but generally you select a set of accounts which might change by data file,
09:48:40 <IanL> or you could
09:48:47 <jsled> That's a good point.
09:49:14 <IanL> I do that so my saved reports would not really give me what I want if i had another datafile.
09:49:17 <jsled> I'd like to see us having a single, self-contained datafile instead of the 3-4 we have now (independent of gconf)
09:50:31 <IanL> single self contained datafile meaning what is currently xml file?
09:50:42 <IanL> currently the*
09:51:26 <jsled> Right. So, the other files are the saved reports and the window-state (open pages, open reports).
09:51:41 <jsled> There's also the ~/.gnucash/config files, but those are basically irrelevant.
09:52:50 <jsled> I mean, when you save a spreadsheet, the list of open worksheets isn't saved off into some magical place.
09:53:05 <IanL> ah, right.
09:53:09 <IanL> I know what you mean.
09:53:16 <jsled> Especially since, if you rename your datafile, we lose it.
09:53:27 <jsled> And if there are customized opened reports, they're now gone.
09:54:01 <IanL> which makes me remember. saving a custom multicolumn report doesn't work but closing gnucash and reopening it with a multicolumn report open works.
09:54:31 * IanL nods
10:04:24 <IanL> Though we shouldn't go overboard. MS Word saves the currently selected printer to a word file.
10:04:51 <IanL> You open up a document and print it and then close and it asks you if you want to save the changes.
10:05:05 <IanL> Couldn't say how many times I've thought "huh?"
10:06:49 <IanL> anyway, bedtime. Thanks jsled.
10:07:05 *** IanL has left #gnucash
10:07:08 <jsled> IanL: take...
10:15:58 *** warlord has quit IRC
10:33:12 *** warlord has joined #gnucash
10:33:13 *** gncbot sets mode: +o warlord
11:12:02 *** warlord has quit IRC
11:22:33 *** warlord has joined #gnucash
11:22:34 *** gncbot sets mode: +o warlord
11:38:40 *** ErKa has quit IRC
11:40:37 *** tjanssen has joined #gnucash
12:17:37 *** tjanssen has quit IRC
12:22:23 *** warlord has quit IRC
12:22:31 *** warlord has joined #gnucash
12:22:32 *** gncbot sets mode: +o warlord
12:24:59 <jsled> http://code.google.com/apis/chart/
12:25:13 <jsled> I wonder... :)
12:32:52 <warlord> If we could use it in lieu of GoG? ;)
12:40:21 *** andrewsw-afk is now known as andrewsw
12:40:47 <andrewsw> shudder... I don't want to give google my financial info in exchange for a pretty chart...
12:41:31 <jsled> Well, it'd just be a sequence of numbers, with labels. But I take your point.
12:42:43 <andrewsw> although as I read down, send a url, get a png image. kinda cool.
12:43:43 <andrewsw> it would suck to have to fire up the modem to run charts though.
12:44:05 <jsled> What is this "mo-dem" of which you speak? :)
12:44:26 <andrewsw> heh heh
12:44:44 <andrewsw> I just plug the copper right into my head, but that's just me.
12:45:21 *** cortilap has quit IRC
12:48:57 *** andi5 has quit IRC
12:53:11 *** choji has joined #gnucash
12:56:26 <choji> hello, is it possible to join 2 separate gnucash files to one? if it is, how?
12:56:46 <jsled> not as such.
12:57:00 <jsled> your best bet is probably to use gnucash-to-qif on one, then QIF-import it into the other.
12:59:02 <choji> ok, but where is the function gnucash-to-qif? i found the qif-import but no qif export?
12:59:24 <jsled> no, there is no qif export. http://gnucashtoqif.sourceforge.net/
13:01:04 <choji> nice... thx, thats it
13:02:05 *** choji has left #gnucash
13:24:26 *** Zoolooc has joined #gnucash
13:28:21 *** warlord2 has joined #gnucash
13:28:26 <andrewsw> guys, are there any overflow conditions in gnc-numerics?
13:28:49 <warlord2> yes
13:29:04 <andrewsw> I'm looking at SegundoBob's test file and there are some calcs that result in gnc-numerics looking like:
13:29:23 <andrewsw> num: 1116267059289220 denom: 99636640910371
13:29:49 <andrewsw> the next time we see it it's num: -1 denom: 0
13:30:06 <andrewsw> (after trying to compute something on that numeric.)
13:31:53 <warlord2> Right, that's an error condition.
13:32:17 <warlord2> Probably overflow.
13:33:16 <andrewsw> I think I probably need to put some rounding in there. It shows up when averaging. He's got 14 years of monthly dividends and the numbers (currently unrounded) just get crazier and crazier.
13:33:39 <andrewsw> any insight into what a reasonable rounding point would be for commodity prices?
13:37:23 *** warlord has quit IRC
13:50:17 *** warlord2 is now known as warlord
13:50:18 <warlord> @op
13:50:18 *** gncbot sets mode: +o warlord
13:50:20 <warlord> umm..
13:50:30 <warlord> Probably depends on the commodity.
13:50:42 <warlord> I suppose you could round based on the commodity SCU
13:58:03 *** guillaume_ has joined #gnucash
13:58:22 <guillaume_> hello !
13:59:35 <guillaume_> i'm a new user and I have a great question
13:59:37 <guillaume_> lol
14:00:23 <jsled> guillaume_: http://wiki.gnucash.org/wiki/FAQ#Q:_I_want_to_use_GnuCash_in_my_own_language_.28Debian_users_may_need_it.29
14:01:18 <guillaume_> lol
14:01:38 <warlord> heh
14:02:00 <guillaume_> changing the env
14:02:03 <guillaume_> to english
14:02:16 <guillaume_> my os is french but the docs is english
14:03:27 <warlord> yes, the docs aren't translated.
14:03:28 <guillaume_> please help me with this, setting the Language variable to english
14:03:39 *** palatin has joined #gnucash
14:04:07 <jsled> guillaume_: did you read the link?
14:04:44 <warlord> The docs will only be in English; we don't have documentation translations. Only the application itself is translated.
14:05:03 <guillaume_> yes i've read the link
14:05:10 <guillaume_> I dont realy understand
14:05:17 <guillaume_> will it change all the os lang^
14:05:40 <jsled> It will change the language for the instance of gnucash.
14:05:48 <jsled> It will not change the whole OS.
14:06:23 <guillaume_> so it would look like "gnucash env LANGUAGE=en_EN"
14:06:30 <warlord> No.
14:06:38 <warlord> env LANGUAGE=en_EN gnucash
14:06:46 <guillaume_> oo
14:07:37 <guillaume_> thanks
14:10:08 <warlord> Although... What's en_EN?
14:10:21 <warlord> (not sure what country-code EN is)
14:10:41 <jsled> yeah... use en_US.
14:10:53 <guillaume_> ok
14:11:04 <guillaume_> the account name will stay the same
14:11:08 <warlord> Yes.
14:11:21 <warlord> But also note that this will change your default currency to USD, which might not be what you want.
14:11:28 <guillaume_> anyway it's better to understand the software
14:11:43 <guillaume_> currency too!
14:11:46 <guillaume_> mmm
14:13:02 <warlord> See the FAQ
14:13:25 <guillaume_> it looks like I still have CAD
14:13:52 <guillaume_> I just wanted to put to english a litle so I can understant the FAQ.. LOL
14:14:07 <jsled> guillaume_: Is the app in english, now?
14:14:14 <guillaume_> yes sir
14:14:20 <jsled> Oh, great. :)
14:14:23 <warlord> good
14:14:24 <warlord> enjoy
14:14:31 <guillaume_> but I have canadien $..
14:14:51 <guillaume_> so I'll stay like that to learn and then switch back to french
14:15:33 <warlord> If you have CAD you might try en_CA
14:15:39 <warlord> (instead of en_US)
14:15:45 <guillaume_> oo
14:16:11 <guillaume_> so the first is the language and the second the country?!
14:16:32 <warlord> effectively
14:16:59 <guillaume_> a lot's of nice feature
14:17:27 <guillaume_> I was in the VAR (value add reseller) business before and I was selling accouting solution ...
14:17:50 <guillaume_> more than 7000$ to match gnucash.. at least!
14:18:24 <guillaume_> can wait to use it at full capacity
14:18:29 <guillaume_> *can't
14:19:19 <warlord> :-D
14:23:09 *** roxy_ has joined #gnucash
14:24:17 *** kielein has quit IRC
14:29:14 <guillaume_> thanks to all
14:31:00 *** andyt has joined #gnucash
14:33:21 *** roxy_ has left #gnucash
14:38:33 *** warlord2 has joined #gnucash
14:38:40 *** warlord has quit IRC
14:45:51 *** warlord__ has joined #gnucash
14:48:23 *** warlord__ is now known as warlord
14:48:25 <warlord> @op
14:48:25 *** gncbot sets mode: +o warlord
14:51:22 *** warlord2 has quit IRC
15:38:21 <andrewsw> ooh... my new keyboard is here!
15:38:27 <andrewsw> clicky clicky
15:38:37 *** ErKa has joined #gnucash
15:39:04 *** guillaume_ has quit IRC
15:44:47 <warlord> congrats
15:48:49 *** tim_abell has joined #gnucash
15:52:38 <andrewsw> I wonder if I can hot-swap ps-2... you'll know soon.
15:52:56 <warlord> depends on the mobo
15:52:58 <jsled> it usually worked, ime.
15:53:10 <jsled> but ... a ps/2 keyboard? In 2007?
15:53:31 <jsled> It's almost 2008, man! PS/2 connectors and "mo-dems".?! ;)
15:53:56 <andrewsw> heh heh heh
15:54:01 <andrewsw> clicky click clicky!
15:54:31 <andrewsw> This keyboard was made in 1988... year I graduated highschool
15:56:55 <andrewsw> oh this amazing! There is no windows key (worth its price right there) so I have to fix all my keybindings... small price.
15:57:03 <andrewsw> is
16:02:48 *** warlord2 has joined #gnucash
16:03:10 <warlord2> Grr... Keep getting new addresses as I move around.
16:05:02 *** steve has joined #gnucash
16:06:39 <steve> I am having a problem getting the reports to sort the accounts in alpha order. I looked at preferences and options to see if I could control sorting...no luck. What am I missing here?
16:06:52 *** warlord has quit IRC
16:07:00 <andrewsw> warlord2: can you script gncbot to ping you more often that 600 seconds and kick you, just while you're at the conference?
16:07:24 <andrewsw> steve: this was discussed on -user recently. you're not missing anything.
16:07:29 *** warlord2 is now known as warlord
16:07:30 <warlord> @op
16:07:30 *** gncbot sets mode: +o warlord
16:07:52 <warlord> andrewsw: :-(
16:08:23 <andrewsw> I"m not sure what the consensus was but although some reports had sorting implemented internally, it may not be working at the moment.
16:08:27 <andrewsw> I think.
16:08:36 *** andi5 has joined #gnucash
16:08:36 *** gncbot sets mode: +o andi5
16:09:28 <steve> andrewsw: are you saying that it is a new problem that recently popped up or that it has always been a problem and not yet addressed?
16:10:13 <warlord> no, the problem is that some reports dont have sorting capabilities.
16:10:17 <warlord> steve: which report?
16:10:46 <andrewsw> steve: someone claimed some reports used to sort automagically and no longer did.
16:10:57 <steve> I haven't tried them all, but chart of accounts listing and the balance sheet.
16:11:01 <warlord> But I think that that user was just lucky.
16:11:14 <andrewsw> I suspect so as well.
16:12:26 <warlord> steve: yeah, those reports dont have sorting capabilities.
16:12:27 <warlord> sorry
16:12:36 <warlord> It's something that needs to get built into the report.
16:12:54 <andrewsw> it would make a lovely little RFE bug, IMO.
16:14:50 <steve> okay. what is the easiest way to export the accounts (with balances) into a csv or xls format?
16:15:27 <andrewsw> what do you mean by the accounts?
16:15:57 <andrewsw> their txn's and balances? just the names and balance?
16:16:25 <steve> well, I am thinking that if I use the account code feature for all accounts, then I can recreate any report that I need in a spreadsheet app.
16:17:01 <steve> just the names and balances
16:17:18 <steve> or rather code, name and balance
16:19:09 <warlord> Export the account report as an HTML Table and then import it into Excel
16:19:48 <andrewsw> or use html2test -nobs and some sed foo.
16:19:54 <andrewsw> html2text
16:20:34 <steve> okay, I was trying the export function with the account summary report on screen. that would work fine.
16:22:31 <steve> thanks for the help
16:22:54 *** steve has quit IRC
16:29:19 *** tjanssen has joined #gnucash
16:49:25 *** nomeata has joined #gnucash
16:57:21 *** palatin has quit IRC
17:01:50 *** tim_abell_ has joined #gnucash
17:05:45 *** andi5 has quit IRC
17:09:52 *** tim_abell has quit IRC
17:18:07 *** andrewsw is now known as andrewsw-afk
17:19:01 *** twunder has quit IRC
17:19:08 *** tim_abell_ has quit IRC
17:43:42 *** nomeata has quit IRC
17:45:16 *** boana has joined #gnucash
17:45:45 <boana> Any Ozzies here?
17:47:14 *** twunder has joined #gnucash
18:01:22 *** twunder has quit IRC
18:43:13 *** andyt has quit IRC
18:44:41 *** boana has left #gnucash
18:46:16 *** rhowe has quit IRC
19:20:31 *** warlord2 has joined #gnucash
19:22:21 *** warlord has quit IRC
19:35:13 *** ErKa has quit IRC
19:50:27 *** warlord2 has quit IRC
19:58:31 *** warlord has joined #gnucash
19:58:31 *** gncbot sets mode: +o warlord
20:16:13 *** twunder has joined #gnucash
20:17:50 *** rhowe has joined #gnucash
20:39:08 *** twunder has quit IRC
20:43:26 *** balaji has joined #gnucash
20:44:12 <balaji> hi
20:44:23 <balaji> anyone here
20:47:15 <jcreigh> don't ask to ask, just ask, and if you're patient, maybe someone who knows the answer will see it and respond.
20:55:52 <balaji> ok i installed ubuntu and gnucash i opened my old account which went finr
20:56:16 <balaji> i saved a transaction and cannot open my old account anymore
20:56:32 <balaji> its like 2 yrs of financial data
21:08:12 <warlord> Let me guess -- it says you can't parse it, and the data file is in ~/.gnucash/books/ right?
21:08:38 <warlord> http://wiki.gnucash.org/wiki/FAQ#Q:_Why_can.27t_GnuCash_find_my_data_file_anymore.3F__It_just_says:_parser_error_:_Start_tag_expected.2C_.27.3C.27_not_found
21:10:20 <balaji> this was a new install and i backedup only the main folder
21:11:17 <warlord> "main folder"?
21:11:41 <balaji> i had all accounts stored in ~home/xxx/GNUCash
21:11:52 <warlord> Oh?
21:12:03 <warlord> Hmm... What's printed on the terminal and in /tmp/gnucash.trace?
21:12:10 <warlord> (use pastebin if it's a lot of text)
21:13:02 *** tjanssen has quit IRC
21:15:06 <balaji> gnucash: /usr/lib/gnucash/libgnc-backend-postgres.so: cannot open shared object file: No such file or directory
21:15:06 <balaji> failed to load gnc-backend-postgres from /usr/lib/gnucash
21:15:06 <balaji> loading system configuration
21:15:06 <balaji> looking for /etc/gnucash/config
21:15:06 <balaji> trying to load /etc/gnucash/config
21:15:07 <balaji> loading user configuration
21:15:09 <balaji> looking for /home/balaji/.gnucash/config-2.0.user
21:15:11 <balaji> looking for /home/balaji/.gnucash/config-1.8.user
21:15:15 <balaji> looking for /home/balaji/.gnucash/config-1.6.user
21:15:15 <balaji> looking for /home/balaji/.gnucash/config.user
21:15:17 <balaji> loading auto configuration
21:15:19 <balaji> looking for /home/balaji/.gnucash/config-2.0.auto
21:15:21 <balaji> looking for /home/balaji/.gnucash/config-1.8.auto
21:15:25 <balaji> looking for /home/balaji/.gnucash/config-1.6.auto
21:15:27 <balaji> looking for /home/balaji/.gnucash/config.auto
21:15:29 <balaji> loading saved reports
21:15:31 <balaji> looking for /home/balaji/.gnucash/saved-reports-2.0
21:15:33 <balaji> looking for /home/balaji/.gnucash/saved-reports-1.8
21:15:36 <balaji> loading stylesheets
21:15:37 <warlord> balaji: STOP!
21:15:37 <balaji> looking for /home/balaji/.gnucash/stylesheets-2.0
21:15:39 <balaji> trying to load /home/balaji/.gnucash/stylesheets-2.0
21:15:41 <balaji> Error: dom_tree_handlers_all_gotten_p(): Not defined and it should be: act:type
21:15:43 <balaji> Error: dom_tree_generic_parse(): didn't find all of the expected tags in the input
21:15:46 <balaji> Error: dom_tree_to_account(): failed to parse account tree
21:15:47 <balaji> account_parent_handler: assertion `parent' failed
21:15:49 <balaji> account_parent_handler: assertion `parent' failed
21:15:51 <balaji> account_parent_handler: assertion `parent' failed
21:15:55 <balaji> account_parent_handler: assertion `parent' failed
21:15:57 <balaji> account_parent_handler: assertion `parent' failed
21:15:58 <warlord> balaji: STOP STOP STOP@!
21:15:59 <balaji> account_parent_handler: assertion `parent' failed
21:16:01 <balaji> oops
21:16:06 <warlord> PASTEBIN DAMMIT!
21:16:29 <balaji> ok ok sorry
21:16:30 <warlord> <warlord> (use pastebin if it's a lot of text)
21:17:58 <balaji> http://pastebin.com/d5e0447dc
21:19:22 <warlord> Ah, that bug.
21:20:09 <warlord> I dont recall if there's a fix for that one.
21:22:17 <warlord> This was discussed recently.
21:22:39 <warlord> I suggest looking on the list. Someone suggested a patch to bypass that check when loading the data file, but it's unclear why it gets broken.
21:29:20 *** balaji has quit IRC
22:05:38 *** twunder has joined #gnucash
22:15:49 <jsled> lol. "Google invents first API ever to generate CHARTS. Google to take over the world with this api." - http://programming.reddit.com/info/62cin/comments/
22:16:36 <warlord> heheh
22:16:49 *** benoitg has joined #gnucash
22:16:53 *** warlord has quit IRC
22:22:10 *** dbreiser has joined #gnucash
22:23:15 <dbreiser> my g_inline_whatever problems in Mac OS X 10.5 don't occur with trunk, only with the tarball
22:23:38 <dbreiser> Is that worth following up either on the list as a closing note, or bugzilla?
22:25:40 <jcreigh> dbreiser: if somebody else has the same problem and they stumble across the bug report or mailing list archive, they'd probably appreciate being able to see what worked for you.
22:28:09 *** twunder has quit IRC
22:37:34 *** twunder has joined #gnucash
22:44:13 *** warlord has joined #gnucash
22:44:15 *** gncbot sets mode: +o warlord
22:44:44 *** warlord is now known as warlord-afk
22:45:30 *** Zoolooc_ has joined #gnucash
22:53:29 <dbreiser> jcreigh: I did mention the fix in the thread already. Just wondering if it's worth trying to track down the trunk/tarball inconsistency on a 'fringe' distro
22:54:49 *** Zoolooc has quit IRC
23:43:45 *** twunder has quit IRC
23:43:51 *** benoitg has left #gnucash
23:46:37 *** twunder has joined #gnucash
23:48:40 *** twunder has quit IRC
23:49:44 *** dbreiser has quit IRC