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 _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
