[Koha] Migration of Multiple copies (Ruth Bavousett)
Koustubha Kale
kmkale at gmail.com
Tue Oct 16 05:27:42 NZDT 2012
Hey Ruth,
I am certain he is using MarcEdit. Just using excel file as input file to
it.
BTW how are you?
Kk
On Oct 15, 2012 9:43 PM, "Ruth Bavousett" <ruth at bywatersolutions.com> wrote:
> 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
> > ************************************
> >
> >
> _______________________________________________
> Koha mailing list http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
More information about the Koha
mailing list