Hi all, 6000 records with bucket aren't really too much, we're updating hundreds of thousands records from 1,3 million by one batch process. Of course, it always take 2-3 hours.
Best Regards, Slava Tykhonov mailto:vty@... Software Developer of International Institute of Social History (IISG) Amsterdam, Netherlands http://socialhistory.org ________________________________________ From: [email protected] [[email protected]] On Behalf Of [email protected] [[email protected]] Sent: Tuesday, April 02, 2013 6:00 PM To: [email protected] Subject: Open-ils-dev Digest, Vol 85, Issue 3 Send Open-ils-dev mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit http://libmail.georgialibraries.org/mailman/listinfo/open-ils-dev or, via email, send a message with subject or body 'help' to [email protected] You can reach the person managing the list at [email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of Open-ils-dev digest..." Today's Topics: 1. Re: Removing URLS from 856 (Mike Rylander) ---------------------------------------------------------------------- Message: 1 Date: Tue, 2 Apr 2013 10:16:16 -0400 From: Mike Rylander <[email protected]> Subject: Re: [OPEN-ILS-DEV] Removing URLS from 856 To: Evergreen Development Discussion List <[email protected]> Message-ID: <CAO8ar=kzut2vc5munswbdiwoyxx9hx+bqpfntxtxphsd3ga...@mail.gmail.com> Content-Type: text/plain; charset="iso-8859-1" On Tue, Apr 2, 2013 at 9:41 AM, Tim Spindler <[email protected]> wrote: > Mike, > > For the batch update, it is about 6000 records with bucket, I didn't think > Evergreen could handle that many in a bucket. > > With that many records I'd recommend the upload-CSV route, but it should be fine. It'll take a while, and the UI level /might/ time out, but barring a backend explosion it should chug through them. > Tim > > > On Tue, Apr 2, 2013 at 9:20 AM, Mike Rylander <[email protected]> wrote: > >> If your removal code is regexp-based, you'll just need to match on HCC in >> the middle of the "find for removal" regexp. Alternatively, you could >> apply the batch MARC update function to a bucket or CSV file full of the >> records. That has the ability to modify records conditionally, based on >> subfield content within a datafield. >> >> --miker >> >> >> >> On Tue, Apr 2, 2013 at 9:12 AM, Tim Spindler <[email protected]>wrote: >> >>> We have a library that wants to reload its Films on Demand records. >>> These records have multiple 856s for other institutions with the subfield 9 >>> associated with their shortname. What would the best way be to remove >>> these for instance. I have created a list of the records needing updating >>> in the staging table. Here is an example of the of he 856. I have code >>> that can remove all the 856s but am having trouble removing just one. We >>> just want to remove the one for HCC (although I'll take suggests for >>> removing the duplicate QCC lines also) >>> >>> <datafield tag="856" ind1="4" ind2="0"><subfield code="y">Click here to >>> access this film online (MCLA students, faculty, and staff >>> only)</subfield><subfield code="u"> >>> http://libproxy.mcla.edu:2048/login?url=http://digital.films.com/PortalPlaylists.aspx?aid=11580&xtid=152<http://libproxy.mcla.edu:2048/login?url=http://digital.films.com/PortalPlaylists.aspx?aid=11580&xtid=152></subfield><subfield >>> code="9">MCLA</subfield></datafield> >>> <datafield tag="856" ind1="4" ind2="0"><subfield code="u"> >>> http://ezhc.ez.cwmars.org:4000/login?url=http://digital.films.com/PortalPlaylists.aspx?aid=9206&xtid=152<http://ezhc.ez.cwmars.org:4000/login?url=http://digital.films.com/PortalPlaylists.aspx?aid=9206&xtid=152></subfield><subfield >>> code="y">Click here to access this film online (HCC Students and Staff >>> only)</subfield><subfield code="9">HCC</subfield></datafield> >>> <datafield tag="856" ind1="4" ind2="0"><subfield code="y">Click here to >>> access this film online (QCC studetns, faculty, & staff >>> only)</subfield><subfield code="u"> >>> http://ezqc.ez.cwmars.org:5200/login?url=http://digital.films.com/PortalPlaylists.aspx?aid=19277&xtid=152<http://ezqc.ez.cwmars.org:5200/login?url=http://digital.films.com/PortalPlaylists.aspx?aid=19277&xtid=152></subfield><subfield >>> code="9">QCC</subfield></datafield> >>> <datafield tag="856" ind1="4" ind2="0"><subfield code="u"> >>> http://ezhc.ez.cwmars.org:4000/login?url=http://digital.films.com/PortalPlaylists.aspx?aid=9206&xtid=152<http://ezhc.ez.cwmars.org:4000/login?url=http://digital.films.com/PortalPlaylists.aspx?aid=9206&xtid=152></subfield><subfield >>> code="y">Click here to access this film online (HCC Students and Staff >>> only)</subfield><subfield code="9">HCC</subfield></datafield> >>> <datafield tag="856" ind1="4" ind2="0"><subfield code="y">Click here to >>> access this film online (QCC studetns, faculty, & staff >>> only)</subfield><subfield code="u"> >>> http://ezqc.ez.cwmars.org:5200/login?url=http://digital.films.com/PortalPlaylists.aspx?aid=19277&xtid=152<http://ezqc.ez.cwmars.org:5200/login?url=http://digital.films.com/PortalPlaylists.aspx?aid=19277&xtid=152></subfield><subfield >>> code="9">QCC</subfield></datafield> >>> >>> >>> -- >>> Tim Spindler >>> [email protected] >>> >>> *P** Go Green - **Save a tree! Please don't print this e-mail unless >>> it's really necessary.* >>> >>> >>> >> >> >> >> -- >> Mike Rylander >> | Director of Research and Development >> | Equinox Software, Inc. / Your Library's Guide to Open Source >> | phone: 1-877-OPEN-ILS (673-6457) >> | email: [email protected] >> | web: http://www.esilibrary.com >> > > > > -- > Tim Spindler > [email protected] > > *P** Go Green - **Save a tree! Please don't print this e-mail unless > it's really necessary.* > > > -- Mike Rylander | Director of Research and Development | Equinox Software, Inc. / Your Library's Guide to Open Source | phone: 1-877-OPEN-ILS (673-6457) | email: [email protected] | web: http://www.esilibrary.com -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20130402/f9824438/attachment-0001.htm> End of Open-ils-dev Digest, Vol 85, Issue 3 *******************************************
