- Koha - lists.katipo.co.nz

How to search an item in Koha 3
by Thommy M. 01 Mar '09

01 Mar '09

when I browse to http://myserver I get the search interface. I select Search ISBN in the drop down and give a number that I have saved earlier but Koha responds with No Result found ! No results match your search for “nb,wrdl: 9175740192” in Catalog How can I have Koha 3 to find my stored items?

1 0

How to import non ascii characters with z3950
by Thommy M. 01 Mar '09

01 Mar '09

When I install Koha (3.0.1) on Ubuntu 8.04 following the instructions on http://wiki.koha.org/doku.php?id=koha_3_install_guide_ubuntu_hardy I almost manage to get everything working but Z39.50 import. I want to use this source for my MARC records http://www.kb.se/libris/teknisk-information/libris-via-Z3950/ which states these parameters: Protokollversion: 3 IP-adress: z3950.libris.kb.se Port nr: 210 Databas: libr Services: INITIALIZE, SEARCH, PRESENT, CLOSE, SORT, NAMED RESULT SETS, DELETE RESULT SET, EXPLAIN Typ av sökning: 1 (RPN) Attributset: Bib-1 Postsyntax: MARC21, SUTRS Teckenset: ISO 8859-1 (Latin-1) Posttyper: Full, Brief So I choose MARC21 in Koha. When i comes to look up an ISBN number I find the book and I can import it, but when I look at the text the characters outside ASCII does not look the way I expect. They are only a black rectangle with a white question mark in it. So, again, how can I make Koha import non ASCII characters? I've set utf-8 everywhere in browser,locale,MySQL... Or do I have to make my installation all Latin one as z3950.libris.kb.se says its charset is ISO 8859-1 (Latin-1) ???

1 0

Re: [Koha] Staging of import stalls
by kmkale＠anantcorp.com 01 Mar '09

01 Mar '09

Ed, I also had issues getting zebra working initially as we had most of the biblios in Unicode Marathi.So while I was playing with zebra we used nozebra to get the services off the ground and then switched to zebra once we had solved the zebra search of Unicode Marathi. 1) Turn off noZebra from system preferences. For testing Zebra you can run it from command line. sudo -u ${KOHA_USER} zebrasrv -f /etc/koha/koha-conf.xml adjust the path to koha-conf.xml if different. The first time I ran this it refused to run as it was not finding some directories. I had to create those and change ownerships to koha user. I forget exact paths but a look at the output will tell you. Once its running, do your bulk import by staging and then importing. After that in a separate terminal run misc/migration_tools/rebuild_zebra.pl -b -w This should build your index and then you should be able to search from opac & stff client. 2) Once you have the search going you can run the zebra server and zebraqueue in daemon mode and have them start on system boot. Here is how to do it on Ubuntu, adjust according to your OS. sudo ln -s ${SCRIPT_DIR}/koha-zebra-ctl.sh /etc/init.d/koha-zebra-daemon ${SCRIPT_DIR} is /usr/share/koha/bin/ by default in a standard install. sudo update-rc.d koha-zebra-daemon defaults sudo /etc/init.d/koha-zebra-daemon start Zebraqueue Daemon: sudo ln -s ${SCRIPT_DIR}/koha-zebraqueue-ctl.sh /etc/init.d/koha-zebraqueue-daemon sudo update-rc.d koha-zebraqueue-daemon defaults sudo /etc/init.d/koha-zebraqueue-daemon start Thats it. the zebraqueue will take care of indexing any subsequent additions you make. If you bulk import any more biblios run rebiuld_zebra.pl again as zebraqueue is slower in indexing. Also run rebuild_zebra.pl for your authorities. The daemons will log in /var/log/koha/ Have a look at files in there if something doesn't work out. -- Regards, Koustubha Kale Anant Corporation Contact Details : Address : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka, Thane (w), Maharashtra, India, Pin : 400601. TeleFax : +91-22-21720108, +91-22-21720109 Mobile : +919820715876 Website : http://www.anantcorp.com Original Message: ----------------- From: Roche III, Edward edward_roche(a)solanco.k12.pa.us Date: Sat, 28 Feb 2009 22:33:19 -0500 To: kmkale(a)anantcorp.com, dearden(a)sarsf.org, koha(a)lists.katipo.co.nz Subject: RE: [Koha] Staging of import stalls how would you get the zebra server running as well as the daemans? I originally tries to use zebra but it was giving me issues so I decide to go the nozebra route. Thanks Ed Edward Roche Technology Support/Network Admin Solanco School District edward_roche(a)solanco.k12.pa.us 717.786.2151 The greatest mistake you can make in life is to continually be afraid you will make one. Elbert Hubbard -----Original Message----- From: Koustubha Kale [mailto:kmkale@anantcorp.com] Sent: Sat 2/28/2009 2:31 AM To: Doug Dearden Cc: Roche III, Edward; koha(a)lists.katipo.co.nz Subject: Re: [Koha] Staging of import stalls ED, Do try Doug's suggestion. I have also faced this problem. removing the problem record solves the stall. Also I have staged and imported more than 87000 records in one go, so the batch process does work well. In case you are not using zebra, one trick i observed was to have the zebra server and queue daemons running during the import and put nozebra to off even if you are not using zebra. this speeds up the staging and import by orders of magnitude. after the import is over you can run the rebuild_nozebra.pl to rebuild the index after turning on nozebra setting. This little trick resulted in hours of time saving. -- Regards, Koustubha Kale Anant Corporation Contact Details : Address : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka, Thane (w), Maharashtra, India, Pin : 400601. TeleFax : +91-22-21720108, +91-22-21720109 Mobile : +919820715876 Website : http://www.anantcorp.com Doug Dearden wrote: > Hi Ed, > > I had the same problem. Take a look at the last import (Home > Tools > Manage Staged MARC Records > Batch > > Figure out the last record in the batch that went in, then edit the import file you are using and remove the record immediately after that one in the file. It has some kind of problem. Try again and see if you get further. It is either that record, or the last one that actually worked, I can't remember exactly which. > > Also, there is a command line tool that you can use to import. You will find it at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl > > >From the migration tools subdirectory enter: perl bulkmarcimport.pl and you will get the syntax and parameter info. It has a test mode you can run against the file. > > Best, > > Doug > > >>>> "Roche III, Edward" <edward_roche(a)solanco.k12.pa.us> 2/27/2009 9:20 AM >>> >>>> > Good Morning All > > > > I am trying stage my MARC import data but it keeps stalling. I broke it > down into 4 individual files of about 4000 records each. But it still > stalls at about 15%. Has anyone had this issue? Can it be done from the > terminal instead of through the browser? Every time I start the process > it pins my cpu at 95 to 100% which is why it is probably stalling but > not sure why. > > > > My Config > > ---------------------------------- > > Ubuntu 8.1 > > 1.5gb memory > > Pentium 4 - 2.5ghz dual core > > Koha 3.0 > > NoZebra > > Basic LAMP install > > > > Any thoughts would be great. > > > > 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 > > > -------------------------------------------------------------------- mail2web LIVE Free email based on Microsoft® Exchange technology - http://link.mail2web.com/LIVE

1 0

Re: [Koha] Staging of import stalls
by Doug Dearden 01 Mar '09

01 Mar '09

Hi Ed, I had the same problem. Take a look at the last import (Home > Tools > Manage Staged MARC Records > Batch Figure out the last record in the batch that went in, then edit the import file you are using and remove the record immediately after that one in the file. It has some kind of problem. Try again and see if you get further. It is either that record, or the last one that actually worked, I can't remember exactly which. Also, there is a command line tool that you can use to import. You will find it at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl >From the migration tools subdirectory enter: perl bulkmarcimport.pl and you will get the syntax and parameter info. It has a test mode you can run against the file. Best, Doug >>> "Roche III, Edward" <edward_roche(a)solanco.k12.pa.us> 2/27/2009 9:20 AM >>> Good Morning All I am trying stage my MARC import data but it keeps stalling. I broke it down into 4 individual files of about 4000 records each. But it still stalls at about 15%. Has anyone had this issue? Can it be done from the terminal instead of through the browser? Every time I start the process it pins my cpu at 95 to 100% which is why it is probably stalling but not sure why. My Config ---------------------------------- Ubuntu 8.1 1.5gb memory Pentium 4 - 2.5ghz dual core Koha 3.0 NoZebra Basic LAMP install Any thoughts would be great. 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?"

3 2

Instructions or meta instructions for ISP-based (ie, single) Koha install method?
by Wade 28 Feb '09

28 Feb '09

Just installed my first instance of Koha this week (Koha 3 / Ubuntu 8.04 / MS Virtual PC 2007). Thanks very much to the author(s) of this doc: http://wiki.koha.org/doku.php?id=koha_3_install_guide_ubuntu_hardy, which got me through the install. So far, so good, except working with VPC is pretty slow to work with. I'm wondering about installing Koha onto a MySQL / PERL / Linux-enabled ISP account (with phpmyadmin and FTP access, but no command line access), to do one or two demo projects with Koha. I've seen a few hints that this config is possible, and just looking for additional direction or hints. For example, would I start by doing a local, single (directory) install, and then try migrating that to the host (with appropriate changes to config files)? Thanks very much for any help, Wade

1 0

Re: [Koha] Staging of import stalls
by Roche III, Edward 28 Feb '09

28 Feb '09

If I use the perl script does that mean I don't have to stage them? 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?" -----Original Message----- From: Doug Dearden [mailto:dearden@sarsf.org] Sent: Friday, February 27, 2009 11:41 AM To: Roche III, Edward Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Staging of import stalls Hi Ed, I had the same problem. Take a look at the last import (Home > Tools > Manage Staged MARC Records > Batch Figure out the last record in the batch that went in, then edit the import file you are using and remove the record immediately after that one in the file. It has some kind of problem. Try again and see if you get further. It is either that record, or the last one that actually worked, I can't remember exactly which. Also, there is a command line tool that you can use to import. You will find it at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl >From the migration tools subdirectory enter: perl bulkmarcimport.pl and you will get the syntax and parameter info. It has a test mode you can run against the file. Best, Doug >>> "Roche III, Edward" <edward_roche(a)solanco.k12.pa.us> 2/27/2009 9:20 AM >>> Good Morning All I am trying stage my MARC import data but it keeps stalling. I broke it down into 4 individual files of about 4000 records each. But it still stalls at about 15%. Has anyone had this issue? Can it be done from the terminal instead of through the browser? Every time I start the process it pins my cpu at 95 to 100% which is why it is probably stalling but not sure why. My Config ---------------------------------- Ubuntu 8.1 1.5gb memory Pentium 4 - 2.5ghz dual core Koha 3.0 NoZebra Basic LAMP install Any thoughts would be great. 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 3

Staging of import stalls
by Roche III, Edward 27 Feb '09

27 Feb '09

Good Morning All I am trying stage my MARC import data but it keeps stalling. I broke it down into 4 individual files of about 4000 records each. But it still stalls at about 15%. Has anyone had this issue? Can it be done from the terminal instead of through the browser? Every time I start the process it pins my cpu at 95 to 100% which is why it is probably stalling but not sure why. My Config ---------------------------------- Ubuntu 8.1 1.5gb memory Pentium 4 - 2.5ghz dual core Koha 3.0 NoZebra Basic LAMP install Any thoughts would be great. 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?"

3 2

Re: [Koha] how to download My sql from net
by mourik jan c heupink 27 Feb '09

27 Feb '09

please reply to the list instead of me personally. > i tryed but if u click on it it will ask registration ofter coplete > thern we will send a list plz help me You don't need to register to be able to download. Under the registration boxes, there is a link called 'No thanks, just take me to the downloads!' That link works here. But again: specially if you are not too experienced, it's a much better idea to use the mysql that comes with your distribution. mj

1 0

zebraqueue error
by Unni Kartha 27 Feb '09

27 Feb '09

after installing koha in lenny, when i try to do add marc record, z3950 search is not working. i am getting the following error DBD::mysql::st execute failed: Table 'koha.zebraqueue' doesn't exist at /usr/share/koha/bin/zebraqueue_daemon.pl line 123. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/bin/zebraqueue_daemon.pl line 124. can anyone help me? -- unnikartha

2 1

Advance search limit with nozebra
by Olugbenga Adara 27 Feb '09

27 Feb '09

Hello all, I am having problems with the Limit type to: feature of the advance search. Looking through the past postings i get the idea that it does not work with nozebra. is this correct? I've tried changing the item-level_itypes is system preferences and checking nozebra indexes but it still does not work. Any help will be appreciated. i am running Koha 3.01 and suse 11.0 Thanks Olugbenga Adara Mobile: 234-803-3220288

2 2