2008-05-10 GnuCash IRC logs
01:11:19 *** terdmonk has quit IRC
03:12:31 *** ErKa has joined #gnucash
04:44:16 *** joerlend_ has joined #GnuCash
04:52:58 *** XiXaQ has quit IRC
05:48:15 *** cortana has joined #gnucash
06:51:43 *** kling0n has joined #gnucash
07:26:19 *** aindilis` has quit IRC
07:27:56 *** aindilis` has joined #gnucash
07:38:14 *** aindilis` has quit IRC
07:40:55 *** aindilis` has joined #gnucash
07:51:54 *** aindilis` has quit IRC
07:55:22 *** aindilis` has joined #gnucash
08:35:44 *** localhos1 has quit IRC
09:08:08 *** warlord-afk is now known as warlord
09:45:02 *** kielein has joined #gnucash
10:49:44 *** cortana has quit IRC
11:06:58 *** Zoolooc__ has quit IRC
11:07:17 *** Zoolooc has joined #gnucash
11:49:24 *** |gunni| has joined #gnucash
11:58:13 *** kling0n has quit IRC
11:58:15 *** _gunni_ has quit IRC
12:17:41 <warlord> .
12:28:53 *** warlord is now known as warlord-afk
12:48:40 *** jcreigh has joined #gnucash
12:58:21 *** kling0n has joined #gnucash
13:02:21 *** ErKa has quit IRC
13:16:13 *** aindilis` has quit IRC
13:18:35 *** jcreigh has quit IRC
13:44:48 *** ErKa has joined #gnucash
14:03:55 *** NeilR has joined #gnucash
14:04:15 <NeilR> Good [morning|afternoon|evening].
14:05:00 <NeilR> I'm a newbie having a data-loss problem: sometime yesterday all records since mid-December have disappeared, and I don't know why or how to get them back without re-entering everything.
14:05:35 <NeilR> I assume from the 30-days-of-logs that there's a record of all activities, but when I tried to 'import' the log files nothing visible happened.
14:05:52 <NeilR> Any suggestions on how to roll-back to before the data "went away" would be appreciated. Thank you.
14:12:23 <warlord-afk> NeilR: Are you sure that you didn't accidentally File -> Open a backup file?
14:12:28 *** warlord-afk is now known as warlord
14:14:07 <NeilR> Fairly sure: I've re-opened it a few times. Additionally, I wasn't using the program in December (I just started less than a month ago) so any import should have had at least through March.
14:14:56 <NeilR> (IOW, there should have been no backup that contained only that set of data.)
14:15:38 <warlord> well, you could "ls -l" in your data file directory and see the dates on the .xac (backup) files as well as the data file itself.
14:17:36 <NeilR> The oldest XAC is from April 28 (I installed it on 4/24); the other XACs have dates through yesterday.
14:26:16 <NeilR> *ding* Light bulb goes on
14:29:09 <warlord> The .xac files are all backup files.
14:29:15 <warlord> (questions the light bulb)
14:29:51 <NeilR> Ok, I was able to open the last XAC and it's got all the data, but when I try to re-save it as the main file I get 'could not make backup of [file]'
14:30:25 <NeilR> (The lightbulb was the realization that I could probably open the .xac directly, without having to import or convert or wave dead chickens)
14:30:55 <NeilR> Hmm, it's not letting me save to that folder...
14:31:27 <NeilR> ah, but I *can* save somewhere else.
14:32:35 <warlord> File permissions>
14:32:36 <warlord> ?
14:32:39 <warlord> Directory permissions?
14:32:42 <warlord> Disk full?
14:32:43 <NeilR> Ok, looks like there may have been an old gconfd-2 process blocking access..
14:32:52 <warlord> That's.... odd.
14:32:57 * NeilR shrugs "That's Windows.."
14:33:25 <warlord> OH! Windows. I guess I need to really start asking "what OS/Distro" early on..
14:33:46 <NeilR> Plus, my data file is on a TrueCrypt partition that dismounts after inactivity; maybe it got fouled earlier when it dismounted and then tried to save, or...*shrug*
14:34:01 <warlord> that could be it.
14:34:11 <NeilR> (Esp. 'cause I get intermittent messages about being unable to obtain the lock for files...))
14:34:44 <warlord> note that gnucash tries to re-open the last-opened data file when it starts. If TruCrypt isn't running then you'd get errors
14:34:53 <NeilR> ...Although it's not auto-dismounting anymore, and I'm still getting 'could not obtain lock' for the *previous* file I had open...
14:35:07 <NeilR> Yeah, I noticed that too; I just mounted the disk and then opened the file, everything would seem to work fine.
14:35:16 <warlord> "trucrypt sucks"?
14:36:12 <NeilR> mm? No, I wouldn't say that: it's doing exactly what I told it to do ("Force dismount.") I turned of auto-dismount though, and I'm confused why GnuCash is trying to open the file-I-had-open-before-the-most-recent one.
14:36:46 <NeilR> oops! Food burning, brb afk
14:36:49 <warlord> because gconf got confused?
14:37:56 <NeilR> Not sure why/what...I had 'kill -9' both GCONF then relaunched a few times, so it should be a clean instance now. (I hope... ;-)
14:38:58 <warlord> Maybe. Unless it can't store it's data file? *shrugs*
14:38:58 <NeilR> hmm, still can't overwrite the last-saved-version... Is there an explicit `file is locked' message, or is it generic `could not make a backup' ?
14:39:00 <warlord> Windows is weird.
14:39:28 <warlord> Could not make backup means that it cannot create a new file in the directory.
14:39:35 <warlord> What's the error you see?
14:39:37 <NeilR> ah, must the the file lock ('cause I can see a .LCK file in the folder.. ;-)
14:39:50 <warlord> Nah, that's only an issue during startup.
14:40:41 <NeilR> But that file *isn't* open, so it shouldn't have a .LCK file..
14:41:20 <NeilR> >nani??< I closed GC and the lock file went away..! ?_?
14:42:01 <NeilR> Lemme check something..
14:42:02 <warlord> Well, then.. that's the file it has open.
14:44:03 <NeilR> Aah, I see: I open `recovered', then SAVE AS the original; it makes the LCK file for the but gives an error.
14:44:31 <warlord> Yeah, it makes the LCK first.
14:44:40 <NeilR> Lemme run chkdsk on the TC 'drive'..
14:45:22 <NeilR> hmm, no errors in the filesystem...
14:45:31 <NeilR> *doh*! Drive full. :-p
14:45:46 <warlord> Didn't I ask that already?
14:46:08 <warlord> (I was certainly thinking it)
14:46:09 <NeilR> Yeah, you did; I thought this was a 650MB drive, but apparently I was silly and made it 5mb.
14:47:08 <NeilR> ooh-kay, I think we've got that fixed. *sheepish grin*
14:47:09 <warlord> Oh. OOPS.
14:47:36 <NeilR> (I have *no* idea why I did that; I've got 5 other TC files and they're all 650MB for a *reason*...
14:47:51 *** ErKa has quit IRC
14:47:55 <NeilR> I'll move stuff over and all should be good.
14:48:01 <NeilR> Thanks bunches for the info about the filetypes!
14:48:07 <warlord> NP.
14:48:38 *** NeilR has left #gnucash
14:49:29 *** jcreigh has joined #gnucash
15:04:07 *** sjc has joined #gnucash
15:31:00 *** |McLANE| has quit IRC
16:02:16 *** cortana has joined #gnucash
16:12:03 *** kling0n has quit IRC
16:23:17 *** cortana has quit IRC
16:42:13 *** andi5 has joined #gnucash
16:42:13 *** gncbot sets mode: +o andi5
17:43:17 *** kielein has quit IRC
17:53:52 *** Zoolooc has quit IRC
18:06:13 <warlord> hi andi5
18:07:04 <andi5> hiho warlord!
18:07:15 <warlord> how is your saturday?
18:07:25 <andi5> it is over, mainly
18:07:44 <andi5> but my 8 minute sunday is great so far :)
18:07:52 <warlord> haha. true.
18:09:23 <andi5> long weekend, no work on monday because of pentecost :)
18:09:43 <warlord> so lots of time to hack on gnucash! :)
18:10:52 <andi5> i will have to solve this aqbanking3 transaction thingie some day.... so i hope to invest some time and at least get some consensus on how to implement collective transfers on gnucash-de
18:11:05 <warlord> 'k
18:12:34 <andi5> other than that i will continued playing with kvm... whenever the aq3 port is ready, i will reinforce this whole cross-compiling issue
18:12:44 <andi5> i have continued, i mean
18:13:30 <warlord> ok..
18:13:37 <andi5> how are you?
18:13:57 <warlord> could you look into the complaint about the reconcile auto-interest account choice?
18:14:02 <warlord> i'm ok.
18:14:13 <warlord> waiting for a guest to arrive.
18:14:33 *** ectospasm has joined #gnucash
18:14:39 <andi5> may you give me a quick link? i did really follow bugs or g-mail recently
18:14:44 <andi5> did not... argh
18:16:06 <ectospasm> I'm having a problem importing QFX files from my bank... it's missing transactions, which are in the QFX file (I can see them if I open the file in vim). Now, it may be user error, but I made sure there were no red lines in the import, or so I thought. This is the second month this has happened... any ideas?
18:17:29 <andi5> ectospasm: qfx has transaction ids, right? do you have id clashes between two different transactions? ... just a wild guess
18:17:54 <ectospasm> Lemme look in the file...
18:18:28 <ectospasm> andi5: I see a <FITID> in the file
18:19:04 <andi5> sounds reasonable
18:19:06 <ectospasm> looks like it's mostly a date, with a two digit counter afterwards...
18:19:56 <andi5> so your older files will probably do not contain that fitid? do you see it when looking at your data file?
18:20:17 <ectospasm> I'll check 'em out... one moment...
18:21:52 <ectospasm> Yeah, my oldest file has <FITID> tags that match the same pattern: YYYYMMDDNN
18:23:03 <andi5> a quick check could be to temporarily change the fitid of a transaction that was not imported and to try importing again
18:24:00 <warlord> andi5: sent to -user today.
18:24:09 <ectospasm> lemme backup my file first...
18:24:31 <andi5> ah, now i see
18:30:28 <andi5> warlord: you wrote "it's correct until you tab out of the Description cell"... what do you mean by "correct" exactly, so what is the expected behavior?
18:31:03 <ectospasm> andi5: Changing that FITID let me import the transaction... but since I had already added it manually, I'm not 100% convinced changing that made a difference...
18:31:43 <warlord> For me, it chooses the correct accounts when it sets up the dialog, but then when I tab out of the description cell the 'from account' changes to the current account. (this happens in a CC payment dialog)
18:32:25 <andi5> ah.... CC payment dialog... i looked at the auto-interest dialog (if it is called that way)
18:32:49 <warlord> i asumed it was the same underlying code.
18:33:03 <warlord> (dialog-xfer)
18:33:16 <andi5> so, what what is the correct account anyway?
18:33:29 <andi5> man, my keyboarding is really bad today
18:33:45 <warlord> The correct account is the "last" account used.. And it does correctly choose that at first.
18:34:01 <andi5> ok, that was what i wanted to hear :)
18:34:43 <andi5> does not work here
18:35:36 <ectospasm> andi5: there are no FITIDs that are repeated in that file... I can check all files...
18:35:55 <andi5> ectospasm: as i said, it was just a wild guess
18:36:29 <warlord> When the dialog comes up the correct account is chosen. But then after I tab out of the description the account changes. Almost as if there's a mismatch in the "from" vs. "to" accounts and it gets reset.
18:36:55 <andi5> you are talking about trunk?
18:36:59 <ectospasm> hrmm... I guess I can try to import the file again into a brand new file, see if it picks up the transactions then...
18:37:01 <warlord> yes
18:37:03 <andi5> ok
18:37:35 <warlord> ectospasm: are there multiple txns with the same FITID in the same file?
18:37:47 <ectospasm> warlord: no
18:38:55 <ectospasm> at least, not with this latest file
18:42:00 <warlord> Generally the main reason a txn isn't imported is because gnucash thinks it's already been imported... something in the same account with the same fitid.
18:42:58 <ectospasm> the fitids for the other transactions should have been different. These were recurring transactions that were missing.
18:43:46 <ectospasm> My bank has a program which I'm in whereby a dollar for every transaction I make gets put into a savings account. It's a royal pain adding the ones that were missed into the account
18:44:01 <ectospasm> ...in gnucash
18:44:29 <andi5> warlord: // XXX: Set "from" account from previous interest payment :-)
18:44:44 <ectospasm> do you think it could be an effect of me having overlapping dates when I generate the file?
18:45:00 <warlord> andi5: even in a CC payment?!?
18:45:03 <andi5> warlord: that is a TODO marker in window-reconcile.c.... i wonder whether you come from the future
18:45:16 <andi5> there are two TODOs, for both cases
18:45:24 <andi5> in sum two... you know
18:45:27 <warlord> But.. the account *IS* being set correctly.
18:45:38 <warlord> but then RESET incorrectly once it gets focus.
18:45:45 <warlord> ectospasm: yep.
18:46:01 <warlord> Overlapping txns will only get imported once.
18:46:10 <andi5> ok... lemme see
18:46:43 <ectospasm> OK, since I imported 20080420-20080510, I should start with 20080511 next time...
18:47:24 <warlord> ectospasm: you don't have to do that. the dates can overlap. gnucash is smart and wont import it a second time.
18:48:07 <warlord> andi5: A simple test: create a CC. make expenses. reconcile. pay. make more expenses. reconcile. pay again. Try to auto-complete the description, then tab out.
18:48:35 <ectospasm> So why gnucash is not adding the transaction is still a mystery for me...
18:48:39 <warlord> I suppose I could try to make a test case file and file a bug report.. But probably not until tomorrow.
18:49:13 <warlord> ectospasm: When you overlap does the same transaction get the same FITID both times?
18:49:35 <ectospasm> I believe so
18:49:35 * warlord only has about 5-10 minutes left to talk here
18:49:40 <warlord> can you check?
18:49:47 <ectospasm> I can...
18:49:49 <warlord> Do you have both OFX files available?
18:53:19 <ectospasm> I'm having trouble identifying the matching lines. I'm using "grep -Hi fitid file1.qfx file2.qfx | sort | uniq -d, and the only duplicates I'm seeing are in file1...
18:57:36 <andi5> warlord: should not http://svn.gnucash.org/trac/browser/gnucash/trunk/src/gnome/window-reconcile.c#L483 be gnc_xfer_dialog_quickfill_from_account?
18:57:57 <warlord> gotta run.. bbl
18:58:00 *** warlord is now known as warlord-afk
19:16:06 *** john has joined #gnucash
19:17:23 <john> How can I copy GC data files from Linux 2.2.4 to Windows 2.2.5? Thx.
19:18:14 <andi5> what is linux 2.2.4 or windows 2.2.5? :-) ... just copy the data file and maybe also the book file in ~/.gnucash/books
19:18:57 <andi5> gnucash 2.2.4 and gnucash 2.2.5 write fully compatible data files
19:19:27 <john> OS and GC version. I copied the data file and it crashes CG. I need the book file, too?
19:20:24 <andi5> what is CG? and on what operating system does it crash, assuming you mean after you opened the file? have you looked into the trace files? (see http://wiki.gnucash.org/wiki/Windows)
19:21:39 *** cortana has joined #gnucash
19:22:37 <john> GC=GnuCash. Sorry about the typo. My fingers are dyslexic >:) It crashes in Windows XP SP3
19:23:37 <andi5> oh... sp3 is out? ... hm.
19:24:13 <john> yeah. sp3 is out, and apparently causing a lot of trouble, tho not yet for me.
19:24:46 <john> I thought, clean install, new sp? and did it.
19:26:16 <andi5> ok... so gnucash crashes? does it that even when you cancel the warning about pending file locks (after restarting after the crash) ... or when you open gnucash with "--nofile" (append that to bin\gnucash.bat
19:28:24 <john> i try to open a new gnucash data file, point at the copied-from-linux data file, then it crashes right away. no messages.
19:28:56 <andi5> no message in the trace files?
19:29:43 <john> haven't yet checked that because i can only see one machine at a time ... i'm swapping the monitor back and forth
19:30:17 <andi5> john: why do not you rejoin from an irc client on windows?
19:30:40 <john> ahh. good idea. see you in a while. thx
19:30:59 *** john has left #gnucash
19:48:56 *** cortana has quit IRC
20:07:44 *** Administrator has joined #gnucash
20:08:32 *** Administrator has left #gnucash
20:17:27 *** John has joined #gnucash
20:18:39 <John> I'm back. No luck finding either a books file on the Linux system nor a trace file on the XP system.
20:19:32 <andi5> books should be in ~/.gnucash/books, the trace files in c:\Documents and Settings\myname\Local Settings\Temp
20:22:22 <John> neither file apparently exists
20:22:54 <John> i'm going to have to take this up again later. i appreciate your help, though.
20:23:10 <andi5> yep, it is quite late here already... see you!
20:23:13 <John> my wife is waiting with her coat on ... we're going to a party.
20:23:32 *** John has left #gnucash
20:23:35 *** andi5 has quit IRC
20:35:55 *** sjc has quit IRC
21:03:43 *** joerlend_ has quit IRC
21:38:41 *** XiXaQ has joined #GnuCash
23:56:57 *** _gunni_ has joined #gnucash