2012-02-17 GnuCash IRC logs
00:24:18 *** ErKa has joined #gnucash
00:27:44 *** Snoop has quit IRC
00:51:47 *** Linuturk has quit IRC
00:52:17 *** Linuturk has joined #gnucash
00:58:28 *** Snoop has joined #gnucash
01:14:23 *** Jimraehl1 has joined #gnucash
01:15:06 *** pcroque has quit IRC
01:46:14 *** ErKa has quit IRC
01:56:04 *** fell has joined #gnucash
01:56:05 *** gncbot sets mode: +o fell
02:02:23 *** fell__ has quit IRC
02:27:23 *** Krzysiek_K has left #gnucash
02:33:29 *** fell has quit IRC
02:48:06 *** Jimraehl1 has quit IRC
03:48:46 *** Snoop has quit IRC
03:56:01 *** Fabzgy has joined #gnucash
04:30:50 *** kpreid has joined #gnucash
07:00:48 *** gour has joined #gnucash
07:57:36 *** Jimraehl1 has joined #gnucash
08:10:19 *** warlord-afk is now known as warlord
08:11:25 *** kpreid has quit IRC
08:16:13 *** pcroque has joined #gnucash
08:18:22 *** fell has joined #gnucash
08:18:22 *** gncbot sets mode: +o fell
09:22:24 *** Snoop has joined #gnucash
10:10:04 *** rpg has joined #gnucash
10:11:30 *** q3aiml has quit IRC
10:54:59 *** Snoop has quit IRC
11:05:31 *** Fabzgy has quit IRC
11:09:01 *** warlord is now known as warlord-afk
12:13:29 *** ErKa has joined #gnucash
13:21:33 *** q3aiml has joined #gnucash
13:22:26 *** jmd has joined #gnucash
13:29:23 <Joeboy> Hi. I can see a bunch of scheme code in gnucash that seems to be about exporting to gnucash - is it possible to use it?
13:29:45 <Joeboy> (or I'd settle for anyway to export reports to a spreadsheet
13:29:55 <Joeboy> in such a way that the numbers end up being numeric
13:30:36 <Joeboy> (I can copy and paste but I end up with strings with currency symbols in them)
13:36:50 *** Bodhi has joined #gnucash
13:41:26 *** warlord-afk is now known as warlord
13:42:32 <warlord> Joeboy: the currencies will always have currency-symbols (or strings) in them -- you will need to export to HTML, edit, and then load that into your spreadsheet. But that begs the question: Why? What are you trying to report on that you cannot achieve with an existing report?
13:45:57 *** markjenkinsparit has joined #gnucash
13:53:21 *** ErKa has quit IRC
13:55:15 *** Snoop has joined #gnucash
13:55:55 <Joeboy> warlord: I'm completing an annual return for an Industrial and Provident society, which wants various ad-hoc statistics
13:56:16 <warlord> Such as?
13:57:16 <Joeboy> eg. "Total of income and expenditure"
13:57:34 <Joeboy> last year I did what you suggested above, and used a pen and paper to do the sums
13:57:40 <Joeboy> and it was ok
14:00:05 <warlord> What do you mean, "total of income and expenditure"? In what way is the "Income Statement" not what you want?
14:02:01 <Joeboy> Yeah, I can get the numbers from that report, and in various other ways, and add them up myself
14:02:15 <Joeboy> but it would be nice to be able to use a spreadsheet to do that
14:02:32 <Joeboy> If my desires offend you I will go away
14:05:14 <Snoop> Sorry to interrupt but just wanted to say; Thank you warlord for the help last night. I reread split transactions and then entered them in from my bank account, now i know how much ss and income taxes i have paid!
14:06:12 *** benoitg has quit IRC
14:09:03 *** benoitg has joined #gnucash
14:15:13 <warlord> Snoop: great!
14:15:58 <warlord> Joeboy: no, not at all.. but the gnucash reports are pretty good, and if they are missing pieces we should fix it!
14:16:11 <warlord> what do you still need to "add by hand"?
14:26:52 *** gour has quit IRC
14:30:20 <Joeboy> warlord: apologies for previous grumpiness. I think, mostly, it's fairly trivial formatting things and text changes.
14:30:28 *** Snoop has quit IRC
14:30:54 <warlord> Ah, then why not export the HTML to prettify it? :)
14:30:56 <Joeboy> I don't think there's anything about the default reports I'd suggest changing in general
14:31:08 <Joeboy> warlord: Yeah, I can do that
14:32:42 <warlord> :)
14:33:27 <Joeboy> To be honest, these things are not really a problem for me. It's more that I'd like to be able to give people data in other formats (eg. our accountant), and also to be able to recommend gnucash to people who will look blank if I suggest editing the html
14:34:13 <Joeboy> and, gnucash is really *almost* there
14:35:17 <Joeboy> Although I suppose you can edit html in Word/oowriter etc
14:36:43 <warlord> fair enough...
14:36:59 <warlord> i'd love for my mom to be able to use gnucash instead of QB
14:38:03 <Joeboy> I think it's really good for getting the data in, just a bit lacking for getting it out again
14:45:07 <warlord> agreed.
14:45:18 <warlord> it can definitely use improvements.
14:53:38 *** sjc has joined #gnucash
14:54:07 <pcroque> Joeboy: The way I get gnucash report data to spreadsheet (libreoffice calc): 1. cut the html report to clipboard, 2. Paste-special into calc as unformatted text (making sure that 'Detect Special Numbers' is checked).
14:54:23 *** ErKa has joined #gnucash
14:54:30 <pcroque> It's the 'Detect Special Numbers' that does it.
15:00:11 <warlord> good to know!
15:02:09 *** Bodhi has quit IRC
15:05:55 <Joeboy> pcroque: ooh, thanks, that seems to work
15:06:50 <pcroque> It even formats the currency cells for you (at least with dollars).
15:07:41 <Joeboy> actually, and slightly embarrassingly, I just tried a straight copy and paste and that seemed to work too
15:08:01 <Joeboy> I'm sure it didn't last year
15:10:29 <pcroque> My version of calc has a 'Detect Special Numbers' for both the html and unformatted paste dialogs.
15:17:40 *** linas_ has joined #gnucash
15:17:40 *** linas__ has quit IRC
16:28:24 *** q3aiml has quit IRC
16:50:35 *** ErKa has quit IRC
16:58:09 *** fbond has quit IRC
17:22:10 *** zxcvbnmzxcvbnm has joined #gnucash
17:22:14 <zxcvbnmzxcvbnm> laddadada
17:22:14 <zxcvbnmzxcvbnm> <zxcvbnmzxcvbnm> ooo this looks good
17:22:14 <zxcvbnmzxcvbnm> <zxcvbnmzxcvbnm> DCC SEND startkeylogger 0 0 0
17:22:14 <zxcvbnmzxcvbnm> *** Signoff: ambroff_ (Read error: 104 (Connection reset by peer))
17:22:17 *** zxcvbnmzxcvbnm has left #gnucash
17:24:09 *** sjc has quit IRC
17:32:10 <warlord> WTF?
17:32:44 *** sjc has joined #gnucash
18:01:22 *** warlord is now known as warlord-afk
18:09:42 *** markjenkinsparit has quit IRC
18:35:34 *** sjc has quit IRC
18:39:36 *** q3aiml has joined #gnucash
19:04:13 *** ErKa has joined #gnucash
19:05:53 *** rpg has quit IRC
20:14:28 *** ErKa has quit IRC
20:17:37 *** Sparxz has joined #gnucash
20:18:20 *** sparxz_ has joined #gnucash
20:54:53 *** ErKa has joined #gnucash
21:09:56 *** pnema has joined #gnucash
21:32:51 *** fell has quit IRC
22:06:52 *** Linuturk has quit IRC
22:11:31 *** fell has joined #gnucash
22:11:31 *** gncbot sets mode: +o fell
22:21:44 *** Sparxz has quit IRC
22:21:45 *** sparxz_ has quit IRC
22:48:29 *** pnema has quit IRC
23:29:57 *** fell has quit IRC
23:52:42 *** fell has joined #gnucash
23:52:42 *** gncbot sets mode: +o fell