2011-07-27 GnuCash IRC logs
00:40:29 *** slidesinger has joined #gnucash
00:45:50 *** alexandros has quit IRC
00:46:12 *** greywolf__ has quit IRC
01:28:28 *** ironwolf3 has left #gnucash
15:06:37 *** gncbot has joined #gnucash
15:08:34 *** warlord has joined #gnucash
15:09:15 <warlord> hey jsled -- any chance you could op gncbot?
15:09:58 *** jsled sets mode: +o gncbot
15:10:00 <jsled> @op warlord
15:10:00 <gncbot> jsled: Error: You don't have the #gnucash,op capability. If you think that you should have this capability, be sure that you are identified before trying again. The 'whoami' command can tell you if you're identified.
15:10:28 <jsled> @op warlord
15:10:28 *** gncbot sets mode: +o warlord
15:10:32 <warlord> TY
15:11:07 <warlord> Comcast decided they didn't want packets to flow for about 12 hours... And then once they did they decided I needed a new IP Address; so I had to get my tunnel endpoint updated.
15:37:41 *** Goldfinn has quit IRC
15:37:50 <hatman> Is there a way to verify a qif file before importing it?
15:46:08 <warlord> Verify in what way?
15:46:46 <hatman> Well when I import a qif file into gnucash from moneydance I get an error, but not a line number. I wanted to find another way to find this error.
15:48:19 <hatman> The idea being something else tells me where the error is, I fix it with vim then import into gnucash.
15:55:04 <warlord> What version of GnuCash? And have you looked at your gnucash.trace file for more error information?
15:55:32 <hatman> gnucash-2.4.7-1.fc15.x86_64
15:55:33 <hatman> yes.
15:55:44 <hatman> the trace file has no useful information.
15:56:25 <warlord> Hmm. is there a backtrace in the trace file?
15:57:29 *** fleischergesell has quit IRC
15:57:53 <hatman> yes, the last line reads: * 21:57:13 MESSG <gnc.app-utils.sx> need dialog? false
15:58:02 <hatman> it doesn't seem to update at all during the import.
15:58:36 <warlord> That's not a useful message......
15:58:44 <warlord> What's the exact error from the qif import?
15:58:53 <hatman> Transaction amount: Unrecognized or inconsistent format.
16:00:55 <warlord> Aha! The issue is that you have multiple numeric formats that are inconsistent. For example, if you have something that looks like 1,000.00 and then 1.000,00 --- those are inconsistent.
16:01:10 <warlord> There's not a particular line number that's wrong.
16:01:24 <warlord> And it's not a bug.
16:01:32 <warlord> (which is why there's no backtrace in the trace file)
16:01:38 <hatman> Ah. So if my export contained different currencies for example?
16:01:52 <warlord> That could do it, too...
16:02:03 <warlord> GnuCash does not handle multi-currency QIF
16:02:12 <hatman> Because I don't have any commas in my qif file
16:02:44 <hatman> Okay so I have a lot of work to do - thanks.
16:03:09 <hatman> Two questions: can gnucash nicely handle exporting csv files from online banking and massaging them into something suitable?
16:03:17 <warlord> The other possibility is that the number fields are not in a format GnuCash recongnizes
16:03:29 <hatman> warlord: what format does it recognise?
16:03:37 <warlord> You have no commas?? What about thousands separators?
16:03:58 <warlord> I'm not sure how well it imports CSV these days.
16:04:10 <hatman> I have lines that look like this: T1234.56
16:05:40 <warlord> That should be fine...
16:06:14 *** ErKa has joined #gnucash
16:06:31 <warlord> That should match *[$]?[+-]?[$]?[0-9]+\\.[0-9]*[+-]?
16:10:13 *** rpg has joined #gnucash
16:10:30 <hatman> what about CX at the end?
16:14:12 <warlord> Yeah, that would cause an issue.
16:14:21 <warlord> T1234.56CX ? That's a failure.
16:17:53 <hatman> maybe its the starting balance?
16:18:07 <warlord> ?? What is?
16:20:07 <hatman> that value
16:20:29 <hatman> yes the CX value is the opening balance
16:22:02 <warlord> It's the 'CX' that is causing the issue, not the fact that it's an opening balancew.
16:22:25 <hatman> I removed it and the import works :)
16:22:50 <hatman> is there a plan for multicurrency qif import support?
16:23:55 <hatman> or a trick to make it work? like pretend its one currency then edit afterwards?
16:26:59 <warlord> For the first question: if someone donates some code, or at least donates a "multi-currency qif file" that developers can use to test against..
16:27:12 <warlord> for the second question: Maybe import each currency separately?
16:27:19 <warlord> (I don't have a good answer for that)
16:28:30 <hatman> thanks very much for your help warlord
16:31:26 *** hatman has quit IRC
16:37:21 *** andy__ has joined #gnucash
16:40:56 <andy__> New to GC, and trying to replace QB for good. Hung up on dealing with employee expenses (small business). I need to record expenses I incurr (like health premiumns, internet, post office, etc), but I might not pay all of the expenses at a time. Might pay last three months health premiums on a single check, plus one month's internet. How would I go about this? I've tried the Expense Voucher, and I don't see how you can select partial
16:40:56 <andy__> payment of some expenses on a single check.
16:45:04 <warlord> The expense voucher records when you (the employee) pay something on behalf of the company.
16:45:20 <warlord> That records that the company needs to reimburse you
16:45:34 <warlord> Then the Process Payment records the reimbursement, which can be a partial payment back to you.
16:46:01 <warlord> The Payment processed need not be the full amount owed.
16:47:07 <andy__> Right, so it's not important that the entire split is paid?
16:48:44 <warlord> Right, gnucash will keep track of the amount owed.
16:59:14 <andy__> Ok, I see how that would work going forward with GC, but I'm trying to replicate the QB situation where I gave myself an itemized expense check that came off of several expense vouchers
16:59:42 <andy__> I see that you also can't use the same check to pay several vouchers?
17:00:10 <warlord> Sure you can! It will pay them in FIFO order.
17:00:28 <warlord> You can (optionally) specify the first out-of-order one to pay
17:07:22 *** Jimraehl2 has joined #gnucash
17:21:13 <gdutton> Greetings. I invoice customers for monthly dues. I have one customer that made a purchase on behalf of the organization. I'd like to just credit that expense against the customer's account as a "payment" instead of cutting them a check. Any suggestions on how to do this?
17:23:00 *** ErKa has quit IRC
17:24:45 *** JasonBoxLaptop has joined #gnucash
17:29:42 <warlord> gdutton: Use Process Payment
17:30:16 <gdutton> Will I be able to process it against an expense account doing it that way?
17:31:06 <warlord> No, but you can adjust the account afterwards (just do not change the amount)
17:32:23 <gdutton> Thanks.
17:34:18 *** fbond has quit IRC
17:35:49 <warlord> You're welcome.
18:02:20 *** Matthew has joined #gnucash
18:09:37 *** Matthew has left #gnucash
18:10:00 *** Matthew has joined #gnucash
18:10:10 *** Matthew has left #gnucash
18:20:29 *** Hajo has joined #gnucash
18:23:35 *** Hajo has quit IRC
18:24:54 *** markjenkinsparit has quit IRC
18:35:04 *** Matthew has joined #gnucash
18:35:16 *** Matthew has left #gnucash
18:53:04 *** gdutton has quit IRC
19:29:11 *** puck has quit IRC
19:34:51 *** puck has joined #gnucash
20:25:28 *** Jimraehl2 has quit IRC
20:59:38 *** warlord is now known as warlord-afk
21:39:21 *** Jimraehl2 has joined #gnucash
21:39:45 *** Jimraehl2 has left #gnucash
21:45:30 *** JasonBoxLaptop has quit IRC
21:56:11 *** Jimraehl2 has joined #gnucash
22:17:39 *** nchand has joined #gnucash
23:21:29 *** alexandros has quit IRC
23:21:41 *** greywolf__ has quit IRC