- Koha - lists.katipo.co.nz

Re: [Koha] Koha Digest, Vol 118, Issue 21
by Sandra Busutel 20 Aug '15

20 Aug '15

We use SCIS web for our Z39.50. We subscribe yearly. I zap the ISBNs into a plain text document upload to SCISweb and it's ready to load into Koha in seconds as a MARC record. We do 100s of books at a time. Then all we have to do is put in our local information. I'm located in Australia, not sure if this service is available world wide. Sandra On Thursday, August 20, 2015, <koha-request(a)lists.katipo.co.nz> wrote: > Send Koha mailing list submissions to > koha(a)lists.katipo.co.nz <javascript:;> > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.katipo.co.nz/mailman/listinfo/koha > or, via email, send a message with subject or body 'help' to > koha-request(a)lists.katipo.co.nz <javascript:;> > > You can reach the person managing the list at > koha-owner(a)lists.katipo.co.nz <javascript:;> > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Koha digest..." > > > Today's Topics: > > 1. Search server for children's books > (CTS-Programmer 3 (Paul Dokken)) > 2. Re: Search server for children's books (Riley Childs) > 3. Re: Re-catalogue a library (Jerwyn) > 4. Re: One Day Koha Seminar (Koha Implementation in libraries - > Tata Institute of Social Science, Mumbai experience) (Amit Gupta) > 5. Re: Search server for children's books > (CTS-Programmer 3 (Paul Dokken)) > 6. Re: Search server for children's books (Bob Birchall) > 7. Re: Search server for children's books (Chris Cormack) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 20 Aug 2015 00:51:47 +0000 > From: "CTS-Programmer 3 (Paul Dokken)" <cts-prog3(a)sil.org.pg > <javascript:;>> > To: "koha(a)lists.katipo.co.nz <javascript:;>" <koha(a)lists.katipo.co.nz > <javascript:;>> > Subject: [Koha] Search server for children's books > Message-ID: > <C8E2715D1613774E8F98EFDD264B35030B6121A9(a)Naomi.sil.org.pg > <javascript:;>> > Content-Type: text/plain; charset="us-ascii" > > We have been using the Seattle Public library Z39.50 server and it finds > most of what we want. There are some books that are not found. > Specifically this one, 978-0060573829. Does anybody know of a good server > I could use for children's books? I tried the Madison WI public library > server but it times out for me. > > I never got a response about my question if there was a way to figure out > if anybody was logged on the Koha staff client. Seems like this would be a > useful addition to Koha. > > Thanks, Paul > > > > ------------------------------ > > Message: 2 > Date: Thu, 20 Aug 2015 01:50:23 +0000 > From: Riley Childs <rchilds(a)cucawarriors.com <javascript:;>> > To: "CTS-Programmer 3 (Paul Dokken)" <cts-prog3(a)sil.org.pg <javascript:;> > >, > "koha(a)lists.katipo.co.nz <javascript:;>" <koha(a)lists.katipo.co.nz > <javascript:;>> > Subject: Re: [Koha] Search server for children's books > Message-ID: > < > SN1PR0701MB21122513D3658B26B9638664DB660(a)SN1PR0701MB2112.namprd07.prod.outlook.com > <javascript:;>> > > Content-Type: text/plain; charset="iso-8859-1" > > We use OhioLink, it has had an excellent track record of finding > Scholastic rebindings and other children's books. > //Riley > > -- > Riley Childs > Alumni > Charlotte United Christian Academy > Library Services Administrator > new email: me(a)rileychilds.me <javascript:;> > mobile: +1 (704) 497-2086 > web: http://www.rileychilds.me > > > ________________________________________ > From: Koha <koha-bounces(a)lists.katipo.co.nz <javascript:;>> on behalf of > CTS-Programmer 3 (Paul Dokken) <cts-prog3(a)sil.org.pg <javascript:;>> > Sent: Wednesday, August 19, 2015 8:51 PM > To: koha(a)lists.katipo.co.nz <javascript:;> > Subject: [Koha] Search server for children's books > > We have been using the Seattle Public library Z39.50 server and it finds > most of what we want. There are some books that are not found. > Specifically this one, 978-0060573829. Does anybody know of a good server > I could use for children's books? I tried the Madison WI public library > server but it times out for me. > > I never got a response about my question if there was a way to figure out > if anybody was logged on the Koha staff client. Seems like this would be a > useful addition to Koha. > > Thanks, Paul > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz <javascript:;> > https://lists.katipo.co.nz/mailman/listinfo/koha > > ------------------------------ > > Message: 3 > Date: Wed, 19 Aug 2015 19:03:39 -0700 (MST) > From: Jerwyn <os.jerwynfernandez(a)gmail.com <javascript:;>> > To: koha(a)lists.katipo.co.nz <javascript:;> > Subject: Re: [Koha] Re-catalogue a library > Message-ID: > <CACXfpCgRQsY=_ > bu+zNrgvQhWPU3KOMMPaU0vBx6UscGn_u4PLA(a)mail.gmail.com <javascript:;>> > Content-Type: text/plain; charset=UTF-8 > > Looks good nick! > > Thanks a lot!.. > > On Thu, Aug 20, 2015 at 2:33 AM, Nick Clemens [via Koha] < > ml-node+s1045719n5850033h22(a)n5.nabble.com <javascript:;>> wrote: > > > Here they are: > > > > https://github.com/WNickC/batchcat > > > > Lots more work to do to make it friendly, but it does the job > > > > -Nick > > > > On Wed, Aug 19, 2015 at 9:37 AM, Riley Childs <[hidden email] > > <http:///user/SendEmail.jtp?type=node&node=5850033&i=0>> > > wrote: > > > > > Could you possibly put them up on GitHub? > > > Thanks, > > > //Riley > > > > > > -- > > > Riley Childs > > > Alumni > > > Charlotte United Christian Academy > > > Library Services Administrator > > > new email: [hidden email] > > <http:///user/SendEmail.jtp?type=node&node=5850033&i=1> > > > mobile: +1 (704) 497-2086 > > > web: http://www.rileychilds.me > > > > > > > > > ________________________________________ > > > From: Koha <[hidden email] > > <http:///user/SendEmail.jtp?type=node&node=5850033&i=2>> on behalf of > > Nick Clemens < > > > [hidden email] <http:// > /user/SendEmail.jtp?type=node&node=5850033&i=3>> > > > Sent: Tuesday, August 18, 2015 3:24 PM > > > To: Koha > > > Subject: Re: [Koha] Re-catalogue a library > > > > > > We had a library severely damaged in a flood that had to catalogue > about > > > 7-10k items. Volunteers went through boxes, scanning the ISBN and a > > > barcode into a text file and then we used MARCEdit to batch look up the > > > isbns and used a simple perl script to auto generate items then cleaned > > up > > > the not found by hand. > > > > > > Happy to share scripts, rough as they are, if you are interested > > > > > > On Tue, Aug 18, 2015 at 12:17 AM, Bob Birchall <[hidden email] > > <http:///user/SendEmail.jtp?type=node&node=5850033&i=4>> wrote: > > > > > > > On 18/08/15 09:43, clint.deckard wrote: > > > > > > > >> I would appreciate any tips, hints or suggestions for re-cataloguing > > a > > > >> 7000 item library. > > > >> > > > >> At the moment, an item is scanned and then the record updated via > > Z39.50 > > > >> but this is a slow process. > > > >> What other approaches are there? > > > >> > > > >> Thank you, > > > >> Clint. > > > >> > > > >> Hi Clint, > > > > One possibility is to compile of file of ISBNs and submit it to your > > > > national library (Te Puna in your case). They could provide you with > > a > > > > file of MARC records. Matching on title and author might also be > > > > possible. There might be a fee involved and you still have to > create > > > > items locally, but its quicker than cataloguing individually. > > > > Hope this helps. > > > > Bob Birchall > > > > Calyx > > > > > > > > _______________________________________________ > > > > Koha mailing list http://koha-community.org > > > > [hidden email] <http:// > /user/SendEmail.jtp?type=node&node=5850033&i=5> > > > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > > > > > > > > > > > -- > > > Nick Clemens > > > Quechee & Wilder Libraries > > > [hidden email] <http:///user/SendEmail.jtp?type=node&node=5850033&i=6> > > > http://www.QuecheeLibrary.org > > > Q (802) 295-1232 W (802) 295-6341 > > > _______________________________________________ > > > Koha mailing list http://koha-community.org > > > [hidden email] <http:///user/SendEmail.jtp?type=node&node=5850033&i=7> > > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > > > > > > -- > > Nick Clemens > > Quechee & Wilder Libraries > > [hidden email] <http:///user/SendEmail.jtp?type=node&node=5850033&i=8> > > http://www.QuecheeLibrary.org > > Q (802) 295-1232 W (802) 295-6341 > > _______________________________________________ > > Koha mailing list http://koha-community.org > > [hidden email] <http:///user/SendEmail.jtp?type=node&node=5850033&i=9> > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > ------------------------------ > > If you reply to this email, your message will be added to the discussion > > below: > > > > > http://koha.1045719.n5.nabble.com/Re-catalogue-a-library-tp5849695p5850033.… > > To unsubscribe from Re-catalogue a library, click here > > < > http://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscrib… > > > > . > > NAML > > < > http://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=macro_view… > > > > > > > > -- > - Jerwyn Fernandez, RL > Koha Support Specialist > OS Library Solutions > (63) 9336734607 > (02) 7383209 > > > > > -- > View this message in context: > http://koha.1045719.n5.nabble.com/Re-catalogue-a-library-tp5849695p5850054.… > Sent from the Koha-general mailing list archive at Nabble.com. > > ------------------------------ > > Message: 4 > Date: Thu, 20 Aug 2015 08:57:54 +0530 > From: Amit Gupta <amitddng135(a)gmail.com <javascript:;>> > To: Koha-List <koha(a)lists.katipo.co.nz <javascript:;>> > Subject: Re: [Koha] One Day Koha Seminar (Koha Implementation in > libraries - Tata Institute of Social Science, Mumbai experience) > Message-ID: > <CAA= > k9sDg1nL4w7SVBiBqQj2EjocA6tP8JF4c3A-Zy+YjPhfT1w(a)mail.gmail.com > <javascript:;>> > Content-Type: text/plain; charset=UTF-8 > > Dear All, > > The last date for registration to this Koha seminar has been extended upto > 23 > Aug 2015. > Very few seats are available for registration on first come first served > basis. > > Those who are interested may please register for the same at the following > URL. > > http://www.informindia.co.in/KohaSeminar_TISS/index.htm > > > More details are there in the trailing email. > > > On Tue, Aug 11, 2015 at 8:57 AM, Amit Gupta <amitddng135(a)gmail.com > <javascript:;>> wrote: > > > Dear All, > > > > Tata Institute of Social Science Mumbai and Informatics Publishing > Limited > > Bangalore are pleased to announce a seminar on Advance Koha. > > > > We would like to take this opportunity to invite you to one day seminar > on > > Advance Koha. This event will showcase the advance features of Koha as > well > > as various customizations and Koha services on cloud. > > > > The seminar titled "Seminar on Advance Koha" will cover the following > > topics: > > 1. Implementing advanced functionalities of Koha in academic and > > corporate libraries > > 2. Institutional perspective on Koha > > 3. Koha on cloud - features and functionality > > 4. Digital Integrated Library Solutions > > > > The workshop will be held on Tuesday, 25th August 2015 at Sir Dorabji > > Tata Memorial Library, Tata Institute of Social Science (TISS), Mumbai > from 9:00 > > am to 5:00 pm. > > > > The workshop will be presented by eminent librarians and Mr. Amit Gupta/R > > Sunil Kumar from Informatics Publishing Ltd., Banglaore. > > > > Please visit www.informindia.co.in/KohaSeminar_TISS for more details and > > registration. > > > > > > -- > > Regards, > > Amit Gupta > > Informatics Publishing Ltd., > > Bangalore > > > > > > -- > Regards, > Amit Gupta > Informatics Publishing Ltd., > Bangalore > > > ------------------------------ > > Message: 5 > Date: Thu, 20 Aug 2015 04:59:17 +0000 > From: "CTS-Programmer 3 (Paul Dokken)" <cts-prog3(a)sil.org.pg > <javascript:;>> > To: Riley Childs <rchilds(a)cucawarriors.com <javascript:;>>, " > koha(a)lists.katipo.co.nz <javascript:;>" > <koha(a)lists.katipo.co.nz <javascript:;>> > Subject: Re: [Koha] Search server for children's books > Message-ID: > <C8E2715D1613774E8F98EFDD264B35030B612320(a)Naomi.sil.org.pg > <javascript:;>> > Content-Type: text/plain; charset="us-ascii" > > Perfect! Thanks so much Riley. Ohiolink seems to have what we need. > > Apparently nobody knows how to determine if any library staff is using the > staff client. Seems like this might be a useful feature. Maybe just store > log on date/time in the db for a user? > > Thanks, Paul > > -----Original Message----- > From: Riley Childs [mailto:rchilds@cucawarriors.com <javascript:;>] > Sent: Thursday, 20 August 2015 11:50 AM > To: CTS-Programmer 3 (Paul Dokken); koha(a)lists.katipo.co.nz <javascript:;> > Subject: Re: Search server for children's books > > We use OhioLink, it has had an excellent track record of finding > Scholastic rebindings and other children's books. > //Riley > > -- > Riley Childs > Alumni > Charlotte United Christian Academy > Library Services Administrator > new email: me(a)rileychilds.me <javascript:;> > mobile: +1 (704) 497-2086 > web: http://www.rileychilds.me > > > ________________________________________ > From: Koha <koha-bounces(a)lists.katipo.co.nz <javascript:;>> on behalf of > CTS-Programmer 3 (Paul Dokken) <cts-prog3(a)sil.org.pg <javascript:;>> > Sent: Wednesday, August 19, 2015 8:51 PM > To: koha(a)lists.katipo.co.nz <javascript:;> > Subject: [Koha] Search server for children's books > > We have been using the Seattle Public library Z39.50 server and it finds > most of what we want. There are some books that are not found. > Specifically this one, 978-0060573829. Does anybody know of a good server > I could use for children's books? I tried the Madison WI public library > server but it times out for me. > > I never got a response about my question if there was a way to figure out > if anybody was logged on the Koha staff client. Seems like this would be a > useful addition to Koha. > > Thanks, Paul > > _______________________________________________ > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > <javascript:;> https://lists.katipo.co.nz/mailman/listinfo/koha > > > ------------------------------ > > Message: 6 > Date: Thu, 20 Aug 2015 15:15:21 +1000 > From: Bob Birchall <bob(a)calyx.net.au <javascript:;>> > To: koha(a)lists.katipo.co.nz <javascript:;> > Subject: Re: [Koha] Search server for children's books > Message-ID: <55D56269.2010703(a)calyx.net.au <javascript:;>> > Content-Type: text/plain; charset=utf-8; format=flowed > > On 20/08/15 10:51, CTS-Programmer 3 (Paul Dokken) wrote: > > We have been using the Seattle Public library Z39.50 server and it finds > most of what we want. There are some books that are not found. > Specifically this one, 978-0060573829. Does anybody know of a good server > I could use for children's books? I tried the Madison WI public library > server but it times out for me. > Nearer to home for you Paul, we've found Macquarie University to be > quite good. New server details are not yet updated to irspy: > hostname: ap01.alm.exlibrsigroup.com > port: 1921 > database: 61MACQUARIE_INST > if that doesn't work contact annette schryver for more help: > annette.schryver(a)mq.edu.au <javascript:;> > > > > > I never got a response about my question if there was a way to figure > out if anybody was logged on the Koha staff client. Seems like this would > be a useful addition to Koha. > > > > Thanks, Paul > The best way to get attention for that is to lodge an enhancement > request in bugzilla: http://bugs.koha-community.org/bugzilla3/ > Patches are welcome too. :) > > Bob Birchall > Calyx > > > ------------------------------ > > Message: 7 > Date: Thu, 20 Aug 2015 17:15:25 +1200 > From: Chris Cormack <chrisc(a)catalyst.net.nz <javascript:;>> > To: "CTS-Programmer 3 (Paul Dokken)" <cts-prog3(a)sil.org.pg <javascript:;>> > Cc: "koha(a)lists.katipo.co.nz <javascript:;>" <koha(a)lists.katipo.co.nz > <javascript:;>> > Subject: Re: [Koha] Search server for children's books > Message-ID: <20150820051525.GK5920(a)rorohiko.wgtn.cat-it.co.nz > <javascript:;>> > Content-Type: text/plain; charset="utf-8" > > * CTS-Programmer 3 (Paul Dokken) (cts-prog3(a)sil.org.pg <javascript:;>) > wrote: > > Perfect! Thanks so much Riley. Ohiolink seems to have what we need. > > > > Apparently nobody knows how to determine if any library staff is using > the staff client. Seems like this might be a useful feature. Maybe just > store log on date/time in the db for a user? > > > > The sessions table should tell you. > > Chris > > > Thanks, Paul > > > > -----Original Message----- > > From: Riley Childs [mailto:rchilds@cucawarriors.com <javascript:;>] > > Sent: Thursday, 20 August 2015 11:50 AM > > To: CTS-Programmer 3 (Paul Dokken); koha(a)lists.katipo.co.nz > <javascript:;> > > Subject: Re: Search server for children's books > > > > We use OhioLink, it has had an excellent track record of finding > Scholastic rebindings and other children's books. > > //Riley > > > > -- > > Riley Childs > > Alumni > > Charlotte United Christian Academy > > Library Services Administrator > > new email: me(a)rileychilds.me <javascript:;> > > mobile: +1 (704) 497-2086 > > web: http://www.rileychilds.me > > > > > > ________________________________________ > > From: Koha <koha-bounces(a)lists.katipo.co.nz <javascript:;>> on behalf > of CTS-Programmer 3 (Paul Dokken) <cts-prog3(a)sil.org.pg <javascript:;>> > > Sent: Wednesday, August 19, 2015 8:51 PM > > To: koha(a)lists.katipo.co.nz <javascript:;> > > Subject: [Koha] Search server for children's books > > > > We have been using the Seattle Public library Z39.50 server and it finds > most of what we want. There are some books that are not found. > Specifically this one, 978-0060573829. Does anybody know of a good server > I could use for children's books? I tried the Madison WI public library > server but it times out for me. > > > > I never got a response about my question if there was a way to figure > out if anybody was logged on the Koha staff client. Seems like this would > be a useful addition to Koha. > > > > Thanks, Paul > > > > _______________________________________________ > > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > <javascript:;> https://lists.katipo.co.nz/mailman/listinfo/koha > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz <javascript:;> > > https://lists.katipo.co.nz/mailman/listinfo/koha > > -- > Chris Cormack > Catalyst IT Ltd. > +64 4 803 2238 > PO Box 11-053, Manners St, Wellington 6142, New Zealand >

1 0

One Day Koha Seminar (Koha Implementation in libraries - Tata Institute of Social Science, Mumbai experience)
by Amit Gupta 20 Aug '15

20 Aug '15

Dear All, Tata Institute of Social Science Mumbai and Informatics Publishing Limited Bangalore are pleased to announce a seminar on Advance Koha. We would like to take this opportunity to invite you to one day seminar on Advance Koha. This event will showcase the advance features of Koha as well as various customizations and Koha services on cloud. The seminar titled "Seminar on Advance Koha" will cover the following topics: 1. Implementing advanced functionalities of Koha in academic and corporate libraries 2. Institutional perspective on Koha 3. Koha on cloud - features and functionality 4. Digital Integrated Library Solutions The workshop will be held on Tuesday, 25th August 2015 at Sir Dorabji Tata Memorial Library, Tata Institute of Social Science (TISS), Mumbai from 9:00 am to 5:00 pm. The workshop will be presented by eminent librarians and Mr. Amit Gupta/R Sunil Kumar from Informatics Publishing Ltd., Banglaore. Please visit www.informindia.co.in/KohaSeminar_TISS for more details and registration. -- Regards, Amit Gupta Informatics Publishing Ltd., Bangalore

1 1

Re: [Koha] Final follow up on: transfers to receive- home/holding branch issues
by Amy Schuler 20 Aug '15

20 Aug '15

Thanks to everyone who helped out on my collection codes/transfers problem. I went with Barton's suggestion to edit mySQL. It worked beautifully. I did some testing (checking in & out in circulation module) and everything now works the way it should with no further "transfers to receive" problems. Amy Cary Institute

1 0

Electronic Resource URLs - Authentication
by Craig Butosi 19 Aug '15

19 Aug '15

Hi all, Running Koha 3.20.02 on Ubuntu 14.04 LTS with Apache 2.4.7. I had a question about the authentication of electronic resource links in Koha. I'd like to explore a method of managing access to links to e-resources (856 fields) that would (1) prevent an anonymous user from navigating to the full-text of an e-resource via the 856 link; and (2) to show an 856 link to the full-text of an e-resource to authenticated users. I am thinking here of how universities and colleges manage their e-resources (i.e., allow registered students access to e-content but denying unauthorized access from unofficial users). The problem is that I've never talked with anyone who could explain how this is done generally. I'm sure it varies across institutions. So, can Koha (presumably with server-side software) do this, and how can it be done? Is this what CAS or SIP2 is for? Hope this is clear. Happy to provide more info. This is not my area, but I'd like to explore further. Feel free to point me to info resources on this too. Many thanks! Craig Butosi, MA, MLIS, B Mus (Hons.) LIBRARY SERVICES MANAGER the royal conservatory TELUS Centre for Performance and Learning 273 Bloor Street West Toronto, ON M5S 1W2 416.408.2824 x338 www.rcmusic.ca<http://www.rcmusic.ca/> Note: This email message and any attachments are intended only for the use of the individual to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the recipient of this email is not the intended recipient (or the employee or agent responsible for delivering the email to the intended recipient), you are hereby notified that any review, dissemination, distribution or copying or other use of this message is strictly prohibited. If you have received this communication in error, please notify the sender immediately by return email and delete this message and attachments from your system, thank you.

4 4

VuFind and Koha
by Riley Childs 19 Aug '15

19 Aug '15

There is little documentation on using Koha with VuFind, I am curious if anyone is currently using VuFind with Koha and if they can give me some guidance. I am currently having issues with VuFind not reflecting holdings status. In addition I am struggling to setup the OAI connector for automated updates. Thanks for your help! //Riley -- Riley Childs Alumni Charlotte United Christian Academy Library Services Administrator new email: me(a)rileychilds.me mobile: +1 (704) 497-2086 web: http://www.rileychilds.me<http://www.rileychilds.me/>

4 4

Want to share your open source story?
by Nicole Engard 18 Aug '15

18 Aug '15

I'm a community moderator for opensource.com and we're trying to feature some new writers and new stories in the month of October. This is an invite to submit your open source origin (how you got started in open source) story for review. Email open(a)opensource.com with their name, area of interest in open source, and article idea if you're interested. Proposals from first-time writers are due by August 31. Thanks Nicole

1 0

Koha Community Newsletter: July 2015
by kohanews 18 Aug '15

18 Aug '15

Fellow Koha users: The Koha Community Newsletter for July 2015 is here: http://koha-community.org/koha-community-newsletter-july-2015/ Many thanks to the folks who submitted articles and news to this month's newsletter. Please feel free to email me with any corrections or suggestions. Thanks! Chad Roseburg Editor, Koha Community Newsletter

2 3

Re: [Koha] follow up on: transfers to receive- home/holding branch issues
by Paul A 18 Aug '15

18 Aug '15

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(a)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(a)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(a)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(a)caryinstitute.org > > >> > > > > > > > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)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(a)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>

2 1

follow up on: transfers to receive- home/holding branch issues
by Amy Schuler 18 Aug '15

18 Aug '15

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(a)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(a)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(a)caryinstitute.org >> > >

2 1

Off Topic(ish)
by Nicole Engard 17 Aug '15

17 Aug '15

Hi all, I'd love if you'd vote for my session on open source: http://panelpicker.sxsw.com/vote/46251 and share the voting link far and wide so I can talk about open source and Koha of course at SxSWEdu. Thanks a ton!! Nicole

2 1