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-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request@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-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. 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 <bob@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.6050301@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.kumar@ecoleglobal.com> Subject: Re: [Koha] Uploading the database from excel to KOHA : Copies not available / Missing To: "'Ata ur Rehman'" <ata.rehman@gmail.com> Cc: koha@lists.katipo.co.nz Message-ID: <000f01cc2a59$9cdae970$d690bc50$@kumar@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.rehman@gmail.com] Sent: 14 June 2011 11:31 To: sunil.kumar@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.kumar@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.kumar@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