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

Tue Aug 18 17:33:59 NZST 2015

I ran across a similar issue and left a report on the wiki to help find
issues with differing cases in codes:

http://wiki.koha-community.org/wiki/SQL_Reports_Library#Codes_differ_in_case

I think that I used a similar technique to fix the offending codes.

--Barton

On Mon, Aug 17, 2015 at 6:12 PM, Paul A <paul.a at navalmarinearchive.com>
wrote:

> 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>
>
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>