[Koha] How to handle multiple copies/items or authors while converting excel data to MARC

[Olugbenga Adara]

Hi Nanaji,

To start with the authors, you should have each author in its own cell in excel. Then export out in excel in tab delimited, rather than comma. Then map the additional author fields to 700$a in MarcEdit. Only the first (main author) should be mapped to 100$a.

As per the accession number, what I do is to export out the first copy, use MarcEdit to convert the file to Marc and then import into Koha. Then I repeat the step for subsequent copies. I have not yet been able to understand how to get Marcedit to generate multiple 952 lines for accession numbers in a single file.

Some others may be able to shed more light on that!

Olugbenga Adara
+2348033220288
Sent from a Mobile Device. Please excuse typos and brevity.

On Apr 26, 2013, at 5:30 AM, gipelibrary pune <gipelibrary at gmail.com> wrote:

> Dear All
> 
> 
> 
> Greetings from the GIPE Library!
> 
> 
> 
> I have the bibliographic data in excel format. In accession Number column,
> I have the range of accession numbers say (23001-23005) for a single title
> having five copies. Will MARCEDIT take care if I separate each accession
> number with 'comma' or do I need to use any other special character as data
> separator.
> 
> 
> 
> Similarly in Author field, I have more than one authors, say (Ranganathan,
> S R and Gopinath, M A and Prasad, A R D) for a single title. What should be
> the data separator for this field so that I can export the data from excel
> to MARC using MARCEDIT. Here in this case, I do not wish to use 'Comma' as
> it is already used for separating surname and the Initials.
> 
> 
> 
> Awaiting your replies.
> 
> 
> 
> Regards
> 
> -- 
> Dr Nanaji Shewale
> Librarian
> Gokhale Institute of Politics and Economics
> B M C C Road, Deccan Gymkhana
> Pune 411004 (India)
> T: 91 20 25679940 (Direct)
> T: 91 20 25654288, 25650287 Ext 401
> http://www.gipe.ac.in
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha