2014-01-11 GnuCash IRC logs
02:40:38 *** fell_ has joined #gnucash
02:40:38 *** gncbot sets mode: +o fell_
02:49:37 *** fell has quit IRC
03:28:12 *** gjanssens has joined #gnucash
03:28:13 *** gncbot sets mode: +o gjanssens
04:06:43 *** fell_ has quit IRC
04:09:48 *** john has quit IRC
05:41:21 *** TradeBorG113 has joined #gnucash
05:56:10 *** aqua___ has joined #gnucash
07:20:00 *** aqua___ has quit IRC
08:00:09 *** goibhniu has joined #gnucash
08:12:19 *** LiamH has joined #gnucash
08:33:08 *** ErKa has joined #gnucash
08:33:28 *** Jimraehl has left #gnucash
08:59:50 *** jmd has joined #gnucash
09:01:13 *** Jimraehl has joined #gnucash
09:46:47 *** jmd has joined #gnucash
09:57:15 *** LiamH1 has joined #gnucash
10:02:26 *** LiamH has quit IRC
10:10:39 *** strannik has joined #gnucash
10:11:06 *** ErKa has quit IRC
10:59:29 *** BnMcGn has joined #gnucash
11:07:28 <BnMcGn> I want to script the entry, posting and payment of simple invoices. The payment thing has got me confused. Which of the four gnc*ApplyPayments* functions should I use? What do I put in the lot list? I'm guessing the one that was created when I posted the invoice. Transaction?
11:08:14 <BnMcGn> If I use OwnerAutoApplyPaymentsWithLots, how does it know what transfer account to use?
11:09:51 <BnMcGn> I want to pay only the invoice that I just posted, so I'm hoping I don't have to get into the whole lot thing.
11:10:03 <warlord> BnMcGn: take a look at what dialog-payment does
11:10:12 <warlord> BnMcGn: you do
11:10:28 <warlord> a lot is what ties the invoice receivable to the payment
11:10:30 <BnMcGn> do what?
11:10:48 <warlord> yes, you do have to "get into the whole lot thing"
11:11:10 <BnMcGn> Can I just use the lot that comes with the invoice?
11:11:41 <BnMcGn> Or do I need a different lot?
11:12:38 <warlord> If you want the payment tied to that invoice you *MUST* use that lot
11:12:49 <BnMcGn> Generally all of the invoices from the vendor where I use this script will be paid up already. There shouldn't be any other open lots.
11:14:31 <BnMcGn> So, I could use OwnerApplyPayment, put the associated lot in the lots list. What about the transaction parameter?
11:15:04 <BnMcGn> It's not the one that got returned when I posted the invoice, is it?
11:15:47 <warlord> Like I said, take a look at dialog-payment to see how the function is used.. (I'd have to do that myself to answer your question; the interfaces have changed significantly since I last looked)
11:16:03 <BnMcGn> Ok, I'll do that. Thanks.
11:17:31 *** strannik has quit IRC
11:17:35 <noughth> is attaching a patch to a bugzilla entry sufficient for it to get recognized/reviewed/merged, or do I need to fire off an email to gnucash-devel as well?
11:17:50 *** strannik has joined #gnucash
11:19:02 <noughth> (the wiki seems to make me think bugzilla is enough - just don't want it to get lost)
11:19:40 <warlord> noughth: Bz is usually sufficient; it definitely wont get lost there (whereas sending to -devel is a surefire way for it to be lost).
11:19:53 <warlord> However you could also send a mail to -devel to point people to the Bz entry..
11:19:57 *** himaxx has joined #gnucash
11:20:22 <warlord> BIAW
11:20:31 *** himaxx has quit IRC
11:46:17 *** fell has joined #gnucash
11:46:17 *** gncbot sets mode: +o fell
12:13:57 *** strannik has quit IRC
12:33:02 *** ErKa has joined #gnucash
12:38:29 *** KeyPlayer has joined #gnucash
12:42:03 <KeyPlayer> Just imported 3 months of bank transactions into gnucash v2.6.0. The accounts show the transactions and the account list shows the totals, but the reports show zeros for each account. See image at http://imagebin.org/286135
12:52:06 <KeyPlayer> I know this must be user error. So verified that the date range of the transactions match those of the reports. Went through all the report options to be sure the accounts were included. Kinda out of "what else could it be" thoughts. Hope someone has seen the problem.
12:54:59 *** jmd has quit IRC
12:55:15 <fell> KeyPlayer: I see the numbers in the report too, but in a very strange format - mi as decimal separator.
13:02:44 <gjanssens> BnMcGn: you will probably want gncOwnerApplyPayment
13:02:58 *** aqua___ has joined #gnucash
13:03:04 <fell> Which stylesheet are you using? What are your locale settings on program start and in edit->preferences...
13:03:19 <BnMcGn> Ok
13:03:21 <gjanssens> warlord: the payment logic has changed in 2.6
13:03:59 <gjanssens> payments now get their own lots and linking transactions are set up between one or more invoice and payment lots
13:04:36 <gjanssens> This was done to accomodate for a few use cases that couldn't be covered in the old code (like paying an invoice with a credit note)
13:04:44 <BnMcGn> Is that taken care of internally?
13:04:52 <gjanssens> BnMcGn: yes
13:05:07 <gjanssens> The lot list can be empty by the way
13:05:15 <BnMcGn> Oh
13:05:31 <gjanssens> It's only taken as a preference to pay these invoices first
13:05:32 <BnMcGn> What about the transaction field?
13:06:09 <BnMcGn> So if I only have one posted unpaid invoice it will find it no problem.
13:06:13 *** ErKa has quit IRC
13:07:07 <BnMcGn> Can I leave the transaction field blank, do I create a new one, or use an old one?
13:08:53 <BnMcGn> What is a transaction? Is it equivalent in concept to a SQL transaction?
13:09:08 *** Bodhi-Baum has joined #gnucash
13:09:17 <KeyPlayer> The funny character is $0.00 but is way small. Did not see locale settings in edit->Preferences
13:09:18 <gjanssens> If you have one posted unpaid invoice, the code may or may not use it for your payment
13:09:37 <BnMcGn> Or is it accounting terminology?
13:09:38 <gjanssens> It depends on the value of the auto_pay boolean
13:09:49 <gjanssens> Transaction is accounting terminology
13:10:37 <gjanssens> If you really want to assign a payment specifically to one invoice,
13:10:54 <gjanssens> you better pass the lot of your invoice in the lots list
13:11:16 <gjanssens> That's the best guarantee your payment will be linked to that invoice
13:11:39 <gjanssens> The transaction field can be left blank in this case
13:11:39 <BnMcGn> Well, I want to pay one bill. I guess I don't need to be picky about behind the scenes stuff.
13:11:46 <BnMcGn> Ok.
13:12:14 <gjanssens> That field is only relevant if you already have an existing transaction that was entered outside of the business logic
13:12:22 <gjanssens> and want to link that to an invoice
13:13:08 <BnMcGn> Ok. Then it's pretty straight forward.
13:13:12 <gjanssens> That's not what you are doing here
13:13:18 <gjanssens> I hope so :)
13:13:51 <gjanssens> One suble thing though: the code expects a *list* of lots
13:13:51 <BnMcGn> Ok, I'll try it. Thanks
13:14:01 <BnMcGn> Empty list then?
13:14:17 <gjanssens> so even if you only want to pass it one lot, you should convert it into a list of one entry
13:14:51 <gjanssens> No, not an empty list
13:15:25 *** Jimraehl has quit IRC
13:15:36 <gjanssens> Either nothing or a list with one invoice
13:15:43 <gjanssens> (invoice lot that is)
13:16:10 <gjanssens> Since you mentioned scripting, I presume you are using the python bindings
13:16:15 <BnMcGn> yes
13:16:29 <BnMcGn> So, None, then.
13:17:13 <gjanssens> If you set it to None, you should verify you have exactly only one posted unpaid invoice for your vendor/customer
13:17:37 <gjanssens> Otherwise the code will assign the payment in fifo order (oldest invoice will be paid first)
13:17:50 <gjanssens> Unless you explicitly pass in a lot in the lots list
13:17:55 <BnMcGn> I see.
13:18:00 <gjanssens> That's what I was trying to convey
13:24:47 <gjanssens> But if your import script ensures there's always only one open invoice, or the payments are applied in the same order as the invoice
13:25:02 <gjanssens> you don't need to use the lots list
13:38:23 *** gjanssens is now known as gjanssens_
13:40:47 *** kpreid has quit IRC
13:41:48 *** kpreid has joined #gnucash
13:54:02 <warlord> gjanssens_: thanks
13:55:18 <KeyPlayer> I have a report styling problem see image http://imagebin.org/286135. I can copy the table from the report and paste it into Word and see the amounts perfectly. Tried changing font and point size in Prefs but noda changes. Must be user error. Any thoughts?
13:55:45 <warlord> KeyPlayer: what OS/Distro?
13:56:37 <KeyPlayer> WinXP GnuCash 2.6.0
14:06:31 <warlord> Was it working with 2.4.x?
14:11:41 *** john has joined #gnucash
14:11:41 *** gncbot sets mode: +o john
14:12:01 <fell> keyplayer: in report options->general you can see the stylesheet, you are using.
14:16:52 <KeyPlayer> fell: Edit>Style Sheets>Fonts>Number cell: Courier New Normal 14 makes report #s readable. Courier 10 is still readable but Sans normal 10, (the default) is not. Prob due to my hi res display setting.
14:18:02 <KeyPlayer> fell:tnx for pointing me in the right direction :-)
14:18:40 <fell> And your decimal searator "mi"?
14:19:20 <KeyPlayer> was actually a number too tiny to read.
14:19:44 <fell> OK.
14:22:02 *** KeyPlayer has quit IRC
14:43:39 <warlord> john: replace dbi with Qt? ;)
14:44:01 <warlord> (or does Qt not have a decent abstraction over e.g. Qt-MySql?)
14:50:50 <john> I'd rather defer the toolkit choice for now. Besides, I don't see us replacing gtk in this dev cycle, and dragging in Qt as well as Gtk would make the Win32 and Mac bundles too big.
14:52:11 <john> If we do commit to Qt at some point, the appropriate classes are at http://qt-project.org/doc/qt-4.8/database.html
14:53:22 <warlord> It just seems silly to swap from libdbi to something else now, only to swap again in another cycle or two.
14:56:17 <john> Roger, but there's no requirement to use QtSqlDatabase if we have something else that works already.
14:56:45 <john> Even if it does reduce the dependencies somewhat.
14:58:32 *** goibhniu has quit IRC
14:59:18 <warlord> True.
15:00:49 <warlord> I'm not doing the work so I don't have lots of say in the matter ;)
15:01:40 <john> OK, but what's your sentiment about distro support?
15:03:13 *** LiamH has joined #gnucash
15:07:41 *** LiamH1 has quit IRC
15:22:50 *** aqua___ has quit IRC
15:22:50 *** LiamH1 has joined #gnucash
15:28:01 *** LiamH has quit IRC
15:42:20 <warlord> john: that's always a tough call. To some degree we need to be beholden to what they ship. On the other hand, if we need something we need something...
15:49:56 <john> Well, we can work around it by forking and inhaling. I hate to do that, though, because it makes maintaining the dependency our problem.
15:59:49 *** Bodhi-Baum has quit IRC
16:01:59 *** LiamH1 is now known as LiamH
16:09:10 <warlord> yeah, but they aren't maintaining it themselves....
16:09:24 <warlord> (it's not like there's a lot of movement on libdbi)
16:10:28 <john> Libdbi has had new activity in the last year. The library I really like, ODB, is commercially maintained and dual-licensed like Sleepycat (a.k.a BerkeleyDB).
16:11:27 <john> OTL and tntdb seem to be actively maintained, but are both one-man shows. SOCI seems not to be active.
16:11:42 <john> Might that be a criterion for deciding which one to fork?
16:12:21 <warlord> Probably, yes.
16:21:34 *** TradeBorG113 has quit IRC
16:43:37 *** goibhniu has joined #gnucash
17:06:42 *** himaxx has joined #gnucash
17:09:47 *** ErKa has joined #gnucash
17:19:30 *** himaxx has quit IRC
17:34:32 <warlord> Well, I finally got sendmail configured on the new server.. (took my long enough, although I still have to deal with mailman) ..
17:53:09 *** ErKa has quit IRC
18:12:22 *** gjanssens_ has quit IRC
18:25:38 *** BnMcGn has quit IRC
18:32:56 *** MacCoaster has quit IRC
18:56:23 <john> Wow, you're still using sendmail? Postfix is so much easier to administer.
18:58:47 *** goibhniu has quit IRC
19:22:45 *** goibhniu has joined #gnucash
20:11:27 *** goibhniu has quit IRC
20:12:37 <fell> warlord: you are no real admin if you never configured sendmail, but you are crazy if you do it more often than once. ;-)
20:12:57 <john> LOL!
20:54:54 <warlord> john: I use sendmail for code, postfix for my personal email. I actually find sendmail extremely easy to configure, especially when I am just copying an existing configuration ;)
20:55:43 <warlord> fell: it's not like anyone configures the .cf file directly; everyone uses the .mc (m4 macro) config and generates the .cf file
20:56:12 <warlord> I think I *did* only configure the .cf file once... Then they introduced the mc format.
20:56:33 <warlord> Getting postifx "right" would be, IMHO, more work than just sticking with sendmail.
21:12:21 <fell> BTW: are there soome issues with the mailing list archives?
21:14:17 <fell> I was searching https://lists.gnucash.org/pipermail/gnucash-devel/2013-December/036624.html, but neither
21:14:20 <fell> https://lists.gnucash.org/search/?query=Documentation+file+format
21:17:10 <fell> nor https://www.google.com/search?q=site%3Alists.gnucash.org+%22Documentation%20file%20format%22
21:17:22 <fell> showed something useful
21:17:44 <warlord> well, the former is known not to work..
21:18:03 <warlord> (that stopped working 2+ years ago)
21:18:15 <warlord> as for the latter; not sure why google isn't working.
21:18:58 <fell> It is bad aligned but normally still working
21:20:13 <fell> Thereis no robots:nofollow or similar?
21:20:15 <warlord> google? or lists/search?
21:20:43 <fell> usually I use lists/search
21:21:20 <warlord> fell: robots.txt only mentions /trac, /cgi-bin, /viewcvs, /search, and /repo
21:21:34 <warlord> That hasn't worked in years.. It certainly hasn't been updated in a very long time..
21:21:50 <warlord> namazu was removed from fedora somewhere around F12 or so...
21:24:36 *** KaiForce has joined #gnucash
21:26:36 <fell> But it is still working - and now I found it. Probably I had some bad character in my search expression.
21:40:09 <warlord> I'm surprised it works for you; the page is all messed up, and frankly I'm dropping support for it when I migrate the server
21:40:46 <warlord> (yeah, last supported version was from FC12; upgrading to FC20, so it was last updated 4 years ago)
21:57:21 <warlord> fell: if you have a suggestion of an alternate search tool that ships with fedora, please let me know.
22:21:12 <wiggin> warlord: yeah i didnt have the right dbi driver, works like a charm now
22:21:43 <warlord> wiggin: great!
22:43:33 *** gncbot` has joined #gnucash
23:05:20 <fell> warlord, I don't know, which would fit: http://en.wikipedia.org/wiki/Category:Free_search_engine_software
23:21:30 *** mohawk has joined #gnucash
23:25:12 <mohawk> Q1) I recently started using gnucash, but when I tried to reopen my accounting records after deleting the files ending in log it said my stored records couldn't be found. I took all the log files out of the trash but gnucash still couldn't find my file. How do I restore my lost info?
23:26:33 <warlord> mohawk: what is the *exact* error message?
23:29:13 *** LiamH has quit IRC
23:31:23 <mohawk> It says the file file:///users/pathway where the file is stored on my computer and the name I gave the file appears and then it simply says cannot be found.
23:32:18 <warlord> mohawk: cannot be found, not "cannot be parsed"?
23:33:07 <mohawk> No to be exact it says name of pathway, file.... .gnucash could not be found
23:33:32 <warlord> well, that implies that it cannot find it.
23:33:36 <warlord> What OS/Distro are you using?
23:33:44 <warlord> And what version of gnucash?
23:34:05 *** KaiForce has quit IRC
23:36:36 <mohawk> I'm using a mac computer OS X and I believe it's the latest version of gnucash.. I see what's new in version 2.0 when I look in the tutorial
23:42:53 <fell> mohawk: the tutorial version is different. Try in gnucash the Help->about button.
23:43:54 * warlord has to leave ...
23:44:01 <warlord> I'll be back in the morning (US/EST)
23:44:03 <warlord> Good night.
23:44:07 <fell> CU
23:46:42 <mohawk> I don't see the about button when I click on help
23:47:37 <mohawk> I see tutorial and concepts guide; tip of the day; and contents
23:50:00 <mohawk> When I try to open gnucash it says intel-2.6.0-1 2014.dmg
23:50:44 <mohawk> I appreciate your help and will try to connect with you in the morning. Thanks.