2010-06-01 GnuCash IRC logs

01:39:49 *** bob25801 has quit IRC
02:19:54 *** feisar has joined #gnucash
03:49:36 *** gjanssens has joined #gnucash
03:49:37 *** gncbot sets mode: +o gjanssens
07:00:25 *** ErKa has joined #gnucash
07:14:00 *** blizgerg has joined #gnucash
07:32:39 *** Jimraehl has left #gnucash
07:41:50 *** ftab has joined #gnucash
07:44:11 <ftab> I am new to any Financial software, and don't know any thing about managing my home finances, I want to use Gnu Cash as I am using Ubuntu and like open source, can any body please help me where to start from ? thanks in advance. and even then after
07:45:33 *** ErKa has quit IRC
07:46:05 *** ftab has quit IRC
07:46:42 *** ftab has joined #gnucash
07:47:32 *** Jimraehl has joined #gnucash
08:26:44 <gjanssens> ftab: you can start with the online guide at http://www.gnucash.org/docs/v2.0/C/gnucash-guide/
08:26:59 <gjanssens> That will give you an idea of how gnucash works in general
08:27:28 *** daedeloth has joined #gnucash
09:16:20 *** warlord-afk is now known as warlord
09:16:28 <warlord> gjanssens: is svn still down to you?
09:16:47 <gjanssens> warlord: yes
09:17:02 <gjanssens> svn up
09:17:03 <gjanssens> svn: Network connection closed unexpectedly
09:18:07 <warlord> Hmm.. What's your IP?
09:18:12 <warlord> Can you ping it?
09:19:34 <gjanssens> I can ping the server
09:19:43 <gjanssens> ping svn.gnucash.org
09:19:44 <gjanssens> PING svn.gnucash.org (204.107.200.65) 56(84) bytes of data.
09:19:46 <gjanssens> 64 bytes from code.gnucash.org (204.107.200.65): icmp_seq=1 ttl=48 time=160 ms
09:21:40 <gjanssens> My ip address is currently 81.165.77.170
09:22:10 <gjanssens> This is dynamically assigned by my ISP, but doesn't change very often.
09:22:30 <warlord> Ah, right, ping is always allowed..
09:22:50 <warlord> IP 81.165.77.170 is in the block list. Is this a dynamic address?
09:22:57 <gjanssens> Yes
09:24:00 <gjanssens> As said, it is assigned by my ISP. In my experience it changes rarely, but it does happen.
09:24:04 <warlord> Most likely someone who had the address before you was infected with an rootkit and attempted to ssh into the server, causing the ip to get blocked. anyways, it's been cleared.
09:24:19 <gjanssens> Ok, thanks
09:24:38 <gjanssens> Working again.
09:25:17 <gjanssens> Hmm, I may have caused this myself.
09:25:46 <gjanssens> I don't have my gpg key installed on my windows test server, but I tried to run svn up anyway with svn+ssh
09:25:59 <warlord> Yes, you did:
09:26:01 <warlord> Jun 1 03:36:15 code sshd[18702]: Invalid user janssege from 81.165.77.170
09:26:18 <gjanssens> I just did it again... :(
09:27:06 <warlord> fixed
09:27:09 <warlord> Stop that
09:27:18 <warlord> change the win32 checkout to http://
09:27:27 <warlord> svn switch is your friend.
09:27:34 <gjanssens> Yes I realised that by now.
09:27:42 <warlord> lol
09:28:21 <gjanssens> Is there a way to install the gpg key on windows as well ? I'm sharing some checkouts between linux and windows, so that would simplify my setup
09:28:45 <gjanssens> Working purely in a VM is a nightmare
09:29:02 <gjanssens> So I do most editing on linux in a directory that is mounted on the vm as well
09:29:36 * gjanssens will search the web for the gpg stuff
09:29:46 <gjanssens> If not possible, I'll switch to http anyway.
09:30:08 <gjanssens> I will try not to block myself at least, promised :)
09:32:38 <warlord> gpg? or ssh?
09:32:58 <warlord> I don't know how to copy ssh stuff to win32
09:33:16 <gjanssens> Hmm, I think you're right, we're using ssh.
09:48:47 <warlord> :)
10:00:47 *** daedeloth has quit IRC
10:05:30 <kimmo> bazinga
10:06:55 <kimmo> gjanssens, you might want to look into Cygwin, it's got all kinds of neat real tools for the handicapped OSes
10:10:05 <warlord> kimmo: unfortunately cygwin and mingw aren't quite compatible.
10:10:31 <kimmo> heh
10:10:36 <kimmo> how convenient
10:14:02 <gjanssens> warlord, I found the problem with the tag building script.
10:14:16 <gjanssens> It was awk behaving very unpredicabilly on windows
10:14:55 <gjanssens> I can commit a patch, but before I do so, the empty tags file should be removed from the directory where this script is installed.
10:14:55 <warlord> unpredictably?
10:15:17 <warlord> i can go remove that
10:15:35 <gjanssens> Hmm, unexpectedly may be more accurate as description.
10:16:08 <gjanssens> awk { print $6$1 } won't work, while awk { print $1$6 } does.
10:16:14 <gjanssens> On linux both options are fine.
10:16:18 <warlord> weird
10:16:59 <gjanssens> Indeed. I simply worked around it.
10:17:04 <warlord> even if you put it in quotes? awk '{ print $6$1 }' ?
10:17:14 <gjanssens> I was.
10:17:58 <gjanssens> I think the issue is that the sixth field ends in a / and awk on windows then insists on interpreting the whole thing as a division of two numbers.
10:18:15 <gjanssens> s/I was/It was/
10:18:21 <warlord> Weird!!!!
10:18:29 <gjanssens> Tell me about it.
10:18:51 <gjanssens> Anyway, I have now tested the script in a windows environment and it gives the proper results.
10:19:13 <gjanssens> So if you can indeed remove the empty tags file, I'll commit the patch and we can have a 2.3.13 by tomorrow.
10:19:52 <gjanssens> That is, if you can also run the build_tags.sh script once after it is committed and the emtpy tags file is removed.
10:20:40 <warlord> I'll empty it in about 60 seconds.
10:21:29 <warlord> Okay, removed.
10:23:18 <gjanssens> Ok. The patch is committed. Can you run the latest script once ?
10:25:35 <warlord> Yeah..
10:26:42 <gjanssens> This should do nothing more than recreate the tags file.
10:27:09 <warlord> Done.
10:27:12 <warlord> tags file created
10:29:09 <warlord> should I remove the 2.3.13 line from the file to force a rebuild tonight?
10:30:04 <gjanssens> I was to retag in svn, but removing the line is simpler, so please do.
10:30:31 <warlord> ok
10:30:46 <warlord> done.
10:30:52 <warlord> So tag build should happen tonight.
10:31:40 <gjanssens> Good thing.
10:38:50 *** bob25801 has joined #gnucash
11:00:09 *** Krumar has joined #gnucash
11:05:37 *** crojas has joined #gnucash
11:06:41 *** crojas has quit IRC
11:20:34 *** bob25801 has quit IRC
11:28:37 *** fbond has joined #gnucash
12:35:11 *** warlord is now known as warlord-afk
12:46:37 *** ErKa has joined #gnucash
13:21:23 *** brushb has joined #gnucash
13:22:02 *** brushb has left #gnucash
13:23:37 *** raleightile has joined #gnucash
13:23:47 *** raleightile has left #gnucash
13:25:19 *** carlos has joined #gnucash
13:25:25 <carlos> hi
13:26:38 *** Askarii has joined #gnucash
13:28:43 <carlos> how i import a bills excel using qif import option
13:28:49 <carlos> ????
13:33:21 <Askarii> QIF export doesn't work, I suppose the import doesn't work either
13:33:30 <Askarii> but thats just an idea
13:34:16 <carlos> and what is the format for qif files??? any url???
13:35:13 <jsled> Askarii: there is no QIF export, and QIF import works fine.
13:35:17 <jsled> carlos: http://en.wikipedia.org/wiki/QIF
13:35:19 <carlos> yes export crash the gnucash, was this bug reported ????
13:36:18 <jsled> If by "bills" you mean Invoices, I don't believe there's a way to import them in QIF or otherwise
13:36:38 <Askarii> carlos the crash is known
13:36:49 <Askarii> qif export is a deprecated function
13:36:57 <Askarii> it's waiting to be removed entirely I believe
13:37:31 <jsled> there is no QIF Export in gnucash.
13:37:39 <jsled> You might be thinking of QSF Export, which is something else.
13:37:44 <Askarii> ah
13:37:46 <Askarii> sry
13:37:48 <Askarii> my mistake
13:50:15 <carlos> ok, invoices , thats correct, if i have many invoices and need a cash flow report
13:50:41 <carlos> could i import these invoices in any way???
13:51:42 <carlos> i dont need the invoices details only the total and if has tax
14:03:04 <carlos> gnucash has webservice o any alternative input for invoices??
14:09:52 *** ErKa has quit IRC
14:10:28 *** tim_abell has joined #gnucash
14:10:54 *** andyt has joined #gnucash
14:20:55 <Askarii> is there a way to add a line break in invoices?
14:21:07 <Askarii> int he description part of the invoice
14:21:32 <Askarii> nvm
14:21:37 <Askarii> just realized html works :)
14:25:55 *** cortana has joined #gnucash
14:31:50 *** ErKa has joined #gnucash
14:42:13 *** ErKa has quit IRC
14:42:28 <Askarii> okay
14:42:30 <Askarii> new question
14:42:36 <Askarii> how to make a credit to a client?
14:56:54 *** aindilis has quit IRC
14:56:54 *** ftab has quit IRC
15:00:58 *** aindilis has joined #gnucash
15:04:11 *** ErKa has joined #gnucash
15:16:40 <carlos> any idea to import many invoices into GNUCash???
15:39:40 *** ErKa has quit IRC
16:03:00 <carlos> ????
16:16:49 *** _echa has joined #gnucash
16:17:14 <_echa> hi, i'm just starting to learn gnucash
16:17:42 <_echa> i've got a question about credit cards: when i make a payment from my asset current account to my liability credit card
16:17:52 <_echa> i get a duplicate transaction on my credit card
16:18:10 <_echa> because the OFX download from amex already has my payment in it
16:18:31 <_echa> should i delete the amex payment OFX record?
16:18:47 <_echa> or is there a way to void it
16:24:34 <Askarii> I have no experience with it
16:24:57 <Askarii> but if its a duplicate, then i don't see why deleting would be a problem... it would only make your accounts relate reality
16:30:33 <jsled> _echa: if you turn on the bayesian learning for the OFX importer, hopefully it'll match the transactions during import.
16:30:41 <jsled> hopefully. I never used the OFX importer.
16:31:44 <_echa> ok
16:34:10 <_echa> i have another question - when i opened a new current or credit account and imported the OFX - the balance isn't accurate, i mean it has just calculated what transactions there were in that extract
16:34:53 <_echa> so it doens't take into account the starting balance. is this something i should have done manually when creating the account?
16:35:51 *** fbond has quit IRC
16:56:05 *** warlord has joined #gnucash
16:56:06 *** gncbot sets mode: +o warlord
16:57:09 <warlord> carlos: no, you cannot import invoices into gnucash. HOWEVER, if you want to run a cash flow you can import the transactions via something like QIF (ignoring the fact that they are invoices) and run a cash flow.
16:57:13 <warlord> And no, there is no web-service.
17:03:09 <_echa> what is the "R" column, and what does "n" and "c" mean?
17:03:40 *** warlord-afk has quit IRC
17:06:46 <warlord> _echa: have you read the docs? This is in there.. R == Reconciled.
17:06:55 <warlord> N == Not; C == Cleared
17:07:25 <_echa> ok
17:07:39 <carlos> thx warlord
17:07:46 <_echa> i am really struggling to understand how the concept of balancing works in gnucash
17:08:09 <warlord> _echa: I repeat: Have you read the docs? In particular the concepts & tutorial guide?
17:08:11 <_echa> i have imported OFX data for my current, savings and credit cards
17:08:21 <_echa> i understand the concept yes
17:08:43 <_echa> what i don't understand is why i end up with loads of duplicates and wildly incorrect balances
17:09:02 <_echa> because the record of the transfer from my current account in already in my savings ofx data
17:09:16 *** ErKa has joined #gnucash
17:10:15 <warlord> duplicate matching requires human intervention.
17:10:28 <_echa> i guess gnucash just doesn't recognise that one credit is the same as the debit from the other account, so i need to manually delete one transaction from either the current or savings account?
17:10:48 <_echa> which one should i remove it from, does it matter?
17:10:50 <warlord> Or during the import you need to match them
17:11:02 <_echa> ok
17:11:52 <warlord> OFX isn't the best import method here with multuple accounts. QIF does better at internal mapping, provided the QIF accounts are set correctly in the QIF.
17:12:12 <_echa> i have a choice of OFX or QIF
17:12:23 <_echa> i assumed OFX was better supported
17:12:37 <_echa> shall i start again :-(
17:19:13 <warlord> Both importers work... There are just different benefits to one over the other. QIF is better for multi-account interaction for e.g. setting up your accounts for the first time. OFX is better for repetative downloads from some online source.
17:19:39 <_echa> i see
17:19:43 <warlord> In either case, yes, you should probably start over. Try different ways to see which you like, and choose the best result.
17:19:48 <warlord> Or just start over
17:19:58 <warlord> from scratch.. without importing.
17:20:05 <_echa> i've already spent 3 hours sorting all the transactions
17:20:13 *** fbond has joined #gnucash
17:20:13 *** message144 has joined #gnucash
17:20:14 <_echa> no way i can do it from scratch
17:20:39 <warlord> Why not? Just ignore your history prior to June 1, 2010
17:22:43 <_echa> i want to go over the past few weeks to see my spending history
17:22:46 <_echa> and also to learn gnucash
17:23:25 <_echa> i prefer the idea of loading my OFX data monthly rather than inputting receipts daily
17:23:43 <warlord> If you do that you'll never find a bank error
17:23:54 <warlord> But if you trust your bank never to make an error, that's fine.
17:24:00 <warlord> me, I've found bank errors.
17:25:01 <_echa> i'll have to go through a lot of transactions anyway, in order to link credit and savings payments to current account debits
17:25:20 <_echa> as my current, savings and credit data is all OFX
17:25:39 <_echa> i'll also want to categorise the transactions
17:25:53 <warlord> You seriously might be better off downloading QIF and trying a new import.
17:26:01 <_echa> so i'll end up going through them, just not having to do data entry
17:26:16 <_echa> i'll save this file where i am now and give it a go on a new one
17:31:01 <warlord> ok
17:43:47 *** andyt has quit IRC
17:47:17 *** tim_abell has quit IRC
17:49:47 <_echa> i see - the QIF importer has a nice dialogue for matching transactions
18:03:29 *** ErKa has quit IRC
18:05:11 *** Askarii has left #gnucash
18:06:05 <warlord> The ofx importer has one as well... just a little .. different.
18:12:04 *** Askarii has joined #gnucash
18:12:12 *** Askarii has left #gnucash
18:17:20 *** ErKa has joined #gnucash
18:23:01 *** gjanssens has quit IRC
18:40:00 *** twig11 has joined #gnucash
18:41:11 <twig11> Where can I find out how to use lots to track inventory in gnucash?
18:44:33 *** _echa has quit IRC
18:45:37 <jsled> inventory? there's no inventory support in gnucash.
18:46:24 <jsled> http://wiki.gnucash.org/wiki/Inventory_Handling tries to use commodities for "inventory" tracking, but it looks a bit thin
18:59:07 <twig11> jsled: so you don't know whether that works or not?
19:00:17 <jsled> well, it's really hand
19:00:20 <jsled> hand-wavy.
19:00:31 <jsled> gnucash simply doesn't have inventory support.
19:00:48 <jsled> You can try to mis-use commodities/lots to do so, I'd guess.
19:42:29 *** Krumar has quit IRC
19:43:23 *** raleightile has joined #gnucash
19:50:47 <twig11> Are there plans to add it?
19:54:16 <warlord> When you (or someone else) gives us a patch.
19:57:09 <twig11> How do you determine development priorities?
19:57:38 <jsled> whatever people are interested in contributing.
20:01:15 <twig11> Assuming there's a developer who knows how to implement it, would a donation nudge the donor's pet "missing feature" ahead?
20:01:47 <jsled> unlikely, but you're welcome to try a bounty approach at gnucash-devel@gnucash.org
20:02:01 *** carlos has quit IRC
20:02:26 <twig11> I'm not a programmer or I'd love to give it a shot.
20:03:46 <twig11> I like gnucash though, and don't absolutely need the inventory support. I'll probably keep using it either way.
20:05:10 <twig11> What are "lots" used for in the present version?
20:05:28 <jsled> stock cost-basis
20:05:34 *** warlord is now known as warlord-afk
20:06:30 <twig11> Maybe that's in the tutorial. I failed to find it.
20:19:55 *** Askarii has joined #gnucash
20:21:18 *** Askarii has left #gnucash
20:49:13 *** raleightile has quit IRC
20:49:28 *** raleightile has joined #gnucash
20:58:29 *** cortana has quit IRC
21:25:28 *** Askarii has joined #gnucash
21:32:06 *** warlord-afk is now known as warlord
21:32:18 <warlord> twig11: lots are also used for invoice-payment matching.
21:33:25 *** Askarii has quit IRC
21:47:46 <raleightile> hey, f13, new version of gnucash?
21:50:53 <warlord> raleightile: contact redhat/fedora/Bill Nottingham.
21:51:45 <raleightile> been getting messages, like your reports are saved in a new format, fonts look bigger or bolder, header graphic disapeared
21:57:44 <raleightile> I guess you're saying that previously fedora shipped only stable 2.29, and now they have decided to go 2.3.11?
22:06:05 <warlord> well, 2.2.9, not 2.29.. but yes
22:06:24 <warlord> Bill gambled that 2.4 would be released before fc13 went stable. He lost.
22:07:19 <jsled> Or, 2.3.12, maybe, as per http://koji.fedoraproject.org/koji/packageinfo?packageID=392
22:08:54 <warlord> I dont know if it's been pushed out as an update, yet.
22:13:14 <raleightile> not yet, i just tried yum update, but maybe soon.. I think i wouldn't have been so quick to jump if I knew it was a big jump, but I guess it is relatively safe with the number of backups I have..
22:14:09 <raleightile> one question, in the keep backups for 30 days, if you change it to say 10 days, will it delete the previous backups?
22:14:26 <raleightile> or will it only delete backups that age from that point on?
22:15:00 <warlord> right away
22:15:03 <raleightile> i usually have it set to 365 days, and would really rather set to unlimited..
22:15:39 <raleightile> ouch, so if i want to keep old backups, move them to a different folder
22:15:52 <warlord> 0 = unlimited
22:16:03 <raleightile> 0 :)
22:16:07 <warlord> (i think)
22:21:11 <raleightile> i'll find out, it already deleted all my files, good thing I had them synced on a different drive!
22:21:50 <raleightile> i have 1 now, so 0 doesn't mean 0
22:22:09 *** Askarii has joined #gnucash
22:23:57 <raleightile> don't you think deleting thousands of files should get at least as much "Are you sure" as touching a register with the mouse?
22:28:35 *** Askarii has quit IRC
22:32:13 *** ErKa has quit IRC
22:36:19 <warlord> nope.
22:36:49 <warlord> You have to type something before it takes effect.
22:36:58 <warlord> just mousing over it doesn't change anything.
22:37:07 <warlord> Perhaps it's -1 that's unlimited?
22:40:55 *** twig11 has left #gnucash
22:43:42 <raleightile> i have 2 backups now, i'll see if they are still there tomorow
22:44:32 <raleightile> this versions seems less save happy, it seems like you have to actually post something before it will even let you save, in my mem
22:44:46 <raleightile> the old version would save if you opened a report or something
22:44:56 <raleightile> i could be wrong though..
22:45:05 <raleightile> thanks
22:45:11 *** raleightile has left #gnucash
22:49:12 *** raleightile has joined #gnucash
22:49:59 <warlord> i dont know -- I haven't run 2.2 in years.. But if you haven't made a data change there's nothing to 'save'
22:50:53 *** raleightile has left #gnucash
22:51:00 *** raleightile has joined #gnucash
22:51:50 *** raleightile has left #gnucash
23:34:31 *** warlord is now known as warlord-afk
23:54:02 *** ebanders has quit IRC
23:54:31 *** ebanders has joined #gnucash