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