Open Source Integrated Library System

Evergreen on IRC

#openils-evergreen Logs for Friday, December 19th, 2008

< Thursday, December 18th, 2008Raw Log FileSaturday, December 20th, 2008 >
#TimeNickMessage
#01:56:41Mark__T has joined #openils-evergreen
#04:44:20robbat2 is now known as robbat2|na
#07:39:55wlayton_work has joined #openils-evergreen
#08:00:46zplstaff has joined #OpenILS-Evergreen
#08:00:59zplstaffthis is rickd, is anyone in?
#08:05:49miker_zplstaff: hey rick
#08:06:03zplstaffhey mike,
#08:06:36zplstaffwe have a staff client that somehow got into a mode where the patron search just says no patron selected but does not allow a search box
#08:06:49zplstaffwe uninstalled then installed again still no luck
#08:07:02zplstaffthen I just downloaded the client again from the site and reinstalled and it worked?
#08:07:18zplstaffIs that the best way to resolve this issue?
#08:07:23miker_there's a vertical bar over on the left, right up against the side of the window, that you should be able to drag to the right
#08:07:24zplstaffBy the way good morning
#08:07:29miker_:)
#08:07:34miker_g'morning :)
#08:07:36zplstaffahh, did not look at that
#08:08:09zplstaffreinstalling with the client from the site did it but I will try your fix if it happens again. about once a month
#08:08:15zplstaffthanks man you are the best
#08:08:29zplstaffgotta run, thanks again
#08:08:31miker_np
#08:10:18zplstaff has quit IRC
#08:51:30rsinger has joined #OpenILS-Evergreen
#08:52:20kgs_away has joined #openils-evergreen
#09:01:15kgs_away is now known as kgs
#09:05:28eby has joined #OpenILS-Evergreen
#09:32:38Dyrcona has joined #openils-evergreen
#09:33:21rsinger has quit IRC
#09:47:36jeffis there any documentation in the wiki or otherwise that describes the hierarchy/priority of things like "holdable" at the copy level, at the copy location level, the circ modifier + patron group level in terms of the circ matrix, etc?
#09:48:05jeffsomething that spells out what overrides what, in terms of holdable, circulate?, etc?
#09:50:13miker_jeff: if anything says "not holdable" then it's not
#09:50:22miker_same for circulate and opac visible
#09:50:28kgs has quit IRC
#09:50:53miker_note, though, that status.holdable=f also means it's not opac visible in 1.2
#09:51:00miker_in 1.4 they are separate on status
#09:52:03jeffstatus.holdable is a property of the item's current status, like damaged, missing, etc?
#09:52:18miker_correct
#09:52:24jeffgot it. thanks!
#09:52:30miker_asset.copy.status -> config.status.holdable
#09:58:55DyrconaOn a related note: I am looking at mapping the item status from our current ILS to Evergreen this morning.
#09:59:12jeffalways a fun undertaking
#09:59:18DyrconaFirst, I have a notion that some things (like a checked out status) are handled elsewhere.
#09:59:51DyrconaSecond, I assume it is OK for me to create new copy statuses in Evergreen for things like "in storage."
#10:00:53phasefx_just have their id's start above 100. The first 100 are reserved for native/stock statuses
#10:01:04miker_Dyrcona: on the second part, it sure is. there's a CGI in 1.2 (and part of conify in 1.4) for that
#10:01:17Dyrconathank you both.
#10:01:24miker_if you use the CGI or conify, it will take care of that for you
#10:01:31miker_no need to go to the db directly
#10:01:55Dyrconaok. i have the cgi open right now. I was typing a "mapping" into a csv file.
#10:02:24phasefx_also, give some thought on whether something should be a copy location or a status.. it's easy to overlap those concepts, but might not be good to do so
#10:02:28Dyrconai put ? for those that did not already have an equivalent copy status in Evergreen (or is it better to call it Open-ILS?)
#10:02:53kgs has joined #openils-evergreen
#10:03:05Dyrconaphasefx_: well, we have 35 members in the consortium, so I figure they'd prefer it be a status.
#10:03:30Dyrconaright now, though, i'm just investigating. no one has decided to migrate, yet.
#10:03:33miker_Dyrcona: direct mapping will difficult in some cases. there's (in our opinion) conflation of concepts embedded in statuses in other systems (similarly, item types get overloaded in other systems (again, in our opinion))
#10:03:43phasefx_a location doesn't have to be physical.. some folks have mapped "collection codes" to locations
#10:04:00miker_heh ... also, what phasefx_ said :)
#10:04:53_dkyle_ has joined #openils-evergreen
#10:04:54Dyrconaok. let me see if i can explain how that might work, that way, i'll know if i understand it or not.
#10:05:02Dyrconai would create a collection as a sublibrary of the main branch and make the sublibrary the owner of those items?
#10:05:18phasefx_between statuses, locations, call numbers, stat cats, and org units.. there are a lot of ways to "place" your items
#10:05:46Dyrconain our current ILS, we use collections more like stat cats, I think.
#10:08:29Dyrconaactually we have a collection that is treated as a location in our current ILS. I made it a sublibrary in our Evergreen config.
#10:08:58phasefx_typically organizational units (what you're thinking of as libraries and sub-libraries) get used to delineate political boundaries, physical boundaries, and departmental boundaries between and within libraries
#10:09:27Dyrconaok. this collection is somewhat special. it might fall under a political boundary.
#10:09:30phasefx_so you might have Consortium -> System A -> Branch B -> Sub-Library C
#10:09:42miker_Dyrcona: if you would like to force items to "transit" back there when they come into the main circ desk, that is good. If you want staff to handle getting it to the right place within the physical building, then a shelving location would be better, I think
#10:10:17miker_ok, sounds like sub-lib is right, then
#10:10:22phasefx_and for things like Fiction, Juvenile Fiction, Display Case, Storage, you might use locations
#10:10:32Dyrconaok.
#10:10:50Dyrcona"location" in our current ILS is equivalent to an org_unit.
#10:10:52phasefx_or if it really doesn't need to be patron-facing, you might use stat cats
#10:11:05Dyrconai have to keep the different vocabulary in mind.
#10:11:07miker_that gives you a way to enforce the political (policy) situation, and track items that live in that place more closely
#10:11:07phasefx_Funding Code, for example
#10:11:56miker_("that" being the sub-lib method as opposed to the shelving location method)
#10:13:28Dyrconaok. so it sounds like, i want to convert our current ILS's "collection codes" which we map directly to its "istats" as stat categories.
#10:13:43phasefx_ has to bow out for a bit, bbl
#10:14:25Dyrconai probably want to leave the "era" collection (which is basically a branch in our current ILS) as a sub-library.
#10:14:35phase_bb has joined #openils-evergreen
#10:15:01miker_Dyrcona: if that's just for reporting and staff use, yes. if you want patrons to use that, no. my gut says istat==stat_cat
#10:15:59Dyrconathe era collection is different. its paid for with state or regional money and gets treated like its own location for the most part.
#10:16:13Dyrconai don't know that patrons care about the difference, but they see it now.
#10:17:07Dyrconaright now, patrons don't see the istat collections, so making them stat_cats is definitely right.
#10:17:12miker_Dyrcona: yeah, don't worry about acquisitions stuff here, that's separate
#10:17:51miker_at least in terms of purchasing ... if it changes circ or location, then do care :)
#10:18:29Dyrconaok. i haven't thought about acquisitions, yet. we don't use the one from our current ILS, 'cause it isn't very good.
#10:18:57Dyrconalet me go back to my original question about copy_status, though.
#10:19:13Dyrconait is different from whether or not the item is checked out, right?
#10:19:34Dyrconaour current ILS conflates the two.
#10:20:04Dyrconai mean, it has a status for checked in and checked out as well as what look like the copy statuses in EVG.
#10:23:27Dyrconaso, i looked at the tables and answered my own quesiton.
#10:24:09Dyrconaits nice the amount of info that goes into action.circulation, but now I have to figure out how to fill that if we ever migrate. ;)
#10:25:22miker_:)
#10:25:38miker_yeah, status represents what is going on with the item right now
#10:25:42dbs has joined #openils-evergreen
#10:26:44miker_dbs: babywatch ought-niner still in effect?
#10:26:51dbsyup
#10:27:04berick read that as Baywatch
#10:27:20berickdbs hasselhof
#10:27:27dbsmaybe next week, which would be for the best, as I appear to have the flu, and babies and flu don't mix well
#10:28:16dbs has lost ten pounds, so he's getting closer to having that cut look - if only he had muscles
#10:29:18berickah, the flu diet
#10:29:33miker_dbs: I had the flu when z was born. if you're in the first 48h, tamiflu!
#10:30:46dbsmiker_: thanks man - but this is hour 160 or so
#10:31:25miker_arg!
#10:32:06Mark__T has quit IRC
#10:32:23dbsapparently they guessed wrong on the four strains of virus they used in the flu vaccine this year
#10:33:57miker_ha
#10:36:12Dyrconamiker_: I missed the checked out copy status when I went through the list earlier. now, i see it.
#10:59:18eby has quit IRC
#11:02:17Dyrconaanyone got time for another newbie question?
#11:02:18kgsdbs so sorry! get better
#11:02:31kgsdyrcona fire away... not sure I can answer but I can always refer
#11:03:35Dyrconai'll take another look at action.circulation, but how does Evg handle a "claims return", that is the book is still charged to the patron, and its overdue, but the patron claims to have returned the book/item?
#11:05:17Dyrconai don't see anything in asset.copy or action.circulation to give me a clue where else to look.
#11:07:50miker_action.circulation will have a stop_fines of "CLAIMSRETURNED"
#11:08:26miker_when the item comes back in, the checkin_time will be set, and if the fine balance is 0, the transaction closed
#11:08:45Dyrconaok, so i should use checked out as the copy status, then.
#11:08:51miker_right
#11:08:57Dyrconathx.
#11:09:46dbsthanks kgs
#11:09:47miker_and increment the claims_returned_count on the actor.usr record, if it matters to you to track that (for native claimes returned, that happens automatically)
#11:10:52kgs kgs is reading this too ;)
#11:11:31Dyrconaok. i suppose "Display" would be better as a shelving location than as a copy status.
#11:11:58kgsas in "new book display" right?
#11:12:22Dyrconayes, or for a seasonal display, they might have a bunch of christmas/hanukah books out now.
#11:13:14kgsdyrcona yes (someone thump me if I'm wrong on that) it's the function of shelving locations and it would confound things to make a copy status
#11:14:07kgsme, I'd be a little more specific -- Holiday Display
#11:15:07Dyrconafor now, i'll just map the status from our old system to available. they allow holds on these already.
#11:15:21kgs(unless you don't let people check out display books :-) )
#11:15:29Dyrconai'll set up locations for that later.
#11:15:34Dyrconawe do allow it.
#11:15:39kgsgood ;-)
#11:16:23phase_bbAnytime a copy status _does_ imply a location, it's usually a) transient/temporary and b) special compared to normal locations (for example, some action happens there)
#11:16:53kgsphase_bb such as weeding, or repair?
#11:17:04kgsor incoming?
#11:17:09kgsI mean inprocessing?
#11:17:10phase_bbYeah, and on holds shelf
#11:17:39kgsahh, the biggy :)
#11:17:46phase_bbRight
#11:18:00kgsor (for the future) "on order"
#11:18:07kgs?
#11:19:04phase_bbCopy locations are more persistent/permanent
#11:19:11Dyrconai added an additional "on order" because some of our member libraries allow requests on on order items and some don't.
#11:20:05kgsyes I have learned there is no consensus on the wisdom of on-order holds
#11:20:34jeffMIEG has on-order, and TADL treats it as holdable.
#11:20:42phase_bbThat might could be handled by policy configuration instead
#11:20:47kgson_order_holds++
#11:21:30Dyrconawell, i'm just learning Evg right now. this is an exploration to see what we'll have to do if we migrate for real.
#11:21:53jeffpreviously, we had placed notes on bibs or on 3x5" cards associated with the orders, saying "please put this item on reserve for patron barcode 12345 when it comes in"
#11:24:48miker_dbs: wanna do 1.4rc3 + opensrf-1.0.2 today/this-weekend? :)
#11:24:54berickdbs: can we close http://svn.open-ils.org/trac/ILS/ticket/18 ? I see a locale picker in trunk anway
#11:25:16miker_someone was just pondering whether 1.4 would be release /after/ 1.2 ;)
#11:25:32dbsberick: yeah, let's close that
#11:25:33miker_berick: and what say you, sir, to 1.4rc3?
#11:25:39bericks/1.2/2.0/
#11:26:13berickmiker_: i'm good. there are 2 nagging things in vandelay i want to add, but it should not stop the flow of progress
#11:26:14dbsphasefx: do we need to backport the network stuff for operator changes to 1.4?
#11:26:29miker_berick: features or fixes?
#11:26:36berickfeatures
#11:26:38dbsmiker_: how much of opensrf trunk do we want in opensrf rel_1_0?
#11:26:57miker_dbs: just the translator bug fixes, I think
#11:27:02phase_bbdbs: I'll look when I get back home
#11:27:04miker_dbs: from the last 2-3 days
#11:27:04bericki've backported my osrf fixes that were bugs
#11:27:08berickfor opensrf, that is
#11:27:16miker_berick: the JS stuff too?
#11:27:23berickyeah
#11:27:56dbsphasefx: okay. if we need to backport network stuff, then that's going to drive more i18n changes because those damned strings pop up everywhere
#11:28:47dbsso we could work towards opensrf 1.0.2 at the very least
#11:29:28berickarg, i need to add a multi-domain opensrf_core.xml example
#11:29:31bericki can do that today
#11:30:21miker_IMO, for opensrf, we're backporting bug fixes only, which have been tested (and found) via non-opensrf code... I'd like to just cut 1.0.2
#11:30:30miker_but, then, I always say that, I know :)
#11:32:59dbsberick: that would be awesome, and then maybe I will crystallize my understanding of multi-domain; my mind fuzzily grasps it currently (sad to say)
#11:34:06dbsmiker_: multi-domain would count as a bug fix, yes?
#11:38:32miker_dbs: in the example config? I call that documentation ;)
#11:41:27dbsI guess http://list.georgialibraries.org/pipermail/open-ils-dev/2008-March/002606.html is the official documentation for now
#11:42:20dbslook at that - there's already an example multi-domain opensrf_core.xml file
#11:43:17dbshttp://svn.open-ils.org/trac/ILS/browser/trunk/Open-ILS/examples/opensrf_core.xml.example.multidomain - why are you not in my checkout?
#11:43:34dbsahh - EG vs OpenSRF. duh.
#11:44:14berickbahha
#11:44:20bericki forgot there was already an example
#11:44:52berickhrm, need to fix the tabbing
#11:48:20dbsI'll give opensrf rel_1_0 a spin on plain jane debian etch
#11:49:22miker_berick: did you backport my (incomplete, as it turned out) changes from trunk to rel_1_0?
#11:50:49berickno, i didn't touch your commits
#11:57:52miker_ok
#12:02:22miker_berick: looks like we're missing a few things from opensrf.js
#12:02:34miker_wait
#12:02:49miker_just mine
#12:03:32miker_updated
#12:04:45rsinger has joined #OpenILS-Evergreen
#12:14:17kgsI'll be happy to blog about opensrf 1.0.2 when you release it -- just let me know
#12:19:02miker_kgs: will do
#12:19:12miker_berick: in that case ... are we ready?
#12:21:12dbsmiker_: well, there's no multi-domain sample config in rel_1_0
#12:27:06miker_dbs: point
#12:28:10dbsIn between downloading debian etch + lenny images, I've been thinking about what a reasonable sample would be, as well as what that will do to the docs
#12:29:44dbsgotta define a new domain in ejabberd.cfg
#12:29:57_dkyle_ has left #openils-evergreen
#12:33:43berick...and register users with the domain
#12:34:34berickwe really need to make the default opensrf_core.xml file for both osrf/eg use multidomain by default
#12:34:35dbs can't wait for the install & configure mess
#12:34:41berickyeah
#12:34:43dbsberick: yeah
#12:34:45berickmy concern as well
#12:45:45rsinger has quit IRC
#13:28:45phasefx_dbs: your change to mozilla.js setting the intl.accept_languages pref, you want that in 1.4?
#13:29:16dbsooh, yeah
#13:29:26phasefx_I'll get it
#13:29:44phasefx_just doing a dirdiff on trunk vs rel_1_4, walking through everything
#13:30:34phasefx_okay, so you have i18n'ized some things we missed in trunk.. did we call a string freeze already?
#13:31:00dbswe did, but where necessary I'm willing to bend that rule a bit
#13:31:28dbsespecially as this is the first time around
#13:32:04phasefx_oh pooh, there's unrelated changes in one of these files.. I'll have to hand-stitch :)
#13:34:10phasefx_I'll backport css changes too.. no harm there
#13:35:16phasefx_on second thought, nah.. css for a feature only in trunk
#13:36:27dbsphasefx_: hand stitching shouldn't be necessary if we merge changesets
#13:36:57phasefx_I don't really have experience doing that
#13:38:13dbshard to go from dir diffs to changesets. I could walk through my changesets and backport whatever. but is the util.network stuff going into 1.4?
#13:38:40phasefx_the only util.network stuff I see is i18n-related, that sound right?
#13:39:21phasefx_I have no preference for whether that gets backported or not
#13:40:17dbsdidn't that i18n stuff come from your operator change auth checks? or did that already go into 1.4?
#13:40:58phasefx_I'm not sure what you're talking about
#13:41:09dbsheh
#13:41:49phasefx_the only things I remember dealing with auth are the session cookies stuff, and a verify credentials function, which should stay trunk I think
#13:42:37dbshttp://svn.open-ils.org/trac/ILS/changeset/11388/trunk/Open-ILS/xul/staff_client/chrome/content/util/network.js
#13:42:41dbsright, session cookies
#13:43:06dbsDidn't we want those to solve a problem with conify / vandelay?
#13:43:09miker_phasefx_: cookies in 1.4 are needed
#13:43:15miker_yeah
#13:43:16phasefx_k, will backport those then
#13:43:30miker_phasefx_: thanks!
#13:44:04phasefx_I think that was all contained in one changeset, if someone wants to teach me how to do that by merging changesets
#13:44:33phasefx_ double-checks
#13:44:33berickcd rel_1_4; svn merge -c <changeset> svn://svn.open-ils.org/trunk .
#13:44:35dbssvn merge -c changeset# svn://svn.open-ils.org/ILS/trunk
#13:44:43berickjinx
#13:44:44dbsjinx
#13:44:47berickaaaaaaaaa;skoldjasd;lfkj
#13:44:48dbsdouble jinx!
#13:44:56phasefx_and then I get to review it and commit?
#13:45:04berickyeah, it just changes your local copy
#13:45:08phasefx_coool
#13:45:19phasefx_multiple changesets
#13:45:24Dyrcona has quit IRC
#13:45:59phasefx_one changeest
#13:46:01berickfor ranges: svn merge -rstart_changeset_minus_1:last_changset
#13:46:31berickIOW, to merge changes 123 and 124 ... svn merge -r 122:124 svn://...
#13:46:45phasefx_k
#13:46:50phasefx_thanks guys
#13:50:14dbs regrets picking "desktop system" in this new debian etch vbox image setup... dollars to doughnuts I won't need xsane to test out opensrf
#13:50:34phasefx_:D
#13:50:45miker_haha
#13:51:09miker_dbs++ # particularly for using my favorite "I'll bet you" variant
#13:55:50till_ has quit IRC
#13:57:40robbat2|na is now known as robbat2
#14:13:38jeff bashes head on desk
#14:16:11phasefx_berick: where's that animation of yours?
#14:18:09berickhttp://dev.gapines.org/~erickson/computer.gif
#14:18:27phasefx_jeff: ^^
#14:18:30jeffand that is the exact animation i figured it would be :)
#14:18:30phasefx_berick++
#14:18:36phasefx_haha
#14:18:57phasefx_if we can get a license for it, could use that instead of EG's skull & crossbones :)
#14:19:35jeffeither i'm finding bugs in the reporter, or i'm not understanding how i'm supposed to do this.
#14:19:49jeffi'm trying to report on desk payments by billing type
#14:21:13jeffif i sum(amount) i get an incredibly high number for Overdue materials. if i leave it at raw data, i get 20 transactions totalling hundreds of dollars less than when doing a sum.
#14:22:04jeff(where "incredibly high number" is "hundreds more than expected")
#14:23:18jeffthe totals report is higher than the total number of desk payments shown in the built-in Cash Reports... and the details report is lower. :P
#14:25:21jeffbut yeah. computer.gif all the way.
#14:26:52phasefx_what's your base source?
#14:29:34jeffpayments: desk
#14:31:24jeffoutputs are payment type, amount, and billable transaction -> billing line items -> billing type
#14:32:22phasefx_and you have two versions of that, one with sum and one with raw
#14:32:49jeffbase filters are payment date/time date between (fill in the blanks), voided equals false, and cash drawer -> owning library -> org unit id equals (fill in the blank)
#14:33:35kgsjeff I'm in three conversations but actually have the 1.4rc2 reporter oopen and will tinker (not the first tiem I wished someone could email me a template i could import)
#14:34:21jeffif i clone that report, change the transform on amount from sum to raw data, and add payment date/time as an output, i get way different totals. it seems as if the report with way different totals
#14:34:30jeff(i take the details report and sum it in excel)
#14:34:49jeffkgs: i can e-mail you (or anyone else) screenshots
#14:35:01jeffwe need a pastebin with image support ;)
#14:35:12kgseh, I just need five minutes to replicate the template, methinks :)
#14:35:26kgsjeff we could webinar live any time you like that I'm aailable
#14:36:09jefflet me know when you're available. i think our consortium support is done for the day due to weather, and i suspect they'd likely pass this right on to ESI anyway. :)
#14:37:04phasefx_jeff: try it without the billable transaction -> billing ine items -> billing type part
#14:37:15jeffphasefx_: willtry.
#14:38:27phasefx_fwiw, I tried a simple version of what you did on demo (as admin, under the test folder: jason/jeff test 1 and jason/jeff test 2) and got different totals as well
#14:39:18till_ has joined #OpenILS-Evergreen
#14:39:26phasefx_with just Amount (Raw or Sum) as the display, and Accepting user as the filter
#14:40:00jeffokay, yep. removing billing type from the report output gives me a total that matches the total amount of desk payments in the built-in cash report.
#14:40:08jeffso... why does it break?
#14:40:59jeff tries the detail report after removing billing type also
#14:42:11phasefx_when you do billing line items, the relationship isn't 1 to 1
#14:42:13kgsjeff I'll play with this anyway...
#14:42:46phasefx_so you might have Payment A be associated with Billing 1 and Billing 2 (by virtue of being on the same transaction)
#14:42:48jeffphasefx_: so it's multiplying overdue fines.
#14:43:04phasefx_and then Payment B, may also be on the same transaction, and duplicate the output for Billing 1 and Billing 2
#14:43:20phasefx_and not only that.. the Amount for Payment A will show up twice (once for each of those billings)
#14:43:28phasefx_and the same with Payment B
#14:43:31jeffokay, so i'll need to treat the report as a way of getting the data out, and then i'll need to do most of my post-processing outside of evergreen
#14:45:15phasefx_jeff: you might be able to use one of those summary views.. report on the billable transaction as your source, not the payments
#14:45:23phasefx_then link to the payments and sum those
#14:48:10jefffirst problem i see with that is that i lose the overall desk payments cash drawer link, i have to dig for it under payment line items -> cash payment detail -> cash_drawer
#14:48:45jeffso i think that means i'll need one report for each payment type.
#14:48:53jefftesting, though.
#14:49:47jeff finds another reporter UI bug
#14:49:48jeffheh
#14:52:38rsinger has joined #OpenILS-Evergreen
#15:00:20jeffnope. turning it around and starting from billable transaction and linking the payment line items gives the same results, where is is apparently multiplying payments, mostly on overdue materials (because those are so much more likely to have multiple bills per payment)
#15:00:33jeffbleh.
#15:00:50phasefx_you're still trying to get the billing type?
#15:00:54jeffwell, let me see if i can get a detailed report that has a total matching the built in cash reports, and i'll see where that gets me.
#15:01:16jeffphasefx_: yes, i was still trying to get the billing type.
#15:01:24phasefx_you can't really associate payments with bills in any manner other than to say that happened on the same transaction
#15:02:11phasefx_if there are $10 worth of late fees, a $10 replacement fee, and a $10 processing fee.. and the patron pays it down by $20.. which bills did the payments go toward? You can't really say
#15:02:14jeffso if i want to take payments and break them down by what they were paid for, i need to use a report to get the data out of evergreen, then summarize/total outside of evergreen, correct?
#15:03:01jeffif i have three $10 bills and i pay $20, don't two of those bills now show in evergreen as having been paid in full?
#15:03:07jeffi haven't tried, really.
#15:03:19phasefx_if you have 3 billable transactions
#15:03:39phasefx_but if you have 3 billings on 1 billable transaction, then you have some ambiguity if you try to stick payments to something specific
#15:04:40jeffbecause billable transactions can contain multiple billing line items, and billing line items can have different billing types within one billable transaction?
#15:04:51phasefx_right
#15:05:28phasefx_some of these summary views might show you the last billing type, for the transaction
#15:05:40jeffknow of any offhand?
#15:06:13phasefx_no, I haven't really played around with them. Do you see any source with the word open transactions or something in them?
#15:06:43phasefx_and I imagine you're wanting to report on closed transactions too
#15:07:00wlayton_work has quit IRC
#15:07:32jeffi'm trying to give a report on total cash taken in during a date range at a specific library, broken down by billing type. different billing types go into different accounts.
#15:08:43phasefx_cash include checks and the like?
#15:08:58jeffyeah, "desk payments"
#15:09:24jeffi was doing a pivot on payment type with my source set to payments: desk
#15:09:31jeffso i was getting one column with cash and one with checks
#15:09:42jeff(we're not yet doing in-person credit cards, but soon)
#15:10:06phasefx_you know, you could "define" a resolution for how payments might link to billings.. payments pay off older billings first, for example. But I don't think the reporting system would accomodate such things
#15:10:24berickhuh, next Debian will be Squeeze :)
#15:12:11phasefx_jeff: another option is to make uber-catagories for different combinations of billing types.. so if this transaction only has late fees, then the uber type is Late Fee.. but if it has late fees and lost item charges, the uber type might be Late + Lost
#15:12:39jeffjust knowing when a billing line item was paid would help, but i can see how that is a challenge, too.
#15:12:45jeffugh.
#15:13:07phasefx_jeff: but then you also having timing issues to consider (or ignore). A transaction accumulates late fees.. some money is applied but the transaction isn't closed.. later, a lost billing is applied, and more money is applied.
#15:14:03phasefx_does all that money get assigned to an uber category Late + Lost? or should the earlier money be binned as Late, and the later money as Lost?
#15:14:29jeffa uber category of late + lost doesn't help us any.
#15:14:52jeffbecause i'd still need to know how much was "late", and how much was "lost".
#15:16:39phasefx_could also restrict yourself to closed transactions, but you still still have room for ambiguity. You have an xact with Late and Lost charges.. patron wants to pay it all off, but wants to split the payment between cash and check
#15:16:48phasefx_You know exactly how much money went to Lost and how much went to Late, but you can't tell the payment method
#15:17:30phasefx_just need to work out some arbitrary resolution and be consistent with it forever after
#15:17:52jeffthat part doesn't matter. i need two things: i need a total that can be matched against a bank deposit, and i need a breakdown of why we received the money (billing type)
#15:28:43dbsI think I'm caught up on my backports from trunk for EG - we'll still hit util.network i18n errors everywhere though, as offlineStrings are currently only available in patron_display.xul
#15:33:06Dyrcona has joined #openils-evergreen
#15:47:16jeff"circulate as type" in the copy editor... is that to override the type in the MARC leader, and is it mainly for stats purposes?
#15:48:58phasefx_it's used for circulation behavior, and would override any behavior based on the type in the MARC
#15:49:40phasefx_so let's say you were determining loan durations and fine intervals based on the bib record instead of circ modifier.. this would let you treat the item as if it were actually on a different type of bib
#15:53:09jeffgot it.
#15:53:26jeffdoesn't affect searching or display in the OPAC?
#15:54:14jeffprobably no need to set it in most cases?
#15:55:15phasefx_wouldn't affect the OPAC, no
#15:55:41phasefx_just a knob you can use to base behavior on, and report on
#15:55:53phasefx_circ/hold behavior
#15:58:44miker_ returns to 2 hours of reporting "fun"
#15:59:00jeffif an item doesn't circ and is in a shelving/copy location with holdable no and circulate no, does it need a circ modifier?
#16:00:14miker_jeff: if we can define the deired result and build a view to encapsulate that, we can plug it into the reporting system ... it's actually got chunks mean specifically for that. there are examples of this for PINES-specific views (the "classic blah" sources)
#16:00:26miker_s/mean/meant
#16:00:50phasefx_depends.. do you do any reporting broken down by circ_modifier, and if so, do you want this showing up the same as every other item with no circ modifier.. and, if staff were to override the restrict, and the item circulated anyway, would you want to treat the item as if it binned by circ modifier like other items
#16:02:40jeffmiker_: sounds promising... :)
#16:04:18miker_in 1.4 you don't even have to add a DB view, just add and describe the base select statement a config file (the fm_IDL.xml file)
#16:05:37jeffi have access to neither, so that's not too much of an improvement for me ;)
#16:06:33miker_ha
#16:08:04miker_jeff: I don't want to talk out of school, but bott may be a resource on the access front (test box or such) ... or you could use the vmware/virt-box image ... or install for yourself in your copious amounts of spare time
#16:10:07dbs finally gets around to preparing to install osrf rel_1_0 on his new vboxes
#16:11:24miker_dbs++
#16:12:27dbsa is going to be back from daycare soon though, which will probably wreak havoc on my attempts to become master of my own multi-domain
#16:17:52miker_give her the camel book and tell her to with regexp's ;)
#16:22:47jamesrf has joined #openils-evergreen
#16:27:28kgsdbs tell her there's a little project she can help daddy and kgs with...
#16:28:50berickyikes, it's 12 F in toronto
#16:29:07berick is trying to get mentally prepared for ola ;)
#16:29:21berickand 72F here
#16:30:05jeffmiker_: yes, i have test systems i can play with (when i make/find time), but it was the {add view to DB|add SQL to fm_IDL.xml} on the live system that is access-equivalient to me
#16:30:16jeff(meaning either one i'd have to ask bott to do)
#16:31:02dbshrm, how averse would you be to me backporting Makefile.install from trunk to rel_1_0? introduces debian-lenny / debian-etch targets instead of generic debian, so's we can use more system packages
#16:31:49miker_dbs: if ti works, not at all :)
#16:32:15dbsjust testing now
#16:36:32rsinger has quit IRC
#16:38:56miker_dbs: I suspect it'll work fine ... nothing "new" in trunk, really
#16:40:32dbsright, but I'm a sort-of cautious type.
#16:42:29kgsmeasure twice, cut once
#16:43:02miker_measure? what's that?
#16:43:30kgs;-)
#16:43:40bericki think it's Greek
#16:46:27dbsi was thinking about that today, watching my cat prepare to jump up onto a counter
#16:48:59kgscats do calculate
#16:49:12dbsbah - damn you, gcrypt
#16:51:15kgsgoing for my run before it gets dark, but am going to continue reading docbook 5.0 when I get back...
#16:54:31dbsman i hate how cpan forces you to rm -fr .cpan/build if a cpan install fails for some reason (or at least that's the only way I've found around the problem)
#16:56:50rsinger has joined #OpenILS-Evergreen
#16:59:24miker_dbs: I haven't run into such a problem ... but then gcrypt likes me
#17:00:15dbsmiker_: the problem of libgrcypt / libgdbm being relatively new dependencies for xml::libxslt?
#17:01:10miker_oh, I'm just saying random words at this point
#17:01:23miker_I mean, I haven't seen cpan stop working on me
#17:01:40miker_but I have no idea about gcrypt or the problems it causes
#17:01:58bericki ran into that recently. something died and cpan would install nothing else
#17:02:01dbsgcrypt/gdbm problem was solved by adding the packages to the Makefile.install
#17:02:21berickbut if you went into the build dir, did you usual make/make test/make install it worked fine
#17:02:37dbscpan seems to get upset if a package fails to build - it will install other packages just fine, but it seems to use a cached result of the last build attempt
#17:02:42dbsright
#17:02:58dbsthat was the workaround for zoom
#17:04:59jeff"Patron reported a vague phone message about her reserve at Woodmere"
#17:05:17jeff"Tech staff reported a vague trouble ticket"... :P
#17:06:41berickheh
#17:06:47dbsat some point, we should probably fix up the install so it automatically installs the sysconfdir stuff under the user/group of the specified user (defaulting to opensrf)
#17:06:59phasefx_"You may or may not have a reserve at some library you've been to. This is a recording."
#17:08:19dbssuccessful install on debian lenny (where success = no configure, make, or make install errors reported)
#17:08:20miker_"ESI vaguely fixed the glitch. It'll work itself out."
#17:08:30miker_WE FIXED THE GLITCH
#17:08:47miker_dbs: worksforme
#17:09:09miker_berick: did you want to get an openserf-generic example of multidomain in before 1.0.2?
#17:11:14berickah, yeah. actually, dbs offered to if I put on in Evergreen ;)
#17:11:22berickbut, i can copy that one over and modify
#17:11:30dbsbastard, I knew you would hold me to that :)
#17:11:33berickhahaa
#17:11:41berickno, just calling you out, that's all ;)
#17:11:43dbsI'm also fixing up the README
#17:11:54berickI got it
#17:11:55jeffhrm. doesn't screen have a "save scrollback buffer to file"?
#17:12:02dbsOh, I would do it. But it might not happen for many more hours.
#17:12:10jeffguess not. have to go into scroll, select, copy, then save paste buffer.
#17:12:20berickjeff: it does, i've used it before
#17:13:16berickjeff: -L maybe?
#17:14:32jeffyeah, that or C-a H will log to a file for new lines, but i want the current contents of the scroll buffer written out
#17:14:57berickah
#17:14:58berickok
#17:15:01bericknot sure about that one
#17:16:03miker_C-a, Esc ... then copy and paste with a mouse? ;)
#17:16:22miker_you can page up and downs after C-a Esc
#17:17:03jeffC-a ESC g Space %100 >
#17:17:25jeffdamn. the % doesn't seem to work
#17:17:49jeffaha. g and G
#17:18:13jeffC-a ESC g Space G >
#17:18:41jeffcopies to /tmp/screen-exchange by default
#17:19:20phasefx_coool
#17:20:09jeff(g goes to top of buffer, G goes to bottom, space sets the first mark, > writes to /tmp/screen-exchange, implicitly closing the selection at the cursor)
#17:21:35phasefx_ remembers a dos TSR called screen.. used it for cut & paste
#17:21:53phasefx_wish I had grown up on unix :)
#17:23:21rsinger has quit IRC
#17:24:17jamesrfopensrf qbasic server ftw
#17:34:34miker_jamesrf: totally! I have visual basic for dos 3.5 right over there
#17:35:09rsinger has joined #OpenILS-Evergreen
#17:36:26dbssuccess on debian-etch too
#17:36:46dbs(by my minimalist definition of success)
#17:38:52rsinger has quit IRC
#17:39:36miker_dinner, biab
#17:53:19berickok, osrf config is now multi-domain
#18:45:05kgs has quit IRC
#19:48:38skmurphy has joined #openils-evergreen
#19:57:30dbsberick++
#19:57:43dbshey skmurphy
#19:58:09dbsI'm tempted to switch "localhost" to "private.localhost" for ease of documentation
#19:59:28berickyou know, that's what it was, but i thought it would just make it unnecessarily complex. i can see what you mean, though
#20:00:58skmurphyhey dbs
#20:01:07skmurphyhows it going?
#20:01:41dbsokay. feeling a bit better tonight. had some food
#20:02:22skmurphyit's very very snowy in your country
#20:04:05dbshey, don't blanket me with your generalisms! it's just bitterly cold up here
#20:05:16skmurphy=
#20:05:19skmurphy=)
#20:08:07dbsberick: so we're really looking at registering four ejabberd users now: opensrf@public, opensrf@private, router@public, and router@private - yeah?
#20:23:19skmurphy has quit IRC
#21:10:19jamesrf has quit IRC
#21:22:13dbs apparently fell into a multi-domain minefield. argh.
#21:29:56dbsXMPP connect is failing for private.localhost, but seemingly working for public.localhost
#21:36:11skmurphy has joined #openils-evergreen
#21:37:18dbsbizarre. it's pulling the wrong password for the router user.
#21:54:34dbsbah. I'm going to check in what I have anyways. Maybe you'll spot something horribly obvious in it.
#21:56:32rsinger has joined #OpenILS-Evergreen
#22:08:44dbsoh, and that last correction of my mistake isn't the problem - ejabberd is telling me that it's matching up username/password of router/opensrf for private.localhost when my config has router/router or opensrf/opensrf
#22:13:44dbsg'nite
#22:13:50dbs has quit IRC
#23:15:24rsinger has quit IRC
< Thursday, December 18th, 2008Raw Log FileSaturday, December 20th, 2008 >