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@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@bywatersolutions.com
On Mon, Oct 15, 2012 at 7:46 AM, Sunil Kumar <sunil.kumar@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@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request@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-request@lists.katipo.co.nz
You can reach the person managing the list at koha-owner@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@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.sellan@saiacs.org> yesan.sellan@saiacs.org or <mailto:yesans@gmail.com> yesans@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@ecoleglobal.com> To: <koha@lists.katipo.co.nz> Subject: [Koha] Migration of Multiple copies Message-ID: <000101cdaab3$542a5220$fc7ef660$@kumar@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@tlen.pl> To: koha@lists.katipo.co.nz Subject: Re: [Koha] Place hold in opac-detail.pl Message-ID: <1350291657832-5729706.post@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@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 <nengard@gmail.com> To: Lori Bowen Ayre <lori.ayre@galecia.com> Cc: koha@lists.katipo.co.nz, Lee Miller <lmiller@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.ayre@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@galecia.com Availability: http://doodle.com/loriayre
<Lori.Ayre@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@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 <nengard@gmail.com> To: "Chief Librarian, SAIACS" <library@saiacs.org> Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Item Details - OPAC and Cataloguing Message-ID: <CAC0K6VFztPJwmPc-KBUhoJUrzKj7708CwrFdu= ue6_0G-D8aPQ@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@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@saiacs.org> yesan.sellan@saiacs.org or <mailto:yesans@gmail.com> yesans@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 <mjr@phonecoop.coop> To: koha@lists.katipo.co.nz Subject: Re: [Koha] Item Details - OPAC and Cataloguing Message-ID: <E1TNjkf-00035Q-0O@petrol.towers.org.uk>
"Chief Librarian, SAIACS" <library@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@bywatersolutions.com> To: sunil.kumar@ecoleglobal.com Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Migration of Multiple copies Message-ID: < CAOEF2+RjR-MMRSpRFjuXf4rezYJowX4hdq5W-gyui1_9sWKCvA@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@bywatersolutions.com
On Mon, Oct 15, 2012 at 3:59 AM, Sunil Kumar <sunil.kumar@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