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

[Ata ur Rehman]

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/6396b348/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/6396b348/attachment-0001.jpeg