2011-09-01 GnuCash IRC logs

03:33:50 *** kpreid has quit IRC
03:34:58 *** Gokee2 has quit IRC
03:35:44 *** kpreid has joined #gnucash
03:35:49 *** Gokee2 has joined #gnucash
03:55:49 *** ErKa has joined #gnucash
04:46:31 *** Silly has quit IRC
04:47:03 *** Silly has joined #gnucash
04:52:18 *** linas__ has quit IRC
04:53:05 *** JasonBox has quit IRC
05:00:16 *** JasonBoxLaptop has quit IRC
05:00:21 *** linas__ has joined #gnucash
05:13:07 *** JasonBoxLaptop has joined #gnucash
05:38:59 *** JasonBox has joined #gnucash
07:05:54 *** ErKa has quit IRC
07:20:26 *** warlord-afk is now known as warlord
07:20:28 <warlord> @op linas__
07:20:28 *** gncbot sets mode: +o linas__
08:05:13 *** Jimraehl2 has left #gnucash
08:16:44 *** Jimraehl2 has joined #gnucash
08:18:11 *** fbond has joined #gnucash
08:43:55 <JasonBoxLaptop> hrm, when prompted to save my pin for online banking, is it stored securely?
09:33:52 *** JasonBoxLaptop has quit IRC
09:55:26 *** ErKa has joined #gnucash
10:05:35 *** ihf has joined #gnucash
10:06:06 <ihf> I am trying to open a gnucash sqlite file with Sqlite manager and I get:
10:06:08 <ihf> SQLiteManager: Error in opening file finance.gnucash - either the file is encrypted or corrupt
10:06:08 <ihf> Exception Name: NS_ERROR_FILE_CORRUPTED
10:06:08 <ihf> Exception Message: Component returned failure code: 0x8052000b (NS_ERROR_FILE_CORRUPTED) [mozIStorageService.openUnsharedDatabase]
10:06:16 <ihf> any idea what the problem could be?
10:45:30 <warlord> JasonBox: probably not.
10:45:54 <warlord> ihf: are you sure it's a SQLIte DB?
10:53:59 *** ErKa has quit IRC
10:58:47 <ihf> warlord, I believe it is. I opened in in Textedit and it is certainly not XML. I tried moving the file to another machine running GC and I have the same problem although the file opens fine in GC.
10:59:08 <ihf> a different GC file opens fine in sqlite manager
10:59:31 <ihf> it is as if it is in fact corrupted somehow
10:59:51 <warlord> ihf: note that gnucash by default compresses the xml..
11:00:04 <warlord> Are you sure it's not compressed xml?
11:04:10 <ihf> no, how can I tell if it is sqllite and not comp. xml?
11:04:57 <ihf> i think it is comp xml! How can I change it to sqlite?
11:05:24 <ihf> is there an easy way?
11:08:53 *** markjenkinsparit has joined #gnucash
11:11:30 <warlord> "file /path/to/file.gnucash"
11:11:58 <ihf> nm, Save as did the trick.
11:12:22 <ihf> duh
11:18:13 <warlord> heh
11:28:28 *** ErKa has joined #gnucash
11:46:11 *** rpg has joined #gnucash
11:46:46 *** ihf has quit IRC
13:32:20 *** smw_ has quit IRC
14:31:16 *** syn2fin has joined #gnucash
14:35:22 *** smw has joined #gnucash
14:36:08 <syn2fin> Is there a good way to backfill transactions after one starts using gnucash? For example, I recently took my current assets and set that as my starting point a week past, and I have added items since, but I would also like to fill in transactions from before the day I started using gnucash without affecting the starting balances at that point.
14:43:26 <warlord> syn2fin: it's possible, but a LOT of work to do that.
14:43:46 <warlord> As you add more transactions you effectively have to reset your starting balance to "before" your "new" (old) transactions
14:45:36 <syn2fin> I was afraid of that. I was hoping there would be a way to lock the value of all assets and liabilities at a particular point as I add prior transactions for the purposes of flushing out budget pie charts.
14:45:44 <syn2fin> thank you
14:46:24 <warlord> Nope.
15:07:20 *** rpg has quit IRC
15:09:27 <warlord> (and you're welcome)
15:37:27 *** Krzysiek_K has joined #gnucash
15:37:42 *** Krzysiek_K has left #gnucash
15:51:15 *** kpreid has quit IRC
16:00:22 *** kpreid has joined #gnucash
16:32:52 *** kpreid has quit IRC
16:33:33 *** kpreid has joined #gnucash
16:58:25 *** kpreid has quit IRC
17:03:52 *** theozaurus has joined #gnucash
17:06:40 <theozaurus> Hi, just importing all my bank details into Gnucash. Can anyone explain to me how I should handle 2 accounts. 1 joint account, and 1 current account. I regularly transfer money from one to the other. I've downloaded the bank statements for both. However, when ever I click on a transaction in the current account that transfers money to the joint account and change it from Imbalance-GBP to Assets::Current Assets::Joint Account it create
17:06:55 <theozaurus> In short, how do I link the transactions without creating new ones?
17:09:19 <warlord> theozaurus: your first message stopped after "from Imbalance-GBP to Assets::Current Assets::Joint Account it create"
17:10:39 <warlord> But I'm not sure what you mean by "creating new ones"? It sounds like you're not properly assigning the double-entry "far" account during the import, so the importer isn't recognizing the duplicate. As a result you ARE getting two transactions imported.
17:11:08 <warlord> Instead, during the import you should assign appropriate destination accounts, and then tell the importer that it's a dup.
17:11:11 <warlord> Is this QIF?
17:33:01 *** theozaurus has quit IRC
17:47:54 *** kpreid has joined #gnucash
18:19:09 *** theozaurus has joined #gnucash
18:27:12 <theozaurus> warlord: I import 2 OFX files, 1 for each account from Natwest. Are you saying that it should be possible on import to tally up debit from one account to the credit on the other account automatically?
18:30:10 <warlord> Well, when you import the first bank you need to assign the transaction to the second bank, and then when you import from the second bank you will need to mark it as a duplicate
18:31:28 <theozaurus> ah okay. so now I just go through and specify the right destination for each transaction. Then scan through and mark the duplicates
18:33:51 <warlord> During the import, yes.
18:33:58 <warlord> After the import it's a little more difficult, but still doable.
18:35:35 <theozaurus> do i just delete the non linked transactions?
18:35:51 <warlord> Yes, you will need to manually delete the already imported duplicate transactions.
18:50:00 *** fbond has quit IRC
18:57:30 <theozaurus> cheers
19:07:07 *** theozaurus has quit IRC
20:07:56 *** JasonBoxLaptop has joined #gnucash
20:07:57 *** wizkid238 has quit IRC
20:10:44 *** wizkid238 has joined #gnucash
20:51:07 <JasonBoxLaptop> What might the logic for say an income & expense report look like?
21:05:12 <warlord> I think how I would do it is for each selected account compute the account balance at the start and end of the period, compute the difference.
21:06:02 <JasonBoxLaptop> hrm
21:06:14 <warlord> Why?
21:06:35 <JasonBoxLaptop> Looking for an excuse to try out ExtJS 4's new charting and graphing components
21:06:42 <JasonBoxLaptop> Thought I'd feed them gnucash data
21:06:57 <warlord> oh.
21:28:32 *** Jimraehl2 has left #gnucash
21:36:49 *** Jimraehl2 has joined #gnucash
23:06:48 *** warlord is now known as warlord-afk
23:33:37 *** slidesinger1 has quit IRC