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