2009-04-16 GnuCash IRC logs
00:03:30 *** iamawake has joined #gnucash
01:55:03 *** bentob0x has joined #gnucash
02:00:46 *** hvx has joined #gnucash
02:55:44 *** Phil_Ewert has joined #gnucash
02:58:35 *** hvx has quit IRC
03:35:59 *** MechtiIde has joined #gnucash
04:06:37 *** tim_abell has joined #gnucash
05:57:13 *** ErKa has quit IRC
06:54:46 *** iamawake1 has joined #gnucash
07:01:50 *** iamawake has quit IRC
07:46:34 *** warlord-afk is now known as warlord
07:48:33 *** bentob0x has quit IRC
08:07:46 *** ErKa has joined #gnucash
09:17:10 *** ErKa has quit IRC
09:30:42 <roe_> anyone have info on the layout expected from a qif file?
09:31:00 <roe_> I'm working with an invoicing system that I would like to export my AR from into GnuCash
09:33:28 <jsled> http://en.wikipedia.org/wiki/QIF isn't horrible … especially the links at the bottom, including one back to GnuCash.
09:34:14 <roe_> I'll take a look, are any of the other formats more appropriate?
09:34:33 <roe_> for me "more appropriate" = easy to implement
09:38:04 <warlord> Note that importing into AR wont let the business reports work.
09:38:16 <roe_> really?
09:39:21 <roe_> I don't care about the invoice "reports" but the aging?
09:39:47 <warlord> That wont work, either.
09:39:57 <warlord> All the business reports depend on using Invoices and Process Payments.
09:40:05 <warlord> (so yes.. Really)
09:40:50 <roe_> well that changes my plans a bit - is there another suggested way of using a separate invoicing system with GnuCash?
09:42:07 <warlord> Nope.
09:42:37 <roe_> so then, at the moment, the only way to be able to run any report in the "business" category is to duplicate effort, posting invoices in both the real invoicing system and also in GnuCash?
09:43:07 <warlord> Well, gnucash is a "real invoicing system", but in your case, yes.
09:43:32 <roe_> yes, I guess, "the real invoicing system" should have read "our real invoicing system"
09:43:46 <roe_> ok, thanks for the input
09:44:06 <warlord> you're welcome.
10:54:31 *** bentob0x has joined #gnucash
11:05:46 *** kielein has joined #gnucash
11:16:33 *** KaiForce has joined #gnucash
11:31:27 *** micha has joined #gnucash
11:32:01 *** micha has quit IRC
11:34:57 *** arta has joined #gnucash
11:36:35 *** arta has quit IRC
11:44:12 *** andrewsw has quit IRC
11:48:51 *** goodger_ has quit IRC
11:49:59 *** goodger has joined #gnucash
11:52:53 *** andrewsw has joined #gnucash
11:52:53 *** gncbot sets mode: +o andrewsw
12:16:22 *** chris has quit IRC
12:17:23 *** chris has joined #gnucash
12:41:57 *** tim_abell has quit IRC
13:01:26 *** MechtiIde has quit IRC
13:32:21 *** ErKa has joined #gnucash
13:58:20 *** warlord has quit IRC
14:00:33 *** MechtiIde has joined #gnucash
14:09:35 *** KaiForce has quit IRC
14:16:46 *** warlord has joined #gnucash
14:30:19 *** jorelio has joined #gnucash
14:59:52 *** jbuchberger has joined #gnucash
15:01:39 *** jbuchberger has quit IRC
15:09:18 *** twunder has joined #gnucash
15:13:31 *** iamawake1 has left #gnucash
15:22:43 *** MarketAmericaWebCenter has joined #gnucash
15:22:57 <MarketAmericaWebCenter> hello
15:24:03 *** iamawake has joined #gnucash
15:24:20 <jsled> MarketAmericaWebCenter: hello
15:24:26 <MarketAmericaWebCenter> hello
15:24:43 <MarketAmericaWebCenter> how are you
15:24:59 <MarketAmericaWebCenter> I have an anoouncement for all small businesses
15:25:03 <MarketAmericaWebCenter> Hi I want to know who takes care of your marketing? Normally i speak with the business owner, would that be you?" I can offer you guarantee..100% profit.Resson why every business needs a web site is
15:25:13 <jsled> MarketAmericaWebCenter: please leave.
15:25:14 <roe_> jeez
15:25:24 <MarketAmericaWebCenter> why is that
15:25:37 <jsled> this is pretty much the definition of spam, and you're about to be kick-banned.
15:25:40 <MarketAmericaWebCenter> this is an opportunity
15:25:50 <roe_> to kick a spammer?
15:25:52 <MarketAmericaWebCenter> i've helped over 80 businesses
15:25:53 <jsled> it's unsolicited
15:26:02 <MarketAmericaWebCenter> ooo im not a spammer
15:26:06 <MarketAmericaWebCenter> i hate that
15:26:10 <MarketAmericaWebCenter> trust me
15:26:19 <MarketAmericaWebCenter> my name is samuel blain and i work for
15:26:22 <jsled> yes, you are. It's off-topic for the channel, regardless.
15:26:26 <MarketAmericaWebCenter> Market America
15:26:38 * roe_ /ignores
15:27:07 <MarketAmericaWebCenter> Ok thanks for listenning ..this is one and a life time offer
15:27:32 <MarketAmericaWebCenter> I could make businesses make 100% profit
15:27:35 *** MarketAmericaWebCenter was kicked by jsled (jsled)
15:28:49 <roe_> damn, I guess we missed that once in a life time opportunity
15:28:54 *** jsled sets mode: +b *!*MarketAme@*
15:29:25 <warlord> LOL
15:37:44 *** twunder has quit IRC
15:37:56 <gxti> a once in a lifetime opportunity to firebomb someone's residence
15:46:43 *** twunder has joined #gnucash
16:04:13 <warlord> Clear that residence should be samuel blain!
16:04:17 <warlord> Clearly
16:10:25 *** twunder has quit IRC
16:13:52 *** kielein has quit IRC
16:18:28 *** iamawake has quit IRC
16:27:59 <warlord> it requires restarting the VMs.
16:38:48 *** iamawake has joined #gnucash
16:51:39 *** MechtiIde has quit IRC
16:51:52 *** iamawake has quit IRC
16:54:36 *** jsled has quit IRC
17:02:10 *** iamawake has joined #gnucash
17:06:35 *** jsled has joined #gnucash
17:06:36 *** gncbot sets mode: +o jsled
17:08:07 *** warlord is now known as warlord-afk
17:08:12 *** twunder has joined #gnucash
17:11:09 *** Phil_Ewert has quit IRC
17:15:14 *** iamawake1 has joined #gnucash
17:17:07 *** twunder has quit IRC
17:18:00 *** iamawake has quit IRC
17:24:57 *** iamawake has joined #gnucash
17:26:00 *** iamawake1 has quit IRC
17:27:30 *** XiXaQ has joined #gnucash
17:43:39 *** tyabux has joined #gnucash
17:43:39 *** iamawake has quit IRC
17:50:03 *** XiXaQ has quit IRC
17:51:54 *** soa2ii has joined #gnucash
17:57:07 *** iamawake has joined #gnucash
18:21:31 *** soa2ii has quit IRC
18:22:52 *** soa2ii has joined #gnucash
18:29:40 *** soa2ii has quit IRC
18:29:47 *** iamawake has quit IRC
18:31:10 *** iamawake has joined #gnucash
18:31:39 *** soa2ii has joined #gnucash
18:33:19 *** soa2ii has quit IRC
19:03:51 *** iamawake1 has joined #gnucash
19:03:59 *** iamawake has quit IRC
19:18:03 *** Bob has joined #gnucash
19:18:11 <Bob> hi there!
19:18:55 <Bob> my question today is about reports.... is it normal that the dates covered by the report don't show completely?
19:23:40 <andrewsw> Bob: what do you mean?
19:25:10 <Bob> when I produce a report like a pie chart of my expenses, there is a title, and a date in parentheses right beside, well my problem is I cannot see the end-date completely
19:26:16 <andrewsw> hmmm... I see what you mean.
19:26:27 * andrewsw doesn't use pie charts
19:26:50 <Bob> did that happen to you in the past in other reports?
19:26:58 *** iamawake1 has quit IRC
19:27:20 <andrewsw> I have no problems with reports, but I do see this problem in the income pie chart.
19:27:29 <andrewsw> the main title is truncated by the chart window
19:27:48 <Bob> exactly!
19:27:49 <andrewsw> further, when you increase the size of the chart, the text is scaled with it leaving the truncation intact
19:28:15 <Bob> that's it!
19:28:20 <Bob> any solution?
19:29:09 <andrewsw> nope, sorry. My first guess is that it might be a font problem. In that either the graph generating code or some piece of the gnome system is picking an inappropriate font.
19:29:18 <Bob> I just realized now that the PDF version is not truncated (I had not tried before....)
19:29:53 <andrewsw> that makes it even more likely to be some kind of font rendering problem, in my opinion, but that's based on very skimpy knowledge of these things.
19:30:31 <Bob> it is sort of annoying though to have to print if to PDF when you just want to quickly check something....
19:30:53 <Bob> I run on Debian with XFCE, if that makes any difference
19:31:03 <andrewsw> I'm on debian with xmonad.
19:31:14 <Bob> what's xmonad?
19:31:21 <andrewsw> a tiling window manager
19:31:36 <andrewsw> hence my inability to really mess with the gnome configuration
19:33:14 <andrewsw> I think we use goffice to render the charts, you might muck around in gnome-control-center and see if you can specify anything for goffice fonts. That might help.
19:33:35 <andrewsw> Other than that, it looks like a bug to me and if you can file it with a screenshot, that would be great.
19:37:14 <Bob> I don't know too much about computers....having installed Debian with Xfce already took me some efforts.....so I don't think I can do a lot of tweeking around with my own settings....
19:37:38 <andrewsw> fair enough. welcome to debian! ;-)
19:37:59 <Bob> it's been cool so far though...
19:38:21 *** bentob0x has quit IRC
19:39:11 <Bob> where would I go to report it as a bug?
19:40:32 <andrewsw> bugzilla.gnome.org
19:41:02 <andrewsw> hmmm... doesn't seem to happen now in the barcharts.
19:41:31 <andrewsw> okay, some work, some don't
19:41:51 <Bob> it happens here...maybe the short-titled ones are fine...?
19:42:35 <andrewsw> yeah, it looks like no allowance is made for the title length. thus the longer titles get cut off.
19:43:18 <Bob> do I need an account to report bugs?
19:44:34 *** twunder has joined #gnucash
19:46:05 <Bob> well, about somehere can do that report....it seems way more complicated that I am willing to put effort into.... :)
19:46:07 <andrewsw> i think so. I'm gonna guess that this bug may already be reported
19:46:39 <andrewsw> I don't have time to do a search right now, but I'll check into it. I'm beginning to suspect that it might not be our bug anyway.
19:46:55 <andrewsw> From a quick glance at the code, it might be a bug in the chart renderer (which we get from elsewhere).
19:47:14 <Bob> I meant ...well, how about someone here can do that report....it seems way more complicated that I am willing to put effort into.... :)
19:47:26 <andrewsw> yeah, I understood.
19:47:36 <andrewsw> I"ll file it if I can't figure it out in the short term.
19:48:01 <andrewsw> mean while, if it helps, you can edit the report title and pick something shorter thant he default...
19:48:13 <Bob> how so?
19:48:23 *** twunder has quit IRC
19:49:01 <andrewsw> run the report, click Options, select General tab and edit "Report Name". It's a lot just to read the whole title, but maybe it helps.
19:50:23 <Bob> cool! thanks for your support, I've been using Gnucash for 3 months now, and have been learning a lot about accounting from it (I knew nothing about it before!)
19:50:35 <Bob> keep up the good work!
19:50:39 <Bob> bye now
19:50:47 <andrewsw> you're welcome. good luck.
19:50:52 *** Bob has quit IRC
20:13:02 *** chris has quit IRC
20:26:05 *** iamawake has joined #gnucash
20:29:28 *** chris has joined #gnucash
20:52:07 *** iamawake has quit IRC
21:32:04 *** warlord-afk is now known as warlord
21:51:22 *** beginner has joined #gnucash
21:56:06 *** jorelio has quit IRC
21:57:21 *** iamawake has joined #gnucash
21:59:23 <beginner> Dear GnuCash Support and user experts, I am new go GunCash. My operating system: US English Windows XP Professional with SP3. I have found GnuCash very hard to get me started. My first 2 stupid questions: 1. how do I check for updates, and 2. I have set up an investment stock account, how do I make GnuCash track latest stock values every time I log on?
22:03:12 <warlord> 1) sign up to the gnucash-announce mailing list
22:03:39 <warlord> 2) install ActivePerl and then install the quote-grabber. The former you have to download manually. The second is in the Start -> All Programs -> GnuCash menu
22:23:48 <beginner> Hi Warlord, thanks for your prompt response. To follow up:
22:24:01 <beginner> how do I sign up to the mailing list?
22:24:29 <warlord> www.gnucash.org -- follow the links
22:25:50 <beginner> Thx! Give me a minute or two to get it done.
22:27:29 <beginner> Still on mailing lists: for updates, do I sign up for the gnucash-announce?
22:29:36 <beginner> I am using FirFox, and for either the announcement mailing list link or the user question link, I get the following error msg:
22:29:42 <beginner> Secure Connection Failed
22:29:42 <beginner>
22:29:42 <beginner>
22:29:42 <beginner>
22:29:42 <beginner>
22:29:43 <beginner>
22:29:45 <beginner>
22:29:47 <beginner>
22:29:49 <beginner>
22:29:51 <beginner> lists.gnucash.org uses an invalid security certificate.
22:29:53 <beginner> The certificate is not trusted because it is self signed.
22:29:55 <beginner> (Error code: sec_error_untrusted_issuer)
22:29:57 <beginner>
22:29:59 <beginner>
22:30:01 <beginner>
22:30:03 <beginner> * This could be a problem with the server's configuration, or it could be someone trying to impersonate the server.
22:30:06 <beginner> * If you have connected to this server successfully in the past, the error may be temporary, and you can try again later.
22:30:09 <beginner> What am I doing wrong?
22:34:16 <gxti> pasting lots of whitespace to a public IRC channel
22:34:20 <gxti> </snark>
22:37:11 <beginner> Sorry, but I was simply copying and pasting an error msg in FireFox when trying to signup to mailing lists.
22:38:03 <gxti> you're not doing anything wrong; lists.gnucash.org just doesn't have a "real" SSL certificate
22:38:21 <gxti> so you have to go through firefox's five-click-tango to get it to open the damn page
22:39:12 <beginner> Would it help if I used IE or Opera?
22:39:29 <gxti> they do the same thing, except they require fewer clicks
22:39:51 <gxti> in ff, click "Or you can add an exception..."
22:40:28 <gxti> then "Add exception" then "get certificate" then "confirm security exception" then curse the asshole who came up with the idea
22:40:29 <warlord> Yeah, just add an exception.
22:48:38 <beginner> Thank you gxti and warlord. I am on both the announce and user mailing lists now.
22:51:25 <warlord> great.
22:51:49 <beginner> Back to the stock tracking question. I clicked the "Install Online Price Retrieval" option per warlord and succeeded. But I still do not see the latest stock info (what is shown is number of shares and value from Feb when I first installed GnuCash and created the account.
22:52:42 <warlord> Did you then click on Tools -> Price Editor -> Get Quotes ?
22:52:54 <warlord> (you'll need to restart gnucash after running the "I.O.P.R."
22:56:48 <beginner> I did restart gnucash. Where will I find "Get Quotes"? The Price Editor simply opens a new but same window.
22:57:47 <warlord> As I said, Tools -> Price Editor
22:57:57 <warlord> There's a "Get Quotes" button there
23:01:06 <beginner> I clicked the Price Editor button and get a Price Editor window. It looks exactly the same as the regular window. I feel so stupid but I cannot find the "Get Quotes" button.
23:01:56 <beginner> BTW, each time I open gnucash, I get a "since last run" window with NO real-time data.
23:03:01 <warlord> The SLR runs because you have an SX
23:03:10 <warlord> What do you mean the "Price Editor button"?
23:04:31 <jsled> Yeah, the Since Last Run window is related to Scheduled Transactions, not prices.
23:04:33 <beginner> What is "SX"? Sorry, I meant the Price Editor menu option under Tools.
23:04:42 <jsled> Scheduled Transactions = SX
23:06:06 <beginner> To recap, I go to the Tools menu, click on Price Editor, a new windows opens looking exactly the same as the regular gnucash window. It seems that I need to find the "Get Quotes" button, but I do not know where to find it.
23:06:09 <warlord> beginner: Can you upload a screen shot to imagebin.ca
23:06:26 <warlord> I dont believe you.
23:06:37 <beginner> How do I upload?
23:08:31 <beginner> I fear I am your typical hopeless and helpless case :-)
23:08:45 <warlord> go to imagebin.ca
23:09:24 <jsled> "a new window opens looking exactly the same as the regular gnucash window"?
23:09:48 <jsled> What's the "regular gnucash window"?
23:11:42 *** tyabux has quit IRC
23:12:26 <beginner> By "regular gnucash window" I mean the progam window that is displayed when I start gnucash.
23:12:41 <jsled> That's really strange.
23:12:46 <jsled> I don't believe you either. :)
23:14:13 <beginner> is "imagebin.ca" www.imagebin.ca?
23:14:24 <jsled> yes. http://www.imagebin.ca/
23:14:40 <warlord> yes
23:24:22 <beginner> I created an MS Word doc with the screen shots, but keep getting the "Sorry, you did not provide any data for upload. Please try again." error msg.
23:24:48 <warlord> Right, you need to upload an IMAGE. A JPG, TIF, GIF, ...
23:25:08 <beginner> I see. Let me try again from scratch.
23:31:29 <jsled> well, uploading another word doc won't help. if you have some sort of image editing software (acdc, photoshop, gimp, &c.), you should be able to save a png.
23:31:48 <jsled> But, geez, I guess windows doesn't make it trivial to create a png screenshot out of the box.
23:32:34 <warlord> it used to.
23:35:42 <beginner> I used Paint to create 3 jpg files. But none will upload as I get the same error msg that I did not provide any data.
23:36:39 <beginner> (I placed the 3 jpg files on my Windows desktop.
23:37:40 <warlord> And did you "browse" to them from the webpage?
23:38:53 <beginner> Yes, then I click one of the files, click open (back to the imagebin.cn page), then click upload, and get the failure msg.
23:40:59 <warlord> I dont know what to tell you.
23:41:58 <warlord> @op
23:41:58 <gncbot> warlord: Error: You don't have the #gnucash,op capability. If you think that you should have this capability, be sure that you are identified before trying again. The 'whoami' command can tell you if you're identified.
23:42:13 <warlord> @op
23:42:14 *** gncbot sets mode: +o warlord
23:44:16 <beginner> I am lost, sorry. What do I need to do?
23:44:46 <warlord> Honestly, at this point I dont know what to tell you.
23:44:59 <warlord> But... I'm heading to bed.
23:45:45 *** warlord is now known as warlord-afk
23:46:29 <beginner> Understand. Before I give up on gnucash and go to another financial/accounting program, could any of the experts tell me what SHOULD happen after I select Price Editor in an attempt to get real time quotes for a stock, eg IBM?
23:46:56 <goodger> I don't think you can rely on it to give you real-time quotes
23:47:12 <goodger> there's going to be a delay of fifteen minutes at least by my reckoning
23:47:45 <jsled> yeah, the only place I know doing free real-time quotes is google, and I don't think finance::quote has a google scraper.
23:47:50 <beginner> How about stock price at end of any given day, as I start gnucash each time?
23:48:11 <goodger> that ought to do
23:48:25 <jsled> you should get a separate price-editor window that lets you either manually edit the price database or invoke finance::quote to scrape the price from a website.
23:48:25 <beginner> But I cannot make it work.
23:48:46 <goodger> ok, so you open the price editor and click get quotes, and about ten seconds later the quotes are updated, and you click "close" and get on with your life
23:48:53 <jsled> It's Really Weird that when hitting that Tools > Price Editor window that you would get the "regular gnucash window" instead.
23:49:36 <beginner> What might prevent the Price Editor window to open properly? Maybe there is something wrong with what I have done.
23:52:12 <beginner> When I select Security Editor, a separate window opens up. I see currency and NYSE. Under NYSE I see IBM.
23:52:25 <beginner> Then I click Edit, and see:
23:53:14 <beginner> full name, symbol-IBM, type-NYSE, ISIN is blank, Fraction=1/10000
23:53:22 <beginner> Get online quotes is checked.
23:53:59 <beginner> type of quote source=multiple: NYSE (Yahoo....), timezone=user local time
23:54:04 <beginner> Anything wrong?
23:54:32 <goodger> nope
23:55:55 <beginner> Why would Price Editor NOT open up properly? I have gnucash version 2.2.9
23:56:44 <beginner> The main Stock menu shows:
23:58:43 <beginner> date (I selected today's date), num (blank), description, transfer=imbalance-USD, r=n, shares=40, price=1, buy=40.00, sell (blank), balance=40
23:58:52 <beginner> at the bottom of the screen, I see:
23:59:31 <beginner> shares: 40 IBM, Current Value: $3636.80 (which is from Feb when I first downloaded and installed gnucash)