[OPEN-ILS-DEV] Evergreen 2.0 alpha4 new sidebar facets

[Mike Rylander]

On Wed, Oct 13, 2010 at 11:06 AM, Soulliere, Robert
<robert.soulliere at mohawkcollege.ca> wrote:
> Thanks Mike,
>
> OK,  I was reingesting the records using the SQL transaction script.
>
> The maintain_control_numbers() function was doing its job to help us clean up our records a bit as the function pointed out several malformed marc tags.
>
> However, I was wondering about the best way to fix this error which is choking the reingesting process?:
> psql:reinges20.sql:3: ERROR:  error from Perl function "maintain_control_numbers": Field 300 must have indicators (use ' ' for empty indicators) at /usr/share/perl5/MARC/File/SAX.pm line 92
>
> According to the error, It looks like I have to replace NULL values in 300 indicator fields with  emply strings ' '? I found about 2200 cases of  empty indicators in the 300 tags in the metabib.real_full_rec table. Is there a way to batch fix these or get the reingestor to  work around them?
>

You'll want to use a space for empty indicators.  Just adjust the
biblio.record_entry table -- the ingest will fix
metabib.real_full_rec.

--miker

> Thanks,
> Robert
>
>
> Robert Soulliere, BA (Hons), MLIS
> Systems Librarian
> Mohawk College Library
> robert.soulliere at mohawkcollege.ca
> Telephone: 905 575 1212 x3936
> Fax: 905 575 2011
> ________________________________________
> From: open-ils-dev-bounces at list.georgialibraries.org [open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of Mike Rylander [mrylander at gmail.com]
> Sent: October 12, 2010 4:40 PM
> To: Evergreen Development Discussion List
> Subject: Re: [OPEN-ILS-DEV] Evergreen 2.0 alpha4 new sidebar facets
>
> On Tue, Oct 12, 2010 at 3:21 PM, Soulliere, Robert
> <robert.soulliere at mohawkcollege.ca> wrote:
>> Hi all,
>>
>> I was doing some testing using Evergreen 2.0 alpha 4 and was not able to get
>> the sidebar facets to show up.
>>
>> This is an upgrade from 1.6.1. using our library data.
>
> There won't be any facet data in an upgraded database -- you'll need
> to adjust or add some indexing definitions and then reingest your
> records.  To reingest in 2.0 you'll want to:
>
> BEGIN;
> UPDATE config.internal_flag SET enabled = TRUE WHERE name =
> 'ingest.reingest.force_on_same_marc';
> UPDATE biblio.record_entry SET marc = marc;
> UPDATE config.internal_flag SET enabled = FALSE WHERE name =
> 'ingest.reingest.force_on_same_marc';
> COMMIT;
>
> Note, that can take a while, depending on the size of your bib set.
>
> --
> Mike Rylander
>  | VP, Research and Design
>  | Equinox Software, Inc. / The Evergreen Experts
>  | phone:  1-877-OPEN-ILS (673-6457)
>  | email:  miker at esilibrary.com
>  | web:  http://www.esilibrary.com
>
> This E-mail contains privileged and confidential information intended
> only for the individual or entity named in the message.  If the reader
> of this message is not the intended recipient, or the agent responsible
> to deliver it to the intended recipient, you are hereby notified that
> any review, dissemination, distribution or copying of this communication
> is prohibited.  If this communication was received in error, please
> notify the sender by reply E-mail immediately, and delete and destroy
> the original message.
>



-- 
Mike Rylander
 | VP, Research and Design
 | Equinox Software, Inc. / The Evergreen Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  miker at esilibrary.com
 | web:  http://www.esilibrary.com