2009-06-04 GnuCash IRC logs

01:56:05 *** warlord-afk is now known as warlord
01:56:14 <warlord> jsled: I wonder if the Income Statement wouldn't have been a little better?
02:22:30 *** warlord is now known as warlord-afk
03:35:00 *** MechtiIde has joined #gnucash
04:35:17 *** bluefox has quit IRC
07:02:46 *** bluefox has joined #gnucash
07:10:05 *** twunder has joined #gnucash
07:18:14 *** twunder has quit IRC
07:32:30 <Jimraehl> What was the path to the Gnucash 2.3.0 nightly build - I lost track f it
07:32:54 <Jimraehl> Er - Windows nightly build
08:22:53 *** Jimraehl has left #gnucash
08:35:10 *** JimRaehl2 has joined #gnucash
08:43:12 *** JimRaehl2 has left #gnucash
08:43:26 *** JimRaehl2 has joined #gnucash
09:14:57 *** warlord-afk is now known as warlord
09:15:05 <warlord> JimRaehl2: code /builds/
09:35:15 *** palatin has joined #gnucash
11:49:41 *** lenscape_ has joined #gnucash
11:49:41 *** znapper has quit IRC
12:04:55 *** soa2ii has joined #gnucash
12:10:35 *** warlord is now known as warlord-afk
12:27:27 *** hvx has joined #gnucash
12:36:31 *** soa2ii has quit IRC
13:12:36 *** bluefox has quit IRC
13:26:15 *** cortana has joined #gnucash
13:40:20 *** sjc has joined #gnucash
13:47:34 *** MechtiIde has quit IRC
14:43:27 *** warlord-afk is now known as warlord
15:03:46 *** MechtiIde has joined #gnucash
15:18:29 *** hvx has quit IRC
15:31:21 *** andyt has joined #gnucash
16:26:06 *** bluefox has joined #gnucash
16:41:54 *** sjc has quit IRC
16:41:58 *** swap001 has joined #gnucash
16:43:08 <swap001> hello. i just installed gnucash and i'm trying to learn how to use it. i have a problem: i cannot tell gnucash to set 2000 EUR as the starting point of my bank account... how can i do?
16:43:36 <warlord> swap001: transfer from Equity:Opening Balances
16:45:34 <swap001> but how many account i have to create? i think only 1: the bank account (type asset)
16:46:27 <jsled> swap001: you should take a look at the example account hierarchies.
16:47:10 <jsled> you need at least two accounts for valid Double-Entry accounting. :)
16:47:42 <jsled> and you really need at least one of the 5 major types (assets, equity, expense, liability, income)
16:49:57 <swap001> i can't understand a thing: everything is based on transactions, that is money comes from a "source" and goes to a "destination". but there should be a starting point that is not a transaction: the opening balance goes to the bank account but does not come from anywhere...
16:50:09 *** sjc has joined #gnucash
16:51:16 <jsled> it "sources" from the account {Equity:Opening Balances}
16:51:40 <jsled> So, the transaction is between {Equity:Opening Balances} and {Assets:Bank}.
16:51:52 <jsled> "Income" is another "source" account.
16:52:10 <jsled> And Expenses is a "sink"/"destination" account.
16:53:08 <swap001> so {Equity:Opening Balances} is a special account, isn't it?
16:54:43 <jsled> not really.
16:55:07 <jsled> It doesn't function differently than the other accounts.
16:55:41 <jsled> It's only "special" in how it's interpreted by reports and you. :)
16:57:51 <swap001> ok i think i have to get used to that way of reasoning :)
16:59:46 <swap001> another question :) what is the "R" column after the "Transfer" column in the transactions table?
17:01:06 <jsled> Reconciliation status
17:01:36 <swap001> ok i think i should not touch it for now...
17:03:07 <gxti_> simply put, you click it when a check clears
17:04:23 <gxti_> then each time you get a bank statement you use the reconciliation window to make sure gnucash agrees with your bank
17:11:08 <swap001> another thing... i gave 150EUR to my dad some days ago... it's only a loan. what's the best way to represent that in gnucash? as an expense perhaps?
17:12:48 <swap001> mmh.. maybe it's an asset
17:19:46 <jsled> an asset, yes. http://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_account_for_loaning.2Fborrowing_money_to.2Ffrom_a_friend.3F
17:24:57 *** palatin has quit IRC
17:34:56 <swap001> last thing, i promise... :) how can i tell gnucash that i earned 1000 EUR from my employer? i think this is a transaction between the employer's bank (type?) and my bank account (type: asset)
17:35:17 <jsled> Income account.
17:35:55 <jsled> Leave their bank (their accounting) out of it; from your perspective, it's Income:Salary:Employer -> Asset:Bank:Checking
17:35:56 <swap001> so from employer's bank (type income) to my bank (type asset)?
17:37:12 <swap001> ok done thanks very much :)
17:39:07 <jsled> you're welcome.
17:40:13 *** andyt has quit IRC
17:41:50 *** garryzn has joined #gnucash
17:42:46 * swap001 must go... thanks again and bye!
17:42:51 *** swap001 has quit IRC
17:45:54 <garryzn> I'm using ubuntu, and all my gnucash files are stored in my home directory, is that normal?
17:46:11 <jsled> your data files?
17:46:20 <garryzn> yeah
17:46:22 <jsled> data files are saved whereever you save them to.
17:46:33 <jsled> There's a bunch of .log and .xac files created in the same directory as that.
17:46:51 <jsled> Other gnucash data is saved to ~/.gnucash/ and (via gconf) in ~/.gconf/
17:47:17 <jsled> You can move all those files to a directory if you wish ... the next time you start gnucash you'll have to File > Open... the new datafile.
17:47:44 <jsled> Alternatively, you can start gnucash and File > Save As... you data to a new location, then (re)move the files in your home dir.
17:49:09 <garryzn> I just want to tidy up my home directory, should i just create a folder to store them in?
17:49:49 <jsled> sure.
17:50:08 <jsled> you can control via preferences how many of those other backup files are created.
17:50:09 <garryzn> thanks
17:50:15 <jsled> (or, really, when they're auto-removed)
18:34:51 <garryzn> Created a file called "cashstuff" , cut& pasted the files in there, go to file > open and i get a list of all the files but gnucash doesn't load them
18:35:44 <warlord> what do you mean "cut & pasted the files in there"?
18:36:05 <warlord> How did you 'create the file "cashstuff"'?
18:36:38 <garryzn> just created a folder in my home directory
18:38:30 <garryzn> sorry file=folder
18:38:34 <jsled> garryzn: so, there's a bunch of files.
18:38:58 <jsled> {basename}{timestamp}.xac {basename}{timestamp}.log, &c.
18:39:03 <jsled> Which one are you opening?
18:40:22 <garryzn> i open the folder and theres a long list of files, should i open one in particular?
18:40:44 <jsled> yup.
18:41:12 <jsled> Of all the {basename}{timestamp}.xac and {basename}{timestamp}.log ... you'll want the one named, simply, {basename}.
18:41:22 <jsled> Whatever that name is; I don't know what you named your datafile.
18:41:55 <garryzn> Hmm, Going back to have a look.
18:43:06 <jsled> garryzn: another thing to do if you have a terminal handy: gconftool-2 -R /apps/gnucash/history
18:49:10 <garryzn> Okay, the terminal lists 5 files
18:50:10 <garryzn> Sorry 4 files
18:50:58 <garryzn> all .xac
18:51:45 <jsled> can you please copy+paste them into http://pastebin.ca/, and give us the url it gives you?
19:06:33 <garryzn> http://pastebin.ca/1448140
19:09:50 <jsled> So, this is a listing of the history of recently opened files by gnucash.
19:10:02 <jsled> It seems to me that: a) your base datafile name is "PoolSense".
19:10:25 <jsled> b) you keep opening the auto-generated, timestamped .xac backup files for some reason.
19:11:13 <jsled> So ... in that new directory you moved the files into, I'd first look for a file named "PoolSense", and try to open that. Make sure that it contains the most recent data you entered.
19:11:32 <jsled> Failing that (either opening it or if it does not contain the most recent data) ... well ... I dunno.
19:11:45 <garryzn> Thanks, will try it.
19:16:23 <garryzn> woohoo, i can breathe again, it worked. I had visions of reloading all my information. Way to go jsled you're a star.
19:17:26 *** warlord is now known as warlord-afk
19:18:29 *** twunder has joined #gnucash
19:45:35 <garryzn> If the latest .xac file contains all your updated information. What are the other (.xac) files for? can they be trashed?
19:46:37 <jsled> yes
19:47:00 <jsled> though ... you really want to open your datafile, everytime.
19:47:12 <jsled> it's what's written to and updated when you save. The others are backups.
19:47:25 <jsled> http://wiki.gnucash.org/wiki/FAQ#Q:_What_are_all_these_.xac_and_.log_files_filling_up_my_directory.3F
19:48:36 <garryzn> will go have a look, and learn some more.
20:25:45 *** garryzn has quit IRC
20:27:15 *** cortana has quit IRC
20:38:01 *** twunder has quit IRC
20:39:54 *** sjc has quit IRC
20:48:45 *** Bob has joined #gnucash
20:48:51 <Bob> hi there
20:49:54 <Bob> I am looking for a report that would tell me my average expense/account/week, is there any?
20:55:44 <Bob> I have found a graphic way of doing so (graph of expenses and revenue), but it is rather hard to extract info from it
21:14:10 *** JimRaehl2 has left #gnucash
21:14:52 *** Jimraehl has joined #gnucash
21:15:50 *** warlord-afk is now known as warlord
21:15:56 <warlord> Bob: gnucash has no comparative reports.
21:39:43 <Bob> I must say reporting seems like a weakness in Gnucash
21:39:53 <Jimraehl> Hot dog! I installed Windows Gnucash 2.3.0 r18102 and it started successfully. r18098 had an error upon start, looks like that was taken care of.
21:40:14 <warlord> yep.
21:40:19 <warlord> It was fixed in 18100.
21:42:05 *** Bob has quit IRC
21:48:14 *** Olipro has joined #gnucash
21:48:31 <Olipro> any of you chaps using 2.3.0?
21:50:52 * warlord has ben using trunk for a long time.
21:51:15 * goodger__ has "ben" on highlight
21:51:18 *** goodger__ is now known as goodger
21:53:52 <Olipro> warlord: how is 2.3?
21:54:09 <Olipro> has it done anything catastrophic?
21:56:33 *** jcreigh has joined #gnucash
22:00:42 <warlord> sorry goodger
22:00:54 <goodger> that's quite all right
22:00:56 <warlord> Olipro: umm... define 'catastrophic'? I use it for my live data.
22:01:37 <Olipro> heh, so it hasn't destroyed anything
22:01:43 <Olipro> are you using the XML backend or SQL?
22:04:42 <warlord> XML
22:04:52 <warlord> I haven't migrated to SQL yet.
22:06:56 <Olipro> is there a migration tool?
22:08:20 <warlord> File -> Save As
22:28:04 <Olipro> not bad
22:28:23 <Olipro> and it hasn't killed, damaged or otherwise destroyed your XML data?
22:30:53 <warlord> Of course not.
22:36:10 <Olipro> alright then
22:36:12 * Olipro upgrades
22:36:47 <Olipro> can anyone give me a direct link to the EXE?
22:36:49 <Olipro> sourceforge isn't loading
22:40:23 <Olipro> ah great there's no binaries
22:40:53 <Olipro> does this compile with cygwin?
22:41:30 <jsled> I don't believe so ...
22:41:58 <jsled> http://wiki.gnucash.org/wiki/Windows#Q:_Is_it_possible_to_compile_GnuCash_on_Windows.3F
22:42:06 <jsled> this was from the 2.2 series.
22:42:38 <Olipro> well, there's win32 builds of the 2.2 series
22:42:44 <Olipro> so someone must be turning them out somehow
22:42:51 <jsled> I always got the sense it was "mingw not cygwin", but I really don't even know what that means.
22:42:58 <Olipro> ah mingw
22:43:21 <Olipro> mingw is an alternative to cygwin
22:43:27 <jsled> and, in fact, there's a daily win32 build on the server...
22:43:45 <Olipro> oh, even better
22:43:47 <Olipro> got a link?
22:43:56 <jsled> the "..." is "looking" :)
22:44:09 <Olipro> heh, OK
22:44:55 <jsled> heh heh
22:45:15 <jsled> http://lists.gnucash.org/pipermail/gnucash-devel/2009-May/025467.html — "However, the last step of publishing the file somewhere is still missing, so
22:45:15 <jsled> nobody can see the result so far :-)."
22:46:31 <Olipro> curses
22:46:59 <jsled> and ... I don't know any more, am done with dinner, and video game is paused. sorry. good luck!
22:48:55 <Olipro> warlord
22:49:09 <Olipro> you look like a man who has access to daily compiles
22:50:05 <warlord> jsled: not true..
22:50:12 *** jcreigh has quit IRC
22:50:12 <warlord> There's another followup to that.
22:50:21 <warlord> it's on code under /builds
22:50:58 <warlord> Olipro: i do. and they are published.
22:51:33 <Olipro> in svn?
22:52:05 <warlord> Please go read the -devel archives.
22:52:26 <Olipro> link me to them then
22:53:17 <Olipro> alright, got it
22:53:32 <Olipro> warlord: roughly what time?
22:53:43 <Olipro> (date)
22:53:57 <warlord> umm... within the last week?
22:54:04 <warlord> Start from Jsled's thread.
22:54:11 <Olipro> I got it - http://code.gnucash.org/builds/win32/trunk/
22:54:29 <warlord> Like I said, it's on code in /builds/
22:54:36 <warlord> I didn't paste the URL FOR A REASON!
22:54:51 <Olipro> what's that reason?
22:55:05 <warlord> Please go read my announcement on the daily builds.
22:55:11 <Olipro> will people in the channel be upset that they've been exposed to the URL?
22:56:14 <warlord> No, *I* will be upset that the URL was exposed without the caveats in the announcement.
22:56:47 <warlord> I could have posted the damn URL myself.
22:56:56 <warlord> I was being oblique for a damn reason.
22:57:08 <Olipro> it's a nightly SVN build, it's implicit to me that such builds are every-man-for-himself
22:57:13 <warlord> I dont want it widely published without without the associated caveats.
22:57:30 <warlord> Have you read the announcement?
22:57:32 <Olipro> if you consider this channel to class as "widely published" then sure
22:57:42 <warlord> This channel is logged..
22:57:45 <warlord> and therefore googleable
22:58:04 <Olipro> oh great
22:59:17 <Olipro> oh well, so is the mailing archive
22:59:40 <Olipro> and I'm not sure exactly how easily someone will find either this or the archive
23:00:18 <Olipro> but, if somehow my linking causes a massive explosion of downloading
23:00:19 <warlord> The mailing archive has the caveats in the message with the URL.
23:00:22 <Olipro> I'll be sure to apologise
23:00:30 <warlord> If it does I know who to blame.. ;)
23:01:13 <Olipro> is it prohibitive to upload the builds to sourceforge?
23:02:05 <warlord> I dont know how to set it up to do it in an automated way.
23:02:45 <Olipro> what's the method you use to make files available on sourceforge?
23:02:51 <Olipro> is it an upload box on a webpage?
23:02:59 <Olipro> or do they offer FTP?
23:03:07 <Olipro> in either case, you could use cURL
23:03:19 <warlord> I think an upload box in an authenticated web page..
23:03:28 <Olipro> yeah, you could do it with cURL then
23:03:29 <warlord> And I'm not putting my password on a windows box.
23:03:38 <Olipro> cURL runs on Linux...
23:03:47 <warlord> But the nightly build is on windows.
23:03:51 <warlord> linux knows nothing about it.
23:04:07 <Olipro> well, if you have a computer on a network with your windows machine
23:04:12 <Olipro> it could grab it from it and cURL it
23:04:28 <warlord> when? How do I know that there's a new build?
23:05:07 <warlord> (yes, I know I could code this up, but frankly I dont want to take the time and I still don't want to leave my SF password on a server)
23:05:08 <Olipro> well, when the build completes, have the windows machine write a file with the current date
23:05:13 <Olipro> or just stick it in the filename of the build
23:05:28 <Olipro> though, I'm sure SF must have a better way than webpage based upload surely
23:05:37 <warlord> which triggers the upload... how? Cron job?
23:05:50 <Olipro> linux box watches for the file's creation
23:05:51 <warlord> It's still an authenticated upload, regardless..
23:05:59 <warlord> "watches" how?
23:06:11 <warlord> polling sucks.
23:06:12 <Olipro> cron job? a program?
23:06:22 <Olipro> you could have a listener port and the windows machine could ping it
23:06:38 <Olipro> also, if you're worried about your personal account
23:06:42 <Olipro> create a second SF account
23:06:51 <Olipro> and give it access
23:08:46 <warlord> There's been a total of 100 downloads in 4 days.
23:09:28 <Olipro> not enough to motivate you eh?
23:09:36 <warlord> I think more likely what we'll do is take the daily builds of actual tags and upload those.
23:09:54 <warlord> So when we make 2.3.1 we'll upload the first daily build of that.
23:11:04 <warlord> And if it becomes a real issue I'll just throttle apache.
23:13:00 *** twunder has joined #gnucash
23:15:28 *** aindilis has joined #gnucash