[Koha] Migrating data from Excel to Koha - Problem at 952 Tag

[S Anand]

Dear all,

I am trying to migrate data which is in Excel* *file to Koha using
MarcEdit.  When I convert Excel to MRK file, the data at Tag 952subfileds
(952a, b, g, o, p, etc.)  is appearing on separate lines.  An example of
which is given below:

=952  \\$aAG
=952  \\$bAG
=952  \\$g695
=952  \\$o420 TON
=952  \\$pGN 1
=952  \\$yBK

When I convert the MRK file to MRC file, and migrate to Koha, it is
creating several items - for each item.  Can someone tell me as to how to
make the data appear in one line as below:

=952  \\$aAG$bAG$g695$o420 TON$pGN 1$yBK

We can correct/edit manually - if we have few entries.  Since we have
hundreds of records to migrate, is there any way to do this automatically
for all the records at one go?

(Note: We are using Koha Version: 3.00.05.003)

Looking forward to hearing from you,

Regards,

S.Anand
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20111107/3ebacffb/attachment.html>