2007-03-13 GnuCash IRC logs

00:05:12 <warlord> hampton2: so how would this new format support something like the new Canadian format?
00:06:17 <hampton2> Either 1) add an item of type TEXT at the right coordinates, or 2) set a gconf key and let gnucash do it for you. :-)
00:06:46 <hampton2> I need to add preferences support for setting the gconf key.
00:06:55 <hampton2> I also need to write documentation.
00:07:16 <warlord> How would TEXT help with a new "date" format, for example?
00:07:37 <hampton2> any text based item (i.e. anything but a picture) supports custom font and alignment
00:07:48 <warlord> Also, do we want to tie the Vendor DB into the check-printing in order to print addresses?
00:08:23 <hampton2> sure. we could add a new ADDRESS item that pulls from the vendor DB
00:08:48 <warlord> Maybe a check-type registry?
00:08:56 <hampton2> item type TEXT, coordinates whatever, text to print YYYMMDD, font "sans 8"
00:09:34 <warlord> oh, I wasnt thinking about the "YYYYMMDD", but the 20070313
00:09:36 <hampton2> that could be done
00:10:05 <hampton2> the check print dialog already supports custom date formats.
00:10:39 <warlord> ok.
00:11:36 <hampton2> If you set the custom date format to "%Y%m%d", gnucash will print today's date as 20070313, and the new code can also parse that format to produce the "YYYYMMDD"
00:12:33 <warlord> Ah, okay
00:13:02 <hampton2> should we add a new QOF date format for YYYYMMDD? :-)
00:13:20 <warlord> Probably not.
00:13:50 <hampton2> AFAICT, the spec as written only applies to companies that print checks using magnetically readable ink.
00:14:21 <warlord> Huh. Must've missed that.
00:15:14 <hampton2> I'm accepting Gilles statement that his check printer said it was also the responsibility of check printing software.
00:15:38 <warlord> ok
00:16:13 <hampton2> Figured it couldn't hurt to add it. I was going to key it off the locale being en_CA or fr_CA, then I realized that someone might get checks that already had the date format printed on it.
00:18:50 <warlord> Yeah, would be nice to let the user choose the date format, and have YYYYMMDD be one of the formats. Then again DDMMYYYY might be another format for pre-printed cheques.
00:20:13 <hampton2> right. I figured users can set whatever they want using the existing dialog that allows custom date formats.
00:26:43 <warlord> Ok.
00:26:56 <warlord> I suppose if they can save their formats then that would help tremendously!
00:27:56 <hampton2> The custom date format (and all the other custom info) is saved across instantiations of the dialog.
00:30:38 <warlord> But is it possible to save off a .chk config file?
00:31:03 <hampton2> From the check print dialog? No. I considered adding that.
00:31:26 <warlord> Might be a cool feature ;)
00:31:41 * hampton2 chuckles
00:31:55 <hampton2> I'm implementing searching for image files atm.
00:31:57 *** dbr has joined #gnucash
00:32:38 <dbr> hampton2: How 'bout adding the check number to things that can be printed?
00:33:19 <dbr> When I rolled my own in Foxpro, I always printed the check number on the stub just to verify that my records matched the printed version.
00:33:25 <hampton2> sure, why not?
00:33:33 <hampton2> good point
00:40:52 <warlord> hampton2: Oh, and for the record, nice job! :)
00:40:57 <warlord> (and thank you)
00:40:59 <hampton2> thanks
00:47:10 <warlord> I figured I should be explicit in the appreciation for your work (in addition to the critiques and "hey, could you ..."
00:47:13 <warlord> )
00:48:21 <dbr> Thanks from the peanut gallery, too! :)
00:50:17 <hampton2> thx warlord
00:50:31 <hampton2> thx dbr
00:55:44 <warlord> okay, bedtime for me.
00:55:46 *** warlord is now known as warlord-afk
01:09:58 *** dbr has quit IRC
01:14:22 *** aj has quit IRC
01:14:22 *** aj has joined #gnucash
02:14:15 *** datakid23 has joined #gnucash
02:14:55 <datakid23> I can't seem to add a taxable element to an invoice I'm editing?
02:15:12 <datakid23> once I hit tab or return on the discount field it auto jumps to the next line?
02:16:05 <datakid23> =qualify= I can actually change the state of the "Taxable?" field, but when I remove the X, it then jumps to the next line
02:18:40 <datakid23> ah! but if I leave it crossed, and then choose my GST table from the drop down list of tax tables, it includes them?
03:01:42 *** datakid23 has quit IRC
03:59:03 *** nomeata has quit IRC
04:57:37 *** nomeata has joined #gnucash
05:05:50 *** ceplma has joined #gnucash
05:16:51 *** ErKa has joined #gnucash
06:25:12 *** ErKa has quit IRC
07:48:03 *** ErKa has joined #gnucash
07:52:12 *** aphexer has joined #gnucash
07:52:51 <aphexer> when i want a new scheduled transaction that runs on 20/2, 20/4, 20/6 ... that would be a "semi-monthly" one with the optiont "every 2 months" right?
08:17:04 <jsled> aphexer: No, that would be monthly.
08:17:21 <jsled> Semi-monthly is similar to bi-weekly: twice a month.
08:18:30 <aphexer> jsled, oh, what could i use instead?
08:18:50 <jsled> Monthly (x2)
08:19:35 *** BlackBsd has joined #GnuCash
08:28:00 <aphexer> oh great, thanks:)
08:35:52 *** hampton2 has left #gnucash
09:04:37 *** warlord-afk is now known as warlord
09:35:28 *** aphexer has quit IRC
09:58:27 *** hampton2 has joined #gnucash
09:58:27 *** gncbot sets mode: +o hampton2
10:01:08 <chris> hampton2: awesome job w/ check printing!
10:06:08 * warlord is rebuilding and testing trunk
10:06:38 <hampton2> thanks chris
10:06:53 *** hampton|away has quit IRC
10:07:01 *** hampton2 is now known as hampton
10:08:14 <warlord> hampton: It didn't build on FC5:
10:08:25 <warlord> dialog-print-check.c: In function 'format_read_item_placement':
10:08:25 <warlord> dialog-print-check.c:433: warning: implicit declaration of function 'g_key_file_get_double_list'
10:08:25 <warlord> dialog-print-check.c:434: warning: assignment makes pointer from integer without a cast
10:08:25 <warlord> dialog-print-check.c: In function 'format_read_multicheck_info':
10:08:25 <warlord> dialog-print-check.c:581: warning: implicit declaration of function 'g_key_file_get_double'
10:08:26 <warlord> dialog-print-check.c: In function 'format_read_general_info':
10:08:28 <warlord> dialog-print-check.c:712: warning: assignment makes pointer from integer without a cast
10:08:30 <warlord> dialog-print-check.c: In function 'draw_page_items':
10:08:32 <warlord> dialog-print-check.c:1245: warning: implicit declaration of function 'g_date_set_time'
10:08:34 <warlord> make[4]: *** [dialog-print-check.lo] Error 1
10:10:00 <hampton> Um, wow. I didn't realize that g_key_file_get_double* wasn't added until 2.12.
10:10:15 <jsled> Is there a float version?
10:10:31 <hampton> I don't see one in the docs. :-(
10:11:02 <hampton> I guess I can write them as strings and parse them on input.
10:11:43 <hampton> The g_date_set_time just needs glib-compat.h to be included, I think.
10:11:59 <warlord> We already have number parsers (for gnc_numerics)
10:12:17 <hampton> scanf("%f", string, &double)
10:12:29 <warlord> There is that, too.
10:19:22 *** kielein has joined #gnucash
10:57:20 *** rhowe has quit IRC
10:58:33 *** ErKa has quit IRC
11:02:01 <warlord> hampton: the patch is almost right, but still an issue. check email
11:05:35 *** BlackBsd has quit IRC
11:05:39 <hampton> warlord: Try adding "#include <glib/gi18n.h>" right after the include of glib.h.
11:06:30 <warlord> That worked.
11:06:42 <warlord> it's building now.. I'll let you know how it goes.
11:07:18 *** kielein has quit IRC
11:09:49 <warlord> oops, missed an include:
11:09:50 <warlord> dialog-print-check.c: In function 'draw_page_items':
11:09:50 <warlord> dialog-print-check.c:1247: warning: implicit declaration of function 'g_date_set_time'
11:12:03 <hampton> Oops, I had the compatibility code backwards. Change that to g_date_set_time_t().
11:12:33 <hampton> both places :-)
11:13:54 <warlord> okay.....
11:14:18 <warlord> that worked.
11:14:38 <warlord> So... would you like the honor of committing?
11:14:43 <warlord> (it's your code)
11:15:41 <hampton> sure. thanks for test compiling
11:15:48 <warlord> np
11:15:53 <warlord> thanks for fixing
11:15:56 *** BlackBsd has joined #GnuCash
11:15:59 <hampton> np
11:23:17 <warlord> Yay. build finished. running checks now.
11:26:43 *** minDscrm has joined #gnucash
12:40:20 *** ceplma has quit IRC
12:44:47 *** ErKa has joined #gnucash
13:06:12 *** andi5 has joined #gnucash
13:06:12 *** gncbot sets mode: +o andi5
13:34:01 *** warlord has quit IRC
13:34:38 *** twunder has joined #gnucash
13:41:10 *** _gunni_ has joined #gnucash
13:51:11 *** _gunni_ has quit IRC
13:57:33 *** warlord has joined #gnucash
13:57:34 *** gncbot sets mode: +o warlord
14:00:02 *** hampton has quit IRC
14:02:51 *** slicslak has joined #gnucash
14:04:19 *** slicslak has quit IRC
14:05:49 *** andi5 has quit IRC
14:08:39 *** hampton2 has joined #gnucash
14:08:39 *** gncbot sets mode: +o hampton2
14:08:45 *** hampton2 is now known as hampton
14:10:22 *** warlord is now known as warlord-afk
14:25:31 *** andi5 has joined #gnucash
14:25:31 *** gncbot sets mode: +o andi5
14:29:30 *** dsch04 has quit IRC
14:59:21 *** _gunni_ has joined #gnucash
15:15:16 *** ErKa has quit IRC
15:34:25 *** BlackBsd has quit IRC
15:42:49 *** BlackBsd has joined #GnuCash
16:06:58 *** sjc has joined #gnucash
16:13:27 *** BlackBsd304 has joined #GnuCash
16:13:36 *** BlackBsd has quit IRC
16:13:44 *** andi5 has quit IRC
16:15:12 *** warlord-afk is now known as warlord
16:39:45 *** ceplma has joined #gnucash
16:40:32 *** hampton has left #gnucash
16:43:55 *** BlackBsd304 has quit IRC
16:44:47 *** BlackBsd has joined #GnuCash
16:57:09 *** jcbhnnn has joined #gnucash
16:57:42 *** twunder has quit IRC
17:11:39 *** hampton2 has joined #gnucash
17:11:47 *** hampton2 is now known as hampton|away
17:22:57 *** BlackBsd has quit IRC
17:34:05 *** dbr has joined #gnucash
17:59:46 *** sjc has quit IRC
18:04:28 <jcbhnnn> I have a question about the _sale_ of a house (with mortgage) that I haven't been able to answer by looking through the mailing lists or the logs of this channel. Is this an appropriate place to ask a usage (rather than technical) question?
18:09:57 <warlord> ask away.
18:13:08 <jcbhnnn> Great, thanks. The problem that I'm having is the fact that the examples in the concept guide all presuppose that you've paid off your loan. When I recently sold my house, this was not the case. I'll try to input some transaction splits to show what I'm talking about.
18:13:58 *** sjc has joined #gnucash
18:14:08 <jcbhnnn> Here is my purchase split:
18:14:39 <jcbhnnn> Account Increase Decrease
18:14:45 <jcbhnnn> Assets:Fixed Assets:House $100,000
18:14:53 <jcbhnnn> Liabilities:Loans:Mortgage $80,000
18:15:01 <jcbhnnn> Liabilities:Loans:Downpayment $20,000
18:15:20 <jcbhnnn> The numbers are altered for simplicity
18:16:09 <jcbhnnn> Now say that I sell the house after having paid 2000 against the principle
18:16:23 <jcbhnnn> Liabilities:Loans:Mortgage Increase:$78,000
18:16:35 <jcbhnnn> Liabilities:Loans:Downpayment increase: $20,000
18:16:49 <jcbhnnn> Expenses:RealEstate:RealtorCom increase: $6,500
18:17:10 <jcbhnnn> Assets:Fixed Assets:House Decrease:$100,000
18:17:28 <jcbhnnn> Income:Capital Gains:House decrease: $30,000
18:18:48 <jcbhnnn> Would the final line be an increase of 25,500 into the current assets:savings (or whatever)?
18:18:49 <warlord> okay....
18:19:01 <warlord> Yes.
18:19:16 <warlord> Or wherever you put the proceeds of the sale.
18:19:40 <jcbhnnn> Hmm... Ok, this makes a lot more sense as I'm typing it out than it did when I was trying to put it into gnucash! ;)
18:20:04 <warlord> Hehe
18:21:01 <jcbhnnn> Ok, thanks a lot. I go back and give it another try before I ask any more questions.
18:23:28 <warlord> Ok
18:32:35 *** rhowe has joined #gnucash
18:38:14 *** ceplma has quit IRC
18:43:09 *** fiveiron has left #gnucash
19:14:57 *** _gunni_ has quit IRC
19:34:07 *** nomeata has quit IRC
19:39:22 *** _gunni_ has joined #gnucash
19:45:09 *** _gunni_ has quit IRC
19:55:03 *** BlackBsd has joined #GnuCash
20:23:48 *** lumien has joined #gnucash
20:23:57 <lumien> hello, anyone awake to answer a question?
20:24:12 <jsled> Don't meta-ask, just ask.
20:24:47 <lumien> I know that gnucash can import QIF files, but can it "restore" a full quicken backup?
20:25:18 <jsled> What's a "quicken backup"?
20:25:35 <lumien> when your in quicken, you have the option to import, export, and backup and restore backup
20:25:52 <lumien> exporting only exports 1 account to a qif file, but i have a "backup" that has all my accounts
20:26:36 <jsled> no. GnuCash doesn't know anything in particular about Quicken, only about QIF.
20:26:48 <lumien> ok thx
20:26:50 *** lumien has quit IRC
20:26:52 <warlord> lumien: gnucash CAN import a QIF file with multiple accounts.
20:47:14 *** zandoval has joined #gnucash
20:47:35 <zandoval> Am I in???
20:47:45 <cortana> in?
20:47:46 <warlord> in what?
20:48:04 <zandoval> Yes just got the xchat working and I did not know if i was connected
20:48:23 <zandoval> Is this the gnucash irc site?
20:48:37 *** jsled changes topic to "Welcome! Don't meta-ask, ASK and WAIT. Gnucash 2.0.5 is released! The remove-group branch has landed - check it out! FAQ: <http://wiki.gnucash.org/wiki/FAQ>. This is a *publically-logged* channel, <http://lists.gnucash.org/logs/>"
20:49:53 <zandoval> OK - Question - How do you remove last years data ffrom accounts in the year
20:50:16 <warlord> zandoval: generally, you dont.
20:50:26 <warlord> but if you REALLY REALY want to start over, you can File -> Export Accounts
20:50:40 <warlord> This will create a new datafile with ONLY your accounts and no data. You'll need to reset the opening balances.
20:50:42 <zandoval> I need the data for 2006 only and when you print them out the expenses for the year before are still there
20:51:07 <cortana> zandoval: when you create a report you can generally specify the start/end date for the report data
20:51:30 <zandoval> Warlord - I see - By exporting each year yoiu just get the data for that year
20:52:24 <jsled> zandoval: no, that's not what he said.
20:52:24 <zandoval> OK - cortana - I am useing the default settings for the reports so its never really asked for a start and end date
20:52:52 <cortana> zandoval: click on the toolbar button with a spanner & wrench on it
20:53:05 <cortana> probably it's got 'options' underneath (i have captions turned off so i dunno)
20:53:10 <cortana> there you can put in the desired dates
20:53:22 <cortana> this is once you have opened hte default report, btw
20:53:41 <zandoval> All Right cortana - will give it a try
20:54:06 <warlord> zandoval: Set the report dates in the report options.
20:54:21 <jsled> zandoval: http://wiki.gnucash.org/wiki/FAQ#Q:_Is_there_book-closing_support.2C_yet.3F might be of interest, but it sounds like the report options are what you want.
20:54:26 <zandoval> Wil try that too warlord
20:57:40 *** BlackBsd has quit IRC
21:02:30 *** andi5 has joined #gnucash
21:02:31 *** gncbot sets mode: +o andi5
21:02:47 <jsled> hey andi5.
21:02:57 <andi5> hiho
21:03:18 <warlord> hi andi5
21:03:52 <andi5> FYI, help support for windows has landed on trunk..... but i will not be able to look at it until tomorrow evening ;-) .... i hope it does not break the build for you :)
21:08:13 <warlord> andi5: I'll check it on FC5 right now
21:08:44 *** jcbhnnn has quit IRC
21:08:49 <andi5> thanks
21:22:52 <warlord> andi5: build succeeded.
21:23:06 <andi5> *sigh*
21:23:30 <andi5> i will check out the checks on windows tomorrow then :-)
21:23:53 <andi5> see you
21:24:15 *** andi5 has quit IRC
21:26:34 <TheNut> Can you have one invoice for multiple jobs?
21:27:53 <TheNut> Or, at least, can it be munged in some way so that I don't have to print multible invoices for one client.
21:33:24 <warlord> TheNut: Sure. The "job" is optional.
21:34:16 <TheNut> I know that.
21:35:01 <TheNut> I am hacking the gc 2 latex package I found and my previous invoices all list a number it items per job, with one or more jobs per invoice.
21:35:41 <TheNut> I could use the job title to demark each group of invoice entries, but it seems I can only have one job per invoice.
21:38:32 <warlord> I dont recall how it's implemented.. It's been too many years since I wrote that code.
21:40:39 <warlord> anyways I need to run. TTYL.
21:40:41 *** warlord is now known as warlord-afk
21:40:42 <jsled> warlord: cheers
21:49:13 *** zandoval has quit IRC
22:15:26 *** sjc has quit IRC
22:16:39 *** twunder has joined #gnucash
22:39:19 *** dbr has quit IRC
22:42:59 *** twunder has quit IRC
23:13:43 *** amicrawler has joined #gnucash
23:13:59 <amicrawler> any body here?
23:14:25 <jsled> amicrawler: try /who #gnucash to get a list; your IRC client should list the participants in the channel as well.
23:14:42 <jsled> As per the topic, don't meta-ask, just ask your question...
23:15:34 <amicrawler> ok is there away in gnucash that once i enter a entry it will know what catagory it needs to go to ?
23:16:28 <amicrawler> becuse i have a lot to go thorugh !
23:16:30 <jsled> Well, gnucash has autocompletion of transactions; so if they have the same description it'll fill in the same transfer account.
23:16:41 <amicrawler> ok
23:16:43 <amicrawler> i did
23:16:43 <jsled> GnuCash doesn't have "categories",
23:16:44 <amicrawler> that
23:17:07 <amicrawler> but i have to click each transaction and tell it what it is
23:17:20 <amicrawler> what catagory to goto to
23:17:46 <jsled> You did what, exactly?
23:18:06 <amicrawler> well example starbucks is the vendor
23:18:19 <amicrawler> i told it it was dining
23:18:46 <amicrawler> well every starbuck i have to tell it's a dining
23:19:11 <jsled> Where are you entering transactions? In which register?
23:19:41 <amicrawler> the qif
23:19:51 <amicrawler> the one that came from the bank
23:19:52 <jsled> Oh? You're doing QIF import?
23:19:58 <amicrawler> yes
23:20:05 <jsled> You, uh, should have mentioned that.
23:20:14 <amicrawler> ok i'm sorry
23:20:32 <amicrawler> i all so have quicken for mac but it sucks
23:20:59 <amicrawler> unless i'm not doing something right
23:21:03 <jsled> In a single import -- if you have 5 Starbucks transactions -- I don't believe it'll set the other 4 when you set the first.
23:21:20 <amicrawler> humm
23:21:26 <jsled> But on subsequent imports it will remember the transaction-description -> account mappings you've made previously.
23:21:39 <jsled> IFF the description is *exactly* the same as before.
23:21:41 <amicrawler> ok
23:21:55 <amicrawler> but is there a way to auto fill
23:21:58 <jsled> (where "iff" means "if and only if")
23:22:12 <amicrawler> humm
23:22:14 <amicrawler> brb
23:22:55 <amicrawler> the transfer is Unspecified
23:22:59 * jsled nods
23:23:07 <amicrawler> a hole bunch of it
23:23:17 <jsled> Unspecified is the account used when no other is .. uh .. specified. :)
23:23:44 <jsled> You need to change those to be the appropriate Expense account.
23:24:15 <amicrawler> ok i'm doing this
23:24:33 <amicrawler> will it auto compleat for the rest of the transaction
23:24:45 <amicrawler> that has to do with starbucks
23:24:52 <jsled> <jsled> In a single import -- if you have 5 Starbucks transactions -- I don't believe it'll set the other 4 when you set the first.
23:24:56 <jsled> <jsled> But on subsequent imports it will remember the transaction-description -> account mappings you've made previously.
23:25:12 <amicrawler> well it is'nt
23:26:24 <amicrawler> when i click on the transaction it comes up when i erase the Unspecified and start to type dining
23:27:06 <amicrawler> but how do i get it to compleat the rest of the same Unspecified
23:27:18 <jsled> I don't think there is a way to do so.
23:27:20 <amicrawler> as dining of the sam transactions
23:27:48 <amicrawler> you know what i'm trying to say ?
23:28:22 <jsled> Yeah, I think so. In a QIF import you have 5 "Starbucks" transactions. You want to say "Expenses:Coffee" for 1, and have it deal with the other 4.
23:28:29 <amicrawler> or is there a way to find all starbucks and catagorz the same
23:28:48 <jsled> (what's your native language?)
23:28:55 <amicrawler> well i have a few 100 of the same
23:29:17 <amicrawler> english
23:29:32 <jsled> Are they from a single QIF import?
23:29:41 <amicrawler> yes
23:29:53 *** Demitar has quit IRC
23:30:10 <jsled> If possible, maybe you cna break it up into multiple QIF files.
23:30:41 <jsled> As I said, it knows how to deal with "autocompleting" mappings between imports, but not within a single import.
23:31:03 <amicrawler> so if i select starbucks and make it dining will the rest auto populate as dining?
23:32:21 <jsled> <jsled> <jsled> In a single import -- if you have 5 Starbucks transactions -- I don't believe it'll set the other 4 when you set the first.
23:32:24 <jsled> <jsled> <jsled> But on subsequent imports it will remember the transaction-description -> account mappings you've made previously.
23:35:58 *** benoitg has left #gnucash
23:35:59 <amicrawler> ok got them to be in the same
23:36:35 <amicrawler> but now is there a way to make the one i tell it will it fallow then rest
23:38:05 *** benoitg has joined #gnucash
23:38:17 <jsled> I don't know what you're asking.
23:39:45 <amicrawler> ok
23:40:27 <amicrawler> i'm not shure how to ask it
23:40:35 <jsled> What do you see?
23:43:47 <amicrawler> my qif
23:44:01 <amicrawler> and i see starbuck transaction
23:44:08 <amicrawler> allof them now
23:45:07 <amicrawler> when i click on the transfer Unspecified part to catorgorize ir
23:45:10 <amicrawler> when i click on the transfer Unspecified part to catorgorize it
23:45:19 <amicrawler> i name it dining
23:46:18 <amicrawler> how can i auto populate from now on when i run into a starbucks it will name it auto maticly
23:46:52 <amicrawler> or will see in the data base and auto populate
23:47:04 <jsled> I don't believe you can, apart from breaking the import up into multiple parts.
23:47:21 <amicrawler> oh
23:47:39 <amicrawler> well then i have a long road in front of me
23:48:26 <jsled> you could cancel the import and break it up into parts.
23:48:40 <jsled> Where'd you get a huge QIF from, anyways?
23:48:54 <amicrawler> ok don't know how to do that
23:49:15 <amicrawler> besides going 1by 1 and naming them
23:49:26 <jsled> Well,
23:49:49 <jsled> QIF is just a simple text format; you could do a bit of research to understand the format, then open it up in a text editor.
23:50:21 <amicrawler> let me check something
23:50:22 <amicrawler> brb
23:54:35 *** dbr has joined #gnucash