Rudy, <br><br>Zebra takes data from the marcxml column in biblioitems table. It is best to migrate using Marcedit (to create Marc files). <br><br>Thanks, <br>Savitra Sirohi<br>Nucsoft OSS Labs<br><a href="http://www.osslabs.biz">http://www.osslabs.biz</a><br>
<br><br><div class="gmail_quote">2009/5/6 ISM KIS <span dir="ltr"><<a href="mailto:Ism@kis.in">Ism@kis.in</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div style="margin: 4px 4px 1px; font-family: Tahoma; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;">
<div>I have to insert all our textbooks from a textfile.</div>
<div> </div>
<div>I have created the following stored procedures to do that:</div>
<div> </div>
<div>CREATE PROCEDURE `InsertBiblio`(IN MyTitle VARCHAR(120), IN MyEdition VARCHAR(120), IN MyAuthor VARCHAR(120), IN MyISBN VARCHAR(120), IN MyYear INTEGER(11), IN MyPublisher VARCHAR(120), IN MyVendor VARCHAR(20), IN MyBugetCategory VARCHAR(120), IN param9 VARCHAR(120), IN param10 VARCHAR(120), IN param11 INTEGER(11), IN param12 INTEGER(11), IN param13 VARCHAR(120), IN MyCost TEXT, IN param15 VARCHAR(120))<br>
NOT DETERMINISTIC<br> SQL SECURITY DEFINER<br> COMMENT ''<br>BEGIN</div>
<div> </div>
<div>declare MyBiblionumber integer;<br>declare MyBiblioitemnumber integer;</div>
<div> </div>
<div>insert into biblio (title,author,copyrightdate,frameworkcode) values(MyTitle,MyAuthor,MyYear,'BKS');</div>
<div> </div>
<div>set MyBiblionumber = LAST_INSERT_ID() ;</div>
<div><br>insert into biblioitems (biblionumber,isbn,itemtype) value(MyBiblionumber,MyISBN,'BK');<br>set MyBiblioitemnumber = LAST_INSERT_ID() ;<br>select MyBiblionumber as Biblionumber, MyBiblioitemnumber as Biblioitemnumber ;</div>
<div> </div>
<div>END;</div>
<div> </div>
<div>CREATE PROCEDURE `InsertItem`(IN MyBiblionumber INTEGER(11), IN MyBiblioitemnnumber INTEGER(11), IN MyBarcode VARCHAR(120))<br> NOT DETERMINISTIC<br> SQL SECURITY DEFINER<br> COMMENT ''<br>BEGIN<br>
insert into items (biblionumber,biblioitemnumber, barcode, homebranch) values(Mybiblionumber,MyBiblioitemnnumber,Mybarcode,'TextBook');<br>END;</div>
<div> </div>
<div>But I must miss something because (after rebuild_zebra.pl) I can't find the textbook.</div>
<div> </div>
<div><b>Are there more tables I have to update then (biblio, biblioitems, and items) ?</b></div>
<div> </div>
<div>Rudy Wuthrich</div>
<div>Kodaikanal International School</div>
<br>
<br></div>
<br>_______________________________________________<br>
Koha mailing list<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>