2014-01-06 GnuCash IRC logs

00:01:52 *** Xuefer has quit IRC
00:36:57 *** LiamH1 has quit IRC
02:00:19 *** aqua___ has joined #gnucash
02:32:31 *** jmd has joined #gnucash
02:32:40 *** Xuefer has joined #gnucash
02:32:42 *** jmd has quit IRC
02:39:34 *** jmd has joined #gnucash
02:41:28 *** fell_ has joined #gnucash
02:41:29 *** gncbot sets mode: +o fell_
02:42:20 *** Xuefer_WBEaE has quit IRC
02:42:30 *** jmd has quit IRC
02:44:45 *** fell has quit IRC
04:10:00 *** john has quit IRC
04:18:24 *** aqua___ has quit IRC
04:19:27 *** aqua___ has joined #gnucash
04:20:19 *** Xuefer_WNrYw has joined #gnucash
04:29:06 *** Xuefer has quit IRC
05:04:08 *** Xuefer_WNrYw has quit IRC
05:13:23 *** mikee-afk has quit IRC
05:37:51 *** mikee has joined #gnucash
05:37:51 *** gncbot sets mode: +o mikee
05:52:40 <mikee> @op
05:52:41 *** gncbot sets mode: +o mikee
05:52:50 *** mikee is now known as mikee-afk
07:04:35 *** goibhniu has joined #gnucash
07:07:17 *** Jimraehl has joined #gnucash
07:12:23 *** Jimraehl has quit IRC
07:19:00 <goibhniu> Hi, I wonder if anyone is familiar with the --enable-local-install configuration option for gwenhywfar? ... I'm trying to add aqbanking support to the gnucash package for the distro I use. It would be really nice if I could keep the gwenhywfar plugins which aqbanking builds in the same place as aqbanking, and I suspect this is possible when enable-local-install is used, but I don't see how to actually use it (or I am mistaken).
07:21:05 <goibhniu> hmm, perhaps I need to place the plugins somewhere near gnucash rather than aqbanking
07:30:21 *** StuM has quit IRC
07:33:50 *** jmd has joined #gnucash
08:08:22 *** uXus has quit IRC
08:09:09 *** mikee-afk has quit IRC
08:13:56 *** fell_ is now known as fell
08:14:13 <fell> goibhniu: which distro?
08:34:26 <goibhniu> hi fell, NixOS is the distro ... I think I may have found something ... just testing now
08:37:03 <goibhniu> oops .. segfaults :D
08:41:40 <fell> Interesting approach of that distro. Gnucash was built with configure --enable-aqbanking?
08:43:32 <goibhniu> yeah, I like it a lot
08:43:36 <goibhniu> yep, I have that open set
08:44:29 <goibhniu> https://www.mail-archive.com/aqbanking-devel@lists.sourceforge.net/msg03566.html is the best reference I've found so far to the --enable-local-install option
08:44:47 * goibhniu is trying another approach now
08:51:18 <fell> I am still wondering, why you will need that. Does NixOS not fillow the FHS (file hierarchy standard)?
08:51:57 <goibhniu> it doesn't ... there are other ways of doing it, but this seemed like an elegant approach
08:52:33 <goibhniu> in NixOS every package has its own path, and one package can't install stuff into another
08:54:34 <goibhniu> hmm .. it seems to insist on looking for the aqbanking plugins in gwenhywfar and crashes .. I guess I will have to do something else
09:07:35 *** todd has quit IRC
09:20:38 *** todd has joined #gnucash
09:23:31 *** StuM has joined #gnucash
09:25:42 *** todd has quit IRC
10:11:52 <fell> goibhniu: AFAIK gwenhywfar is a helper lib - abstracting OS dependend things - of aqbanking.
10:12:22 *** linas has quit IRC
10:12:49 <fell> So the best advice you can get by Martin "Aquamanic" at aqbanking.de
10:13:59 *** linas has joined #gnucash
10:21:24 <goibhniu> thanks fell
10:35:59 *** himaxx has joined #gnucash
10:40:49 *** himaxx has quit IRC
10:48:57 *** benoitg has quit IRC
10:59:45 *** rpg has joined #gnucash
11:02:43 *** uXus has joined #gnucash
11:07:37 *** himaxx has joined #gnucash
11:22:04 *** himaxx has quit IRC
11:43:58 *** benoitg has joined #gnucash
11:55:47 *** aqua___ has quit IRC
12:00:21 *** aqua___ has joined #gnucash
12:03:36 *** mikee has joined #gnucash
12:03:36 *** gncbot sets mode: +o mikee
12:08:30 <mikee> @op
12:08:30 *** gncbot sets mode: +o mikee
12:16:38 *** anna_puk has joined #gnucash
12:17:13 *** mikee is now known as mikee-afk
12:18:35 <anna_puk> I recently installed GnuCash (on Windows 7) and to my surprise, it's all in Dutch. I am in the Netherlands, but my Windows installation is in English and I prefer my applications to be in English as well. I've already tried changing the LANGUAGE parameter in the environment file (as recommended on the wiki) but that didn't change anything.
12:21:02 *** john has joined #gnucash
12:21:02 *** gncbot sets mode: +o john
12:21:29 <warlord> anna_puk: What does your environment file look like? That should override any system settings.
12:22:36 <anna_puk> I tried reinstalling (which didn't help) and now it ends with:
12:22:37 <anna_puk> # If you wish GnuCash to use a different language, uncomment the two parameters # below and set LANG to your preferred locale # LANG=nl_BE # LANGUAGE={LANG} GNC_DBD_DIR={GNC_HOME}/lib/dbd
12:23:14 <anna_puk> I have no idea where it got the _BE from, that would be Belgium.
12:23:39 <john> That would be Geert. ;-)
12:25:49 <warlord> anna_puk: Right, so those lines are still commented out, meaning it would use your system locale. I don't know how it determines the system locale on Windows.
12:25:54 *** aqua___ has quit IRC
12:26:26 <warlord> you can force it to english by uncommenting those lines (remove the '# ' in front of the lines) and then change nl_BE to... en_US (or en_GB, or whichever base currency you want to use)
12:27:34 <anna_puk> I tried that, but it didn't work.
12:27:48 <anna_puk> oh, never mind
12:27:48 <warlord> anna_puk: show me the last two lines of your environment file when it didn't work
12:28:03 <anna_puk> I didn't read # as being a comment symbol.
12:29:01 <warlord> Yeah..
12:29:10 <warlord> (perhaps that should be more explicit)
12:32:26 <anna_puk> Well, I mainly wasn't thinking clearly... and reading too quickly.
12:33:23 <anna_puk> I think that when it said 'uncomment the two parameters # below', I was reading that as 'uncomment the two parameters, which in this particular language are assigned by prefixing a line with #' - I actually thought the # was what made it work, not the other way around.
12:33:55 <anna_puk> Anyway, it worked - everything is in English now so it looks nicely familiar.
12:33:57 <anna_puk> Thanks heaps!
12:34:17 <warlord> you're welcome, anna_puk
12:34:51 *** anna_puk has quit IRC
12:36:36 *** Krzysiek_K has joined #gnucash
12:36:41 *** Krzysiek_K has left #gnucash
12:46:02 *** aqua___ has joined #gnucash
12:48:00 *** benoitg has quit IRC
12:57:17 *** kanru has quit IRC
12:58:19 *** kpreid has quit IRC
12:59:44 *** StuM has quit IRC
13:03:15 *** aqua_ has joined #gnucash
13:06:45 *** benoitg has joined #gnucash
13:11:46 *** aqua___ has quit IRC
13:13:46 *** benoitg1 has joined #gnucash
13:13:47 *** benoitg has quit IRC
14:15:20 *** aqua_ has quit IRC
14:50:05 *** edm has joined #gnucash
14:52:25 *** goibhniu1 has joined #gnucash
14:56:55 *** goibhniu has quit IRC
15:02:53 *** aqua_ has joined #gnucash
15:38:54 *** aqua_ has quit IRC
16:10:28 *** aqua___ has joined #gnucash
16:24:10 *** jmd has quit IRC
16:59:11 *** reaper has joined #gnucash
17:01:37 <reaper> greetings #gnucash -- i've been searching for a while, but can't figure out: is there a way to generate a report based on the tax table? specifically, i'm running a small business, and the state wants to know my total (sales-tax worthy) income, plus my income per tax region, which i'm tracking with the tax table. i can get a transaction report by setting up my accounts better than i have, but i can't find a way to see total invoice income with ass
17:02:24 <warlord> reaper: your question ended at "income with ass"
17:02:30 <reaper> it looks like it wants to be a custom report, but my programming abilities do not currently stretch to scheme (never touched anything lisp-like before, i've only got a C/perl/javascript background)
17:02:35 <warlord> (which, albeit amusing, doesn't help us.. )
17:02:36 <reaper> oh, le sigh
17:03:01 <warlord> But no, we do not have a report to give you the info you need right now.
17:03:02 <reaper> that concluded, "see total invoice
17:03:03 <reaper> income with associated tax liability in a summary form"
17:03:14 <reaper> i figured that was the answer
17:03:27 <reaper> i've spent a couple hours wielding all the google-fu i had, but no luck
17:03:30 <warlord> Do you have each tax go to a different withholding account?
17:03:42 <reaper> i will in the future, that's the workaround i figured out today
17:03:47 <warlord> If so you MIGHT be able to run a transaction report filtering on those accounts
17:03:54 <warlord> If not..... then no.
17:03:57 <reaper> yeah, that's what i was going to do
17:04:04 <warlord> There's no reference back to the TaxTable objects at all.
17:04:46 <reaper> i may be misunderstanding transaction report filtering -- if i select, say, "income:sales" as the account to report on, is there any way to link back through invoices to see where the taxes went?
17:04:54 <reaper> er. wait
17:04:57 <reaper> that was very poorly phrased
17:05:06 <warlord> No
17:05:22 <warlord> Well, not via the Tax Tables, only via the destination withholding account(s)
17:05:27 <reaper> transaction report on income:sales. filtering to/from sales tax accounts comes up with no entries matching
17:06:05 <reaper> the key that i can't find is how to associate "i took in $500" with "i also collected $50 in sales tax for the state"
17:06:29 <reaper> i can do a tax invoice, but it's lke i want to do that for a range of invoices, rather than a single invoice
17:07:19 <warlord> For that I'd run multiple reports.. I:S for the "I took in $500" and then your withholding accts for "I collected $50 in tax"
17:07:21 <reaper> actually, if i could do a batch tax invoice, that would be quite close to what i want
17:07:39 <warlord> You would need to impement that.
17:08:02 <reaper> oh ok, so actually just run two separate reports, and hand-correlate the data between sales and tax entries?
17:08:19 *** aqua___ has quit IRC
17:08:42 <reaper> i thought of that, but that kept looping back to "there should be a way to automate this." ;)
17:08:50 <warlord> Possibly based on that or the aging report (which knows how to iterate over all the items in A/R
17:09:05 <reaper> i'll take a look at the aging reports, i haven't done that yet
17:09:15 <warlord> It's not what you want
17:09:27 <warlord> But it has some of the logic.. Just does different functions on the list.
17:09:37 <reaper> you mean use the aging report as a basis for writing a new report?
17:09:40 <warlord> You will definitely need to write some Scheme to do what you want
17:09:48 <reaper> yeah, that seems like a given
17:10:08 <reaper> but it also seems like if i can pull it off, that would be a valuable report to contribute back
17:11:12 <reaper> i am in washington state, and don't imagine other states have completely dissimilar sales tax reporting methods
17:12:08 <reaper> could i come back here with scheme questions? it's sufficiently far from my experience that i would expect to have a pretty substantial learning curve
17:12:29 <warlord> Sure!
17:12:48 <warlord> I recommend you start by googling "MIT Scheme Reference" which should give you pointers to some good intro guides
17:13:13 <warlord> IMHO scheme is REALLY easy to learn.. If you understand other real programming languages (which it sounds like you do) the scheme *syntax* is something you can learn in 1 day..
17:13:50 <warlord> All the nuances can take a while, but you generally dont need to learn those to write a report. It just might not be the most "elegant" code, but it will be functional (which is all you really care about, right?
17:15:20 <reaper> pretty much. good to know. yeah, it's the syntax that's throwing me. i've been writing perl for 20+ years, and c for longer but less frequently
17:16:15 <warlord> The #1 difference between perl/C and scheme is that the function/procedure is that the open-paren happens before the function/procedure instead of after
17:16:30 <warlord> So instead of calling sum(x, y, z) you would call (sum x y z)
17:17:11 <warlord> oops, remove the "is that the function/procedure"
17:18:12 <reaper> cool
17:18:56 <warlord> The second thing is that everything is a list.. functions, arguments, data, ...
17:18:58 <reaper> i thought lisp was pretty heavily recursion-dependent, which can be hard to parse along with unfamiliar syntax, but perhaps i have that wrong
17:19:39 <reaper> can i safely think of them like arrays in c/perl?
17:19:40 <warlord> It is not dependent.. You can certainly iterate instead of recurse. But yes, recursion is heavily used. Note that you can recurse in C/perl as well
17:19:49 <reaper> of course ;)
17:20:05 <warlord> pretty much, yes, except you dont have pointers or indexes into them, generally
17:20:12 <warlord> (there are exceptions, of course)
17:20:20 <reaper> do you typically just iterate over them in order?
17:20:28 <warlord> Yes
17:20:39 <reaper> i saw a foreach loop in one of the samples i looked at
17:20:49 <warlord> (for-each (lamdba (x) ....) item-list)
17:21:03 <reaper> cool
17:21:14 <warlord> where (lamdba (x) ...) is the procedure you call on each item in the item-list
17:21:16 <reaper> well, armed with that, i'll take another look. thanks for the pointeres
17:21:21 <warlord> You're welcome.
17:21:22 <reaper> er. pointers
17:21:27 <warlord> (we'd love to have more schemers here)
17:21:28 <reaper> i kin speel, rilly
17:21:32 <warlord> LOL
17:22:02 <reaper> oh, interesting. i'll have to find a reference on the syntax, sounds like that's going to be my major learning curve
17:22:41 <reaper> i don't have a lot of free time to dedicate to this, but it's a report i'd like to have, and if i can make something functional, i'd love to contribute back to the project
17:28:39 <warlord> that would be great
17:28:41 <warlord> thanks
17:29:14 <reaper> heh. thank me when i've actually contributed. i'll see what i can work out, though.
17:29:38 <warlord> ok
17:29:50 <reaper> gnucash seems pretty awesome, so i'll be glad if i can help make it even better
17:54:40 <warlord> :)
18:19:29 *** wizkid238 has quit IRC
18:24:04 *** wizkid238 has joined #gnucash
18:32:29 *** goibhniu1 has quit IRC
18:34:43 *** edm has quit IRC
18:35:13 *** todd has joined #gnucash
19:54:37 *** benoitg1 has quit IRC
20:19:30 *** LiamH has joined #gnucash
21:34:39 *** kanru has joined #gnucash
21:43:12 *** rpg has quit IRC
22:11:52 *** wiggin has joined #gnucash
22:12:03 <wiggin> hey how should i compile gnucash with a sqlite backend?
22:12:24 <wiggin> i have all the proper libs, and configuring with --with-dbi
22:12:55 <wiggin> but when i open and select open the only backend thats available is file
23:13:19 *** LiamH has quit IRC
23:20:53 *** benoitg has joined #gnucash
23:42:56 *** fell_ has joined #gnucash
23:42:57 *** gncbot sets mode: +o fell_
23:42:57 *** fell has quit IRC
23:53:20 *** fell__ has joined #gnucash
23:53:20 *** gncbot sets mode: +o fell__
23:54:54 *** fell_ has quit IRC