[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