2011-10-23 GnuCash IRC logs

01:13:14 *** ErKa has joined #gnucash
02:09:34 *** erik_ has quit IRC
02:11:03 *** zeroedout has joined #gnucash
02:19:30 *** ErKa has quit IRC
02:40:31 *** ErKa has joined #gnucash
04:08:06 *** ErKa has quit IRC
05:06:00 *** arbortender has joined #gnucash
05:14:49 *** ironwolf1 has quit IRC
05:24:10 *** ironwolf1 has joined #gnucash
05:34:08 <arbortender> What's the best way to export the account structure and then import it back into a fresh datafile for a separate year? I tried the xml export but got an empty file.
05:46:54 *** puggan has joined #gnucash
05:48:37 <puggan> how do i debug an error message like "The server at URL mysql://gnucash_puggan@puggan.se/gnucash_puggan experienced an error or encountered bad or corrupt data.", tried "gnucash.exe --debug" but got no output at all
05:53:55 <puggan> have tested the database with "SELECT tx_guid, SUM(value_num), SUM(quantity_num) FROM splits GROUP BY tx_guid HAVING NOT SUM(value_num) = 0" and got no errors, someone got more sql tips that i can try?
06:32:11 *** arbortender has quit IRC
06:35:14 *** arbortender has joined #gnucash
06:42:49 *** matled has left #gnucash
06:54:08 <puggan> oh, found the trace file, and the data is not corrupted, it just have some connection error: "* 10:45:55 CRIT <gnc.backend.dbi> [gnc_dbi_mysql_session_begin()] Unable to connect to database 'gnucash_puggan'"
06:55:29 *** kpreid has quit IRC
06:55:37 <puggan> maybe it got something to do with the warning above "* 10:45:43 WARN <gnc.app-utils> Could not spawn perl: Failed to execute child process (No such file or directory)"
07:07:01 <puggan> Installing perl reomved the warning, but the error messages are still there
07:23:12 <puggan> lol, sorry for bothering you about above, my mysql settings somehow reseted it self, and got bind to 127.0.0.1, and gnucash is the only non local program connecting to it
07:23:41 *** pjama has joined #gnucash
07:36:22 <puggan> now it craches insted: Segmentation fault. #1 0x77c4acfa in msvcrt!localtime () from C:\WINDOWS\system32\msvcrt.dll #8 0x6c9c971b in timegm () from C:\Program Files\gnucash\bin\libdbi-0.dll
07:49:27 *** pjama has left #gnucash
08:12:38 *** fDavid has joined #gnucash
09:01:54 *** Jimraehl2 has left #gnucash
09:12:18 *** Jimraehl2 has joined #gnucash
09:41:26 *** Linuturk has quit IRC
11:35:00 *** puggan is now known as puggan_windows
11:37:10 *** puggan has joined #gnucash
11:37:39 *** puggan_windows has quit IRC
11:47:50 *** fDavid has quit IRC
12:49:18 *** rpg has joined #gnucash
13:34:30 <Joeboy_> Hi. Is doing reports with guile likely to be supported for the foreseeable future? Is it the sensible way to start writing reports?
13:34:35 *** Joeboy_ is now known as Joebo
13:35:14 *** Joebo is now known as Joeboy_
13:45:21 *** ErKa has joined #gnucash
13:45:50 *** fDavid has joined #gnucash
14:06:35 <arbortender> crashing:Problem signature:
14:06:35 <arbortender> Problem Event Name: APPCRASH
14:06:35 <arbortender> Application Name: gnucash.exe
14:06:35 <arbortender> Application Version: 0.0.0.0
14:06:35 <arbortender> Application Timestamp: 4e0ef228
14:06:36 <arbortender> Fault Module Name: ntdll.dll
14:06:38 <arbortender> Fault Module Version: 6.1.7601.17514
14:06:40 <arbortender> Fault Module Timestamp: 4ce7b96e
14:06:42 <arbortender> Exception Code: c00000fd
14:06:44 <arbortender> Exception Offset: 00052c26
14:06:46 <arbortender> OS Version: 6.1.7601.2.1.0.768.3
14:06:48 <arbortender> Locale ID: 1033
14:06:50 <arbortender> Additional Information 1: f84c
14:06:52 <arbortender> Additional Information 2: f84c52250418a01ac7197730b994e996
14:06:54 <arbortender> Additional Information 3: 866f
14:06:56 <arbortender> Additional Information 4: 866f7fce9309e2fdf8ec770362b99445
14:06:58 <arbortender> like 4 crashes. yay!
14:08:28 *** arbortender has left #gnucash
14:57:54 *** sjc has joined #gnucash
14:59:55 *** markjenkinsparit has joined #gnucash
15:02:51 *** markjenkinsparit has quit IRC
15:52:30 *** fDavid has quit IRC
15:54:36 *** esther has joined #gnucash
16:00:44 *** esther has left #gnucash
16:06:55 *** pnema has joined #gnucash
16:15:25 *** pnema has quit IRC
16:18:51 *** pnema has joined #gnucash
17:06:12 *** Guest has joined #gnucash
17:06:13 * Guest - IRC client sponsored by http://www.ImageGenerator.org (Make free graphics online)
17:08:39 <Guest> Hi guys. I think I'm missing a concept. Me and my partner get paid at odd times so we keep cash in a box by the door, to make sure we have some on us at all times... We've got some scheduled stuff we pay out of that too, the problem is that I don't know how to tell GNUCash that it exists.. I think I need a transaction to automatically bring that placeholder account back to 0, pullinmg equal amou8nts from the placeholder accounts
17:09:10 <Guest> Is that somewhat realistic?
17:09:23 <Guest> err... and I have a goofy nick.
17:12:08 <Guest> Hmm, in fact that probably sounds retarded. Let me clear the concept up a little.
17:13:14 *** sorush20 has joined #gnucash
17:14:13 <Guest> 'Account A' -> { 'account b', 'account c' }, 'Account A' has scheduled transactions, washing the cars, delivery tips, etc. This makes the account go negative. I want a scheduled transaction to each week pull half of the negative value of 'Account A' from 'account b' and 'account c', equally.
17:14:22 <Guest> Yeah, that makes a little more sense.
17:15:56 <Guest> Also, I haven't figured out how to change scheduled transactions, are they only created once and never updated? I assumed they would be marked as generated by the scheduler and updated when the scheduled transaction is changed, at least for future transactions.
17:19:45 <Guest> I think I may be in the grey area between scheduled transactions and budgeting... but I'm out of time for today. I'll ask again on the mailing list if I don't figure it out tonight.
17:19:53 *** Guest has quit IRC
17:27:01 *** sorush20 has quit IRC
17:31:21 *** fretegi has joined #gnucash
17:31:28 <fretegi> good afternoon guys
17:33:00 <fretegi> ok been a user of gnucash for a while now and im trying to use it to its full potentional and use it to track my P/L's on investments as well. I have been reading the tutorials on how to do such and trying to get it it working for over 4 hours now and its just not working out. is there a chance someone can walk me through this a bit and try to point out where im going wrong?
17:35:28 <fretegi> basically the net valued never add up as they should
17:36:58 <fretegi> damn it, eur gapped down 50 pips
17:38:00 <fretegi> damn knew shoulda shorted into the w/e hehe
17:38:09 <fretegi> wrong room sorry
17:54:00 <puggan> You 2 at least got it working, my windows version crashes at loading the data, and on linux i gets libraries errors "gnucash: error while loading shared libraries: libgncmod-ledger-core.so: cannot open shared object file: No such file or directory"
17:54:26 <fretegi> puggan, what distro of linux?
17:55:15 <fretegi> i cant help you much troubleshooting windows, i hate that os lol, but, i do have version 2.2.9 running under win 7 just fine
18:08:26 *** sorush20 has joined #gnucash
18:17:18 *** warlord has joined #gnucash
18:17:18 *** gncbot sets mode: +o warlord
18:38:54 <fretegi> ok been a user of gnucash for a while now and im trying to use it to its full potentional and use it to track my P/L's on investments as well. I have been reading the tutorials on how to do such and trying to get it it working for over 4 hours now and its just not working out. is there a chance someone can walk me through this a bit and try to point out where im going wrong?
18:48:05 *** puggan has quit IRC
18:56:26 *** puggan has joined #gnucash
19:04:22 <fretegi> puggan, any luck yet? what disto are you running?
19:17:11 *** yakumo has joined #gnucash
19:24:32 *** fbond has joined #gnucash
19:33:58 *** pnema has quit IRC
20:02:30 <fretegi> what is profit with to amount = 0 mean?
20:02:30 *** sorush20 has quit IRC
20:03:05 <fretegi> thast the part i cannot get right, the math is always screwed up on my investments, other than that i got gnucash all figured out and love it
20:13:24 *** fDavid has joined #gnucash
20:20:39 *** sorush20 has joined #gnucash
20:22:12 *** sjc has quit IRC
20:29:32 *** arnotixe has joined #gnucash
20:56:27 *** pnema has joined #gnucash
21:22:53 *** sorush20 has quit IRC
21:31:57 *** arnotixe has quit IRC
21:38:53 *** pnema has quit IRC
21:40:18 *** pnema has joined #gnucash
21:46:17 *** ErKa has quit IRC
21:57:31 *** fbond has quit IRC
22:09:44 *** fDavid has quit IRC
22:34:45 *** pnema has quit IRC
22:35:40 *** warlord is now known as warlord-afk