<div class="gmail_quote"><div>Dear Sir</div><div> </div><div>I have same query about imort data in koha from excel file.</div><div> </div><div>I had follow the Marc edit method, </div><div>after stage MARC RECORD in koha the result was disply all record import.</div>
<div>While in searching in OPAC there were some problem <font style="background-color: rgb(255, 0, 0);">" NO ITEM"</font></div><div><font style="background-color: rgb(255, 0, 0);"></font> </div><div><font style="background-color: rgb(255, 255, 255);">only title appear but no item found is display in opac</font></div>
<div> </div><div>What to do in this regards?</div><div> </div><div>Please guide me</div><div> </div><div>Thanks and Regards</div><div>Ashok</div><div><div></div><div class="h5"><div><br> </div><div class="gmail_quote">2011/8/6 Olugbenga Adara <span dir="ltr"><<a href="mailto:gbengaadara@yahoo.com" target="_blank">gbengaadara@yahoo.com</a>></span><br>
<blockquote style="margin: 0px 0px 0px 0.8ex; padding-left: 1ex; border-left-color: rgb(204, 204, 204); border-left-width: 1px; border-left-style: solid;" class="gmail_quote"><table border="0" cellspacing="0" cellpadding="0">
<tbody><tr><td style="font: inherit; font-size-adjust: inherit; font-stretch: inherit;" valign="top">Hello Christine,<br><br>Apart from mapping the fields you have in your excel file, you also need to create some other fields like permanent location, holding branch, itemtype and barcode if you need to circulate the items. Also note that the branch code, location, itemtype has to match what you have in Koha.<br>
<br>You may create this fields in excel before converting using marcedit or add them in Marcedit after conversion.<br><br>In addition to the link Nicole sent you, you can also read<br><br><a href="http://manual.koha-community.org/3.4/en/implementation.html#imp-migration" target="_blank">http://manual.koha-community.org/3.4/en/implementation.html#imp-migration</a> and<br>
<a href="http://manual.koha-community.org/3.4/en/catguides.html#itemcatguide" target="_blank">http://manual.koha-community.org/3.4/en/catguides.html#itemcatguide</a><br><br><br>Olugbenga Adara<br>
<br>
Mobile: 234 (0) 8033220288<br>
Home: 234 (2) 8721720<br>
Skype: gbengaadara<br>
Blog: <a href="http://gbengaadara.blogspot.com" target="_blank">http://gbengaadara.blogspot.com</a><br>
Twitter: <a href="http://twitter.com/gbengaadara" target="_blank">http://twitter.com/gbengaadara</a><br>
Profile: <a href="http://www.linkedin.com/in/gbengaadara" target="_blank">http://www.linkedin.com/in/gbengaadara</a><br><br>--- On <b>Sat, 8/6/11, Christine Othitis <i><<a href="mailto:cothitis@telus.net" target="_blank">cothitis@telus.net</a>></i></b> wrote:<br>
<blockquote style="padding-left: 5px; margin-left: 5px; border-left-color: rgb(16, 16, 255); border-left-width: 2px; border-left-style: solid;"><br>From: Christine Othitis <<a href="mailto:cothitis@telus.net" target="_blank">cothitis@telus.net</a>><br>
Subject: [Koha] Help with MarcEdit Delimited Text Translator<br>To: <a href="mailto:koha@lists.katipo.co.nz" target="_blank">koha@lists.katipo.co.nz</a><br>Date: Saturday, August 6, 2011, 5:45 AM<div><div></div><div>
<br><br><div><div><p>Hi group,</p><p> </p><p>I am volunteering with a non-profit organization who has decided to use Koha to catalogue their collection. It exists as an Excel spreadsheet.</p><p> </p><p>Nicole, on this list, pointed me to these instructions for translating the Excel file:</p>
<p> </p><p><a href="http://manual.koha-community.org/3.4/en/marceditexcel.html" rel="nofollow" target="_blank">http://manual.koha-community.org/3.4/en/marceditexcel.html</a></p><p> </p><p>I thought I made the MARC file correctly, but when I tried to import it into Koha, I received an error that said something to the effect of 0 records
were imported, records don’t exist. </p><p> </p><p>I am looking at the tutorial again and I don’t think I mapped the fields correctly as demonstrated in the tutorial.</p><p> </p><p>The spreadsheet contains these fields:</p>
<p> </p><p>Flag</p><p>Title/Description</p><p>Author(s)/Editor/Curator</p><p>Artists Involved</p><p>Pub. Year</p><p>Gallery</p><p>Category</p><p>Location</p><p>Notes</p><p>Borrowed</p><p> </p><p>Do I need to change the column headings to something else? And if so, what would the map to text be? I went to the LOC website, but I can’t understand it :\</p>
<p> </p><p>Thanks,</p><p>Christine</p></div></div><br></div></div>-----Inline Attachment Follows-----<br><br><div>_______________________________________________<br>Koha mailing list <a href="http://koha-community.org" target="_blank">http://koha-community.org</a><br>
<a href="http://mc/compose?to=Koha@lists.katipo.co.nz" target="_blank">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>
</div></blockquote></td></tr></tbody></table><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" target="_blank">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>
</div></div></div><br>