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

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

System requirements
by Eric Bégin 25 Mar '09

25 Mar '09

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

1 0

Migrating dev_week to Koha 3.x
by Kyle Hall 25 Mar '09

25 Mar '09

Hey All, We are having some issue getting our records into Koha 3 from dev_week. When we export the MARC from dev_week, and import it into Koha 3, the original biblionumber and the like get ignored and new ones generated, so nothing matches up. If I search for 'Cat in the Hat' and click the link, I'll be looking at the bib for 'Learning XML'. Any ideas? Thanks, Kyle http://www.kylehall.info Information Technology Crawford County Federated Library System ( http://www.ccfls.org )

3 4

XSLT for Unimarc also
by Zeno Tajoli 25 Mar '09

25 Mar '09

Hi to all, I want to use XSLT display for Unimar also. I read the code of Opac and I found two points to fix: opac.detail.pl line 63 my $newxmlrecord = XSLTParse4Display($biblionumber,C4::Context->config('opachtdocs')."/prog/en/xslt/MARC21slim2OPACDetail.xsl"); opac-showmarc.pl line 68 my $xslfile = C4::Context->config('intranetdir')."/koha-tmpl/intranet-tmpl/prog/en/xslt/compact.xsl"; If I change the lines and the .xsl files, can I use XSLT with Unimarc ? Bye Zeno Tajoli CILEA - Segrate (MI) tajoliAT_SPAM_no_prendiATcilea.it (Indirizzo mascherato anti-spam; sostituisci quanto tra AT con @)

2 1

Post Import of field update issue
by Roche III, Edward 25 Mar '09

25 Mar '09

Good Morning All I am writing to both groups because I am not sure which one would be the best option for this problem. I have to do a mass update of our barcode field to match up what our barcodes actually are as opposed to what Follett spits out in its export. Before I do the field update I can check out books with no problem with the current barcode format. After I do the update, when I enter the barcode to checkout for the student and hit Checkout then it automatically sends me back to the Circulation - Checkout page and never assigns the book to the patron. Here are the steps I do when updating the field: * Export data to a tab delimited file (itemnumber and barcode) * Open file in Excel and fix the barcode field (From T0012345 to T 12345) * Save as file again as Tab Delimited * Go to WebMin in the browser and create a temp table to hold the updated info * Import the data to the temp table with no issues * Run the following SQL expression to update the barcode field in the items table with the data that is in the temp table linked by itemnumber o update items a inner join temp b on a.itemnumber = b.itemnumber set a.barcode = b.barcode * Everything copies over, I spot check a couple records to make sure no issues. * I run the following script from terminal o perl /usr/share/koha/bin/maintenance/sync_items_in_marc_bib.pl --run-update * Then run: o perl /usr/share/koha/bin/migration_tools/rebuild_nozebra.pl * I go into Koha and test the checkout function (see Checkout Image Attachment) and I get the Circulation - Checkout page (see Circulation-Checkout Attachment) Should I be doing this update a different way???? 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 1

Inporting authority data in Koha3
by Partha Mukhopadhyay 24 Mar '09

24 Mar '09

Dear all Need ur valuable advice on importing of MARC 21 formatted authority data. As u know recently VIAF (Virtual Internation Authority File) project started jointly by Loc, DNB, BnF, and OCLC. The url is http://viaf.org/. My questions are - Is it possible to import VIAF authority data (MARC 21 formatted authority data) into Koha authority table? Note: I tried to import data through Tools -> Stage MARC record to import and follow the steps. This process imported authority data but I was not clear about how koha imported data - as bibliographic data or as authority data. However, then I tried to the process Tools -> Manage staged MARC record -> Import into catalogue. This activity reported sucessful importing of data. But when I searched catalogue or authirty data, I failed to found the imported authority record. Is there any way to import only MARC 21 authority data from VIAF or Loc either by single record based operation or through batch mode? Dr. Parthasarathi Mukhopadhyay -- _______________________________________________ Search for products and services at: http://search.mail.com

2 1