2013-11-02 GnuCash IRC logs

00:24:42 *** keryell has joined #gnucash
00:58:13 *** fell__ has quit IRC
01:04:10 *** fell has joined #gnucash
01:04:10 *** gncbot sets mode: +o fell
01:28:33 *** fell has quit IRC
01:29:18 *** fell has joined #gnucash
01:29:19 *** gncbot sets mode: +o fell
01:48:20 *** keryell has quit IRC
01:52:19 *** fell has quit IRC
02:21:07 *** john has joined #gnucash
02:21:08 *** gncbot sets mode: +o john
02:21:18 *** jmd has joined #gnucash
02:45:04 *** john has quit IRC
03:46:46 *** JoTraGo has joined #gnucash
05:09:30 *** warlord has quit IRC
05:30:07 *** Topcat has joined #gnucash
05:42:25 *** Topcat has quit IRC
05:42:59 *** Topcat has joined #gnucash
05:46:43 *** aqua___ has joined #gnucash
05:52:02 *** Topcat has quit IRC
05:52:43 *** Topcat has joined #gnucash
06:01:41 <aqua___> hi,
06:02:20 <aqua___> i'm wondering wether their is a timeplan for a 2.6.0-release?
06:03:24 <aqua___> as for german (european) users this would be critical by 1st of january, because of iban-transaction (possible with 2.5.x, but not with 2.4.x)
06:03:47 <jmd> aqua___, Why is it critical?
06:05:00 *** Topcat has quit IRC
06:05:07 <jmd> You're talking about SEPA ?
06:05:44 <aqua___> true, iban = sepa
06:07:16 <jmd> Well its only critical if you absolutely have to use SEPA with Gnucash.
06:07:21 <aqua___> so with 2.4.x people won't be able to transfer money next year
06:07:27 <aqua___> true
06:08:22 <aqua___> but people won't want to use two programs, right?
06:09:40 <jmd> Well with gnucash one cannot transfer money anyway. You need aqbanking for that.
06:10:36 <aqua___> ok, ok
06:12:00 <jmd> I thought 1 Feb was the deadline?
06:12:22 <aqua___> I installed 2 programs (and a lot of dependencies) but in real life, i like to click on online-actions in gnucash and go.
06:12:40 <jmd> Yeah. Don't we all.
06:12:50 <aqua___> ;)
06:13:24 <aqua___> 1.feb you are right
06:13:30 <jmd> Frankly I think the way that gnucash interacts with libaqbanking is an abomination.
06:14:00 <jmd> (probably not the fault of Gnucash though)
06:15:57 <aqua___> you say that as a programmer? or as a user?
06:16:12 <jmd> As a user.
06:17:18 <aqua___> as a user i like the way it works, whe it works, the key creation or better the key-exchange with my bank is a pain, but then it works mostly smooth
06:17:43 <jmd> Yes. the setup is certainly a pain.
06:17:47 *** Topcat has joined #gnucash
06:18:10 <jmd> But the transactions are not altogether painless.
06:18:54 <jmd> The biggest pain is, if the transaction is refused by the bank, trying to find out what is wrong is next to impossible.
06:19:48 <aqua___> the hbci-errot-codes and this german homepage always helped me: http://www.kaiwu.de/cgi-bin/sbb/sbb.cgi?&a=print&forum=26&beitrag=16
06:20:27 <jmd> I didn't know about that page. Thanks.
06:21:29 <jmd> But that's not the biggest problem. The window which displays those codes is covered by another window, which you cannot get rid of unless you also get rid of the one you want to see.
06:22:13 <jmd> Again, I think those windows are ones created by the libaqbanking plugin. rather than Gnucash.
06:22:31 <aqua___> hm
06:23:38 <aqua___> but you can reach the window with the connection-messages-and-errors over action-online-actions-
06:24:10 * aqua___ should go back to work, and idle in here again
06:24:11 <aqua___> cu
06:24:16 <jmd> No. Because the error window is modal.
06:24:58 <jmd> You have to click on Retry or Cancel before anything will respond.
06:25:09 <jmd> Both those buttons cause the log window to close.
06:25:31 <aqua___> but afterwards you can open the log-window
06:25:40 <jmd> (or something like that .- I don't exactly remember)
06:26:02 <jmd> So far as I'm aware, there is no option to re-open the log window.
06:26:16 <aqua___> and their is a button within the log-window saying close me when finished
06:26:21 <aqua___> unhit that button
06:26:38 <jmd> Right. I have done that.
06:27:31 <jmd> but although the window doesn't close, it is obscured until the whole transaction is either retried, or aborted.
06:29:30 <jmd> Let me try a dummy transaction to see if I can describe the problem better.
06:32:55 <jmd> Right. So I ran a transaction and entered the wrong Pin/tan
06:34:00 <jmd> So I get two windows. One contains the log messages. But it is obscured by a message dialog "An error occurred while executing the job. Please check the log window for the exact error message.
06:34:00 <jmd> Do you want to enter the job again?"
06:35:38 <jmd> That's the first inconvenience.
06:35:53 <jmd> It would be better if these two windows were one.
06:36:36 <jmd> Secondly, like you said, there is a "close when finished" checkbox. But there is a catch 22 situation here.
06:37:24 <jmd> If that checkbutton is on, you cannot possibly uncheck it (because as soon as you click No) the window closes!
06:38:10 <jmd> Thirdly, that window is very small and doesn't let itself be resized.
06:41:55 <aqua___> <aqua___> but you can reach the window with the connection-messages-and-errors over action-online-actions-
06:41:57 *** tomkerswill has joined #gnucash
06:42:14 <tomkerswill> Hi! I'm experiencing a problem on Gnucash 2.4.13, where when I save an sqlite file, the application crashes during saving (about 30 secs after hitting the save button). An sqlite file is created (6MB). If I reopen Gnucash and attempt to open the file, after about a minute the file loads, but there are no accounts listed.
06:42:25 *** Topcat has quit IRC
06:43:48 <jmd> aqua___, Not before I've clicked either yes or no.
06:44:31 <jmd> aqua___, And also, I don't have such a menuitem
06:45:10 <jmd> It's just called "Show Log Window" here.
06:48:05 <jmd> The fourth nasty thing is, that if the transaction fails (say because I had one digit wrong in the account number) I have to re-enter EVERYTHING, acount no. BLZ, amount, description ...
06:56:13 <tomkerswill> Update on this issue ---- I've created a new set of accounts (blank) to test, saved as XML, then reopened and saved as SQLITE. This does work. So I think there's something in the xml file for my actual accounts which is causing Gnucash to crash when saving as sqlite.
06:57:07 <tomkerswill> Is there an easy way for me to get more debug info on what is happening ---- eg. a log or debug mode? I'm running this on OSX. Apart from the problems saving to sqlite, everything else on Gnucash seems to work great when using the usual xml file.
07:14:53 <tomkerswill> Here are the last lines in the trace file, before it quits (when trying to save the sqlite file). After saving, the Sqlite file exists, but doesn't have any data in the Accounts on Transactions tables, as far as I can see:
07:15:02 <tomkerswill> http://mibpaste.com/Zs8gp3
07:18:21 <PaulFertser> tomkerswill: when you say crashes, does it mean it produces a core dump? Is it possible for you to recompile with debug info (CFLAGS=-g) and rerun? Or at least to load the core file in gdb and do "t a a bt all"?
07:21:07 <tomkerswill> Hi - yes, I guess I mean that it just completely closes (I'm on OSX, and so the icon in the dock that shows the program is running, disappears at this point)
07:21:47 <tomkerswill> At the moment, I'm running the precompiled OSX binary --- but I'll definitely try and compile from source and test this out again, long term
07:22:24 <tomkerswill> I'm not sure about the core dump --- I can see the trace file, which seems to log things all the time that Gnucash runs normally - but not a core dump... But I'm not sure I'm looking in the right place
07:23:05 <jmd> The core file is normally dumped in the current directory.
07:23:40 <tomkerswill> Just one other bit of info that may be useful --- it creates the sqlite file, and also a small journal file (tom-business.gnucash-journal). If I do a "strings tom-business.gnucash-journal" on this, then I get some snippets of sqlite:
07:23:56 <jmd> Depending on your setup, you may have to run "ulimit -c unlimited" first.
07:24:00 <tomkerswill> http://mibpaste.com/7DkEwC
07:24:24 <tomkerswill> Ah right - yes, no core file then. I'll try running that first...
07:28:18 *** jmd has quit IRC
07:28:21 <tomkerswill> Great - in the terminal, when it crashes, I do eventually see: Segmentation fault: 11 (core dumped)
07:28:39 <tomkerswill> Sorry for the newbness here, but what would the core dump file be named, roughly?
07:32:17 <tomkerswill> Fab --- I've found it. Thanks for the help with this... Am learning! It's stored in /cores on OSX, once you've run the ulimit command you mentioned above...
07:34:47 <tomkerswill> It turns out the OSX Mavericks doesn't support gdb any more, and uses lldb instead. I'm just trying to see if I can use that to get the info needed. Will keep you posted.
07:51:15 <tomkerswill> Okay, I think the equivalent for doing gdb's "thread apply all bt" in lldb, is "thread backtrace all". But this is giving me an "invalid process" error. I'll keep trying, anyway, and will come back later to let you know how I get on.
07:56:15 *** tomkerswill has quit IRC
08:36:20 *** fell has joined #gnucash
08:36:20 *** gncbot sets mode: +o fell
08:37:30 *** Jimraehl1 has left #gnucash
09:05:37 *** Jimraehl1 has joined #gnucash
09:08:53 *** fell has quit IRC
09:09:45 *** fell has joined #gnucash
09:09:46 *** gncbot sets mode: +o fell
09:19:18 *** fell has quit IRC
09:21:09 *** fell has joined #gnucash
09:21:10 *** gncbot sets mode: +o fell
09:21:36 *** aqua___ has quit IRC
09:32:06 *** aqua___ has joined #gnucash
09:35:09 *** fell has quit IRC
09:35:37 *** keryell has joined #gnucash
09:38:26 *** fell has joined #gnucash
09:38:26 *** gncbot sets mode: +o fell
09:50:23 *** aqua___ has quit IRC
09:55:29 *** keryell has quit IRC
10:05:28 *** kpreid has quit IRC
10:06:08 *** kpreid has joined #gnucash
10:16:28 *** Jimraehl1 has left #gnucash
10:23:22 *** Jimraehl1 has joined #gnucash
11:06:48 *** ErKa has joined #gnucash
11:56:07 *** Topcat has joined #gnucash
12:09:06 *** jmd has joined #gnucash
12:21:30 *** xyst has joined #gnucash
12:21:53 <xyst> hello! is there a way to do something along the lines of =sum() (from excel) in the gnucash scheduled transaction editor?
12:23:21 <xyst> use case: I pay 13% tax on two charges in a schedule transaction. one charge changes periodically. it'd be nice to enter it as: a $1, b $2, c sum(others)*0.13, (then the corresponding balance transaction to categorize)
12:24:26 <xyst> I notice there's discussion of fin.scm on a few wiki pages, variables, and the like. can't find a page which lists "built in" stuff available (and fin.scm appears to contain mostly amortization formulas)
12:39:06 *** Topcat has quit IRC
12:50:50 *** jmd has joined #gnucash
13:23:43 *** ErKa has quit IRC
13:38:55 *** aqua___ has joined #gnucash
14:14:37 <fell> xyst: Have alook at http://wiki.gnucash.org/wiki/Scheduled_Transactions#Variables_and_Formula
14:58:40 *** mattl has quit IRC
15:03:08 *** Topcat has joined #gnucash
15:10:07 *** Topcat has quit IRC
15:10:45 *** Topcat has joined #gnucash
15:17:43 *** Topcat has quit IRC
15:18:20 *** Topcat has joined #gnucash
15:25:22 *** Topcat has quit IRC
15:25:56 *** Topcat has joined #gnucash
15:27:45 *** fabior has joined #gnucash
15:32:59 *** Topcat has quit IRC
15:33:36 *** Topcat has joined #gnucash
15:33:56 *** fabior has quit IRC
15:39:38 *** TradeBorG has joined #gnucash
15:46:00 *** Topcat has quit IRC
15:46:45 *** Topcat has joined #gnucash
16:03:15 *** Topcat has quit IRC
16:25:47 *** john has joined #gnucash
16:25:48 *** gncbot sets mode: +o john
16:30:58 *** aqua___ has quit IRC
16:44:21 *** jmd has quit IRC
17:05:48 *** Takyoji has joined #gnucash
17:08:37 <Takyoji> So I'd like to write some mobile webapp that perhaps uses GnuCash's SQL backend, for the sake of interoperability (rather than an interchange format that'd have to be imported/exported each time). Is there any plan of changing of the SQL table layout, or any considerations for multi-user access (since the documentation states that it's not necessarily multiuser)?
17:10:27 <Takyoji> It's probably not a serious project, might not even come to fruition as it's merely an idea. But I'd like to have some sort of mobile financing app that's useful, with an open format.
17:11:57 <Takyoji> It's very challenging to me to use an accounting program, when I have to keep things in my head, and enter them later when I'm home in front of a workstation.
17:19:15 <Takyoji> Anyway, my vision for my little app would be mainly for 'lazy' entry. As in, I could go to the store, buy something, and just say I spent 123.45, and fill in a description and other things later when I have time. Or have something to recording time on a project. And when creating an invoice, I can choose from 'untagged' expenses/hours that were entered earlier.
17:19:21 <Takyoji> Anyway, just an idea
17:19:37 *** warlord has joined #gnucash
17:19:37 *** gncbot sets mode: +o warlord
18:09:55 <fell> Takyoji: did you see https://play.google.com/store/apps/details?id=org.gnucash.android ?
18:27:01 <Takyoji> I noticed it after my spiel; although, it sounds like it works solely from importing/exporting files between GnuCash, rather than something that can connect to a central GnuCash SQL DB or similar
19:09:21 *** Anton has joined #gnucash
19:10:42 *** Anton_ has quit IRC
20:01:59 <xyst> fell: that's one of the pages I've read - but I don't want to have to enter the value (so not a variable?) and it's not already in fin.scm
20:05:05 <fell> You could enter something like A1, A2, Tax=A1+A2*0.13. Then, when creating the txn, it will ask for A1 and A2.
20:05:58 <xyst> A1 and A2 are relatively static, I don't want them to be asked for every time
20:06:13 <xyst> it'd be nice if I could say, enter A1, and then it would *become* a variable
20:08:57 <fell> If they are relative constant, use fix amount and review the txn on creation. You can use algebraic operations also whe entering data.
20:10:19 <xyst> perhaps an example: http://cl.ly/image/1E3R3D052P0q
20:10:33 <xyst> 22.23 is just 0.13 * (rest of the column)
20:11:18 <xyst> it'd be cool if I could make it that as a formula. if rent goes up I have to adjust one number
20:17:00 *** StuM has joined #gnucash
20:22:44 *** ErKa has joined #gnucash
20:29:55 <fell> xyst: just one idea: add getter functions for the amounts e.g. to fin.scm
20:35:35 *** ErKa has quit IRC
20:36:58 <fell> Takoji: http://wiki.gnucash.org/wiki/FAQ#Q:_Can_I_open_my_GnuCash_SQL_database_with_another_program.2C_perhaps_Microsoft_Access.3F
20:38:43 <fell> But You should not write in another way as documeted in http://cvs.gnucash.org/docs/HEAD/
20:40:43 <fell> Eventually you could use http://wiki.gnucash.org/wiki/Python_Bindings
20:44:31 <fell> Takyoji
20:52:18 *** john has quit IRC
21:38:35 *** nafg has joined #gnucash
21:40:45 *** fell_ has joined #gnucash
21:40:46 *** gncbot sets mode: +o fell_
21:46:14 *** StuM1 has joined #gnucash
21:47:12 *** StuM has quit IRC
21:49:42 *** fell has quit IRC
23:44:23 *** shaun has quit IRC
23:45:04 *** shaun has joined #gnucash
23:50:20 *** TradeBorG2 has joined #gnucash
23:55:52 *** nafg_ has joined #gnucash
23:57:23 *** TradeBorG has quit IRC