2009-05-07 GnuCash IRC logs
00:28:18 *** cedayiv has joined #gnucash
00:45:28 *** iamawake has joined #gnucash
01:11:03 *** soa2ii has joined #gnucash
01:16:48 *** cedayiv has quit IRC
02:34:43 *** iamawake has quit IRC
02:34:43 *** Jimraehl has quit IRC
02:34:43 *** warlord-afk has quit IRC
02:34:44 *** iamawake1 has joined #gnucash
02:38:12 *** MechtiIde has joined #gnucash
03:20:19 *** bentob0x has joined #gnucash
03:22:42 *** palatin has joined #gnucash
03:26:10 *** ErKa has joined #gnucash
03:54:54 *** iamawake1 has left #gnucash
04:08:26 *** e2x1pose has joined #gnucash
04:08:30 <e2x1pose> hi
04:08:45 *** e2x1pose is now known as some_visitor
04:08:55 <some_visitor> how does gnucash save the hbci pin?
04:09:20 <some_visitor> not plaintext in a file named 'pin', right?
04:09:27 <some_visitor> :-)
04:11:01 *** iamawake has joined #gnucash
04:16:19 <some_visitor> how can i change the initial amount of money of an account after creating it?
04:40:49 *** chris has joined #gnucash
05:11:16 *** enriq has quit IRC
05:14:09 *** Rolf1 has joined #gnucash
05:17:55 *** eukreign has quit IRC
05:19:20 *** eukreign has joined #gnucash
05:22:15 *** Rolf2 has quit IRC
05:45:17 *** eukreign has quit IRC
05:53:51 *** some_visitor has quit IRC
06:38:29 *** MechtiIde has quit IRC
06:38:29 *** MechtiIde has joined #gnucash
06:43:04 *** Feisar has joined #gnucash
07:47:49 *** sum1 has joined #gnucash
07:48:38 *** sum1 has left #gnucash
07:49:37 *** sum1 has joined #gnucash
07:50:12 <sum1> Hi all
07:51:16 <sum1> Is anyone here able to help me with reports?
08:03:20 <sum1> OK, so I don't know if this working or not, or if I'm visible or not....:)
08:05:01 *** palatin has quit IRC
08:15:08 <sum1> Alright, I'm just going to put this out there, and maybe someone can guide me.
08:16:45 <sum1> I am regularly raise invoices from GnuCash, and due to the fact there are some changes I need to make, I export them and open in OpenOffice Word
08:17:57 <sum1> The formatting doesn't export well - I have a logo in GnuCash, which seems to muck everything up somewhat.
08:18:27 <sum1> What I really need to know is what report, or where I need to edit?
08:20:27 <sum1> There are several changes I need to make - for example, I need to make the invoice read "Tax Invoice"
08:20:34 *** sfalanga has quit IRC
08:30:34 *** eukreign has joined #gnucash
08:34:50 *** sum1 has left #gnucash
08:41:16 *** sum1 has joined #gnucash
08:43:39 *** sum1 has left #gnucash
09:10:50 *** JimRaehl2 has joined #gnucash
09:10:59 *** warlord-afk has joined #gnucash
09:14:07 *** warlord-afk is now known as warlord
09:14:08 <warlord> @op
09:14:08 *** gncbot sets mode: +o warlord
09:18:09 *** JimRaehl2 has left #gnucash
09:18:29 *** JimRaehl2 has joined #gnucash
09:44:47 *** kielein has joined #gnucash
09:55:49 *** warlord is now known as warlord-afk
10:24:02 *** soa2ii has quit IRC
10:38:13 *** JimRaehl2 has quit IRC
10:43:12 *** cedayiv has joined #gnucash
10:43:46 *** beginner has joined #gnucash
10:44:41 <beginner> SOS! May Day! When I open GnuCash, an error msg pops up:
10:45:19 <beginner> GnuCash could not obtain the lock for D:\gnucash data\data-gnucash.
10:45:33 <beginner> That database may be in use by another user, in which case you should not open the database. What would you like to do?
10:45:52 <beginner> What can I do to fix the error?
10:46:12 <jsled> Make sure no other instance of gnucash is running and say "open anyways" or whatever the option is.
10:46:54 <beginner> How do I make sure there is no other instance of gnucash running?
10:47:03 <beginner> I just started the computer.....
10:47:56 <jsled> then you can be pretty sure there isn't another one.
10:48:11 <jsled> It's likely that gnucash did not shut down cleanly last time, and left the lock file behind.
10:48:29 <jsled> either gnucash crashed on shutdown, or the machine crashed, or something.
10:52:26 <beginner> Yes, jsled, you are right. Yesterday I was struggling to figure out how to create an online banking account, and GC suddenly crashed. (I am running GC under Windows XP.)
10:53:05 <jsled> there you go. for reference, to check if another gnucash is running I'd use the task manager, or some sort of process listing tool.
10:54:07 *** beginner has left #gnucash
10:56:08 *** beginner has joined #gnucash
11:02:22 *** JimRaehl2 has joined #gnucash
11:04:30 *** john has joined #gnucash
11:06:10 <john> where is the info for custom checks stored (gnucash 2.x, linux)?
11:07:16 <john> that would be for custom check formats
11:24:55 *** warlord-afk is now known as warlord
11:28:05 <warlord> john: which 2.x, 2.0 or 2.2?
11:28:22 <warlord> (I'm not sure exactly where it gets saved)
11:32:46 <john> umm, I can't remember
11:33:08 <john> I've upgraded machines, but 've saved the old installation
11:33:24 <john> so I'm just trying to find the old settings
11:33:31 <warlord> Saved check formats didn't migrate from the old check subsystem to the new one.
11:33:57 <john> well, my previous version was relatively new
11:34:03 <john> probably the 2.2 series
11:36:02 <warlord> Did you reinstall the system, upgrade the system, or move to a new system?
11:36:20 <warlord> In the #1 and #3 cases you would need to copy your data file, ~/.gnucash, and ~/.gconf*
11:36:58 <john> I moved to a new system
11:37:31 <john> so I'll copy the files as you've suggested
11:37:37 <john> thanks!
11:39:38 <warlord> Make sure you shutdown gconf before copying the .gconf* files.
11:39:56 <john> I will
11:40:39 <warlord> Or just copy all of $HOME
11:43:01 <john> well, I copied everything except the .foo folders in my home directory
11:43:32 <john> it was a pretty old and hacked system
11:43:41 <john> so i wanted to start relatively fresh
11:44:24 <john> about the only thing I kept was the .mozilla profile
11:47:22 <warlord> ok.
11:55:25 *** ErKa has quit IRC
12:18:55 *** MechtiIde has quit IRC
12:39:43 *** ErKa has joined #gnucash
12:52:56 *** Rolf1 has quit IRC
12:52:58 *** Rolf1 has joined #gnucash
12:53:50 *** Rolf1 has quit IRC
12:53:51 *** Rolf2 has joined #gnucash
13:03:03 *** john has left #gnucash
13:03:38 <beginner> Can I set USA as default for accounts, instead of changing Germany to USA each and every time I create a new (online banking) account?
13:05:35 *** twunder has joined #gnucash
13:05:40 *** iamawake has quit IRC
13:06:48 <warlord> beginner: Set your locale to US?
13:09:55 *** twunder has quit IRC
13:13:07 *** MechtiIde has joined #gnucash
13:15:34 *** ErKa has quit IRC
13:29:43 *** andyt has joined #gnucash
13:30:34 <beginner> Warlord, thx for responding. I have looked under Preferences in GC (Windows XP 2.2.9 version), but see nowhere to specify location). My Windows XP "region" is, of course, set to USA.
13:31:07 <warlord> did you restart the system after setting XP to USA?
13:31:12 <warlord> Did you modify the gnucash.bat?
13:37:38 <beginner> My XP has always been set to USA, I never changed it. Re "gnucash.bat" - NO clue what it is or how I might have changed it.
13:39:29 <beginner> I just checked again. My XP region/languages is set to English (United States), and Time Zone under Date and Time is set to Central time (US & Canada).
13:39:39 <warlord> Does gnucash come up in English or German?
13:39:53 <beginner> English.
13:40:07 <beginner> (thank god! :-)
13:40:09 <warlord> Then it should default to US, unless you changed your PRefernces?
13:40:17 *** hvx has joined #gnucash
13:40:42 <beginner> GC Preferences? Where would that field be?
13:41:04 <beginner> I go to Edit-Preferences and see no field to define locale? I must be blind....
13:41:43 <warlord> not locale... but default currencies for various things.
13:42:51 <beginner> In Preferences-Reports, I have the default of Locale: USD.
13:43:59 <warlord> Check the Accounts tab
13:43:59 <beginner> Under Preferences-Date/Time, I have the default of Locale: 07/31/05.
13:44:37 <beginner> Default Currency: Locale USD (US Dollar)
13:45:27 <beginner> This was the default, I never changed any of the Preferences. Should I select "Choose: USD"?
13:46:38 <warlord> So... whats' the problem again?
13:47:14 <warlord> What do you mean by creating a "new online banking account"?
13:47:23 <beginner> When I create an online banking user/account, the default is always Germany for location instead of USA.
13:47:47 <warlord> What do you mean by "online banking user/account"?
13:47:52 *** hvx has quit IRC
13:48:47 <beginner> XP-GC-Tools-Online Banking Setup
13:49:07 <beginner> Did I answer your question, Warlord?
13:49:42 <warlord> Oh, that's an AqBanking thing. I have no idea anything about htat.
13:49:49 <warlord> Are you selecting HBCI or OFX?
13:51:42 <beginner> OFX, though NO clue what each does exactly, but OFX seemed right and I think I have made it work by now.
13:52:18 *** palatin has joined #gnucash
13:52:26 <warlord> Sorry, I cant help you.
13:52:35 <warlord> Try asking on the gnucash-user mailing list?
13:53:17 *** iamawake has joined #gnucash
13:56:09 *** ErKa has joined #gnucash
13:56:27 <beginner> OK. Understand. Thanks anyway.
14:12:47 *** bentob0x has quit IRC
14:53:45 *** palatin has quit IRC
14:58:17 <beginner> Dear GC experts, I need your help with "Online Banking".
14:58:28 <beginner> I have Windows XP with SP3.
14:58:38 <beginner> GC version 2.2.9.
14:59:06 <beginner> After hours of trying, I got the OFX backend to work to the point of retrieving accounts.
14:59:36 <beginner> Then I associated the retrieved accounts with GC Accounts.
15:00:49 <beginner> Then Actions-Online Actions-Get Transactions or Get Balance.
15:01:45 <beginner> Whether I pick From Earliest Date or today's date, to today's date, I get the same error msg:
15:02:06 *** ErKa has quit IRC
15:02:39 <beginner> "Error executing backend's queue. What shall we do?" with Continue and Abort buttons. Clicking Continue is same as clicking Abort.
15:02:50 <beginner> What am I doing wrong?
15:03:52 <beginner> The Online Banking Connection Window shows the following:
15:04:12 <beginner> Current Job <Executing Jobs>
15:05:02 <beginner> Current Action <Now the jobs are send via their backend to the credit institutes.
15:05:06 *** sfalanga has joined #gnucash
15:05:16 *** ErKa has joined #gnucash
15:05:21 <beginner> Progress <green bar to the end>
15:05:25 <beginner> Log Messages:
15:05:34 <beginner> Resolving hostname "....
15:05:42 <beginner> IP address is .....
15:05:49 <beginner> Creating HTTPS connection
15:05:53 <beginner> Connecting....
15:05:58 <beginner> Sending request...
15:06:03 <beginner> Waiting for response...
15:06:12 <beginner> Parsing response...
15:06:18 <beginner> Disconnecting...
15:06:25 <beginner> Parsing response
15:06:27 *** sfalanga has quit IRC
15:06:47 <beginner> <the process ends abruptly>
15:14:09 <warlord> beginner: sounds like an AqB issue.
15:21:50 <beginner> Warlord, thanks for the tip. How/where can I get help?
15:22:23 <warlord> As I said earlier, try the gnucash-user mailing list.. Or they may point you to the AqB list.
15:24:14 <beginner> OK. Thanks again, warlord!
15:25:22 *** Zoolooc_ has joined #gnucash
15:40:16 *** murphy_slaw has joined #gnucash
15:40:30 *** Zoolooc__ has joined #gnucash
15:42:08 <murphy_slaw> Anyone else here running the gnucash quartz build on OS X 10.5? It works fine - except the selection, copy, and paste don't work in the register.
15:44:41 <warlord> murphy_slaw: if you dont get an answer here you should ask on the gnucash-user mailing list.
15:45:07 <murphy_slaw> Will do, thought I would try instant gratification first.
15:45:59 <warlord> yep
15:46:01 *** beginner has left #gnucash
15:48:43 *** Zoolooc_ has quit IRC
15:49:36 *** Zoolooc has joined #gnucash
15:52:47 *** Zoolooc__ has quit IRC
15:54:41 *** owen has joined #gnucash
16:01:17 *** owen has left #gnucash
16:02:26 *** Zoolooc_ has joined #gnucash
16:10:01 *** Zoolooc__ has joined #gnucash
16:11:02 *** Zoolooc has quit IRC
16:17:25 *** Zoolooc_ has quit IRC
16:19:36 *** Zoolooc_ has joined #gnucash
16:21:21 *** murphy_slaw has left #gnucash
16:23:12 *** Zoolooc__ has quit IRC
16:23:12 *** chris has quit IRC
16:24:17 *** cedayiv has quit IRC
16:24:52 *** Zoolooc__ has joined #gnucash
16:25:18 *** chris has joined #gnucash
16:31:13 *** owen has joined #gnucash
16:32:21 *** Zoolooc_ has quit IRC
16:35:26 *** Zoolooc__ has quit IRC
16:40:13 *** ErKa has quit IRC
16:50:19 *** MechtiIde has quit IRC
17:00:09 *** MechtiIde has joined #gnucash
17:12:46 *** twunder has joined #gnucash
17:16:27 *** twunder has quit IRC
17:18:32 *** kielein has quit IRC
17:41:56 *** todd has quit IRC
17:42:37 *** Rolf2 has quit IRC
17:49:35 *** twunder has joined #gnucash
17:52:51 *** andyt has quit IRC
18:03:19 *** todd has joined #gnucash
18:08:09 *** localhost has quit IRC
18:15:46 *** nomeata has joined #gnucash
18:31:14 *** Zoolooc has joined #gnucash
18:31:33 *** twunder has joined #gnucash
18:34:26 *** twunder has quit IRC
18:35:23 *** Zoolooc_ has joined #gnucash
18:40:08 *** Zoolooc__ has joined #gnucash
18:42:07 *** Zoolooc has quit IRC
18:47:32 *** warlord is now known as warlord-afk
18:47:49 *** Zoolooc_ has quit IRC
19:23:31 *** cedayiv has joined #gnucash
19:34:47 *** nomeata has quit IRC
19:49:44 *** Feisar has quit IRC
20:16:18 *** owen has left #gnucash
20:23:10 *** JimRaehl2 has left #gnucash
20:23:32 *** Jimraehl has joined #gnucash
20:25:49 *** twunder has joined #gnucash
20:35:58 *** twunder has quit IRC
20:59:52 *** cedayiv has quit IRC
21:02:20 *** Bob has joined #gnucash
21:02:27 <Bob> hi there!
21:03:16 <Bob> I am currently looking online for an accounting program tailored to fit agricultural businesses, but, not surprisingly, I cannot find anything....
21:04:22 <Bob> I was wondering, would it be feasible (and easy) to program some kind of add-on module that would be a pre-made account hierarchy that suits the needs of agricultural business. I know nothing of programming myself.
21:04:55 <jsled> fesible, yes. easy, no.
21:05:03 <jsled> feasible, even.
21:05:38 <jsled> It's always feasible, though. Everything is possible. But programming is hard.
21:06:14 <Bob> Also, I thought it would be neat to have some feature that lets you track amounts of items bought and sold, in order, ,for example, to establish production cost per unit produced, etc. Anyone knows of some decent existing program that I could use for these kind of purposes?
21:07:20 <Bob> jsled: do you think this idea of an account hierarchy suited for agricultural business does at least make some sense?
21:08:23 <Bob> does everything Gnucash have to be programmed in C?
21:14:22 <jsled> Bob: gnucash can ship pre-defined account hierearchies like the ones you see in the first time setup.
21:14:54 <jsled> If there's one that works with the existing product that generally makes sense for Ag business, please contribute it! :)
21:15:17 <jsled> Gnucash is like 90% C, with specific parts in Scheme.
21:15:20 <jsled> (the reports, mostly)
21:15:47 <Bob> OK....in other words, are you saying that I could myself make an "empty" account hierarchy that makes sense, and then distribute it?
21:16:18 <jsled> the "example account hierarchy" format is a bit different from the normal datafile, but generally: yes. :)
21:16:31 <Bob> that's cool!
21:16:48 <jsled> If you created an empty datafile that had the appropriate account hierarchy, you should post it ot the gnucash-user or gnucash-devel list
21:17:18 <jsled> If you're up for it, look at the example account hierarchy files, and massage the data-file XML into that format; it's like 95% the same.
21:18:28 <jsled> here, the example account hierarchy files are installed into /usr/share/gnucash/accounts/ e.g. /usr/share/gnucash/accounts/C/acctchrt_common.gnucash-xea
21:19:24 <Bob> mmmm.....like I said I no nothing of programming....I guess I asked the question about "C" to sound smart :) All I did is some quickbasic programming in high school....I was Ok at it, but that a long time ago ! I do like the little challenge though
21:23:28 <jsled> well, don't worry about programming … creating a domain-specific account hierarchy is productive work, too.
21:24:09 <jsled> There are plenty of ways to contribute that aren't programming.
21:24:32 <Bob> I guess you still have to hold my hand a little here....how would I go from my empty datafile to an XML file? (does my question even make sense)??
21:25:05 <jsled> Your empty datafile is an xml file (though it might be trivially compressed into a binary file).
21:25:16 <Bob> Ah :)
21:25:35 <jsled> There are differences between the "datafile xml" and the "example account hierarchy xml", but they're small.
21:25:56 <jsled> I'd suggest opening both in your favorite text editor, and looking for the differences/commonalities.
21:28:18 <Bob> I guess an easy way to do this comparison would be to save the simplest "example account hierarchy" available into an empty data file, and look at the differences....?
21:31:02 <Bob> I guess that would be a major difference <gnc-account-example>
21:31:02 <Bob> <gnc-act:title>
21:31:02 <Bob> A Simple Checkbook
21:31:02 <Bob> </gnc-act:title>
21:31:02 <Bob> <gnc-act:short-description>
21:31:03 <Bob> The minimal set of accounts to use GnuCash.
21:31:07 <Bob> </gnc-act:short-description>
21:31:09 <Bob> <gnc-act:long-description>
21:31:11 <Bob> Use this if you just want to balance your checkbook. Later on, you can start tracking income and expenses in more detail if you feel the need.
21:31:14 <Bob> </gnc-act:long-description>
21:31:24 <jsled> yeah, that's a really good way to do it, actually
21:31:37 <jsled> (*ahem* http://pastebin.ca/ *ahem* :)
21:32:09 <jsled> that feels like most of the major change, apart from the top-level element.
21:34:01 <Bob> say I am done tweeking around my empty file into an "example account hierarchy xml", do I only need to paste it in the /usr/share/gnucash/accounts/C/ folder for it to appear in the examples...somehow I feel like this would be too easy....?
21:35:15 <jsled> if you get it into the correct format and add it to that dir, then it should show up in the list (after a restart).
21:35:27 <Bob> cool!
21:37:11 <Bob> so I guess the answer to my initial question is completly answered by now, in short it is: "Do it yourself buddy!" :)
21:38:09 <Bob> My 2nd question tonight was: "I thought it would be neat to have some feature that lets you track amounts of items bought and sold, in order, ,for example, to establish production cost per unit produced, etc. Anyone knows of some decent existing program that I could use for these kind of purposes?" I guess that would be MUCH harder to achieve...
21:40:26 *** twunder has joined #gnucash
21:41:07 <Bob> see, the reason why I am interested in these question is that I work in a consulting firm for farmers (I do the fertilisation part, my collegue does the more "management" part) and I see that one big reason why farmers don't buy the very specialized accounting software it the price of it....I though that since Gnucash already has a decent "skeleton" it would be neat to be able to tweek it a bit so it fits the needs of farmers...
21:50:25 <Bob> I'm off to bed now...before I go, any idea on my "2nd question"?
21:53:34 <jsled> roughly sounds like "inventory", which gnucash does not do.
21:53:49 <jsled> As for the first question...
21:53:57 <Bob> it is indeed "inventory"
21:54:39 <jsled> I see the :), but I don't want to frame it as "[DIY], buddy!". It's more … this is the first request I've heard for that account hierarchy in 10 years with the project.
21:54:48 <jsled> I have no idea what that hierarchy should look like.
21:54:58 <jsled> If you do, contribute the codified knowledge! :)
21:55:38 <jsled> So, well, maybe the response actually is "DIY, good buddy!" ;)
21:55:48 <Bob> :)
21:59:36 <Bob> I might very well do that, but, would you think of any way I could somehow track "inventory", (I am fond of Gnucash and would like to somehow be able to stick to it). Maybe some external program or something, or would it be better to switch to another software altogether (those that use MySQL), such as http://www.sql-ledger.org/
21:59:38 <Bob> ?
22:19:46 <Bob> goodnight
22:19:50 *** Bob has quit IRC
22:28:38 *** twunder has quit IRC
22:47:51 *** cedayiv has joined #gnucash
22:56:36 *** Zoolooc_ has joined #gnucash
23:05:21 *** Zoolooc__ has quit IRC
23:07:56 *** Zoolooc__ has joined #gnucash
23:16:27 *** Zoolooc_ has quit IRC
23:17:03 *** Zoolooc has joined #gnucash
23:19:22 *** Zoolooc__ has quit IRC
23:31:28 *** Zoolooc__ has joined #gnucash
23:33:04 *** Zoolooc has quit IRC
23:47:06 *** Zoolooc__ has quit IRC