- Koha - lists.katipo.co.nz

Inactive borrowers report
by Cab Vinton 16 May '12

16 May '12

The SQL Reports Library contains a couple of reports for inactive borrowers: http://wiki.koha-community.org/wiki/SQL_Reports_Library#Inactive_Borrowers SELECT DISTINCT borrowers.surname, borrowers.firstname, borrowers.cardnumber, borrowers.email FROM borrowers WHERE NOT EXISTS (SELECT borrowernumber FROM statistics WHERE borrowers.borrowernumber = borrowernumber AND statistics.datetime >= 'YYYY-MM-DD') http://wiki.koha-community.org/wiki/SQL_Reports_Library#Patrons_with_No_Che… SELECT surname, firstname, cardnumber FROM borrowers WHERE borrowernumber NOT IN (SELECT DISTINCT borrowernumber FROM statistics WHERE type = 'issue' AND datetime BETWEEN <<Between (yyyy-mm-dd)>> AND <<and (yyyy-mm-dd)>>) I'd like to modify either of these to create a report that includes the last date of activity for each patron inactive since a given date (last activity is an item either being checked in or returned). Anyone have pointers on how to achieve this? It's beyond my current minimal level of SQL-fu. Many thanks, Cab Vinton, Director Sanbornton Public Library Sanbornton, NH Life is short. Read fast!

1 0

MySQL Database Restoring Problem from 3.4.x to 3.8.0
by Andi Sugandi 16 May '12

16 May '12

Hi all, The Koha 3.8.0 installation has no problem: http://goo.gl/WPBSC , but when restoring MySQL database from Koha 3.4.x to 3.8.0 I have an error message: ERROR 1005 (HY000) at line 2273: Can't create table 'kohadb.letter' (errno: 150) Any clue? Thanks in advance. Best regards, -- Andi Sugandi.

1 0

Re: [Koha] Multi-Lingual SQL & User Defined Parameters
by Karam Qubsi 16 May '12

16 May '12

Hi Dear Mr Massoud , Dear all, I think this will be very helpful for the people who don't want to use the English interface in Koha , and as you say when we finish translating koha 3.8 to Arabic ( very soon inshaallah) , we will have problems with the people who want to use koha in Arabic and english in the same time e.g: May be some Arab librarian prefer to use koha English interface for the staff client , and in the case that we've used the translated sql files (that your company provided it to us) for the marc21 the Arab librarian who want to use the English interface will have a problem because all the staff client will be in english except for the marc records and if we use the English version of the marc21 sql files the problem will be that the Arab librarian who will use the Arabic interface will see the marc fields in english so if we want to use arabic interface we have to use arabic sql files for marc is it possible to make something like armarc as we have normarc in the SQL structure ?! it's not a standard we don't really have 'armarc' and it is not a solution so the library chose its Marc flavor and all the librarian in that library will be forced to use this armarc , but will help to make the installation of the translated Arabic marc more easier and for the preferences description is included in the po files but the preferences still in English (the main term ) maybe the best solution is to make all the strings in koha included in the po files I don't have deep technical background but this will be more flexible for koha users all over the world for other languages not only for the Arabic language wish you will be able to do that for all the koha community :) thanks a lot for you Mr Massoud and thanks you all in Koha community for helping us :D Karam Qubsi Koha Arab Translating Team http://koha.wikibrary.org/ Wikibrary for Arab Librarians http://wikibrary.org > Date: Wed, 16 May 2012 09:00:57 +0300 > From: Massoud Alshareef <massoud(a)kwareict.com> > Subject: [Koha-translate] Multi-Lingual SQL & User Defined Parameters > To: koha-devel(a)lists.katipo.co.nz, koha(a)lists.katipo.co.nz, > koha-translate(a)lists.koha-community.org > Message-ID: > <CAMp2hxbU3fzajsQjgd-hou-RiPLmJ7y8Wf3XU=k2=5W15pPzmQ(a)mail.gmail.com> > Content-Type: text/plain; charset="iso-8859-1" > > Hello, > > I have asked a question about two years ago about when we can have Koha > support of Multi-Lingual SQL files (used for marc21/Auth fields description > in the Staff client) and Multi-Lingual users defined parameters (used for > describing items/ libraries & groups/ locations/ patrons categories/ etc), > and the answer from Koha development then was that it is > under consideration but not in the development pipelines yet, as it will > require some re-structuring in Koha system databases and controls. That > means, Koha will remain a single language in these areas. > > With Koha 3.6 release, I noticed the inclusion of "Spanish translation for > SQL files" in the INTERNATIONALIZATION enhancement section. Does this mean > that Spanish Koha, or any non-English Koha, now has both Spanish and > English SQL files, where Koha users can switch between more than one > language when, for instance, editing marc records in the staff client ? > > Koha Preferences description used to be in SQL files, which means a single > language prefers, and then moved into PO files format with 3.2 release (I > think) and thus Preferences became multi-lingual since then. > > Thank you Koha development for elaborating on the issue of having a fully > bilingual Koha. > > BTW, Arabic Koha 3.8 is now on the fast-lanes translation speed to be > completed within 3-4 weeks. > See Arabic Koha 3.8 OPAC demo site on > http://176.34.184.60/cgi-bin/koha/opac-search.pl?q=%D8%B9%D9%84%D9%85 > > Thanks > Massoud M. AlShareef, > > The world of achievement has always belonged to the optimist! > > KnowledgeWare Technologies > (P.O. Box 230-312) > Riyadh 11321, Saudi Arabia > Cel: +966 505 307 267 > massoud(a)kwareict.com >

2 1

Re: [Koha] http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6435
by Doug Kingston 16 May '12

16 May '12

We start the zebraqueue daemon from the /etc/init.d/koha-zebraqueue-daemon script at startup. This is a link to /usr/share/koha/bin/koha-zebraqueue-ctl.sh. My hack to keep things up to date is to run '/usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b' every 2 minutes from cron. /etc/cron.d/koha-hack: */30 * * * * koha KOHA_CONF=/etc/koha/koha-conf.xml PERL5LIB=/usr/share/koha/lib /usr/share/koha/bin/migration_tools/ rebuild_zebra.pl -b -Doug- On 14 May 2012 10:43, Elaine Bradtke <eb(a)efdss.org> wrote: > I can't answer that question, can you? (down at the bottom). > EB > > ---------- Forwarded message ---------- > From: Mason James <mtj(a)kohaaloha.com> > Date: Tue, May 8, 2012 at 9:38 PM > Subject: Re: [Koha] > http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6435 > To: Elaine Bradtke <eb(a)efdss.org> > Cc: Hugo Agud <hagud(a)orex.es>, Koha list <koha(a)lists.katipo.co.nz> > > > > > On 2012-05-9, at 5:05 AM, Elaine Bradtke wrote: > > > On Tue, May 8, 2012 at 11:34 AM, Hugo Agud <hagud(a)orex.es> wrote: > > > >> Dear all > >> > >> We are facing this bug again but this time with Koha 3.6.4, in our > case.. > >> > >> We have [intranet] false "no items" using zebra and nozebra, but when > you > >> click on title of the record.. the item appears without problem.... > >> > >> the main problem is that those items with false no items are not indexed > >> (the items) and you can't find them on advance search > >> > >> We have clean zebra index and reindex again and now appears all right... > >> but I think I will export the records and import another koha and check > >> what it happens and also upgrade to Koha 3.8 and check also what it > >> happens. > >> > > > > I've just tested this in our installation of 3.08 and the problem > persists. > > It happens with new records and recently edited records. Our workaround > > is to schedule the system to re-index periodically, but even with that, > > there is a delay between editing something and getting the barcode / item > > to show up again. Whereas any other changes I make (subject headings for > > instance) appear instantly. > > > > We're running > > mysql Ver 14.14 Distrib 5.1.61, for debian-linux-gnu (i486) using > readline > > 6.1 > > Apache version: Server version: Apache/2.2.16 (Debian) > > Zebra version: Zebra 2.0.50 (C) > > > > how are you starting your zebraqueue daemon, please? > > > > > > > >

1 0

Multi-Lingual SQL & User Defined Parameters
by Massoud Alshareef 16 May '12

16 May '12

Hello, I have asked a question about two years ago about when we can have Koha support of Multi-Lingual SQL files (used for marc21/Auth fields description in the Staff client) and Multi-Lingual users defined parameters (used for describing items/ libraries & groups/ locations/ patrons categories/ etc), and the answer from Koha development then was that it is under consideration but not in the development pipelines yet, as it will require some re-structuring in Koha system databases and controls. That means, Koha will remain a single language in these areas. With Koha 3.6 release, I noticed the inclusion of "Spanish translation for SQL files" in the INTERNATIONALIZATION enhancement section. Does this mean that Spanish Koha, or any non-English Koha, now has both Spanish and English SQL files, where Koha users can switch between more than one language when, for instance, editing marc records in the staff client ? Koha Preferences description used to be in SQL files, which means a single language prefers, and then moved into PO files format with 3.2 release (I think) and thus Preferences became multi-lingual since then. Thank you Koha development for elaborating on the issue of having a fully bilingual Koha. BTW, Arabic Koha 3.8 is now on the fast-lanes translation speed to be completed within 3-4 weeks. See Arabic Koha 3.8 OPAC demo site on http://176.34.184.60/cgi-bin/koha/opac-search.pl?q=%D8%B9%D9%84%D9%85 Thanks Massoud M. AlShareef, The world of achievement has always belonged to the optimist! KnowledgeWare Technologies (P.O. Box 230-312) Riyadh 11321, Saudi Arabia Cel: +966 505 307 267 massoud(a)kwareict.com

1 0

Call for News for the May Newsletter
by Daniel Grobani 15 May '12

15 May '12

Dear Koha Kommunitarians, I'm harvesting news for the May newsletter. Please send me by the 25th anything you think your fellow community members might like to know about. "News" can be as short as a sentence or as long as a paper. I especially encourage you to send me a line or two for the gossip/society column about what you're currently working on. And if you know of a go-live not announced on the list, please be sure to let me know about it. Thanks, Daniel Grobani

1 0

koha frozen patron accounts - patch?
by Amy Schuler 15 May '12

15 May '12

Hello everyone, I am running Koha 3.06.04.000. When I log into my account (and other user accounts) I get the following message: "Your account has been frozen until 00/02/0". I believe I found this bug (7272, see link below) and see that a patch has been "pushed". Does this mean (1) patch is available (and if so-where?) or (2) patch is not yet available? Thanks so much! Amy http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7272 Amy C. Schuler Director, Information Services & Library Cary Institute of Ecosystem Studies PO Box AB, 2801 Sharon Turnpike Millbrook, New York, 12545

2 1

Re: [Koha] Show us your OPACs
by Adalid Ortiz 15 May '12

15 May '12

Biblioteca Loyola - Universidad Iberoamericana Tijuana http://clavius.tij.uia.mx

1 0

Equinox job posting - Support specialist
by Galen Charlton 15 May '12

15 May '12

[apologies for multi-posting] Equinox Software, a growing and dynamic software development and support company based in Duluth, Georgia, is seeking a talented and dedicated Support Specialist. This position is responsible for providing technical support to our customers for several open source systems for libraries, including Koha and Evergreen. We are looking for the following qualities in a candidate: * The ability to communicate effectively both orally and in writing. * The ability and desire to dig deep to solve technical problems while keeping the customer's ultimate goal always in mind. * Ability to work well in a team environment. * Strong customer service focus. * A continual desire not to just do the job, but to also figure out how to do it better. The following skills and knowledge are essential for success in this position: * Two years of experience using the Linux command line. * One year of experience using SQL to query relational databases. * Familiarity with at least one scripting language such as Perl and Python is preferred. * Familiarity with core web technologies such as HTML, JavaScript and CSS is preferred. * Familiarity with library practices is preferred. * Experience operating or managing an integrated library system, particularly Koha and/or Evergreen, is preferred. * A MLS or equivalent degree is preferred. Summary of essential job functions:. * Providing excellent technical support to Equinox customers with other team members on the help desk. This includes helping troubleshoot problems, assist customers with configuration changes, and helping to advise our customers on how to make the best use of the software we support. * Providing continual status updates to internal and external customers via our ticket system. * Assisting Equinox's Operations Team with light system administration tasks such as log analysis. Equinox offers a strong benefits package including family health, dental, and vision insurance, fully paid for by the company. We also offer a 401k plan with matching contributions. Salary starts at $40,000 a year but is negotiable and commensurate with experience. This position is based on Duluth, Georgia. Please send your resume, 3 professional references, and salary requirements to careers(a)esilibrary.com Regards, Galen -- Galen Charlton Director of Support and Implementation Equinox Software, Inc. / The Open Source Experts email: gmc(a)esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org

1 0

Re: [Koha] import records in marc display formats?
by smurfett＠gmail.com 15 May '12

15 May '12

Hi i just made it up to show the format, not the data itself. i've tried maredit but i couldn't figure out how to import data such as this and have marc split it...... nancy On 5/15/12 6:03 AM, Eric Bégin wrote: > Nancy, > > Before answering your email with my suggestion, I just want to check with > you if the sample date you gave us was copied/pasted or you typed it. > > I'm asking because it doesn't have the indicators nor the $a in for the 020 > field, which make me think that you may have typed it and forgot to type those. > > If it it as your system provide it, there are more processing to do to you > data before being able to create a marc record out of it. > > Let me know, > > Eric Bégin > Solutions inLibro inc. > > On 2012-05-15 03:00, smurfett(a)gmail.com wrote: >> 001 054 >> 020 09783848x8 >> 100 1 $aLee, Harlety

1 0