Evergreen ILS Website

IRC log for #evergreen, 2013-08-28

| 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:01 phasefx Fem: if you load http://192.168.100.53/ in Internet Explorer, what you do see?
00:01 Fem It works!  This is the default web page for this server.  The web server software is running but no content has been added, yet.
00:02 Fem do you think the two .js is a bug of 2.3.9?
00:02 phasefx hrmm, but we disabled that with a2dissite, so you shouldn't be seeing that
00:02 Fem what u mean?
00:02 phasefx I suspect we're not going to the right server somehow
00:03 phasefx your ifconfig showed the .53 address, so I'm confused
00:04 Fem o.O
00:04 Fem I didn't get you sir.
00:04 phasefx Fem: in one terminal, do   tail -f /var/log/apache2/access.log /var/log/apache2/error.log
00:04 Fem don't
00:06 phasefx then reload the webpage in Internet Explorer and see if there is activity in that terminal
00:08 Fem still it say's it works
00:08 pastebot "fem" at 204.193.129.146 pasted "client error in evergreen" (25 lines) at http://paste.evergreen-ils.org/40
00:10 eeeeevil "/openils/var/web/xul/rel_​2_3_9/server/main/OpenILS" i just saw this error what you think?
00:10 phasefx I think that's JSAN trying to find a repository
00:10 Fem hmmm
00:10 Fem what JSAN?
00:11 bshum That unfound OpenILS happens all the time in production.  I just ignore it and use it to count the number of times staff log in with a client.
00:11 phasefx eeeeevil: the weird thing is that the server's IP address is blah.53, and on the server, wget -O- http://blah.53/opac/common/js/fmall.js gives a 404, but http://localhost/opac/common/js/fmall.js works
00:13 phasefx Fem: JSAN is a library that the staff client uses internally; we can ignore it
00:14 phasefx Fem: try  a2dissite default-ssl
00:14 phasefx as root
00:15 pastebot "fem" at 204.193.129.146 pasted "client error in evergreen" (3 lines) at http://paste.evergreen-ils.org/41
00:15 Fem disabled...
00:17 Fem phasefx when i type the " http://localhost/opac/common/js/fmall.js " in linux it shows this...
00:19 Fem prntscr.com/1nuu6s
00:21 phasefx Fem: try  telnet localhost 80     then enter  help     do the same for  telnet 192.168.100.53 80
00:22 pastebot "fem" at 204.193.129.146 pasted "client error in evergreen" (11 lines) at http://paste.evergreen-ils.org/42
00:23 Fem so?
00:23 phasefx you typed help and it just closed the connection without spitting anything else out?
00:27 phasefx instead of help, do the telnet command for localhost and type     GET / HTTP/1.1   <press enter>  host: localhost  <press enter> <press enter>
00:30 pastebot "fem" at 204.193.129.146 pasted "client error in evergreen" (29 lines) at http://paste.evergreen-ils.org/43
00:30 Fem I don't know if i get correctly but uhmm
00:31 Fem check it..
00:31 phasefx host: needs to spelled out; and I'll want to see one iteration with  host: localhost   and another with  host: 192.168.100.53
00:31 phasefx and then the same with telnet 192.168.100.53 instead of telent localhost
00:35 Fem its the same error..
00:35 Fem I don't know if i get correctly.
00:36 phasefx an example: http://paste.evergreen-ils.org/44
00:45 phasefx Fem: I need to sleep; most folks will show up here in about 8 hours or so.  The mailing list may be a good place to try to get help as well
00:46 phasefx since srfsh works, you're very close.  You may want to install that .exe in ubuntu using Wine, and use localhost for the hostname in the staff client, just to see it work
00:48 Fem what .exe
00:48 Fem wine?
00:49 phasefx the staff client exe you downloaded
00:49 phasefx wine is a program for linux that lets you run windows programs
00:51 pastebot "fem" at 204.193.129.146 pasted "client error in evergreen" (27 lines) at http://paste.evergreen-ils.org/45
00:51 Fem how to use it?
00:51 Fem anyway do you think I made it right now?
00:52 phasefx can you do that same telnet test, but do  telnet 192.168.100.53 80  instead of telnet localhost 80?
00:53 Fem 400 bad request
00:53 Fem when i type telnet 192.168.100.53 80
00:54 phasefx so you don't even get a chance to type the GET / HTTP/1.1 part?
00:55 pastebot "fem" at 204.193.129.146 pasted "client error in evergreen" (27 lines) at http://paste.evergreen-ils.org/46
00:55 Fem now i think i made it right
00:56 phasefx alright, one last test, change the host: line to host: 192.168.100.53  instead of host: localhost
00:56 Fem yea I already do that..
00:56 Fem it says 400 bad request
00:56 phasefx I haven't seen that output
00:56 Fem oh boy I thin I didnt post that..
00:56 Fem wait
00:58 pastebot "fem" at 204.193.129.146 pasted "client error in evergreen" (24 lines) at http://paste.evergreen-ils.org/47
00:58 Fem I think now it works
00:58 eeeeevil hmmm move your folder www to openils
00:59 phasefx Fem: does ls -l /etc/apache2/sites-enabled/  only show eg.conf?
01:00 eeeeevil nope
01:00 pastebot "fem" at 204.193.129.146 pasted "client error in evergreen" (5 lines) at http://paste.evergreen-ils.org/48
01:00 * phasefx had Fem do a2dissite earlier, saw the output
01:00 Fem hmmm.... 2
01:01 phasefx but it's still there, bleh
01:01 phasefx try  a2dissite 000-default
01:01 Fem root?
01:01 phasefx yeap
01:01 pastebot "fem" at 204.193.129.146 pasted "client error in evergreen" (5 lines) at http://paste.evergreen-ils.org/49
01:02 Fem so? what you think?
01:02 phasefx now do what it says,   service apache2 reload
01:02 eeeeevil I think fem is new in linux am i right dear?
01:02 phasefx indeed
01:03 Fem ok now
01:03 phasefx Fem: try staff client now
01:03 Fem it works... thanks...
01:04 Fem I will now log that... I am new in linux.. haha
01:05 phasefx @later tell eeevil lots of evil around here :)
01:05 pinesol_green phasefx: The operation succeeded.
01:06 Fem a big thanks to you.
01:07 phasefx glad it's working
01:08 phasefx those a2dissite instructions could be robustified
01:08 Fem aggreed
01:09 Fem you from evergreen?
01:11 phasefx Fem: everyone in this channel is involved with Evergreen one way or another; but no one is "from" Evergreen
01:11 Fem 1 more sir...I am the one who will make the online of evergreen?
01:11 Fem I mean I am the one who will build the website?
01:12 phasefx you're saying you are in charge of getting Evergreen running for your library?
01:12 Fem yes
01:12 Fem sadly yes..
01:14 phasefx Fem: welcome to #evergreen :)
01:18 Fem haha thanks.....
06:55 timf joined #evergreen
06:56 timf joined #evergreen
07:10 moodaepo_nb joined #evergreen
07:41 jboyer-isl joined #evergreen
08:07 csharp ok - having a weird error sometimes when I create a reports template and attempt to run it and my folders (within the report definition grid - e.g. "Choose a folder to store this report definition:") are not displaying
08:08 csharp JavaScript Console output: TypeError OILS_RPT_TRANSFORMS[par.column.transform] is undefined oils://remote/reports/oils_report_param_editor.js
08:10 csharp oh - line 56
08:11 csharp $n(row, 'transform').appendChild(text(OILS_RPT_T​RANSFORMS[par.column.transform].label));
08:11 csharp this seems to happen when I attempt reports that dig into MARC fields and such
08:12 csharp but I don't know if that error is a red herring or if the MARC fields are the issue
08:14 * csharp has trouble untangling javascript :-/
08:14 csharp @monologue
08:14 pinesol_green csharp: Your current monologue is at least 8 lines long.
08:15 csharp oh - hmm - maybe it's use of "substring" that's causing the issue
08:15 akilsdonk_ joined #evergreen
08:16 csharp yep
08:16 csharp if I change the "transform" from substring to raw data I'm able to see everything as expected
08:17 paxed csharp: there's also bug 1100262
08:17 pinesol_green Launchpad bug 1100262 in Evergreen 2.4 "Report editor uses translated string internally and crashes" (affected: 4, heat: 14) [Medium,Confirmed] https://launchpad.net/bugs/1100262
08:17 paxed those sneaky transformeses
08:18 csharp paxed: thanks - I just came across that bug too, but didn't know if it was related
08:19 csharp sounds like the same thing though
08:23 * csharp adds a "me too (I think)" comment to the bug report
08:23 csharp paxed++
08:25 csharp I just experimented with removing my hard-coded value for the substring - still not working
08:26 csharp so selecting substring appears to break reports
08:30 jboyer-isl csharp: only when building them, or do past reports with substring also fail?
08:37 Shae joined #evergreen
08:37 csharp jboyer-isl: I haven't dug that far yet
08:37 csharp I imagine substring is seldom used by your average reports runner
08:41 jboyer-isl That's true. I do have a few cooked up though, so it at least worked on 2.2. What are you running currently? 2.3?
08:47 csharp yeah 2.3.6
08:53 mmorgan1 joined #evergreen
08:54 csharp Open-ILS/web/reports/oils_rpt_param_editor.js hasn't been touched in five years, so maybe it could be more xulrunner weirdness?
08:55 * csharp doesn't know enough about it to know :-/
08:55 jboyer-isl Oh, I was wrong. I don't think I've used the Substring transform, only the Contains Matching Substring operator. How is it supposed to even work?
08:56 csharp oh hmm - I didn't realize there was that operator ;-)
08:56 csharp lemme try that
08:57 ericar joined #evergreen
08:57 csharp aha - that does work
08:57 csharp so maybe "substring" as a transform never worked?
08:58 csharp at least that gives me the template I wanted!
08:58 jboyer-isl Quite possible. I never knew how it was supposed to since you can't supply start and length params.
08:58 csharp jboyer-isl++ # thanks!
08:59 jboyer-isl I like the (ignore case) version more myself, but that's a personal thing. :)
08:59 jboyer-isl Glad your report is going!
08:59 csharp yeah - that's what I'm using
08:59 kmlussier joined #evergreen
09:02 Dyrcona joined #evergreen
09:04 mrpeters joined #evergreen
09:11 collum joined #evergreen
09:11 yboston joined #evergreen
09:18 Dyrcona Fun with mailman!
09:23 jboyer-isl Hmm. Doesn't /sound/ like fun.
09:41 tsbere jboyer-isl: It is fun. For him. Because *I* get to fix it. ;)
09:43 csharp heh
09:43 csharp mailman++
09:46 Dyrcona Well, it's not that much fun when you get errors creating a new list.
09:51 jboyer-isl I suppose it still beats majordomo. That was the last one I fought with. Plus, if someone else gets to make it work, how bad an experience can it be? :D
09:53 jboyer-isl Ugh, I, apparently, use, too, many, commas. Must be a programming related disease; passing sentence fragments as params to something or other, hah.
09:55 mllewellyn joined #evergreen
09:58 Dyrcona Heh. I have that same tendency.
09:59 Dyrcona I put them where I might usually pause when speaking, but this is not always where good grammar says that they should be.
10:07 * csharp is a former English major who thinks that grammar rules should be more descriptive than prescriptive
10:08 * tater now knows csharp reads SlashDot
10:08 csharp ha!
10:10 * Dyrcona doesn't visit Slashdot as much as he used to.
10:10 * Dyrcona thinks it has gone downhill since CmdrTaco went to the Washington Post.
10:11 csharp hey, apparently so has the Washington Post! badump bing!
10:11 Dyrcona Ha!
10:12 * csharp is here all week
10:28 krvmga joined #evergreen
10:29 krvmga the jacket pictures that show up in the catalog are re-sized on the fly, yes?
10:30 mcooper joined #evergreen
10:43 jeff krvmga: nothing in evergreen re-sizes the images at this time. there are various sizes available from providers, and the user's web browser will re-size them to fit the dimensions specified (if/where specified) in the html/css
10:43 krvmga joined #evergreen
10:43 jeff krvmga: nothing in evergreen re-sizes the images at this time. there are various sizes available from providers, and the user's web browser will re-size them to fit the dimensions specified (if/where specified) in the html/css
10:43 jeff krvmga: hopefully that helps without overly complicating things.
10:43 krvmga jeff: thanks, it does.
10:52 csharp @blame teh interwebz
10:52 pinesol_green csharp: teh interwebz broke Evergreen.
10:52 Dyrcona The pipes are full!
10:55 paxed choo! choo! all aboard the bus-sized fatberg!
11:09 zerick joined #evergreen
11:16 bshum kmlussier++ #digging up lost bugs
11:18 dboyle joined #evergreen
11:19 krvmga sounds like a kid's book: "kmlussier and the island of lost bugs"
11:22 * kmlussier is generally afraid of bugs and doesn't want to be stuck on an island with a bunch of lost ones.
11:24 krvmga :)
11:38 ericar joined #evergreen
11:41 jboyer-isl Ooh, the island of misfit bugs. "And what do you do?" "I make the patron summary window chartreuse when they owe over $5.00 and it's a Tuesday." "Well, I'm a dentist."
11:41 jdouma joined #evergreen
11:44 csharp jboyer-isl++
11:47 phasefx /me did not actually write out chartreuse in the CSS, fwiw :)
11:51 jboyer-isl That the w3c didn't include it in the html named colors is a failing on their part, in my opinion.
11:55 acoomes joined #evergreen
11:57 smyers_ joined #evergreen
11:59 bshum Eww, the mac client has a sporadic bug with xul rows where the line goes invisible hovering over them.
12:01 csharp OMG we should totally do this: https://github.com/mroth/lolcommits
12:02 Dyrcona No.
12:02 csharp haha
12:03 kmlussier csharp++
12:04 csharp of course the preferred verbosity of commit messages would pretty much cover the image ;-)
12:06 rfrasur joined #evergreen
12:06 tsbere I am willing to go with that. Fair warning, though: I don't keep webcams on my machines and my commits all happen on a server over SSH, negating the ability to use a webcam if it is there. ;)
12:07 * phasefx will use psychedelic images and hack your visual cortex
12:08 * bshum now remembers why he hated his mac after awhile.
12:08 rfrasur phasefx++ #best comment of the day
12:10 dbs lolcommits could/should just use the 1-line summary, which is supposed to be brief :)
12:12 csharp bshum: is it reproducible?  I could track down a mac if you need confirmation
12:13 csharp (of course if it's a xulrunner-level rendering issue, not much we would do)
12:14 phasefx may be related to the skin being used for the apple look-and-feel
12:19 ericar joined #evergreen
12:29 stevenyvr2 joined #evergreen
12:33 kmlussier berick: Is there any chance of resurrecting https://bugs.launchpad.net/evergreen/+bug/856688? I don't know how much work it would take to bring it up to the current code, but it would be a shame to lose what was already done for it.
12:33 pinesol_green Launchpad bug 856688 in Evergreen "Option to disallow use of an org unit as a pickup library for holds" (affected: 4, heat: 18) [Wishlist,Incomplete]
12:33 mrpeters is there a comprehensive list of CC processors Evergreen works with out of the box/
12:33 mrpeters release notes for 2.0 just mention Authorize and PayPal
12:35 berick mrpeters: those two, plus PayFlowPro (variant of paypal)
12:35 mrpeters berick: awesome.  thank you
12:35 mrpeters customer thinsk PayFlow is the real processor they use, so thats excellent
12:35 berick de nada
12:38 mrpeters anyone played with the dedupe.sql that comes with the migration-tools?   have any documentation?   i'm kind of blindly running it, sans the actual merging, to see what kind of results I get in a massive database.  Seeking any documentation that might be out there for it though!
12:38 berick kmlussier: now that jspac is officially dead, i don't see why not.  should be pretty easy to forward-port
12:40 kmlussier berick++
12:42 csharp I'm trying to get our dvd/video/videogame circ limit sets to be applied when another circ rule is "winning"
12:42 csharp our circ rules are mainly built around circ modifiers, but we have org-specific exceptions for fine level and when those "win", the circ limit sets aren't factored in
12:43 Dyrcona Add maps for those circ matrix matchpoints.
12:43 Dyrcona config.circ_matrix_limit_set_map
12:43 csharp ok - that's what I was wondering
12:43 csharp can I load those rules up with three limit sets each? or does that cause problems?
12:44 Dyrcona I'm not sure I understand the question?
12:44 Dyrcona If you want to lump multiple circ mods together, you make a group and add the limit_sets to the group.
12:44 Dyrcona At least in 2.3+, I think.
12:44 Dyrcona Maybe in 2.2, also.
12:44 tsbere csharp: Did you enable "fallthrough" on the limit set to circ matrix maps?
12:45 csharp I've only added one circ limit set per circ matchpoint - if I add multiple sets per matchpoint, would you expect problems?
12:45 Dyrcona oh, that too.
12:45 csharp I don't see "fallthrough".  I do see "Global"
12:46 tsbere csharp: circ_matrix_limit_set_map table
12:46 csharp okay - lemme look
12:46 * csharp was starting with the GUI
12:46 tsbere In the GUI it is in the circ matrix editor
12:46 tsbere Not the limit set editor
12:46 tsbere As fallthrough is a factor in the link, not the limit set itself
12:46 csharp ah - fallthrough is false
12:47 tsbere With fallthrough false the limit set only applies if the matchpoint is the most specific one in the set. With fallthrough true it applies so long as the matchpoint does.
12:47 csharp excellent
12:47 csharp I'm pretty sure that will fix me up then
12:47 * csharp tests
12:53 kmlussier yboston++ # providing guidance on developer lingo in LP
12:54 kmlussier yboston: What are your thoughts on setting bug 1000957 to Won't Fix in light of new bib/authority browse?
12:54 pinesol_green Launchpad bug 1000957 in Evergreen "TPAC is missing the authority browse feature" (affected: 8, heat: 38) [Wishlist,Confirmed] https://launchpad.net/bugs/1000957
12:56 csharp tsbere: hot damn that works
12:57 csharp Dyrcona++
12:57 csharp tsbere++
13:00 bshum Hmm, library conference or Star Trek convention?  Decisions, decisions....
13:00 kmlussier Star Trek.
13:02 bradl Star Treck
13:02 bradl I mean Trek :)
13:02 bradl kmlussier++
13:03 kmlussier bradl, bshum: I'm surprised there is even a question there.
13:04 bshum Yeah I suppose :)
13:04 * csharp goes to the knockoff "Starr Treck" convention
13:04 csharp bshum: you should mosey on down to dragon*con
13:05 bshum csharp: Unfortunately I'll be in Dallas, TX for a family friend's wedding this weekend.
13:05 bshum I'm getting my air miles done :)
13:06 bshum Maybe next time
13:06 bshum csharp: So for that xul weirdness in the mac, I think it happens every time there's a xul generated row.
13:07 bshum Like looking at z39.50 import lines
13:07 bshum Or item status
13:07 bshum Or checkouts
13:07 bshum Or pretty much anything
13:07 bshum I've never seen it before.
13:07 bshum So I'm wondering if it's some interaction with the stock install of Evergreen that's different than our actual production builds.
13:07 bshum The thing I'm pondering is the fake # column
13:07 bshum Since we don't enable that in our systems
13:08 bshum But this stock system did have those.
13:09 bshum Random observation.  The default index page for the staff client points at the communications.php page on the website.
13:10 bshum When we migrate the websites, we'll have to account for stuff like that too.
13:11 bshum Another thing is any files pulled during installation that are sourced from open-ils.org hosting too.
13:13 tsbere I think we have a file during packaging that is pulled from there, but I don't know about installation.
13:15 bshum libdbi-0.8.3 is pulled from http://open-ils.org/~denials/evergreen
13:15 bshum As part of the makefile.install
13:16 ericar joined #evergreen
13:16 tsbere Huh. Didn't notice that one.
13:16 * tsbere was thinking about dojo
13:17 bshum I know, I didn't think of it either till I was watching a fresh install roll by and saw it.
13:17 bshum I'm adding these things to lists of things to watch for while poking at our website conversions.
13:17 bshum aka, things I hope not to break
13:24 yboston kmlussier:  yes, it is OK to set bug 1000957 to Won't Fix in light of new bib/authority browse
13:24 pinesol_green Launchpad bug 1000957 in Evergreen "TPAC is missing the authority browse feature" (affected: 8, heat: 38) [Wishlist,Confirmed] https://launchpad.net/bugs/1000957
13:24 kmlussier yboston: I figured if there was something the early authority browse did that the bib browse doesn't do, it could be submitted as a separate bug.
13:24 kmlussier yboston++
13:27 * csharp thinks we should make modest moves towards actual deb/rpm repos for EG dependencies
13:31 Dyrcona csharp: +1
13:53 * bshum wonders what constitutes "several minute period of inactivity"
13:53 bshum bug 1218002
13:53 pinesol_green Launchpad bug 1218002 in Evergreen "Postal code does not populate city/state after period of inactivity" (affected: 2, heat: 10) [Undecided,New] https://launchpad.net/bugs/1218002
13:54 * bshum tries again, waiting for 10 minutes
14:05 jboyer-isl I suspect it's based on your staff login timeout period. My previous lib set it to 10+ hours because it was obnoxious. The default here is considerably less (and much more irritating)
14:05 bshum Okay, 10+ minutes later and I can still punch in a zip code to a register patron screen and get stuff.
14:06 bshum Yeah that's what I was suspecting too.
14:06 bshum Ours is set to something like 8 hours.
14:06 jboyer-isl Quite the wait, heh. :)
14:06 bshum Indeed.
14:06 bshum I'm going to comment on the bug to gather some more details and note this suspicion.
14:07 * csharp suspects memory leak interference
14:07 kmlussier I was thinking it was the login timeout period too. But, then, wouldn't they come across other problems if their login had timed out?
14:07 kmlussier For example, would they even be able to save the patron record that they're adding?
14:07 csharp kmlussier: they would not
14:07 jboyer-isl Sounds like like a memory sieve-hat conspiracy theory to me, csharp. ;)
14:08 * csharp retreats to his cabin in the woods
14:09 jboyer-isl Depending on the interface the client will ask for a new session, throw up an error, or do nothing. I don't think the patron interface will ask for a new session, but I'm not sure which of the other two will happen.
14:19 bshum Could be brick weirdness?  Like what if they rotated bricks and the zip file wasn't installed or shared to all of them.
14:19 * bshum shrugs, goes back to loading student records
14:25 * rfrasur tries to track down water leak as reflected in utility bills.
14:27 jeff_ rfrasur: running toilet in need of maintenance, or rogue after-hours carwash.
14:28 rfrasur well....we had several leaks fixed last month...and maybe it was those.  I just need to double check something with the utility.
14:29 * rfrasur never envisioned facilities maintenance as a job description.
14:32 rfrasur well...not for me at least
14:34 mrpeters i might have a nice water bill this month.....been watering since 8:30 haha
14:34 mrpeters TruGreen said to water all day today for the stuff they put down
14:34 mrpeters sorry if i'm leeching your water rfrasur
14:36 rjackson-isl part of our lawn was watered by a fire hydrant left on to relieve pressure on a broken water main yesterday :-(
14:36 rfrasur lol, no...it wasn't that.  <insert_relief>  It was the plumbing stuff from last month and the town will let us appeal the 10x bill
14:36 mrpeters nice rjackson-isl!!!
14:36 rjackson-isl flooded from fron to back...
14:36 mrpeters free watering!
14:36 mrpeters we need it!
14:36 rjackson-isl hope I don't pay for that usage!!!
14:36 * rfrasur has well water at home and lives over an underground lake (no lie).
14:36 mrpeters haha yeah, im sure you could argue that one!
14:37 rfrasur we just pay to pump it out of the ground.
14:37 mrpeters very cool
14:37 rfrasur lol, and soften it...and remove rust
14:37 rjackson-isl need that set up again - had it in KOkomo - well and city...
14:37 rfrasur but other than that...
14:37 mrpeters i want to buy an irrigation system
14:38 rfrasur I hate paying for something that basically composes most of the world...but alas
14:38 mrpeters eh, its fair to pay for it in my eyes...its a limited resource i guess
14:38 mrpeters if only it were combustable for our cars....haah
14:39 rfrasur well....it is POSSIBLE...but still a little cost prohibitive.  Plus, then it'd get more expensive.
14:39 mrpeters hey rjackson-isl: while you're here....will you ask adbowling-isl to ping me when he has a sec
14:40 rjackson-isl sure
14:40 rfrasur It'd be like Dune and Chain Reaction
14:40 mrpeters thanks!
14:40 mrpeters actually, even better if we could do a group chat in your channel
14:42 rfrasur okay....crisis mode cancelled.  Time to go parent.
14:47 mrpeters is there a function to get the normalized isbn for a bre.marc?  say, stripping out all extra characters, spaces, etc.
14:47 dboyle joined #evergreen
14:51 phasefx anyone using windows 8 with the staff client?  Does it randomly crash?
14:52 phasefx (the client or windows, but mostly the client:)
14:52 mrpeters windows 8--
14:52 jboyer-isl phasefx: Worked fine for me since Win8 came out.
14:52 mrpeters i tested it a little, phasefx, back in 2.2 days
14:52 mrpeters i ran it in a VM for a while while it was in beta
14:52 mrpeters dont recall any strange crashes
14:52 mrpeters but that was before the new xulrunner stuff
14:53 phasefx gracias
14:53 jboyer-isl Ah, yeah. Even today I'm still running 2.2 and it's associated xulrunner on Win8. Haven't tried anything newer yet.
15:00 mrpeters jboyer-isl: did they force yall onto win 8?
15:08 bshum phasefx: I think there are a few libs using Win8 now and I haven't heard any reported issues with the client.  Our master is roughly around where 2.4.1 left off.
15:08 bshum Though we'll be upgrading again next weekend.
15:10 phasefx bshum: roger that, thanks
15:10 jboyer-isl No, no. I ran it for a while at JCPL, and picked up a new core i7 laptop to do some dev work at home. I think it's got a place, and that place is on tablets. Maybe 8.1 will improve the desktop experience a bit in October.
15:13 jboyer-isl mrpeters: can you really imagine the state moving on something that fast? Win9 isn't even out yet! ;)
15:13 mrpeters hahaha
15:14 mrpeters we got win7 pretty fast actually
15:14 jboyer-isl That gives me hope. I don't like using ancient releases (the businesses still running xp baffle me).
15:15 bshum Well, the mac line rendering glitch happens even without the # rows
15:15 bshum Too bad, that would have been easy :(
15:15 bshum Must be some other weird xul 14 + mac issue
15:38 sseng joined #evergreen
15:53 kmlussier joined #evergreen
15:58 acoomes joined #evergreen
16:01 kmlussier Dyrcona: Am I remembering correctly that you have a SQL query to delete copies that are in a specific copy bucket?
16:01 bshum Sounds like an easy one.
16:02 jeff famous last words... ;-)
16:02 * bshum likes deleting things.
16:02 bshum It's bringing them back that I find annoying.
16:03 Dyrcona kmlussier: If it isn't in here http://git.mvlcstaff.org/?p=jason/​evergreen_utilities.git;a=summary then it is in my private collection.
16:04 Dyrcona I'm too busy ATM to dig through my private collection.
16:04 kmlussier Dyrcona++ It's there. Thanks!
16:04 Dyrcona It is in there, and it's Perl.
16:08 bshum @wunder 76015
16:08 pinesol_green bshum: The current temperature in Turf Club Estates, Arlington, Texas is 93.7°F (3:08 PM CDT on August 28, 2013). Conditions: Clear. Humidity: 41%. Dew Point: 66.2°F. Pressure: 30.02 in 1016 hPa (Falling).
16:11 gsams not too bad today down in Texas
16:11 gsams I feel sorry for our AC repairman on the roof at the moment
16:12 kmlussier Dyrcona: When you use this script, if it's the last copy belonging to a volume, will it delete the volume and, if it's the last volume belonging to the bib, will it delete the bib? I know there normally are OU settings to control this, but I didn't know if they came into play if you're deleting outside the staff client.
16:12 kmlussier Dyrcona: If you're too busy to answer now, I can take my answer tomorrow. :)
16:12 Dyrcona kmlussier: The settings do come into play with that script. It uses the standard backend calls that the client would make.
16:13 kmlussier Dyrcona: Awesome! Thanks!
16:14 Dyrcona kmlussier: It may bypass the setting and do the delete anyway. I seem to recall setting the flag to do that without checking the settings.
16:14 kmlussier Dyrcona: I think that's fine too. They just want to make sure the bib is deleted if all the copies are deleted.
16:16 bshum gsams: Yeah I'll be sure to pack lighter and maybe bring a fan or something :)
16:19 gsams bshum: visiting on business again?  It's actually been pretty cool by comparison to most summers.  We've had a lot more rain and cloud cover this year.
16:20 bshum Just "vacation"
16:22 senator bshum: i can't remember whether bbq tickles your fancy or not, but if you try pecan lodge bbq at the dallas farmers' market, please report back :-)
16:22 bshum senator: I have a feeling my folks will drag me to some chinese restaurant or something.
16:22 bshum But if I can persuade them otherwise, I'll add it to the list :)
16:23 senator well fair warning then since your family's involved: it's lunch-time only with a long wait
16:23 Dyrcona @hate vacation
16:23 pinesol_green Dyrcona: The operation succeeded.  Dyrcona hates vacation.
16:23 gsams tha's right around the corner from our Colo center
16:24 gsams wish I could spare the time to take a visit myself but long wait times will probably keep me away
16:25 senator gsams: got any other favorite places then? i visit dfw every 'casionally
16:27 gsams I'm based in the city of Roanoke, halfway between Fort Worth and Denton roughly
16:28 bshum "the unique dining capital of texas"
16:28 gsams Most of what we have in Roanoke is actually pretty solid and varies greatly
16:28 bshum It says so on their logo and everything!  :D
16:29 gsams yeah, my current favorite is Tacos and Avacados
16:29 gsams I don't care for avacados, but the other half is that good
16:30 Dyrcona Send lawyers, guns and tacos!
16:30 senator i'll remember that. i'm usually east of there, but i do like tacos and avocados
16:31 gsams We also have a Hard-8 barbecue that I've heard is really good, I haven't had a chance to eat there yet myself
16:32 gsams Our library regularly has brochures for the restaurants here but I haven't seen one in a while.  They might be revamping them.
16:33 gsams I'd go on, but I'm afraid I'll just make myself crave something I can't have today
16:33 senator yeah i'm getting prematurely hungry myself :-)
16:46 dboyle joined #evergreen
16:50 kmlussier We were talking today about deleting MARC records, specifically electronic resources, in batch. We started by looking at whether Record Buckets could handle it. However, we noticed when we did a record query through a bucket, it only retrieves 100 records. Is there any way to retrieve results beyond that 100 records?
16:51 kmlussier I know SQL is probably the better route to take, but I wanted to explore all of our options.
16:51 phasefx there's a line in the javascript that applies the cap
16:52 phasefx IIRC
16:52 phasefx record_buckets.js, line 888:  [ { 'limit' : 100 }, x.value, 1 ]
16:53 phasefx could remove that limit altogether, just use  [ {}, x.value, 1 ]
16:53 phasefx don't know how the client would handle very large result sets.  That interface was an experiment I slipped in before we started using topic branches
16:54 kmlussier phasefx: Yeah, that's what I was wondering. In some cases, a library might have thousands of records associated with  a subscription.
16:54 * phasefx thinks batch deletion of records through record buckets would eventually hit a practical limit
16:54 kmlussier If they cancel a subscription, that would be a lot of records to delete.
16:55 phasefx a practical limit that might not be very practical, that is
16:56 kmlussier So I'm guessing most sites that want to delete a few thousands (or more) electronic resources use SQL.
16:57 kmlussier Does anyone have a query we could use as a starting point?
16:57 phasefx what's the easiest way to select the records?  a report?  manual collection into buckets?
16:59 kmlussier phasefx: Possibly a report, but I think it would be easy enough for them to do a Select query to get a list of record ID's. Manual collection into buckets might be difficult.
17:00 phasefx oh, pooh, the bucket thing seemed easy: DELETE FROM biblio.record_entry WHERE id IN (SELECT target_biblio_record_entry FROM container.biblio_record_entry_bucket_item WHERE bucket = # );
17:00 phasefx assuming no call numbers and copies on the bibs
17:01 tsbere As a general note, MVLC decided to load electronic resource records under different bib sources. So we can wipe them out by bib source. ;)
17:01 bshum Likewise for us
17:02 bshum I know Mary set up new bib sources for things like Overdrive, etc.
17:02 kmlussier phasefx: I can always check. If we remove that constraint limiting the number of records we can retrieve, it might be possible.
17:02 bshum To make them easier to target with SQL
17:02 kmlussier tsbere, bshum: Yes, we were just discussing that option today. But they don't have the separate records source for their electronic records ATM.
17:05 phasefx kmlussier: so in the query case, just DELETE FROM biblio.record_entry WHERE id in ( sub-select here );  I doubt that would handle $9-powered 856 tags though, since those create call numbers behind the scenes
17:06 bshum Should be easy enough to target those later for deletion though.
17:06 phasefx for a report, you can have the report output bib id's as a text file, and load the file into a staging or temporary table, and query that table for your sub-select
17:07 phasefx CREATE TABLE foo ( id BIGINT ); \COPY foo FROM 'file.txt'
17:08 phasefx of course, IMO, long term, we want server-side batch actions for buckets, and easy population of buckets from reports :)
17:11 kmlussier phasefx++ # We do too.
17:12 kmlussier phasefx++ tsbere++ bshum++ Thanks for the help!
17:13 gsams phasefx: that would be amazing!
17:21 mmorgan1 left #evergreen
17:25 tmccanna joined #evergreen
17:25 tmccanna left #evergreen
17:26 tmccanna_ joined #evergreen
18:39 stevenyvr2 joined #evergreen
18:45 BigRig joined #evergreen
19:13 RBecker joined #evergreen
20:12 acoomes_ joined #evergreen
20:12 smyers__ joined #evergreen
20:25 stevenyvr2 left #evergreen
22:50 smyers_ joined #evergreen
23:16 stevenyvr2 joined #evergreen
23:16 stevenyvr2 left #evergreen
23:50 mtate joined #evergreen

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