2014-11-01 GnuCash IRC logs
00:23:43 *** ErKa has joined #gnucash
00:45:40 *** GabrieleV_ has joined #gnucash
00:45:41 *** GabrieleV has quit IRC
00:45:41 *** GabrieleV_ is now known as GabrieleV
01:10:00 *** ErKa has quit IRC
02:02:42 *** StuM has quit IRC
02:05:09 *** GabrieleV_ has joined #gnucash
02:05:40 *** GabrieleV has quit IRC
02:05:40 *** GabrieleV_ is now known as GabrieleV
02:58:50 *** fell_ has quit IRC
03:25:46 *** StuM has joined #gnucash
03:32:56 *** cartsoftware has quit IRC
03:35:13 *** MechtiIde has joined #gnucash
03:39:11 *** O01eg has quit IRC
03:59:20 *** Krzysiek_K has left #gnucash
04:07:49 *** cartsoftware has joined #gnucash
04:09:14 *** GabrieleV_ has joined #gnucash
04:09:29 *** GabrieleV has quit IRC
04:09:29 *** GabrieleV_ is now known as GabrieleV
04:12:59 *** MechtiIde has quit IRC
04:59:46 *** GabrieleV_ has joined #gnucash
04:59:47 *** GabrieleV has quit IRC
04:59:48 *** GabrieleV_ is now known as GabrieleV
05:14:17 *** GabrieleV_ has joined #gnucash
05:14:53 *** GabrieleV has quit IRC
05:14:53 *** GabrieleV_ is now known as GabrieleV
05:26:02 *** gjanssens has joined #gnucash
05:26:02 *** gncbot sets mode: +o gjanssens
05:29:19 *** GabrieleV_ has joined #gnucash
05:29:51 *** GabrieleV has quit IRC
05:29:51 *** GabrieleV_ is now known as GabrieleV
06:09:22 *** GabrieleV_ has joined #gnucash
06:09:25 *** GabrieleV has quit IRC
06:09:25 *** GabrieleV_ is now known as GabrieleV
06:36:58 *** mlncn has quit IRC
06:59:50 *** StuM has quit IRC
08:47:03 *** Jimraehl1 has left #gnucash
08:54:45 *** mlncn has joined #gnucash
08:58:51 *** Jimraehl1 has joined #gnucash
09:28:51 *** wizkid238 has joined #gnucash
09:45:27 *** himaxx has joined #gnucash
09:45:31 *** andy has quit IRC
09:48:33 *** cartsoftware has quit IRC
09:49:14 *** himaxx has quit IRC
09:53:05 *** andy has joined #gnucash
10:04:14 *** fell_ has joined #gnucash
10:04:14 *** gncbot sets mode: +o fell_
10:12:59 *** mlncn has quit IRC
10:13:22 *** mlncn has joined #gnucash
10:36:56 *** GabrieleV_ has joined #gnucash
10:37:29 *** GabrieleV has quit IRC
10:37:29 *** GabrieleV_ is now known as GabrieleV
10:57:25 *** GabrieleV_ has joined #gnucash
10:57:51 *** GabrieleV has quit IRC
10:57:51 *** GabrieleV_ is now known as GabrieleV
11:12:06 *** Krzysiek_K has joined #gnucash
11:16:44 *** mlncn has quit IRC
11:28:28 *** Gbarr has joined #gnucash
11:41:02 *** cartsoftware has joined #gnucash
12:30:53 <gjanssens> Just for the record, I now highly doubt the Windows installer hangs while running pango-querymodules
12:31:17 <gjanssens> I have paid careful attention in the last install and after the *.png images the installer continues with lots of *.mo files
12:32:01 <gjanssens> That means that when the installer freezes it's still busy extracting files.
12:32:15 <gjanssens> pango-querymodules is only run *after* all files are extracted
12:32:31 <gjanssens> So the pango-querymodules hack can stay as far as I'm concerned.
12:32:48 <gjanssens> It does what it needs to do and is not the cause of any trouble.
12:38:45 *** Gbarr has quit IRC
12:44:42 *** Gbarr has joined #gnucash
12:49:56 *** jralls has quit IRC
12:50:28 *** jralls has joined #gnucash
12:50:28 *** gncbot sets mode: +o jralls
12:52:17 *** ErKa has joined #gnucash
12:55:44 <jralls> gjanssens: Darn. Well, sort-of darn. I was working on getting Pango to not need querymodules on the theory that that was the problem.
12:56:04 <jralls> How do we debug the installer to find out what's really the problem?
13:10:29 <gjanssens> My first suggestion would have been to enable logging:
13:10:31 <gjanssens> http://www.jrsoftware.org/ishelp/
13:10:49 <gjanssens> However I tried that and it doesn't give any useful hints
13:11:11 <gjanssens> It nicely logs each file being written up until it freezes on redhat-accessories.png
13:11:36 <gjanssens> It reconfirms though that pango-querymodules hasn't started yet
13:12:21 <gjanssens> I should also add that for my local build which failed similarly it was fixed just by rerunning dist.sh
13:12:52 <gjanssens> That doesn't give a hint to the cause though
13:16:36 <jralls> What happens if you remove redhat-accessories.png from the archive?
13:17:05 <jralls> Or is that even possible once the archive is made?
13:19:59 <gjanssens> I have no idea
13:20:21 <gjanssens> I don't know how the archive is created
13:20:34 <gjanssens> So I don't know how to remove a file from it
13:28:03 <gjanssens> BTW from now until Nov 11 I will not have much time available for gnucash
13:28:22 <gjanssens> We're preparing our annual expo in Christa's shop...
13:28:36 <gjanssens> So if it takes long before I reply, you know why :)
13:32:38 *** fell__ has joined #gnucash
13:32:39 *** gncbot sets mode: +o fell__
13:33:14 *** Gbarr has quit IRC
13:34:06 <jralls> Sounds like fun. I'll keep plugging away on this. I've got a new webkit tarball, plus a libsoup one which IIRC fixes the hang during build with the iso8859 po file. I need to test the changes to impl_install and impl_dist and push/upload everything. Maybe with no pngs in WebKit the installer won't hang.
13:40:43 *** fell_ has quit IRC
14:06:44 *** wol has joined #gnucash
14:33:13 <gjanssens> Ok good luck
14:33:58 <gjanssens> If I have a spare moment I'll test if my guile2 compile changes affect the window build in any way
15:11:40 <jralls> I don't think that there's any rush for that, unless you can think of a reason to switch to Guile 2 for maint.
15:13:03 *** cartsoftware has quit IRC
15:19:18 <jralls> Curious, though: The non-ascii path examples you gave seem to use gnc-build-dotgnucash-path, which wraps the C function and should get the right path. Do you know what is Guile2's problem with the result?
15:30:24 *** ErKa has quit IRC
15:33:47 *** MechtiIde has joined #gnucash
15:53:36 *** sabayonuser has joined #gnucash
15:56:04 *** comcry has quit IRC
15:57:37 *** comcry has joined #gnucash
16:05:45 *** ErKa has joined #gnucash
16:17:35 *** sabayonuser is now known as shade304
16:22:47 <gjanssens> Oh, I meant that my patches to precompile for guile 2 don't cause any trouble under Windows with guile 1.8
16:22:52 <gjanssens> Not building Windows with guile 2
16:23:51 <gjanssens> Re the non-ascii paths: gnc_build_dot_gnucash_path works and give the proper result
16:24:14 <gjanssens> gnc-dot-gnucash-path on the other hand ends up with a garbled path
16:24:36 <gjanssens> So the issue is somewhere in the transition from C to scheme
16:25:06 <gjanssens> I started to gdb it but in the end I gave up
16:25:38 <gjanssens> Because Eli Zaretskii already went through the effort
16:26:04 <gjanssens> And reading his story I figured I would hit quite a few additional issues before self compiling would work
16:26:31 <gjanssens> With Eli's build I never bothered to debug. I stopped once I confirmed the bug was still there...
16:32:14 <jralls> Ah. It appears that gnc-build-dotgnuash-path just wraps gnc_build_dot_gnucash_path, which emits the path in UTF8. That needs to be converted for Guile to understand it.
16:32:41 *** MechtiIde has quit IRC
16:34:16 <jralls> I see in http://www.gnu.org/software/guile/manual/guile.html#Representing-Strings-as-Bytes that that can be done either by using a port and setting the encoding on the port or using bytevector->string with the encoding of the bytevector.
16:35:31 <jralls> That still might not be enough, if Guile isn't smart enough to use UTF16 when interacting with NTFS.
17:02:27 *** GabrieleV_ has joined #gnucash
17:02:44 *** GabrieleV has quit IRC
17:02:44 *** GabrieleV_ is now known as GabrieleV
17:07:53 <shade304> Is there a report: Sales per vendor for the year
17:10:48 *** aqua___ has joined #gnucash
17:11:27 <shade304> I know the vendor report shows the total tranactions for a time period, and the accounts payable report shows bill totals not paid
17:12:02 <shade304> Instead I need totals of bills that are paid in a list form to sort greatest to smallest
17:21:22 *** aqua___ has quit IRC
17:37:02 *** gjanssens has quit IRC
17:39:37 *** Krzysiek_K has left #gnucash
17:45:27 <jralls> shade304: I don't think so, but let me take a look.
17:53:36 <shade304> thank you
17:57:50 <jralls> shade304: I don't see anything like what you're asking for, only the summary reports you already found. You might ask on the User's list to see if anyone has written a custom report that they'd be willing to share.
17:59:58 *** storri has joined #gnucash
18:01:23 <storri> I have a problem with the starting reconcilation balance. Its higher by an old transaction of $156.63. I went and unreconciled the transaction thinking I could just redo the reconcilation. I don't see the transaction in the reconcilation window. How can I fix this?
18:06:53 <Simon> I suspect you may not have saved the change to make it unreconciled yet
18:07:29 <jralls> storri: Did you remember to exit the tranaction after unreconciling it, either by arrowing to another txn, clicking outside of it, or pressing 'return'?
18:10:44 <storri> I can try re-saving.
18:11:58 <storri> Saving still did not change it. I have really borked this.
18:13:21 <storri> I thought the 156.63 was related to the first credit card but in fact it was the second. So when I reconciled the second card I added this missing transaction. Which now makes the starting reconciling balance 313.26 which is 2 x 156.63.
18:13:39 <storri> I am not going to make any more changes until i can fix this
18:14:56 *** cartsoftware has joined #gnucash
18:16:53 <jralls> storri: No, you didn't need to save the file, that was a poor choice of words on Simon's part. You juet needed to commit the transaction.
18:20:24 <jralls> storri: To fix what I understand is the problem, delete the transaction that you added in error, then go to the one that you reconciled in error to the other CC, unreconcile it, which should fix the reconciled balance, then change the transfer account from the first CC to the second.
18:21:23 <storri> I deleted the two transactions
18:21:44 <jralls> And is your starting balance now correct?
18:22:31 <storri> No. Now the first account balance is incorrect (156.63 still outstanding to be paid while statement says 0)
18:22:41 <storri> The first account is a credit card.
18:22:48 <storri> The reconcile account is my checking account
18:22:59 <storri> I need to say this so we understand which is which
18:24:38 <jralls> Are there two CCs or did you mean "second account" when you said "second card"?
18:25:08 <storri> Yes. Sorry. I have two accounts I am talking about. #1 = checking, #2 = CC
18:26:52 <jralls> OK. And they're both off by 156.16?
18:28:50 <storri> Going to checking and clicking reconcile I see its is off by 312.32. This I think happened because of trying twice to fix it by deleting the old transaction and trying a new one.
18:29:16 <storri> The CC is off by 156.16
18:29:40 <storri> I think the CC is off because its missing the payment transaction.
18:29:49 *** wizkid238 has quit IRC
18:30:21 <storri> I need to add a payment transaction from the checking to CC for 156.16
18:30:32 <jralls> In which direction is the checking off, and is it the starting or ending balance that's off?
18:31:30 <storri> Starting balance. The ending balance does not make any sense to me. I have always had to edit that to what the bank says.
18:33:27 <jralls> And in which direction is the starting balance off? Is the bank's starting balance higher or lower than yours?
18:34:01 <storri> The starting balance is off on me end.
18:34:12 <storri> The bank is now lower than mine
18:34:18 *** Gbarr has joined #gnucash
18:35:26 <jralls> OK. So the two transactions that you deleted were correctly reconciled.
18:35:50 *** andy has quit IRC
18:36:51 <jralls> How much work have you done in this GnuCash session? Would it be feasible to roll back to your last backup and start over?
18:37:12 <storri> I have reconcilled a couple of statements but nothing I cannot redo.
18:38:26 <storri> How do I roll back and start over?
18:41:31 <jralls> Select File>Open and look at the files beginning with your filename, but with a date extension; if your account file is foo.gnucash, then the backups will have names like foo.gnucash.20141031113215.gnucash, with those numbers being the date and time the following file was opened.
18:43:28 *** andy has joined #gnucash
18:43:59 <jralls> No, sorry, it's the time that it was originally saved. So you want the one with a timestamp nearest before the one you last saved.
18:44:17 <jralls> The one you saved a few minutes ago that is.
18:45:03 <jralls> Select that and click "open", then immediately select File>Save As and save it with the right name.
18:47:48 <storri> I went back to a previous date. When I looked at the checking I am off by 66.39. I guess I keep rolling back until I figure out when I match.
18:51:36 <jralls> What do you mean you are "off"? Did you open the reconcile window and check the starting balance against your statement?
18:52:44 <storri> I went back through various files back to the start of October. Each time I went to the checking account and clicked reconcile I saw my balance is still higher than the bank by 66.39. The next files older than that are four months old. If the timestamp is correct.
18:57:14 <jralls> 4 months? When did you last reconcile?
18:58:15 <storri> I honestly find the timestamps on the gnucash files to be confusing. I see a lot of files there. I guess at one time I just made a new copy. The four month old file is quite old.
19:01:31 <storri> I reconciled last month
19:06:34 <jralls> Did you pull out last month's statement and make sure that its ending balance matches this month's starting balance?
19:07:26 <storri> I found an old file in my back where I match the bank for the starting balance of the October. I can use that.
19:08:28 <storri> Well now I know how I am spending my evening.
19:09:31 <jralls> Good luck!
19:10:10 <storri> Appreciate the help.
19:10:54 <jralls> You're welcome.
19:14:13 <storri> Geek question: What language is used to program Gnucash?
19:21:34 <jralls> Most of GnuCash is in C, a bit is in Scheme (Guile) and we're starting to use C++11.
19:24:21 <shade304> In case someone is later to come across my question of a report of vendors ordered by transaction, I did not find a report but came to this solution, a little hard to do all the time, but worked for the time:
19:25:08 <shade304> I opened the "Cost of Goods Sold" account and did a register report, this showed every transaction..
19:25:46 <shade304> Then I did a file export report and opened into a spreadsheet
19:26:15 <storri> I have 10+ years using C++. Perhaps over the Christmas break I will take a look at the source code.
19:28:08 <shade304> I had to save as a csv file to get rid of all the formating, and use search replace to get rid of the dollar signs..
19:29:50 <shade304> Then selecting all the data and creating a pivot table, when the dialog comes up I dragged the Vendor name into the "row fields" and the transaction amount into the "data field" it will output a nice list on a new tab listing in alphabetical order all the vendors and the total of their transactions
19:30:15 <shade304> Then you can resort the list descending by amount and save
19:31:12 <jralls> storri: We'll be here. If you aren't already familiar with C++11 you might want to read up on it in the meantime.
19:31:39 <jralls> shade304: Sounds like a lot of work. Are you able to write code?
19:31:48 <shade304> I prefer the gnumeric spreadsheet as it handles the saved reports better, but unfortunately could not figure out how to create the pivot table, and was forced to use libre office instead..
19:33:29 <shade304> I can do easy stuff, but it's not my line of work, I don't have formal training, just lots of googling and figuring things out, I'm sure it was a very inefficient process :)
19:34:22 <shade304> I really want to help code with gnucash, but it is a mind blow for me, scheme? I really am missing out there..
19:35:06 <shade304> For me its like jazz music, I want to like it, but I just don't get it
19:37:35 *** storri has quit IRC
19:39:25 <jralls> Well, I love jazz, but I'm not wild about Scheme. Fortunately we also have Python bindings, and Python is a bit more approachable.
19:55:28 *** Gbarr has quit IRC
20:00:35 <shade304> :)
20:01:23 <shade304> I'll look into it, thanks for the help
20:05:39 *** himaxx has joined #gnucash
20:25:35 *** shade304 has quit IRC
20:36:16 *** mlncn has joined #gnucash
21:14:31 *** GabrieleV_ has joined #gnucash
21:14:32 *** GabrieleV has quit IRC
21:14:33 *** GabrieleV_ is now known as GabrieleV
21:20:31 *** mlncn has quit IRC
21:29:11 *** jralls has quit IRC
21:30:05 *** jralls has joined #gnucash
21:30:05 *** gncbot sets mode: +o jralls
21:32:48 *** Krzysiek_K has joined #gnucash
21:48:33 *** mlncn has joined #gnucash
22:05:33 *** jralls has quit IRC
22:06:10 *** jralls has joined #gnucash
22:06:10 *** gncbot sets mode: +o jralls
22:08:35 *** wizkid238 has joined #gnucash
22:29:05 *** GabrieleV_ has joined #gnucash
22:29:16 *** GabrieleV has quit IRC
22:29:16 *** GabrieleV_ is now known as GabrieleV
22:29:32 *** jralls has quit IRC
22:30:26 *** jralls has joined #gnucash
22:30:26 *** gncbot sets mode: +o jralls
22:34:58 *** jralls has quit IRC
22:35:33 *** jralls has joined #gnucash
22:35:33 *** gncbot sets mode: +o jralls
22:42:46 *** cartsoftware has quit IRC
23:00:28 *** jralls has quit IRC
23:01:10 *** jralls has joined #gnucash
23:01:10 *** gncbot sets mode: +o jralls
23:20:25 *** mlncn has quit IRC
23:59:21 *** mlncn has joined #gnucash