[OPEN-ILS-GENERAL] Question about best practices....

[Jane Sandberg]

I typically use a pretty round-about process for batch updating bib
records.  It's worked out really well for me so far, but I know that
it doesn't really help with the item record updates that your
catalogers do.

Here's what I do:

1. Create a report template with the first column containing the bib
record's TCN.
2. Create a report using that template in the CSV format.
3. Go to Cataloging > Batch Import/Export, and upload the report
containing all those TCNs.
4. Evergreen will produce a file containing all the appropriate MARC records.
5. Use MarcEdit (http://marcedit.reeset.net/) to make the desired changes.
6. Re-import the records into Evergreen, with an appropriate merge
profile applied on exact matches (901c) only.

I'm curious to see what others are doing.  Thanks for asking this, Tony!

    -Jane

On Mon, Feb 23, 2015 at 2:45 PM, Tony Bandy <tonyb at ohionet.org> wrote:
> Hello everyone,
>
>
>
> This group has been very helpful with all of my questions, so if I may, just
> throw one out there to get folks opinions, best practices, etc., I would be
> grateful!
>
>
>
> ----------------
>
>
>
> In the case of our consortium, several time our catalogers need to update
> 2-3k records at a time, usually to alter a fixed field in the copy record.
> I know that we can upload a list of barcodes via the staff client and then
> put them into a copy bucket to do batch edits.  Realistically however, at
> least in cases I’ve tried, we’re finding out that this doesn’t really work
> too well, except in small numbers of records.
>
>
>
> What does everyone do if you need to update thousands of records at time?
> Is this something that is being considered for the web client, now that
> sprint 2 is the next target?  I do realize that it’s possible to jump down
> via the console and do things via SQL, but given the skill set needed to run
> operations like that, not too practical to expect catalogers and other
> library staff to have the time and knowledge to do this.
>
>
>
> Any workarounds, etc. that you may have come up with would be appreciated!!!
>
>
>
> --Tony
>
>
>
> Tony Bandy
>
> tonyb at ohionet.org
>
> OHIONET
>
> 1500 West Lane Ave.
>
> Columbus, OH  43221-3975
>
> 614-486-2966 x19
>
>



-- 
Jane Sandberg
Electronic Resources Librarian
Linn-Benton Community College
sandbej at linnbenton.edu / 541-917-4655