[Koha] branchcodes and case sensitivity

[Chris Cormack]

2010/9/24 Chris Hobbs <chobbs at nhusd.k12.ca.us>:
> On 9/15/10 9:01 AM, Galen Charlton wrote:
>
> Hi,
>
> On Sep 3, 2010, at 4:03 PM, Chris Hobbs wrote:
>
> The obvious fix would be to simply set branchcode to LOWER(branchcode) in
> the back end, but the foreign key constraint prevents me from doing so
> through mysql.
>
> A longer-term fix would be to figure out why it's not setting the branchcode
> correctly, but as far as cascading the update of branchcode is concerned,
> you could either alter the constraints to cascade updates or take advantage
> of MySQL's ability to disable foreign key checks temporarily:
>
> SET FOREIGN_KEY_CHECKS = 0;
>
> Galen's direction on removing the foreign key checks temporarily got me the
> ability to update branchcodes across all of my db tables, but I seem to have
> a problem with my zebra indexes - most of my items (those that have not been
> circulated since the conversion) do not have branch information visible
> information - here's a screen shot:
> http://www.nhusd.k12.ca.us/it/files/images/Screen%20shot%202010-09-23%20at%204.14.03%20PM.png
>
> I have tried re-indexing in the hopes that it would work itself out
> (rebuild_zebra.pl -b -a -r) but no luck. Any idea how to get the correct
> (lowercase) branch info into the zebra indexes?
>
Indeed, in misc/maintenance/ there is a script sync_items_in_marc_bib.pl

That will sync up what is in the MARC (which zebra uses for its
indexes) with what is in the items table.
The nice thing is, it puts an entry into the zebraqueue table, and so
the cron job indexes the changed ones.

Chris