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 r...@bywatersolutions.com On Mon, Oct 15, 2012 at 7:46 AM, Sunil Kumar <sunil.ku...@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-boun...@lists.katipo.co.nz > [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of > koha-requ...@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-requ...@lists.katipo.co.nz > > You can reach the person managing the list at > koha-ow...@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" <libr...@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.sel...@saiacs.org> > yesan.sel...@saiacs.org > or <mailto:yes...@gmail.com> yes...@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.ku...@ecoleglobal.com> > To: <koha@lists.katipo.co.nz> > Subject: [Koha] Migration of Multiple copies > Message-ID: <000101cdaab3$542a5220$fc7ef660$@ku...@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 <smichae...@tlen.pl> > To: koha@lists.katipo.co.nz > Subject: Re: [Koha] Place hold in opac-detail.pl > Message-ID: <1350291657832-5729706.p...@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.techk...@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 <neng...@gmail.com> > To: Lori Bowen Ayre <lori.a...@galecia.com> > Cc: koha@lists.katipo.co.nz, Lee Miller > <lmil...@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.a...@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.a...@galecia.com > > Availability: http://doodle.com/loriayre > > > > <lori.a...@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 > > <lmil...@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 <neng...@gmail.com> > To: "Chief Librarian, SAIACS" <libr...@saiacs.org> > Cc: koha@lists.katipo.co.nz > Subject: Re: [Koha] Item Details - OPAC and Cataloguing > Message-ID: > <CAC0K6VFztPJwmPc-KBUhoJUrzKj7708CwrFdu= > ue6_0g-d8...@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 > <libr...@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.sel...@saiacs.org> > yesan.sel...@saiacs.org > > or <mailto:yes...@gmail.com> yes...@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 <m...@phonecoop.coop> > To: koha@lists.katipo.co.nz > Subject: Re: [Koha] Item Details - OPAC and Cataloguing > Message-ID: <e1tnjkf-00035q...@petrol.towers.org.uk> > > "Chief Librarian, SAIACS" <libr...@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 <r...@bywatersolutions.com> > To: sunil.ku...@ecoleglobal.com > Cc: koha@lists.katipo.co.nz > Subject: Re: [Koha] Migration of Multiple copies > Message-ID: > < > caoef2+rjr-mmrsprfjuxf4rezyjowx4hdq5w-gyui1_9swk...@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 > r...@bywatersolutions.com > > > > On Mon, Oct 15, 2012 at 3:59 AM, Sunil Kumar > <sunil.ku...@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 > ************************************ > > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
