2007-07-12 GnuCash IRC logs
00:04:54 *** jmgreen has quit IRC
00:09:32 *** warlord has joined #gnucash
00:09:33 *** gncbot sets mode: +o warlord
00:10:04 <leonardof> please check if I understood correctly: should translations be committed until this today (thursday)?
00:13:41 <chris> leonardof: I'm changing my mind.
00:14:06 <chris> leonardof: I'm thinking that perhaps that string shouldn't be translated at all.
00:14:47 <leonardof> chris: honestly, after translating it i look at all that options and decided to let them just like in English
00:15:06 <leonardof> all that options: the other date formats
00:16:50 <chris> I think that string will be interpreted as a strptime input.
00:17:16 <chris> warlord might know, I think it's a business-only thing.
00:17:56 <chris> leonardof: sounds reasonable.
00:19:05 <warlord> Umm...
00:19:24 * warlord looks in the logs..
00:20:52 <warlord> Hmm... I'm not even sure why that string is translated... Umm...
00:21:11 <warlord> Is it used in strptime or strftime?
00:21:26 <warlord> If the former then you can't change it and it should be removed from the translation table.
00:21:39 <warlord> If the latter then you can change it to your locale strftime format.
00:22:00 *** nbinont has joined #gnucash
00:23:20 <leonardof> warlord: neither; it's a glade file
00:23:33 <warlord> leonardof: yes, but how is it used?
00:23:49 <leonardof> I don't know :)
00:24:26 <warlord> I think you should probably just translate it to the same thing for now.
00:25:05 <leonardof> thanks
00:27:00 *** nbinont_ has joined #gnucash
00:31:15 <kooz> hey, I can't poste to pastebin ubuntu-nl.org. browser thinks it's spam....but am installing Finance::Quote for gnucash
00:32:03 <kooz> I get to the part of the installing where SSLeay needs a path directory...and then "make test" and "make install" had some problems
00:32:17 <kooz> but it says "Finance::Quote"" is up-to-date
00:32:20 <kooz> which is what I want
00:32:54 <kooz> but..." perldoc Finance::Quote" returns that I need to install the perl-doc package
00:33:24 <kooz> basically, how and where (which path) do I effectively install the perl-doc package to get Finance::Quote to work for gnucash?
00:35:01 *** nbinont has quit IRC
00:38:49 *** vbabiy has quit IRC
00:43:04 <warlord> kooz: what OS/Distro? And how are you trying to install F::Q?
00:50:21 <kooz> fiesty fawn 7.04
00:50:38 <kooz> sudo gnc-fq-update
00:50:46 <kooz> is the method i've been trying to to use
00:51:20 <kooz> it then gets to a Crypt::SSLeay
00:51:47 <kooz> part of the installation process, asks which SSL install path to use, and I have no idea what to put
00:52:05 <warlord> kooz: Oooh, that's exactly the WRONG thing to do..
00:52:20 <warlord> apt-get install perl-finance-quote (or whatever the ubuntu package name is)
00:52:28 <kooz> Oooh, what should I be deoing?
00:52:30 <kooz> okay
00:52:37 <kooz> perl-finance-quote is the package name/
00:52:58 <kooz> I technically didn't even do anything because I never specified the ssl question
00:53:25 <kooz> i don't see hwo that's the WRONG thing to do...that's what was specified in the gnucash docs
00:53:46 <warlord> it's specified "if your distribution doesn't supply it"
00:54:51 <kooz> YES! thanks warlod, apt-get install perl-doc was what I needed
00:55:00 <kooz> things working smoothly now
00:55:14 <kooz> atleast with perl-doc, not sure of finance-qutoe status
00:56:33 <warlord> you can apt-get it
00:57:47 <kooz> yeah, did that with perl-doc, thanks, now am trying to wire gnucash with the Finance::Quote feature
00:58:43 <kooz> how does apt-get work? do new packages get installed to a common server? how does apt-get "find" the designated package?
00:59:33 <warlord> central database
01:05:16 <kooz> okay, cool about apt-get, anyway,s making progress
01:05:25 <kooz> apparently have Finance::Quote installed.
01:05:46 <kooz> I try to run gnucash --add-price-quotes $HOME/gnucash-filename and get parser error : Start tag expected, '<' not found
01:06:37 <kooz> obviously, replacing $HOME/gnucash-filename with the location of the file
01:06:49 <warlord> which is..??
01:07:03 <kooz> ~/.gnucash/books/jtk
01:07:24 <kooz> I get a series of 3 of those parser errors
01:07:42 <warlord> Right, because you can't put your data there.
01:07:52 <warlord> That's gnucash's meta-data storage directory.
01:08:07 <kooz> ohhhh, so just relocate the account file?
01:08:41 <warlord> yes.
01:08:54 <warlord> Why did you put it into ~/.gnucash/books?
01:09:07 <kooz> i think that's where it defaulted
01:11:00 <warlord> Oh? That's VERY odd..
01:11:33 <kooz> actually I know the account is called jtk but there are about 10-15 files in home directory starting iwth jtk like jtk.20070711170384.log
01:11:40 <kooz> obviously that appended number is the date
01:11:57 <kooz> I assumed the file jtk in /books was the actual account file
01:12:01 <kooz> how do I know for sure?
01:13:32 <Sathamoth> for each GnuCash datafile I've created a have an entry in ~/.gnucash/books directory
01:13:48 <Sathamoth> but datafiles themselves are elsewhere, just where I saved them
01:13:49 <warlord> no, the file 'jtk' is your metadata file that gnucash overwrote because gnucash owns that directory.
01:13:52 <warlord> Your datafile is gone.
01:14:27 <kooz> ummm, how can my datafile be gone if I'm using it?
01:15:21 <kooz> i understand that GNUcash "owns/uses" the .gnucash directory, but nevertheless I have fully-functioning data-fiel.
01:15:36 <kooz> just not what it's path is -- there's no path name in the title bar
01:16:01 <warlord> File -> Save As and store it elsewhere.
01:16:03 <Sathamoth> it's probably just in your ram :) save it in some different directory before you lose it completely :)
01:17:06 <kooz> great, Sathamoth, thanks for the precautionary help. problem Solved! did a save as to home, Finance::Quote worked!
01:17:16 <kooz> the only stock it didn't get quotes for is an OTC
01:17:29 <kooz> "not listed in conventional exchanges" over-the-counter
01:17:37 <kooz> anyone know how to get quotes for an otc?
01:17:50 <kooz> very minor problem now that finance:quote works
01:18:43 <kooz> the gnucash docs suggests making an auto-update crontab file with a suggested line of code to add.
01:18:48 <kooz> how do I access my crontab file?
01:19:07 <Sathamoth> man cron, man crontab :)
01:20:33 <kooz> good ol' manual pages. thanks I'll give those a gander. Yes! thanks SO much for helping to get this to work
01:20:45 <kooz> how long have you been using gnucash?
01:20:54 <kooz> do you have the finance::quote featuer installed?
01:20:58 <Sathamoth> actually just couple of weeks :)
01:21:04 <Sathamoth> yeah I have
01:21:06 <kooz> that is nifty AS heck
01:21:33 <Sathamoth> I'm using it to fetch quotes from NYSE and OMXH stock markets
01:21:40 <kooz> yeah, I've gone from quicken/quickbooks about 4 years ago, didn't trust those so just switched to raw excel
01:21:53 <Sathamoth> I'm coming from Excel as well
01:22:02 <Sathamoth> (brrrh...)
01:22:02 <kooz> excel I could write my own formulas but it wasnt' comprehensive enough for quality accounting/expenses/bookkeeping so
01:22:11 <kooz> gnucash hopefully will be the ideal syntehsis
01:23:05 <kooz> If its opensource coding holds, I prefer it MUCH more to quicken/quickbooks. Not some accountant freak, just trying to connect with an agreeable budget tracker program
01:24:14 <Sathamoth> I just need to learn to write my own reports in GnuCash so I would be able to generate a tax report about my investments for Finnish tax authorities.. it's called "Form 9A", I guess no one has done one yet :)
01:25:47 <kooz> Finland, eh. they have some good long distance runners there, I hear, and fjords. That about sums up what I now about finland:)
01:26:17 <kooz> See you're already very technical. I'm just doing personal budgetting...but in tremendously comprehenisve detail
01:26:26 <Sathamoth> runners? umm.. ;)
01:26:33 <Sathamoth> and fjords are in Norway ;)
01:28:07 <Sathamoth> yeah I'm just doing personal budgetting as well.. and some investment tracking, really small-scale at this moment though..
01:28:35 <kooz> I was into distance running for awhile and all documentaries always talked about finnish runners. Fjords in norway, great, -1 thing I know about finland!
01:29:11 <kooz> The Flying Finn as they were called -- a bunch of mid- long- distance runners
01:30:43 <kooz> ahhh, big (but obvious note) they didn't mention this in helpdocs, but the add-price-quotes command can only be issues when the accoutn file is closed!! ahhh! duh
01:30:50 <Sathamoth> hehe, Flying Finn was our first budget airlines company which went bankrupt few years ago :)
01:39:11 <kooz> haha, funny. they brought you on board to handle their taxes, and then they went' bankrupt???:)
01:39:31 <kooz> I can't solve the missing OTC stock, guess i'll just have to manually enter the quotes
01:39:41 <kooz> I even plugged in the CUSIP number
01:47:07 <kooz> it's just reassuring and encouraging to have a detailed scope of finances
02:04:05 *** warlord is now known as warlord-afk
02:21:04 * leonardof goes to bed
02:52:58 *** kooz has quit IRC
03:02:44 *** kooz has joined #gnucash
03:24:18 *** Vino has quit IRC
04:02:35 *** kooz has quit IRC
04:55:15 *** nomeata has joined #gnucash
05:16:18 *** nomeata has quit IRC
05:23:55 *** nomeata has joined #gnucash
05:48:30 *** nomeata has quit IRC
06:06:13 *** cortilap has joined #gnucash
06:54:52 *** RallyU has joined #gnucash
07:25:24 *** twunder has joined #gnucash
07:30:49 *** twunder has quit IRC
07:33:23 *** Rol1 has joined #gnucash
07:58:30 *** twunder has joined #gnucash
08:36:04 *** nbinont_ has quit IRC
08:51:31 *** IanL has joined #gnucash
08:52:14 *** vbabiy has joined #gnucash
08:59:38 *** vbabiy has quit IRC
09:16:39 *** andi5 has joined #gnucash
09:16:39 *** gncbot sets mode: +o andi5
10:42:16 *** dbr has joined #gnucash
11:04:53 *** nomeata has joined #gnucash
11:25:26 *** cortilap has quit IRC
11:31:45 *** warlord-afk has quit IRC
11:42:10 *** nomeata has quit IRC
11:48:39 *** cortilap has joined #gnucash
11:51:12 *** andi5 has quit IRC
12:08:07 *** zarchne has quit IRC
12:11:32 *** cortilap has quit IRC
12:12:54 *** zarchne has joined #gnucash
12:18:16 *** warlord-afk has joined #gnucash
12:18:24 *** warlord-afk is now known as warlord
12:18:25 <warlord> @op
12:18:25 *** gncbot sets mode: +o warlord
12:18:51 *** cortilap has joined #gnucash
12:31:42 *** vbabiy has joined #gnucash
12:42:54 *** IanL has quit IRC
12:58:10 *** vbabiy has quit IRC
12:59:45 *** GuiGS has joined #gnucash
13:32:14 *** jakin has joined #gnucash
13:33:10 *** aluink has joined #gnucash
14:35:05 *** nomeata has joined #gnucash
15:33:25 *** roxy_ has joined #gnucash
15:57:27 *** bonez44 has quit IRC
15:59:27 *** roxy_ has quit IRC
16:19:32 *** GuiGS has quit IRC
16:27:56 *** Zoolooc has joined #gnucash
16:44:32 *** aluink has left #gnucash
16:52:36 *** ErKa has joined #gnucash
16:56:59 *** twunder has quit IRC
17:17:17 *** nomeata has quit IRC
17:25:21 *** Zoolooc has quit IRC
17:47:57 *** cortilap has quit IRC
17:51:59 *** twunder has joined #gnucash
18:04:15 *** cortilap has joined #gnucash
18:27:29 *** ErKa has quit IRC
19:26:38 *** vbabiy has joined #gnucash
19:41:53 *** cortilap has quit IRC
19:47:49 *** vbabiy has quit IRC
20:38:23 *** HerrMuller has joined #gnucash
20:40:34 <HerrMuller> I'm having this problem: "There was an error parsing the file ..."
20:40:35 *** dbr has quit IRC
20:41:06 <jsled> Is anything printed to the console?
20:41:24 <HerrMuller> not running through console
20:41:28 <HerrMuller> let me see
20:41:29 <jsled> http://pastebin.ca/ might be useful.
20:41:38 <jsled> (to avoid flooding the channel)
20:41:56 <jsled> what version/os, as well?
20:42:13 <HerrMuller> no, nothing useful in the console
20:42:22 <jsled> What about /tmp/gnucash.trace ?
20:42:29 <HerrMuller> the accounts were created at work on version 2.1.4 (windows)
20:42:43 <HerrMuller> trying to open at home on 2.0.2 (debian)
20:42:55 <jsled> Ah. Are you using scheduled transactions?
20:43:49 <HerrMuller> no haven't scheduled any transactions that I know of
20:44:08 <HerrMuller> let me open up the last .xac file that opens, and I'll see if any snuck in
20:45:43 <HerrMuller> nope, no scheduled transactions
20:45:55 <jsled> Well, if it opens, then maybe it doesn't have them. :)
20:46:08 <jsled> I'd check /tmp/gnucash.trace ... maybe if you run with --debug, as well.
20:46:55 <HerrMuller> i'll give that a shot
20:47:04 <HerrMuller> something else that's interesting is ..
20:47:19 <HerrMuller> that when I open the last .xac file that will open...
20:47:38 <HerrMuller> and "save as" ...
20:47:49 <HerrMuller> then try to open that file, I get the same error.
20:47:57 <HerrMuller> ok, off to try you suggestion, brb
20:48:12 <jsled> and that's with 2.0.2 on debian?
20:48:36 <HerrMuller> yes
20:50:03 <HerrMuller> ok, the --debug doesn't give any interesting messages on the .xac file that opens, now trying on a normal file that will not parse ...
20:51:52 <warlord> HerrMuller: what's the path to your datafile?
20:52:55 <HerrMuller> i'm using both /media/<usb drive>/gnucash/<filename> ...
20:53:14 <HerrMuller> and I've tried /home/<username>/gnucash/<filename>
20:53:21 <HerrMuller> both locations have the same problem
20:53:54 <warlord> "gnucash", not ".gnucash", right?
20:54:03 <HerrMuller> correct
20:54:19 <HerrMuller> but I did try the .gnucash/books and had no success there either
20:55:00 <HerrMuller> no interesting messages opening the file that doesn't parse in the console, looks the same as the .xac that does parse
20:57:06 <HerrMuller> I should also clarify that I'm using the ubuntu flavor of debian
21:03:01 <jsled> Well, definitely don't use ~/.gnucash/books/
21:03:21 <jsled> Any luck looking at /tmp/gnucash.trace on a file that won't open?
21:04:33 <HerrMuller> yes, it looks the same as the .xac that does parse
21:05:35 <jsled> Even with --debug?
21:05:54 <jsled> if you run `file /path/to/file`, what does it say?
21:06:12 <HerrMuller> yes, they appear the same... give me another sec, I'll diff the two to see if there is anything I'm missing
21:11:14 *** vbabiy has joined #gnucash
21:13:25 <HerrMuller> they look the same with the exception of the differing file names
21:13:40 <HerrMuller> i'm using: gnucash --debug <filename>
21:17:02 *** Rol1 has quit IRC
21:24:52 <HerrMuller> here you go: http://pastebin.ca/617132
21:27:19 <HerrMuller> it's getting past my bed time, I'll be back tomorrow night. Is there any harm using the .xac file until the problem is resolved?
21:28:12 <HerrMuller> it would blow to have to reenter all that data again, if you know what I mean
21:28:38 <warlord> Wow, those look exactly the same.
21:29:00 <HerrMuller> well, the file names differ, but the rest looks the same
21:29:09 <HerrMuller> call me stumped
21:29:22 <warlord> what does "file /path/to/..." say for each one?
21:31:57 <HerrMuller> ok, for the .xac that opens: "gzip compressed data, from NTFS filesystem (NT)"
21:34:02 <HerrMuller> the files that don't open: "gzip compressed data, from Unix"
21:34:08 <HerrMuller> looks like a big fat clue
21:35:45 <warlord> huh? "file" says "from NTFS filesystem (NT)" ???
21:36:04 <HerrMuller> remember, I created the accounts using 2.1.4 on windows
21:36:21 <warlord> that shouldn't matter.
21:36:29 <warlord> How did you get the files across?
21:36:37 <HerrMuller> usb flashdrive
21:36:58 <warlord> Both the regular AND the .xac backup?
21:37:12 *** twunder has quit IRC
21:37:30 <HerrMuller> yes
21:37:49 <warlord> And this file never opened at all under unix?
21:38:21 <HerrMuller> trying to remember ...
21:38:46 <warlord> another thing to try: cp <datafile> <datafile>2.gz ; gunzip <datafile>2.gz ; gnucash <datafile>2
21:39:40 <HerrMuller> i'm going to give that a try, fastening my seatbelt ...
21:42:57 <HerrMuller> no success
21:43:04 <HerrMuller> doesn't parse
21:43:36 <warlord> Oh really??
21:43:43 <warlord> That means the gzip container is broken.
21:43:54 <warlord> Can you still open the file on windows?
21:44:34 <HerrMuller> yes, but not until tomorrow ; ), windows is at work
21:49:24 <HerrMuller> i'll be back tomorrow night for more insight, thanks for the clues
21:49:44 *** HerrMuller has left #gnucash
21:55:01 *** lasindi_ has joined #gnucash
22:03:21 *** lasindi has quit IRC
22:04:40 *** dbr has joined #gnucash
22:12:54 *** johnr has joined #gnucash
22:14:09 <johnr> just installed 2.1.5 on mac osx. it's working, but number formats do not have comma for thousands. Is that set by locale? or by gnome? or other?
22:14:31 <johnr> gnome => gconf
22:14:32 <warlord> locale
22:14:42 <warlord> gotta run to dinner. bye.
22:14:52 *** warlord has quit IRC
22:22:58 *** vbabiy has joined #gnucash
22:25:03 *** vbabiy has quit IRC
22:25:08 <johnr> warlord: thanks
22:32:05 *** johnr has quit IRC
22:38:01 *** fell has joined #gnucash
22:46:43 *** vbabiy has joined #gnucash
23:04:58 *** dbr has quit IRC
23:05:01 *** vbabiy has joined #gnucash