[OPEN-ILS-DEV] ***SPAM*** RE: Open-ils-dev Digest, Vol 85, Issue 3
Vyacheslav Tykhonov
vty at iisg.nl
Tue Apr 2 12:15:00 EDT 2013
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 at ...
Software Developer of International Institute of Social History (IISG)
Amsterdam, Netherlands
http://socialhistory.org
________________________________________
From: open-ils-dev-bounces at list.georgialibraries.org [open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of open-ils-dev-request at list.georgialibraries.org [open-ils-dev-request at list.georgialibraries.org]
Sent: Tuesday, April 02, 2013 6:00 PM
To: open-ils-dev at list.georgialibraries.org
Subject: Open-ils-dev Digest, Vol 85, Issue 3
Send Open-ils-dev mailing list submissions to
open-ils-dev at list.georgialibraries.org
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
open-ils-dev-request at list.georgialibraries.org
You can reach the person managing the list at
open-ils-dev-owner at list.georgialibraries.org
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 <mrylander at gmail.com>
Subject: Re: [OPEN-ILS-DEV] Removing URLS from 856
To: Evergreen Development Discussion List
<open-ils-dev at list.georgialibraries.org>
Message-ID:
<CAO8ar=kZut2vc5MuNSWbDiwoyXX9hx+BqPfnTXTXphSd3GApeg at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
On Tue, Apr 2, 2013 at 9:41 AM, Tim Spindler <tjspindler at gmail.com> 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 <mrylander at gmail.com> 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 <tjspindler at gmail.com>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
>>> tjspindler at gmail.com
>>>
>>> *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: miker at esilibrary.com
>> | web: http://www.esilibrary.com
>>
>
>
>
> --
> Tim Spindler
> tjspindler at gmail.com
>
> *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: miker at esilibrary.com
| 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
*******************************************
More information about the Open-ils-dev
mailing list