Evergreen ILS Website

IRC log for #evergreen, 2014-04-23

| Channels | #evergreen index | Today | | Search | Google Search | Plain-Text | summary | Join Webchat

All times shown according to the server's local time.

Time Nick Message
00:43 zerick joined #evergreen
01:52 gmcharlt eeevil: dbwells: the patch for bug 1311467 should probably get eyes on it soon
01:52 pinesol_green Launchpad bug 1311467 in Evergreen "validate headings broken in 2.6.0" (affected: 1, heat: 6) [High,New] https://launchpad.net/bugs/1311467
01:58 gmcharlt @later tell yboston I've increased the upload limit again
01:58 pinesol_green gmcharlt: The operation succeeded.
06:54 timf joined #evergreen
07:44 jboyer_isl joined #evergreen
07:51 eeevil gmcharlt: looking now
07:53 collum joined #evergreen
08:02 jboyer-isl joined #evergreen
08:06 akilsdonk joined #evergreen
08:09 gmcharlt eeevil: thanks
08:12 mdriscoll joined #evergreen
08:14 George_Frideric joined #evergreen
08:21 ericar joined #evergreen
08:27 jboyer-isl Floating Point + Math = sucks.
08:35 Dyrcona joined #evergreen
08:44 mmorgan joined #evergreen
08:48 jl- morning
08:50 dbwells jboyer-isl: I think you mean " = sucks.0000000000000004"
08:50 jboyer-isl dbwells++
08:51 jboyer-isl Or suckr, because I'm usually off by one. (too much int($float * 100)...)
08:51 RoganH joined #evergreen
08:55 jl- I want to enable the  opac.located_uri.act_as_copy global flag
08:55 jl- would this be sufficient for a located URI (see Marc Record at bottom)
08:56 jl- 856.‡9SHIP
08:57 RoganH I'm assuming SHIP is an org unit name for you?  You'll want the URI and maybe a display subfield too.  $u and $z
08:57 jl- RoganH: it is an org unit
08:58 jl- $u seems to be a link which I dont want
08:58 jl- I want just the record
08:58 jl- and $y would be link text
08:58 jl- which I also don't want / need since I'll be batch adding 856 9 SHIP
08:58 jl- is this feasible?
08:58 eeevil jl-: it doesn't work like that
08:59 jl- hmm
08:59 eeevil jl-: located URIs are for URIs. if you don't want a link, you need to attach a copy to the record
08:59 RoganH jl-: are you trying to restrict what orgs the bib shows up to?
08:59 jl- eeevil: the dilemma is, I really want scope search for demonstration purpose.. and migrating the copies from the previous ILS.. would be overkill for me with my resources.
09:00 jl- if I could batch add generic copies that would be fine
09:00 jl- RoganH: yes
09:00 jl- you can see my dev install
09:00 RoganH jl-: eeevil was ahead of me on my response to that :)
09:00 RoganH jl-: you can batch add copies via sql inserts, especially if you don't care about call numbers being random :)
09:01 jl- see "KLN > Shippensburg University" for units, next will be Lincoln University
09:01 dbwells jl-: I guess what you are trying might work strictly for fake, demo purposes.
09:01 jl- ah, the master of SQL is speaking ;)
09:01 jl- dbwells: that would be nice
09:01 dbwells jl-: You'll probably need a placeholder URI in there, though.
09:02 jl- ok so I have no problem doing that for my current bibs
09:02 jl- they are all ship bibs
09:02 dbwells jl-: Also, I think you need certain indicators to have it picked up as a located URI.  4|0 or 4|1  (OTTOMH)
09:02 RoganH [off topic] Occasionally I think about adding fake books that should exist just to see if anyone would put a hold on them like "The Love Life of the Polar Walrus".
09:03 jl- rofl!
09:03 jl- dbwells: I thought if I have copies, I won't need located URI?
09:03 jl- because scope search will look for the copies?
09:04 RoganH jl-: yeah, restrict your scope by org unit and only copies at those orgs will show up
09:04 dbwells jl-: Yes, you only need one or the other.
09:04 dbwells I thought we were talking about adding fake URIs vs adding fake copies.
09:04 RoganH jl-: dbwells is right, you probably can get the URI way to work but without copies things will still be off and not give an accurate impression even for a demo
09:05 RoganH jl-: just my 0.02 dinars
09:05 jl- I think if I can use SQL for fake copies that might be fine
09:06 jl- I'm ok with random barcodes
09:06 jl- (instead of located uri's)
09:07 dbwells I'd say that's the better route.  Certainly a less fake fake.
09:07 jl- cool
09:08 eeevil dbwells / gmcharlt: 2d65580268 looks good to me. signing off. dbwells, I can push if you like
09:09 dbwells eeevil: please do, thanks
09:09 kbeswick joined #evergreen
09:10 jl- so RoganH, what would the SQL look like? :) would this go into asset.copy?
09:11 dbwells jl-: for quick creation of fake assets, I'd check out the stuff in the "Concerto" test set.
09:11 RoganH jl-: I'm not sure what data you're working off of.  the concerto stuff would be a good jumping off point.
09:11 dbwells jl-: specifically, the functions in Open-ILS/tests/datasets/sql/env_create.sql and their use in Open-ILS/tests/datasets/sql/assets_concerto.sql
09:11 RoganH jl-: basically you need entires in asset.call_number that reference bib records
09:12 RoganH jl-: then entries in asset.copy that reference the call numbers
09:12 eeevil dbwells: done, sir
09:12 dluch joined #evergreen
09:14 pinesol_green [evergreen|Galen Charlton] LP#1311467: fix heading validation in bib editor - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=3665b7c>
09:15 RoganH left #evergreen
09:15 RoganH joined #evergreen
09:27 jl- RoganH: I did use the concerto_loader but I attached my bibs to it and copied out assets part
09:27 jl- load_concerto
09:27 jl- copied out = commented out
09:29 bshum General question, now that 2.6.0 is on the downloads page, shouldn't we remove 2.3 series from there since it's past it's 3 months security fix time period and eventually when we add 2.4.7, change 2.4's status to security updates only?
09:31 csharp bshum: I think that's the right approach
09:34 RoganH jl-: That's a good start.  So you have your bibs but no call numbers or assets yet, right?
09:35 jl- RoganH: correct
09:36 yboston joined #evergreen
09:37 RoganH jl- : :)
09:38 RoganH jl-: you have a few options, one would be to modify the concerto asset sql, downside being that it's really oriented towards that data set and might take a lot of modification since you want your records there
09:39 RoganH jl-: I would lean towards grabbing random bibs by ID and creating call numbers for each org to whatever limit you want using something (author's name?) as the call number label
09:39 RoganH jl-: then auto creating copies for each of those with random barcodes
09:39 * bshum changed the status of 2.4 to security updates only anyways.  Since basically that's where we are already.
09:40 RoganH jl-: you could get fancier with distinguishing fiction and non-fiction, doing dewey ranges if you want to spend that time as well
09:42 RoganH jl- : assets_concerto.sql will give some great code for working off of so you don't have to reinvent the wheel
09:42 jl- RoganH: I don't need anything fancy, at all
09:42 jl- just functional
09:43 RoganH jl-: it'll get you close enough that it'll look real, things like call numbers will be wonky but that's easy to explain off
09:44 * bshum is also updating all the other places, Windows Staff Clients (for 2.5 and 2.4) and the Code Museum since he's poking anyways.
09:44 jl- max(id) 628807
09:44 jl- so all of those need copies
09:44 jl- some of those are authorities tho
09:45 jl- we don't want those authorities to get copies right?
09:45 RoganH jl- : no.  but you can make another table to work off of, do a create table as select non authories non-deleted (though none of yours are probably deleted yet)
09:45 jl- nvm
09:45 jl- authority.record_entry
09:46 RoganH jl- : yeah, I'd just use biblio.record_entry
09:47 ericar joined #evergreen
09:50 jl- RoganH: right off the bat, which lines can I take out of assets_concerto
09:50 jl- I need to strip it down first
09:52 RoganH jl- : If you're going for a big bulk insert of semi random items you'll probably just want to cherry pick out of it the code you want to use
09:52 RoganH jl- : it's more of a crafted realistic (but small) sample set
09:53 RoganH [off topic] I still think an alternative sample data set for the Miskatonic Consortium would be fun.
09:54 jl- RoganH: http://collabedit.com/vsc4w
09:54 jl- do I need to create call numbers?
09:56 RoganH jl- : yep, think of the chain as bibs -> call numbers -> copies
09:58 mrpeters joined #evergreen
10:00 * bshum reminds jl- of http://ur1.ca/h4zj2 and how copies are organized
10:00 jl- thanks
10:00 bshum RoganH++
10:04 yboston bshum: who created that google doc explaining copies / call nums?
10:04 bshum yboston: I did
10:05 bshum Earlier this week
10:05 yboston bshum: I like it, we should added to the offical docs
10:05 bshum I've been thinking about where we could stick something like it in the core
10:05 yboston s/added/add it/
10:05 yboston I'll think about ti too if it helps
10:05 bshum Could probably enhance it further, but as a starting point, I was just trying to get the point across about how information hangs together.
10:05 yboston very well done
10:06 yboston learned about asset.uri
10:06 bshum eeevil: gmcharlt: Does the most recent changeset 3665b7c need to be backported to the rel_2_6 branch too?
10:06 pinesol_green [evergreen|Galen Charlton] LP#1311467: fix heading validation in bib editor - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=3665b7c>
10:06 mmorgan bshum++
10:06 montgoc1 joined #evergreen
10:07 eeevil bshum: it was
10:07 bshum Oh duh
10:07 bshum I see what I did wrong now
10:07 bshum The top commit in rel_2_6 wasn't the same because it was a docs change
10:07 bshum Nevermind I see it now
10:07 eeevil cool
10:08 denishpatel joined #evergreen
10:21 ldwhalen joined #evergreen
10:22 pinesol_green [evergreen|Thomas Berezansky] LP#1310283: Propogate .staff through Z3950 searches - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=f6bb791>
10:29 jl- does each copy have to have a unique call nr?
10:31 Dyrcona jl-: No, but call number labels have to be unique per org. unit.
10:31 Dyrcona jl-: More than 1 copy can use the same call number.
10:31 Dyrcona In database terms it is a one to many relationship from call number to copy.
10:31 jl- with org unit you mean owning_lib ?
10:31 Dyrcona Yes.
10:32 jl- what table stores owning_lib ?
10:32 Dyrcona owning_lib refers to actor.org_unit.id
10:33 Dyrcona If you do \d asset.call_number in psql, you can get all the information about the table and its foreign key relationships.
10:34 jl- got it
10:35 kmlussier joined #evergreen
10:37 jl- Dyrcona: I'm trying to create fake copies for all existing bibs with SQL for library scope search demonstration since I dont want to migrate real copies for now -- what do you mean with call number labels have to be unique per org.?
10:38 jl- look here http://collabedit.com/vsc4w is the Call Number Label 'Import Concerto'?
10:38 Bmagic At the Evergreen conference there was a mention of redesigning the UI for reporting. Im having trouble finding documentation on this via open-ils.org
10:38 Dyrcona asset.call_number.label has a unique index per asset.call_number.owning_lib.
10:39 Dyrcona Bmagic: PINES has contracted Emerald Data to work on that AFAIK.
10:39 Bmagic Ah
10:40 Dyrcona jl-: That means if you have two copies with a call number of 324.56 JUL at Branch 1, then you can only have 1 asset.call_number entry, and both copies refer to the same call_number.
10:43 jl- right
10:44 Dyrcona jl-: In your example the label is the second parameter of the evergreen.populate_call_number functions.
10:44 Dyrcona asset.call_number.label is the call number that gets displayed, the prefix and suffix, if any will be added to it.
10:45 jl- what are the other parameters in there?
10:45 Dyrcona Not sure. I've never used the function.
10:46 RoganH left #evergreen
10:46 jl- I wish there was a generate_fake_copies.pl
10:46 kmlussier Bmagic: There were some wireframes for that project floating around at some point. But I think they may be a couple of years old.
10:47 Dyrcona jl-: I've heard of such scripts floating around. It would not be so difficult to write one.
10:47 Dyrcona jl-: You should try looking in some of the lesser known repos out there. You might find something.
10:51 kmlussier Bmagic: http://evergreen-ils.org/dokuwiki/doku.ph​p?id=evergreen-reports:reports_wireframes
10:52 Bmagic kmlussier++ #thanks for digging out that link
10:52 jl- Dyrcona: let me know if you can find something
10:52 jl- I haven't been able to
10:53 Dyrcona jl-: I'm not doing your homework. :)
10:53 jl- right
10:53 jl- not asking for that either
10:53 jl- :)
10:54 Dyrcona left #evergreen
10:54 jl- would be useful for demo purposes tho
10:54 Dyrcona joined #evergreen
10:55 csharp Bmagic: the alternative reports creator UI is under development now - I don't have a lot of details, nor do I have an ETA, but I"m happy to answer/redirect any questions
10:55 * Dyrcona grumbles something about "tap to click...."
10:55 Dyrcona jl-: It turns out, we have a copy of the old ILS-Contrib repo.
10:55 remingtron akilsdonk: ericar: I'm getting 404 errors on old ESI docs pages, where should I be looking?
10:55 * csharp likes tap to click (except when he doesn't)
10:55 remingtron Example: http://esilibrary.com/docs/asciidoc/2.5_D​efault_Values_Vandelay_Item_Import_doc/2.​5_Default_Values_Vandelay_Item_Import.txt
10:56 Dyrcona jl-: Have a look at this: http://git.mvlcstaff.org/?p=Evergreen/ILS-Contri​b.git;a=tree;f=import_demo/trunk;h=32ba80abf9363​c86de5533083a2e0e9f38714a66;hb=refs/heads/master
10:56 * bshum mumbles something about publishing development plans for community review early in case it'll matter to the next RM whether something will go in or not to the next release....
10:56 Bmagic csharp: I was just seeking general info. Some people in our consortium were curious
10:57 csharp sure thing - it will be a way to run pre-designed templates in a more polished interface (plus some new features)
10:57 jl- Dyrcona: looks interesting, sec
10:58 Bmagic csharp: but creation of the templates will be the same?
10:58 akilsdonk remingtron: we're working on getting our documentation up on the new ESI website.  All of the documentation that was posted on the old site is in the official docs and we've been adding new documentation to the official docs as well.  As soon as we get the new ESI docs page up, we will be adding all new documentation there and directly to the official docs repository.
10:59 csharp it will leverage the existing reports structure (i.e., clark kent, template/report/output)
10:59 remingtron akilsdonk: cool, thanks for the info
10:59 csharp templates will be pre-set (as far as the end user goes), but admin staff will be able to add templates
10:59 csharp (like EG system admin staff, not local library staff)
11:00 Bmagic csharp: Good info! Thanks again
11:00 csharp happy to help!
11:00 tspindler joined #evergreen
11:00 * csharp looks around for what bshum is mumbling about ;-)
11:21 bshum Random question
11:21 bshum Right now, we pull in Business::ISBN via CPAN
11:21 bshum is there any reason we can't use the packaged version like libbusiness-isbn-perl
11:22 bshum (since the version in Trusty is 2.0.7, same as CPAN, I think?)
11:22 bshum Or is this the sort of thing we're teasing out
11:22 bshum With testing and breaking
11:23 bshum Oh, nevermind I can see we already covered this with Wheezy
11:24 * bshum ponders some edits to the section of the README about standalone DB requirements
11:26 jeff bshum: you neverminded, but to the best of my knowledge, the only reason for bringing that in via CPAN was where it wasn't packaged by the distro in question.
11:27 bshum jeff: That makes good sense.  I guess that means we really ought to update the standalone DB portion of the README since it still uses CPAN and not packages that may exist.
11:27 bshum I'm setting up a new standalone DB and it suddenly occurred to me to check on what packages may or may not exist
11:28 * bshum will do some poking and whip up a branch for this later on.
11:41 * jeff had fun killing a test vm repeatedly yesterday
11:41 csharp @blame the test vm
11:41 pinesol_green csharp: the test vm stole bradl's tux doll!
11:42 jeff (intentional triggering of OOM conditions and adjusting Apache settings to avoid said conditions)
11:42 * Dyrcona had "fun" upgrading his laptop to Ubuntu 14.04.
11:42 jeff creating endless loops in php designed to quickly use as much memory as the php memory limit would allow, etc :-)
11:43 Erick316 joined #evergreen
11:44 bshum So pretty much everything that used to be CPAN can be done with packages now for the existing standalone DB list.  But I wonder what else might be missing off that list that might be required.
11:45 Erick316 hello
11:46 Dyrcona Erick316: hello
11:47 Erick316 I need some help, I'm triyng to import marc files into Evergreen, but I couldn't do a record match set that works
11:49 Erick316 I already used the expression of the official documentation, but it didn't work, here is an example : Your Expression: (020 ‡a OR 022 ‡a OR 024 ‡a OR 028 ‡a)
11:52 kmlussier Erick316: When you say it didn't work, what happened?
11:52 kmlussier And what version of Evergreen are you on?
11:53 Erick316 I´m usign Evergreen staff client 2.5.3, when import the records without the record match set all the records are in the queue, but when I use the record match set none of the records are brought to the queue
11:55 kmlussier Erick316: How large is the batch of records you're trying to import?
11:55 Erick316 I've already tried with other expressions and have the same result, I don't know if is the record match set or maybe I have another problem.
11:56 jl- Erick316: are you looking to import *any* records or your own?
11:57 Erick316 are about 35,000 records, but first I'm proving with less records
11:57 kmlussier Unfortunately, I need to head out, but I'm sure somebody can help you out.
11:57 Erick316 thank you anyway
11:57 kmlussier FWIW, I would never triy to import that many records through the staff client.
11:58 kmlussier left #evergreen
11:58 Dyrcona Erick316: I don't think the importer is going to deal very well with 35,000 records with match sets all at once.
11:58 Dyrcona Erick316: The staff client is likely to time out waiting on the server.
11:58 jl- yes start with 1k
11:59 jl- or even 1
11:59 jl- just for testing
11:59 jboyer-isl Start with 5 to make sure the match set works the way you want, after that your upper limit is determined by the complexity of your matches and your hardware.
11:59 jboyer-isl It will be a lower limit than you would hope.
12:01 Erick316 yeah actually I have 10 records only for testing
12:02 Erick316 but the expression for the record match set, I don't know if it is correct, have anyone some expression to make another test?
12:02 jboyer-isl How many are already in the system? Match set timing is effected by both incoming and existing.
12:03 Erick316 I' ve already used this : Your Expression: (020 ‡a OR 022 ‡a OR 024 ‡a OR 028 ‡a)  and  Your Expression: (item_lang AND (240 ‡a OR 245 ‡a))
12:03 Erick316 are 3 queues already in system some of 300, another of 600, and other of 3500
12:04 jboyer-isl Try a single field with a record that you know will match before trying 4 at a time.
12:04 jboyer-isl That shouldn't be too many for it to work.
12:06 jboyer-isl Does anyone currently in here use vandelay much? I'd be worried that the command line import methods are most common here.
12:10 Dyrcona I don't think too many catalogers are in the channel.
12:10 Dyrcona I imagine the ones who are are usually too busy to notice questions like these.
12:12 jboyer-isl Erick316, have you tried the openils-general or openils-docs lists? Responses may not be immediate, but they may be better than here.
12:12 jihpringle joined #evergreen
12:13 Christineb joined #evergreen
12:13 remingtron joined #evergreen
12:18 Erick316 No, I already haven't
12:20 csharp ~lists | Erick316
12:20 pinesol_green Erick316: information on the Evergreen project's mailing lists is available here: http://www.evergreen-ils.org/listserv.php
12:25 Dyrcona There is also a catalogers list.
12:26 jl- Dyrcona: I'm going through http://git.mvlcstaff.org/?p=Evergreen/ILS​-Contrib.git;a=blob;f=import_demo/trunk/g​enerate_copies.sql;h=4724219c1c5027029140​3ed64951bfde14ae0c97;hb=refs/heads/master so does this generate copies from existing bibs biblio.record_entry? it seemsto be referring to staging_items, which is what?
12:27 Dyrcona jl-: That script depends on one of the other ways of importing stuff, I guess.
12:28 bshum jl-: So, going by the README file for that contrib
12:29 bshum There's a link on line 74 to the Evergreen wiki
12:29 bshum jl-: http://evergreen-ils.org/dokuwiki/doku.php?id​=importing:holdings:import_via_staging_table
12:29 Dyrcona jl-: There's lots of other stuff in that repo.
12:29 bshum Which is how a staging table might be constructed I would imagine, based on how that generate_copies script operates.
12:29 bshum I wasn't involved with it and it's for Evergreen 1.4, so it might be flaky / needs serious updating to work
12:30 bshum But I would read the many things involved with the repo to see how things come together.
12:32 bshum Ugh, this page is horrible.
12:32 * bshum marks it as obsolete too
12:32 bshum Well, I'll think about it, maybe after lunch.
12:35 * jl- wishes he had another developer to work with here
12:35 jl- thanks guys
12:37 ryan joined #evergreen
12:46 phasefx jl-: http://wiki.evergreen-ils.org/doku.​php?id=advocacy:demonstration_data
12:46 phasefx old, but maybe still useful
12:48 jl- phasefx: interesting but this is not for generating copies?
12:48 phasefx the bottom of the page is
12:49 jl- indeed
12:54 Dyrcona jl-: You noticed the python script linked at the bottom of the page? I knew there was something like that somewhere.
12:56 jl- yes
12:56 jl- the holy grail right at the bottom
12:56 * phasefx had stored procedures that could generate fake data too, "but I have no idea where I put that stuff
12:57 jl- let's see if I can make this work
12:57 * jl- takes a snapshot just in case
12:57 jl- gotta love virtualization
12:57 akilsdonk joined #evergreen
13:03 jl- SELECT id FROM biblio.record_entry ORDER BY RANDOM() LIMIT 1
13:03 jl- so the script will create random copies, but it won't create copies for each bib
13:03 berick jl-: if the copy count is high enough, it will create copies for most bibs
13:04 berick if you need copies for every bib, you could run the script then modify a few call numbers to link to any empty bibs
13:04 jl- ok so if I have 600k bibs, I should set it to 1.2 million copies?
13:05 jl- berick: it would be enough to have maybe 60-80% of my bibs covered
13:05 berick yeah, probably
13:06 berick if you're going to do that many, you may want to run them in batches
13:06 berick of, say, 100k
13:07 jl- berick: good idea, and maybe limit the id's to choose from
13:07 bmills joined #evergreen
13:08 jl- like a maxid of 300000
13:08 berick well, it will only chose a valid bib ID.  the RANDOM() just affects the odering, not which ID to use
13:09 jl- right but how can I set a ceiling for which bib id's to choose from
13:09 jl- for my next sample data, it will have a different owner
13:09 berick oh, yeah, if you need to set a ceiling, then sure
13:09 jl- so from 1-300k library_owner 1 and then I'll run 300-600k with library_owner2
13:09 berick i misunderstood what you were trying to do
13:09 berick gotcha, yeh
13:09 jl- :)
13:10 jl- this script makes me very happy
13:16 mrpeters possible to accomplish alternate tpac skins without the ability to create new vhosts?  have a customer who is super locked down on what hostnames the city will let them create and they don't see the need for a second one for the library.  their goal is one hostname for the "in the building" TPAC and then their current one for the public, outside the building.
13:18 tsbere mrpeters: Er, if they have two hostnames (internal vs external) then, er, you have two hostnames already?
13:20 jl- SELECT id FROM biblio.record_entry WHERE id <= 1000  ORDER BY RANDOM() LIMIT 1 berick
13:20 jl- ceiling
13:20 jl- tested
13:20 jl- ;)
13:21 bshum Heh
13:21 berick jl-: cool, glad it's working
13:21 jeff mrpeters: i think it might be possible with creative apache config, but i haven't tried yet.
13:22 jeff mrpeters: that's not very helpful for an immediate answer, sorry
13:22 jeff i think i've looked at this before, but it's been a while since i last looked.
13:22 bshum mrpeters: Well, the city decides hostnames, so they control DNS.  But you could always play ridiculous and add a custom vhost entry in their hosts file on the local machines
13:22 jeff SetEnvIf wasn't helpful because it was a PerlVar being used...
13:23 bshum "in the building" and all
13:25 akilsdonk_ joined #evergreen
13:26 eeevil mrpeters: and, strictly speaking, anyone can point a name at any IP as long as they own the name. so if a completely separate name is what they want, they could go register a different name and point it at the opac IP (assuming, of course, there's no transparent proxy in front that will filter at the protocol level)
13:29 bshum Heh, I imagine it's not a huge stretch to refactor how the lib_ips.txt file works too, and change it to pass tpac variables for templating purposes.
13:29 mrpeters they don't already have 2 hostnames...thats the problem
13:29 mrpeters the hosts file isnt a bad idea though
13:30 mrpeters think we need to just beat on the city some more and explain why its needed
13:31 dbwells mrpeters: there's also always the option of running the second vhost on the same hostname, different port.  That path would come with its own set of complications, though.
13:31 mrpeters they have patrons getting mad that they can't get to certain databases that only work inside the library, so they want to go with different skins to avoid that
13:31 tsbere mrpeters: THAT sounds like an easier problem to solve
13:32 jl- berick: so if I want to give ~100k bibs I'll set the num_copies to 200k and also for num_volumes? not sure what the difference is
13:32 jl- *give 100k bibs a copy
13:32 ldwhalen joined #evergreen
13:32 mrpeters you wouldn't go with alternating skins, tsbere, depending on your location?
13:32 tsbere mrpeters: Use rewrite rules to set an ENV variable, then decide if you want to show the databases based on the value of said variable in the templates. One set of templates!
13:32 mrpeters hmmm thats not a bad idea either
13:32 tsbere (or just tell the templates how to check relevant ENV vars directly, I guess)
13:34 berick jl-: each volume can have multiple copies.  if you set num_vols and num_copies the same, each volume will have one copy (which is fine)
13:35 berick the fewer volumes you set, the more the copies will clump around bibs, which lowers the overall coverage
13:35 berick so, yeah, set them both to 200k for 100k bibs
13:36 jl- lgotcha
13:36 jl- thanks for writing that script
13:37 berick jl-: my pleasure.  I wrote it for myself ;)
13:37 bshum mrpeters: tsbere: So maybe something like IP condition checking like in http://www.netshinesoftware.com/blog/restricting-​access-to-a-url-by-ip-address-using-mod-rewrite/
13:37 bshum Where you write something like  RewriteCond %{REMOTE_ADDR} !^(A\.B\.C\.D)$
13:38 bshum And then set an apache variable to use a template override
13:38 bshum Or other variable to define whether or not to show a link actually.
13:39 tsbere bshum: RewriteCond whatever followed by RewriteRule . - [E=ENVVAR:ENVVALUE]
13:39 tsbere bshum: Then ENV.ENVVAR in templates is set to ENVVALUE
13:39 bshum Right
13:39 tsbere bshum: Or if it is simple enough SetEnvIf would work too, I think
13:40 bshum So wrap the link in like... [% IF ENVVALUE %] put <a>link here</a> [% END %] or some such?
13:40 tsbere bshum: [% IF ENV.ENVVALUE %]
13:40 tsbere But yea
13:40 bshum And that'll only show the link if the apache variable is set
13:40 bshum tsbere++ # apache rewrites are so great
13:40 jeff for "different behavior within the same template dir based on some variable", we do that with our youth stuff
13:41 tsbere Or, perhaps, say <a href="[%- IF ENV.ENVVALUE -%]realurl[%- ELSE -%]onlyavailablewithinthellibrarypageurl[%- END -%]">link text</a>
13:43 jeff we also have a conditional include based on physical_loc: https://github.com/tadl/Evergreen_templates_t​adlskin/blob/9c94d5359cc6db927579badc072ac9d2​d126d8ea/templates_tadlskin/opac/home.tt2#L3
13:43 jeff IF ctx.physical_loc == '23'; INCLUDE "opac/parts/inlib_nav.tt2"; END;
13:44 eeevil mrpeters: you could use mod_proxy to redirect to an external resource, make those external resources be vhosts on the same server, and user the server's /etc/hosts to point back at itself...
13:45 eeevil IOW, just standard vhost config with mod_proxy in front to internally redirect based on something in the original URL
13:45 dMiller__ joined #evergreen
13:46 eeevil hrm... have to make sure /all/ links are host-relative, though. unsure if that's likely in tpac
13:48 hbrennan joined #evergreen
13:56 bmills joined #evergreen
14:03 jl- berick: so for my example source  2 |      10 | System Local      | f            | t would probably be good?
14:03 jl- for the bibs
14:05 berick jl-: yep.  any of the existing sources will work.
14:05 berick anyone else having google issues?
14:06 berick google.com, googleapis.com crapping out on me
14:06 jl- even source 3? (transcendent) the purpose will be to have different library scope search
14:06 jl- with different owners
14:06 berick ah, yes, don't use a transcendent source -- sorry, forgot about those
14:06 jl- google works fine for me
14:07 berick hmm
14:14 ldwhalen joined #evergreen
14:14 berick no one on twitter complaining...  i must be in a Googmuda Triangle.
14:15 bshum Seems fine for us too
14:15 berick ooh, someone on twitter finally said something.  i'm not alone ;)
14:16 * berick feels better
14:18 * jeff is having a difficult time saying "Goodmuda" without a vague accent
14:20 * jeff ponders the impact of regional googleapis / google outage vs AWS region outage
14:20 jeff difficult to measure when they're not happening
14:20 jeff though i'd say the googleapis/google scenario is slightly less challenging to measure/simulate
14:28 csharp @who is complaining on twitter?
14:28 pinesol_green rangi is complaining on twitter.
14:31 ldwhalen joined #evergreen
14:38 jl- trying to delete some records.. DELETE FROM biblio.record_entry WHERE ID BETWEEN 200000 AND 250000; returns DELETE 0
14:38 jl- max(id) is 300000 and there are no gaps
14:38 berick jl-: it sets the deleted=true column on the bib when a DELETE is performed on bibs
14:38 berick it doesn't actually DELETE anything
14:38 berick hence the 0
14:39 jl- hmm
14:39 jl- how do I actually delete anything then with sql?
14:39 jl- in that table
14:39 Dyrcona jl-: You want the short answer?
14:40 jl- sure
14:40 jl- whatever is feasible
14:40 Dyrcona jl-: Drop the database and start over.
14:41 jl- lol
14:42 * Dyrcona is not kidding.
14:42 Dyrcona At this point, you're learning Evergreen.
14:42 Dyrcona The easiest thing is to wipe out the database, or even your whole VM, and start over.
14:43 jl- vm sure but we do have a dev server that has 600k formatted records
14:43 Dyrcona There are several things in Evergreen that are never really deleted from the database: bibliographic records, call numbers/volumes, copies, patrons, and a few others.
14:43 jl- that I loaded with batches of 20 k
14:43 jeffdavis Here's a long answer: you could drop the protect_bib_rec_delete rule on biblio.record_entry, delete as needed, and then re-enable that rule. But that tends to be an error-prone process, and other tables have similar protections...
14:43 rjackson-isl joined #evergreen
14:44 Dyrcona Yeah, there's a lot more to it than just dropping the rule.
14:44 jl- ok seems to have a lot of consequences
14:44 jeffdavis Arguably going through the process is a good way to learn more about what happens. But yeah, I prefer the short answer too. :)
14:44 Dyrcona Well, if you don't have volumes and copies, it is a little easier.
14:45 berick could also just leave the records there and adjust your queries to use WHERE deleted=FALSE  (admittedly, I have no idea what your overall goal is)
14:45 Dyrcona Well, 600,000 is a lot of junk records to be keeping around for no useful purpose.
14:49 ningalls joined #evergreen
15:00 jl- hmm is there a function to limit search results in the opac?
15:00 jl- by default
15:00 jl- going through 1m + records can be slow
15:02 eeevil jl-: tl;dr: yes
15:02 jl- is that a setting in the staff client? where?
15:03 eeevil it's not. it's inherent in how search works
15:03 eeevil search is paged (well, superpaged) ... it's ... complicated ;)
15:04 eeevil search is not a simple SQL statement in evergreen
15:10 jl- ok
15:10 Dyrcona1 joined #evergreen
15:13 Dyrcona Stupid wireless.
15:17 * csharp wants an ethernet drop beside every power outlet
15:18 * Dyrcona has 3 ethernet drops by his power, 1 in use by his desk phone.
15:18 * Dyrcona also has an ethernet cable that is plugged into one of the drops just lying on his desk doing nothing.
15:18 * Dyrcona should probably use it. :)
15:18 tsbere csharp: And of course, once you get that you will find that you are invariably trying to use one that has no patch to a switch at the other end or is on the wrong vlan. ;)
15:19 tsbere csharp: Assuming they aren't already all in use, anyway
15:20 Dyrcona Whatever happened to network over power lines anyway?
15:22 jeff Dyrcona: HomePlug: http://en.wikipedia.org/wiki/HomePlug
15:24 bshum jl-: One quick way to limit a search in the OPAC is to make use of the logc variable.  Like hostname/eg/opac/home?locg=100 (or whatever the ID is of the library you want to filter down to)
15:24 bshum *locg, not logc
15:25 bshum That'll apply a search filter to the OPAC results for that given org unit
15:26 kbeswick joined #evergreen
15:30 jl- bshum: makes sense, a search filter for copies and library owner?
15:34 jl- org unit = library_owner
15:34 jl- gotcha
15:36 dMiller__ joined #evergreen
15:38 * rangi waves from the equinox offices
15:39 * bshum waves back at rangi
15:39 bshum Have you posted a pic of your new laptop?
15:39 rangi not yet
15:40 rangi have now, on google+
15:40 jeff /msg rangi okay, now remember... the gear is hidden under the ping pong table. be sure to put it in place and ensure that the unit has power before you leave.
15:40 rangi heh
15:40 * jeff ducks
15:50 eeevil rangi++ # and sorry I couldn't be there for the NZ beer :(
16:00 JTaylor_ joined #evergreen
16:01 gmcharlt rangi: howdy!
16:05 dbs_mob joined #evergreen
16:06 dbs_mob did someone say NZ beer?
16:06 * dbs_mob hops on a plane to Atlanta
16:06 * gmcharlt is imaging not just one dbs, but a mob of them
16:06 * bshum should have just bought that ticket south.
16:07 dbwells gmcharlt: I always imagine that as well :)
16:28 tspindler left #evergreen
16:31 mdriscoll left #evergreen
16:38 bshum "Utopic Unicorn" really?
16:38 bshum I mean unicorns sure. But utopic?
16:40 Dyrcona Whatever.
16:40 * Dyrcona starts installing OpenBSD.....
16:42 Dyrcona They should have chosen Uguisu: "Their guano is used in face creams!"
16:54 mrpeters left #evergreen
17:03 gsams I've got an odd issue with expired holds on 2.3.5.  We have an issue that is happening where items that have hit the hold expiration boundary are cancelling automatically with an odd timestamp, for instance 4/22/2014 12:6 PM
17:04 gsams I don't feel like it should be cancelling the hold off of the patron account until after we check it in with the clear shelf expired holds flag enabled, but they are being cancelled it looks like
17:05 csharp a unicorn is the first imaginary animal they've used
17:05 bshum csharp: Indeed.
17:05 bshum gsams: Was that supposed to be 12:6 or 12:06?
17:05 gsams 12:6 is the timestamp it is showing
17:06 csharp eww
17:06 gsams yeah, I'm worried about that
17:06 gsams We have a few like that in the holds shelf browser, but most of them are normal timestamps
17:07 csharp gsams: is it entered that way in the database?
17:07 csharp seems like postgres would reject an invalid time
17:07 csharp the expire time comes from the client machine (e.g., the patron's web browser when placing the hold)
17:08 csharp they used to be able to edit that expire date, but that was pre TPAC
17:08 csharp (that is to say that I don't know if they can edit it now)
17:09 gsams the database shows a timestamp of 2014-04-22 12:06:56.199783-05
17:09 bshum And that's "expire_time" or "shelf_expire_time"
17:10 bshum Cause those are different things
17:10 gsams That's actually the cancel_time in the database
17:10 gsams the expire_time shows null
17:10 csharp hmm
17:10 bshum null expire_time isn't wholly unusual
17:10 gsams but the reason clearly shows as hold shelf expiration
17:11 csharp gsams: okay - well, then we know it's a display issue
17:11 csharp oh - hold shelf expiration, not hold expiration
17:11 gsams yes, sorry if I mispoke at some point
17:12 bshum I don't have a 2.3 system handy anymore
17:12 gsams it does have a shelf_expire_time as well
17:12 csharp gsams: they aren't cancelling automatically - it probably means that a staff member entered the "Clear Shelf Expired Holds" interface
17:12 bshum But yeah, what csharp says
17:12 bshum Maybe they went to the wrong menu option
17:12 bshum And that cancels holds
17:12 gsams wouldn't that remove it from the hold shelf browser?
17:13 csharp just clicking on that menu item will automatically cancel all holds past the configured shelf expire time
17:13 csharp we've greyed it out (ala bshum's patch)
17:13 csharp or phasefx's patch via bshum
17:13 bshum It'll probably leave them on the shelf browser though.
17:13 gsams hmmm.
17:13 bshum Till checked in
17:14 bshum But yeah, use of the menu option, even accidentally could mess things up.
17:14 gsams that might explain it then, I'll have to find out if someone has been pushing buttons
17:14 csharp that menu item should really be removed - this is going to happen over and over
17:14 gsams are you talking about the clear these holds button on the clear shelf expired holds interface?
17:14 csharp gsams: if you have a bunch of items showing with that same cancel timestamp, that's almost certainly what happened
17:14 csharp "what does this button do" BOOM
17:15 bshum csharp: I'm not sure how I feel about removing someone else's "feature" but it does seem to cause more pain than expected in my opinion.
17:15 gsams yeah that is what it looks like then
17:15 csharp do we know whose feature it was?
17:15 bshum csharp: Not off the top of my head, but it probably came into being during the big rewrites of 2.0/2.1
17:16 * csharp requests a "drop my database" menu item button and makes everyone else just live with it ;-)
17:16 gsams csharp++
17:16 bshum "Clear Hold Shelf" process is noted in the long, long list of 2.0 features
17:17 bshum Back then, we weren't as good with tracking new features with LP, etc.
17:17 bshum Might only exist as some note in SVN and the memory of the original devs
17:17 csharp @fix that problem
17:17 pinesol_green csharp: Mr. Spock: Something fascinating just happened.
17:17 * csharp wants a @fix command that "fixes" whatever we want
17:18 gsams I don't suppose there is a good way to see who might have accidentally hit the button?
17:18 csharp gsams: I think only logs will tell
17:18 csharp the user id will be in the log messages
17:18 bshum Probably right, holds don't have audit trails by default.
17:19 gsams mkay, that'll have to do then
17:19 bshum At least you have the exact moment when the hold was cancelled.
17:19 pinesol_green Incoming from qatests: Test Success - http://testing.evergreen-ils.org/~live/test.html <http://testing.evergreen-ils.org/~live/test.html>
17:19 gsams I think I know what happened though, and timestamps are enough for any local damage that might have been done.
17:19 bshum That'll help with log sifting
17:19 gsams csharp++
17:19 gsams bshum++
17:19 gsams many thanks!
17:20 mmorgan left #evergreen
17:23 gsams turns out it was me!  Ha!
17:23 gsams I was answering questions for our incoming library and cancelled holds by accident
17:24 gsams that sounds like a thing I would do while doing something totally innocuous.
17:24 gsams so... what is this change that can disable this "feature" that I might be able to implement?
17:28 * bshum points gsams at http://irc.evergreen-ils.org/​evergreen/2013-09-05#i_27907
17:32 gsams bshum++  will give that a go
17:34 bshum gsams: Should be as simple as dropping that in and then restarting staff clients to see the menu option grey out
17:36 gsams bshum: that did the trick, thank you very much.  Saving me from a lot of headaches down the line.
17:36 gsams bshum++
17:37 gsams phasefx++ # for helping disable the clear shelf expired holds option back in September of 2013
17:41 bshum csharp: I'm building a new trusty demo to poke at the ubuntu makefile you setup for Evergreen.
17:41 bshum OpenSRF seems fine with the revisions I threw in my working branch
17:41 bshum Or at least, the basic test passes
17:42 csharp cool
17:42 csharp yeah - I was updating the Evergreen makefile to be able to test the opensrf makefile ;-)
17:43 csharp beyond the math test, that is
17:43 bshum Hehe, yeah
17:43 bshum On paper, all the changes you suggest look alright.
17:43 bshum I'm still not entirely sure what gmcharlt was warning us to watch for, some change in perl I think.
17:43 bshum But I'm sure we'll hit something new
17:47 gmcharlt bshum: upshot - hash key sort randomization caused failures in Koha's test cases of its copy of QueryParser
17:48 gmcharlt that may (or may not) apply to Evergreen
17:48 gmcharlt the issue manifested as a given query randoming resulting in different parse trees
17:49 gmcharlt hopefully isn't not widespread
17:50 bshum Guess we'll see.
17:52 gmcharlt speaking of which, a minor example in OpenSRF - https://bugs.launchpad.net/opensrf/+bug/1285915
17:52 pinesol_green Launchpad bug 1285915 in OpenSRF "t/09-Utils-JSON.t can fail on Perl 5.18" (affected: 1, heat: 6) [Low,New]
18:03 jwoodard joined #evergreen
18:08 vlewis joined #evergreen
18:41 berick joined #evergreen
18:49 hbrennan Hey all - Just returned from lunch to discover we're running on offline mode (messed with db, jabber prob)
18:50 hbrennan One of our offline circ stations is giving a print_tree error at the end of a transaction and won't print a receipt... These transactions are still being logged though, right?
18:50 hbrennan This particular circ station normally required a hit of the 'OK' to actually print receipts, while our other stations automatically spit it out
18:57 hbrennan nm. Figured it out
18:57 hbrennan Answer is yes, the transactions are still logged
18:57 hbrennan I pulled a bshum (conversation with self)
18:58 gsams hbrennan++
18:58 gsams I did that a few days ago I think
18:58 hbrennan Sometimes you just have to say things "out loud"
18:59 hbrennan Then panic because no one is there to help, and then figure it out
18:59 gsams I find it very effective myself
18:59 gsams nothing like being under fire
19:00 hbrennan Luckily it wasn't me who broke it
19:01 hbrennan Welp, with EG down I think I'll take a break and get some sunshine while delivering piles of electronics to recycling!
19:48 dcook joined #evergreen
20:00 gsams Got a request from our migrating library, they desperately need a way to search call numbers that isn't the bib call number option or a shelf browse.
20:01 gsams unfortunately bib call number has nothing to target (so it appears) and shelf browse isn't a good option for them
20:02 gsams they have all of their call numbers set to generic FIC/dewey style call numbers no matter where they are at, and if a patron approaches their staff with a call number they have to be able to search in a way that lists all the possibilities
20:04 gsams if anyone has options that might be of use for this, I would greatly appreciate any help or pointing in the right direction to make this happen.
20:44 kmlussier joined #evergreen
20:49 gsams joined #evergreen
20:58 _bott_ joined #evergreen
21:09 bshum hbrennan: Ha, I'm glad I can be an example :)
21:10 hbrennan bshum: You're a great one!
21:12 bshum I just type a lot now.  Used to be you couldn't get me to say anything at all.  My boss had to order me to say or ask at least one thing in IRC every day at the beginning when I was still a newbie.
21:13 hbrennan That's a great idea
21:13 * kmlussier tries to imagine a world where bshum needs to be forced to talk in IRC.
21:13 hbrennan haha
21:13 hbrennan I type really fast, so a lot more often comes out than needs to
21:13 hbrennan wow, how many grammar issues are in that?
21:14 hbrennan Worse sentence ever
21:14 hbrennan And there's the proof
21:14 gsams haha
21:14 kmlussier hbrennan: My typos in IRC are terrible.
21:14 gsams bshum: I should probably follow that idea, ask a question in IRC at least once per day
21:15 bshum When I used to play online games, I got into the habit of at least capitalizing the first letter and putting a period at the end of each sentence.  My guildmates were snobs.  :)
21:15 gsams I'm a bit picky about my typing
21:15 gsams though I do allow dropped caps and lack of periods
21:15 hbrennan I'm very impressed with the typing skills of EGers in here
21:16 hbrennan .
21:16 gsams I just like to make sure that my message is clear.
21:16 kmlussier I'm very impressed with the typing skills of my 9 yo. She can type nearly as fast as I can.
21:16 hbrennan Now I'm self-conscious
21:16 gsams haha
21:16 bshum gsams: It's good to ask questions, I'm happy that I've evolved to be able to help answer a few from time to time.
21:17 gsams bshum: I've learned quite a bit every time I have asked a question.  Except my last one, which I imagine might be a while.
21:18 gsams I'm still learning what can be changed easily and what might take actual development
21:18 hbrennan This is the best place to play devil's advocate
21:18 bshum That tends to be a fairly complicated question indeed.
21:19 gsams aye, I like that the people on here are willing to share their experience and opinions about various questions I've asked
21:19 bshum gsams: Bib call number browse sucks.  I hate it and we removed it from our catalog a couple years back when we first went live on TPAC.
21:19 bshum Mostly because in our consortium, hardly anyone used bib call numbers.
21:20 gsams bshum: I'm going to remove it to, but the new library needs a call number search that isn't bib related or shelf browsing
21:20 bshum What's wrong with the shelf browser?  :)
21:20 gsams haha
21:20 gsams I've never had a problem with it
21:20 bshum It'll still get you to the bib you're searching around, in theory.
21:20 kmlussier gsams: Are they looking for a simple list of call numbers?
21:21 gsams they need search results related to a call number
21:21 bshum gsams: Ooh, pretty, I haven't looked at your catalog lately.  I like the NTLC logo.
21:21 kmlussier Oh, so not a browse list.
21:21 gsams bshum: Thanks!  It's actually one of the first things the new library helped with
21:22 gsams kmlussier: yeah, normal search results based on a call number basically.
21:22 kmlussier gsams: When I saw your e-mail, I thought you were looking for something like this: http://masslnc.cwmars.org/node/2590. Which we never funded, but the specs are there if anyone wants to run with it. :)
21:23 gsams all of their fictional materials use the same "FIC ABC" structure so they need to be able to search by that
21:24 gsams kmlussier: That is actually a pretty neat idea.  I wish that was what I was looking for, though I don't know that I have the chops to implement that sort of features haha
21:25 bshum Hmm
21:25 gsams DVDs, Easy Books, Adult Fiction, Young Adult, etc.  They apparently never thought they would need more descriptive call numbers until it was too large a project.
21:26 gsams And of course, no one stores call number data in 092/099 in this group
21:28 gsams Where does it expose the Volume information so that cnbrowse can work?  Would it be possible to use the same system and remove the browse part?
21:29 bshum So all that gets handled in Open-ILS/src/perlmods/lib/Open​ILS/WWW/EGCatLoader/Search.pm
21:30 bshum (I started looking at it from another angle, seeing where item_barcode as a qtype was expressed, but I can see cnbrowse in there too)
21:33 gsams hrm
21:37 gsams I think I'm going to look at this tomorrow, and maybe that will work better for me
21:38 gsams at the moment, I feel too uncomfortable with the idea of hacking a call number search into this
21:39 bshum It seems more new featurish to me.
21:39 bshum aka, some sort of development.
21:39 bshum But honestly, search has always been a weird place to look for things.  Maybe there's something more obvious I'm missing.
21:39 bshum (irony)
21:41 bshum So... they need to be able to search by call numbers (on the volume level) by themselves and get a giant list?  Or is this like, an additional filter.
21:41 bshum I mean, how would you narrow a search from FIC ABC to something more relevant.
21:43 gsams Basically yes, and I'm not sure how they would narrow things down from there
21:43 gsams I'm planning on upgrading after the migration which would reimplement shelving locations at least, but I'm not sure otherwise.
21:49 gsams It does sound like a feature request to me as well though
21:49 bshum Indeed.
21:50 bshum I can't find anything in QueryParser.pm for volume/call_number type search filters
21:50 bshum locations, sure; lassos, you betcha; lucky?? okay...
21:50 bshum But nope, nothing for raw CN lookups as a filter choice.
21:52 gsams yeah, I was afraid of that too
21:53 gsams I wasn't sure how it was pulling up the shelf browser, but I had a feeling it wouldn't be compatible(easily) with a regular search
21:53 bshum It's probably adaptable.
21:54 bshum But yeah, new feature, whee.
21:54 bshum If it was me, I'd push them away from call number searching and finding more ways of narrowing or mapping their data to other areas.
21:54 bshum :D
21:55 gsams aye, I'm going to have a talk with their director about that, considering
21:58 jeff hrm
22:08 gsams bshum++ thanks for taking a look with me on that
22:09 gsams I'm going to go home and see if there is something I can do with fresh eyes tomorrow.
22:50 kmlussier left #evergreen

| Channels | #evergreen index | Today | | Search | Google Search | Plain-Text | summary | Join Webchat