[OPEN-ILS-GENERAL] Question about MARC Batch edit

Fri May 18 12:41:13 EDT 2012

Hi Ian,

Thanks for the assist. Unfortunately, that didn't work for me. When I ran
it, the string "NMLSYS" still appeared in 856, subfield 9 in the MARC record
I was testing. 

Thanks for the information about the characters in the regular expression.

Mary

From: open-ils-general-bounces at list.georgialibraries.org
[mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of Ian
Bays
Sent: Friday, May 18, 2012 12:00 PM
To: open-ils-general at list.georgialibraries.org
Subject: Re: [OPEN-ILS-GENERAL] Question about MARC Batch edit

If you are trying to match exactly NMLSYS your regular expression should
probably be:
/^NMLSYS$/
The // being the start/end of the regular expression, the ^ being the start
of the field being searched and the $ being the end of that field.

I can't say I have tried that feature, but that's the regular expression.
Try it.

Ian

On 18/05/2012 16:31, Mary Llewellyn wrote: 

We'd like to do something similar, but the opposite. When one of our
libraries drops their Overdrive subscription, we'd like to be able to remove
their subfield 9 from the 856. 

So far, every time I try to tell it to remove $9 if it contains NMLSYS, all
the subfields 9 are removed. Not a happy outcome for our other libraries!

I set it up as 

Action (Rule type): Delete          

MARC tag: 856

Subfields: 9

Advanced Matching Restriction: 

Subfield: 9

Regular Expression: NMLSYS

I know I must be missing something. I've looked at the Perl Regular
Expressions documentation, but I'm not sure what I need to do. 

Any help would be greatly appreciated. 

From: open-ils-general-bounces at list.georgialibraries.org
[mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of
Katie Wallis
Sent: Friday, April 20, 2012 12:25 PM
To: open-ils-general at list.georgialibraries.org
Subject: Re: [OPEN-ILS-GENERAL] Question about MARC Batch edit

Hi Elaine,

Yes, it is possible to do that!  When you use the rule setup in MARC Batch
Edit, there's an option section called "Advanced Matching Restrictions".  So
you'd tell it to add subfields z and 9 to 856 but only where 856 has a
subfield z that contains [fill in blank].   It would look something like
this:

Action (Rule Type): Add

MARC tag: 856

Subfields (option): z9

MARC Data: 856 \\$z <file:///\\%5C%5C$z>  (Patrons of participating GADD
libraries please click here). $9ARL $9CHRL $9CRLS $9CPRL $9DTRL $9DCPL
$9ECGR $9ECPL $9FRRLS-FA $9FRRLS $9HCLS $9HOU $9LBRL $9OCRL-DUBLN $9LEE
$9MRLS $9OHOOP $9RML $9SHRL $9SGRL $9SWGRL $9STRL $9TCPLS $9THRL $9TLLS
$9WORTH

Advanced Matching Restrictions

Subfield: z

Regular Expression: Access Georgia Download Destination

Katie

Katie Wallis

Columbia Gorge Community College Library

400 East Scenic Drive, The Dalles, OR 97058

kwallis at cgcc.cc.or.us | 541-506-6087

>>> <open-ils-general-request at list.georgialibraries.org> 4/20/2012 9:00 AM
>>>

   1. Question about MARC Batch edit (Hardy, Elaine)

Date: Thu, 19 Apr 2012 14:04:47 -0400 (EDT)
From: "Hardy, Elaine" <ehardy at georgialibraries.org>
Subject: [OPEN-ILS-GENERAL] Question about MARC Batch edit

We are exploring options for adding a $z and a string of $9s to an 856 on
title records for Overdrive titles within the PINES consortium. The 856
for the specific url for each title will be provided by a vendor. Each
record will have a different 856 |u for the Overdrive url since it links
to the specific title. We want to take the provided 856 that will look
like:

856  40  ?u
http://GADD.lib.overdrive.com/ContentDetails.htm?ID=CE3E7B9F-22CB-4808-A6C
E-52E4F7B811D5 ?z Access Georgia Download Destination?

And make it look like:

856  40  ?u
http://GADD.lib.overdrive.com/ContentDetails.htm?ID=CE3E7B9F-22CB-4808-A6C
E-52E4F7B811D5 ?z Access Georgia Download Destination ?z (Patrons of
participating GADD libraries please click here). ?9 ARL ?9 CHRL ?9 CRLS ?9
CPRL ?9 DTRL ?9 DCPL ?9 ECGR ?9 ECPL ?9 FRRLS-FA ?9 FRRLS ?9 HCLS ?9 HOU
?9 LBRL ?9 OCRL-DUBLN ?9 LEE ?9 MRLS ?9 OHOOP ?9 RML ?9 SHRL ?9 SGRL ?9
SWGRL ?9 STRL ?9 TCPLS ?9 THRL ?9 TLLS ?9 WORTH

Or (only one subfield z)

856  40  ?u
http://GADD.lib.overdrive.com/ContentDetails.htm?ID=CE3E7B9F-22CB-4808-A6C
E-52E4F7B811D5 ?z Access Georgia Download Destination (Patrons of
participating GADD libraries please click here). ?9 ARL ?9 CHRL ?9 CRLS ?9
CPRL ?9 DTRL ?9 DCPL ?9 ECGR ?9 ECPL ?9 FRRLS-FA ?9 FRRLS ?9 HCLS ?9 HOU
?9 LBRL ?9 OCRL-DUBLN ?9 LEE ?9 MRLS ?9 OHOOP ?9 RML ?9 SHRL ?9 SGRL ?9
SWGRL ?9 STRL ?9 TCPLS ?9 THRL ?9 TLLS ?9 WORTH

If we use MARC batch edit to add our information, can we add it to the
specific Overdrive linked 856 in the desired records and not to all 856s
in a record? If so, how would we do that?

Elaine

J. Elaine Hardy
PINES Bibliographic Projects and Metadata Manager

Georgia Public Library Service,
A Unit of the University System of Georgia
1800 Century Place, Suite 150
Atlanta, Ga. 30345-4304
404.235-7128
404.235-7201, fax

-- 
Ian Bays
Director of Projects, PTFS Europe Limited
Content Management and Library Solutions
+44 (0) 800 756 6803 (phone)
+44 (0) 7774 995297 (mobile)
+44 (0) 800 756 6384 (fax) 
skype: ian.bays
email: ian.bays at ptfs-europe.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20120518/6334f6e6/attachment-0001.htm>