2013-03-28 GnuCash IRC logs
00:32:09 *** arrainey has joined #gnucash
00:38:12 *** arrainey has quit IRC
00:48:35 *** fell__ has quit IRC
02:03:24 *** StuM1 has quit IRC
02:47:16 *** ErKa has quit IRC
03:05:33 *** DanC has quit IRC
03:17:06 *** DanC has joined #gnucash
03:58:13 *** calbasi has joined #gnucash
04:06:34 *** calbasi has left #gnucash
04:22:06 *** Topcat has joined #gnucash
04:27:10 *** Topcat has quit IRC
04:27:32 *** Topcat has joined #gnucash
04:32:38 *** Topcat has quit IRC
04:33:29 *** Topcat has joined #gnucash
04:43:36 *** Topcat has quit IRC
04:43:59 *** Topcat has joined #gnucash
04:49:01 *** Topcat has quit IRC
04:49:23 *** Topcat has joined #gnucash
04:54:27 *** Topcat has quit IRC
04:55:00 *** Topcat has joined #gnucash
05:02:54 *** aqua___ has joined #gnucash
05:25:16 *** Topcat has quit IRC
05:25:38 *** Topcat has joined #gnucash
05:28:35 *** aqua___ has quit IRC
05:35:45 *** Topcat has quit IRC
06:23:24 *** aqua___ has joined #gnucash
06:41:04 *** Jimraehl has left #gnucash
06:56:07 *** fabior has joined #gnucash
06:59:25 *** aqua___ has quit IRC
07:06:27 *** aqua___ has joined #gnucash
07:07:53 *** Topcat has joined #gnucash
07:08:57 *** Jimraehl has joined #gnucash
07:18:05 *** Topcat has quit IRC
07:18:27 *** Topcat has joined #gnucash
07:23:26 *** Topcat has quit IRC
07:23:42 *** fell__ has joined #gnucash
07:23:43 *** gncbot sets mode: +o fell__
07:23:49 *** Topcat has joined #gnucash
07:28:48 *** Topcat has quit IRC
07:29:25 *** Topcat has joined #gnucash
07:34:24 *** Topcat has quit IRC
07:34:57 *** Topcat has joined #gnucash
07:39:57 *** Topcat has quit IRC
07:40:19 *** Topcat has joined #gnucash
07:45:08 *** aqua___ has quit IRC
07:49:00 *** nodje has quit IRC
07:59:33 *** Topcat has quit IRC
07:59:55 *** Topcat has joined #gnucash
08:04:54 *** Topcat has quit IRC
08:05:17 *** Topcat has joined #gnucash
08:10:16 *** Topcat has quit IRC
08:10:40 *** Topcat has joined #gnucash
08:15:39 *** Topcat has quit IRC
08:16:02 *** Topcat has joined #gnucash
08:21:01 *** Topcat has quit IRC
08:21:43 *** Topcat has joined #gnucash
08:26:41 *** Topcat has quit IRC
08:27:04 *** Topcat has joined #gnucash
08:32:02 *** Topcat has quit IRC
08:32:25 *** Topcat has joined #gnucash
08:37:25 *** Topcat has quit IRC
08:37:48 *** Topcat has joined #gnucash
08:52:54 *** Topcat has quit IRC
09:10:40 *** Topcat has joined #gnucash
09:15:45 *** Topcat has quit IRC
09:16:12 *** ErKa has joined #gnucash
09:16:29 *** Topcat has joined #gnucash
09:21:33 *** Topcat has quit IRC
09:21:55 *** Topcat has joined #gnucash
09:23:45 *** aqua___ has joined #gnucash
09:32:00 *** Topcat has quit IRC
09:32:23 *** Topcat has joined #gnucash
09:33:05 *** fabior has quit IRC
09:42:31 *** Topcat has quit IRC
09:42:53 *** Topcat has joined #gnucash
10:13:46 *** slidesinger has joined #gnucash
10:14:17 *** aqua___ has quit IRC
10:21:12 *** aqua___ has joined #gnucash
10:38:54 *** Topcat has quit IRC
10:39:35 *** Topcat has joined #gnucash
10:45:29 *** fabior has joined #gnucash
10:58:20 *** Jimraehl has quit IRC
11:04:42 *** Topcat has quit IRC
11:11:07 *** benoitg has joined #gnucash
12:47:18 *** Topcat has joined #gnucash
12:52:16 *** fabior has quit IRC
12:56:18 *** Topcat1 has joined #gnucash
13:01:19 *** Topcat1 has quit IRC
13:01:29 *** Topcat has quit IRC
13:01:41 *** Topcat has joined #gnucash
13:02:11 *** whitc has joined #gnucash
13:11:45 *** Topcat has quit IRC
13:18:46 *** ErKa has quit IRC
13:21:33 *** benoitg has quit IRC
13:21:35 *** whitc has left #gnucash
13:31:38 *** aqua___ has quit IRC
13:46:11 *** gpeangel has joined #gnucash
13:48:53 <gpeangel> I've gnucash setup to use mysql and working fine no both a linux box and a win7 box (db on a remote server). Problem is, win7 keeps prompting me for the db user password on startup, whereas the linux box does not. Any suggestions for how I can store the db password on the win7 box?
13:49:12 <gpeangel> "no both" == "on both"
13:58:58 *** calbasi has joined #gnucash
14:06:37 *** Topcat has joined #gnucash
14:10:06 <warlord> I'm surprised the linux box doesn't ask you, too, honestly.
14:16:43 *** Topcat has quit IRC
14:17:05 *** Topcat has joined #gnucash
14:22:56 *** ErKa has joined #gnucash
14:32:32 *** Topcat has quit IRC
14:32:43 *** ErKa has quit IRC
14:33:06 *** Topcat has joined #gnucash
14:38:10 *** Topcat has quit IRC
14:38:33 *** Topcat has joined #gnucash
14:39:31 *** ErKa has joined #gnucash
14:59:27 <gpeangel> @warlord I'm puzzled by that, too.
14:59:27 <gncbot> gpeangel: Error: "warlord" is not a valid command.
15:00:18 <gpeangel> I would assume I'd have to find a solution for persisting the password on both boxes.
15:00:51 <gpeangel> The linux box login remains intact even after reboot the system.
15:01:54 <warlord> Oh, maybe it's using the gnome keybox
15:13:17 <warlord> (er, keyring)
15:19:18 *** Topcat has quit IRC
15:19:41 *** Topcat has joined #gnucash
15:35:18 *** Topcat has quit IRC
15:35:50 *** Topcat has joined #gnucash
15:45:59 *** Topcat has quit IRC
15:46:21 *** Topcat has joined #gnucash
15:56:26 *** Topcat has quit IRC
15:56:49 *** Topcat has joined #gnucash
16:01:51 *** Topcat has quit IRC
16:02:13 *** Topcat has joined #gnucash
16:05:27 *** calbasi has left #gnucash
16:22:34 *** Topcat has quit IRC
16:23:06 *** Topcat has joined #gnucash
16:25:15 *** aqua___ has joined #gnucash
16:28:23 *** a has joined #gnucash
16:29:47 <gpeangel> I'll check the keyring.
16:30:06 <a> Hello people I have a problem with importing QFX files to my gnucash account. importing QIF there is no problem, but QFX works strangely. Actually the best would be to read a detailed "howto". Where could I find it?
16:35:14 *** Topcat has quit IRC
16:35:53 *** Topcat has joined #gnucash
16:45:37 <warlord> a: what happens when you try?
16:45:56 <warlord> gpeangel: I suspect that's what is going on -- and of course there is no "gnome keyring" on windows.
16:47:06 *** Topcat has quit IRC
16:51:37 *** aqua___ has quit IRC
16:52:11 *** aqua___ has joined #gnucash
16:53:33 <a> warlord: it seems to work, there are dialogs asking me to create new accounts (this is about investment accounts, stocks etc) but in the end the expenses are placed in inappropriate accounts, and what is the most strange - the purchase of a stock does not lead to the change in the amount of cash.
16:57:06 <warlord> Where did you tell it to buy from?
16:57:18 <warlord> ... what "other account" did you specify during the import?
17:02:07 <a> it asked me to creat a new account - gnucash suggested a "bank" type account - I did it
17:02:48 <a> Actually I did not tell it to buy the stock - (f I do the procedure manually there is no problem )
17:03:10 <a> it loads the QFX file which contains already all the info
17:03:53 <warlord> right, but during the import did you go through each transaction to assign the 'other' account to each transaction?
17:07:29 <a> yes, I did what it asked me for. If you have some more time I am willing to repeat the procedure and report it step by step - OK?
17:08:43 <a> (this is a small report :)
17:10:11 <a> so I created a new Gnucash file - with common assets and investment assets (USD)
17:11:07 <a> now I am importing the QFX which contains only 1 transaction for the period
17:12:31 <a> now it asks me to select commodity to match the following exchange specific code - this is for the stocks which were in the portfolio already and did not move - is this ok?
17:13:36 <warlord> I believe so. It's at the transaction matching step
17:14:00 <a> just 1 sec - I will create these stock-accounts
17:14:35 *** shanny has joined #gnucash
17:14:55 *** Krzysiek_K has joined #gnucash
17:15:02 <a> each time i click "new" then enter the code suggested, Ok - and continue - these are the stocks which will not move
17:15:17 *** Krzysiek_K has left #gnucash
17:16:18 *** aqua___ has quit IRC
17:16:45 <a> ok now it says: please select or create an appropriate Gcash account for "Unknown OFX investment account blabla...
17:16:46 <warlord> a: I don't import anything, so I'm doing this all from memory ...
17:17:34 <a> so I guess I create a new one??
17:18:09 <warlord> I think it asks for two accounts, one which is the 'stock' account, and one which is the 'brokerage' account from which it will buy/sell. at least I think that is what the importer is trying to do.
17:20:04 <a> for the moment he asks about ONE account - select or create -
17:20:38 <a> when i click on New account - he suggests a BANK type account
17:20:50 <a> as a new Top level - but i think I can change this
17:22:09 <warlord> It asks for one at a time..
17:23:23 <a> OK so I created it - an investment account named "Unknown OFX investment acount - this is a Bank account
17:24:21 <a> i select it, say Ok, then indeed he askls select/create an appropr accout for Stock A
17:24:45 <a> so I guess I create it inside the newly created incvestment account?
17:25:24 <warlord> sure.
17:26:45 <a> note BTW that it does not ask to create a cash account in this brand new "unknown" --
17:27:14 <a> I say OK
17:27:43 <a> now "the list of downloaded transactions " appears
17:27:46 <warlord> I think the 'unknown' *is* the Cash account.
17:27:55 <warlord> (I think -- I dont know)
17:28:06 <a> NO! the unknown was the BANK account, and there was no choice
17:28:23 <warlord> Okay, now for each account, on the right side, doubleclick to check/assign the account.
17:28:29 <warlord> Well, in this case Cash == Bank
17:28:50 <a> there is 1 transaction, ok ,
17:29:21 <a> you neam check and repair??
17:29:26 <warlord> ??
17:29:29 <a> (i do not know what it would mean)
17:29:34 <a> sorru mean
17:29:42 <warlord> check & repair?
17:29:58 <a> sorry I did not underastand what you say
17:30:56 <warlord> Because I mistyped. I should have said: Okay, now for each TRANSACTION, on the right side, doubleclick to check/assign the account.
17:31:41 <a> Oh I see - he does not suggest this - he says - new, already balanced
17:32:15 <a> but there is smth new now - the transaction was a short sell
17:32:24 <a> so I have this shorting
17:32:44 <warlord> I dont know if the importer handles that specifically.
17:32:58 <a> and in the "unknown investment acc" I have "the DEPOSIT of the correct sum
17:33:21 <a> however the balance is ZERO
17:33:25 <warlord> Here's a better question for you: what transaction does get created?
17:33:40 <warlord> Can you show a screen shot of the transaction from both ends?
17:33:51 <warlord> (you can use something like imagebin to post it)
17:34:41 <a> warlord - it works !!!
17:35:03 <a> )) thanks a lot - just when I said OK for the transaction - it did the job
17:35:35 <warlord> okay, so what did you do differently this time?
17:36:03 <a> err - good question ))
17:36:38 <a> i guess the accounts were assigned correctly
17:37:08 <warlord> okay
17:37:22 <a> and you were right - there were two of them I did not pay attention to this.
17:37:50 <a> Thanks ! it can save me a heap of time - at present I am doing all by hand
17:38:34 <warlord> Good luck. (me, I enter everything in by hand)
17:39:42 <a> I would have nothing against this - but there are also many fees and stuff
17:40:44 <a> ah! by the way - it did not enter the commission
17:41:14 <a> but this is another story )) it is fine for today ) thanks a lot
17:41:24 <warlord> OFX/QFX does not support split transactions..
17:41:35 <a> BTW - what do you think - will it go UP or crash?
17:41:39 <warlord> (I'm not sure how the commission would be encoded in the OFX/QFX)
17:41:49 <warlord> which stock?
17:41:51 <a> i mean SP500
17:42:26 <a> it got its 4-bucks-over-the-record )
17:43:07 <a> i do not see the commission indeed
17:43:52 <a> but never mind i can do this manually
17:44:19 <warlord> Oh, I have no idea.. I've got some investments in an SP500 Index.
17:45:55 <a> Okay thanks for the help - see you
17:46:04 <warlord> Enjoy
17:46:49 <a> have a nice day (here it is a night)
17:47:26 *** benoitg has joined #gnucash
17:48:04 *** a has quit IRC
18:01:01 *** fell has joined #gnucash
18:01:01 *** gncbot sets mode: +o fell
18:10:00 *** fell__ has quit IRC
18:47:48 *** rpg_ has quit IRC
18:58:59 *** benoitg has quit IRC
19:00:38 *** benoitg has joined #gnucash
19:03:45 *** fell_ has joined #gnucash
19:03:46 *** gncbot sets mode: +o fell_
19:12:41 *** fell has quit IRC
19:48:40 <gpeangel> warlord: Yep, gnome's keyring is letting me log right into gnucash. Doesn't seem to be anything comparable on win7. The win credentials don't work the way the keyring does.
20:11:25 *** mikee_ has joined #gnucash
20:16:36 *** mikee has quit IRC
20:16:40 *** Jimraehl has joined #gnucash
20:45:29 <warlord> gpeangel: guess not.
20:55:01 *** Jimraehl has left #gnucash
21:04:12 *** Jimraehl has joined #gnucash
21:10:23 *** calbasi has joined #gnucash
21:29:44 *** ErKa has quit IRC
21:59:21 *** calbasi has quit IRC
22:10:59 *** ErKa has joined #gnucash
23:08:36 *** kpreid has quit IRC
23:09:01 *** kpreid has joined #gnucash
23:16:00 *** gpeangel has quit IRC