Oh! Yes, I'd rather get a script instead, too. :) Katie >>> "Hardy, Elaine" <eha...@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 eha...@georgialibraries.org www.georgialibraries.org http://www.georgialibraries.org/pines/ From: Katie Wallis [mailto:kwal...@cgcc.cc.or.us] Sent: Wednesday, May 30, 2012 1:51 PM To: eha...@georgialibraries.org; open-ils-general@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" <eha...@georgialibraries.org> Subject: Re: [OPEN-ILS-GENERAL] Question about MARC Batch edit To: "'Evergreen Discussion Group'" <open-ils-general@list.georgialibraries.org>, "Evergreen Catalogers" <evergreen-catalog...@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:eha...@georgialibraries.org> eha...@georgialibraries.org <http://www.georgialibraries.org/> www.georgialibraries.org <http://www.georgialibraries.org/pines/> http://www.georgialibraries.org/pines/ From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Katie Wallis Sent: Friday, April 20, 2012 12:25 PM To: open-ils-general@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 kwal...@cgcc.cc.or.us | 541-506-6087 Katie Wallis Columbia Gorge Community College Library 400 East Scenic Drive, The Dalles, OR 97058 kwal...@cgcc.cc.or.us | 541-506-6087 >>> <open-ils-general-requ...@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" <eha...@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 ************************************************