- Koha-devel - lists.koha-community.org

a simple update-items.pl tool
by Mason James 31 Mar '09

31 Mar '09

Hi Folks, i have an idea around a simple update-items.pl tool. my idea is a tool similar to circ's current branchtransfers.pl script (that takes scanned barcodes as input), and it updates the scanned item's various values what values ??? perhaps some/all of these... (any others??) Item Information 1. Home Library: 1. Holding Library: 2. Item type: 3. Collection: Statuses ( Lost Damaged ) 1. Current Location: 3. Lost Status: 4. Damaged Status: 5. Withdrawn: do other libraries use a different method that i'm unaware of? is there another update-items.pl type tool i have missed? Cheers, Mason

6 10

Add Biblio slow
by zang＠zang.co.za 31 Mar '09

31 Mar '09

I have contacted the list previously about this issue. We are hosting Koha successfully, but the "add biblio" screen is really a big problem (accessed via the internet). It is impractical to do cataloguing at this speed. It takes 30 seconds on average to start cataloguing a new record. Is there anything to be done to circumvent this issue? The problem is not Javascript related. All other functionality (searches, etc) are satisfactory.

2 1

Re: [Koha-devel] [Koha] Barcode Don't Found
by Roche III, Edward 30 Mar '09

30 Mar '09

That is an idea but I would think there was a way to have Koha except the T+space. 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: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Owen Leonard Sent: Friday, March 27, 2009 9:52 AM To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] [Koha-devel] Barcode Don't Found > Currently doing it by hand but have tried with the scanner with no luck. I asked because sometimes scanners are configured to add characters where you might not expect them. I did a quick test in my 3.0 installation and didn't have any problem typing in the barcode.. I don't have any prefix options specified. What I wonder is if you couldn't store just the numeric portion of the barcode (if it's the T+space causing the problem) and configure your scanners to strip off the "T "? Of course you'd have to consult the documentation for your scanners to know if that was possible. We've done something similar in the past. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

5 13

Re: [Koha-devel] {Possible SPAM} RE: [Koha] Barcode Don't Found
by Michael Hafen 30 Mar '09

30 Mar '09

It can be a little tricky to read patch files. Git diffs are a little easier than some because they list the changed files and the number of changes at the top. Don't worry about the changes in sysprefs.sql. Getting the database updated is more important. The change to Circulation.pm is the really important bit. The two lines with the '+' next to them are to be added to that file. If you can locate the lines around those in the file, then just copy and paste those lines in so it looks like what's in the diff. Then remove the '+''s. Good luck. On Sat, 2009-03-28 at 08:34 -0400, Roche III, Edward wrote: > I being dumb but where does this patch go? I found what I need to do for the sys.pref but not sure where to put the patch. > > 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: Michael Hafen [mailto:mdhafen@tech.washk12.org] > Sent: Friday, March 27, 2009 12:00 PM > To: Roche III, Edward > Cc: koha-devel(a)lists.koha.org; koha(a)lists.katipo.co.nz > Subject: {Possible SPAM} RE: [Koha-devel] [Koha] Barcode Don't Found > Importance: Low > > I'll attach a modified patch to do it. You'll still have to update the sys. pref. options to enable this feature. Look at the changes to installer/data/mysql/en/mandatory/sysprefs.sql for an idea of what to set the sys. pref. to. > > Good luck. > > On Fri, 2009-03-27 at 11:42 -0400, Roche III, Edward wrote: > > How do you create the filter? > > > > 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: Michael Hafen [mailto:mdhafen@tech.washk12.org] > > Sent: Friday, March 27, 2009 11:29 AM > > To: Roche III, Edward > > Cc: koha-devel(a)lists.koha.org > > Subject: Re: [Koha-devel] [Koha] Barcode Don't Found > > > > I have in my libraries several copies with a "T " before the number > > part of the barcode. Koha works with it fine. I find the trick is to > > make sure what's in the Koha database and what's encoded in the > > barcode are the same. It is possible with itemInputBarcodeFilter > > processing. I've used that sys. pref. to strip leading spaces ( which > > I put in ) from some barcodes. > > > > If what you want is to be able to enter just the number, or the "T " > > and the number ( like from a barcode scanner ), then I think making a > > custom itemInputBarcodeFilter ( like I did to trim leading spaces ) > > would be a good solution. > > > > On Fri, 2009-03-27 at 10:00 -0400, Roche III, Edward wrote: > > > That is an idea but I would think there was a way to have Koha > > > except the T+space. > > > > > > 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: koha-bounces(a)lists.katipo.co.nz > > > [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Owen Leonard > > > Sent: Friday, March 27, 2009 9:52 AM > > > To: koha(a)lists.katipo.co.nz > > > Subject: Re: [Koha] [Koha-devel] Barcode Don't Found > > > > > > > Currently doing it by hand but have tried with the scanner with no > > > luck. > > > > > > I asked because sometimes scanners are configured to add characters > > > where you might not expect them. I did a quick test in my 3.0 > > > installation and didn't have any problem typing in the barcode.. I > > > don't have any prefix options specified. > > > > > > What I wonder is if you couldn't store just the numeric portion of > > > the barcode (if it's the T+space causing the problem) and configure > > > your scanners to strip off the "T "? Of course you'd have to consult > > > the documentation for your scanners to know if that was possible. > > > We've done something similar in the past. > > > > > > -- Owen > > > > -- > Michael Hafen > Systems Analyst and Programmer > Washington County School District > Utah, USA > > for Koha checkout > http://koha-dev.washk12.org > or > git://koha-dev.washk12.org/koha -- Michael Hafen Systems Analyst and Programmer Washington County School District Utah, USA for Koha checkout http://koha-dev.washk12.org or git://koha-dev.washk12.org/koha

1 0

Koha Z39.50 client process discussion
by Frederic Demians 30 Mar '09

30 Mar '09

Koha Z39.50 client process isn't easy to understand from a end-user perspective. Current process: ◊ In cataloguing, a search to multiple z3950 target is sent. ◊ Result is displayed. 20 first results are displayed for each target. ◊ Each record is stored in import_* tables for further usage via 'reservoir'. ◊ By clicking on Import, one record is copied in data entry page. ◊ Cataloger can modify biblio record, localized it, etc. ◊ In next cataloguing operation, a search will be done both in catalog and reservoir (import_biblios table), and will retrieve eventually biblio records from previous z3950 searches. Some design choices are disputable: ◊ Why just 20 records per host are displayed? ◊ Why all retrieved records are stored in reservoir? People generally don't understand that. Why 20 and not 5 or 100 records? When a search is done by author, it is to catalog a specific book from this author. But with the current design, the library will fill its reservoir with biblio records describing books which will generally never enter into its catalog. ◊ Search in reservoir is done with BreedingSearch function only on 'title' and 'isbn' fields. So it's impossible to retrieve a biblio record by author. ◊ There is no user interface allowing to see what's going on with biblio records stored in reservoir and coming from z3950 searches. There is such an interface for staged records: those imported explicitly into reservoir from files (in Tools). ◊ So if a library uses to do search in 4 z3950 hosts, each search may add 4 x 20 = 60 records in import_biblios and import_records tables. The number of records added this way will grow indefinitely without any mean to clean reservoir. Some ideas of improvement: ◊ Add a syspref 'ReservoirZ3950' which when at false disable biblio records adding from z3950 searches. ◊ Add an UI in Tools to see the number of biblio records in reservoir added from z3950 searches. ◊ Add a 'clear' option in Tool to delete all records in reservoir coming from z3950, and eventually also coming from file imports. Any comment/idea? Also here: http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3069 -- Frédéric

3 2

Possuble Bug when running rebuild_nozebra.pl
by Roche III, Edward 29 Mar '09

29 Mar '09

Good Morning All Whenever I run this script I have to add the /C4 to the koha-httpd.conf file at the end of SetEnv PERL5LIB "/usr/share/koha/lib" line. This really is a pain in the backside because when I do that then Koha doesn't want to work. I switch it back and Koha works. Something isn't right somewhere and I am not sure it was meant to be this way or not. I am currently using the following setup: Ubuntu 8.10 Mysql 5.0.67 Apache 2.2.9 Perl 5.10 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?"

4 7

Barcode Don't Found
by Roche III, Edward 27 Mar '09

27 Mar '09

I am sending to both lists in case this needs to be addressed with a program update. Every time I update our barcodes in Koha (T0012345 to T 12345) it no longer recognizes the barcodes when trying to check out. I have tried each of the prefix options and we even added a blank option but that still isn't working, I export the itemnumber and barcode, update the barcode and reimport to the DB to a temp table then update the items table with sql expression. The records are updated and then I run the following script: perl /usr/share/koha/bin/maintenance/sync_items_in_marc_bib.pl --run-update It runs for like 6 hours (almost 16k records) it gives following results: Embedded item synchronization report ------------------------------------ Number of bibs checked: 13214 Number of bibs modified: 13167 Number of item fields removed from bibs: 15698 Number of item fields added to bibs: 15698 Number of bibs with errors: 0 I go back into Koha and try to checkout and I get a yellowish box that say barcodes not found. I need to get this to work because rebarcoding is out of the question with the number of items we have in our library. Thanks in advance! 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

1 0

Zebra stops searching after a crash
by Chadwick, John, DCA 26 Mar '09

26 Mar '09

We are getting ready to go into production and one of the Mac Minis that we have been testing on decided to crash today. After rebooting the server, searching with Zebra turned off works. Turning Zebra on and searching fails. Zebra was turned on prior to the crash and the searching worked great. I have tried the drop option in zebraidx and dropped the database biblios in an attempt to start clean, still no joy. I have run the rebuild zebra script numerous times and everything seems to be indexing, but we still can't search. Any ideas? Thanks, John +----------------------------------------------------------------------- -----+ John Chadwick, Ed.D. Information Technology Manager New Mexico State Library 1209 Camino Carlos Rey Santa Fe, NM 87507 Phone: 505-476-9740 Cell: 505-629-8116 Fax: 505-476-9761 john.chadwick(a)state.nm.us http://www.nmstatelibrary.org This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.

3 3

Error exporting report!
by Muahmmad Wasim 26 Mar '09

26 Mar '09

hi, I'm trying to export a report from the page "reports/guided_reports.pl" in interanet. When I create a report it works fine and shows result. But when I click on "Download" button to export the report in any format(CSV/Tab Spaced), it doesn't work. It just shows an error: "Error exporting report!". I've tried it on two different machines having different installations, but both don't work. Please help ! Regards, Muhammad Wasim

1 0

System requirements
by savitra sirohi 26 Mar '09

26 Mar '09

Eric, On Hard drive: for 100,000 records, about 10 GB for Zebra indexes and about 5 GB for mysql. If using Zebra we find RAM should ideally be 500 MB or more even if use load is very light. Thanks, Savitra Sirohi Nucsoft OSS Labs http://www.osslabs.biz On Thu, Mar 26, 2009 at 4:19 AM, Eric Bégin <Eric.Begin(a)inlibro.com> wrote: > Hi there, > > Is there some guidelines about the system requirements to run Koha with > all components (Apache, MySQL, Koha, Zebra) running on a machine > exclusivement dedicated to Koha? > > I'm mostly talking in term of: > - CPU and RAM vs simultaneous number of users > - Hard drive space vs number of records > - Other? > > Thank you in advance for all inputs! > > Eric > _______________________________________________ > Koha-devel mailing list > Koha-devel(a)lists.koha.org > http://lists.koha.org/mailman/listinfo/koha-devel >

1 0