- Koha - lists.katipo.co.nz

SIP2 Configuration Koha 3.10
by Vishal Patil 23 May '13

23 May '13

Hi, Can anyone help me with SIP2 configuration. I am using Koha 3.10. Best Regards, Vishal

1 0

Koha 3.10.6 released
by Chris Cormack 23 May '13

23 May '13

The Koha community is proud to announce the release of Koha 3.10.6, this is a stable release and contains many bugfixes. The packages are available at debian.koha-community.org or you can download the tarball from download.koha-community.org This is also my last release as 3.10.x release maintainer, thanks again to all the many people who have contributed along they way. Please read more for the full release notes RELEASE NOTES FOR KOHA 3.10.6 23 May 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.6 can be downloaded from: http://download.koha-community.org/koha-3.10.06.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.6 is a bugfix/maintenance release. Highlights of 3.10.6 ====================== Acquisitions ---------- 7228 major can't order more than 1 when importing all from staged file 9923 major correction of a bug due to bz 7129 Cataloging ---------- 185 blocker Barcode not auto-calculated when autobarcode is on 9392 major confirmation does not appear for negative notforloan items issues 9684 major Z39.50 Card View broken in CCSR Circulation ---------- 8770 blocker amount does not equal amountoutstanding on a fine with no payments or credits Hold requests ---------- 8294 major enumeration should show in copy specific hold menu MARC Bibliographic record staging/import ---------- 9839 major when importing MARC records, item record not created even when set to "always add" OPAC ---------- 9679 major can't place hold from cart in CCSR Reports ---------- 6898 major circulation librarians can't run overdues without reports permissions Staff Client ---------- 9591 blocker Set Library changes after viewing Holds Queue >> reserves item Tools ---------- 8264 major local cover images not working in IE8 Bugs fixed in 3.10.6 ====================== Acquisitions ---------- 72 normal can't receive an order 2046 normal Suggestions: Title Field too small 7358 normal basket.pl : it is possible to affect a closed basket to a closed basketgroup Cataloging ---------- 144 normal Missing mandatory subfields not correctly highlighted 5790 normal Deleting a biblio should alert/fail if there are existent holds 9358 normal Fixed field plugins for MARC21 should be updated for MARC21 update #15 9523 normal Trying to import staged marc records where a matched bib has been deleted caused the import to hang 9019 minor ILS-DI: GetRecords should return item fields in marcxml 9759 minor last subfield can be deleted Circulation ---------- 101 normal circulation error 111 normal Client can request item multiple times 150 normal "Next Borrower" button results in Internal Server Error 9860 normal Incorrect box heading 'Cannot check in' when a late document is returned 9720 minor uninitialized value warnings in circulation Hold requests ---------- 8419 normal Suspended holds appear on the daily holds queue 8508 minor Holds to Pull : Library dropdown options are erroneously concatenated by br tags I18N/L10N ---------- 6709 normal marc21_field_006.xml and marc21_field_008.xml can't be translated. 9266 normal Untranslated strings in tags moderation 9818 normal "Overdue Fines Cap ($)" should not use $ (I18N) importedbugs ---------- 58 normal typos 84 normal broken link Installation and upgrade (command-line installer) ---------- 42 normal installer.pl could prompt user to send testing results in 44 normal scripts dir doesn't get installed to $kohadir 85 normal koha.upgrade squashes custom templates 149 normal Installation fails if the MySQL root password is not set 152 normal Install.pm missing from main branch 153 normal opachtdocs and intrahtdocs in koha.conf not initialized 156 normal in Install.pm the marc21 refers to /script/ instead of /scripts/ 9812 normal Several files shouldn't be exposed or browseable through a URL 176 minor showmessage yn does not accept uppercase Y or N Installation and upgrade (web-based installer) ---------- 9831 minor Wrong and missing values in installer for French UNIMARC MARC Bibliographic data support ---------- 7054 normal NORMARC: wrong default for 000 position 17 7055 normal NORMARC: Links and defaults for 008 position 15-17 and 35-37 9213 normal Implement analytics for NORMARC XSLT 9804 trivial Fix name for NORMARC biblio-koha-indexdefs.xml MARC Bibliographic record staging/import ---------- 9035 trivial remove deprecated 'bulkauthimport.pl' file OPAC ---------- 41 normal OPAC Search Results Missing Branch 4862 minor "Browse by subject" is misnamed 93 trivial Minor HTML Template error Patrons ---------- 22 normal autoMemberNum doesn't work with Add Child 33 normal autoMemberNum set to 1 by default 225 normal Add member ignores parameters set in categories 9479 normal The member notices page does not display dates in the syspref format 9556 normal Changing patron category does not fully update patron messaging preferences 9484 minor userid not generated consistently (different editing pages) 9330 trivial Patron duplication : should duplicate with empty title (salutation field) 9981 trivial Sort1 not automatically cleared when duplicating a patron Searching ---------- 9049 normal rebuild_zebra should not use shadow when called with -r Serials ---------- 8896 normal Delete serials no more missing from missinglist Staff Client ---------- 2 normal Need appropriate graphic for admin scripts 26 normal marcimport.pl reports DONE for records that aren't done 104 normal moditem.pl displays the wrong record 107 normal templates for intranet are still in old includes/templates location 9397 trivial Error Messages hard to find for Visually Impaired Users (Accessibility) [Returning Items] Templates ---------- 9555 normal Template files contain single quote strings 9737 normal Local Covers sometimes appear then disappear on OPAC Search Results/Lists 9608 minor white background on header on check in 9613 minor items namespace missing in XSLT 9957 trivial Missing cancel link on subfield editing page Transaction logs ---------- 7241 normal circulation action logs record biblionumber instead of item number Enhancements in 3.10.6 ====================== Installation and upgrade (command-line installer) ---------- 97 Various buildrelease patches 110 patron can place unlimited holds on a item Packaging ---------- 9250 Provide commands to allow handling of SIP servers in the packages New sysprefs in 3.10.6 ====================== 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.6/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 (98%) * Armenian (98%) * Chinese (China) (92%) * Chinese (Taiwan) (99%) * Danish (100%) * English (New Zealand) (98%) * French (95%) * French (Canada) (66%) * German (98%) * German (Switzerland) (95%) * Greek (60%) * Italian (100%) * Norwegian Bokmål (63%) * Portuguese (98%) * Portuguese (Brazil) (97%) * 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.6 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.6: * Universidad Nacional de Córdoba We thank the following individuals who contributed patches to Koha 3.10.6. * 12 Tomas Cohen Arazi * 1 Edmund Balnaves * 1 Stefano Bargioni * 1 D Ruth Bavousett * 3 Jared Camins-Esakov * 1 Colin Campbell * 1 Galen Charlton * 4 David Cook * 7 Chris Cormack * 2 Christophe Croullebois * 5 Jonathan Druart * 6 Magnus Enger * 2 Katrin Fischer * 1 Corey Fuimaono * 8 Kyle M Hall * 1 Kristina D.C. Hoeppner * 3 Bernardo Gonzalez Kriegel * 12 Owen Leonard * 3 Julian Maurice * 1 Karam Qubsi * 1 Liz Rea * 3 Marcel de Rooy * 8 Fridolyn SOMERS * 1 Mathieu Saby * 5 Adrien Saurat * 2 Robin Sheat * 1 Lyon3 Team We thank the following companies who contributed patches to Koha 3.10.6 * 12 ACPL * 2 BSZ BW * 23 Biblibre * 3 BigBallOfWax * 8 ByWater-Solutions * 3 C & P Bibliography * 8 Catalyst * 1 Equinox * 6 Libriotech * 1 PTFS-Europe * 5 Prosentient Systems * 3 Rijksmuseum * 1 Université Jean Moulin Lyon 3 * 1 Université Rennes 2 * 1 pusc.it * 18 unidentified We also especially thank the following individuals who tested patches for Koha 3.10.6. * 61 Jared Camins-Esakov * 7 Galen Charlton * 4 David Cook * 115 Chris Cormack * 1 Elliott Davis * 1 Srikanth Dhondi * 22 Jonathan Druart * 5 Nicole C. Engard * 3 Magnus Enger * 36 Katrin Fischer * 12 Kyle M Hall * 11 Mason James * 5 Bernardo Gonzalez Kriegel * 13 Owen Leonard * 4 Paul Poulain * 3 Liz Rea * 13 Marcel de Rooy * 1 Fridolyn SOMERS * 5 Mathieu Saby * 1 Adrien Saurat * 1 Robin Sheat * 2 Mirko Tietgen * 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.10.x. The last Koha stable release was 3.10.05, which was released on April 22, 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

1 0

Koha 3.8.13 released
by Chris Cormack 23 May '13

23 May '13

It is with great pleasure the Koha community announce the release of Koha 3.8.13 this a maintenance release and contains many bugfixes. It is available for download from download.koha-community.org This is my last release as release maintainer for the 3.8.x branch. I would like to thank all those who wrote patches, tested, signed off, and did QA, as well as of course Jared the release manager. Please read below for full release notes. RELEASE NOTES FOR KOHA 3.8.13 23 May 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.13 can be downloaded from: http://download.koha-community.org/koha-3.08.13.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.13 is a bugfix/maintenance release. Highlights of 3.8.13 ====================== Acquisitions ---------- 7228 major can't order more than 1 when importing all from staged file 9923 major correction of a bug due to bz 7129 Staff Client ---------- 9591 blocker Set Library changes after viewing Holds Queue >> reserves item Tools ---------- 8264 major local cover images not working in IE8 Bugs fixed in 3.8.13 ====================== Cataloging ---------- 9019 minor ILS-DI: GetRecords should return item fields in marcxml I18N/L10N ---------- 9266 normal Untranslated strings in tags moderation Installation and upgrade (command-line installer) ---------- 42 normal installer.pl could prompt user to send testing results in 156 normal in Install.pm the marc21 refers to /script/ instead of /scripts/ 9812 normal Several files shouldn't be exposed or browseable through a URL MARC Bibliographic data support ---------- 9804 trivial Fix name for NORMARC biblio-koha-indexdefs.xml OPAC ---------- 93 trivial Minor HTML Template error Patrons ---------- 22 normal autoMemberNum doesn't work with Add Child 33 normal autoMemberNum set to 1 by default 225 normal Add member ignores parameters set in categories 9484 minor userid not generated consistently (different editing pages) Staff Client ---------- 107 normal templates for intranet are still in old includes/templates location 8895 minor Warning in systempreferences.pl: Use of uninitialized value in length... Templates ---------- 9613 minor items namespace missing in XSLT 9957 trivial Missing cancel link on subfield editing page Enhancements in 3.8.13 ====================== ---------- New sysprefs in 3.8.13 ====================== 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.13/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 (100%) * Chinese (Taiwan) (75%) * Danish (93%) * English (New Zealand) (100%) * French (99%) * French (Canada) (76%) * German (100%) * German (Switzerland) (99%) * Greek (95%) * Italian (100%) * Norwegian Bokmål (67%) * Portuguese (100%) * 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.13 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.13: * Universidad Nacional de Córdoba We thank the following individuals who contributed patches to Koha 3.8.13. * 3 Tomas Cohen Arazi * 1 Edmund Balnaves * 1 Stefano Bargioni * 1 D Ruth Bavousett * 1 David Cook * 4 Chris Cormack * 2 Christophe Croullebois * 1 Magnus Enger * 3 Owen Leonard * 1 Julian Maurice * 3 Fridolyn SOMERS * 1 Adrien Saurat * 1 Marc Veron We thank the following companies who contributed patches to Koha 3.8.13 * 3 ACPL * 7 Biblibre * 2 BigBallOfWax * 2 Catalyst * 1 Libriotech * 2 Prosentient Systems * 1 pusc.it * 4 unidentified * 1 veron.ch We also especially thank the following individuals who tested patches for Koha 3.8.13. * 10 Jared Camins-Esakov * 1 David Cook * 23 Chris Cormack * 1 Srikanth Dhondi * 2 Jonathan Druart * 1 Nicole C. Engard * 2 Magnus Enger * 9 Katrin Fischer * 4 Kyle M Hall * 1 Mason James * 1 Bernardo Gonzalez Kriegel * 3 Owen Leonard * 2 Paul Poulain * 2 Marcel de Rooy * 3 Mathieu Saby * 1 Mirko Tietgen 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

conver mysql data into UTF8
by lankanatha 23 May '13

23 May '13

Hi, i have converted my mysql database into UTF8.after that my local language fonts are not readable.i had configured my.conf for utf8. cant revers into latin1.how can i fix this? Thanks. -- View this message in context: http://koha.1045719.n5.nabble.com/conver-mysql-data-into-UTF8-tp5755573.html Sent from the Koha-general mailing list archive at Nabble.com.

1 0

Re: [Koha] New SQL Report - Patron Permissions
by BRANNON, CHRISTOPHER 23 May '13

23 May '13

Cab, thanks for the comment on the SQL. I am glad to have a report that will help me keep an eye on permissions. FYI, I made a couple tweaks and added a second report that allows you to watch certain permissions (Permissions Check). While I was working on it, I found that the tools sub column wouldn't display all flags if most of them were turned on. Must be a limit in characters in each column. So I divided the tools column in two. I also found that the superlibrarian flag wasn't accurate when other flags were set. I fixed both issues in both SQL. ___________________________ Christopher Brannon IT Coordinator Coeur d'Alene Public Library 702 E Front Ave Coeur d'Alene, ID 83814 (208)769-2315 Ext. 456 cbrannon(a)cdalibrary.org www.cdalibrary.org + peanut gallery commentary -- Whoa. Will have to spend some time learning from this lovely SQL ... Cheers, Cab Vinton Sanbornton PL Sanbornton, NH

1 0

New SQL Report - Patron Permissions
by Cab Vinton 22 May '13

22 May '13

+ peanut gallery commentary -- Whoa. Will have to spend some time learning from this lovely SQL ... Cheers, Cab Vinton Sanbornton PL Sanbornton, NH Patron Permissions Developer: Christopher Brannon Module: Patrons Purpose: List patrons by library and type, and show what the status of all permissions. Status: Complete SELECT surname AS 'Last Name',firstname AS 'First Name',cardnumber AS 'Card Number',userid AS 'UserID',branchcode AS 'Library',Super AS 'superlibrarian',A AS 'circulate',SubA AS 'circulate subs',B AS 'catalogue',C AS 'parameters',SubC AS 'parameters subs',D AS 'borrowers',E AS 'permissions',F AS 'reserveforothers',SubF AS 'reserveforothers subs',G AS 'borrow',I AS 'editcatalogue',SubI AS 'editcatalogue subs',J AS 'updatecharges',K AS 'acquisition',SubK AS 'acquisition subs',L AS 'management',M AS 'tools',SubM AS 'tools subs',N AS 'editauthorities',O AS 'serials',SubO AS 'serials subs',P AS 'reports',SubP AS 'reports subs',Q AS 'staffaccess' FROM (SELECT b.surname,b.firstname,b.cardnumber,b.userid,b.branchcode,b.categorycode,@CHECK:=b.flags AS 'CheckQ',IF(@Check-131072>=0,@Q:="On",@Q:="Off") AS 'Q', IF(@Check-131072>=0,@CHECK:=@Check-131072,@CHECK) AS 'CheckP',IF(@Check-65536>=0,@P:="On",@P:="Off") AS 'P',(SELECT group_concat(up.code) FROM user_permissions up WHERE up.module_bit='16' AND borrowernumber=b.borrowernumber) AS SubP, IF(@Check-65536>=0,@CHECK:=@Check-65536,@CHECK) AS 'CheckO',IF(@Check-32768>=0,@O:="On",@O:="Off") AS 'O',(SELECT group_concat(up.code) FROM user_permissions up WHERE up.module_bit='15' AND borrowernumber=b.borrowernumber) AS SubO, IF(@Check-32768>=0,@CHECK:=@Check-32768,@CHECK) AS 'CheckN',IF(@Check-16384>=0,@N:="On",@N:="Off") AS 'N', IF(@Check-16384>=0,@CHECK:=@Check-16384,@CHECK) AS 'CheckM',IF(@Check-8192>=0,@M:="On",@M:="Off") AS 'M',(SELECT group_concat(up.code) FROM user_permissions up WHERE up.module_bit='13' AND borrowernumber=b.borrowernumber) AS SubM, IF(@Check-8192>=0,@CHECK:=@Check-8192,@CHECK) AS 'CheckL',IF(@Check-4096>=0,@L:="On",@L:="Off") AS 'L', IF(@Check-4096>=0,@CHECK:=@Check-4096,@CHECK) AS 'CheckK',IF(@Check-2048>=0,@K:="On",@K:="Off") AS 'K',(SELECT group_concat(up.code) FROM user_permissions up WHERE up.module_bit='11' AND borrowernumber=b.borrowernumber) AS SubK, IF(@Check-2048>=0,@CHECK:=@Check-2048,@CHECK) AS 'CheckJ',IF(@Check-1024>=0,@J:="On",@J:="Off") AS 'J', IF(@Check-1024>=0,@CHECK:=@Check-1024,@CHECK) AS 'CheckI',IF(@Check-512>=0,@I:="On",@I:="Off") AS 'I',(SELECT group_concat(up.code) FROM user_permissions up WHERE up.module_bit='9' AND borrowernumber=b.borrowernumber) AS SubI, IF(@Check-512>=0,@CHECK:=@Check-512,@CHECK) AS 'CheckH',IF(@Check-256>=0,@H:="On",@H:="Off") AS 'H', IF(@Check-256>=0,@CHECK:=@Check-256,@CHECK) AS 'CheckG',IF(@Check-128>=0,@G:="On",@G:="Off") AS 'G', IF(@Check-128>=0,@CHECK:=@Check-128,@CHECK) AS 'CheckF',IF(@Check-64>=0,@F:="On",@F:="Off") AS 'F',(SELECT group_concat(up.code) FROM user_permissions up WHERE up.module_bit='6' AND borrowernumber=b.borrowernumber) AS SubF, IF(@Check-64>=0,@CHECK:=@Check-64,@CHECK) AS 'CheckE',IF(@Check-32>=0,@E:="On",@E:="Off") AS 'E', IF(@Check-32>=0,@CHECK:=@Check-32,@CHECK) AS 'CheckD',IF(@Check-16>=0,@D:="On",@D:="Off") AS 'D', IF(@Check-16>=0,@CHECK:=@Check-16,@CHECK) AS 'CheckC',IF(@Check-8>=0,@C:="On",@C:="Off") AS 'C',(SELECT group_concat(up.code) FROM user_permissions up WHERE up.module_bit='3' AND borrowernumber=b.borrowernumber) AS SubC, IF(@Check-8>=0,@CHECK:=@Check-8,@CHECK) AS 'CheckB',IF(@Check-4>=0,@B:="On",@B:="Off") AS 'B', IF(@Check-4>=0,@CHECK:=@Check-4,@CHECK) AS 'CheckA',IF(@Check-2>=0,@A:="On",@A:="Off") AS 'A',(SELECT group_concat(up.code) FROM user_permissions up WHERE up.module_bit='1' AND borrowernumber=b.borrowernumber) AS SubA, IF(@Check-2>=0,@CHECK:=@Check-2,@CHECK) AS 'CheckSuper',IF(b.flags=1,"On","Off") AS "Super" FROM borrowers b LEFT JOIN categories USING (categorycode) WHERE b.branchcode=<<Accounts FOR|branches>> AND b.categorycode=<<Account type|categorycode>>) AS MainFlags ORDER BY surname, firstname ASC

1 0

sending mail using google server and postfix
by Yvonne Wambui 22 May '13

22 May '13

i have stuck on this for a while. postfix is able to send mail but koha does not. i have configure koha to send mail. can there be another underlying problem?

2 1

KohaCon 13 IRC Meeting May 23 22 UTC
by Keener, Nancy 22 May '13

22 May '13

I will be reporting the latest on preparations for KohaCon 13, and getting your feedback and suggestions. Meeting time is 22 UTC on Thursday May 23. http://koha-community.org/get-involved/irc Get on the IRC http://www.timeanddate.com/worldclock/fixedtime.html?msg=IRC+Planning+Meeti… UTC converter Nancy Keener Systems Librarian I.T.O.S.C. Chair KohaCon 13 Chair Washoe County Library System Reno, Nevada 775 327-8347 nkeener(a)washoecounty.us

1 0

Re: [Koha] Live DVD (Was: Master-password (katikoan) and Live-DVD
by Vimal Kumar V. 22 May '13

22 May '13

Dear Friends, We can leave unhealthy arguments on Live DVD. We can submit the Official Live DVD to users, its their freedom to use for what purpose. They have freedom to accept or reject it. I strongly believe that, Live DVD can provide an opportunity to try Koha for newbies. Please forgive me if my words hurt anyone. I finished Koha 3.12 Live DVD making. I have still doubt where I host this to make available to Koha users. Nobody from developing team given an answer. Regards, -- Vimal Kumar V. Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.info Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

3 2

Koha & Crystal Reports
by Iming Chan 22 May '13

22 May '13

Dear all, As we are planning to migrate from a commercial LMS to Koha, I am wondering whether anyone has used Crystal Reports to generate reports using Koha data? Regards, Iming Melbourne, Australia -- View this message in context: http://koha.1045719.n5.nabble.com/Koha-Crystal-Reports-tp5755459.html Sent from the Koha-general mailing list archive at Nabble.com.

2 1