- Koha - lists.katipo.co.nz

Do we like the same books?
by jayadevkumbar 18 Sep '07

18 Sep '07

I just joined Shelfari to connect with other book lovers. Come see the books I love and see if we have any in common. Then pick my next book so I can keep on reading. Click below to join my group of friends on Shelfari! http://www.shelfari.com/Register.aspx?ActivityId=15028819&InvitationCode=b9… jayadevkumbar Shelfari is a free site that lets you share book ratings and reviews with friends and meet people who have similar tastes in books. It also lets you build an online bookshelf, join book clubs, and get good book recommendations from friends. You should check it out. -------- You have received this email because jayadevkumbar (jayadevkumbar(a)gmail.com) directly invited you to join his/her community on Shelfari. It is against Shelfari's policies to invite people who you don't know directly. Follow this link (http://www.shelfari.com/actions/emailoptout.aspx?email=Koha@lists.katipo.co…) to prevent future invitations to this address. If you believe you do not know this person, you may view (http://www.shelfari.com/jayadevkumbar) his/her Shelfari page or report him/her in our feedback (http://www.shelfari.com/Feedback.aspx) section. Shelfari, 616 1st Ave #300, Seattle, WA 98104

1 0

MARC Export and adding data to marc tables
by Anthony Manzo 18 Sep '07

18 Sep '07

Hi, I have been trying a variety of techniques to swap data from a library specific field (we are using 900 to store legacy data) to the Koha items field (952). Specifically moving data from 900 sub 6 to 952 p (barcode, we are using a custom number in place of barcode) My problems are: 1. The MARC export is producing a file that has incorrect Leader data. I have verified this through two utilities which I have used before successfully with other marc files - Marcedit ( a free win32 app) and File_MARC (pear extension). 2. My next attempt was to try to directly edit the data in the Koha database. I was able to update items.barcode = marc_subfield_table.subfieldvalue with plain old sql. However it seems this data is only part of the story and I need to also update the marc_subfield_table(900 sub 6 to 952 p OR items.barcode to 952 p). I could not figure out which fields need which data to do this step and if this (marc_subfield_table) was the only other table that I needed to update. So to reiterate. Is there a known problem w/marc export? And Can someone help me w/the sql to create the necessary entries from items.barcode to the other marc related tables so that this data is visible throughout Koha. Many thanks, Tony

1 0

Search for a Supplier
by mohamed fekry 16 Sep '07

16 Sep '07

hi every body when i trying using serials module and add a new subscription (Search for a Supplier ) (Search for Biblio ) not working and gives me error on pages . line 300- char 3 - error invalid argument - code 0 url://intranet/cgi-bin/koha/bull/subscription-add.pl. any help .thanks _________________________________________________________________ Capture your memories in an online journal! http://www.reallivemoms.com?ocid=TXT_TAGHM&loc=us

1 0

documents to install koha 2.2.8
by zlire 16 Sep '07

16 Sep '07

Hi, i would like to install koha 2.2.8. This is my server profile: -Ubuntu 6.06 -PHP Version 5.1.2 -Apache/2.0.55 -MySql 5.0.22 Please can anyone tell me where can i find some documents about the installation of this version of koha? Thank you. -- View this message in context: http://www.nabble.com/documents-to-install-koha-2.2.8-tf4360554.html#a12427… Sent from the Koha - Discuss mailing list archive at Nabble.com.

3 3

Patron Entry Error
by Olugbenga Adara 15 Sep '07

15 Sep '07

Hello all, please can somebody help me with the error i'm getting from koha; the tail end o the koha eror log is as follows: [Fri Sep 14 16:54:04 2007] [error] [client 192.168.11.200] ERROR: Date::Manip unable to determine Time Zone., referer: http://192.168.11.253:8080/cgi-bin/koha/members/memberentry.pl [Fri Sep 14 16:54:04 2007] [error] [client 192.168.11.200] at /usr/lib/perl5/site_perl/5.8.8/Date/Manip.pm line 3645, referer: http://192.168.11.253:8080/cgi-bin/koha/members/memberentry.pl [Fri Sep 14 16:54:04 2007] [error] [client 192.168.11.200] \tDate::Manip::Date_TimeZone called at /usr/lib/perl5/site_perl/5.8.8/Date/Manip.pm line 684, referer: http://192.168.11.253:8080/cgi-bin/koha/members/memberentry.pl [Fri Sep 14 16:54:04 2007] [error] [client 192.168.11.200] \tDate::Manip::Date_Init() called at /usr/lib/perl5/site_perl/5.8.8/Date/Manip.pm line 1454, referer: http://192.168.11.253:8080/cgi-bin/koha/members/memberentry.pl [Fri Sep 14 16:54:04 2007] [error] [client 192.168.11.200] \tDate::Manip::ParseDate('today') called at /usr/local/koha/intranet/modules/C4/Members.pm line 132, referer: http://192.168.11.253:8080/cgi-bin/koha/members/memberentry.pl [Fri Sep 14 16:54:04 2007] [error] [client 192.168.11.200] \tC4::Members::newmember('phoneday', '', 'firstname', 'sds', 'categorycode', 'UG', 'destination', '', 'othernames', ...) called at /usr/local/koha/intranet/cgi-bin/members/memberentry.pl line 136, referer: http://192.168.11.253:8080/cgi-bin/koha/members/memberentry.pl [Fri Sep 14 16:54:04 2007] [error] [client 192.168.11.200] Premature end of script headers: memberentry.pl, referer: http://192.168.11.253:8080/cgi-bin/koha/members/memberentry.pl I am running koha 2.2.9 on Suse 10.1 with mysql 5. i have had some success with this configuration in the past. i had to uninstall the date::manip that was installed with suse and i used a previous version. i also had to use the Date.pm that came with 2.2.7 before the joining and expiry dates were autocalculated. i have done the sam thing now but no success. the browser always wants to download memberentry.pl i guess this may be a problem with my perl modules but cant say for sure. any help will be appreciated. thanks Olugbenga Adara MCP Consultant, 3om Services, 75, Lebanon Street, Dugbe, Ibadan, Nigeria. Tel: 234-2-2412090 Mobile: 234-803-3220288 ____________________________________________________________________________________ Got a little couch potato? Check out fun summer activities for kids. http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&…

2 1

Koha Newbie Questions
by Jon Bek 13 Sep '07

13 Sep '07

Hello, and please forgive me if I haven't navigated to precisely the right forum for Koha Newbie questions: I am the IT Project Manager for a very large public school district currently running the Sagebrush (now Follett) Accent product, which in turn uses the Unicorn engine (2003 version) created by Sirsi. On of our largest challenges with the architecture of our existing product is that the architecture is dependent upon two databases: BRS (for full text search) and OPAC. Nor does it appear that the division of labor between BRS and ORACLE is clean -- we can see that there are patron user indexes and other objects used by BRS that make no sense if the tasks were segregated as simply as they have been portrayed. Due to the number of libraries we serve (680+) and the number of titles in our OPAC (7,000,000+), a batch job which should run nightly to synchronize BRS temp and permanent indices and Oracle records very often cannot complete after hours. This batch (ADUTEXT) may not run during business hours, as it interferes with ordinary central cataloging tasks, as well as certain tasks (inventory, adding brief marc records, importing new copies of arriving shipments) in the field. I am interested in evaluating Koha, but am concerned by the touted "Dual Database" nature of Koha. This sounds very much like a trip down the same dead-end street we've encountered with Accent. Does anyone have insight & experience to share with me about batch or periodic processes required to maintain Koha (especially "nightly" stuff), or a better understanding of the the Koha architecture, and why it would or would not pose similar problems for an operation our size? Thanks in advance! -Jon -- View this message in context: http://www.nabble.com/Koha-Newbie-Questions-tf4429659.html#a12636666 Sent from the Koha - Discuss mailing list archive at Nabble.com.

3 3

Opac error
by eddy wetaba 12 Sep '07

12 Sep '07

Hi good people, When i issue a patron with a book,then i go to opac,i log in using his user name and paswrd the following error comes up. [Wed Sep 12 16:03:18 2007] [error] [client 127.0.0.1] Premature end of script headers: opac-user.pl, referer: http://opac/cgi-bin/koha/opac-main.pl [Wed Sep 12 16:03:18 2007] [error] [client 127.0.0.1] HTML::Template->output() : fatal error in loop output : HTML::Template::param() : attempt to set parameter 'reserves' with an array ref - parameter is not a TMPL_LOOP! at C:/usr/site/lib/HTML/Template.pm line 3069, referer: http://opac/cgi-bin/koha/opac-main.pl [Wed Sep 12 16:03:18 2007] [error] [client 127.0.0.1] at C:/usr/koha228/opac/cgi-bin/koha/opac-user.pl line 158, referer: http://opac/cgi-bin/koha/opac-main.pl [Wed Sep 12 16:03:58 2007] [error] [client 127.0.0.1] Premature end of script headers: opac-user.pl, referer: http://opac/cgi-bin/koha/opac-user.pl [Wed Sep 12 16:03:58 2007] [error] [client 127.0.0.1] HTML::Template->output() : fatal error in loop output : HTML::Template::param() : attempt to set parameter 'reserves' with an array ref - parameter is not a TMPL_LOOP! at C:/usr/site/lib/HTML/Template.pm line 3069, referer: http://opac/cgi-bin/koha/opac-user.pl [Wed Sep 12 16:03:58 2007] [error] [client 127.0.0.1] at C:/usr/koha228/opac/cgi-bin/koha/opac-user.pl line 158, referer: http://opac/cgi-bin/koha/opac-user.pl [Wed Sep 12 17:41:57 2007] [error] [client 127.0.0.1] Premature end of script headers: opac-user.pl, referer: http://opac/cgi-bin/koha/opac-main.pl [Wed Sep 12 17:41:57 2007] [error] [client 127.0.0.1] HTML::Template->output() : fatal error in loop output : HTML::Template::param() : attempt to set parameter 'reserves' with an array ref - parameter is not a TMPL_LOOP! at C:/usr/site/lib/HTML/Template.pm line 3069, referer: http://opac/cgi-bin/koha/opac-main.pl [Wed Sep 12 17:41:57 2007] [error] [client 127.0.0.1] at C:/usr/koha228/opac/cgi-bin/koha/opac-user.pl line 158, referer: http://opac/cgi-bin/koha/opac-main.pl -- Michael Wetaba 0721566886 3755410

1 0

Koha MYSQL database install errors on Deb
by Matthew Stockfleth 12 Sep '07

12 Sep '07

The installer is giving me the following errors and not installing koha.items or koha.systempreferences (but as far as I can tell...it is installing everything else.) ERROR 1064 (42000) at line 772: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'return char(4) default NULL, renewals tinyint(4) default NULL, timestamp tim' at line 9 An issue with mysql 5? DBD::mysql::st execute failed: Table 'Koha.items' doesn't exist at scripts/updater/updatedatabase line 2047.DBD::mysql::st fetchrow failed: fetch() without execute() at scripts/updater/updatedatabase line 2049. DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't exist at scripts/updater/updatedatabase line 2130.DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't exist at scripts/updater/updatedatabase line 2138.DBD::mysql::st execute failed: Table 'Koha.systempreferences' doesn't exist at scripts/updater/updatedatabase line 2138. as for gcrypt I managed to find it...figure that deb would add the version number to the package. Matt And all I got was this lousy thing _________________________________________________________________ Can you find the hidden words? Take a break and play Seekadoo! http://club.live.com/seekadoo.aspx?icid=seek_wlmailtextlink

2 1

Re: [Koha] Looking for Icons for OPAC Search Screens
by BWS Johnson 12 Sep '07

12 Sep '07

Salve! Have you seen the Kid's Catalogue? http://yakpac.liblime.com/ Cheers, Brooke @ Hinsdale MA

1 0

Re: [Koha] tmpl_process3.pl script not running on Windows
by Serhij Dubyk / Сергій Дубик 12 Sep '07

12 Sep '07

> I'm trying to run the tmpl_process3.pl script on windows environmnet but > it > is giving error. Could any body plz tell me whether this scripts run on > windows platform or not. It running for me but script slightly modified: tmpl_process3.pl: #my $xgettext = './xgettext.pl'; my $xgettext = 'xgettext.pl'; (and small add for utf-8, if need I send) Locale::PO also needed. And Win32 binaries of GNU gettext-tools 0.13.1 installed (this one only needed for creating clear po-files). For getting english_clear_opac_css.po used next command: perl tmpl_process3.pl create -r -i ../../../opac-html/opac-tmpl/css/en/ -s english_clear_opac_css.po For building templates used: mkdir ..\..\..\opac-html\opac-tmpl\css\uk perl tmpl_process3.pl install -o ..\..\..\opac-html\opac-tmpl\css\uk\ -s ..\..\..\..\css_opac_uk_UA\css_opac_uk_UA.po -i ..\..\..\opac-html\opac-tmpl\css\en\ -r and manually copied some ommited files (images, js, ...)

5 4