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

Wed May 30 17:46:30 EDT 2012

Oh!  Yes, I'd rather get a script instead, too.   :)
Katie

>>> "Hardy, Elaine" <ehardy at georgialibraries.org> 5/30/2012 11:32 AM >>>

Unfortunately, the 856 will be different for about 6000 records we are bringing in for our Overdrive libraries. We will probably add the necessary info via a script rather than this route. 
Thanks!

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

ehardy at georgialibraries.org
www.georgialibraries.org
http://www.georgialibraries.org/pines/

From: Katie Wallis [mailto:KWallis at cgcc.cc.or.us] 
Sent: Wednesday, May 30, 2012 1:51 PM
To: ehardy at georgialibraries.org; open-ils-general at list.georgialibraries.org
Subject: Re: Question about MARC Batch edit

Hi Elaine,

Adding the 9 26 times is what I would have thought of doing too.  I fiddled around and couldn't get the right results except by the way your figured out- leaving out the z and 9 from Subfields (option).  I think you were doing it correctly.  

If you want a work-around until the bug is fixed, you could enter the entire 856 as you want in a new separate 856 field, as in below-

Action (Rule Type): Add

MARC tag: 856

Subfields (option): 

MARC Data: 856 40$uhttp://GADD.lib.overdrive.com/ContentDetails.htm?ID=CE3E7B9F-22CB-4808-A6CE-52E4F7B811D5 $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

And then delete the original 856 field.  You might be able to delete this 856 field in the same batch edit by adding a second rule with Add Merge Rule.  I've never tried deleting a field that I'm filtering by at the same time before, but you could try it on one or two records to see if it works.  Otherwise, you'd have to have a second step to remove the first 856.

Katie

Date: Wed, 30 May 2012 10:23:55 -0400 (EDT)
From: "Hardy, Elaine" <ehardy at georgialibraries.org>
Subject: Re: [OPEN-ILS-GENERAL] Question about MARC Batch edit
To: "'Evergreen Discussion Group'"
<open-ils-general at list.georgialibraries.org>, "Evergreen Catalogers"
<evergreen-catalogers at list.evergreen-ils.org>
Message-ID: <00a301cd3e6f$d85232d0$88f69870$@georgialibraries.org>
Content-Type: text/plain; charset="us-ascii"

Kathy,

I followed your instructions but did not get the desired results. It
appears that you cannot add multiple instances of the same subfield via
the MARC batch edit to an existing field. At least, I was unsuccessful
adding multiple $9s. 

When I did this:

Action (Rule Type): Add

MARC tag: 856

Subfields (option): z9

MARC Data: 856 \\$z ( file:///\$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

I get this:

=856
40$uhttp://GADD.lib.overdrive.com/ContentDetails.htm?ID=CE3E7B9F-22CB-4808
-A6CE-52E4F7B811D5$zAccess Georgia Download Destination$z (Patrons of
participating GADD libraries please click
here).$9ARL$CHRLCRLS$CPRLDTRL$DCPLECGR$ECPLFRRLS-FA$FRRLSHCLS$HOULBRL$OCRL
-DUBLNLEE$MRLSOHOOP$RMLSHRL$SGRLSWGRL$STRLTCPLS$THRLTLLS$WORTH

While the delimiter symbol is added, the 9 is only added to the first one,
making the immediately following library policy name the subfield tag
everywhere else.

I tried putting spaces on either side of $9, a space in front of the $9s
with none after, no space before but one after, and then no spaces; but,
the result was always the same. I thought perhaps I needed as many 9s as
there were instances in the field (26 in this case) in the Subfields
(option) datawell. That resulted in 26 repetitions of the above. So then I
added nothing in the subfield datawell (since it says option) and that
resulted in an additional 856 being added (which makes sense), with the
$9s correctly formatted:

=856 \\$a\\$z(Patrons ( file:///\$az(Patrons ) of participating GADD libraries please click
here).$9ARL$9CHRL$9CRLS$9CPRL$9DTRL$9DCPL$9ECGR$9ECPL$9FRRLS-FA$9FRRLS$9HC
LS$9HOU$9LBRL$9OCRL-DUBLN$9LEE$9MRLS$9OHOOP$9RML$9SHRL$9SGRL$9SWGRL$9STRL$
9TCPLS$9THRL$9TLLS$9WORTH

If I am doing this correctly, I will open a bug report. 

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

<mailto:ehardy at georgialibraries.org> ehardy at georgialibraries.org

<http://www.georgialibraries.org/> www.georgialibraries.org

<http://www.georgialibraries.org/pines/>
http://www.georgialibraries.org/pines/

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:///\$z ) <file:///\\$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

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20120530/6c6e5bd1/attachment.htm>

End of Open-ils-general Digest, Vol 71, Issue 79
************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20120530/c1679243/attachment-0001.htm>