[OPEN-ILS-GENERAL] SQL help needed

[Mary Llewellyn]

The MARC Batch Edit in Evergreen is still kind of clunky and I never get the
results I want from it. 

Thanks to everyone who has offered up SQL/Perl solutions to my question. I
can see I'm in over my head for these approaches, so I'm using option 1,
exporting, doing an external edit, then reloading, 100 bibs at a time. 

Mary


-----Original Message-----
From: open-ils-general-bounces at list.georgialibraries.org
[mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of
Jason Etheridge
Sent: Wednesday, September 12, 2012 10:38 AM
To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] SQL help needed

> This is the sort of thing that I'd do with perl, since there is the 
> nice MARC::Record module and the OpenSRF/OpenILS modules used by 
> Evergreen's backend have all the routines that you need to do this.

There's also a MARC Batch Edit UI, though I don't have any practical
experience with it.  Under the hood it uses MARC::Record powered stored
procedures like vandelay.replace_field()

-- Jason