2012-03-25T00:00:38 *** enhancin has joined #evergreen 2012-03-25T00:05:18 I'm having a silly thing happen where if the username is numbers, it will treat it as a barcode even if no barcode like such exists. Since I'm not too familiar with the structure of the code...does anyone happen to know where those functions are that authenticate a user so I can make some slight changes? 2012-03-25T00:14:11 enhancin: there's an org setting that can affect that, I believe. opac.barcode_regex or somesuch? 2012-03-25T00:14:36 I see in the log where it says "CALL: open-ils.actor open-ils.actor.ou_setting.ancestor_default 1, opac.barcode_regex" 2012-03-25T00:14:40 so perhaps you're right 2012-03-25T00:15:02 if the input matches the regex, it gets treated as a barcode, otherwise, a username 2012-03-25T00:15:22 and I think that's done in the opac javascript, which determines how the auth call is made 2012-03-25T00:15:38 ahhh alright. Awesome, i'll do some testing 2012-03-25T00:16:03 * phasefx_ goes and plays some Tribes: Ascend :-) 2012-03-25T00:17:35 Oh boy...that looks like Halo but free and more fun. You've made my night. 2012-03-25T00:42:41 *** GayashanNA has joined #evergreen 2012-03-25T00:49:37 *** Neil____ has joined #evergreen 2012-03-25T00:51:19 *** Neil___ has quit IRC 2012-03-25T01:04:03 *** GayashanNA has quit IRC 2012-03-25T03:38:55 *** Zhee has joined #evergreen 2012-03-25T05:12:00 *** virendra_eg has joined #evergreen 2012-03-25T05:12:50 *** Rohit has joined #evergreen 2012-03-25T05:13:23 *** Rohit is now known as Guest63284 2012-03-25T05:23:45 *** Neil____ has quit IRC 2012-03-25T05:25:53 *** Neil___ has joined #evergreen 2012-03-25T05:26:42 *** Guest63284 has quit IRC 2012-03-25T05:28:21 *** Neil___ has quit IRC 2012-03-25T06:06:21 *** hopkinsju has quit IRC 2012-03-25T06:55:26 *** virendra_eg has quit IRC 2012-03-25T10:14:17 *** Neil___ has joined #evergreen 2012-03-25T10:31:09 *** hopkinsju has joined #evergreen 2012-03-25T10:58:48 *** hopkinsju has quit IRC 2012-03-25T11:03:17 *** Neil___ has quit IRC 2012-03-25T11:05:14 *** Neil___ has joined #evergreen 2012-03-25T11:27:07 *** Neil___ has quit IRC 2012-03-25T11:35:50 *** GayashanNA has joined #evergreen 2012-03-25T11:47:50 hm. So in the Admin -> Server Administration -> Booking -> Resource Types, is it possible to add a new field on there to log an identifying number for the resource? 2012-03-25T11:48:06 essentially logging the serial number I guess 2012-03-25T11:48:49 *** Neil___ has joined #evergreen 2012-03-25T11:51:26 *** Gaiz_ has joined #evergreen 2012-03-25T11:52:26 *** Gaiz_ has joined #evergreen 2012-03-25T11:53:42 *** Gaiz_ has quit IRC 2012-03-25T11:53:56 *** GayashanNA has quit IRC 2012-03-25T12:08:30 *** hopkinsju has joined #evergreen 2012-03-25T12:25:39 hi all 2012-03-25T12:25:53 *** Neil___ has quit IRC 2012-03-25T12:31:08 *** Gentlecat has quit IRC 2012-03-25T12:34:58 *** Neil___ has joined #evergreen 2012-03-25T13:05:49 enhancin: I have minimal experience with the booking stuff, but I think resource *types* aren't actual items and thus wouldn't have identifying numbers themselves. They are the categories the actual bookable items are grouped into? 2012-03-25T13:06:05 Zhee: You are allowed to say things other than "hi all" ;) 2012-03-25T13:06:38 tsbere: Wow thatks! At last 2012-03-25T13:06:52 I've been waiting for that for about a week:-) 2012-03-25T13:08:34 tsbere: unfortunately I'm not super familiar with it either...so i guess I'll be playing around to figure that out 2012-03-25T13:10:20 enhancin: Note that I believe there are, on top of resource types, two "kinds" of bookable resources. Regular assets (that exist on bibs and such) and things that aren't on bibs. Those that are on bibs have regular asset.copy entries and thus should be able to have stat cat entries to contain extra information? 2012-03-25T13:12:32 *** Neil___ has quit IRC 2012-03-25T13:13:05 *** wlayton has joined #evergreen 2012-03-25T13:14:35 *** Neil___ has joined #evergreen 2012-03-25T15:40:28 *** danielR has joined #evergreen 2012-03-25T15:51:22 tsbere: sorry had to go run errands. yeah, i see what needs to happen then. could you point me where I need to make changes to add a Serial Number field to the Resources? I think when they wrote the request they were just a little confused. 2012-03-25T15:52:31 I assume it's going to be some coding as well as database changes 2012-03-25T15:56:17 enhancin: Depending on how you are planning on using them you could just use the barcode to store that, if that is the unique identifier for the items. 2012-03-25T16:01:18 enhancin: Looks like you can also give resource types "attributes"? Not sure how those are supposed to work. 2012-03-25T16:01:39 Looks like you have to provide a pre-made list of those, though. 2012-03-25T16:01:49 Like asset.copy stat cat entries 2012-03-25T16:01:52 Ah...hm...oh I could just add a serial number attribute...let me play around with that 2012-03-25T16:01:56 yeah that's fine 2012-03-25T16:02:09 we already have all the resource types in there so it'd be quick 2012-03-25T16:02:48 enhancin: You misunderstand. You would have to add the serial numbers as valid values for the attribute *first*, then you could link them to resources. 2012-03-25T16:03:06 Ohhh okay. 2012-03-25T16:03:22 Which seems somewhat wasteful for something that should be unique to any given item. <_< 2012-03-25T16:03:36 So not as useful-sounding for serial numbers 2012-03-25T16:04:45 yeah....I'm just a comptuer guy so nothing they want ever makes sense to me. the big thing is they want serial numbers as well...but i'm going to talk with them about putting that in the barcodes instead anf see if that would be an easier alternative. sounds much more efficient to me. 2012-03-25T16:04:50 enhancin: If you want something like that other than the barcode field then I would go with one of two methods. 1 - Modify the resource attributes to allow plaintext as an option (perhaps dictated by a flag on the attribute?) or 2 - Add a new column to the resource table. 2012-03-25T16:05:31 Would simply adding a column cause it to read the table correctly and display it for modifications? I would thinkt here would be some perl file or something I needed to change...the menus or something 2012-03-25T16:05:52 That....will depend on what interfaces you are dealing with. 2012-03-25T16:06:07 * tsbere hasn't figured out where all the booking stuff lives interface wise 2012-03-25T16:06:43 At a minimum you need to add your new column to the IDL. Some interfaces will then pick it up automatically. Others will ignore it unless modified. 2012-03-25T16:07:05 The staff client should be able to pick it up automatically? that's what we're using 2012-03-25T16:07:14 mostly because it's already developed really well for this. 2012-03-25T16:08:43 enhancin: Even in the staff client different things use different interfaces. Some can pick things up automatically, some can't. It depends partially on how they are coded. For example, I don't believe the copy editor is capable of picking up new columns without being told about them, but some of the admin interfaces show all columns unless told otherwise. 2012-03-25T16:09:13 Oh okay, I found in fm_IDL.xml where to add in the fields so I'll try doing that and adding the column in the same motion so it doesn't get confused. 2012-03-25T16:10:01 You should also note that even if the column is there it may not do anything useful. 2012-03-25T16:11:02 Outside of some configuration interfaces and maybe some column picker scenarios code *will* need to be changed to make anything actually care about the new column 2012-03-25T16:12:16 Yeah, unfortunately I'm not even sure where to start in the code...one of the biggest things that keeps me from developing on open source software is the sheer size of the code I have to familiarize myself with... 2012-03-25T16:12:50 In this case I would call step 1 "figure out what they actually need, not what they claim they want" 2012-03-25T16:13:28 Do they just need to keep track of the number? Do they need to search on it? Do they need the system to be aware of it, or do they only care that the system stores it in case they ever have to go looking? 2012-03-25T16:14:18 If they want the serial number to be what they look the items up by then I would tell them that they should use that as the barcode. If they have some other number, like an actual barcode, to look them up by and just need the serial number for reporting or tracking purposes, and nothing day to day, then the new column may work. 2012-03-25T16:14:55 If they can't answer any of that, ask them for use cases and figure it out yourself ;) 2012-03-25T16:17:05 enhancin: For example, if they want to be able to look things up by the serial number *and* an actual barcode then you likely need a "secondary identifier" column. If done that way (don't call it serial number in that case) and coded properly you can then submit it to the community so that you don't have to keep it working alone later ;) 2012-03-25T16:17:59 Right, I always plan to submit any changes I make to the community if they seem like someone else could possibly make use of it. I have a few scripts I need to finish up that help with migration that I want to submit. I'll converse with them and figure it out 2012-03-25T16:35:42 *** Khobaib has joined #evergreen 2012-03-25T16:46:48 *** Neil____ has joined #evergreen 2012-03-25T16:47:57 *** Neil___ has quit IRC 2012-03-25T16:56:08 *** Neil____ has quit IRC 2012-03-25T17:02:12 *** Neil___ has joined #evergreen 2012-03-25T17:20:52 *** danielR has quit IRC 2012-03-25T17:33:15 *** thethomaseffect has quit IRC 2012-03-25T17:39:09 *** thethomaseffect has joined #evergreen 2012-03-25T18:32:01 Sorry for bringing so much today, but for some reason we have electronic resources that show up even when we search in libraries that they don't belong to. In fact, they don't really have any "volumes" or "items" in any of the libraries so they are showing up when we search anywhere 2012-03-25T18:35:07 *** Zhee has quit IRC 2012-03-25T18:40:15 enhancin: Transcendant bib sources do that. Possibly bibs with certain URI entries, haven't dug deeply into that. 2012-03-25T18:40:56 I guess I'm just confused on how resources actually work..gonna go read docs 2012-03-25T18:45:26 *** enhancin has quit IRC 2012-03-25T18:50:55 @later tell denials Not sure if it's just a quirk with our system, but it didn't like applying 0690, complained that it thought I should drop function evergreen.rank_ou before it let me proceed. Will investigate and perhaps try again on a clean system that didn't have former unapi test attempts lurking. 2012-03-25T18:50:55 bshum: The operation succeeded. 2012-03-25T18:56:00 anyone got a sec 2012-03-25T18:56:06 to help me rebut some FUD? 2012-03-25T18:56:18 theres about 280ish libraries in PINES eh? 2012-03-25T18:56:28 approx how many volumes? 2012-03-25T18:57:03 some egg here is saying theres no opensource ILS that could handle auckland (which is 1.5 mill volumes 500k transactions) 2012-03-25T18:59:45 rangi: I think there are multiple groups that can attest to that being bunk. I think there are multiple groups with 1.5+ mil bibs, with averages well over 3 volumes/copies per bib, running Evergreen. 2012-03-25T19:00:25 yeah 2012-03-25T19:00:30 cool 2012-03-25T19:00:38 MVLC has 3,215,087 call numbers, for example. 2012-03-25T19:00:53 i know there are koha libraries bigger than it, so im sure there are evergreen ones even bigger too 2012-03-25T19:01:05 cool thanks 2012-03-25T19:01:08 Looks like MVLC is running 3,243,465 copies too. 2012-03-25T19:01:35 And MVLC is a *smaller* consortia, when compared to others. 2012-03-25T19:01:41 maybe ill do a blog post, Open Source ILSes - They are much bigger than you think 2012-03-25T19:01:55 and just fill it with stats 2012-03-25T19:02:43 rangi: Well only have 35 libraries and we hit 3+ mil volumes/copies, so yea. Anyone claiming Evergreen can't handle a paltry 1.5 mil should be laughed at. 2012-03-25T19:03:37 perfect 2012-03-25T19:07:10 *** enhancin has joined #evergreen 2012-03-25T19:07:13 now I'm really confused because when I go to the library and search for the resources they don't show up in the library anywhere. I also can't find any docs about it really so i'm having a hard time figuring out how to fix this 2012-03-25T19:07:50 enhancin: Staff client searches show (and should highlight) bibs without copies regardless of scope, intentionally. 2012-03-25T19:08:38 Yeah, unfortunately that's not showing them either...and i'm not sure how to check if it's been set up correctly 2012-03-25T19:08:49 i tried to look through the org units and org unit types but didn't find much 2012-03-25T19:09:51 enhancin: When you say resources are you talking "electronic resources" by bib type, or booking resources? 2012-03-25T19:10:30 booking resources are what we want to show up. it's showing "electronic resources" because those are in the normal library 2012-03-25T19:10:53 In that case they will only show up if they are tied to an actual bib, compared to only existing in the booking module 2012-03-25T19:11:22 they are owned by a lib i think...the Equipment one we have made 2012-03-25T19:11:24 Things that you would keep in the booking module only would include, say, meeting rooms, I believe. Stuff that you want to track but don't want to search. 2012-03-25T19:12:07 enhancin: It sounds like you created booking resources that were *not* tied to bibs. If you want them searchable in the staff client or OPAC you need to make bibs, attach copies, then flag the copies as bookable. 2012-03-25T19:31:36 I guess I'm not fulling understanding it. I changed the owning library to the library that is being searched (they were set to the parent of what was being searched) and it didn't really changed anything at all...so I can't really pull it up in OPAC. and I can't find documentation on how it's supposed to be...man..i feel really silly 2012-03-25T19:34:27 enhancin: Beyond resource types there are two major types of booking resources: Those that are *only* booking resources, and those that are also copies on bibs. 2012-03-25T19:34:43 enhancin: Only the *latter* kind show up in the catalog. The former kind don't show up in searches. 2012-03-25T19:35:10 Wait..alright, i confused myself. I was mis-defining bibs in my head 2012-03-25T19:35:14 To get the former ones I think you have to use the booking specific resource list. Or a booking specific interface of some kind. 2012-03-25T19:35:19 bibliographic records, just like te books have. 2012-03-25T19:35:31 for some reason...i don't think I got enough sleep 2012-03-25T19:35:48 enhancin: Not only just like books, you can make books into booking resources. 2012-03-25T19:37:01 Hmm. okay. I should be able to figure it out from here...then hopefully after that I can finish adding the serail numbers and tomorrow submit the code to youg uys 2012-03-25T19:37:47 enhancin: I still recommend calling the field something like "secondary idenfier" or similar. Not everything will have serial numbers ;) 2012-03-25T19:38:31 ah, yeah. i'll try to remember that by writing it down here..... Even if I do forgot I'm sure it will come up again in community discussion. 2012-03-25T20:08:39 *** wlayton has quit IRC 2012-03-25T20:29:28 tsbere: you're going to be glad when I log off. I can't find an updated schema documentation for the biblio.record_entry, the only one I can find it from 1.6....is there plans to do another one of these sometime? http://open-ils.org/documentation/evergreen-schema-1.6.0.1.html 2012-03-25T20:29:50 but does the "owner" field dictate which library owns it, or is it an actor.usr that owns it? 2012-03-25T20:30:01 enhancin: I have no clue about those. I just read the SQL. :P 2012-03-25T20:31:05 enhancin: Looks like "owner" is pretty much universally an org unit in the booking area, though. 2012-03-25T20:31:18 yeah, i found the key constraint...yeah 2012-03-25T20:31:22 it looksl ike it's actor.org_unit 2012-03-25T20:31:24 sweet 2012-03-25T20:52:39 *** Gentlecat has joined #evergreen 2012-03-25T20:52:58 Hm, when updating the biblio.record_entry it's claiming an oils_xpath(text, text, text[]) doesn't exist on line 6....when I do it through phppgadmin it doesn't error out...hm 2012-03-25T20:53:41 enhancin: Seems like you aren't getting search path in all places? 2012-03-25T21:43:15 *** hopkinsju has joined #evergreen 2012-03-25T22:41:57 Anyone aware of a parallel postgresql query runner, or should I just separate it by id ranges and run them some concurrency at a time 2012-03-25T22:42:21 Or is postgresql faster if I just run a single query over the whole range 2012-03-25T23:01:56 *** finnx has quit IRC 2012-03-25T23:15:08 *** mtcarlson has joined #evergreen 2012-03-25T23:19:48 *** mtcarlson_ has joined #evergreen 2012-03-25T23:21:25 *** mtcarlson has quit IRC