Evergreen ILS Website

IRC log for #evergreen, 2015-12-22

| 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
07:50 collum joined #evergreen
07:53 _bott_ joined #evergreen
07:56 potion joined #evergreen
07:57 potion left #evergreen
07:57 rjackson_isl joined #evergreen
08:13 jboyer-isl Dyrcona++
08:13 jboyer-isl I'd @quote that if I could.
08:39 rlefaive joined #evergreen
08:47 Dyrcona joined #evergreen
08:53 Dyrcona Well, that's nice: Argument "The" isn't numeric in integer division (/) at /usr/share/perl5/MARC/Record.pm line 407.
08:54 Dyrcona That's not from MARC export, so I guess I'll need to trap that and see what record produced it.
08:54 maryj joined #evergreen
08:57 Dyrcona Hmm. Might be from marc_export after all....
09:05 Dyrcona So, coming from an insert_grouped_field call in marc_export....
09:06 Dyrcona Ah, when adding items on line 473.
09:06 Dyrcona The record must have a bad field.
09:16 Dyrcona Warning from bibliographic record 1635630: Argument "The" isn't numeric in integer division (/) at /usr/share/perl5/MARC/Record.pm line 407.
09:16 Dyrcona is a lot more useful. :)
09:17 jboyer-isl What is it doing that there would be any math done at all, never mind math done on fields that haven't been checked for numeric-ness?
09:18 jboyer-isl (I suppose I could look that up, what with the line numbers right there.)
09:18 Dyrcona Line 407 of MARC::Record is in the insert_grouped_fields method.
09:18 Dyrcona It is doing the math to determine where the inserted field(s) belong(s).
09:19 Dyrcona That record has a summary field (should probably be a 520?) with a tag of 'The'.
09:20 Dyrcona @marc 520
09:20 pinesol_green Dyrcona: Unformatted information that describes the scope and general contents of the materials. This could be a summary, abstract, annotation, review, or only a phrase describing the material. (Repeatable) [a,b,u,3,6,8]
09:20 Dyrcona Yep, that looks to me what it ought to be, but I'll let the catalogers determine that.
09:21 jeff @marc The
09:21 pinesol_green jeff: unknown tag The
09:21 jeff heh
09:22 * Dyrcona loves searching for The The in databases with stop words. :)
09:23 Dyrcona @tea
09:23 * pinesol_green brews and pours a pot of Wild Snow Sprout Tea, and sends it sliding down the bar to Dyrcona (http://ratetea.com/tea/wild-tea​-qi/wild-snow-sprout-tea/6447/)
09:23 Dyrcona "Wild Snow Sprout," eh....
09:23 * Dyrcona looks at the rain out the window.
09:25 Dyrcona And RT ticket 5144 created....
09:25 Dyrcona Hmm. I made a branch to make that change. Maybe I should trap warnings around all calls to MARC::Record in marc_export and then make a LP bug?
09:29 Dyrcona Oh, I see what happened....
09:29 Dyrcona The tag is The
09:29 Dyrcona in1 is A and ind2 is d
09:30 Dyrcona $a begins: ventures of....
09:30 tsbere Fun.
09:30 tsbere Brand new record, too, looks like.
09:30 Dyrcona And, looking at the subfields, it is probably not a 520.
09:31 Dyrcona Yep.
09:32 Dyrcona It's what we call a "brief" record. It will get overlaid from OCLC eventually.
09:32 mrpeters joined #evergreen
09:32 Dyrcona It has the local 590.
09:33 Dyrcona @marc 550
09:33 pinesol_green Dyrcona: Information about the current and former issuing bodies of a continuing resource. (Repeatable) [a,6,8]
09:33 Dyrcona @marc 650
09:33 pinesol_green Dyrcona: A subject added entry in which the entry element is a topical term. (Repeatable) [a,b,c,d,e,v,x,y,z,2,3,4,6,8]
09:33 Dyrcona @marc 500
09:33 pinesol_green Dyrcona: General information for which a specialized 5XX note field has not been defined. (Repeatable) [a,3,5,6,8]
09:34 * Dyrcona is trying to remember what field the titles of a compilation go into.
09:34 Dyrcona That's the field this should be.
09:38 csharp @blame [marc 500]
09:38 pinesol_green csharp: General information broke Evergreen. for which a specialized 5XX note field has not been defined. (Repeatable) [a,3,5,6,8]
09:39 maryj_ joined #evergreen
09:40 Dyrcona csharp++
09:40 Dyrcona heh.
09:40 Dyrcona @blame [marc The]
09:40 pinesol_green Dyrcona: unknown tag The is why we can never have nice things!
09:40 tsbere @blame [quote random]
09:40 pinesol_green tsbere: Quote #62: "< Dyrcona> À propos a migration from TLC: If you have a column called TOTALINHOUSEUSES you should also have TOTALOUTHOUSEUSES must eat cottage cheese! for symmetry's sake." (added by csharp at 11:49 AM, July 22, 2013)
09:41 kmlussier @quote add <Dyrcona> ASCII stupid question; get a stupid ANSI. :)
09:41 pinesol_green kmlussier: The operation succeeded.  Quote #135 added.
09:43 * kmlussier just remembered that she created a branch for bug 1436797 last summer, but never posted it to the bug.
09:43 pinesol_green Launchpad bug 1436797 in Evergreen ""grocery" term confuses frontline staff and patrons" [Undecided,New] https://launchpad.net/bugs/1436797
09:43 kmlussier Maybe I'll be able to find it in time for 2.10
09:45 Dyrcona That quote would a good response for dunno.
09:45 Dyrcona There's a verb missing there.... ;)
09:45 csharp sounds Shakespearean ;-)
09:46 kmlussier Dyrcona: Yeah, now that you mention it, it would make a good dunno.
09:52 Dyrcona The quote would a good response for dunno make. # For Shakespeare's sake.
09:52 maryj joined #evergreen
09:53 Dyrcona Anyway, I bugged it and posted my patch: lp 1528596
09:53 pinesol_green Launchpad bug 1528596 in Evergreen "Another untrapped marc_export warning" [Undecided,New] https://launchpad.net/bugs/1528596
09:53 Dyrcona My work is done. I can go home, right?
09:56 kmlussier Dyrcona: I hereby grant you permission to go home
09:59 jwoodard joined #evergreen
10:02 csharp Dyrcona++
10:03 csharp getting the ID in cases like that will make a huge difference
10:06 tsbere joined #evergreen
10:11 Dyrcona I consider that a new feature, but it would back port very easily if you're on 2.9 or have backported the previous warning fixes.
10:18 maryj joined #evergreen
10:21 bshum Dyrcona++
10:21 berick joined #evergreen
10:37 ohiojoe joined #evergreen
10:40 ohiojoe joined #evergreen
10:45 Dyrcona joined #evergreen
11:11 Christineb joined #evergreen
12:05 csharp I'm trying to identify records that have a tag 505 subfield $r - is there an efficient way to do that without using metabib tables?
12:06 csharp i.e., I'd like to search the MARCXML
12:09 jeff the efficient way i'd suggest is using metabib tables.
12:11 jeff SELECT DISTINCT record from metabib.real_full_rec WHERE tag = '505' AND subfield = 'r' ORDER BY record;
12:11 jeff That query is reasonably fast for me.
12:11 jeff Time: 194.155 ms
12:11 jeff 3286 rows
12:13 jeff csharp: Why were you hoping to avoid using metabib tables?
12:13 * berick bets csharp means "no reindexing"
12:13 jeff Are you looking to include deleted bibs?
12:13 jboyer-isl jeff: If I were to guess, to find records so broken they don't ingest properly.
12:14 jeff jboyer-isl: ah. good possibility.
12:18 dbs Or to find the original values of the subfields, not the munged versions perhaps?
12:20 jeff Ah. There had been no mention made of the values themselves. :-)
12:23 jeff I think you're in the realm of "write a function", "export the records", or http://stackoverflow.com/a/1732454/157515
12:24 jeff actually, you could probably pull it off with existing xpath functions.
12:36 bmills joined #evergreen
12:40 Dyrcona jeff: Classic stackoverflow.
12:40 jeff csharp: this will probably catch everything you need, but will take some time to execute. there might be a faster way: SELECT id FROM biblio.record_entry WHERE xpath_exists('//marc:record/marc:datafiel​d[@tag="505"]/marc:subfield[@code="t"]', marc::XML, ARRAY[ARRAY['marc', 'http://www.loc.gov/MARC21/slim']]);
12:40 Dyrcona I imagine the author pwns one fo these: https://plus.google.com/+ReverendEric​Ha/posts/Qn4aTEytdqn?pid=623115200997​6367506&amp;oid=103046039519355433778
12:41 jeff csharp: actually, you'll want to add a criteria to attempt to avoid invalid xml.
12:44 jeff SELECT id FROM biblio.record_entry WHERE xml_is_well_formed(marc) AND xpath_exists('//marc:record/marc:datafiel​d[@tag="505"]/marc:subfield[@code="t"]', marc::XML, ARRAY[ARRAY['marc', 'http://www.loc.gov/MARC21/slim']]);
12:44 Dyrcona jeff: have you seen much invalid xml in your marc records?
12:44 jeff found at least one just now.
12:46 Dyrcona I'm running select id from biblio.record_entry where not xml_is_well_formed(marc) on my development database right now to see what I find.
12:46 phasefx hrmm, there should be a a_marcxml_is_well_formed trigger on bre
12:47 jeff immediate 500 error on supercat marcxml retrieval, mods takes a bit to return an empty collection, standard catalog page returns quickly (but mostly broken), and the MARC Record view in the catalog seems to take a while too.
12:48 jeff delays might be unrelated, but i wonder if something gets... stuck.
12:48 Dyrcona Well, I get an empty set back, so....
12:48 jeff dies so hard it doesn't return a response and the client times out waiting on the service.
12:49 Dyrcona yep. I can see that happening with malformed xml.
12:52 csharp wow - thanks to all of you for helping - I got pulled away just after asking the question
12:53 csharp my use case is that we want to map the 505 $r to author search and it looks like the records with that tag/subfield need reingesting
12:53 jeff csharp: then go with my original suggestion, unless you have some other reason for avoiding the metabib tables. :-)
12:54 jeff Dyrcona: two bre entries with invalid XML here.
12:55 Dyrcona jeff: Old ones?
12:55 jeff Feb 2009 :-)
12:55 csharp jeff: thanks!
12:56 * csharp just read jeff's stackoverflow link :-D
12:57 jeff it's a favorite.
12:57 csharp the Moderator's Note is almost as amusing as the post
12:58 Dyrcona yep. That's a favorite of mine, too.
13:00 jeff and indeed the trigger to prevent invalid xml is present.
13:01 csharp @love felafel
13:01 pinesol_green csharp: The operation succeeded.  csharp loves felafel.
13:02 jwoodard @librarian
13:02 pinesol_green jwoodard: Management:11, Cataloging:14, Acquisitions:13, Reference:12, Circulation:8, Systems:15, Research:11, Custodial:13
13:02 Dyrcona @dnd
13:02 pinesol_green Dyrcona: strength:6 dexterity:10 constitution:7 intelligence:11 wisdom:11 charisma:16
13:02 jwoodard Looks like I'm average for the holidays.
13:03 * Dyrcona prefers point-buys. :)
13:04 jwoodard My constitution feels like a 7 today. It is in the 70s yet I have winter illnesses.
13:04 jwoodard @weather 76227
13:04 pinesol_green jwoodard: Aubrey, TX :: Clear :: 67F/19C | Tuesday: Abundant sunshine. High near 70F. Winds SSE at 10 to 20 mph. Tuesday Night: Partly cloudy this evening, then becoming cloudy after midnight. A stray severe thunderstorm is possible. Low 59F. Winds SSW at 15 to 25 mph. | Updated: 11m ago
13:08 csharp @weather 30345
13:09 pinesol_green csharp: Atlanta, GA :: Fog :: 60F/16C | Tuesday: Foggy. A stray shower or thunderstorm is possible. High 68F. Winds light and variable. Tuesday Night: Periods of rain. Low 58F. Winds SE at 5 to 10 mph. Chance of rain 100%. Rainfall may reach one inch. | Updated: 9m ago
13:36 Dyrcona @weather 01845
13:36 pinesol_green Dyrcona: North Andover, MA :: Overcast :: 54F/12C | Tuesday: Rain likely. High 54F. Winds SW at 10 to 15 mph. Chance of rain 80%. Tuesday Night: Partly cloudy. Low near 40F. Winds WSW at 5 to 10 mph. | Updated: 24m ago
13:37 Dyrcona I would say chance of rain 100%, but otherwise...
13:43 kmlussier @weather 02771
13:43 pinesol_green kmlussier: Seekonk, MA :: Rain :: 59F/15C | Tuesday: Rain likely. High 58F. Winds SW at 10 to 20 mph. Chance of rain 90%. Tuesday Night: Partly cloudy skies. Low 43F. Winds WSW at 10 to 15 mph.
13:43 kmlussier It says 59, but it feels much colder.
14:03 gmcharlt joined #evergreen
14:03 gmcharlt joined #evergreen
14:32 kmlussier @quote random
14:32 pinesol_green kmlussier: Quote #54: "csharp gobbles up commit bits ᗧ - - - - - - - - -" (added by gmcharlt at 11:36 AM, April 19, 2013)
14:37 csharp pacman!
15:35 ohiojoe joined #evergreen
15:37 ohiojoe I know I'm trying my luck asking in channel on a holiday week, but does anyone avaliable know, in Library Settings, the "OPAC: Patron Self-Reg. Expire Interval" is a numeric value, but no indication as to whether it is days, hours, minutes, or seconds
15:37 ohiojoe My guess would be that it would either be days or seconds, depending on how it was written..
15:37 ohiojoe does anyone know which it is off hand?  I should mention this is in 2.7.1
15:37 bshum Offhand, not really
15:37 berick ohiojoe: it's an interval
15:37 bshum But it's something we can find out!
15:38 berick so, yes, you can use days, weeks, etc.
15:38 bshum Or you know berick is awesome, berick++
15:38 ohiojoe oh, hmm.
15:39 berick based on postgres interval type.
15:39 jboyer-isl ohiojoe: berick means you can use values lik '3 weeks' or '5 days', etc.
15:39 berick so you can say things like "1 month" "2 weeks" "5 days 6 hours", etc.
15:40 berick beat me to it
15:40 bshum '86400 seconds'
15:40 ohiojoe oh wow, so it'll understand plain english more or less then..  cool
15:40 ohiojoe thank you everyone  berick++  bshum++ jobyer-isl++
15:41 berick holiday_warriors++
15:41 jboyer-isl vacation? bah humbug!
15:41 ohiojoe no kidding..  I figured maybe someone would be lurking, but possibly not
15:42 jboyer-isl (not really, send dog with whiskey barrel on its collar)
15:42 ohiojoe although, that said, I do find that it's a lot easier to get some things done over the holiday periods like this than others..
15:42 ohiojoe the public and cold-calling vendors are busy off doing other things apparently..
15:51 Dyrcona pivot_on_reports--
15:51 Dyrcona kill -9: The UNIX equivalent of "Kill it! Kill it with fire!"
16:27 jlitrell joined #evergreen
17:06 * dbwells will be out for the rest of the year, and wishes everyone a merry Christmas and happy holidays
17:07 kmlussier dbwells: Merry Christmas to you too!
17:23 kmlussier And I am also out for the rest of the year.
17:23 kmlussier Happy holidays #evergreen and best wishes for 2016!
18:01 * jwoodard wishes he was out for the rest of the year...
18:13 Christineb joined #evergreen

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