[Koha] Uploading the database from excel to KOHA : Copies not available / Missing

Ata ur Rehman ata.rehman at gmail.com
Tue Jun 14 18:14:50 NZST 2011


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 at 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 at gmail.com

On Tue, Jun 14, 2011 at 11:09 AM, R Sunil Kumar <sunil.kumar at 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 at gmail.com]
> *Sent:* 14 June 2011 11:31
> *To:* sunil.kumar at ecoleglobal.com
> *Cc:* koha at 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 at 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 at 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 at ecoleglobal.com  Web: www.ecoleglobal.com
>
>
>
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at 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/23349bdf/attachment-0001.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/23349bdf/attachment-0001.jpeg 


More information about the Koha mailing list