2008-12-19T01:56:41 *** Mark__T has joined #openils-evergreen 2008-12-19T04:44:20 *** robbat2 is now known as robbat2|na 2008-12-19T07:39:55 *** wlayton_work has joined #openils-evergreen 2008-12-19T08:00:46 *** zplstaff has joined #OpenILS-Evergreen 2008-12-19T08:00:59 this is rickd, is anyone in? 2008-12-19T08:05:49 zplstaff: hey rick 2008-12-19T08:06:03 hey mike, 2008-12-19T08:06:36 we 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 2008-12-19T08:06:49 we uninstalled then installed again still no luck 2008-12-19T08:07:02 then I just downloaded the client again from the site and reinstalled and it worked? 2008-12-19T08:07:18 Is that the best way to resolve this issue? 2008-12-19T08:07:23 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 2008-12-19T08:07:24 By the way good morning 2008-12-19T08:07:29 :) 2008-12-19T08:07:34 g'morning :) 2008-12-19T08:07:36 ahh, did not look at that 2008-12-19T08:08:09 reinstalling with the client from the site did it but I will try your fix if it happens again. about once a month 2008-12-19T08:08:15 thanks man you are the best 2008-12-19T08:08:29 gotta run, thanks again 2008-12-19T08:08:31 np 2008-12-19T08:10:18 *** zplstaff has quit IRC 2008-12-19T08:51:30 *** rsinger has joined #OpenILS-Evergreen 2008-12-19T08:52:20 *** kgs_away has joined #openils-evergreen 2008-12-19T09:01:15 *** kgs_away is now known as kgs 2008-12-19T09:05:28 *** eby has joined #OpenILS-Evergreen 2008-12-19T09:32:38 *** Dyrcona has joined #openils-evergreen 2008-12-19T09:33:21 *** rsinger has quit IRC 2008-12-19T09:47:36 is 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? 2008-12-19T09:48:05 something that spells out what overrides what, in terms of holdable, circulate?, etc? 2008-12-19T09:50:13 jeff: if anything says "not holdable" then it's not 2008-12-19T09:50:22 same for circulate and opac visible 2008-12-19T09:50:28 *** kgs has quit IRC 2008-12-19T09:50:53 note, though, that status.holdable=f also means it's not opac visible in 1.2 2008-12-19T09:51:00 in 1.4 they are separate on status 2008-12-19T09:52:03 status.holdable is a property of the item's current status, like damaged, missing, etc? 2008-12-19T09:52:18 correct 2008-12-19T09:52:24 got it. thanks! 2008-12-19T09:52:30 asset.copy.status -> config.status.holdable 2008-12-19T09:58:55 On a related note: I am looking at mapping the item status from our current ILS to Evergreen this morning. 2008-12-19T09:59:12 always a fun undertaking 2008-12-19T09:59:18 First, I have a notion that some things (like a checked out status) are handled elsewhere. 2008-12-19T09:59:51 Second, I assume it is OK for me to create new copy statuses in Evergreen for things like "in storage." 2008-12-19T10:00:53 just have their id's start above 100. The first 100 are reserved for native/stock statuses 2008-12-19T10:01:04 Dyrcona: on the second part, it sure is. there's a CGI in 1.2 (and part of conify in 1.4) for that 2008-12-19T10:01:17 thank you both. 2008-12-19T10:01:24 if you use the CGI or conify, it will take care of that for you 2008-12-19T10:01:31 no need to go to the db directly 2008-12-19T10:01:55 ok. i have the cgi open right now. I was typing a "mapping" into a csv file. 2008-12-19T10:02:24 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 2008-12-19T10:02:28 i put ? for those that did not already have an equivalent copy status in Evergreen (or is it better to call it Open-ILS?) 2008-12-19T10:02:53 *** kgs has joined #openils-evergreen 2008-12-19T10:03:05 phasefx_: well, we have 35 members in the consortium, so I figure they'd prefer it be a status. 2008-12-19T10:03:30 right now, though, i'm just investigating. no one has decided to migrate, yet. 2008-12-19T10:03:33 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)) 2008-12-19T10:03:43 a location doesn't have to be physical.. some folks have mapped "collection codes" to locations 2008-12-19T10:04:00 heh ... also, what phasefx_ said :) 2008-12-19T10:04:53 *** _dkyle_ has joined #openils-evergreen 2008-12-19T10:04:54 ok. let me see if i can explain how that might work, that way, i'll know if i understand it or not. 2008-12-19T10:05:02 i would create a collection as a sublibrary of the main branch and make the sublibrary the owner of those items? 2008-12-19T10:05:18 between statuses, locations, call numbers, stat cats, and org units.. there are a lot of ways to "place" your items 2008-12-19T10:05:46 in our current ILS, we use collections more like stat cats, I think. 2008-12-19T10:08:29 actually we have a collection that is treated as a location in our current ILS. I made it a sublibrary in our Evergreen config. 2008-12-19T10:08:58 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 2008-12-19T10:09:27 ok. this collection is somewhat special. it might fall under a political boundary. 2008-12-19T10:09:30 so you might have Consortium -> System A -> Branch B -> Sub-Library C 2008-12-19T10:09:42 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 2008-12-19T10:10:17 ok, sounds like sub-lib is right, then 2008-12-19T10:10:22 and for things like Fiction, Juvenile Fiction, Display Case, Storage, you might use locations 2008-12-19T10:10:32 ok. 2008-12-19T10:10:50 "location" in our current ILS is equivalent to an org_unit. 2008-12-19T10:10:52 or if it really doesn't need to be patron-facing, you might use stat cats 2008-12-19T10:11:05 i have to keep the different vocabulary in mind. 2008-12-19T10:11:07 that gives you a way to enforce the political (policy) situation, and track items that live in that place more closely 2008-12-19T10:11:07 Funding Code, for example 2008-12-19T10:11:56 ("that" being the sub-lib method as opposed to the shelving location method) 2008-12-19T10:13:28 ok. so it sounds like, i want to convert our current ILS's "collection codes" which we map directly to its "istats" as stat categories. 2008-12-19T10:13:43 * phasefx_ has to bow out for a bit, bbl 2008-12-19T10:14:25 i probably want to leave the "era" collection (which is basically a branch in our current ILS) as a sub-library. 2008-12-19T10:14:35 *** phase_bb has joined #openils-evergreen 2008-12-19T10:15:01 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 2008-12-19T10:15:59 the era collection is different. its paid for with state or regional money and gets treated like its own location for the most part. 2008-12-19T10:16:13 i don't know that patrons care about the difference, but they see it now. 2008-12-19T10:17:07 right now, patrons don't see the istat collections, so making them stat_cats is definitely right. 2008-12-19T10:17:12 Dyrcona: yeah, don't worry about acquisitions stuff here, that's separate 2008-12-19T10:17:51 at least in terms of purchasing ... if it changes circ or location, then do care :) 2008-12-19T10:18:29 ok. i haven't thought about acquisitions, yet. we don't use the one from our current ILS, 'cause it isn't very good. 2008-12-19T10:18:57 let me go back to my original question about copy_status, though. 2008-12-19T10:19:13 it is different from whether or not the item is checked out, right? 2008-12-19T10:19:34 our current ILS conflates the two. 2008-12-19T10:20:04 i mean, it has a status for checked in and checked out as well as what look like the copy statuses in EVG. 2008-12-19T10:23:27 so, i looked at the tables and answered my own quesiton. 2008-12-19T10:24:09 its 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. ;) 2008-12-19T10:25:22 :) 2008-12-19T10:25:38 yeah, status represents what is going on with the item right now 2008-12-19T10:25:42 *** dbs has joined #openils-evergreen 2008-12-19T10:26:44 dbs: babywatch ought-niner still in effect? 2008-12-19T10:26:51 yup 2008-12-19T10:27:04 * berick read that as Baywatch 2008-12-19T10:27:20 dbs hasselhof 2008-12-19T10:27:27 maybe next week, which would be for the best, as I appear to have the flu, and babies and flu don't mix well 2008-12-19T10:28:16 * dbs has lost ten pounds, so he's getting closer to having that cut look - if only he had muscles 2008-12-19T10:29:18 ah, the flu diet 2008-12-19T10:29:33 dbs: I had the flu when z was born. if you're in the first 48h, tamiflu! 2008-12-19T10:30:46 miker_: thanks man - but this is hour 160 or so 2008-12-19T10:31:25 arg! 2008-12-19T10:32:06 *** Mark__T has quit IRC 2008-12-19T10:32:23 apparently they guessed wrong on the four strains of virus they used in the flu vaccine this year 2008-12-19T10:33:57 ha 2008-12-19T10:36:12 miker_: I missed the checked out copy status when I went through the list earlier. now, i see it. 2008-12-19T10:59:18 *** eby has quit IRC 2008-12-19T11:02:17 anyone got time for another newbie question? 2008-12-19T11:02:18 dbs so sorry! get better 2008-12-19T11:02:31 dyrcona fire away... not sure I can answer but I can always refer 2008-12-19T11:03:35 i'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? 2008-12-19T11:05:17 i don't see anything in asset.copy or action.circulation to give me a clue where else to look. 2008-12-19T11:07:50 action.circulation will have a stop_fines of "CLAIMSRETURNED" 2008-12-19T11:08:26 when the item comes back in, the checkin_time will be set, and if the fine balance is 0, the transaction closed 2008-12-19T11:08:45 ok, so i should use checked out as the copy status, then. 2008-12-19T11:08:51 right 2008-12-19T11:08:57 thx. 2008-12-19T11:09:46 thanks kgs 2008-12-19T11:09:47 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) 2008-12-19T11:10:52 * kgs kgs is reading this too ;) 2008-12-19T11:11:31 ok. i suppose "Display" would be better as a shelving location than as a copy status. 2008-12-19T11:11:58 as in "new book display" right? 2008-12-19T11:12:22 yes, or for a seasonal display, they might have a bunch of christmas/hanukah books out now. 2008-12-19T11:13:14 dyrcona 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 2008-12-19T11:14:07 me, I'd be a little more specific -- Holiday Display 2008-12-19T11:15:07 for now, i'll just map the status from our old system to available. they allow holds on these already. 2008-12-19T11:15:21 (unless you don't let people check out display books :-) ) 2008-12-19T11:15:29 i'll set up locations for that later. 2008-12-19T11:15:34 we do allow it. 2008-12-19T11:15:39 good ;-) 2008-12-19T11:16:23 Anytime 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) 2008-12-19T11:16:53 phase_bb such as weeding, or repair? 2008-12-19T11:17:04 or incoming? 2008-12-19T11:17:09 I mean inprocessing? 2008-12-19T11:17:10 Yeah, and on holds shelf 2008-12-19T11:17:39 ahh, the biggy :) 2008-12-19T11:17:46 Right 2008-12-19T11:18:00 or (for the future) "on order" 2008-12-19T11:18:07 ? 2008-12-19T11:19:04 Copy locations are more persistent/permanent 2008-12-19T11:19:11 i added an additional "on order" because some of our member libraries allow requests on on order items and some don't. 2008-12-19T11:20:05 yes I have learned there is no consensus on the wisdom of on-order holds 2008-12-19T11:20:34 MIEG has on-order, and TADL treats it as holdable. 2008-12-19T11:20:42 That might could be handled by policy configuration instead 2008-12-19T11:20:47 on_order_holds++ 2008-12-19T11:21:30 well, i'm just learning Evg right now. this is an exploration to see what we'll have to do if we migrate for real. 2008-12-19T11:21:53 previously, 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" 2008-12-19T11:24:48 dbs: wanna do 1.4rc3 + opensrf-1.0.2 today/this-weekend? :) 2008-12-19T11:24:54 dbs: can we close http://svn.open-ils.org/trac/ILS/ticket/18 ? I see a locale picker in trunk anway 2008-12-19T11:25:16 someone was just pondering whether 1.4 would be release /after/ 1.2 ;) 2008-12-19T11:25:32 berick: yeah, let's close that 2008-12-19T11:25:33 berick: and what say you, sir, to 1.4rc3? 2008-12-19T11:25:39 s/1.2/2.0/ 2008-12-19T11:26:13 miker_: i'm good. there are 2 nagging things in vandelay i want to add, but it should not stop the flow of progress 2008-12-19T11:26:14 phasefx: do we need to backport the network stuff for operator changes to 1.4? 2008-12-19T11:26:29 berick: features or fixes? 2008-12-19T11:26:36 features 2008-12-19T11:26:38 miker_: how much of opensrf trunk do we want in opensrf rel_1_0? 2008-12-19T11:26:57 dbs: just the translator bug fixes, I think 2008-12-19T11:27:02 dbs: I'll look when I get back home 2008-12-19T11:27:04 dbs: from the last 2-3 days 2008-12-19T11:27:04 i've backported my osrf fixes that were bugs 2008-12-19T11:27:08 for opensrf, that is 2008-12-19T11:27:16 berick: the JS stuff too? 2008-12-19T11:27:23 yeah 2008-12-19T11:27:56 phasefx: okay. if we need to backport network stuff, then that's going to drive more i18n changes because those damned strings pop up everywhere 2008-12-19T11:28:47 so we could work towards opensrf 1.0.2 at the very least 2008-12-19T11:29:28 arg, i need to add a multi-domain opensrf_core.xml example 2008-12-19T11:29:31 i can do that today 2008-12-19T11:30:21 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 2008-12-19T11:30:30 but, then, I always say that, I know :) 2008-12-19T11:32:59 berick: that would be awesome, and then maybe I will crystallize my understanding of multi-domain; my mind fuzzily grasps it currently (sad to say) 2008-12-19T11:34:06 miker_: multi-domain would count as a bug fix, yes? 2008-12-19T11:38:32 dbs: in the example config? I call that documentation ;) 2008-12-19T11:41:27 I guess http://list.georgialibraries.org/pipermail/open-ils-dev/2008-March/002606.html is the official documentation for now 2008-12-19T11:42:20 look at that - there's already an example multi-domain opensrf_core.xml file 2008-12-19T11:43:17 http://svn.open-ils.org/trac/ILS/browser/trunk/Open-ILS/examples/opensrf_core.xml.example.multidomain - why are you not in my checkout? 2008-12-19T11:43:34 ahh - EG vs OpenSRF. duh. 2008-12-19T11:44:14 bahha 2008-12-19T11:44:20 i forgot there was already an example 2008-12-19T11:44:52 hrm, need to fix the tabbing 2008-12-19T11:48:20 I'll give opensrf rel_1_0 a spin on plain jane debian etch 2008-12-19T11:49:22 berick: did you backport my (incomplete, as it turned out) changes from trunk to rel_1_0? 2008-12-19T11:50:49 no, i didn't touch your commits 2008-12-19T11:57:52 ok 2008-12-19T12:02:22 berick: looks like we're missing a few things from opensrf.js 2008-12-19T12:02:34 wait 2008-12-19T12:02:49 just mine 2008-12-19T12:03:32 updated 2008-12-19T12:04:45 *** rsinger has joined #OpenILS-Evergreen 2008-12-19T12:14:17 I'll be happy to blog about opensrf 1.0.2 when you release it -- just let me know 2008-12-19T12:19:02 kgs: will do 2008-12-19T12:19:12 berick: in that case ... are we ready? 2008-12-19T12:21:12 miker_: well, there's no multi-domain sample config in rel_1_0 2008-12-19T12:27:06 dbs: point 2008-12-19T12:28:10 In 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 2008-12-19T12:29:44 gotta define a new domain in ejabberd.cfg 2008-12-19T12:29:57 *** _dkyle_ has left #openils-evergreen 2008-12-19T12:33:43 ...and register users with the domain 2008-12-19T12:34:34 we really need to make the default opensrf_core.xml file for both osrf/eg use multidomain by default 2008-12-19T12:34:35 * dbs can't wait for the install & configure mess 2008-12-19T12:34:41 yeah 2008-12-19T12:34:43 berick: yeah 2008-12-19T12:34:45 my concern as well 2008-12-19T12:45:45 *** rsinger has quit IRC 2008-12-19T13:28:45 dbs: your change to mozilla.js setting the intl.accept_languages pref, you want that in 1.4? 2008-12-19T13:29:16 ooh, yeah 2008-12-19T13:29:26 I'll get it 2008-12-19T13:29:44 just doing a dirdiff on trunk vs rel_1_4, walking through everything 2008-12-19T13:30:34 okay, so you have i18n'ized some things we missed in trunk.. did we call a string freeze already? 2008-12-19T13:31:00 we did, but where necessary I'm willing to bend that rule a bit 2008-12-19T13:31:28 especially as this is the first time around 2008-12-19T13:32:04 oh pooh, there's unrelated changes in one of these files.. I'll have to hand-stitch :) 2008-12-19T13:34:10 I'll backport css changes too.. no harm there 2008-12-19T13:35:16 on second thought, nah.. css for a feature only in trunk 2008-12-19T13:36:27 phasefx_: hand stitching shouldn't be necessary if we merge changesets 2008-12-19T13:36:57 I don't really have experience doing that 2008-12-19T13:38:13 hard 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? 2008-12-19T13:38:40 the only util.network stuff I see is i18n-related, that sound right? 2008-12-19T13:39:21 I have no preference for whether that gets backported or not 2008-12-19T13:40:17 didn't that i18n stuff come from your operator change auth checks? or did that already go into 1.4? 2008-12-19T13:40:58 I'm not sure what you're talking about 2008-12-19T13:41:09 heh 2008-12-19T13:41:49 the only things I remember dealing with auth are the session cookies stuff, and a verify credentials function, which should stay trunk I think 2008-12-19T13:42:37 http://svn.open-ils.org/trac/ILS/changeset/11388/trunk/Open-ILS/xul/staff_client/chrome/content/util/network.js 2008-12-19T13:42:41 right, session cookies 2008-12-19T13:43:06 Didn't we want those to solve a problem with conify / vandelay? 2008-12-19T13:43:09 phasefx_: cookies in 1.4 are needed 2008-12-19T13:43:15 yeah 2008-12-19T13:43:16 k, will backport those then 2008-12-19T13:43:30 phasefx_: thanks! 2008-12-19T13:44:04 I think that was all contained in one changeset, if someone wants to teach me how to do that by merging changesets 2008-12-19T13:44:33 * phasefx_ double-checks 2008-12-19T13:44:33 cd rel_1_4; svn merge -c svn://svn.open-ils.org/trunk . 2008-12-19T13:44:35 svn merge -c changeset# svn://svn.open-ils.org/ILS/trunk 2008-12-19T13:44:43 jinx 2008-12-19T13:44:44 jinx 2008-12-19T13:44:47 aaaaaaaaa;skoldjasd;lfkj 2008-12-19T13:44:48 double jinx! 2008-12-19T13:44:56 and then I get to review it and commit? 2008-12-19T13:45:04 yeah, it just changes your local copy 2008-12-19T13:45:08 coool 2008-12-19T13:45:19 multiple changesets 2008-12-19T13:45:24 *** Dyrcona has quit IRC 2008-12-19T13:45:59 one changeest 2008-12-19T13:46:01 for ranges: svn merge -rstart_changeset_minus_1:last_changset 2008-12-19T13:46:31 IOW, to merge changes 123 and 124 ... svn merge -r 122:124 svn://... 2008-12-19T13:46:45 k 2008-12-19T13:46:50 thanks guys 2008-12-19T13:50:14 * dbs regrets picking "desktop system" in this new debian etch vbox image setup... dollars to doughnuts I won't need xsane to test out opensrf 2008-12-19T13:50:34 :D 2008-12-19T13:50:45 haha 2008-12-19T13:51:09 dbs++ # particularly for using my favorite "I'll bet you" variant 2008-12-19T13:55:50 *** till_ has quit IRC 2008-12-19T13:57:40 *** robbat2|na is now known as robbat2 2008-12-19T14:13:38 * jeff bashes head on desk 2008-12-19T14:16:11 berick: where's that animation of yours? 2008-12-19T14:18:09 http://dev.gapines.org/~erickson/computer.gif 2008-12-19T14:18:27 jeff: ^^ 2008-12-19T14:18:30 and that is the exact animation i figured it would be :) 2008-12-19T14:18:30 berick++ 2008-12-19T14:18:36 haha 2008-12-19T14:18:57 if we can get a license for it, could use that instead of EG's skull & crossbones :) 2008-12-19T14:19:35 either i'm finding bugs in the reporter, or i'm not understanding how i'm supposed to do this. 2008-12-19T14:19:49 i'm trying to report on desk payments by billing type 2008-12-19T14:21:13 if 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. 2008-12-19T14:22:04 (where "incredibly high number" is "hundreds more than expected") 2008-12-19T14:23:18 the 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 2008-12-19T14:25:21 but yeah. computer.gif all the way. 2008-12-19T14:26:52 what's your base source? 2008-12-19T14:29:34 payments: desk 2008-12-19T14:31:24 outputs are payment type, amount, and billable transaction -> billing line items -> billing type 2008-12-19T14:32:22 and you have two versions of that, one with sum and one with raw 2008-12-19T14:32:49 base 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) 2008-12-19T14:33:35 jeff 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) 2008-12-19T14:34:21 if 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 2008-12-19T14:34:30 (i take the details report and sum it in excel) 2008-12-19T14:34:49 kgs: i can e-mail you (or anyone else) screenshots 2008-12-19T14:35:01 we need a pastebin with image support ;) 2008-12-19T14:35:12 eh, I just need five minutes to replicate the template, methinks :) 2008-12-19T14:35:26 jeff we could webinar live any time you like that I'm aailable 2008-12-19T14:36:09 let 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. :) 2008-12-19T14:37:04 jeff: try it without the billable transaction -> billing ine items -> billing type part 2008-12-19T14:37:15 phasefx_: willtry. 2008-12-19T14:38:27 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 2008-12-19T14:39:18 *** till_ has joined #OpenILS-Evergreen 2008-12-19T14:39:26 with just Amount (Raw or Sum) as the display, and Accepting user as the filter 2008-12-19T14:40:00 okay, 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. 2008-12-19T14:40:08 so... why does it break? 2008-12-19T14:40:59 * jeff tries the detail report after removing billing type also 2008-12-19T14:42:11 when you do billing line items, the relationship isn't 1 to 1 2008-12-19T14:42:13 jeff I'll play with this anyway... 2008-12-19T14:42:46 so you might have Payment A be associated with Billing 1 and Billing 2 (by virtue of being on the same transaction) 2008-12-19T14:42:48 phasefx_: so it's multiplying overdue fines. 2008-12-19T14:43:04 and then Payment B, may also be on the same transaction, and duplicate the output for Billing 1 and Billing 2 2008-12-19T14:43:20 and not only that.. the Amount for Payment A will show up twice (once for each of those billings) 2008-12-19T14:43:28 and the same with Payment B 2008-12-19T14:43:31 okay, 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 2008-12-19T14:45:15 jeff: you might be able to use one of those summary views.. report on the billable transaction as your source, not the payments 2008-12-19T14:45:23 then link to the payments and sum those 2008-12-19T14:48:10 first 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 2008-12-19T14:48:45 so i think that means i'll need one report for each payment type. 2008-12-19T14:48:53 testing, though. 2008-12-19T14:49:47 * jeff finds another reporter UI bug 2008-12-19T14:49:48 heh 2008-12-19T14:52:38 *** rsinger has joined #OpenILS-Evergreen 2008-12-19T15:00:20 nope. 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) 2008-12-19T15:00:33 bleh. 2008-12-19T15:00:50 you're still trying to get the billing type? 2008-12-19T15:00:54 well, 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. 2008-12-19T15:01:16 phasefx_: yes, i was still trying to get the billing type. 2008-12-19T15:01:24 you can't really associate payments with bills in any manner other than to say that happened on the same transaction 2008-12-19T15:02:11 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 2008-12-19T15:02:14 so 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? 2008-12-19T15:03:01 if 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? 2008-12-19T15:03:07 i haven't tried, really. 2008-12-19T15:03:19 if you have 3 billable transactions 2008-12-19T15:03:39 but if you have 3 billings on 1 billable transaction, then you have some ambiguity if you try to stick payments to something specific 2008-12-19T15:04:40 because billable transactions can contain multiple billing line items, and billing line items can have different billing types within one billable transaction? 2008-12-19T15:04:51 right 2008-12-19T15:05:28 some of these summary views might show you the last billing type, for the transaction 2008-12-19T15:05:40 know of any offhand? 2008-12-19T15:06:13 no, I haven't really played around with them. Do you see any source with the word open transactions or something in them? 2008-12-19T15:06:43 and I imagine you're wanting to report on closed transactions too 2008-12-19T15:07:00 *** wlayton_work has quit IRC 2008-12-19T15:07:32 i'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. 2008-12-19T15:08:43 cash include checks and the like? 2008-12-19T15:08:58 yeah, "desk payments" 2008-12-19T15:09:24 i was doing a pivot on payment type with my source set to payments: desk 2008-12-19T15:09:31 so i was getting one column with cash and one with checks 2008-12-19T15:09:42 (we're not yet doing in-person credit cards, but soon) 2008-12-19T15:10:06 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 2008-12-19T15:10:24 huh, next Debian will be Squeeze :) 2008-12-19T15:12:11 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 2008-12-19T15:12:39 just knowing when a billing line item was paid would help, but i can see how that is a challenge, too. 2008-12-19T15:12:45 ugh. 2008-12-19T15:13:07 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. 2008-12-19T15:14:03 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? 2008-12-19T15:14:29 a uber category of late + lost doesn't help us any. 2008-12-19T15:14:52 because i'd still need to know how much was "late", and how much was "lost". 2008-12-19T15:16:39 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 2008-12-19T15:16:48 You know exactly how much money went to Lost and how much went to Late, but you can't tell the payment method 2008-12-19T15:17:30 just need to work out some arbitrary resolution and be consistent with it forever after 2008-12-19T15:17:52 that 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) 2008-12-19T15:28:43 I 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 2008-12-19T15:33:06 *** Dyrcona has joined #openils-evergreen 2008-12-19T15:47:16 "circulate as type" in the copy editor... is that to override the type in the MARC leader, and is it mainly for stats purposes? 2008-12-19T15:48:58 it's used for circulation behavior, and would override any behavior based on the type in the MARC 2008-12-19T15:49:40 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 2008-12-19T15:53:09 got it. 2008-12-19T15:53:26 doesn't affect searching or display in the OPAC? 2008-12-19T15:54:14 probably no need to set it in most cases? 2008-12-19T15:55:15 wouldn't affect the OPAC, no 2008-12-19T15:55:41 just a knob you can use to base behavior on, and report on 2008-12-19T15:55:53 circ/hold behavior 2008-12-19T15:58:44 * miker_ returns to 2 hours of reporting "fun" 2008-12-19T15:59:00 if an item doesn't circ and is in a shelving/copy location with holdable no and circulate no, does it need a circ modifier? 2008-12-19T16:00:14 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) 2008-12-19T16:00:26 s/mean/meant 2008-12-19T16:00:50 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 2008-12-19T16:02:40 miker_: sounds promising... :) 2008-12-19T16:04:18 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) 2008-12-19T16:05:37 i have access to neither, so that's not too much of an improvement for me ;) 2008-12-19T16:06:33 ha 2008-12-19T16:08:04 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 2008-12-19T16:10:07 * dbs finally gets around to preparing to install osrf rel_1_0 on his new vboxes 2008-12-19T16:11:24 dbs++ 2008-12-19T16:12:27 a 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 2008-12-19T16:17:52 give her the camel book and tell her to with regexp's ;) 2008-12-19T16:22:47 *** jamesrf has joined #openils-evergreen 2008-12-19T16:27:28 dbs tell her there's a little project she can help daddy and kgs with... 2008-12-19T16:28:50 yikes, it's 12 F in toronto 2008-12-19T16:29:07 * berick is trying to get mentally prepared for ola ;) 2008-12-19T16:29:21 and 72F here 2008-12-19T16:30:05 miker_: 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 2008-12-19T16:30:16 (meaning either one i'd have to ask bott to do) 2008-12-19T16:31:02 hrm, 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 2008-12-19T16:31:49 dbs: if ti works, not at all :) 2008-12-19T16:32:15 just testing now 2008-12-19T16:36:32 *** rsinger has quit IRC 2008-12-19T16:38:56 dbs: I suspect it'll work fine ... nothing "new" in trunk, really 2008-12-19T16:40:32 right, but I'm a sort-of cautious type. 2008-12-19T16:42:29 measure twice, cut once 2008-12-19T16:43:02 measure? what's that? 2008-12-19T16:43:30 ;-) 2008-12-19T16:43:40 i think it's Greek 2008-12-19T16:46:27 i was thinking about that today, watching my cat prepare to jump up onto a counter 2008-12-19T16:48:59 cats do calculate 2008-12-19T16:49:12 bah - damn you, gcrypt 2008-12-19T16:51:15 going for my run before it gets dark, but am going to continue reading docbook 5.0 when I get back... 2008-12-19T16:54:31 man 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) 2008-12-19T16:56:50 *** rsinger has joined #OpenILS-Evergreen 2008-12-19T16:59:24 dbs: I haven't run into such a problem ... but then gcrypt likes me 2008-12-19T17:00:15 miker_: the problem of libgrcypt / libgdbm being relatively new dependencies for xml::libxslt? 2008-12-19T17:01:10 oh, I'm just saying random words at this point 2008-12-19T17:01:23 I mean, I haven't seen cpan stop working on me 2008-12-19T17:01:40 but I have no idea about gcrypt or the problems it causes 2008-12-19T17:01:58 i ran into that recently. something died and cpan would install nothing else 2008-12-19T17:02:01 gcrypt/gdbm problem was solved by adding the packages to the Makefile.install 2008-12-19T17:02:21 but if you went into the build dir, did you usual make/make test/make install it worked fine 2008-12-19T17:02:37 cpan 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 2008-12-19T17:02:42 right 2008-12-19T17:02:58 that was the workaround for zoom 2008-12-19T17:04:59 "Patron reported a vague phone message about her reserve at Woodmere" 2008-12-19T17:05:17 "Tech staff reported a vague trouble ticket"... :P 2008-12-19T17:06:41 heh 2008-12-19T17:06:47 at 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) 2008-12-19T17:06:59 "You may or may not have a reserve at some library you've been to. This is a recording." 2008-12-19T17:08:19 successful install on debian lenny (where success = no configure, make, or make install errors reported) 2008-12-19T17:08:20 "ESI vaguely fixed the glitch. It'll work itself out." 2008-12-19T17:08:30 WE FIXED THE GLITCH 2008-12-19T17:08:47 dbs: worksforme 2008-12-19T17:09:09 berick: did you want to get an openserf-generic example of multidomain in before 1.0.2? 2008-12-19T17:11:14 ah, yeah. actually, dbs offered to if I put on in Evergreen ;) 2008-12-19T17:11:22 but, i can copy that one over and modify 2008-12-19T17:11:30 bastard, I knew you would hold me to that :) 2008-12-19T17:11:33 hahaa 2008-12-19T17:11:41 no, just calling you out, that's all ;) 2008-12-19T17:11:43 I'm also fixing up the README 2008-12-19T17:11:54 I got it 2008-12-19T17:11:55 hrm. doesn't screen have a "save scrollback buffer to file"? 2008-12-19T17:12:02 Oh, I would do it. But it might not happen for many more hours. 2008-12-19T17:12:10 guess not. have to go into scroll, select, copy, then save paste buffer. 2008-12-19T17:12:20 jeff: it does, i've used it before 2008-12-19T17:13:16 jeff: -L maybe? 2008-12-19T17:14:32 yeah, 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 2008-12-19T17:14:57 ah 2008-12-19T17:14:58 ok 2008-12-19T17:15:01 not sure about that one 2008-12-19T17:16:03 C-a, Esc ... then copy and paste with a mouse? ;) 2008-12-19T17:16:22 you can page up and downs after C-a Esc 2008-12-19T17:17:03 C-a ESC g Space %100 > 2008-12-19T17:17:25 damn. the % doesn't seem to work 2008-12-19T17:17:49 aha. g and G 2008-12-19T17:18:13 C-a ESC g Space G > 2008-12-19T17:18:41 copies to /tmp/screen-exchange by default 2008-12-19T17:19:20 coool 2008-12-19T17:20:09 (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) 2008-12-19T17:21:35 * phasefx_ remembers a dos TSR called screen.. used it for cut & paste 2008-12-19T17:21:53 wish I had grown up on unix :) 2008-12-19T17:23:21 *** rsinger has quit IRC 2008-12-19T17:24:17 opensrf qbasic server ftw 2008-12-19T17:34:34 jamesrf: totally! I have visual basic for dos 3.5 right over there 2008-12-19T17:35:09 *** rsinger has joined #OpenILS-Evergreen 2008-12-19T17:36:26 success on debian-etch too 2008-12-19T17:36:46 (by my minimalist definition of success) 2008-12-19T17:38:52 *** rsinger has quit IRC 2008-12-19T17:39:36 dinner, biab 2008-12-19T17:53:19 ok, osrf config is now multi-domain 2008-12-19T18:45:05 *** kgs has quit IRC 2008-12-19T19:48:38 *** skmurphy has joined #openils-evergreen 2008-12-19T19:57:30 berick++ 2008-12-19T19:57:43 hey skmurphy 2008-12-19T19:58:09 I'm tempted to switch "localhost" to "private.localhost" for ease of documentation 2008-12-19T19:59:28 you know, that's what it was, but i thought it would just make it unnecessarily complex. i can see what you mean, though 2008-12-19T20:00:58 hey dbs 2008-12-19T20:01:07 hows it going? 2008-12-19T20:01:41 okay. feeling a bit better tonight. had some food 2008-12-19T20:02:22 it's very very snowy in your country 2008-12-19T20:04:05 hey, don't blanket me with your generalisms! it's just bitterly cold up here 2008-12-19T20:05:16 = 2008-12-19T20:05:19 =) 2008-12-19T20:08:07 berick: so we're really looking at registering four ejabberd users now: opensrf@public, opensrf@private, router@public, and router@private - yeah? 2008-12-19T20:23:19 *** skmurphy has quit IRC 2008-12-19T21:10:19 *** jamesrf has quit IRC 2008-12-19T21:22:13 * dbs apparently fell into a multi-domain minefield. argh. 2008-12-19T21:29:56 XMPP connect is failing for private.localhost, but seemingly working for public.localhost 2008-12-19T21:36:11 *** skmurphy has joined #openils-evergreen 2008-12-19T21:37:18 bizarre. it's pulling the wrong password for the router user. 2008-12-19T21:54:34 bah. I'm going to check in what I have anyways. Maybe you'll spot something horribly obvious in it. 2008-12-19T21:56:32 *** rsinger has joined #OpenILS-Evergreen 2008-12-19T22:08:44 oh, 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 2008-12-19T22:13:44 g'nite 2008-12-19T22:13:50 *** dbs has quit IRC 2008-12-19T23:15:24 *** rsinger has quit IRC