| 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:datafield[@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/+ReverendEricHa/posts/Qn4aTEytdqn?pid=6231152009976367506&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:datafield[@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 |
