[Koha] Migration of Multiple copies (Ruth Bavousett)

Ruth Bavousett ruth at bywatersolutions.com
Tue Oct 16 05:11:55 NZDT 2012


I can't *imagine* using Excel for that; MarcEdit or some other tool would
probably be much more useful.  So I'm not sure how to begin to help you
with that.

*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 7:46 AM, Sunil Kumar <sunil.kumar at ecoleglobal.com>wrote:

> 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
> ************************************
>
>


More information about the Koha mailing list