2007-12-29 GnuCash IRC logs
00:38:55 *** tjanssen has quit IRC
00:50:34 *** twunder has quit IRC
02:04:10 *** McLANE has quit IRC
02:07:16 *** dbreiser has quit IRC
02:14:47 *** McLANE has joined #gnucash
02:30:54 *** kling0n has joined #gnucash
02:39:25 *** warlord is now known as warlord-afk
02:56:02 *** conrad has quit IRC
03:09:29 *** ErKa has joined #gnucash
03:14:30 *** kling0n has quit IRC
03:32:14 *** ErKa has quit IRC
03:49:04 *** conrad has joined #gnucash
04:02:42 *** kielein has joined #gnucash
04:14:37 *** McLANE has quit IRC
05:50:28 *** Zoolooc_ has quit IRC
06:25:49 *** paulproteus has quit IRC
06:27:37 *** paulproteus has joined #gnucash
06:27:45 *** aindilis has quit IRC
06:27:45 *** wizkid238 has quit IRC
06:27:45 *** localhos1 has quit IRC
06:27:45 *** elb has quit IRC
06:27:45 *** kielein has quit IRC
06:27:45 *** conrad has quit IRC
06:27:45 *** IanL has quit IRC
06:27:45 *** jsled has quit IRC
06:27:45 *** Def has quit IRC
06:27:45 *** puck has quit IRC
06:27:45 *** RobbieAB has quit IRC
06:27:45 *** dave has quit IRC
06:30:03 *** jsled has joined #gnucash
06:30:03 *** kielein has joined #gnucash
06:30:03 *** conrad has joined #gnucash
06:30:03 *** IanL has joined #gnucash
06:30:03 *** wizkid238 has joined #gnucash
06:30:03 *** localhos1 has joined #gnucash
06:30:03 *** aindilis has joined #gnucash
06:30:03 *** Def has joined #gnucash
06:30:03 *** puck has joined #gnucash
06:30:03 *** RobbieAB has joined #gnucash
06:30:03 *** elb has joined #gnucash
06:30:03 *** dave has joined #gnucash
06:30:03 *** irc.acc.umu.se sets mode: +o jsled
06:30:03 *** gncbot sets mode: +o jsled
07:41:17 *** lindi- has joined #gnucash
08:11:10 *** twunder has joined #gnucash
08:47:05 <jsled> .
09:15:52 *** andi5 has joined #gnucash
09:15:53 *** gncbot sets mode: +o andi5
09:16:00 *** Jan has joined #gnucash
09:16:14 <Jan> Hi
09:17:22 <jsled> hello
09:18:00 <Jan> I'm having trouble with gnu cash 2.2.1 fancy invoice report. I recently upgraded from release 2.2.0 to 2.2.1 Now for some reason all invoices with an invoice ID higher then 75 throw an report error...
09:18:23 <jsled> Did you just try to send a message as such to gnucash-user?
09:18:48 <Jan> I tried those invoices above id 75 with easy invoice or printable invoice and they work just fine.
09:18:52 <Jan> yup
09:19:00 <Jan> done that 15min ago :-)))
09:19:05 <jsled> What happened re: the message?
09:19:51 <Jan> I got only an answer from the server saying that a moderator will have to approve the post first ...
09:21:43 <jsled> Hmm. I went to moderate it through, but I'm not seeing it. strange.
09:21:57 <jsled> I'm not seeing any of the -user traffic, in fact.
09:22:06 <Jan> hmmm...
09:22:54 <Jan> just checking when I got the reply from server ...
09:23:51 <Jan> Sat, 29. Dec 2007 08:46:15 -0500
09:24:04 <Jan> Your mail to 'gnucash-user' with the subject
09:24:04 <Jan> GnuCash 2.2.1 and fancy invoice trouble
09:24:04 <Jan> Is being held until the list moderator can review it for approval.
09:24:04 <Jan> The reason it is being held:
09:24:04 <Jan> Post by non-member to a members-only list
09:24:57 <Jan> Does this shed some light?
09:26:00 <jsled> Unfortunately: no. But thanks. As for your original question, I don't know why or what it could be, but it'd be easier knowing the error message...
09:26:18 <jsled> (please use http://pastebin.ca/ if it's more than a line)
09:28:22 <Jan> http://pastebin.ca/837280
09:28:30 <Jan> :)
09:29:06 <Jan> It's not exactly a descriptive error message...
09:29:22 <jsled> Where do you see that?
09:30:32 <Jan> when i go Reports>Business>Fancy Invoice
09:30:53 <jsled> That text is in the report window, though, right?
09:30:53 <Jan> I then select an Invoice via the invoice ID and hit apply
09:31:01 <Jan> yup
09:31:23 <jsled> Can you reproduce while running gnucash from a terminal, like so?: `gnucash --logto stderr --debug --log gnc.scm=debug`?
09:31:38 <jsled> And pastebin what's output there.
09:31:51 <Jan> will try...linux is not my strong side...
09:33:13 <andi5> 2.2.1... maybe you see http://bugzilla.gnome.org/show_bug.cgi?id=483796
09:35:16 *** McLANE has joined #gnucash
09:35:51 <Jan> http://pastebin.ca/837283
09:36:27 <andi5> yes, please update to 2.2.2
09:37:13 <Jan> andi 5: you are saying you had the same probs and after update they are gone?
09:37:54 <jsled> Jan: the bug was filed by someone else, though it appears andi5 did fix it.
09:37:58 <andi5> just click the bug report :-) ... but one could summarize with "yes"
09:38:32 <Jan> :) cheers! Thanks for helping me out...just spend hours on this...
09:39:10 <andi5> Jan: it would be very helpful if you could comment on the bug after you tried again with gnucash 2.2.2... that is a good way to verify it as fixed
09:39:58 <lindi-> just reported three usability bugs ;-) I wish I could test them with the newest version but debian unstable seems to have an issue with guile-1.6-slib at the moment
09:40:16 <Jan> will do...just a minor thing how do I update gnu cash?? Linux is still very new to me. I'm running ubuntu 7.10
09:40:21 <andi5> lindi-: do you have a link for me?
09:40:51 <lindi-> andi5: http://bugzilla.gnome.org/show_bug.cgi?id=506257 http://bugzilla.gnome.org/show_bug.cgi?id=506261
09:40:51 <andi5> Jan: well...
09:41:04 <andi5> lindi-: and the debian problem? :)
09:42:30 <andi5> Jan: gnucash 2.2.2 will most likely be available in ubuntu hardy which you can dist-upgrade in april 2008... there is not even a hardy package yet (it is derived from debian package descriptions, which are missing)... so currently the only way is to compile gnucash yourself
09:42:58 <lindi-> andi5: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=458172
09:43:44 <lindi-> andi5: and the third gnucash bug is http://bugzilla.gnome.org/show_bug.cgi?id=506265
09:44:14 <andi5> Jan: it is not very hard, i just did that on a clean gutsy machine
09:44:25 <Jan> :-D hm ok
09:45:01 <andi5> Jan: you will need a shell and a little bit of time :-)
09:45:23 <Jan> I assume I have to download : gnucash-2.2.2.tar.bz2 and gnucash-2.2.2.tar.gz ?
09:45:36 <andi5> only one of them...
09:45:54 <andi5> bz2 is more work for the cpu and less for the network
09:46:04 <Jan> ok
09:46:31 <Jan> downloading...
09:48:07 <andi5> Jan: there is http://wiki.gnucash.org/wiki/Debian ... unfortunately that version describes how to start from a debian package description and enrich it with aqbanking support
09:48:17 *** twunder has quit IRC
09:49:20 <andi5> Jan: do you need online banking support?
09:50:06 <Jan> andi5: no all by hand...
09:51:34 <Jan> hm download just finished and I extracted the tar file..
09:52:03 <andi5> Jan: ok... then i would simply do "sudo apt-get build-dep gnucash && tar -xjpf gnucash-2.2.2.tar.bz2 && cd gnucash-2.2.2 && ./configure --prefix=/opt/gnucash --enable-ofx && make && sudo make install"
09:52:59 <andi5> well, now you can stripp of the tar command as you have done that already :-)
09:53:10 <lindi-> you can omit the risks of "sudo make install" by first doing "sudo mkdir /opt/gnucash; sudo chown jan.jan /opt/gnucash" and then only using "make install"
09:53:27 <andi5> listen to lindi-
09:53:49 <Jan> ok
09:55:36 <andi5> lindi-: but you are not Tommi, right? :-)
09:56:24 <lindi-> andi5: no, i'm Timo
09:56:40 <andi5> sure ;-)
09:56:46 <Jan> I'm not logged in as admin... and sudo doesnt work
09:57:37 <andi5> Jan: do you mean that you have a user account called "admin" and only that user belongs to group admin?
09:58:35 <andi5> sudo should work unless you created more that one user account yourself
09:58:57 <Jan> sort of. I got a user account called olive which belongs to group admin but I'm logged in as my wife...
09:59:06 <Jan> complicated world
10:00:03 <lindi-> Jan: you can do "sudo apt-get build-dep gnucash; sudo mkdir /opt/gnucash; sudo chown <wife's account>:<wife's account> /opt/gnucash" as olive first?
10:00:30 <Jan> will do... will be back i n 5
10:00:49 <lindi-> i thought gnome allowed multiple logins at the same time
10:01:07 <lindi-> (it starts an extra X server transparently to handle it)
10:02:03 <andi5> yes, ... the stock ubuntu gnome desktop even shows your name in some applet (i have deactivated already), and in its context-menu you can switch users pretty easily
10:03:22 <lindi-> andi5: other than those few usability issues the only problems i currently have are 1) how to get the data from my bank? and 2) is there some way to support "cost centers" since an association would need those if it switched to gnucash
10:03:27 <andi5> jsled, aka moderated /dev/null
10:03:53 <jsled> andi5: hmm?
10:04:09 <andi5> jsled: just ignore me
10:04:12 <lindi-> for 1) i modified mastercard2ofx to http://iki.fi/lindi/sampo2ofx but then noticed that the CSV data from my bank does not have all information the HTML pages show me (including the "archival id")
10:04:55 <jsled> ah, okay. It's really frustrating; even now, the -user moderation page shows up with "no pending requests". But I'm clearly getting the moderator email version of the messages.
10:05:00 <lindi-> for 2) I'm bit puzzled. I guess I could specify "location" in the "memo" field and then somehow find all transactions that belong to same location?
10:06:08 <andi5> for 1) ask your bank to fix it? :-)
10:07:10 <andi5> oh, the current gnucash trunk includes a csv importer... you may want to check that out
10:07:19 <lindi-> andi5: oh, they have already fixed it :-) The fix just isn't available unless I pay some 9 EUR extra per month which is ridiculous for a normal customer
10:07:30 <andi5> lol
10:07:32 <Jan> ok...sudo apt-get build-dep gnucash; sudo mkdir /opt/gnucash; sudo chown <wife's account>:<wife's account> /opt/gnucash
10:07:39 <Jan> did that ...
10:08:05 <Jan> do i know use make install?
10:08:10 <lindi-> Jan: and replaced "<wife's account>" with the right username i suppose? ;)
10:08:30 <Jan> :-D yup
10:08:39 <lindi-> ok, just checking
10:08:50 <Jan> no probs
10:09:15 <andi5> Jan: what about ./configure --prefix=/opt/gnucash --enable-ofx?
10:09:42 <lindi-> andi5: interesting. however, i was more comfortable in doing this in python since I there were all sorts of gludges to do to the data in the older CSV formats my bank used to generate
10:09:52 <andi5> lindi-: i am not sure how gnucash can fix no 1 for you then
10:10:02 <Jan> andi5:is this the next step?
10:10:08 <andi5> Jan: yes
10:10:10 <lindi-> andi5: same here, i doubt it's your problem :)
10:11:33 <Jan> done...
10:12:01 <lindi-> andi5: also, it gets more complicated. the association apparently gets _only_ PDF files and not CSV like normal customers
10:12:11 <Jan> not that I would know what I just have done...O:-)
10:12:21 <lindi-> andi5: but those PDFs have "archival ids" and stuff like that so the data is more complete
10:12:49 <andi5> Jan: you configured the sources to your current setup, i.e. where you want your stuff installed, against what libraries you want to link and so on.... now run "make" to let it compile all stuff
10:13:18 <Jan> just "make install"
10:13:19 <Jan> ?
10:13:49 <andi5> normally make, then make install... but only make install will work also (given that you install as yourself (not root)
10:15:05 <andi5> lindi-: do you know https://lists.gnucash.org/pipermail/gnucash-user/2007-October/022074.html , or more generally http://lists.gnucash.org/search ?
10:18:08 <lindi-> andi5: hmm yeah i think I saw that thread but kind of stopped when i started to talk about changes to source code in https://lists.gnucash.org/pipermail/gnucash-user/2007-October/022094.html
10:18:42 *** tjanssen has joined #gnucash
10:19:11 <Jan> uih that was alot of text...
10:19:48 <Jan> do i need to do more?
10:20:09 <andi5> Jan: do you think that it succeeded? you might want to run "echo $?"
10:20:41 <Jan> that returns a "$"
10:21:05 <andi5> if it did, you will find an executable (script) at /opt/gnucash/bin/gnucash..... no, i actually meant $?
10:21:44 <Jan> ups , returns "0"
10:21:48 <andi5> but now it is too late... this will print the exit status (0 for good, others for bad) of the last executed command... which is now "echo" :-)
10:22:55 <Jan> there are a couple of folders bin etc include lib libexec share
10:23:09 <lindi-> andi5: is the "Action" field the one i see with "Double line" enabled where it says "Enter type of transaction, or choose one from the list" and suggests things like "ATM", "AutoDep", "Check", ..?
10:24:18 <andi5> lindi-: yes, that is in the second line, as the header indicates
10:24:43 <lindi-> andi5: the header says "Ac" :-)
10:24:56 <andi5> then double click it :-)
10:25:22 <lindi-> aha
10:26:13 <Jan> aah found it
10:26:31 <Jan> I just run it?
10:26:36 <andi5> yes
10:27:39 <Jan> it works!!!!!
10:27:48 <Jan> Thanks for that!!
10:27:48 <andi5> *g*
10:28:07 <Jan> sorry iust one more thing
10:28:19 *** Zoolooc has joined #gnucash
10:28:46 <Jan> is this linked to the Applications>office>gnucash menu entry?
10:28:52 <andi5> nope
10:29:33 <andi5> but ubuntu has some sort of menu editor... or you can copy the appropriate gnucash.desktop file into ~/.local and edit it right away, but i suppose this can be called advanced
10:30:10 <Jan> ah ok I think I will look into that tomorrow!!!
10:30:19 <Jan> Thanks again for your quick help!
10:30:30 <andi5> do not forget to comment on the bug :-)
10:32:16 <Jan> hm on the mailing list or on the link you gave me earlier on
10:33:07 <andi5> i meant the bugzilla link
10:33:45 <andi5> but your message to gnucash-user was eaten by the moderation monster, so i guess you need not write to gnucash-user :-)
10:36:39 *** Zoolooc has quit IRC
10:38:05 <lindi-> andi5: that "Action" field probably does not have an element in OFX?
10:38:19 <Jan> ok sorted. Thanks again!
10:38:58 *** Jan has left #gnucash
10:39:24 *** dbreiser has joined #gnucash
10:40:46 <andi5> lindi-: at least there is no xaccSplitSetAction in src/import-export/ofx
10:40:54 *** Zoolooc has joined #gnucash
10:41:17 <dbreiser> I'm trying to take my local repository back in time to do a binary search test of revisions between 2.2.1 and 2.2.2 to find the rev that causes problems with intel macs
10:41:47 <jsled> dbreiser: straight svn, or git-svn?
10:41:47 <andi5> dbreiser: cool :-) ... what is delta right now?
10:41:58 <andi5> i know what jsled is going to propose ;-)
10:42:01 <lindi-> andi5: i guess I could embedded "cost center" information then to the "memo" field that I can fill with OFX?
10:42:01 <dbreiser> straight svn
10:42:44 <jsled> is there an implied "how do I […]?" question there, or are you just stating?
10:42:46 <dbreiser> I keep getting build problems and svn status gives me a bunch of ? files
10:42:49 <lindi-> andi5: so i'd only need to write the report code that could recognize "cost centers" by given fields (and not limited to just Action)
10:43:27 <dbreiser> I've tried svn removing them, but they reappear with autogen and then the build bombs with "no rule to make..."
10:43:47 <andi5> lindi-: you know more about that issue than me, so please do not ask :-D
10:43:57 <andi5> lindi-: at least not me
10:44:24 <jsled> dbreiser: how are you doing the version changes? What sorts of files are '?'ed?
10:45:41 <dbreiser> jsled: I've tried both 'svn update -r16575' and blowing away the tree and 'svn checkout -r16575 http:...'
10:46:39 <dbreiser> the files are the accounts/ja, accounts/(something _CN), and something in the csv import directories
10:47:02 <dbreiser> sorry - the intel is my wife's and she has repossessed her machine
10:47:06 <dbreiser> for the momen
10:47:08 <dbreiser> t
10:47:12 <andi5> i remember that i started ignoring at some point in time
10:47:55 <dbreiser> ignoring how?
10:47:59 <lindi-> andi5: not so sure about that ;-)
10:48:15 <andi5> dbreiser: well, i adjusted svn:ignore properties in some commit
10:48:55 <dbreiser> ok. I'll go look for that commit and see if I can model it for earlier versions that are causing problems
10:49:05 <andi5> i would be more interested in the kind of bomb
10:49:43 <dbreiser> no rule to make libgnc-somethingorother-csv.something
10:50:11 <lindi-> andi5: reports can be written in either C or scheme?
10:50:14 <andi5> did you checkout branches/2.2 or trunk?
10:50:21 <dbreiser> trunk
10:50:41 <andi5> lindi-: ahem... i suppose you will need to write it in scheme...
10:51:37 <andi5> dbreiser: maybe it is easier to start from 2.2.2 on branches/2.2 and then move back to the branching point
10:52:31 <dbreiser> andi5: ok, but I'd like to start at the branch point, since I know 2.2.2 doesn't work
10:52:46 <lindi-> andi5: no problem :)
10:53:18 <andi5> dbreiser: that is r16560, in case you did not know
10:54:11 <dbreiser> andi5: sort of knew that. does that mean r16560 is in both trunk and 2.2?
10:55:11 <dbreiser> so that svn checkout -r16560 http:.../.../branches/2.2 gnucash is a reasonable starting method?
10:55:16 <andi5> well, it means that that repo/gnucash/trunk@r16559 was copied to repo/gnucash/branches/2.2 at revision 16560, so starting at that rev, there are two copies in the repo
10:55:22 <andi5> yes
10:56:44 <andi5> dbreiser: keep in mind that revisions are not tied to single files, but rather the whole repository... what you check out is another story then, of course
10:56:44 <dbreiser> Thanks. It will be a couple hours before I can get back on the intel mac. I'll be back
10:56:55 <andi5> ok, thanks a lot dave
10:57:04 <andi5> or david :-)
10:57:14 <dbreiser> dave is fine
10:57:19 <lindi-> andi5: http://iki.fi/lindi/cost-center-idea1.png is rought draft of what I'd need. does it make any sense? ;-)
10:57:20 <andi5> no, not here..
10:58:35 <lindi-> (hmm, i have the numbers wrong...)
10:59:19 <lindi-> (should be right now)
11:01:39 <lindi-> andi5: i probably should try to develop this against 2.2.x or trunk? any idea if those build on debian stable?
11:08:43 <andi5> both should normally build
11:09:21 <andi5> when building from svn you will not some semi-recent version of swig, but i hope that is available on debian stable
11:09:55 <andi5> 1.3.28 as it seems
11:15:09 *** ecraven has joined #gnucash
11:15:28 <ecraven> greetings
11:15:36 <ecraven> does gnucash support batch editing?
11:15:43 <jsled> no.
11:16:01 <jsled> There's a couple of workarounds for very limited circumstances.
11:16:21 <jsled> Mostly about using account parenting/deleting to move an account's worth of transactions to anotherr.
11:16:41 <ecraven> i mainly need to set one of the two accounts connected to a transaction to some account for all transactions matching some criteria
11:16:59 <jsled> yup, that's pretty common. But not supported at present.
11:17:17 <jsled> Depending on how adept/comfortable you are, editing the datafile might be an option.
11:17:26 <ecraven> i thought about that :)
11:29:02 <andi5> lindi-: are you working with gnucash 2.0.5?
11:29:59 <lindi-> andi5: yeah
11:30:22 <lindi-> andi5: i noticed I don't even need to recompile. i can just edit /usr/share/gnucash/guile-modules/gnucash/report/account-summary.scm and see the changes instantly
11:31:47 <andi5> you do not need to restart gnucash?
11:33:14 <lindi-> andi5: apparently
11:33:36 <andi5> lindi-: gnucash 2.2.2 at least fised #343448: Hide unused horizontal scrollbar ... i think the vertical scrollbar is ok
11:33:47 <andi5> s,fised,fixed,
11:34:21 <lindi-> andi5: good to hear, i'll upgrade when the debian bug gets fixed
11:35:23 <andi5> lindi-: do you know how to resize columns?
11:35:38 <lindi-> andi5: in scheme?
11:35:46 <lindi-> andi5: or do you mean the bug report?
11:36:21 <andi5> oh... i confused two bugs.... well
11:37:08 <andi5> in bug 506261 you basically complain about something that very likely will not change with this register (maybe some day far in the future it will have a better descendent)
11:37:49 <lindi-> andi5: might be true, i just found it very counterintuitive
11:38:13 <andi5> seems like many do
11:38:14 <lindi-> only after i had started writing the bug report i figured out that i need to drag _two_ lines to see the text
11:39:05 <andi5> well, basically it boils down to 1) resize all columns besides description ; 2) double click description header to make it best-fit
11:44:01 <lindi-> i see. when you know it it doesn't seem too unusual. that's why it's good to report usability bugs when you are new to the software :-)
11:44:21 <andi5> yep
11:46:03 <lindi-> anyways, i think i figured out how to generate html table in scheme for the report. now i need to figure out 1) list of cost centers and then for each cost center: 2) balance of every account when only transactions of the given cost center are taken into account
11:46:05 <andi5> if you ever want to really contribute to gnucash, the register-rewrite is a really good place to make friends (and foes) :-D
11:48:06 <andi5> note that gnucash 2.2 uses swig instead g-wrap to export c objects and apis to scheme ... so here you might want to update first, i do not know
11:55:53 *** donfede has joined #gnucash
11:56:39 <lindi-> andi5: i checked the diff and it's fortunately not large
12:28:29 *** dbreiser has quit IRC
12:47:10 *** Def has quit IRC
12:58:33 *** dbreiser has joined #gnucash
12:59:02 *** Def has joined #gnucash
12:59:56 <dbreiser> the 2.2 branch point works on intel macs. Half way there... Is there anything special about picking revisions?
13:00:27 <dbreiser> can I 'svn update -r16620' without worrying if that specific rev deals with branch/2.2?
13:02:29 <chris> dbreiser: it won't change branches. it will be just as if you specified the greatest revision less than 16620 that affected the current branch.
13:02:47 <dbreiser> chris: thanks. that's what I wanted to hear
13:06:56 *** andi5 has quit IRC
13:12:38 *** ecraven has quit IRC
13:46:32 *** Badenser has joined #gnucash
13:48:08 <Badenser> Hi all ... At the moment I start a new GnuCash file for each year to separate all (and keep the performance up ;-). Now I want to migrate all customers and projects etc. to a new file, not only the account structure. Whats the easiest way to do this ... ?
13:50:18 <jsled> Badenser: there isn't a good way at present.
13:51:12 <Badenser> ok
13:52:50 <Badenser> and one final question: my customer paid and now I want to mark this invoice as paid. How can I do this *without* adding a new record but assign an existing record to this invoice ... ?
13:54:35 <jsled> I don't know the answer; if you hang around, someone else might.
13:55:22 <Badenser> oky
14:03:46 *** Badenser has quit IRC
15:17:36 <lindi-> hmm, report generation seems to be bit more complex than i thought :)
15:22:46 *** tjanssen has quit IRC
15:27:46 *** Zoolooc_ has joined #gnucash
15:30:48 *** Zoolooc__ has joined #gnucash
15:35:30 *** Zoolooc has quit IRC
15:38:33 *** Zoolooc_ has quit IRC
15:41:30 *** Zoolooc__ has quit IRC
15:46:36 *** dehuszar has joined #gnucash
15:50:24 <dehuszar> I am just getting started using gnucash and have a few questions that I'm a little stumped on for the moment... The first is: when entering an itemized bill into my accounts payable, can I only enter one tax table? With with my gas bill, I have three separate taxes that are levied against the subtotal. There seems to be no way to do this, only individual tax tables against individual items on the invoice, and I'm wondering i
15:52:37 <lindi-> dehuszar: too long line
15:53:16 <dehuszar> k. Is there a way to use multiple tax tables for accounts payable bills?
15:54:41 <lindi-> dehuszar: sounds like what split transactions are for?
15:54:54 <lindi-> dehuszar: i haven't used them yet but they were mentioned in the manual when i browsed it
15:55:15 <dehuszar> Gas bill has multiple tax rates levied against the subtotal, not the itemizations. I can only add one table to each split.
15:57:02 <lindi-> dehuszar: i'm sorry but i don't understand the problem yet :-)
15:59:30 <dehuszar> There are 3 taxes levied against the subtotal. I can't figure out how to itemize the bits I'm being billed for and still have them taxed properly without making the taxes their own transaction. How am I supposed to run multiple tax tables against the accumulated split?
16:01:07 <dehuszar> ...or at least the subtotal
16:05:56 <lindi-> hrm
16:07:37 *** McLANE has quit IRC
16:09:28 <lindi-> dehuszar: http://www.gnucash.org/docs/v2.0/C/gnucash-guide/txns-registers1.html#txns-registers-multiaccount2 wasn't what you want?
16:13:13 <dehuszar> More or less... and that's sort of what I did, but in the A/P bill, not the check register. But then it makes me wonder what the point of the tax tables are. I want to make sure I'm not making decisions that might muck up reporting or summaries down the road.
16:14:54 <lindi-> mailing list is probably best place to ask. i only started experimenting today
16:15:48 <dehuszar> Another question, this one less technical: when setting up A/P accounts, is it recommended I make separate ones for each vendor, or make one for "Utilities," "Personal Accounts," Business Accounts," or "Dual Use," etc.?
16:17:17 *** McLANE has joined #gnucash
16:47:42 <lindi-> the only reason the reports are not done completely in scheme is performance?
16:49:21 *** Slart has joined #gnucash
16:49:52 <Slart> I couldn't find any installation requirements for windows.. do I need to install gtk? anything else?
17:07:26 *** dehuszar has left #gnucash
17:12:25 <jsled> Slart: I'm not sure, but I believe everything required is in the installer.
17:13:26 <Slart> jsled: indeed everything was included.. but there was a bug with the latest gnome-vfs that gave a strange error about a missing entry point.. the fix was to downgrade gnome-vfs to a earlier version.. it works now
17:13:45 <jsled> Ah, good.
17:13:57 <jsled> lindi-: hmm?
17:14:26 <lindi-> jsled: (gnc:query-add-action-match query "L1" 0 0 'query-and)
17:14:38 <jsled> lindi-: I mean: performance doesn't really have anything to do with it, IIRC. What parts are you referring to when you mean "completely"?
17:15:23 <jsled> Oh. Well, the QofQuery stuff is all in C. So that's just a binding/API to that existing code.
17:16:16 <lindi-> jsled: i added the following match to gnc:account-get-comm-balance-at-date to see if it would be enought to get me balances when only transactions in location "L1" are considered
17:16:37 <lindi-> jsled: for some reason I get only zeroes in "Account Summary" after that one line change
17:16:51 <lindi-> jsled: if I use ".*" regexp it works
17:17:27 <lindi-> jsled: gdb shows that string_match_predicate does compare "L1" against "L1" and "L2" and returns correct return values so i'm bit puzzled here :/
17:17:57 <lindi-> jsled: http://lindi.iki.fi/lindi/cost-center-idea1.png explains my data example in case you didn't check it already
17:18:22 <jsled> Do you know where gnc:query-add-action-match is defined?
17:18:34 <lindi-> yeah
17:19:23 <lindi-> ./engine/Query.h:#define xaccQueryAddActionMatch(q,m,c,r,o) \
17:19:23 <lindi-> ./engine/Query.h- xaccQueryAddStringMatch ((q), (m), (c), (r), (o), SPLIT_ACTION, \
17:19:25 <dbreiser> jsled: r16672 is the change that's crashing SLR and SX editor in intel macs
17:19:26 <lindi-> ./engine/Query.h- NULL)
17:20:15 <jsled> lindi-: is that 2.0.5?
17:20:34 <lindi-> jsled: yes
17:21:40 *** kielein has quit IRC
17:21:42 <jsled> dbreiser: looking.
17:21:49 <dbreiser> thanks
17:22:19 <jsled> *sigh*
17:22:36 <jsled> GUID_ENCODING_LENGTH is 32. But the string is null-terminated, so its really 33.
17:22:45 <jsled> it's, even.
17:22:55 <jsled> I ♡ C.
17:23:00 <dbreiser> heh
17:23:12 <dbreiser> what's the char code of that heart?
17:23:34 <jsled> 2661: WHITE HEART SUIT (♡)
17:23:41 <jsled> (and 2665: BLACK HEART SUIT (♥))
17:24:09 <lindi-> aha, i think i found the bug :)
17:24:32 <jsled> lindi-: oh?
17:25:03 <jsled> dbreiser: Do you have the capability to apply patches at the packaging level?
17:25:07 <dbreiser> yes
17:25:36 <jsled> Well, a "+1" should resolve the issue. Of course I'll commit it and mark it for back port right now, but until 2.2.3 …
17:26:13 <dbreiser> OK. that's really easy to patch in the packaging
17:26:30 <lindi-> jsled: well, a transaction moves money to "Savings Account" from "Other Income". the "Action" field is apparently set for that transaction in "Savings Account" and not in "Other income"
17:26:52 <jsled> Hmm. It's the same transaction, though.
17:26:59 <lindi-> jsled: that's why it's confusing
17:27:03 <jsled> But the "Action" field is per-Split.
17:27:03 <lindi-> i can provide screenshots
17:27:08 <lindi-> per-split?
17:27:16 <jsled> The line-items of a Transaction are Splits.
17:27:21 <lindi-> hmm
17:27:38 <lindi-> jsled: uh, then i probably don't want to use the Action field to implement "cost centers"?
17:27:54 <jsled> I don't know quite what cost-centers are, but probably not.
17:28:34 <jsled> If you don't want to overload/use the Transaction's Description field, you might be okay using its Notes field (accessible via View > Double Line) …
17:28:40 <lindi-> jsled: http://lindi.iki.fi/lindi/cost-center-idea1.png tries to illustrate the idea. the idea is that i have N accounts but also M locations and they form a NxM matrix
17:29:04 <lindi-> jsled: and i should be able to get "Account summary" for each location separately
17:29:05 <jsled> Unfortunately, that field is stored in the KVP frame of the Transaction, so you'll need to pay the indirection tax to Query against it.
17:29:59 <jsled> Well, depending on how much work you want to do, you could Query for the Splits with the relevant Action, then dereference/navigate to their parent Transactions.
17:30:09 <lindi-> uh oh
17:30:19 <lindi-> a simple solution would be ok for me, i don't need performance
17:30:37 <lindi-> maybe i'll just export the data and do this with an external program?
17:31:54 <jsled> Perhaps, though you might not like the Exporting landscape; http://wiki.gnucash.org/wiki/FAQ#Q:_How_can_I_export_data.3F
17:32:41 <lindi-> jsled: i'm still puzzled by why the Action field is not visible in both source and destination accounts
17:33:02 <jsled> Because the field is on the Split, and the Split only references one account.
17:33:08 <lindi-> ok
17:33:11 <jsled> The data model is basically the same as the register view.
17:33:12 <lindi-> so i'll just the Notes field
17:33:20 <lindi-> +use
17:33:39 *** Zoolooc has joined #gnucash
17:34:29 <jsled> The Transaction contains a list of Splits. The date, description, number and notes are fields of the Transaction. The fields of the Split are action, memo, transfer/account and a GncNumeric, representing the commodity/currency, amount and value relative to that Account.
17:34:50 <jsled> The sum of the numerics of all Splits in a Transaction must be zero.
17:35:00 <lindi-> ok
17:36:55 <jsled> Hmm. I probably should have referenced those bugs in the commit.
17:43:51 <dbreiser> oh well. I probably won't be able to test until tomorrow. My wife has plans for dinner :)
17:43:57 <dbreiser> thanks for the help.
17:44:20 *** dbreiser is now known as dbreiser-afk
17:44:37 <jsled> dbreiser-afk: thanks!! Take care.
17:50:31 *** dehuszar has joined #gnucash
17:50:41 <lindi-> jsled: gnc:query-add-memo-match is probably for the "Notes" field?
17:53:04 <dehuszar> Is there any reason why I can't just pay a bill using a standard transaction instead of process payment? I sometimes have to pay 2 bills at a time, and the process payment only allows me to select one bill at a time complicating reconciliation.
17:53:06 <lindi-> jsled: would be nice to be able to print what it's comparing against in scheme, having to recompile the C part takes a long time
17:54:50 <lindi-> jsled: ah no, memo must be part of the split then
17:55:05 <lindi-> jsled: there does not seem to be a match for Notes :/
18:03:59 <lindi-> jsled: this is why i'd like to do it in scheme :-)
18:30:29 *** fell has joined #gnucash
18:53:11 *** tim_abell has joined #gnucash
19:15:15 *** dehuszar has left #gnucash
19:16:16 *** hoffmanc has joined #gnucash
19:20:42 <hoffmanc> hello. Is there another alternative other than LB for budgeting in GnuCash?
19:21:08 <hoffmanc> LB = the little budgeting tool
19:21:41 <hoffmanc> I can't even get the thing installed, and it seems like it would be painfully simple to integrate such functionality into gnucash
19:22:56 <hoffmanc> nevermind, I'm reading the FAQ now. Perhaps an update to the Budgeting section would be in order, though.
19:57:56 <tim_abell> hoffmanc, i'm currently also contemplating the budgeting facilities, not that i'll necessarily be much help
20:08:40 <hoffmanc> tim_abell: 2.0 has nice support, at least as far as the FAQ indicates
20:09:13 <tim_abell> i've just built from svn head again :-D
20:09:47 <tim_abell> it's marked as 2.2.99 now for some reason
20:10:44 <tim_abell> just trying to work out why the edit scheduled transaction dialog is picking up the wrong item when i save it...
20:30:08 *** McLANE has quit IRC
20:44:11 *** hoffmanc has quit IRC
21:25:40 <IanL> What is the purpose of asking the currency during the QIF import?
21:25:40 <gncbot> IanL: Sent 2 days, 10 hours, and 1 minute ago: <andi5> you wanted to avoid messing up your ~/.gnucash directory when using different gnucash versions in parallel.... please try to use the environment variable GNC_DOT_DIR... you can find its exact semantics in src/engine/gnc-filepath-utils.c:gnc_dotgnucash_dir
21:26:12 <IanL> I ask because currently it only asks if you create new accounts
21:27:08 <IanL> I'm looking at fixing the flow of the QIF import druid and I'm thinking that that page should always be shown.
21:28:37 * IanL realizes that living in a radically different time zone has it's disadvantages
21:29:25 <IanL> (everyone is probably asleep)
21:34:49 <fell> Good morning, Tokyo. I fear, they are in weekend.
21:36:27 <IanL> Good morning from Tokyo. Yah, I imagine people may be sparse the next few days,
21:38:27 *** benoitg has joined #gnucash
21:41:39 <tim_abell> i'm in the UK and really should be asleep
21:42:12 <tim_abell> (02:42am)
21:42:43 <fell> ... preparing New Year. I don't use QIF, so I can't help you. but your Question about ~/.gnucash helped me also.
21:43:39 <IanL> ok, good.
21:44:02 <IanL> using neither HOME or GNC_GCONF_DIR seemed to help.
21:44:23 <IanL> fell: you doing testing of some sort?
21:45:02 <fell> at the moment I "test" the german translation.
21:48:09 <IanL> ah,
21:48:10 <fell> IanL, a workaround could be a batch or shell file for switching by copying between .gnucash-test and .gnucash-work
21:48:43 <IanL> yah,
21:49:33 <IanL> I just thought I might maintain several test home directories and wanted an easy way of launching gnucash against a particular home directory.
21:51:12 <fell> I think, that I possible got a crash a few days ago, because I always change between svn vs. 2.2.2 and LANG=C vs. DE.
21:52:29 <tim_abell> nuts. i can't get KDevelop to attach gdb to gnucash :(
22:00:26 *** tim_abell has quit IRC
22:03:29 *** stlgirl has joined #gnucash
22:05:38 *** McLANE has joined #gnucash
22:06:53 <stlgirl> can a new version be installed over an old one without data loss?
22:08:30 *** McLANE has quit IRC
22:11:03 <fell> stlgirl, what means installed over?
22:13:58 <stlgirl> ...?
22:14:35 <stlgirl> what's the confusing part?
22:15:22 <fell> installing from svn, tar, deb rpm?
22:16:50 <fell> have a look at http://www.gnucash.org/ "GnuCash 2.2.0 released" about changes in data format
22:18:05 <IanL> stlgirl: Basically he's asking how you are installing gnucash.
22:18:19 <IanL> fell: do you use OFX import?
22:19:29 <stlgirl> *sugh*U
22:19:35 <stlgirl> *sigh*
22:20:30 *** donfede has quit IRC
22:21:03 <stlgirl> 'twas just supposed to be a simple question. forget it.
22:23:24 <fell> IanL: in DE HBCI is common for online banking. My import of MS-files was more than 5 years ago.
22:23:40 <IanL> nods,
22:24:03 <IanL> stlgirl: Sorry. there are a number of ways to install gnucash. are you using windows?
22:24:12 <IanL> If so I think there shouldn't be a problem.
22:24:37 <stlgirl> i have installations on multiple os'
22:24:49 <fell> stlgirl, which Version do you have and which do you want to install?
22:26:01 <stlgirl> is the qif import for 2 or 4 digit qif files?
22:26:30 <IanL> stlgirl: it can handle both I believe
22:27:31 <IanL> if by 2 and 4 digits you mean 2 and 4 digit years.
22:29:50 *** benoitg has left #gnucash
22:33:18 *** dbreiser-afk has quit IRC
22:50:53 *** Zoolooc_ has joined #gnucash
22:56:51 *** mjchang has joined #gnucash
22:59:12 *** dbreiser has joined #gnucash
23:00:12 *** Zoolooc has quit IRC
23:12:57 *** wizkid239 has joined #gnucash
23:18:07 *** ttick has joined #gnucash
23:19:22 <ttick> does anyone know if QIF supports splits? I'm converting a CSV to something importable, and trying to do it with split transactions.
23:20:11 *** wizkid238 has quit IRC
23:24:35 <IanL> ttick: Yes it does.
23:30:26 <IanL> If you are writing it by hand you need to use the 'S' field identifier
23:30:35 <IanL> see this example: http://paste.lisp.org/display/53262
23:31:32 <IanL> The QIF section in my google notebook has more info on the QIF format: http://www.google.com/notebook/public/15175340803479774874/BDQGkIwoQ__PHquoi
23:34:50 <ttick> thanks, IanL
23:35:43 <IanL> np
23:55:08 *** d0lph1nK1ng has joined #gnucash
23:55:18 <d0lph1nK1ng> anyone use vista?
23:56:10 <d0lph1nK1ng> i can not get online banking to work, i get a QT error
23:56:34 <d0lph1nK1ng> QT-somethin-3.exe has unexpectedly quit