2010-09-16 GnuCash IRC logs

00:01:10 <scar> should i just grab the libgoffice-0-dev package from 9.10 and install that in 10.04?
00:04:56 <scar> no that doesn't work... too many unresolved dependencies
01:26:28 *** esperegu has joined #gnucash
04:26:06 *** bp0 has quit IRC
04:43:33 *** HerrK has joined #gnucash
05:34:59 *** fell has joined #gnucash
07:22:12 *** warlord-afk is now known as warlord
07:22:42 <warlord> scar: try apt-get build-dep gnucash ; apt-get source gnucash and start from their 2.2.9 sources?
07:52:37 *** Jimraehl has left #gnucash
07:56:03 <fell> warlord, thinking about https://bugzilla.gnome.org/show_bug.cgi?id=118391, I reworked http://wiki.gnucash.org/wiki/Dependencies .
07:56:41 <fell> Should I rework README.dependencies in the same kind?
07:58:25 <fell> And are build dependencies or run deps. meant?
07:58:31 *** Jimraehl has joined #gnucash
08:01:21 <warlord> I think we tend to talk about build deps, not run deps.
08:03:40 <fell> But I think, there should also be a place, where we inform the package maintainer about suggested runtime deps like isocodes.
08:07:02 *** Rajish has joined #gnucash
08:07:43 <Rajish> is OFX worth investing time in?
08:08:57 <Rajish> I'm asking because I'm creating XSLT to convert account history from my bank into OFX and a few things seem lacking in the standard
08:14:38 <warlord> Rajish: That's up to you. Personally if the bank doesn't provide persistent unique transaction Ids then you're probably better off using QIF
08:15:49 <Rajish> they do
08:16:42 <Rajish> but some transactions like cash withdraw or payment with debit card has no other side account
08:17:31 <Rajish> I started to parse such cases to create dummy accounts that can be assigned to my accounts when importing into gnucash
08:18:04 <Rajish> I'm not sure if the tag ACCTTYPE is relevant when importing
08:18:50 <warlord> Rajish: you dont need to; just put the payee info and the import will map that to the appropriate account.
08:18:50 <Rajish> it has only four values: CHECKING, SAVINGS, MONEYMARKET, and CREDITLINE in the spec
08:21:57 <Rajish> warlord: you mean MEMO field?
08:22:11 <warlord> sure
08:22:23 <warlord> I think it'll use all of those various fields.
08:22:48 <Rajish> I think not
08:23:20 <Rajish> when I tried that there were a lot of imbalance entries
08:26:32 <warlord> Rajish: that's because you didn't map the accounts during the import.
08:27:56 <Rajish> the problem is the entries didn't have other side accounts
08:30:21 <warlord> That's because you didn't ASSIGN the other side account IN THE IMPORTER
08:30:29 <warlord> It requires some manual effort.
08:34:12 <Rajish> just to be clear: by ASSIGN you mean the 'select account' dialogue that pops up when a new other side account appears in OFX file?
08:35:15 <warlord> No.
08:35:35 <warlord> But ASSIGN I mean, in the transaction matcher dialog you actually go in and assign the other account manually.
08:35:44 <warlord> s/But/By
08:36:36 <Rajish> sed: -e expression #1, char 8: unterminated `s' command
08:36:40 <Rajish> :)
08:40:20 <warlord> :-P
08:42:14 <Rajish> OK. I've tried it
08:46:39 <Rajish> this is strange because:
08:46:39 <Rajish> 1. I've introduced dummy accounts in the OFX and importer asked me to assign them to my account plan but the transactions got UNBALANCED status even if I did
08:46:39 <Rajish> 2. The transactions already exist in my gnucash file but when I select the target account they are marked as new or they become red with 'Match missing!' note
08:50:26 <warlord> I dont use any importers myself so... you've kinda reached the limit of my practical knowledge there
08:51:03 <Rajish> ok. thanks anyway
08:51:40 <Rajish> seems like a few bug reports' gonna appear
08:54:44 *** bentob0x has joined #gnucash
09:09:12 *** Slurpee has quit IRC
09:25:31 *** Slurpee has joined #gnucash
09:38:46 *** oowf has joined #gnucash
09:39:45 <oowf> Hello... Newbie to gnucash and it is really working for us except that I can't get it to accept input in Chinese. Mac OS 6 Snow Leopard Really could use some help
09:40:09 <oowf> We need to system to be in English but be able to input English and Chinese comments and item description
09:41:41 <warlord> oowf: using the OSX dmg?
09:42:47 <oowf> We chose gnucash as an alternative to MS Money. We are fazing out all the PCs and MS Money was the last thing to convert over to Mac. in gnucash I could import the old money files, use Chinese RMB/CNY and according to what I read, input in Chinese characters.
09:43:09 <oowf> So far I have read a whole lot. It still seems it should work but for some reason it won't.
09:43:32 <oowf> Yes I did use the OSX dmg.
09:44:01 <warlord> I'm not 100% sure about OSX. The Mac guy (JRalls) doesn't hang out here much; you should try asking on the gnucash-user mailing list
09:44:38 <oowf> Thank You.. don't mean to be dumb but what or how to I access that?
09:45:12 <oowf> Is that an email function?
09:45:15 <jsled> https://lists.gnucash.org/mailman/listinfo
09:45:36 <oowf> Thank You. I'm looking now.
09:49:22 <warlord> yes, "mailing list" is "email function"
10:03:29 *** bentob0x has quit IRC
10:05:09 *** blizgerg has quit IRC
10:05:49 *** bentob0x has joined #gnucash
10:17:57 <warlord> oowf: Nathan, I presume? You sent mail to mailman-owner, not to "gnucash-user"
10:19:09 <warlord> You need to subscribe and send a message to the gnucash-user mailing list.
10:19:13 <warlord> Not to "mailman"
10:24:20 *** mishehu has quit IRC
10:27:29 *** fbond has joined #gnucash
10:48:14 *** Slurpee has quit IRC
10:48:47 <Mer|in> so gnucash says i have $10,000.00 in my account - my bank says i have $20.00. is there a way for gnucash to correct my bank account for me?
10:53:44 <warlord> LOL. When you reconcile GnuCash should be able to point out the missing 9,980.00 in transactions that didn't get posted .
10:54:15 <Mer|in> k
10:58:15 *** bp0 has joined #gnucash
11:10:35 *** seyfi has joined #gnucash
11:10:55 <seyfi> is this info current? http://wiki.gnucash.org/wiki/AccountHierarchyTemplate
11:11:03 <seyfi> especially the bash script there?
11:16:30 *** markjenkinsparit has joined #gnucash
11:23:00 <warlord> seyfi: the page looks up to date; I cannot comment on the correctness of the shell script.
11:32:35 *** Rajish has quit IRC
11:44:11 <fell> seyfi: what is your LANG?
11:44:32 <seyfi> fell: turkish
11:44:59 <seyfi> existing accounts are in 8859-9, I wonder if I should convert them to utf-8
11:45:10 <warlord> Yes, you probably should.
11:45:19 <fell> So you has to adjust a few strings in the script.
11:46:05 <seyfi> one big account is also corrupted with html entities, instead of 8859-9 codes. GC does not render it correctly.
11:46:56 <seyfi> e.g. <act:name>108 D&#221;&#208;ER HAZIR DE&#208;.</act:name>
11:47:20 <fell> you can use recode for both cases.
11:50:15 <warlord> seyfi: yes, gnucash 2.2.x and 2.3.x expect UTF8, unless the XML states an encoding explicitly
11:53:38 <fell> recode 8859-9..UTF8 <filename>; recode HTML<version>..UTF8 <filename>
11:55:15 <seyfi> ok, thanks
11:57:03 <seyfi> I was thinking of iconv, but recode looks more comprehensive
12:23:17 *** seyfi has quit IRC
12:39:50 *** Linuturk has quit IRC
12:42:37 *** Linuturk has joined #gnucash
13:13:39 *** Slurpee has joined #gnucash
13:26:58 *** Slurpee has quit IRC
15:01:31 *** HerrK has quit IRC
15:19:11 *** yoga has joined #gnucash
15:25:31 *** Askarii has joined #gnucash
15:29:43 *** yoga has quit IRC
15:37:25 *** rpg has joined #gnucash
15:39:41 *** Slurpee has joined #gnucash
15:57:09 *** warlord is now known as warlord-afk
16:10:53 *** bp0 has quit IRC
16:26:50 *** Slurpee has quit IRC
16:27:32 *** Slurpee has joined #gnucash
16:29:22 *** c3l has joined #gnucash
16:33:46 <c3l> I added credit to my income:salary with transfer to assets bank by $x. shouldnt this increase my equity by $x? it doesnt.. I guess Im misunderstandint equity. after all the tutorial says "Net worth (equity) increases through
16:33:51 <c3l> income and decreases through expenses.
16:34:27 <jsled> Think of the Equity account as "Equity Adjustments"
16:34:41 <jsled> if you want to know your "instantaneous" Equity, you need to run a report.
16:36:40 <fell> or at the end of your financial year your run the close books tool, which moves your profit to equity.
16:37:10 <fell> or sustracts the loss!
16:37:20 <jsled> http://en.wikipedia.org/wiki/Balance_sheet
16:38:08 <c3l> something I dont have to care about then ;) thanks
16:42:18 <c3l> one other thing im wondering abount, is how reorganized accounts are handled. lets say I have some enteries in expenses:foo and expenses:bar, now I want to group them in expenses:foobar:{foo,bar}. what happens to transactions between those expenses and the assets thaty they are transferred from. is that 'link' updated too, with the new path?
16:43:28 <jsled> yeah. internally it's all guids.
16:43:45 <jsled> so you can rename and reparent accounts (within the constraints of account typing) at will
16:43:59 <jsled> unfortunately there's no batch transaction processing (with one exception)
16:44:34 <jsled> (the exception being when you delete an account, you have an option of moving all its transactions to the parent account)
16:45:09 <c3l> cool, I like this program even though I don't fully get it :)
16:45:21 <jsled> at least you're reading the tutorial. :)
16:45:35 <jsled> double entry takes some time to get used to, but it's powerful.
16:45:46 *** sjc has joined #gnucash
16:47:54 <c3l> I believe you, by time you learn that strange features and concepts isnt neseccarily evil even though they take some time to grasp ;) Well I guess Ill have some more questions in the future, so Ill see you. got to go now. thanks for the fast and precise help :)
16:48:10 <jsled> cheers
16:55:29 <fell> jsled: In moving by deleting you can select the target acccount. :-)
16:57:28 *** esperegu has quit IRC
17:21:53 *** rpg has quit IRC
17:39:34 *** bentob0x has quit IRC
17:48:55 *** rpg has joined #gnucash
17:58:53 *** blizgerg has joined #gnucash
18:05:35 *** markjenkinsparit has quit IRC
18:19:33 *** Askarii has quit IRC
18:20:29 *** Slurpee has quit IRC
18:46:59 *** bp0 has joined #gnucash
18:54:33 *** bp0 has quit IRC
19:04:24 *** bp0 has joined #gnucash
19:08:41 *** fbond has quit IRC
20:03:37 *** silly has joined #gnucash
20:08:36 <silly> Any idea on when the next stable release will be?
20:17:06 <fell> Que sera sera ...
20:17:53 <silly> Ah yes, I see. Whatever will be, will be.
20:19:42 <fell> But we have a plan - at least to improve a plan
20:19:51 <fell> http://wiki.gnucash.org/wiki/Release_Schedule
20:20:24 <silly> Oh goodness, somehow I missed page entirely. Thanks.
20:22:47 <silly> So, there is possibly going to be an RC this month? Maybe even a stable release?
20:24:15 <fell> I still see: Database lock still needed
20:24:50 <fell> and I don't know how the progress is - if there is any.
20:31:29 <silly> Sadness.
20:43:37 *** Jimraehl has left #gnucash
20:52:46 *** sjc has quit IRC
20:55:56 *** Jimraehl has joined #gnucash
20:59:26 <bp0> There should be a template for nonprofits that includes income accounts like donations, grants, fundraising, trust, etc....
21:01:51 <fell> The germans use SKR49, for others a patch is needed.
21:24:20 *** warlord-afk is now known as warlord
21:24:30 <warlord> bp0: Sounds great! I look forward to your donation of said set of accounts!
21:24:44 <bp0> heh
21:24:54 <fell> bp0: see http://wiki.gnucash.org/wiki/AccountHierarchyTemplate to create one.
21:24:59 <bp0> I did try to make one, but I got a little frustrated with it
21:25:51 <bp0> thanks, I'll look into it
21:31:44 <warlord> How did you get frustrated? Just use the standard tools in the program to create the set of accounts that you think should be there. Then you can File -> Export -> Export Accounts to a file and then modify it per the Wiki to create a template
21:32:57 <fell> Hm, I believe, Export would loose tax information.
21:33:47 <fell> So I would save it an remove any transaction, clients, ...
21:46:35 <warlord> Does the hierachy druid even import tax information?
21:48:21 <fell> Rolf put tax relation in SKR04 and some users got crashes, because the used a version, which was not compiled with enable-tax
21:53:54 <fell> I believe, the header [and footer] is rewritten and the rest copied, if it is valid xml.
21:55:42 *** bp0 has quit IRC
21:59:19 *** bp0 has joined #gnucash
22:02:13 *** bp0 has quit IRC
22:03:50 *** bp0 has joined #gnucash
22:10:40 <fell> BTW, shouldn't http://www.gnucash.org/XML/act etc. be accessible on th server? currently xmllint is failing to get the specs.
22:16:30 <fell> Hm, jsled made this RELAX NG Compact schema.
22:21:47 *** bp0 has quit IRC
22:22:56 *** bp0 has joined #gnucash
22:39:08 *** bp0 has quit IRC
22:43:29 *** bp0 has joined #gnucash
22:46:00 *** bp0 has quit IRC
22:50:01 *** bp0 has joined #gnucash
22:52:52 <warlord> there is no requirement that the URI be resolvable;
22:59:46 *** bp0 has quit IRC
23:00:58 *** bp0 has joined #gnucash
23:06:11 <fell> xmllint is complaining that.
23:09:44 <warlord> that doesn't surprise me; the gnucash datafile and example files probably dont pass xmllint.
23:09:57 <warlord> the URIs are in there to make libxml2 happy
23:10:11 <warlord> but there is no schema, no DTD, for gnucash files
23:10:17 <warlord> at least nothing normative
23:17:08 <fell> there is src/doc/xml with *.dtd. What is the meaning?
23:18:03 <fell> and *.rnc
23:22:05 <jsled> non-normatic
23:22:08 <jsled> non-normative.
23:22:11 <jsled> descriptive
23:24:33 <fell> Hah, there are syntax errors in skr49. It seems, we didn't run xmllint before uploading.
23:24:48 <fell> Sorry for the noise.
23:25:36 <fell> xmllint on SKR04 runs without errors.
23:36:52 <warlord> okay.
23:36:55 <warlord> anyways, good night all
23:36:57 *** warlord is now known as warlord-afk
23:38:57 <fell> @tell seyfi xmllint told me to fix 2 lines in the script. Done.
23:38:57 <gncbot> fell: The operation succeeded.
23:41:07 *** CQ_ has joined #gnucash
23:48:53 *** CQ has quit IRC
23:55:31 <fell> good night
23:55:46 *** fell has quit IRC