- Koha - lists.katipo.co.nz

need help about analytic record
by vikrant malik 24 Apr '13

24 Apr '13

Hello All, In koha I add analytic records, and they are working fine. But my problem is that i have a no. of data in excel format. And I want to bulk import all this data to my koha. How can I do this. Can Anyone suggest me in this regard. thanks vikrant malik

2 1

Need Help in Koha Multiple instance
by sunil sharma 24 Apr '13

24 Apr '13

Hello all, I installed koha 3.8.x multiple instances on a debian-squeeze server by refering this link: http://wiki.koha-community.org/wiki/Installing_Multiple_Instances_of_Koha . But I am facing problem in rebuilding zebra in multiple instances. Actually when I installed one instance for example koha1, it installed perfectly and rebuildzebra.pl work fine after uploading my database. After installing another instance say koha2, it also installed perfectly and rebuildzebra.plalso works fine. But now the problem is that, now if I again come at my first instance i.e. koha1, make rebuildzebra.pl command to run again, it takes database of my 2nd instance. This is because in zebra configuration file while rebuild zebra it show like this:- Zebra configuration information ================================ Zebra biblio directory = /var/lib/*koha2*/zebradb/biblios Zebra authorities directory = /var/lib/*koha2*/zebradb/authorities Koha directory = /usr/share/*koha2*/intranet/cgi-bin In place of *koha2*, this should take *koha1* in my first instance of koha, which is making wrong zebra rebuild and show me biblio of koha2 instance in koha1 instance. How should I resolve this problem. Can Anyone help me in this regard? Thanks in advance for your help, Sunil

4 4

Koha 3.10.5 released
by Chris Cormack 24 Apr '13

24 Apr '13

The Koha community is proud to announce the release of Koha 3.10.5. This is a stable release and contains many bugfixes. You can download the tarball from http://download.koha-community.org or wait a day or 2 for the packages to become available. Please read below for the full release notes RELEASE NOTES FOR KOHA 3.10.5 23 Apr 2013 ======================================================================== Koha is the first free and open source software library automation package (ILS). Development is sponsored by libraries of varying types and sizes, volunteers, and support companies from around the world. The website for the Koha project is http://koha-community.org/ Koha 3.10.5 can be downloaded from: http://download.koha-community.org/koha-3.10.05.tar.gz Installation instructions can be found at: http://wiki.koha-community.org/wiki/Installation_Documentation OR in the INSTALL files that come in the tarball Koha 3.10.5 is a bugfix/maintenance release. Major fixes of 3.10.5 ====================== Acquisitions ---------- 9928 blocker no way to see all purchase suggestions at all 7018 critical need all acq permissions to search 7449 major billingplace and freedeliveryplace not saved when creating a new basketgroup Cataloging ---------- 9908 major OCLC Connexion Desktop Client Doesn't Work Circulation ---------- 9953 major When OpacMaintenance breaks lifting debarment Hold requests ---------- 9922 critical holds queue shows home library with AutomaticReturn Notices ---------- 8378 major <fine> syntax not working on overdues anymore OPAC ---------- 8979 major "News" does not work with CCSR Patrons ---------- 9930 critical can't update patron info in ccsr Searching ---------- 9341 major Problem with UNIMARC authors facets Tools ---------- 9535 major Patron card creator "Remove duplicates" function doesn't work Other bugs fixed in 3.10.5 ========================== About ---------- 9956 trivial Add missing translators to the about page Acquisitions ---------- 7875 trivial Pending suggestion link (the numbers) from staff client home directs to accepted suggestions instead of pending Architecture, internals, and plumbing ---------- 9727 normal Typo in code causes compilation failure with Solr enabled 9609 trivial Rebuild zebra reports double numbers for exported records with -z option Authentication ---------- 9841 minor Improve the link from the "logged in as mysql-user"-warning Command-line Utilities ---------- 9496 normal rebuild_zebra.pl should handle invalid XML records better 9885 normal Passwords generated by command line scripts are weak Database ---------- 9745 trivial Don't nuke translated permissions with changes introduced in bug 9382 I18N/L10N ---------- 7938 normal The -v option to the translate script is not documented Installation and upgrade (web-based installer) ---------- 9498 normal Update encoding for Norwegian sample Z39.50 servers 9752 normal Set marcflavor = normarc when NORMARC is chosen in the web installer 9837 normal Fix Norwegian authorized values for the web installer 9863 trivial 'import' button in web installer should read 'Import' MARC Bibliographic data support ---------- 9274 normal Software error in bibtex export OPAC ---------- 9166 normal OPAC needs configuration file for datepicker 9504 normal URL escape in OPAC more searches 9660 normal OpenLibrary covers are too small on OPAC search results 9932 normal Broken calendar image and misplaced masthead include for CCSR theme 9003 minor Add css fix for opac news items with strong and em 9935 minor Social icons missing in CSSR theme Packaging ---------- 8816 normal add WARNING to debian/control file, to not manually edit 9802 minor Add test case to verify package man pages are well formatted Patrons ---------- 9002 normal Remove Problematic Logic from Patron Messaging Preferences Form Searching ---------- 9419 minor The highlight feature can cause a browser freeze Self checkout ---------- 9748 minor noitemlinks not being enforced Serials ---------- 9947 minor Creating item for received serial prefills enumchron subfield SIP2 ---------- 9838 trivial SIP tests : fix in 04patron_status.t Staff Client ---------- 9726 minor XISBN service throttle not initialized Templates ---------- 9554 normal single quote in didyoumean 9945 normal Pretty icon display in authorised values configuration 5648 minor icons clumping together 9571 minor Fix width for textareas in Edit Item screen 9952 trivial MARC tab: tab 0 is not translated correctly Tools ---------- 9415 normal XML catalog export is missing root node 9954 minor CSV profile encoding not selected on editing translate.koha-community.org ---------- 8942 normal Translation process breaks javascript in calendar.inc Enhancements in 3.10.5 ====================== Circulation ---------- 9423 Add notforloan value to issue confirmation or blocking message New sysprefs in 3.10.5 ====================== * UNIMARCAuthorsFacetsSeparator System requirements ====================== Important notes: * Perl 5.10 is required * Zebra is required Documentation ====================== As of Koha 3.2, the Koha manual is now maintained in DocBook. The home page for Koha documentation is http://koha-community.org/documentation/ As of the date of these release notes, only the English version of the Koha manual is available: http://manual.koha-community.org/3.10.5/en/ The Git repository for the Koha manual can be found at http://git.koha-community.org/gitweb/?p=kohadocs.git;a=summary Translations ====================== Complete or near-complete translations of the OPAC and staff interface are available in this release for the following languages: * English (USA) * Arabic (99%) * Armenian (99%) * Chinese (China) (92%) * Chinese (Taiwan) (99%) * Danish (100%) * English (New Zealand) (99%) * French (98%) * French (Canada) (68%) * German (100%) * German (Switzerland) (97%) * Greek (62%) * Italian (99%) * Norwegian Bokmål (64%) * Portuguese (99%) * Portuguese (Brazil) (99%) * Slovak (100%) * Spanish (100%) * Turkish (100%) Partial translations are available for various other languages. The Koha team welcomes additional translations; please see http://wiki.koha-community.org/wiki/Translating_Koha for information about translating Koha, and join the koha-translate list to volunteer: http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-translate The most up-to-date translations can be found at: http://translate.koha-community.org/ Release Team ====================== The release team for Koha 3.10.5 is Release Manager: Jared Camins-Esakov <jcamins(a)cpbibliography.com> Documentation Manager: Nicole C Engard <nengard(a)gmail.com> Translation Manager: D Ruth Bavousett <ruth(a)bywatersolutions.com> QA Manager: Katrin Fischer <Katrin.Fischer(a)bsz-bw.de>, QA Team: Marcel de Rooy <M.de.Rooy(a)rijksmuseum.nl>, Jonathan Druart <jonathan.druart(a)biblibre.com>, Mason James <mtj(a)kohaaloha.com>, Elliott Davis <elliott(a)bywatersolutions.com> Bug Wranglers: Magnus Enger <magnus(a)enger.priv.no>, Marc Véron <veron(a)veron.ch>, Chris Hall <chrish(a)catalyst.net.nz>, Mirko Tietgen <5p4m(a)gmx.de> Packaging Manager: Robin Sheat <robin(a)catalyst.net.nz> Packaging Assistant: Mason James <mtj(a)kohaaloha.com> Release Maintainer (3.6.x): Liz Rea <liz(a)catalyst.net.nz> Release Maintainer (3.8.x): Chris Cormack <chrisc(a)catalyst.net.nz> Release Maintainer (3.10.x): Chris Cormack <chrisc(a)catalyst.net.nz> Credits ====================== We thank the following libraries who are known to have sponsored new features in Koha 3.10.5: * KEEP SOLUTIONS We thank the following individuals who contributed patches to Koha 3.10.5. * 3 Jared Camins-Esakov * 1 Colin Campbell * 1 Galen Charlton * 3 David Cook * 5 Chris Cormack * 2 Jonathan Druart * 4 Magnus Enger * 1 Vitor FERNANDES * 4 Kyle M Hall * 1 Mason James * 2 Peter Crellan Kelly * 2 Owen Leonard * 1 Chris Nighswonger * 4 Dobrica Pavlinusic * 1 Karam Qubsi * 1 Thatcher Rea * 2 Liz Rea * 2 Marcel de Rooy * 15 Fridolyn SOMERS * 1 Mathieu Saby * 2 Adrien Saurat * 1 Robin Sheat * 1 Will Stokes * 1 ByWater Migration Support * 1 Aaron Wells * 1 Jen Zajac We thank the following companies who contributed patches to Koha 3.10.5 * 2 ACPL * 19 Biblibre * 4 BigBallOfWax * 6 ByWater-Solutions * 3 C & P Bibliography * 9 Catalyst * 1 Equinox * 1 Foundations * 1 KohaAloha * 4 Libriotech * 1 PTFS-Europe * 3 Prosentient Systems * 2 Rijksmuseum * 1 Université Rennes 2 * 1 keep.pt * 4 rot13.org * 1 unidentified We also especially thank the following individuals who tested patches for Koha 3.10.5. * 4 Tomas Cohen Arazi * 1 Larry Baerveldt * 1 Brendan * 51 Jared Camins-Esakov * 5 Galen Charlton * 60 Chris Cormack * 1 Frédéric Demians * 14 Jonathan Druart * 1 Frédéric Durand * 1 Nicole C. Engard * 4 Magnus Enger * 25 Katrin Fischer * 6 Kyle M Hall * 6 Mason James * 5 Bernardo Gonzalez Kriegel * 9 Owen Leonard * 1 Sophie Meynieux * 1 Chris Nighswonger * 1 Dobrica Pavlinusic * 6 Paul Poulain * 1 MJ Ray * 5 Liz Rea * 5 Marcel de Rooy * 1 Mathieu Saby * 1 Robin Sheat We regret any omissions. If a contributor has been inadvertantly missed, please send a patch against these release notes to koha-patches(a)lists.koha-community.org. Revision control notes ====================== The Koha project uses Git for version control. The current development version of Koha can be retrieved by checking out the master branch of git://git.koha-community.org/koha.git The branch for this version of Koha and future bugfixes in this release line is 3.10.x. The last Koha release was 3.8.10, which was released on February 23, 2013. Bugs and feature requests ====================== Bug reports and feature requests can be filed at the Koha bug tracker at http://bugs.koha-community.org/ Ehara taku toa i te toa takitahi, engari he toa takitini

2 1

search not working (zebra error) ??!
by abdallah abdelsalam 24 Apr '13

24 Apr '13

Hi I use Koha version 3.00.00.094 search does not give results(It gives results before) but i don't know what happened When making rebuild zebra(migration_tools/rebuild_zebra.pl -b -a -w) This error appears 20:16:43-23/04 zebraidx(22731) [fatal] Node node_zebra missing 20:16:43-23/04 zebraidx(22731) [warn] Cannot obtain EXPLAIN information 20:16:43-23/04 zebraidx(22731) [fatal] zebra_begin_trans: cannot open register any help??

2 2

Koha 3.8.12 released
by Chris Cormack 24 Apr '13

24 Apr '13

The Koha community is proud to announce the release of 3.8.12, this is a maintenance release and contains many bugfixes. As always you can download the release from http://download.koha-community.org Please read below for the full release notes RELEASE NOTES FOR KOHA 3.8.12 23 Apr 2013 ======================================================================== Koha is the first free and open source software library automation package (ILS). Development is sponsored by libraries of varying types and sizes, volunteers, and support companies from around the world. The website for the Koha project is http://koha-community.org/ Koha 3.8.12 can be downloaded from: http://download.koha-community.org/koha-3.08.12.tar.gz Installation instructions can be found at: http://wiki.koha-community.org/wiki/Installation_Documentation OR in the INSTALL files that come in the tarball Koha 3.8.12 is a bugfix/maintenance release. Major fixes in 3.8.12 ====================== Acquisitions ---------- 7018 critical need all acq permissions to search Cataloging ---------- 8860 critical can't merge if you don't have fast cataloging permissions 9908 major OCLC Connexion Desktop Client Doesn't Work Circulation ---------- 9953 major When OpacMaintenance breaks lifting debarment Installation and upgrade (command-line installer) ---------- 8780 major Lower dependency version for DateTime::TimeZone Notices ---------- 8378 major <fine> syntax not working on overdues anymore Searching ---------- 9050 major rebuild_zebra should use the adelete action so it doesn't fail when deleting a record not in the index 9341 major Problem with UNIMARC authors facets Tools ---------- 9535 major Patron card creator "Remove duplicates" function doesn't work Other bugs fixed in 3.8.12 ========================== About ---------- 9956 trivial Add missing translators to the about page Acquisitions ---------- 7875 trivial Pending suggestion link (the numbers) from staff client home directs to accepted suggestions instead of pending Architecture, internals, and plumbing ---------- 7379 normal copynumber is displayed 'as is' when linked to autorised values 9609 trivial Rebuild zebra reports double numbers for exported records with -z option Command-line Utilities ---------- 9885 normal Passwords generated by command line scripts are weak Hold requests ---------- 9786 normal [3.8.X] Holds to pull showing items not available I18N/L10N ---------- 7938 normal The -v option to the translate script is not documented Installation and upgrade (command-line installer) ---------- 8742 trivial Example uses perl 5.8 in Makefile.PL Installation and upgrade (web-based installer) ---------- 9863 trivial 'import' button in web installer should read 'Import' MARC Bibliographic data support ---------- 9274 normal Software error in bibtex export OPAC ---------- 9502 minor [3.8.X] famfamfam: wrongly placed in package 3.8.8/9 Packaging ---------- 8816 normal add WARNING to debian/control file, to not manually edit 9802 minor Add test case to verify package man pages are well formatted Patrons ---------- 9002 normal Remove Problematic Logic from Patron Messaging Preferences Form Searching ---------- 9419 minor The highlight feature can cause a browser freeze Self checkout ---------- 9748 minor noitemlinks not being enforced Serials ---------- 9947 minor Creating item for received serial prefills enumchron subfield SIP2 ---------- 9838 trivial SIP tests : fix in 04patron_status.t Staff Client ---------- 9726 minor XISBN service throttle not initialized Templates ---------- 9945 normal Pretty icon display in authorised values configuration 5648 minor icons clumping together 8737 minor Incorrect icon at login in staff client 9571 minor Fix width for textareas in Edit Item screen 9781 minor [3.6.X/3.8.x] Fix dynarch calendar positioning in IE Tools ---------- 8861 minor Undefined variables in batchMod.pl trigger error logs 9954 minor CSV profile encoding not selected on editing translate.koha-community.org ---------- 8942 normal Translation process breaks javascript in calendar.inc Enhancements in 3.8.12 ====================== ---------- New sysprefs in 3.8.12 ====================== * UNIMARCAuthorsFacetsSeparator System requirements ====================== Important notes: * Perl 5.10 is required * Zebra is required Documentation ====================== As of Koha 3.2, the Koha manual is now maintained in DocBook. The home page for Koha documentation is http://koha-community.org/documentation/ As of the date of these release notes, only the English version of the Koha manual is available: http://manual.koha-community.org/3.8.12/en/ The Git repository for the Koha manual can be found at http://git.koha-community.org/gitweb/?p=kohadocs.git;a=summary Translations ====================== Complete or near-complete translations of the OPAC and staff interface are available in this release for the following languages: * English (USA) * Arabic (100%) * Armenian (99%) * Chinese (Taiwan) (75%) * Danish (74%) * English (New Zealand) (99%) * French (99%) * French (Canada) (76%) * German (100%) * German (Switzerland) (99%) * Greek (95%) * Italian (99%) * Norwegian Bokmål (67%) * Portuguese (99%) * Portuguese (Brazil) (99%) * Slovak (100%) * Spanish (100%) * Turkish (100%) Partial translations are available for various other languages. The Koha team welcomes additional translations; please see http://wiki.koha-community.org/wiki/Translating_Koha for information about translating Koha, and join the koha-translate list to volunteer: http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-translate The most up-to-date translations can be found at: http://translate.koha-community.org/ Release Team ====================== The release team for Koha 3.8.12 is Release Manager: Paul Poulain <paul.poulain(a)biblibre.com> Documentation Manager: Nicole C Engard <nengard(a)gmail.com> Translation Manager: Frédéric Demians <frederic(a)tamil.fr> QA Manager: Ian Walls <koha.sekjal(a)gmail.com> QA team: Marcel de Rooy <M.de.Rooy(a)rijksmuseum.nl>, Jonathan Druart <jonathan.druart(a)biblibre.com> Mason James <mason(a)kohaaloha.com> Bug Wranglers: Katrin Fischer, Magnus Enger Release Maintainer (3.4.x): Chris Nighswonger <cnighswonger(a)foundations.edu> Release Maintainer (3.6.x): Jared Camins-Esakov <jcamins(a)cpbibliography.com> Release Maintainer (3.8.x): Chris Cormack <chrisc(a)catalyst.net.nz> Credits ====================== We thank the following libraries who are known to have sponsored new features in Koha 3.8.12: * KEEP SOLUTIONS We thank the following individuals who contributed patches to Koha 3.8.12. * 1 Tomas Cohen Arazi * 1 Jared Camins-Esakov * 3 David Cook * 8 Chris Cormack * 2 Jonathan Druart * 1 Vitor FERNANDES * 2 Kyle M Hall * 2 Peter Crellan Kelly * 1 Owen Leonard * 1 Chris Nighswonger * 4 Dobrica Pavlinusic * 1 Karam Qubsi * 1 Thatcher Rea * 1 Marcel de Rooy * 9 Fridolyn SOMERS * 1 Mathieu Saby * 2 Adrien Saurat * 1 Robin Sheat * 1 Will Stokes * 4 Mark Tompsett * 1 Aaron Wells * 1 Jen Zajac * 1 “ByWater We thank the following companies who contributed patches to Koha 3.8.12 * 1 ACPL * 13 Biblibre * 6 BigBallOfWax * 3 ByWater-Solutions * 1 C & P Bibliography * 8 Catalyst * 1 Foundations * 3 Prosentient Systems * 1 Rijksmuseum * 1 Université Rennes 2 * 1 bywatersolutions.com” * 1 keep.pt * 4 rot13.org * 6 unidentified We also especially thank the following individuals who tested patches for Koha 3.8.12. * 4 Tomas Cohen Arazi * 29 Jared Camins-Esakov * 2 Galen Charlton * 45 Chris Cormack * 10 Jonathan Druart * 1 Frédéric Durand * 3 Magnus Enger * 13 Katrin Fischer * 8 Kyle M Hall * 4 Mason James * 1 Bernardo Gonzalez Kriegel * 10 Owen Leonard * 1 Sophie Meynieux * 1 Chris Nighswonger * 1 Paul Poulain * 1 MJ Ray * 1 Liz Rea * 4 Marcel de Rooy * 1 Robin Sheat * 1 wajasu We regret any omissions. If a contributor has been inadvertantly missed, please send a patch against these release notes to koha-patches(a)lists.koha-community.org. Revision control notes ====================== The Koha project uses Git for version control. The current development version of Koha can be retrieved by checking out the master branch of git://git.koha-community.org/koha.git The branch for this version of Koha and future bugfixes in this release line is 3.8.x. The last Koha release was 3.6.11, which was released on December 27, 2012. Bugs and feature requests ====================== Bug reports and feature requests can be filed at the Koha bug tracker at http://bugs.koha-community.org/ Ehara taku toa i te toa takitahi, engari he toa takitini

1 0

Importing patrons' borrowing histories?
by Harminder Singh 24 Apr '13

24 Apr '13

Hi everyone, I was wondering if there's some way to import patrons' borrowing histories when setting up a new Koha implementation. The library I'm doing it in wants to keep the borrowing histories of their members in Koha. Is there some way to do so? I couldn't find it in the manual. thanks Harminder

2 1

Re: [Koha] [Koha-devel] Sip error in Koha on my local git copy
by Galen Charlton 23 Apr '13

23 Apr '13

Hi, On Tue, Apr 23, 2013 at 12:42 PM, Scott Kushner <skushner(a)mplmain.mtpl.org> wrote: > root@mtplkohacomm:/home/koha/kohaclone# perl -I ./SIPServer.pm > /home/koha/kohaclone/etc/SIPconfig.xml > > syntax error at /home/koha/kohaclone/etc/SIPconfig.xml line 2, near "-->" The invocation isn't quite right. Assuming you're in C4/SIP, try: perl -I . ./SIPServer.pm /home/koha/kohaclone/etc/SIPconfig.xml "-I ." tells the Perl interpreter to add the current working directory to the module search path. Regards, Galen -- Galen Charlton Manager of 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

Sip error in Community Koha on my local git copy
by Scott Kushner 23 Apr '13

23 Apr '13

Has anyone seen this error? root@mtplkohacomm:/home/koha/kohaclone# perl -I ./SIPServer.pm /home/koha/kohaclone/etc/SIPconfig.xml syntax error at /home/koha/kohaclone/etc/SIPconfig.xml line 2, near "-->" Unterminated <> operator at /home/koha/kohaclone/etc/SIPconfig.xml line 5. Thanks, Scott Kushner Middletown Library

1 0

Re: [Koha] Koha Digest, Vol 90, Issue 31
by عبد الرزاق محمود 23 Apr '13

23 Apr '13

i use koha 3.8 when i add new item type did not appear in catalog , but the biblio appear without item , and when rebuild-zebra , appear with record . Are there any solutions to show directly On Tue, Apr 23, 2013 at 8:34 AM, <koha-request(a)lists.katipo.co.nz> wrote: > Send Koha mailing list submissions to > koha(a)lists.katipo.co.nz > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.katipo.co.nz/mailman/listinfo/koha > or, via email, send a message with subject or body 'help' to > koha-request(a)lists.katipo.co.nz > > You can reach the person managing the list at > koha-owner(a)lists.katipo.co.nz > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Koha digest..." > > > Today's Topics: > > 1. Re: Report Help (Bernardo Gonzalez Kriegel) > 2. Opac can't show non-latin characters correctly (Peter Zhao) > 3. Re: Opac can't show non-latin characters correctly > (Fischer, Katrin) > 4. Re: [Koha-devel] Translation manager for v3.14 (Fischer, Katrin) > 5. Re: koha lost/missing items (Mason James) > 6. Please unsubscribe me (Usman) > 7. Re: Report Help (Nicole Engard) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Mon, 22 Apr 2013 22:19:10 -0300 > From: Bernardo Gonzalez Kriegel <bgkriegel(a)gmail.com> > To: Nicole Engard <nengard(a)gmail.com> > Cc: Koha <Koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Report Help > Message-ID: > <CADF4kvQYUY2M7BtwU-L3pDPA=02-OHSx= > SyTWytO_6h1zyPZYg(a)mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Nicole, > you want for each guarantor it's guarantees, Q: it's ok to repeat guarantor > information on each guarantee tuple? > > you could use something like this (put any data you want in first select, > and change order by if needed) > > SELECT > IFNULL(concat(g.surname, ', ', g.firstname, ' (',g.cardnumber, ')'),'') > AS guarantor, > IFNULL(concat(p.surname, ', ', p.firstname, ' (',p.cardnumber, ')'),'') > AS guarantee > FROM > ( > SELECT * > FROM borrowers > WHERE guarantorid IS NOT NULL > ) AS p > LEFT JOIN borrowers AS g > ON p.guarantorid = g.borrowernumber > ORDER BY g.borrowernumber > ; > > Bernardo > > -- > Bernardo Gonzalez Kriegel > bgkriegel(a)gmail.com > > > On Mon, Apr 22, 2013 at 4:18 PM, Nicole Engard <nengard(a)gmail.com> wrote: > > > I'm looking to change this report around. It shows patrons with their > > guarantor information. I want a report that shows me the guarantees for > > each guarantor instead. > > > > > > SELECT p.categorycode, p.dateofbirth, p.cardnumber, p.surname, > p.firstname, > > p.dateexpiry, IFNULL(concat(g.surname, ', ', g.firstname, ' (', > > g.cardnumber, ')'),'') AS guarantor, p.relationship, > > ifnull(FORMAT(SUM(a.amountoutstanding),2),'0.00') AS due > > FROM borrowers p > > LEFT JOIN accountlines a USING (borrowernumber) > > LEFT JOIN borrowers g ON (p.guarantorid=g.borrowernumber) > > WHERE p.dateexpiry < NOW() > > GROUP BY p.borrowernumber > > ORDER BY p.dateexpiry ASC > > > > > > > > Nicole > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > ------------------------------ > > Message: 2 > Date: Tue, 23 Apr 2013 14:22:04 +0800 (CST) > From: "Peter Zhao" <peterzhaonj(a)163.com> > To: koha(a)lists.katipo.co.nz > Subject: [Koha] Opac can't show non-latin characters correctly > Message-ID: <3007ca14.81f9.13e358e66ae.Coremail.peterzhaonj(a)163.com> > Content-Type: text/plain; charset=GBK > > Hi, > > Warmly greetings. > > Could anyone know why in the "Refine your search" column area of OPAC > can not show non-latin characters ? But in the other area of the OPAC can > show non-latin characters. Anyone know how to fix this problem? Thanks a > lot. > > Peter > > > > > > ------------------------------ > > Message: 3 > Date: Tue, 23 Apr 2013 09:37:54 +0200 > From: "Fischer, Katrin" <Katrin.Fischer(a)bsz-bw.de> > To: "Peter Zhao" <peterzhaonj(a)163.com>, <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Opac can't show non-latin characters correctly > Message-ID: > <028B1A54D03E7B4482CDCA4EC8F06BFD02BCA251(a)Bodensee.bsz-bw.de> > Content-Type: text/plain; charset="UTF-8" > > Hi Peter, > > the facets should work correctly with non-latin characters. > Which version of Koha are you using? > What is the problem you see? > > Katrin > > > -----Original Message----- > > From: koha-bounces(a)lists.katipo.co.nz [mailto:koha- > > bounces(a)lists.katipo.co.nz] On Behalf Of Peter Zhao > > Sent: Tuesday, April 23, 2013 8:22 AM > > To: koha(a)lists.katipo.co.nz > > Subject: [Koha] Opac can't show non-latin characters correctly > > > > Hi, > > > > Warmly greetings. > > > > Could anyone know why in the "Refine your search" column area of OPAC > > can not show non-latin characters ? But in the other area of the OPAC can > > show non-latin characters. Anyone know how to fix this problem? Thanks a > > lot. > > > > Peter > > > > > > > > _______________________________________________ > > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > ------------------------------ > > Message: 4 > Date: Mon, 22 Apr 2013 10:22:34 +0200 > From: "Fischer, Katrin" <Katrin.Fischer(a)bsz-bw.de> > To: "Bernardo Gonzalez Kriegel" <bgkriegel(a)gmail.com>, "Galen > Charlton" <gmc(a)esilibrary.com> > Cc: Koha-List <koha(a)lists.katipo.co.nz>, > koha-translate(a)lists.koha-community.org, Koha Devel > <Koha-devel(a)lists.koha-community.org> > Subject: Re: [Koha] [Koha-devel] Translation manager for v3.14 > Message-ID: > <028B1A54D03E7B4482CDCA4EC8F06BFD02BCA0F9(a)Bodensee.bsz-bw.de> > Content-Type: text/plain; charset="UTF-8" > > Hi Bernardo, > > thank you for volunteering! > > I have been helping out with setting up permissions and accounts for > translators on Pootle and can continue doing that if the new translation > manager would like me to. > > Katrin > > > -----Original Message----- > > From: koha-bounces(a)lists.katipo.co.nz [mailto:koha- > > bounces(a)lists.katipo.co.nz] On Behalf Of Bernardo Gonzalez Kriegel > > Sent: Saturday, April 20, 2013 9:22 PM > > To: Galen Charlton > > Cc: Koha-List; koha-translate(a)lists.koha-community.org; Koha Devel > > Subject: Re: [Koha] [Koha-devel] Translation manager for v3.14 > > > > Hi all, > > > > On Fri, Apr 19, 2013 at 5:29 PM, D Ruth Bavousett <druthb(a)gmail.com> > wrote: > > > > Given my situation, and after discussing the matter with Galen, I've > > > decided > > > > that my term as Translation Manager should end after the release of > > > > 3.12 next month. I'll be happy to help hand off matters, and will > > > > update the wiki page to reflect current processes, in order to make > > > > for a smooth transition, once someone is elected. > > > > > > > > Ruth, as many others have expressed , is sad news that you need to leave. > > Also, we all expect that you remain involved as far as you can. > > > > > > > As far as the election is concerned, I suggest that folks interested > > > in being the Translation Manager for 3.14 submit their proposals in > > > time for discussion to take place at the next general IRC meeting, > > > which is scheduled for 7 May 2013. In case there isn't a quick > > > consensus achieved at that meeting, I further suggest that the vote > > > for TM be held at the June meeting. > > > > > > > > About the role of TM, I want to volunteer for the post. > > I currently run the site dedicated to the translation of the manual, also > > using Pootle. Certainly is a small site, there are only > > 2 active translations (Arabic and Spanish), but that gives me a glimpse > of > > the tasks involved. > > > > I know there are some ideas about migrating out of Pootle to better > tools, > > but I am also appointed as RM for 3.10.x, for that reason I prefer not to > > change our tools at this moment. > > > > So, I think I can deal with both posts but without changes in current > > infrastructure; or someone could take RM 3.10.x, I have no problem to > step > > back; or we found another volunteer for TM with more time. > > > > As far as I know, there is no need to relocate current translate.k-c > > server, anyone interested could use it without problem. > > > > Best regards, > > Bernardo > > _______________________________________________ > > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > ------------------------------ > > Message: 5 > Date: Tue, 23 Apr 2013 20:43:45 +1200 > From: Mason James <mtj(a)kohaaloha.com> > To: schnydszch <eugenegf(a)yahoo.com> > Cc: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] koha lost/missing items > Message-ID: <53F4CFFC-6FAD-478D-A157-678DCBC871F1(a)kohaaloha.com> > Content-Type: text/plain; charset=windows-1252 > > > On 2013-04-22, at 7:15 PM, schnydszch wrote: > > > I have Koha 3.10.4 installed in debian server. Whenever I set status to > an > > item in moredetail.pl as lost it does not reflect that it's lost. > > this is nearly always caused by the slight lag in zebra indexing > > reindex your zebra? is the problem solved? > > > > > ------------------------------ > > Message: 6 > Date: Tue, 23 Apr 2013 05:10:01 -0700 (PDT) > From: Usman <usmi_usman(a)yahoo.com> > To: "Koha(a)lists.katipo.co.nz" <Koha(a)lists.katipo.co.nz> > Subject: [Koha] Please unsubscribe me > Message-ID: > <1366719001.9727.YahooMailNeo(a)web141001.mail.bf1.yahoo.com> > Content-Type: text/plain; charset=iso-8859-1 > > Hello, > > Please unsubscribe me from this list. > > Thank You !! > ? > ---- > Muhammad Usman > Phone : +923215823532 > IM : usman_usmi4(a)hotmail.com > Skype: usmi_usman > Profile:http://www.linkedin.com/in/usmiusman > > ------------------------------ > > Message: 7 > Date: Tue, 23 Apr 2013 08:34:02 -0400 > From: Nicole Engard <nengard(a)gmail.com> > To: Bernardo Gonzalez Kriegel <bgkriegel(a)gmail.com> > Cc: Koha <Koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Report Help > Message-ID: > < > CAC0K6VFwzvTct1vd1DW4tPy+XXNG-r7g_ZnjH-7rzhdqS+puvg(a)mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Thank you! That's a step in the right direction :) I have shared it (in > your name) on the Koha wiki for others to benefit from. > > Nicole > > > On Mon, Apr 22, 2013 at 9:19 PM, Bernardo Gonzalez Kriegel < > bgkriegel(a)gmail.com> wrote: > > > Nicole, > > you want for each guarantor it's guarantees, Q: it's ok to repeat > > guarantor information on each guarantee tuple? > > > > you could use something like this (put any data you want in first select, > > and change order by if needed) > > > > SELECT > > IFNULL(concat(g.surname, ', ', g.firstname, ' (',g.cardnumber, ')'),'') > > AS guarantor, > > IFNULL(concat(p.surname, ', ', p.firstname, ' (',p.cardnumber, ')'),'') > > AS guarantee > > FROM > > ( > > SELECT * > > FROM borrowers > > WHERE guarantorid IS NOT NULL > > ) AS p > > LEFT JOIN borrowers AS g > > ON p.guarantorid = g.borrowernumber > > ORDER BY g.borrowernumber > > ; > > > > Bernardo > > > > -- > > Bernardo Gonzalez Kriegel > > bgkriegel(a)gmail.com > > > > > > On Mon, Apr 22, 2013 at 4:18 PM, Nicole Engard <nengard(a)gmail.com> > wrote: > > > >> I'm looking to change this report around. It shows patrons with their > >> guarantor information. I want a report that shows me the guarantees for > >> each guarantor instead. > >> > >> > >> SELECT p.categorycode, p.dateofbirth, p.cardnumber, p.surname, > >> p.firstname, > >> p.dateexpiry, IFNULL(concat(g.surname, ', ', g.firstname, ' (', > >> g.cardnumber, ')'),'') AS guarantor, p.relationship, > >> ifnull(FORMAT(SUM(a.amountoutstanding),2),'0.00') AS due > >> FROM borrowers p > >> LEFT JOIN accountlines a USING (borrowernumber) > >> LEFT JOIN borrowers g ON (p.guarantorid=g.borrowernumber) > >> WHERE p.dateexpiry < NOW() > >> GROUP BY p.borrowernumber > >> ORDER BY p.dateexpiry ASC > >> > >> > >> > >> Nicole > >> _______________________________________________ > >> Koha mailing list http://koha-community.org > >> 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 > > > End of Koha Digest, Vol 90, Issue 31 > ************************************ >

1 0

Please unsubscribe me
by Usman 23 Apr '13

23 Apr '13

Hello, Please unsubscribe me from this list. Thank You !! ---- Muhammad Usman Phone : +923215823532 IM : usman_usmi4(a)hotmail.com Skype: usmi_usman Profile:http://www.linkedin.com/in/usmiusman

2 1