[Koha] follow up on: transfers to receive- home/holding branch issues

[Paul A]

Disclaimer: untested; we are not a lending library so cannot double check 
all possible repercussions.

However, if you are convinced that your problem is limited to / caused by 
case sensitivity of 'homebranch' and 'holdingbranch' in your *items* 
records, the easy solution is to edit MySql:

mysql> UPDATE items SET homebranch = 'CARY' WHERE items.homebranch LIKE 'cary';
mysql> UPDATE items SET holdingbranch = 'CARY' WHERE items.holdingbranch 
LIKE 'cary';

This will only work if "CARY" is the properly declared value -- otherwise 
you'll get an error message about foreign keys (MySql is your friend and 
won't let you make a major mistake.)

Best -- Paul

At 07:34 PM 8/17/2015 +0100, Elaine Bradtke wrote:
>We had a similar problem with collection codes.
>In the end I exported the records, ran a batch edit in MarcEdit (or a text
>editor) and then imported the records to overwrite the old ones.  It is
>always safer to do this in a test instance of the catalogue first, if you
>have one. Though as edits go, changing the case of one word *should *be
>simple.
>
>On Mon, Aug 17, 2015 at 4:18 PM, Amy Schuler <schulera at caryinstitute.org>
>wrote:
>
> > Hello again,
> > thanks to Michael, Katrin and Robin for helping out a few weeks ago with my
> > holding branch/home branch issues.
> >
> > I went through the exercises you all recommended, and as you might have
> > guessed I found that for some (not all) items I have a bad homebranch and
> > holdingbranch:  Cary.  The "correct" location for both should be uppercase
> > CARY.
> >
> > Example: When I check out an item that has homebr Cary and holdingbr Cary,
> > then check it in again, it ends up in the "transfers to receive" queue
> > because in the checkout process it had been switched from homebr Cary and
> > holdingbr CARY.  These are the only items that go to "transfers to
> > receive".  Items that always indicate homebr CARY and holdingbr CARY always
> > get checked in normally without going to that queue.
> >
> > Is this something I can fix if I make a copy of my database and make global
> > changes in some test environment?
> >
> > Thanks again for all of your advice.
> > Amy Schuler
> > CARY Institute ;)
> >
> > On Wed, Jul 29, 2015 at 12:44 PM, Amy Schuler <schulera at caryinstitute.org>
> > wrote:
> >
> > > Hello again, I have more info.
> > >
> > > Just now, when canceling transfers as described below, I saw that the
> > > fields for "home library" and "holding library" were slightly different.
> > > One says "Cary" and the other says "CARY".  I should mention that only
> > the
> > > books that I checked in that have the lower case "Cary" as home library
> > end
> > > up in the 'transfers to receive' queue.
> > >
> > > When I look at these records in the OPAC I don't see differences between
> > > them - they all have thefull name of our institution (Cary Institute
> > > Library) listed as home and current holding library.
> > >
> > > I just looked in global sys preferences > libraries and see that there is
> > > only one library, Cary Institute Library, code CARY indicated here.  So I
> > > am not sure where lower case 'Cary' is coming from, or how to merge or
> > get
> > > rid of it without really messing things up.
> > >
> > > Any help or advice would be appreciated.  Thanks again!
> > > a
> > >
> > >
> > > On Wed, Jul 29, 2015 at 12:00 PM, Amy Schuler <
> > schulera at caryinstitute.org>
> > > wrote:
> > >
> > >> Hi, if this message looks familiar it's because I posted it originally
> > >> back in 2013, but got no response.  I am still having the same problem.
> > >>
> > >> An annoying thing is occurring when I check in an item in the
> > circulation
> > >> module.  After I check in as usual, the status becomes "In transit from
> > >> Cary Institute Library, to , since . " Then I have to go into Transfers
> > to
> > >> Receive and cancel the transfer for that item before it will display as
> > >> available for loan in the OPAC record.
> > >>
> > >> Any tips or advice?  I searched bugs and didn't find anything about
> > this.
> > >>
> > >> We use Koha 3.18.06.000 (Linux ubuntu).
> > >>
> > >> Hope you can help.
> > >> thanks!
> > >>
> > >> Amy Schuler
> > >> schulera at caryinstitute.org
> > >>
> > >
> > >
> > _______________________________________________
> > Koha mailing list  http://koha-community.org
> > Koha at lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> >
>
>
>
>--
>Elaine Bradtke
>Data Wrangler
>VWML
>English Folk Dance and Song Society | http://www.efdss.org
>Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
>Tel    +44 (0) 20 7485 2206 (This number is for the English Folk Dance and
>Song Society in London, England. If you wish to phone me personally, send
>an e-mail first. I work off site)
>--------------------------------------------------------------------------
>Registered Company No. 297142
>Charity Registered in England and Wales No. 305999
>---------------------------------------------------------------------------
>"Writing about music is like dancing about architecture"
>--Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
>_______________________________________________
>Koha mailing list  http://koha-community.org
>Koha at lists.katipo.co.nz
>https://lists.katipo.co.nz/mailman/listinfo/koha

---
Maritime heritage and history, preservation and conservation,
research and education through the written word and the arts.
<http://NavalMarineArchive.com> and <http://UltraMarine.ca>