- Koha - lists.katipo.co.nz

Stage MARC Records For Import
by Vitor Fernandes 11 Nov '10

11 Nov '10

Hi to all. I've tried to import a file with 150mb and the the job progress don't leave 0%. There is an maximun file size to import or the operation is quite slow? Regards. Vitor Fernandes

3 4

Re: [Koha] Koha MySQL Statement
by Nicole Engard 11 Nov '10

11 Nov '10

Tony, First, it's spelled Koha (not KOHA) - read here: http://bywatersolutions.com/?p=690 Next, I'm not sure how to help you with this specific problem so please remember to email the entire list so that someone with more skills than me can help you out. Thanks Nicole On Wed, Nov 10, 2010 at 10:42 PM, Tony Ying <tony_ykt(a)yahoo.com> wrote: > Dear Nicole, > > Hope this email finds you well. > > I need your assistance to resolve an issue on my KOHA Library system. > > When i do a catalog search,i got this error message "Can't call method > "as_usmarc" on an undefined value at /usr/share/koha/lib/C4/Search.pm line > 2119." > > i ran /usr/share/koha/bin/migration_tools/rebuild_nozebra.pl and it resolved > the issue > However,when i perform a catalog search using either keyword or barcode > again , it will either show me 1 or 2 records or no record is found. In > fact, there are records in my Koha.Out of 10 tries, only 1 or 2 times are > successfully... > > Thanks in advanced. > > > > ________________________________ > From: Nicole Engard <nengard(a)gmail.com> > To: Susan Bennett <susan.bennett(a)geaugalibrary.info> > Cc: ahtshun83 <tony_ykt(a)yahoo.com>; koha(a)lists.katipo.co.nz > Sent: Thursday, 8 October 2009 04:48:49 > Subject: Re: [Koha] Koha MySQL Statement > > Remember that there is a SQL reports list on the wiki- add your > reports there and check there first to see if someone else has already > written the report you're looking for: > http://wiki.koha.org/doku.php?id=sql_library > > Nicole > > 2009/10/7 Susan Bennett <susan.bennett(a)geaugalibrary.info>: >> This is what we use: >> >> SELECT >> >> borrowers.cardnumber,borrowers.surname,borrowers.firstname,borrowers.phone,borrowers.branchcode,borrowers.categorycode,borrowers.address,borrowers.address2,borrowers.city,borrowers.zipcode, >> items.homebranch, items.holdingbranch,items.itemcallnumber, >> items.location, >> >> items.ccode,issues.date_due,biblio.author,biblio.title,items.barcode,items.replacementprice >> FROM borrowers LEFT JOIN issues on (issues.borrowernumber = >> borrowers.borrowernumber) LEFT JOIN items on (items.itemnumber = >> issues.itemnumber) LEFT JOIN biblioitems on >> (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on >> (biblioitems.biblionumber=biblio.biblionumber) >> WHERE issues.date_due < DATE_SUB(now(), INTERVAL put in the number of days >> overdue you are checking for DAY) AND issues.returndate IS NULL ORDER BY >> borrowers.surname asc >> >> This has more fields then you need but it's easy to take the un-needed >> ones >> out. Hope this helps! >> >> Susan Bennett >> ILS System Administrator >> Geauga County Public Library >> 440 286-6811 x 125 >> 440 286-7419 FAX >> >> >> On Wed, Oct 7, 2009 at 3:54 AM, ahtshun83 <tony_ykt(a)yahoo.com> wrote: >>> >>> Hi all, >>> >>> I would like to extract out a list of patrons who has overdue books which >>> has yet to return. I need the required field such as surname,card >>> number,book borrowed & due date. >>> >>> is there anyone has a sample of the above script? >>> >>> appreciated and thank you in advanced >>> -- >>> View this message in context: >>> http://www.nabble.com/Koha-MySQL-Statement-tp25782087p25782087.html >>> Sent from the Koha - Discuss mailing list archive at Nabble.com. >>> >>> _______________________________________________ >>> 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

is there a LAMP bundle with Perl?
by Caitlin McGurk 11 Nov '10

11 Nov '10

Hi all, I'm brand new to Koha (actually, it isn't even installed yet!) and wondering whether or not somewhere hidden on the internet there lies a bundle to download Linux, Apache, MySQL and Perl. With so many programmers involved in Koha, there's just gotta be by now, right? I suppose the only other good route is downloading LAMP with PHP, then installing and configuring Perl separately? Any advice or tips would be greatly appreciated! Caitlin McGurk Head Librarian The Center for Cartoon Studies <http://www.cartoonstudies.org> mcgurk(a)cartoonstudies.org

3 2

Newbie Questions
by makekee＠msu.ac.zw 11 Nov '10

11 Nov '10

Hi All Just managed to install Koha 3.02.00.004 on Ubuntu and I have the following questions: 1. When I try to create a new record fields 100a, 650a and 700a cannot be edited. They do not allow me to add any text into them because the curser won't even get in there. 2. When I importing a record using z39.50, after clicking the Save and view record button, I get the message "Tag "" is not a valid tag. at /usr/share/koha/lib/C4/Biblio.pm line 1863" Whats the problem here? Ephraim ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.

2 1

koha-3.02.00 searching problem
by Nur Ahammad 11 Nov '10

11 Nov '10

Hi all, I have installed koha3.02.00 on debian-squeeze for testing purpose. After updating my koha database and quick indexing and rebuilding zebra i do not get any search result. I set necessary file permission to koha:koha. first i run these command *export PERL5LIB=/usr/share/koha/lib, cd /usr/share/koha/bin/migratoin_tools, * *./rebuild_zebra.pl -b -w then **./rebuild_zebra.pl -v -b -a -r. *These command work but can not get any search result. Please suggest me. My library is waiting to go koha-3.02.00. -- Nur Ahammad Junior Assistant Librarian BRAC University, Bangladesh

2 1

Multiple URLs for digital Items
by Wolfgang Koller 11 Nov '10

11 Nov '10

Dear List, Is it possible to specify several URLs for digitized version of a single book? In fact we have internal digitized versions which we specify using the URL field in the items mask of koha, however it only allows us to add one URL. What we would like to do is add several URLs with external digitized versions of the book. Is this possible at all? Regards, Wolfgang -------------------------------------- Information gemaess UGB Par. 14 Abs. 1 Naturhistorisches Museum 1010 Wien, Burgring 7 Firmenbuchnummer: FN 236724z Firmenbuchgericht: Handelsgericht Wien UID: ATU 38020609 --------------------------------------

2 2

Fwd: NISO Press Release: NISO Announces Availability of NCIP Implementer Registry (11/10/10)
by Lori Bowen Ayre 10 Nov '10

10 Nov '10

Is anyone out there working on developing NCIP support for Evergreen or Koha? Is it queued up in the roadmap? Lori ---------- Forwarded message ---------- From: Karen Wetzel <kwetzel(a)niso.org> Date: Wed, Nov 10, 2010 at 7:04 AM Subject: NISO Press Release: NISO Announces Availability of NCIP Implementer Registry (11/10/10) To: newsline(a)list.niso.org *NISO Announces Availability of NCIP Implementer Registry* *Site brings together information about vendors’ implementations of NCIP* *Baltimore, MD - November 10, 2010 -* NISO is pleased to announce the availability of the NCIP Implementer Registry, a site that allows vendors to share information about their implementations of the NISO Circulation Interchange Protocol (ANSI/NISO Z39.83, Parts 1 and 2). NCIP addresses the need for interoperability among disparate circulation, interlibrary loan, and related applications by standardizing the exchange of messages between and among computer-based applications. At this time, the following vendors have indicated their use of NCIP by signing up for the registry: Auto-Graphics, Ex Libris, Innovative Interfaces, Inc., and Rapid Radio. The registry is linked from the NCIP website (www.niso.org/workrooms/ncip) and from the NCIP maintenance agency site (www.ncip.info) The registry allows vendors to enter information about their implementations of Version 1 of the standard, now deprecated but still widely used, and Version 2 of the standard, the current version of the standard adopted in 2008. Vendors may participate in the standard as an initiator of messages, a responder to messages, or both. By making this information publicly available, libraries will be able to see which vendors currently support NCIP, which version(s) of the standard are supported, and which messages in the standard are supported. In 2010 the NCIP Standing Committee defined two sets of core messages for accomplishing essential tasks: the Resource Sharing and the Self-Service. All required messages must be enabled for a vendor to claim support for a core message set. Depending on the role the vendor is playing in the transaction, the vendor must either support the messages as an initiator or responder. NCIP Standing Committee member Susan Campbell (Research & Development Consultant, College Center for Library Automation), who, with Mary Jackson (Product Manager, Resource Sharing, Auto-Graphics) developed the Drupal-based registry for the committee, noted, “The new registry builds on years of work on NCIP. It is a key next step to help libraries better understand which vendors provide NCIP, which NCIP messages are supported, and how those might in turn support what the library needs in order to more efficiently provide resource sharing or self-service services to their users. I am pleased to make this registry available and look forward to seeing its growth.” Rob Walsh, President of EnvisionWare, the Maintenance Agency for NCIP, as well as co-chair for NISO’s Discovery to Delivery Topic Committee, which provides oversight to the NCIP Standing Committee, added, “This is a wonderful step forward for NCIP. The registry is just one of the tools that the Standing Committee has been working on to support NCIP implementers and users. By making this information more broadly available, the community will be able to make better informed decisions to help meet their customers’ and patrons’ needs.” The NCIP Standing Committee is working to develop additional user tools. For more information, visit the NCIP website at www.niso.org/workrooms/ncip or the NCIP maintenance agency home at www.ncip.info. *About NISO* NISO, based in Baltimore, Md., fosters the development and maintenance of standards that facilitate the creation, persistent management, and effective interchange of information so that it can be trusted for use in research and learning. To fulfill this mission, NISO engages libraries, publishers, information aggregators, and other organizations that support learning, research, and scholarship through the creation, organization, management, and curation of knowledge. NISO works with intersecting communities of interest and across the entire lifecycle of an information standard. NISO is a not-for-profit association accredited by the American National Standards Institute (ANSI). *For More Information, Contact:* Victoria Kinnear NISO Business Development and Operations Manager Phone: 301-654-2512 vkinnear(a)niso.org Karen Wetzel NISO Standards Program Manager kwetzel(a)niso.org ---------------------- Karen A. Wetzel Standards Program Manager National Information Standards Organization (NISO) One North Charles Street, Suite 1905 Baltimore, MD 21201 Tel.: 301-654-2512 Fax: 410-685-5278 E-mail: kwetzel(a)niso.org

1 0

Corrupt PDF output for Arabic Records
by Abdul Vali 10 Nov '10

10 Nov '10

Dear List Members I have installed Koha 3.2 on Ubuntu. I have configured Zebra, Apache and MySQL with UTF-8 encoding (Ubuntu locale too). My UTF search is also working fine but when i try to print spine labels using some Arabic script included, it make bad PDF and gives error that PDF is corrupt and can not be open. Can someone help me to print PDF with Arabic words? Regards, Abdul Vali

1 0

EN files that have french words
by Zeno Tajoli 10 Nov '10

10 Nov '10

Hi to all, I have check files to translate the 3.2 In same 'en' files there are French words. So to translate all the files, I need two languages, English and French The 'en' files with French words are: ../koha-tmpl/opac-tmpl/prog/en/xslt/UNIMARCslim2OPACDetail.xsl ../koha-tmpl/opac-tmpl/prog/en/xslt/UNIMARCSlimUtils.xsl ../koha-tmpl/opac-tmpl/prog/en/xslt/UNIMARCslim2OPACResults.xsl ../koha-tmpl/intranet-tmpl/prog/en/xslt/UNIMARCSlim2OAIDC.xsl ../koha-tmpl/intranet-tmpl/prog/en/xslt/UNIMARCSlim2intranetDetail.xsl ../koha-tmpl/intranet-tmpl/prog/en/xslt/UNIMARCSlimUtils.xsl The bug in bugzilla is: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5204 Do I send a patch to use English instead of French ? Attention that all translations already done need to change. Bye Zeno Tajoli -- Zeno Tajoli CILEA - Segrate (MI) tajoliAT_SPAM_no_prendiATcilea.it (Indirizzo mascherato anti-spam; sostituisci qaunto tra AT con @)

1 0

Koha Admin Email
by Vitor Fernandes 10 Nov '10

10 Nov '10

Hello... I'm with a problem on the admin email. I've set up it to a gmail account but I can't send email notifications to new patrons or I can't receive email notifications when the patron change its personal details... What i need to do to make this work? Install an SMTP server on the Koha machine? Can you tell me a easy way to makes this work... Thanks for your time...

1 0