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

[Soulliere, Robert]

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?

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.