- Koha - lists.katipo.co.nz

Advance search limits by language
by Shelley Sii 20 Mar '09

20 Mar '09

Dear all, Advance search limits by language is not working although I add a line 'language' =>'008:35-37' to NoZebraIndexes I read from CCL Indexing Chart which language only index from 041, but I think 008:35-37 will be more specific. Anyone can help? Shelley Sii 徐微菁 Assistant Librarian Logos Evangelical Seminary 正道福音神學院 Tel : 626-571-5110 ext.124 Fax : 626-571-5119 <http://www.logos-seminary.edu> www.logos-seminary.edu

1 0

MARC to Koha mapping of item records
by Beth Willis 20 Mar '09

20 Mar '09

Dear list, I am mapping item records from our current system to Koha. Not all of the fields in our item record are represented on the item linking table. For example, I don't see a Koha field for total checkouts in the items table. Is it possible to add this field? Can this be done through the GUI? Thanks for your help. -- Beth Willis Catalog & Digital Librarian North of Boston Library Exchange, Inc. Danvers, Massachusetts willis(a)noblenet.org

3 2

painful upgrade from 2.25 to 3.0.1: incomplete tables
by ghenry 20 Mar '09

20 Mar '09

hello all, i'm following the document: http://wiki.koha.org/doku.php?id=22_to_30 and it's failing when executing the script koha-3.00.01-stable/misc/migration_tools/22_to_30/rebuild_unimarc_100.pl Creating/updating field 100 if needed DBD::mysql::st execute failed: Unknown column 'done' in 'where clause' at /usr/local/koha/lib/C4/Biblio.pm line 2299. DBD::mysql::st fetchrow_array failed: fetch() without execute() at /usr/local/koha/lib/C4/Biblio.pm line 2300. Use of uninitialized value in numeric eq (==) at /usr/local/koha/lib/C4/Biblio.pm line 2302. ... the reason is that the zebraqueue table isn't as expected: CREATE TABLE `zebraqueue` ( `id` int(11) NOT NULL auto_increment, `biblio_auth_number` int(11) NOT NULL default '0', `operation` char(20) NOT NULL default '', `server` char(20) NOT NULL default '', `done` int(11) NOT NULL default '0', `time` timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `zebraqueue_lookup` (`server`, `biblio_auth_number`, `operation`, `done`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; but my actual table looks like: CREATE TABLE `zebraqueue` ( `id` int(11) NOT NULL AUTO_INCREMENT, `biblio_auth_number` int(11) NOT NULL DEFAULT '0', `operation` char(20) NOT NULL DEFAULT '', `server` char(20) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=9555 DEFAULT CHARSET=utf8; as you can see, done and time are missing, so my guess is that something was wrong during the script execution, update22to30.pl ? The only errors i had are: 090319 9:23:24 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072 DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`BDkoha4_test`.`#sql-455b_55bd`, CONSTRAINT `#sql-455b_55bd_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE) at /home/henry/koha-3.00.01-stable/installer/data/mysql/update22to30.pl line 3442. ==================== An error occured during : alter table items ADD FOREIGN KEY holdingbranch (holdingbranch) REFERENCES branches (branchcode) on update CASCADE on delete RESTRICT It probably means there is something wrong in your DB : a row (items.holdingbranch) refers to a value in branches.branchcode that does not exist. solve the problem and run updater again (or just the previous SQL statement). You can find those values with select items.* from items where holdingbranch not in (select branchcode from branches) ==================== the last error is easily corrected, but for the first one, i have no idea if it's related to the uncomplete table? and how can i verify if others tables where affected during the update process? thanks in advance for reply, gerard

2 6

Koha to MARC mapping
by Beth Willis 20 Mar '09

20 Mar '09

Dear list members, How can I modify the Koha to MARC mapping table? Thank you. -- Beth Willis Catalog & Digital Librarian North of Boston Library Exchange, Inc. Danvers, Massachusetts willis(a)noblenet.org

2 1

Re: [Koha] Firefox on Windows XP and Koha
by Emrys Minnig 20 Mar '09

20 Mar '09

I had a similar problem with Koha 3.0.0 on FF3/WinXP (with no add-ons), but I noticed that the slowdown was progressive. In other words, the first few records seemed to process rather quickly after hitting the 'Save' button, but as more records were added, it got slower and slower. However, after 'Clearing private data' from FF's 'Tools' menu, everything sped up again. (Perhaps Koha was desperately looking for cached data?) Now I've set up my browser to clear all private data whenever I close it... Hope that helps! Emrys ________________________________ From: koha-bounces(a)lists.katipo.co.nz on behalf of Beda Szukics Sent: Mon 16/03/2009 16:46 To: Koha-Mailingliste Subject: [Koha] Firefox on Windows XP and Koha Hello all I'd like to use Firefox (3.0.7) on WindowXP to work with Koha. Most of the things do all right. But adding MARC-Records the Firefox takes about half a minute to save the record (and the harddisk is quite busy). Why is that so? I tried Safary and Google Chrome: those two don't show this behaviour. Also using Firefox with Linux (Ubuntu). Beda _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

6 9

Re: [Koha] Hiding lost items
by Olugbenga Adara 19 Mar '09

19 Mar '09

Hello Savitra, I will check the link. Thanks Olugbenga Adara Mobile: 234-803-3220288 --- On Thu, 3/19/09, savitra sirohi <savitra.sirohi(a)osslabs.biz> wrote: > From: savitra sirohi <savitra.sirohi(a)osslabs.biz> > Subject: Re: [Koha] Hiding lost items > To: "Olugbenga Adara" <gbengaadara(a)yahoo.com> > Date: Thursday, March 19, 2009, 12:29 AM > Olubenga, > > This post has information on your problem: > http://www.nabble.com/Lost-items-display-td17190147.html > > Thanks, > Savitra Sirohi > Nucsoft OSS Labs > http://www.osslabs.biz > > On Wed, Mar 18, 2009 at 3:42 AM, Olugbenga Adara <gbengaadara(a)yahoo.com> > wrote: > > > > Hello all, > > > > If i enable the hide lost items systems preferences > OPAC searches does not work. what do i need to do to enable > hide lost items and still have non lost items show up in > opac search? > > > > Thanks so much for your help. > > > > Olugbenga Adara > > Mobile: 234-803-3220288 > > > > > > > > _______________________________________________ > > Koha mailing list > > Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > >

1 0

Re: [Koha] Item Type Defined in MARC
by Doug Dearden 19 Mar '09

19 Mar '09

Just looked again, also put it into 942$c. Doug >>> "Doug Dearden" <dearden(a)sarsf.org> 3/19/2009 11:57:21 AM >>> Ed, I believe your answer is in here: =952 \\$bFiction$hFIC DLA$pT0025982$t1$xFSC@aR@b148@c20081014@i1@jHardcover@fFollett$xFUND: District$aSHS The $x fields contain the detail info that was exported from Follett. I think the item code you are looking for in this example is "R". The string that starts $xFSC has fields that are delimited by "@". The item type is in the @a field. The script I sent and later posted to the web site contains code to do the conversion, if you use it you need to modify it to convert from your Follett item type codes to your koha item type codes. Looking at the script I put it into the 952$y field. Best, Doug >>> "Roche III, Edward" <edward_roche(a)solanco.k12.pa.us> 3/19/2009 11:34:27 AM >>> That is what I am trying to do . The only thing I can find for Follett is it put a 3 character code in the LDR field at position 5, 6 and 7 to represent the type of item. Anyone that migrates from Follett how did you assign your item types? Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?" From: Joe Atzberger [mailto:ohiocore@gmail.com] Sent: Thursday, March 19, 2009 12:59 PM To: Roche III, Edward Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Item Type Defined in MARC You should create the itemtype codes in Koha to match your data, or edit your data to match your new codes. The question you are asking is better directed to a FOLLETT group regarding where that system outputs itemtype. --Joe 2009/3/19 Roche III, Edward <edward_roche(a)solanco.k12.pa.us> Good Morning All Does anyone know where in MARC is the item type defined? In my exported data from Follett I dont see anything that looks like the item type codes that are in Koha. Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?" _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Re: [Koha] Item Type Defined in MARC
by Doug Dearden 19 Mar '09

19 Mar '09

Ed, I believe your answer is in here: =952 \\$bFiction$hFIC DLA$pT0025982$t1$xFSC@aR@b148@c20081014@i1@jHardcover@fFollett$xFUND: District$aSHS The $x fields contain the detail info that was exported from Follett. I think the item code you are looking for in this example is "R". The string that starts $xFSC has fields that are delimited by "@". The item type is in the @a field. The script I sent and later posted to the web site contains code to do the conversion, if you use it you need to modify it to convert from your Follett item type codes to your koha item type codes. Looking at the script I put it into the 952$y field. Best, Doug >>> "Roche III, Edward" <edward_roche(a)solanco.k12.pa.us> 3/19/2009 11:34:27 AM >>> That is what I am trying to do . The only thing I can find for Follett is it put a 3 character code in the LDR field at position 5, 6 and 7 to represent the type of item. Anyone that migrates from Follett how did you assign your item types? Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?" From: Joe Atzberger [mailto:ohiocore@gmail.com] Sent: Thursday, March 19, 2009 12:59 PM To: Roche III, Edward Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Item Type Defined in MARC You should create the itemtype codes in Koha to match your data, or edit your data to match your new codes. The question you are asking is better directed to a FOLLETT group regarding where that system outputs itemtype. --Joe 2009/3/19 Roche III, Edward <edward_roche(a)solanco.k12.pa.us> Good Morning All Does anyone know where in MARC is the item type defined? In my exported data from Follett I dont see anything that looks like the item type codes that are in Koha. Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?" _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Item Type Defined in MARC
by Roche III, Edward 19 Mar '09

19 Mar '09

Good Morning All Does anyone know where in MARC is the item type defined? In my exported data from Follett I don't see anything that looks like the item type codes that are in Koha. Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?"

2 2

(no subject)
by MATALDA CHARLES 19 Mar '09

19 Mar '09

Daer all , I'm using debian 5.0 but i'd like to confirm that koha 3.0.1 is support following : mysql -sever -4.1 or mysql-server-5 perl 5.8 or perl 5.10 charles(a)biblo.fr _________________________________________________________________ Join the all-new Windows Live Messenger family http://get.live.com

2 1