Evergreen ILS Website

IRC log for #evergreen, 2014-09-15

| 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:41 jeffdavis joined #evergreen
01:20 cherri_ joined #evergreen
02:27 cherri_ joined #evergreen
03:59 pastebot joined #evergreen
03:59 dbs joined #evergreen
04:35 cherri_ joined #evergreen
05:48 pinesol_green` Incoming from qatests: Test Success - http://testing.evergreen-ils.org/~live/test.html <http://testing.evergreen-ils.org/~live/test.html>
07:41 cherri_ joined #evergreen
07:58 jboyer-isl joined #evergreen
08:02 eeevil joined #evergreen
08:10 artunit joined #evergreen
08:13 akilsdonk joined #evergreen
08:26 collum joined #evergreen
08:31 mrpeters joined #evergreen
08:38 Shae joined #evergreen
08:39 wjr joined #evergreen
08:39 ericar joined #evergreen
08:42 mmorgan1 left #evergreen
08:48 _bott_ joined #evergreen
08:57 mmorgan1 joined #evergreen
08:57 mmorgan1 left #evergreen
08:58 mmorgan joined #evergreen
09:00 Callender joined #evergreen
09:11 kmlussier joined #evergreen
09:15 tspindler joined #evergreen
09:16 kmlussier @coffee
09:16 * pinesol_green brews and pours a cup of Colombia La Escuelita, and sends it sliding down the bar to kmlussier
09:18 jeff morning!
09:19 kmlussier jeff: Good morning!
09:25 csharp @tea
09:25 * pinesol_green brews and pours a pot of Huang Shan Mao Feng Green Tea, and sends it sliding down the bar to csharp (http://ratetea.com/tea/teavivre/hu​ang-shan-mao-feng-green-tea/6041/)
09:29 berick joined #evergreen
09:40 Dyrcona joined #evergreen
09:43 bshum Dyrcona: Was just looking at https://bugs.launchpad.net/evergreen/+bug/1369128 and I wonder if maybe we should consider that a "bug fix" more so than a new feature.  Fixing permission issues seems more bug fixing to me anyways.
09:43 pinesol_green Launchpad bug 1369128 in Evergreen "No Permission in IDL to delete BRE via PCRUD" (affected: 1, heat: 6) [Wishlist,New]
09:43 berick been meaning to comment on that one..
09:46 yboston joined #evergreen
09:46 * bshum will wait to see berick's comments then and use this opportunity to finish getting himself to his office.
09:49 Dyrcona berick bshum: I actually suspect the permission omission was deliberate, because its easy to shoot oneself in the foot that way. However, cstore will let you delete bibs without any permission checks.
09:49 Dyrcona bshum: to answer your later: We're still using Pg 9.1 on Ubuntu 12.04.
09:50 berick cstore's job is always to do what you tell it.  it's just a DB layer
09:50 berick commented
09:55 BigRig joined #evergreen
10:11 mllewellyn joined #evergreen
10:26 ningalls joined #evergreen
10:32 Dyrcona Apropos lp 1359762: I've just discovered 16 different drones giving not connected to the network errors this morning.
10:32 pinesol_green Launchpad bug 1359762 in Evergreen "Internal Server Error Doing Keyword Basic Search for ISBN" (affected: 1, heat: 6) [Undecided,New] https://launchpad.net/bugs/1359762
10:32 Dyrcona And, an Apache reload seems to clear it up for the time being.
10:32 kmlussier yikes
10:36 Dyrcona Betcha I find 16 connections from Library Elf last night, too.
10:38 iliv joined #evergreen
10:38 iliv left #evergreen
10:38 berick Dyrcona: did my comment on 1369128 seem reasonable?
10:41 Dyrcona berick: Yes, I added a comment that a warning works for me. I'll add when I can find the time.
10:41 Dyrcona I may also change how I'm deleting copies, volumes, and bibs in the one program where I thought I needed this change.
10:51 vlewis joined #evergreen
10:54 csharp all right - wanted to query the #evergreen mental database about the sanest way to approach this... I have a request to remove/replace any 650 or 655 subfield a with the text "Talking books" or "Talking books for children" with "Audiobooks" or "Children's Audiobooks", respectively.  Replace if the "Audiobooks"/"Children's Audiobooks" headings are not yet present, remove if they are.
10:54 _bott_ joined #evergreen
10:55 csharp I'm looking for any built-in PG functions/stored procedures that would help me identify/remove/replace those fields
10:55 csharp or if it makes more sense to do something with MARC::File and the like, I'll go that direction
10:56 csharp if it were just a matter of replacement, I would just use regexp_replace() but I don't want duplicated headings
11:01 cherri__ joined #evergreen
11:02 gmcharlt joined #evergreen
11:06 collum csharp: instead of database manipulation, I usually identify the records with a sql statement, export them, change them with marcedit, and then reimport and overlay them.
11:06 collum but there may be an easier way.
11:11 tsbere csharp: Two queries, one that says "Has both, remove the one we don't want" and then a second that updates any remaining?
11:12 tsbere csharp: For "identify" I would just query real_full_rec, easier than parsing the MARC.
11:13 dbs csharp: I usually just build a little MARC::Record based SQL function and run the records through that
11:14 dbs something like evergreen.maintain_901 but as a function instead of a trigger
11:16 tsbere going the DB function route, if you really wanted to you could probably make it a trigger for insert/update and get all future records too.
11:18 Dyrcona I'd write a little something in Perl to pull the records out in a query, make the changes, and then stuff them back in. So, I'd use MARC::Record and friends, myself.
11:19 Dyrcona I'd not add a function to the database, btw. I'd write a standalone script.
11:27 dbs csharp: you could export the records from the database, have someone print them out on index cards, have someone else edit them with a red pen, and then have someone reenter them in your database too
11:29 csharp dbs++
11:29 csharp collum: tsbere: dbs: Dyrcona: thanks for the suggestions!
11:30 Dyrcona dbs++
11:30 Dyrcona One of our members still maintained their card catalog until last year or so.
11:34 csharp yeah - looks like MARC::Record will be the best way to go (either within or outside the db)
11:37 dbs Dyrcona: wow
11:40 kmlussier I wonder if bug 1206593 and bug 1356153 should be rolled into one bug about maintaining parameters when sorting a search results list.
11:40 pinesol_green Launchpad bug 1206593 in Evergreen "Depth parameter needs to be maintained when sorting search results" (affected: 1, heat: 6) [Undecided,New] https://launchpad.net/bugs/1206593
11:40 pinesol_green Launchpad bug 1356153 in Evergreen "Facet parameter needs to be maintained when sorting search results" (affected: 1, heat: 6) [Medium,New] https://launchpad.net/bugs/1356153
11:50 Bmagic Does anyone know of any library that has defined a "playaway" in EG?
11:50 kmlussier Bmagic: I think one of our consortia may have. Let me check.
11:52 kmlussier hmmm...I see video playaway, but not audio playaways. But it looks like Biblio has Playaway if you want to check with bshum.
11:53 Bmagic kmlussier: would you be able to tell me which marc attributes are setup to define the audio playaway?
11:54 kmlussier Bmagic: No, I don't know. I thought we had audio defined, but it looks like we only had the video playaways defined.
11:54 tsbere Bmagic: I will point out that, in general, I have not found a proper set of MARC for defining a "playaway" or similar item in already existing fixed fields or RDA information. Custom cataloging will, obviously, differ.
11:55 tsbere I could also be missing something, not being a cataloger myself, but I have also yet to have one of our catalogers tell me I am wrong
11:55 Bmagic tsbere: that is what I was thinking after reading this http://oclc.org/bibformats/en/0xx/007comp.html and this http://www.olacinc.org/drupal​/capc_files/playawaysPDF.pdf
11:56 tsbere Bmagic: Please note that OCLC has their own "extra" things. I only trust loc.gov for "proper" marc ;)
11:56 Bmagic From what I can tell, 2 007 fields are required
12:00 csharp Bmagic: I know PINES has some too - I can check with our cataloging expert if it would help you
12:00 Bmagic csharp: I was looking at your catalog and didnt see any but I didnt spend much time on it
12:02 Bmagic it must be "other formats"
12:02 csharp http://gapines.org/eg/opac/record/4​210283?query=playaway;qtype=keyword​;locg=156;expand=marchtml#marchtml is an example - but I'm not cataloger-y enough to judge the MARC quality ;-)
12:02 csharp you could flip through those though
12:04 Bmagic csharp: thanks!
12:09 krvmga joined #evergreen
12:19 RoganH joined #evergreen
12:19 buzzy joined #evergreen
12:23 nhilton joined #evergreen
12:27 jihpringle joined #evergreen
12:39 Dyrcona "Curiouser and curiouser," said Alice
12:40 jeff Through the Looking Glass API
12:40 RoganH Well known for it's time functions being heavily buggy, hence causing the rabbit's issues with getting anywhere on time.
12:47 bshum Bmagic: mllewellyn might know how we defined the Playaway in our system.  I know it's a local definition that she set up during our upgrade to 2.6.
12:53 jeff heh. from the playawaysPDF.pdf file linked above: ``In conclusion, it is hoped that RDA will make the question moot with its clear separation of content and carrier.''
13:01 bshum dbs: FYI, I'm going to follow your lead from the other day in IRC as far as directing potential OPW applicants to the resources you mentioned as a starting point.
13:02 bshum gmcharlt: I'm getting some applicants poking me directly on the selfcheck project too, but have to pull together something for that too.
13:02 berick bshum: mind re-sharing said resources here?
13:02 berick or pointing me at the irc logs
13:02 bshum berick: Sure!
13:02 RoganH joined #evergreen
13:03 bshum dbs' very helpful starting points were logged here:  http://irc.evergreen-ils.org/​evergreen/2014-09-13#i_123492
13:03 bshum Well, I thought they were helpful anyways :)
13:03 berick bshum++
13:03 berick thanks
13:03 berick dbs++
13:07 kmlussier bshum: Are those things that could be added to http://wiki.evergreen-ils.org/doku.php?id=opw?
13:08 bshum kmlussier: I suppose the link to the community servers is already there.
13:08 bshum kmlussier: dbs just also suggested to them to use the Firefox/Chrome dev tools to inspect / poke at the code on the pages for the mobile work.
13:15 bshum Hmm
13:15 bshum I wonder if the problem with those other catalogs and the author search links (the subfield 7/0 problem) is related to how the graphic_880s hunt works
13:16 bshum From the general mailing list discussion http://markmail.org/message/rmujlt2thy74aj2u
13:18 bshum Hmm
13:18 bshum @marc 100
13:18 pinesol_green bshum: A personal name used as a main entry in a bibliographic record. [a,b,c,d,e,f,g,j,k,l,n,p,q,t,u,4,6,8]
13:18 bshum There is no 7.
13:18 dbs bshum: maybe.
13:18 bshum :)
13:18 bshum Must be something local to those systems
13:18 dbs We have an old scraped version of the MARC docs, so don't be too sure
13:18 kmlussier bshum: She said it's what they use to link to authority records.
13:18 kmlussier Instead of subfield 0
13:18 dbs but http://www.loc.gov/marc/bibliographic/bd100.html concurs
13:18 bshum dbs: Well I looked up 100 on the site too
13:19 bshum Okay, cool :)
13:19 dbs yeah, sounds like our USMARC out-of-the-box defaults might not suit a non-USMARC situation
13:19 bshum I would imagine that if they edit the misc_util.tt2 to ignore 7 as well during the get_graphic_880 dance, that might solve their display issue.
13:20 * bshum supposes he *could* test it...
13:20 bshum By making a weird fake record somewhere
13:22 dbs where's that database-indexes == display-fields thing at
13:22 berick bug 1251394
13:22 pinesol_green Launchpad bug 1251394 in Evergreen "Metabib Display Fields" (affected: 3, heat: 16) [Wishlist,Triaged] https://launchpad.net/bugs/1251394 - Assigned to Bill Erickson (erickson-esilibrary)
13:23 snigdha26 joined #evergreen
13:24 dMiller joined #evergreen
13:28 bshum Yep, adding 7 to the list of subfields to ignore in misc_util for the get_graphic_880s function gets rid of it on my test server.
13:28 bshum Guess I can write that back to them as a suggestion
13:28 bshum And maybe it's something we can add to future Evergreen versions for them.
13:30 dbs bshum++
13:30 * dbs tries to investigate the case of the short-lived z39.50 connections (incoming to Evergreen)
13:34 bshum I'm trying to figure out how to figure out why queries are slow on our DB server.
13:34 bshum Grabbing the big block to explain analyze and all it gives me is query_parser_fts :)
13:34 snigdha26 kmlussier: Hi! I've cloned the Evergreen working repository and I think I would be able to make a doc commit now. I went through the doc structure as well, like you suggested.
13:35 dbs bshum: I think the first parameter to query_parser_fts is the core of the query, IIRC
13:35 kmlussier snigdha26++
13:35 kmlussier That's good to hear. Do you see any other bitesize-docs bug that you're willing to try?
13:42 snigdha26 kmlussier: I think the punctuation bugs would be fairly simple to do https://bugs.launchpad.net/evergreen/+bug/1294299.
13:42 pinesol_green Launchpad bug 1294299 in Evergreen "Small documentation punctuation bugs" (affected: 1, heat: 6) [Undecided,New]
13:43 snigdha26 pinesol_green: I had the same thing in mind :)
13:43 pinesol_green snigdha26: What do you mean? An African or European swallow?
13:43 pinesol_green snigdha26: I am only a bot, please don't think I'm intelligent :)
13:45 kmlussier Heh. snigdha26: pinesol_green is a bot in the channel that is programmed to sometimes give automatic responses in the channel.
13:45 kmlussier snigdha26: So whenever you mention a bug in channel, it will respond with the title of the bug.
13:45 bshum @who is pinesol_green's master.
13:45 pinesol_green graced is pinesol_green's master.
13:45 kmlussier pinesol_green: I believe it.
13:45 pinesol_green kmlussier: Have you tried turning it off and back on again?
13:46 snigdha26 kmlussier: haha I had no idea :P
13:46 kmlussier snigdha26: yes, it took me by surprise the first time it started talking to me.
13:47 kmlussier snigdha26: On that bug, you might want to change the "Assigned to" column to yourself so that others know you are working on it and don't try to fix it themselves.
13:48 dkyle left #evergreen
13:51 pastebot "berick" at 64.57.241.14 pasted "for phasefx, wheezy_installer -- only run live tests if $LIVETEST?" (19 lines) at http://paste.evergreen-ils.org/12
13:51 berick phasefx: ^-- if that looks sane, i'll push it to your branch
13:52 snigdha26 kmlussier: Done that :)
13:58 snigdha26 kmlussier: I was interested in a few others but it looks like some one is already working on them. I would like to work on this bug https://bugs.launchpad.net/evergreen/+bug/1369203. It looks like no one is working on it yet.
13:58 pinesol_green Launchpad bug 1369203 in Evergreen "Documentation - image error MARC Federated Search" (affected: 1, heat: 6) [Undecided,New]
14:02 kmlussier snigdha26: I'll take a look at that list to make sure we have a good number of them that haven't already been claimed. I also have a few that came to mind today that I'll be adding.
14:02 jboyer-isl joined #evergreen
14:20 phasefx berick++ looks good to me
14:29 berick phasefx: cool, thanks for looking
14:30 phasefx push it in soon and we'll see if it works one way or another :)
14:30 berick testing by the seat of our pants!
14:41 RoganH joined #evergreen
14:42 ghost_name joined #evergreen
14:42 * ghost_name hey
14:43 kmlussier ghost_name: Hello
14:44 ghost_name I hope you'll forgive me, I'm just learning IRC after reading up on it. I use Evergreen so thought it would be a good forum to start with
14:45 kmlussier ghost_name: Welcome! Have you seen http://wiki.evergreen-ils.org/doku​.php?id=community:irc-quick-start?
14:46 ghost_name gonna look at it now
14:47 akilsdonk joined #evergreen
14:53 ghost_name thanks for sending that to me
14:56 RoganH joined #evergreen
15:10 * kmlussier initially read "compliments" as "complaints" in RoganH's e-mail.
15:11 RoganH Did I mis-spell it?  (Given how my typing is today I'm lucky it's recognized as English.)
15:12 bshum Hehe
15:12 kmlussier RoganH: No, not at all. I just misread it. Changes the whole context of the e-mail. :)
15:12 RoganH lol, yes it does
15:13 kmlussier I was getting ready to demand specifics of where it went wrong. ;)
15:13 bshum Hehe
15:14 bshum There are a few areas we still need to refine though.
15:14 kmlussier bshum: Yes, absolutely.
15:14 bshum And I still think it'd be cool to build a middle ground for certain sized tablets.
15:14 bshum But we'll get there someday.
15:14 bshum Or maybe with OPW, since that's one of the project ideas ;)
15:16 mrpeters left #evergreen
15:29 csharp @who has complaints about the mobile opac?
15:29 pinesol_green shadowspar has complaints about the mobile opac.
15:30 bshum @who loves the mobile catalog?
15:30 pinesol_green cherri__ loves the mobile catalog.
15:30 csharp @love mobile catalog
15:30 pinesol_green csharp: The operation succeeded.  csharp loves mobile catalog.
15:30 kmlussier @love mobile catalog
15:30 pinesol_green kmlussier: The operation succeeded.  kmlussier loves mobile catalog.
15:31 kmlussier @whocares mobile catalog
15:31 pinesol_green csharp and kmlussier love mobile catalog
15:50 Bmagic RoganH++ #responding to Mobile app
15:52 Bmagic Anyone versed in these tables: config.marc21_physical_characteristic_value_map and config.marc21_rec_type_map  I'm trying to understand howto find/define the 007 byte 0 (1st character)
15:52 BigRig_ joined #evergreen
15:55 gsams joined #evergreen
15:59 Stompro joined #evergreen
16:02 Bmagic if I say "config.marc21_physical_characteristic_value_map" does anyone's brain begin to suface something? Like a mind flare gun going off?
16:05 jihpringle joined #evergreen
16:06 mmorgan Bmagic: Not my area of expertise, but I am fairly sure we have never made any changes to that table.
16:08 kmlussier mmorgan: Actually, I think you may have when adding more specific formats for sound recording. Or I might be thinking of the wrong table.
16:09 kmlussier Now that I think about it, though, those changes have since been added to stock Evergreen.
16:09 Bmagic It seems to me that this table contains a definition for bytes located in the 007 field and only in the 007 field.
16:09 mmorgan kmlussier: I think it's a different table, but I'm really grasping at straws :)
16:10 bshum csharp: I don't know if you're still poking at PG 9.3, but curious if you guys have hyperthreading turned on for your CPUs in those new Dells.  I was just reading a thread where people are talking about turning it off for performance reasons.
16:10 bshum csharp: Like http://www.postgresql.org/message​-id/53F4F36E.6050003@agliodbs.com
16:10 bshum I might experiment with our next servers a bit to see if that alters our performance issues in any way
16:10 bshum *next server reconfigurations
16:11 bshum I'm still reading the thread to see what this all means though.  There's conflicting views/opinions about it right now.
16:15 kmlussier mmorgan: You're probably right.
16:16 dbwells Bmagic: What are you trying to do?  007/0 are the ptype_key column in this table: config.marc21_physical_characteristic_subfield_map
16:16 collum Bmagic:  It looks like the ptype_key column in mar21_physical_charateristic_subfield_map references the marc21_physical_characteristic_type_map
16:16 collum Oops.  jinx
16:18 csharp bshum: I'm looking into that - I'll share whatever we find.
16:18 bshum csharp: Tomorrow we're reformatting one of our Dells to use software RAID to deal with the TRIM problem.
16:18 bshum We're going to try using 12.04 to see if that helps
16:19 bshum Or maybe even go over to Debian :(
16:22 bshum I do wonder if there's anything weird with the 3.13 kernel or something.  But 12.04.5 uses that kernel on new installs, so it might not be a good test.
17:11 nhilton joined #evergreen
17:11 mmorgan left #evergreen
17:13 Bmagic dbwells: collum: Basically I am expierementing with what is possible. I would like to setup a new OPAC Icon definition which requires two 007 fields. One that starts with 'c' and one that starts with 's'
17:26 nhilton_ joined #evergreen
17:30 pinesol_green Incoming from qatests: Test Failure - http://testing.evergreen-ils.org/~live/test.html <http://testing.evergreen-ils.org/~live/test.html>
17:31 buzzy joined #evergreen
19:26 nattonerd joined #evergreen
19:29 nattonerd hello, i am new to the community, i am reading the wiki and it recommends to check “the lists”, but the link is broken.  it’s a catch
19:30 nattonerd 22.
19:36 jihpringle nattonerd: try http://evergreen-ils.org/communicate/
19:44 StomproJ joined #evergreen
19:44 bshum nattonerd: And please feel free to let us know which wiki page has the broken link on too. So that we may fix it up.
19:46 goood joined #evergreen
19:49 berick_ joined #evergreen
19:53 nattonerd joined #evergreen
20:15 fjgenus joined #evergreen
20:26 fjgenus left #evergreen
20:47 seizonsha joined #evergreen
20:55 fjgenus left #evergreen
21:03 nattonerd_ joined #evergreen
21:58 nattonerd joined #evergreen

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