Dear Bob, Location (952$c) is basically the shelf location of the book in the library, regard to the library branch / holding branch. There is only one library with different shelf location (primary book, science book, reference book, etc). It will be appropriate if I use 952$a (for library branch/library holding as 'Main Library' in my database) and 952$c (as shelf location in my database)
Please suggest. Thanks and Regards R Sunil Kumar Library Technologist +91-9686576695 -----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: 14 June 2011 11:40 To: koha@lists.katipo.co.nz Subject: Koha Digest, Vol 68, Issue 57 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. Re: Uploading the database from excel to KOHA : Copies not available / Missing (Bob Birchall) 2. Re: Uploading the database from excel to KOHA : Copies not available / Missing (R Sunil Kumar) ---------------------------------------------------------------------- Message: 1 Date: Tue, 14 Jun 2011 16:06:49 +1000 From: Bob Birchall <b...@calyx.net.au> Subject: Re: [Koha] Uploading the database from excel to KOHA : Copies not available / Missing To: koha@lists.katipo.co.nz Message-ID: <4df6fa79.6050...@calyx.net.au> Content-Type: text/plain; charset=ISO-8859-1; format=flowed On 14/06/11 15:27, R Sunil Kumar wrote: > Dear All, > > I am trying to upload the database from excel file to KOHA below are the > list of fields available in the excel sheet and the corresponding MARC > tags code. Be careful using Excel for this exercise - it will embed non-printing characters in your data. Use Libre Office and keep your file in csv format. > > But when I upload the data to the KOHA using MarcEdit Software, as there > is multiple copies of single ISBN number, I have used the matching rules > (ISBN as unique identifier) and it had successfully matched the record > and displayed the record number wherever there is a matching of records > (biblio number). Database is successfully created message comes and > display the biblio number. > > But when I do OPAC search it display two option. > > Error 1: Copies does not exit > > Error 2: Copies available in (library branch name) but when I try to > Place Hold, it shows copies not available or missing. You don't seem to have branch data in your holdings statement (952). Koha requires both Home Branch (952$a) and Holding Branch (952$b). Refer to Koha to Marc Mapping on the Administration page for the fields expected by Koha. You do have Location (952$c) so if that is your library/branch, change it to 952$a then copy that to 952$b. The value must match exactly (including case) a value in your Libraries definition (Administration/Libraries, Branches, Groups). But first move Condition from 952$a to a more suitable sub-field. Hope that helps, Bob Birchall CALYX ------------------------------ Message: 2 Date: Tue, 14 Jun 2011 11:39:21 +0530 From: "R Sunil Kumar" <sunil.ku...@ecoleglobal.com> Subject: Re: [Koha] Uploading the database from excel to KOHA : Copies not available / Missing To: "'Ata ur Rehman'" <ata.reh...@gmail.com> Cc: koha@lists.katipo.co.nz Message-ID: <000f01cc2a59$9cdae970$d690bc50$@ku...@ecoleglobal.com> Content-Type: text/plain; charset="utf-8" Dear Rehman, But I have barcode also where I have already given 952$p wont? that clash with Accession Number MARC Tag. I need to use barcode for the circulation purpose. Thanks and Regards R Sunil Kumar Library Technologist +91-9686576695 From: Ata ur Rehman [mailto:ata.reh...@gmail.com] Sent: 14 June 2011 11:31 To: sunil.ku...@ecoleglobal.com Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Uploading the database from excel to KOHA : Copies not available / Missing Sunil Put your accession number in 952$p and re import the records Ata 2011/6/14 R Sunil Kumar <sunil.ku...@ecoleglobal.com> Dear All, I am trying to upload the database from excel file to KOHA below are the list of fields available in the excel sheet and the corresponding MARC tags code. But when I upload the data to the KOHA using MarcEdit Software, as there is multiple copies of single ISBN number, I have used the matching rules (ISBN as unique identifier) and it had successfully matched the record and displayed the record number wherever there is a matching of records (biblio number). Database is successfully created message comes and display the biblio number. But when I do OPAC search it display two option. Error 1: Copies does not exit Error 2: Copies available in (library branch name) but when I try to Place Hold, it shows copies not available or missing. Accession Number 082$b Language 041$a Language 041$a Language 041$a Location 952$c Status 952$4 CallNumber 082$a Title 245$a Reminder Title 245$b Author 1 245$c Author 2 700$a Author 3 700$a ISBN 020$a Barcode 952$p Publisher Name 260$b Place of Publication 260$a Year of Publication 260$c Subject 1 650$v Subject 2 650$v Subject 3 650$v Volume 440$v Pages 300$a Cover Type (Paperback/Hardbound) 300$b Edition 260$a Editor 700$a Translator 700$a Series Name 490$a Price 952$o Currency Condition 952$a Receipt Date Remark 500$a Can anybody please share the pre-migration / post migration requirements for migration database from Excel to Koha. Thanks and Regards R Sunil Kumar Library Technologist cid:image001.jpg@01CC250B.5782A730 Ecole Solutions Pvt Ltd Level 15 Concorde Towers UB City 1 Vittal Mallya Road Bangalore 560001,India Mobile: +91 9686576695 Fax: +91 80 40300400 <tel:%2B91%2080%2040300400> eMail: sunil.ku...@ecoleglobal.com Web: www.ecoleglobal.com _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20110614/46f788db/attac hment.htm -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: image/jpeg Size: 3889 bytes Desc: not available Url : http://lists.katipo.co.nz/pipermail/koha/attachments/20110614/46f788db/attac hment.jpeg ------------------------------ _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 68, Issue 57 ************************************ _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha