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" <r...@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 > 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 > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
