[Koha] Koha Digest, Vol 68, Issue 57

R Sunil Kumar sunil.kumar at ecoleglobal.com
Tue Jun 14 18:34:11 NZST 2011


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 at lists.katipo.co.nz
[mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of
koha-request at lists.katipo.co.nz
Sent: 14 June 2011 11:40
To: koha at lists.katipo.co.nz
Subject: Koha Digest, Vol 68, Issue 57

Send Koha mailing list submissions to
	koha at 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 at lists.katipo.co.nz

You can reach the person managing the list at
	koha-owner at 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 at calyx.net.au>
Subject: Re: [Koha] Uploading the database from excel to KOHA : Copies
	not available / Missing
To: koha at lists.katipo.co.nz
Message-ID: <4DF6FA79.6050301 at 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 at ecoleglobal.com>
Subject: Re: [Koha] Uploading the database from excel to KOHA : Copies
	not	available / Missing
To: "'Ata ur Rehman'" <ata.rehman at gmail.com>
Cc: koha at lists.katipo.co.nz
Message-ID: <000f01cc2a59$9cdae970$d690bc50$@kumar at 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 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/attac
hment.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/attac
hment.jpeg 

------------------------------

_______________________________________________
Koha mailing list
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


End of Koha Digest, Vol 68, Issue 57
************************************



More information about the Koha mailing list