<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">Hi Ashok,<br><br>If I understand your post well, you mean in some instances you see items while in other instances in the same batch, you see no items.<br><br>I would advice you check your marc records very well. You may also try the command line bulkmarcimport tool or try upgrading to 3.2.10 and try again.<br><br>Olugbenga Adara<br>
<br>
<br><br>--- On <b>Thu, 8/25/11, Ashok Gangurde <i><ashokg9696@gmail.com></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Ashok Gangurde <ashokg9696@gmail.com><br>Subject: Re: [Koha] Fwd: Help with MarcEdit Delimited Text Translator<br>To: "Olugbenga Adara" <gbengaadara@yahoo.com><br>Cc: koha@lists.katipo.co.nz<br>Date: Thursday, August 25, 2011, 6:41 AM<br><br><div id="yiv1306132965"><div> </div><div>Dear Sir</div><div> </div><div>Please find the attached file of MARC VIEW of both title from OPAC</div><div> </div><div>1) display ITEM available</div><div> </div><div>2) NO ITEM AVAILABLE</div><div> </div>
<div>both title import in koha same excel file.</div><div> </div><div>We are mapping all required field in 950 tag</div><div> <br> </div><div>WE ARE USEING KOHA VERSION (LINUX) 3.0006010</div><div> </div><div> </div><div>
Please guide me in this matter</div><div> </div><div>Thanks & Regards</div><div>Ashok</div><div> </div><h1><font size="2">********</font></h1><div> </div><h1><font size="2">System preferences admin</font></h1><div>
</div><h2><font size="2">all preferences</font></h2><div>
</div><div><table id="yiv1306132965sysprefst" width="80%">
<thead><tr>
<th class="yiv1306132965header yiv1306132965headerSortDown">Preference</th>
<th>Explanation</th>
<th>Value</th>
<th>Edit</th>
<th>Delete</th>
</tr></thead>
<tbody>
<tr>
<td><strong><a rel="nofollow" target="_blank" href="http://192.168.0.9:8090/cgi-bin/koha/admin/systempreferences.pl?op=add_form&searchfield=NoZebra">NoZebra</a></strong></td><td>
If ON, Zebra indexing is turned off, simpler setup, but slower
searches. WARNING: using NoZebra on even modest sized collections is
very slow.</td>
<td class="yiv1306132965single-line">
<form target="_blank" method="post" >
<input name="value" value="1" type="radio">
<label class="yiv1306132965yesno" for="value">ON</label>
<input name="value" value="0" type="radio">
<label class="yiv1306132965yesno" for="value-no">OFF</label>
</form>
</td>
<td><a rel="nofollow" target="_blank" href="http://192.168.0.9:8090/cgi-bin/koha/admin/systempreferences.pl?op=add_form&searchfield=NoZebra">Edit </a></td>
<td><a rel="nofollow" target="_blank" href="http://192.168.0.9:8090/cgi-bin/koha/admin/systempreferences.pl?op=delete_confirm&searchfield=NoZebra">Delete</a></td>
</tr><tr class="yiv1306132965highlight">
<td><strong><a rel="nofollow" target="_blank" href="http://192.168.0.9:8090/cgi-bin/koha/admin/systempreferences.pl?op=add_form&searchfield=NoZebraIndexes">NoZebraIndexes</a></strong></td><td> Enter a specific hash for NoZebra indexes. Enter : 'indexname' => '100a,245a,500*','index2' => '...'</td>
<td>
<form target="_blank" method="post" >
<a rel="nofollow" class="yiv1306132965expand-textarea" target="_blank" href="http://192.168.0.9:8090/cgi-bin/koha/admin/systempreferences.pl#">Click to Edit</a>
</form>
</td>
<td><a rel="nofollow" target="_blank" href="http://192.168.0.9:8090/cgi-bin/koha/admin/systempreferences.pl?op=add_form&searchfield=NoZebraIndexes">Edit </a></td>
<td><a rel="nofollow" target="_blank" href="http://192.168.0.9:8090/cgi-bin/koha/admin/systempreferences.pl?op=delete_confirm&searchfield=NoZebraIndexes">Delete</a></td></tr></tbody></table></div><div style="text-align: left;"><br></div><div style="text-align: left;">
</div><div style="text-align: left;">*************</div><div style="text-align: left;">MARC VIEW IN OPAC</div><div style="text-align: left;"> </div><h1 style="text-align: left; clear: both;">Ships Visual Encyclopedia (Record no. 5421)</h1>
<div style="text-align: left;">
</div><div style="text-align: left;"><table id="yiv1306132965marc">
<tbody><tr><th colspan="2">000 -LEADER</th></tr>
<tr>
<td>fixed length control field</td>
<td>00699nam a2200205Ia 4500</td>
</tr>
<tr><th colspan="2">003 - CONTROL NUMBER IDENTIFIER</th></tr>
<tr>
<td>control field</td>
<td>OSt</td>
</tr>
<tr><th colspan="2">005 - DATE AND TIME OF LATEST TRANSACTION</th></tr>
<tr>
<td>control field</td>
<td>20110824154150</td>
</tr>
<tr><th colspan="2">008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION</th></tr>
<tr>
<td>fixed length control field</td>
<td>110824s9999 xx 000 0 und d</td>
</tr>
<tr><th colspan="2">020 ## - INTERNATIONAL STANDARD BOOK NUMBER</th></tr>
<tr>
<td>International Standard Book Number</td>
<td>9781907446269</td>
</tr>
<tr><th colspan="2">040 ## - CATALOGING SOURCE</th></tr>
<tr>
<td>Transcribing agency</td>
<td>ENG</td>
</tr>
<tr><th colspan="2">082 ## - DEWEY DECIMAL CLASSIFICATION NUMBER</th></tr>
<tr>
<td>Item number</td>
<td>1228</td>
</tr>
<tr>
<td>Classification number</td>
<td>G.11</td>
</tr>
<tr><th colspan="2">100 ## - MAIN ENTRY--PERSONAL NAME</th></tr>
<tr>
<td>Personal name</td>
<td>David Ross</td>
</tr>
<tr><th colspan="2">245 ## - TITLE STATEMENT</th></tr>
<tr>
<td>Title</td>
<td>Ships Visual Encyclopedia</td>
</tr>
<tr><th colspan="2">260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)</th></tr>
<tr>
<td>Place of publication, distribution, etc</td>
<td>London</td>
</tr>
<tr>
<td>Name of publisher, distributor, etc</td>
<td>Amber Books Ltd</td>
</tr>
<tr>
<td>Date of publication, distribution, etc</td>
<td>2010</td>
</tr>
<tr><th colspan="2">300 ## - PHYSICAL DESCRIPTION</th></tr>
<tr>
<td>Extent</td>
<td>448</td>
</tr>
<tr><th colspan="2">530 ## - ADDITIONAL PHYSICAL FORM AVAILABLE NOTE</th></tr>
<tr>
<td>Availability source</td>
<td>HONG KONG</td>
</tr>
<tr><th colspan="2">650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM</th></tr>
<tr>
<td>Topical term or geographic name as entry element</td>
<td>General</td>
</tr>
<tr><th colspan="2">942 ## - ADDED ENTRY ELEMENTS (KOHA)</th></tr>
<tr>
<td>Koha item type</td>
<td>BOOKS</td>
</tr>
</tbody></table></div><div style="text-align: left;">
</div><p style="text-align: left;">No copies available.</p><div><br></div><div class="yiv1306132965gmail_quote">On Wed, Aug 24, 2011 at 1:07 PM, Olugbenga Adara <span dir="ltr"><<a rel="nofollow" ymailto="mailto:gbengaadara@yahoo.com" target="_blank" href="/mc/compose?to=gbengaadara@yahoo.com">gbengaadara@yahoo.com</a>></span> wrote:<br>
<blockquote style="margin: 0px 0px 0px 0.8ex; padding-left: 1ex; border-left: 1px solid rgb(204, 204, 204);" class="yiv1306132965gmail_quote"><table border="0" cellpadding="0" cellspacing="0">
<tbody><tr><td style="font: inherit;" valign="top">Hi Ashok,<br><br>What version of Koha are you running? What you described has happened to me with 3.4 versions. <br><br>
You may click one of the records in the OPAC search results and download the marc format. Using marcedit again, cross check that you have your marc tags right, especially the 952 fields.<br><br>And please also make sure that zebraqueue daemon is not running. I don't think it is compatible with 3.4 It recently messed up the index on two of my installs recently.<br>
<br>Olugbenga Adara<br>
<br>
<br>--- On <b>Wed, 8/24/11, Ashok Gangurde <i><<a rel="nofollow" ymailto="mailto:ashokg9696@gmail.com" target="_blank" href="/mc/compose?to=ashokg9696@gmail.com">ashokg9696@gmail.com</a>></i></b> wrote:<br><blockquote style="padding-left: 5px; margin-left: 5px; border-left: 2px solid rgb(16, 16, 255);">
<br>From: Ashok Gangurde <<a rel="nofollow" ymailto="mailto:ashokg9696@gmail.com" target="_blank" href="/mc/compose?to=ashokg9696@gmail.com">ashokg9696@gmail.com</a>><br>Subject: [Koha] Fwd: Help with MarcEdit Delimited Text Translator<div class="yiv1306132965im"><br>To: <a rel="nofollow" ymailto="mailto:koha@lists.katipo.co.nz" target="_blank" href="/mc/compose?to=koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a><br>
</div>Date: Wednesday, August 24, 2011, 1:35 PM<div><div></div><div class="yiv1306132965h5"><br><br><div><div><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><div><br> </div><div>2011/8/6 Olugbenga Adara <span dir="ltr"><<a rel="nofollow" target="_blank" href="http://mc/compose?to=gbengaadara@yahoo.com">gbengaadara@yahoo.com</a>></span><br>
<blockquote style="margin: 0px 0px 0px 0.8ex; padding-left: 1ex; border-left: 1px solid rgb(204, 204, 204);"><table border="0" cellpadding="0" cellspacing="0">
<tbody><tr><td style="font: 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 rel="nofollow" target="_blank" href="http://manual.koha-community.org/3.4/en/implementation.html#imp-migration">http://manual.koha-community.org/3.4/en/implementation.html#imp-migration</a> and<br>
<a rel="nofollow" target="_blank" href="http://manual.koha-community.org/3.4/en/catguides.html#itemcatguide">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 rel="nofollow" target="_blank" href="http://gbengaadara.blogspot.com">http://gbengaadara.blogspot.com</a><br>
Twitter: <a rel="nofollow" target="_blank" href="http://twitter.com/gbengaadara">http://twitter.com/gbengaadara</a><br>
Profile: <a rel="nofollow" target="_blank" href="http://www.linkedin.com/in/gbengaadara">http://www.linkedin.com/in/gbengaadara</a><br><br>--- On <b>Sat, 8/6/11, Christine Othitis <i><<a rel="nofollow" target="_blank" href="http://mc/compose?to=cothitis@telus.net">cothitis@telus.net</a>></i></b> wrote:<br>
<blockquote style="padding-left: 5px; margin-left: 5px; border-left: 2px solid rgb(16, 16, 255);"><br>From: Christine Othitis <<a rel="nofollow" target="_blank" href="http://mc/compose?to=cothitis@telus.net">cothitis@telus.net</a>><br>
Subject: [Koha] Help with MarcEdit Delimited Text Translator<br>To: <a rel="nofollow" target="_blank" href="http://mc/compose?to=koha@lists.katipo.co.nz">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 rel="nofollow" target="_blank" href="http://manual.koha-community.org/3.4/en/marceditexcel.html">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 rel="nofollow" target="_blank" href="http://koha-community.org">http://koha-community.org</a><br>
<a rel="nofollow" target="_blank" href="http://mc/compose?to=Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br><a rel="nofollow" target="_blank" href="http://lists.katipo.co.nz/mailman/listinfo/koha">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
</div></blockquote></td></tr></tbody></table><br>_______________________________________________<br>
Koha mailing list <a rel="nofollow" target="_blank" href="http://koha-community.org">http://koha-community.org</a><br>
<a rel="nofollow" target="_blank" href="http://mc/compose?to=Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a rel="nofollow" target="_blank" href="http://lists.katipo.co.nz/mailman/listinfo/koha">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
<br></blockquote></div><br>
</div></div></div><br>
</div><br>-----Inline Attachment Follows-----<br><br><div>_______________________________________________<br>Koha mailing list <a rel="nofollow" target="_blank" href="http://koha-community.org">http://koha-community.org</a><br><a rel="nofollow" target="_blank" href="http://mc/compose?to=Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a rel="nofollow" target="_blank" href="http://lists.katipo.co.nz/mailman/listinfo/koha">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br></div></div></div></blockquote></td></tr></tbody></table></blockquote></div><br>
</div><br>-----Inline Attachment Follows-----<br><br><div class="plainMail">_______________________________________________<br>Koha mailing list <a href="http://koha-community.org" target="_blank">http://koha-community.org</a><br><a ymailto="mailto:Koha@lists.katipo.co.nz" href="/mc/compose?to=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></div></blockquote></td></tr></table>