2007-12-31 GnuCash IRC logs
00:00:13 *** _gunni_ has quit IRC
00:11:00 <andrewsw> the problem I see is changing the report-id to something other than the name breaks all existing open reports and saved custom reports.
00:11:05 <andrewsw> :(
00:11:49 <andrewsw> but it's still the right thing to do. I wonder that the work-around is?
00:13:14 <fell> having the id unstranslated is good, else changing LANG would break the opening
00:14:11 <andrewsw> yes. the current situation is better than before. Everyone with non-english locales will have their open reports break on upgrading. But then they will be immune going forward.
00:14:28 <andrewsw> until someone renames a report for whatever reason (it's happened before).
00:15:31 <fell> now there should be something for opening old open reports id = lookup(name) or lookup(untranslate(name))
00:17:26 <andrewsw> yes. if it fails to lookup, then call some legacy support code to try and find the report.
00:21:16 <fell> and possible as 3. some error message instead of a crash :-D
00:22:06 <andrewsw> yes. I'm thinking that if the report has to be found using the legacy method, then it should pop up a dialog.
00:22:39 <andrewsw> I think the already open reports aren't a problem. If they get changed even once, then they'll get rewritten to the books file.
00:22:50 <andrewsw> It may be that they get rewritten anyway.
00:27:46 *** nbinont has joined #gnucash
00:48:52 <andrewsw> well, it's doable. maybe even by me, but not tonight. I got a start and see what needs to happen, but it'll take me a while.
00:50:45 <fell> ok, have also to do some work
00:51:08 <andrewsw> its a pretty cool system, really. I'm enjoying learning about it.
00:52:43 <fell> My problem is a little before. It was a quarter century ago, when I last used Eight Megabytes Always Constantly Swapping.
00:59:21 <andrewsw> hmmm... quarter century ago I was swapping my rom into ram and rewriting the kernel. but that was when I was young and nimble. C-64, oh how sweet it was...
00:59:51 <andrewsw> anyway, I'm going to push up more advanced portfolio changes and call it a night. see ya fell!
01:00:26 <fell> see you, andrewsw!
01:00:32 *** andrewsw is now known as andrewsw-afk
01:22:02 *** fell is now known as fell_afk
01:22:29 *** kamilner has joined #gnucash
01:22:57 *** kamilner has left #gnucash
01:53:25 *** basanta has joined #gnucash
03:38:36 *** aindilis has quit IRC
03:38:36 *** basanta has quit IRC
03:38:36 *** nbinont has quit IRC
03:38:36 *** dale has quit IRC
03:38:36 *** conrad has quit IRC
03:38:36 *** wizkid239 has quit IRC
03:38:36 *** ttick has quit IRC
03:38:36 *** dave has quit IRC
03:38:36 *** jsled has quit IRC
03:38:36 *** puck has quit IRC
03:38:36 *** RobbieAB has quit IRC
03:38:36 *** Slart has quit IRC
03:38:36 *** Def has quit IRC
03:38:36 *** elb has quit IRC
03:38:36 *** localhos1 has quit IRC
03:41:08 *** conrad has joined #gnucash
03:41:09 *** basanta has joined #gnucash
03:41:09 *** nbinont has joined #gnucash
03:41:09 *** dale has joined #gnucash
03:41:09 *** aindilis has joined #gnucash
03:41:09 *** ttick has joined #gnucash
03:41:09 *** wizkid239 has joined #gnucash
03:41:09 *** Slart has joined #gnucash
03:41:09 *** Def has joined #gnucash
03:41:09 *** localhos1 has joined #gnucash
03:41:09 *** jsled has joined #gnucash
03:41:09 *** puck has joined #gnucash
03:41:09 *** RobbieAB has joined #gnucash
03:41:09 *** elb has joined #gnucash
03:41:09 *** dave has joined #gnucash
03:41:09 *** ircd.gimp.org sets mode: +oo conrad jsled
03:41:09 *** gncbot sets mode: +o conrad
03:41:10 *** gncbot sets mode: +o jsled
03:42:05 *** cortilap has quit IRC
03:42:06 *** RobbieAB has quit IRC
03:50:18 *** cortilap has joined #gnucash
03:54:20 *** RobbieAB has joined #gnucash
04:13:46 *** findlay has joined #gnucash
04:17:14 *** basanta has quit IRC
04:22:45 *** Pepe66 has joined #gnucash
04:30:20 *** basanta has joined #gnucash
04:52:02 *** ErKa has joined #gnucash
06:00:33 *** basanta has quit IRC
07:00:32 *** McLANE has joined #gnucash
07:20:06 *** _gunni_ has joined #gnucash
07:36:31 *** kling0n has joined #gnucash
07:46:51 *** kling0n has quit IRC
07:57:45 *** XiXaQ has joined #GnuCash
08:09:18 *** kling0n has joined #gnucash
08:17:13 *** _gunni_ has quit IRC
08:18:44 *** andi5 has joined #gnucash
08:19:17 <dale> Anyone awake?
08:19:51 *** _gunni_ has joined #gnucash
08:21:36 <localhos1> yes
08:21:51 *** localhos1 is now known as localhost
08:27:52 <dale> dummy question if you have the time --
08:28:46 <dale> I have some income transactions in a "Simple Checkbook" configuration -- I have severla income type acounts, one for me, on for the wife, and one that's "other".
08:29:06 <dale> How do I move a transaction from "other" to another income account?
08:31:02 <andi5> dale: just open up your checking account or whereever that money was transferred to and edit the transfer account appropriately.... you can also open the "other" account and press the "split" button
08:32:30 <dale> Ok, I'll try that -- I was just opening the account and trying to alter the transaction column.
08:33:58 <andi5> yep... but in simple transactions there are only two splits involved and you will only see the account of the other split... by pressing the "split" button you will see the split tied to the opened register as well
08:35:23 <andi5> does anyone run windows here?
08:39:53 <dale> Your already over my head... I try not to run windows if at all possible.
08:40:36 <dale> I opend the main account for the checking and changed the "Transfer" column -- that seem to do the trick
08:41:15 * dale 's wife had over $1,000 in store return credit by 05/15/2007 ... No wonder I'm broke!!
08:41:40 <andi5> lol
08:41:45 *** McLANE has quit IRC
09:02:49 <dale> If anyone is using Bank Of America, don't bother with the .QIF downloads. Go for the .OFX (Money 2006 I think). The .QIF produced by BOA was useless for me - never could get the automatching working on ANY of the netries.
09:03:10 <dale> s/netries/entries
09:04:01 *** hoffmanc has joined #gnucash
09:04:43 <hoffmanc> hello; is there work being done of the type Quicken does when banks don't support the OFX standard? That is, using some kind of automated bot to do the work?
09:07:26 *** kielein has joined #gnucash
09:07:44 <hoffmanc> also, is there a development channel where this question would be better addressed?
09:13:07 <lindi-> hoffmanc: mailing list is probably the way to go?
09:13:20 <hoffmanc> oh, okay, I'll try that; thanks
09:13:28 <andi5> what automated bot work do you mean?
09:13:28 <lindi-> hoffmanc: what does quicken do?
09:13:42 <lindi-> hoffmanc: i just automated conversion of my bank data to OFX
09:13:46 <lindi-> with python
09:14:14 <hoffmanc> lindi-: how did you do that?
09:14:33 <hoffmanc> I think quicken just does screen scraping of some sort; my bank doesn't support OFX
09:14:55 <lindi-> hoffmanc: my bank gives csv format. i then just use http://iki.fi/lindi/sampo2ofx
09:15:07 <andi5> hoffmanc: is that just a guess?
09:15:22 <lindi-> hoffmanc: how does it access your bank? ;)
09:15:40 *** donfede has joined #gnucash
09:16:18 <hoffmanc> oh so you manually log in still to retrieve the csv?
09:16:35 <andi5> hoffmanc: have you seen http://lists.gnucash.org/pipermail/gnucash-user/2007-December/022750.html
09:16:39 <hoffmanc> quicken uses some sort of bot to negotiate the web interface, I think
09:16:57 <andi5> but please read the whole thread
09:17:02 <lindi-> hoffmanc: yep
09:17:27 <lindi-> hoffmanc: i could automate it with chickenfoot-launcher but i have a feeling that would be against TOS of my bank
09:17:53 <hoffmanc> chickenfoot-launcher? Never heard of that.
09:18:06 <hoffmanc> I guess I have some reading to do.
09:18:17 <lindi-> hoffmanc: http://iki.fi/lindi/darcs/chickenfoot-launcher/
09:18:31 <lindi-> hoffmanc: it allows you to execute chickenfoot scripts non-interactively from command line
09:18:41 <andi5> lindi-: Not Found
09:18:43 <lindi-> hoffmanc: chickenfoot is a firefox extension for automating browsing
09:18:50 <lindi-> hoffmanc: http://iki.fi/lindi/darcs/chickenfoot/
09:19:38 <lindi-> andi5: see above
09:19:55 <hoffmanc> oh, I use selenium for a similar purpose, but I would actually want gnucash using something more rudimentary, such as wget
09:21:12 <lindi-> hoffmanc: the point of chickenfoot is that you only depend on what a user would see on the page and not some html internals
09:21:53 <lindi-> hoffmanc: so it's both easy and robust
09:22:26 <hoffmanc> have you used selenium?
09:23:15 <lindi-> hoffmanc: nope
09:23:26 <lindi-> only greasemonkey and chickenfoot
09:25:28 <hoffmanc> okay
09:25:53 <lindi-> hoffmanc: i thought chickenfoot was unique in this respect
09:27:36 <lindi-> hoffmanc: i'd probably automate fetching my bank data if my bank offered a read-only account for doing that :) i'm too paranoid to experiment with privileges that could actually change something
09:29:30 *** ErKa has quit IRC
09:39:49 <hoffmanc> lindi-: I see what you mean; actually, after reading that mailing list post andi5 mentioned, I think I'll just stick with manually downloading the info, as I mostly use a credit card
09:53:40 *** andi5 has quit IRC
09:57:11 *** McLANE has joined #gnucash
10:07:39 <conrad> Happy new year everyone (belated or in advance, depending on where you are ... :-))
10:09:38 *** warlord-afk is now known as warlord-slow
10:09:46 <warlord-slow> happy new year, conrad
10:13:36 <conrad> Thanks warlord.
10:20:04 *** rick has joined #gnucash
10:26:51 <rick> After an upgrade to Fedora 8 my OFX imports are not going smoothly. Many transactions are missing from the import dialog. Unfortunately I am way behind in my accounting, and also in the time since I last updated my books, my credit union, DCU, also upgraded their system. So I do not know if it is a change in the OFX file itself or the changes to GnuCash that are the problem.
10:28:05 <rick> so a few questions: 1) Have there been any updates to the import code that could cause this problem?
10:28:13 <rick> 2) Anyone else seeing this too?
10:29:09 <rick> 3) Is anything wrong/missing from this sample OFX transaction:
10:29:51 <rick> <STMTTRN>
10:29:51 <rick> <TRNTYPE>CHECK
10:29:52 <rick> <DTPOSTED>20070911000000[-5:EST]
10:29:52 <rick> <TRNAMT>-195.00
10:29:52 <rick> <FITID>182134
10:29:53 <rick> <CHECKNUM>134
10:29:54 <rick> <MEMO>SH DRAFT
10:29:57 <rick> </STMTTRN>
10:36:50 <warlord-slow> rick: do you (maybe) have duplicate FITIDs?
10:37:10 <rick> I will look in the OFX.
10:38:05 <warlord-slow> the importer will silently discard duplicate FITIDs.. It remembers the FITID of all previous imports for that account.
10:38:26 <rick> warlord-slow: within the OFX there are no duplicates.
10:38:36 <warlord-slow> but what about with previous imports?
10:40:44 <rick> I've gunzip'd my gnucash data file
10:40:50 <rick> what should I look for?
10:41:08 <warlord-slow> look for a the FITID value for a transaction that hte importer is ignoring.
10:41:56 <rick> my datafile is 14megs
10:42:01 <rick> bbiab..
10:52:04 <rick> this FITID would be the slot value for key online_id?
10:54:54 <rick> Does the online_id need to be globally unique?
10:56:43 <rick> warlord-slow?
10:58:11 <warlord-slow> It needs to be unique per account. I dont think it needs to be globally unique.
11:11:15 *** hoffmanc has quit IRC
11:20:32 <warlord-slow> gotta run
11:20:34 *** warlord-slow is now known as warlord-afk
11:52:53 *** tjanssen has joined #gnucash
12:06:54 *** artsman has joined #gnucash
12:07:37 *** artsman is now known as daad
12:12:06 *** daad has quit IRC
12:21:24 *** warlord-afk is now known as warlord-slow
12:22:12 *** wizkid239 is now known as wizkid238
12:27:24 *** tim_abell has joined #gnucash
12:31:44 *** tjanssen has quit IRC
12:33:34 <rick> warlord-slow: Indeed it is that the transactions have a non-unique FITID
12:40:28 <rick> What is the easiest thing to do from here ? Scrub the online_id key & value from the data file? Or pre-process my OFX files?
12:46:04 *** Zoolooc__ has quit IRC
13:01:13 <warlord-slow> ummm.. no idea.
13:24:57 <lindi-> finally got account summaries separately for each cost center ;-)
13:28:54 *** |gunni| has joined #gnucash
13:34:26 <dale> Is there an easy way to doa temporary sort by transaction in an asset account?
13:34:47 <jsled> "by transaction"?
13:35:03 <dale> Transactiion column.
13:35:15 <dale> Sorry, "Transfer".
13:35:58 <jsled> Not from the Asset account register, but Edit > Find should support it.
13:36:09 <dale> looking at the main asset account of a simple check book -- got some entries that need to be moved.
13:36:44 <dale> OK, I'll try that. thanks ;)
13:36:52 <jsled> Oh, shit, it won't.
13:37:10 <jsled> Because it's a Split search, not a Transaction search. :(
13:37:43 *** _gunni_ has quit IRC
13:38:06 <dale> yea... just ran one and it didn't return the expected results.
13:38:49 <jsled> Yeah, well, they are the expected results for Splits, since no Split can be related to two Accounts at once.
13:39:58 <dale> I'm just not sharp enough to use this software properly. Anyway to do this easy enough I can get a grasp:
13:40:39 <jsled> No, I'm sure you're sharp enough. We have too many gotchas and "it should, but" and "oh, that's a bug" and ...
13:40:52 <dale> I have a lot of entries that are in say "Misc" -- I want to go through them and move them to the appropriate account - say I missed a transaction that should really be under "Entertainement:Liqior"
13:41:34 <dale> I can look through ... brb, phone call.
13:47:43 *** kling0n has quit IRC
14:03:14 *** tim_abell_ has joined #gnucash
14:08:37 <rick> Is it safe to simply delete the <slot>s for online_id?
14:10:29 *** tim_abell has quit IRC
14:57:44 *** stlgirl has joined #gnucash
15:03:06 *** tim_abell_ is now known as tim_abell
15:19:38 *** ttick has quit IRC
15:31:16 *** ThatGuyBob has joined #gnucash
15:45:36 *** ThatGuyBob has left #gnucash
15:48:30 *** McLANE has quit IRC
15:54:11 *** rick has quit IRC
15:54:56 *** donfede has quit IRC
16:36:12 <dale> is there an esier way to reassign transactions to different accounts than going through the main asset account?
16:43:38 <warlord-slow> You could perform a search and use that register.
16:49:25 *** Pepe66 has quit IRC
16:51:24 *** stlgirl has quit IRC
16:51:44 *** stlgirl has joined #gnucash
16:55:17 <jsled> dale: doing it via the keyboard can help, but it's still one-at-a-time. There's no batch processing. :(
17:09:33 *** ttick has joined #gnucash
17:13:13 *** tjanssen has joined #gnucash
17:52:58 *** warlord-slow is now known as warlord-afk
17:53:37 *** stlgirl has quit IRC
17:54:16 *** tim_abell_ has joined #gnucash
17:55:56 <dale> Yea, I wanted to do them one at a time... the problem is, look at the expense accounts would be the perfect place to do the move -- but you can't.
17:56:25 <dale> And find doesn't work like that because find does ... something different.
17:56:49 <dale> Find does "Split Search"?
17:56:59 <dale> Nohting matches anyway
17:58:11 <dale> At least sorting by "Transfer" column in the main assett accoount would be a good way... but that doesn't appear to be an option.
17:58:34 <dale> Another topic: is there a MAC OS installer for Gnucash?
17:59:04 *** tim_abell_ has quit IRC
18:02:09 *** tim_abell has quit IRC
18:36:37 *** kielein has quit IRC
18:40:15 *** w has quit IRC
18:40:58 <jsled> dale: what do you mean you can't look at the expense accounts?
18:41:15 <jsled> There is no standalone/.dmg installer for the Mac, no.
18:41:23 * jsled goes afk again...
18:55:23 *** McLANE has joined #gnucash
19:30:22 *** McLANE has quit IRC
19:31:33 *** w has joined #gnucash
19:31:48 *** McLANE has joined #gnucash
19:43:36 <mjoseph> has anyone considered moving dates off the transaction level and down the split level?
19:44:39 <mjoseph> i know there are hacks for dealing with transactions dated at different times (intermediate accounts, etc), but moving the date to the split level seems like the simplest approach
19:46:34 <lindi-> mjoseph: but then at some point in time the sum of values would not be zero?
19:47:03 <mjoseph> well, yes and no
19:47:10 <mjoseph> the transaction would always remain balanced
19:47:35 <mjoseph> but yes, the sum of values for the accounts at a given current instant would be non-zero
19:47:58 <mjoseph> (though if you go forward enough, that is resolved, making the accounting consistent
19:49:06 <mjoseph> note that i am not imagining huge differences in the dates (though it's conceivable that such usage could not be precluded), really just a few days to at most a few weeks
19:50:31 <lindi-> sounds quite complex still
19:51:04 <mjoseph> really, you think so?
19:52:00 <lindi-> but i'm not very knowledgeable on accounting :)
21:05:10 <dale> jsled: From a non-technical user standpoint, I would expect the behavior to be to be able to move a transaction to another account while viewing transaction in accounts - expense accounts being on example.
21:05:57 <dale> I'm not accounting savvy and have only about a week of putzing around with gnucash
21:47:20 *** tjanssen has quit IRC
22:09:26 *** |McLANE| has joined #gnucash
22:18:17 *** McLANE has quit IRC