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

[R Sunil Kumar]

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

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 <tel:%2B91%2080%2040300400> 

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/46f788db/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/46f788db/attachment-0001.jpeg