Dear Rehman, I do understand that Accession / Barcode Number are unique numbers but as during the circulation which will be used for the circulation. Because Accession Number starts with numeric number but barcode number starts with "BK000....". 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:45 To: koha@lists.katipo.co.nz Subject: Koha Digest, Vol 68, Issue 58 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 (Ata ur Rehman) ---------------------------------------------------------------------- Message: 1 Date: Tue, 14 Jun 2011 11:14:50 +0500 From: Ata ur Rehman <ata.rehman@gmail.com> Subject: Re: [Koha] Uploading the database from excel to KOHA : Copies not available / Missing To: sunil.kumar@ecoleglobal.com Cc: koha@lists.katipo.co.nz Message-ID: <BANLkTi=oBmG6_isHBLvep2w72+8frrbsSA@mail.gmail.com> Content-Type: text/plain; charset="utf-8" Dear Sunil / All Accession number is a unique number assigned to every book in library and in most of cases accession number is used for circulation, holds, etc. But if this is not the case in your situation, you may put other values in barcode 952$p. But no of copies in each biblio record depends upon no of barcodes (952$p) associated with it. 952$p is repeatable tag. Regards Ata ur Rehman ------------------------------ AM Library, National Centre for Physics(NCP), Islamabad http://www.ncp.edu.pk/ http://www.ncplib.co.cc/ Coordinator, LISolutions? info@lisolutions.org http://www.lisolutions.org My profiles: [image: Facebook] <http://www.facebook.com/ataurrehman> [image: LinkedIn] <http://pk.linkedin.com/in/ataurrehman> [image: Flickr]<http://www.flickr.com/photos/lisolutions/> [image: Twitter] <http://twitter.com/ataurrehman> [image: Blogger]<http://www.lisolutions.net/> [image: Delicious] <http://www.delicious.com/ataurrehman> Contact me: [image: Google Talk] ata.rehman [image: Skype] ata.rehman [image: MSN] ata.rehman@gmail.com On Tue, Jun 14, 2011 at 11:09 AM, R Sunil Kumar <sunil.kumar@ecoleglobal.com
wrote:
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
[image: 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
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