Dear Ruth What I am doing is using Microsoft Excel to Convert the database into MARC21 and then converting them to MRC format. But when I have multiple copies, I am keeping the biblio records also; how can I remove the biblio and keep the 952 records especially in MS Office Excel. Thanks and Regards R Sunil Kumar Library Technologist -----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request@lists.katipo.co.nz Sent: 15 October 2012 18:04 To: koha@lists.katipo.co.nz Subject: Koha Digest, Vol 84, Issue 26 Send Koha mailing list submissions to koha@lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request@lists.katipo.co.nz You can reach the person managing the list at koha-owner@lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..." Today's Topics: 1. Item Details - OPAC and Cataloguing (Chief Librarian, SAIACS) 2. Migration of Multiple copies (Sunil Kumar) 3. Re: Place hold in opac-detail.pl (kamild) 4. selfcheckout/checkin (KLib Tech Support) 5. Re: How can I see the Z39.50 sever info for my library in the admin (Nicole Engard) 6. Re: Item Details - OPAC and Cataloguing (Nicole Engard) 7. Re: Item Details - OPAC and Cataloguing (MJ Ray) 8. Re: Migration of Multiple copies (Ruth Bavousett) ---------------------------------------------------------------------- Message: 1 Date: Mon, 15 Oct 2012 11:18:17 +0530 From: "Chief Librarian, SAIACS" <library@saiacs.org> To: <koha@lists.katipo.co.nz> Subject: [Koha] Item Details - OPAC and Cataloguing Message-ID: <006601cdaa98$bc33ba70$349b2f50$@saiacs.org> Content-Type: text/plain; charset="us-ascii" Dear Folks, I have created a recorded and entered items details such as call number, barcode and other information. My problem is that holding details in cataloguing is not shown also in OPAC. I do not know if this question was resolved earlier. I also want to find those records with no items, is there a SQL command to find and edit them. Thanks in anticipation. ______________________________________ Yesan Sellan, B.Com., MLISc., PGDLAN Chief Librarian South Asia Institute of Advanced Christian Studies (SAIACS) 363 Dodda Gubbi Cross Road, Kothanur Post Office, Bangalore -560077, INDIA Phone : 91 80 2846 5235/5344/ 5649, Fax : 91 80 28465412, Mobile : 91-9972348251 Website : <http://www.saiacs.org/> www.saiacs.org Alternative Email: <mailto:yesan.sellan@saiacs.org> yesan.sellan@saiacs.org or <mailto:yesans@gmail.com> yesans@gmail.com ______________________________________ IMPORTANT : This message is intended only for the addressee. It may contain confidential information. Any unauthorized disclosure is strictly prohibited. If you have received this message in error, please notify us immediately so that we may correct our internal records. Please then delete the original message. Thank you. P Please consider the environment before printing this email. ------------------------------ Message: 2 Date: Mon, 15 Oct 2012 14:29:00 +0530 From: "Sunil Kumar" <sunil.kumar@ecoleglobal.com> To: <koha@lists.katipo.co.nz> Subject: [Koha] Migration of Multiple copies Message-ID: <000101cdaab3$542a5220$fc7ef660$@kumar@ecoleglobal.com> Content-Type: text/plain; charset="us-ascii" Dear Mr. Robin, Can you share with us the step by step process of data migration of multiple copies of single titles in MARC21. The standard practice what I have done is to keep the biblio number same and then changing the local field details in 952 and making sure that barcode and copy number changed. But not able to do the same and facing some problem. Appreciate your suggestion and help. Thanks and Regards R Sunil Kumar Library Technologist ------------------------------ Message: 3 Date: Mon, 15 Oct 2012 02:00:57 -0700 (PDT) From: kamild <smichaelxx@tlen.pl> To: koha@lists.katipo.co.nz Subject: Re: [Koha] Place hold in opac-detail.pl Message-ID: <1350291657832-5729706.post@n5.nabble.com> Content-Type: text/plain; charset=us-ascii Hi, Thanks very much for your interest a problem. I think abotu reserve from details a specific copy. I do somthing like this <http://koha.1045719.n5.nabble.com/file/n5729706/egz.jpg> but Perl is not my strong side. I add to opac-detail.tt <form action="/cgi-bin/koha/opac-reserve.pl" method="post" id="hold-request-form"> <input type="hidden" name="place_reserve" value="1"/> <input type="hidden" name="biblionumbers" id="biblionumbers"/> <input type="hidden" name="selecteditems" id="selections"/> <input class="reserve_mode" name="reserve_mode" type="hidden" value="multi"/> <input class="single_bib" name="single_bib" type="hidden" value="[% biblionumber %]"/> <input id="reqspecific_[% biblionumber %]" class="selectspecific" type="hidden" checked value="Specific" name="reqtype_[% biblionumber %]"> <input type="hidden" class="checkitem checkitem_[% biblionumber %]" name="checkitem_[% biblionumber %]" value="[% ITEM_RESULT.itemnumber %]" /> <input value="Place Hold" type="submit" class="placehold" /></form> Maybe someone is able to help? thx -- View this message in context: http://koha.1045719.n5.nabble.com/Place-hold-in-opac-detail-pl-tp5729488p572 9706.html Sent from the Koha-general mailing list archive at Nabble.com. ------------------------------ Message: 4 Date: Mon, 15 Oct 2012 17:19:24 +0530 From: KLib Tech Support <kalib.techkoha@gmail.com> To: koha list <koha@lists.katipo.co.nz> Subject: [Koha] selfcheckout/checkin Message-ID: <CAM3vUpZsyorLyj1LOyuoG+ehC1ie556bA7be1q_CLGFHzDfi=A@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Hi, Can we deactivate selfcheckout and allow only self check in koha 3.8? ------------------------------ Message: 5 Date: Mon, 15 Oct 2012 08:17:37 -0400 From: Nicole Engard <nengard@gmail.com> To: Lori Bowen Ayre <lori.ayre@galecia.com> Cc: koha@lists.katipo.co.nz, Lee Miller <lmiller@buttepubliclibrary.info> Subject: Re: [Koha] How can I see the Z39.50 sever info for my library in the admin Message-ID: <CAC0K6VGDoBmD_OYiDPE8C13tS85H6XUH5FxdvPhvZysRx-h6=A@mail.gmail.com> Content-Type: text/plain; charset=UTF-8 I also found this: http://manual.koha-community.org/3.8/en/systemfaq.html#publicztarget (that I forgot was in the manual). Nicole On Fri, Oct 5, 2012 at 4:07 PM, Lori Bowen Ayre <lori.ayre@galecia.com> wrote:

Have you seen this:

http://manual.koha-community.org/3.8/en/additionaladmin.html#z3950admi n

and this:

http://wiki.koha-community.org/wiki/Troubleshooting_Koha_as_a_Z39.50_s erver

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-= Lori Bowen Ayre // Library Technology Consultant / The Galecia Group Oversight Board & Communications Committee / Evergreen (707) 763-6869 // Lori.Ayre@galecia.com Availability: http://doodle.com/loriayre

<Lori.Ayre@galecia.com>Specializing in open source ILS solutions, RFID, filtering, workflow optimization, and materials handling =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

On Fri, Oct 5, 2012 at 11:22 AM, Lee Miller <lmiller@buttepubliclibrary.info

...

wrote:

...

All, I know that this may sound remedial, but I need some assisatance. I need the following info for my Z39.50 server - can some one please point me in the correct direction? Target Hostname/Port Database Userid Password Checked Rank Syntax Encoding

Thank you, Lee in Butte Butte Public Library

-- Lee Miller Library Director BSB Public Library 226 W. Broadway Butte, MT 59701 406-723-3361 x6301

______________________________**_________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/**mailman/listinfo/koha<http://lists.katipo .co.nz/mailman/listinfo/koha>

_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

------------------------------ Message: 6 Date: Mon, 15 Oct 2012 08:20:32 -0400 From: Nicole Engard <nengard@gmail.com> To: "Chief Librarian, SAIACS" <library@saiacs.org> Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Item Details - OPAC and Cataloguing Message-ID: <CAC0K6VFztPJwmPc-KBUhoJUrzKj7708CwrFdu=ue6_0G-D8aPQ@mail.gmail.com> Content-Type: text/plain; charset=UTF-8 To find all bibs without items you can try this report from the SQL Report Library: http://wiki.koha-community.org/wiki/SQL_Reports_Library#All_bibs_without_ite ms If the items aren't showing, but the bibs are you might have OPACHiddenItems (http://manual.koha-community.org/3.8/en/administration.html#OpacHiddenItems ) set to something that's hiding items or even hidelostitems set (http://manual.koha-community.org/3.8/en/administration.html#hidelostitems). Hope that helps some, Nicole On Mon, Oct 15, 2012 at 1:48 AM, Chief Librarian, SAIACS <library@saiacs.org> wrote:

Dear Folks,

I have created a recorded and entered items details such as call number, barcode and other information. My problem is that holding details in cataloguing is not shown also in OPAC. I do not know if this question was resolved earlier.

I also want to find those records with no items, is there a SQL command to find and edit them.

Thanks in anticipation.

______________________________________

Yesan Sellan, B.Com., MLISc., PGDLAN

Chief Librarian

South Asia Institute of Advanced Christian Studies (SAIACS)

363 Dodda Gubbi Cross Road, Kothanur Post Office, Bangalore -560077, INDIA

Phone : 91 80 2846 5235/5344/ 5649,

Fax : 91 80 28465412,

Mobile : 91-9972348251

Website : <http://www.saiacs.org/> www.saiacs.org

Alternative Email: <mailto:yesan.sellan@saiacs.org> yesan.sellan@saiacs.org or <mailto:yesans@gmail.com> yesans@gmail.com

______________________________________

IMPORTANT : This message is intended only for the addressee. It may contain confidential information. Any unauthorized disclosure is strictly prohibited. If you have received this message in error, please notify us immediately so that we may correct our internal records. Please then delete the original message. Thank you.

P Please consider the environment before printing this email.

_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

------------------------------ Message: 7 Date: Mon, 15 Oct 2012 13:26:33 +0100 From: MJ Ray <mjr@phonecoop.coop> To: koha@lists.katipo.co.nz Subject: Re: [Koha] Item Details - OPAC and Cataloguing Message-ID: <E1TNjkf-00035Q-0O@petrol.towers.org.uk> "Chief Librarian, SAIACS" <library@saiacs.org>

I have created a recorded and entered items details such as call number, barcode and other information. My problem is that holding details in cataloguing is not shown also in OPAC. I do not know if this question was resolved earlier.

http://koha-community.org/faqs/zebra-indexing-wont-work-fix-it-aka-search-st uff-up-help/ The second question is "What is the exact error message?" The third question was "What version of Koha are you using?" http://koha-community.org/faq/find-version-koha-running/ The fourth question is "Are we there yet?"

I also want to find those records with no items, is there a SQL command to find and edit them.

http://wiki.koha-community.org/wiki/SQL_Reports_Library#All_bibs_without_ite ms could be installed in Tools: Reports Hope that helps, -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op. http://koha-community.org supporter, web and library systems developer. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire (including development) at http://www.software.coop/ ------------------------------ Message: 8 Date: Mon, 15 Oct 2012 07:33:31 -0500 From: Ruth Bavousett <ruth@bywatersolutions.com> To: sunil.kumar@ecoleglobal.com Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Migration of Multiple copies Message-ID: <CAOEF2+RjR-MMRSpRFjuXf4rezYJowX4hdq5W-gyui1_9sWKCvA@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 You can also, of course, have multiple 952 entries in the same biblio record; each one giving the copy number and barcode of a different copy, along with its' other details like branchcode and itype. *D Ruth Bavousett* Lead Migration Specialist ByWater Solutions Support and Consulting for Open Source Software Headquarters: Santa Barbara, CA Office: Lawrence, KS Phone/Fax (888)900-8944 http://bywatersolutions.com ruth@bywatersolutions.com On Mon, Oct 15, 2012 at 3:59 AM, Sunil Kumar <sunil.kumar@ecoleglobal.com>wrote:

Dear Mr. Robin,

Can you share with us the step by step process of data migration of multiple copies of single titles in MARC21.

The standard practice what I have done is to keep the biblio number same and then changing the local field details in 952 and making sure that barcode and copy number changed.

But not able to do the same and facing some problem.

Appreciate your suggestion and help.

Thanks and Regards

R Sunil Kumar

Library Technologist

_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

------------------------------ _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 84, Issue 26 ************************************