S.Anand,<br><br><br>Bob's right, you should use Koha 3.6, or at the very least Koha 3.4.5. These versions separate the items from the biblios, you could migrate the values from the Excel document right into the items table in the Koha database, without needing to muck about with the 952 field. You'd just need to know the biblionumber and biblioitemnumber (should always be the same value) of each title you want to connect the items to.<br>
<br><br>-Ian<br><br><div class="gmail_quote">2011/11/7 Bob Birchall <span dir="ltr"><<a href="mailto:bob@calyx.net.au">bob@calyx.net.au</a>></span><br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<u></u>
<div bgcolor="#ffffff" text="#000000">
Also, you are implementing a very old version of Koha. The current
version is 3.06.00. I hope you are getting Koha from the right
place: <a href="http://koha-community.org" target="_blank">http://koha-community.org</a><br>
<br>
Bob Birchall<br>
Calyx<div><div></div><div class="h5"><br>
<br>
On 07/11/11 18:05, Hugo Agud wrote:
<blockquote type="cite">
<div>Hi using</div>
<div><br>
</div>
<div>Marc edit 5.5 you have to select each fiedl, select all 952
button.right mouse and select join</div>
<div><br>
</div>
<div>Br<br>
<br>
Enviado desde mi iPad, disculpen los errores tipográficos y
ortográficos</div>
<div><br>
El 07/11/2011, a las 07:11, S Anand <<a href="mailto:sanand1948@gmail.com" target="_blank">sanand1948@gmail.com</a>>
escribió:<br>
<br>
</div>
<blockquote type="cite">
<div>Dear all,<br>
<br>
I am trying to migrate data which is in Excel<b> </b>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:<br>
<br>
=952 \\$aAG<br>
=952 \\$bAG<br>
=952 \\$g695<br>
=952 \\$o420 TON<br>
=952 \\$pGN 1<br>
=952 \\$yBK<br>
<br>
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:<br>
<br>
=952 \\$aAG$bAG$g695$o420 TON$pGN 1$yBK<br>
<br>
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?<br>
<br>
(Note: We are using Koha Version: 3.00.05.003)<br>
<br>
Looking forward to hearing from you,<br>
<br>
Regards,<br>
<br>
S.Anand<br>
<br>
</div>
</blockquote>
<blockquote type="cite">
<div><span>_______________________________________________</span><br>
<span>Koha mailing list <a href="http://koha-community.org" target="_blank">http://koha-community.org</a></span><br>
<span><a href="mailto:Koha@lists.katipo.co.nz" target="_blank">Koha@lists.katipo.co.nz</a></span><br>
<span><a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a></span><br>
</div>
</blockquote>
<pre><fieldset></fieldset>
_______________________________________________
Koha mailing list <a href="http://koha-community.org" target="_blank">http://koha-community.org</a>
<a href="mailto:Koha@lists.katipo.co.nz" target="_blank">Koha@lists.katipo.co.nz</a>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a>
</pre>
</blockquote>
<br>
</div></div><font color="#888888"><pre cols="72">--
Bob Birchall
Director
Calyx Group Pty Limited
Mob: 0414 796 988
Email: <a href="mailto:bob@calyx.net.au" target="_blank">bob@calyx.net.au</a>
Web: <a href="http://www.calyx.net.au" target="_blank">www.calyx.net.au</a>
Participating in the Koha Open ILS project:
<a href="http://koha-community.org" target="_blank">http://koha-community.org</a></pre>
</font></div>
<br>_______________________________________________<br>
Koha mailing list <a href="http://koha-community.org" target="_blank">http://koha-community.org</a><br>
<a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Ian Walls<br>Lead Development Specialist<br>ByWater Solutions<br>Phone # (888) 900-8944<br><a href="http://bywatersolutions.com" target="_blank">http://bywatersolutions.com</a><br>
<a href="mailto:ian.walls@bywatersolutions.com" target="_blank">ian.walls@bywatersolutions.com</a><br>Twitter: @sekjal<br>