[Koha] Migration of Multiple copies (Ruth Bavousett)

Tue Oct 16 01:46:19 NZDT 2012

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 at lists.katipo.co.nz
[mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of
koha-request at lists.katipo.co.nz
Sent: 15 October 2012 18:04
To: koha at lists.katipo.co.nz
Subject: Koha Digest, Vol 84, Issue 26

Send Koha mailing list submissions to
	koha at 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 at lists.katipo.co.nz

You can reach the person managing the list at
	koha-owner at 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 at saiacs.org>
To: <koha at 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 at saiacs.org> yesan.sellan at saiacs.org
or  <mailto:yesans at gmail.com> yesans at 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 at ecoleglobal.com>
To: <koha at lists.katipo.co.nz>
Subject: [Koha] Migration of Multiple copies
Message-ID: <000101cdaab3$542a5220$fc7ef660$@kumar at 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 at tlen.pl>
To: koha at lists.katipo.co.nz
Subject: Re: [Koha] Place hold in opac-detail.pl
Message-ID: <1350291657832-5729706.post at 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 at gmail.com>
To: koha list <koha at lists.katipo.co.nz>
Subject: [Koha] selfcheckout/checkin
Message-ID:
	<CAM3vUpZsyorLyj1LOyuoG+ehC1ie556bA7be1q_CLGFHzDfi=A at 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 at gmail.com>
To: Lori Bowen Ayre <lori.ayre at galecia.com>
Cc: koha at lists.katipo.co.nz, Lee Miller
	<lmiller at 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 at 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 at 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 at galecia.com
> Availability:  http://doodle.com/loriayre
>
> <Lori.Ayre at 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 at 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 at 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 at 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 at gmail.com>
To: "Chief Librarian, SAIACS" <library at saiacs.org>
Cc: koha at lists.katipo.co.nz
Subject: Re: [Koha] Item Details - OPAC and Cataloguing
Message-ID:
	<CAC0K6VFztPJwmPc-KBUhoJUrzKj7708CwrFdu=ue6_0G-D8aPQ at 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 at 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 at saiacs.org>
yesan.sellan at saiacs.org
> or  <mailto:yesans at gmail.com> yesans at 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 at 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 at phonecoop.coop>
To: koha at lists.katipo.co.nz
Subject: Re: [Koha] Item Details - OPAC and Cataloguing
Message-ID: <E1TNjkf-00035Q-0O at petrol.towers.org.uk>

"Chief Librarian, SAIACS" <library at 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 at bywatersolutions.com>
To: sunil.kumar at ecoleglobal.com
Cc: koha at lists.katipo.co.nz
Subject: Re: [Koha] Migration of Multiple copies
Message-ID:
	<CAOEF2+RjR-MMRSpRFjuXf4rezYJowX4hdq5W-gyui1_9sWKCvA at 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 at bywatersolutions.com

On Mon, Oct 15, 2012 at 3:59 AM, Sunil Kumar
<sunil.kumar at 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 at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>

------------------------------

_______________________________________________
Koha mailing list
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

End of Koha Digest, Vol 84, Issue 26
************************************