[Koha] Koha QA Sprint - Friday 17th April
Hi all, as Magnus already hinted on in his email about the GBSD, the QA team is going to have a 'QA Sprint' this Friday - April 17th. So even if the official GBSD is almost over, please keep signing off and fill our queue! Thanks! Katrin ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Does Koha plan to add 550, 562, 775, 780, 785 fields to Serial record workform?
On 14 April 2015 at 06:03, catarinafrc catar...@fundacao-rc.org wrote: I'm having trouble in making these fields visible... no matter what i do I can't seem to make them visible. Low-level, technical question: Are you using memcached on the server? At least for some versions of Koha memcached needs a restart before changes to the frameworks show up in the cataloguing interface. I have been bitten by this a couple of times and spent ages tracking it down... Best regards, Magnus ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] favicon
hello please i want to put favicon image in my website (koha ) but i failed to do so please help me regard regina ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] favicon
please i want to put favicon image in my website (koha ) There are two system preferences which allow you to specify custom favicons: IntranetFavicon (for the staff client) OpacFavicon (for the OPAC) Go to Administration - System preferences and search for favicon /cgi-bin/koha/admin/preferences.pl?op=searchsearchfield=favicon -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] CAS Authentication
Hi Matthias! Thanks for your reply! I did what you tell me and I am getting this error in the log [error] opac-user.pl: checkpw_cas at /usr/share/koha/lib/C4/Auth_with_cas.pm line 91. [error] opac-user.pl: Got ticket : ST-239771-la1xduqMYwVLNDQNamBk-cas at/usr/share/koha/lib/C4/Auth_with_cas.pm line 98. [error] opac-user.pl: Problem when validating ticket : ST-239771-la1xduqMYwVLNDQNamBk-cas at /usr/share/koha/lib/C4/Auth_with_cas.pm line 128. [error] opac-user.pl: Authen::CAS::Client::Response::Error: HTTP request failed: 500: Can't connect to cas.ufasta.edu.ar:8443 at /usr/share/koha/lib/C4/Auth_with_cas.pm line 129. [error] opac-user.pl: $VAR1 = 'Can\\'t connect to cas.ufasta.edu.ar:8443 I believe the issue is that is doing an HTTP request when It should be an HTTPS request, even though casServerUrl is set with https. Do you know how to solve this issue? -- View this message in context: http://koha.1045719.n5.nabble.com/CAS-Authentication-tp5835379p5835578.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Call for news: April Newsletter
Fellow Koha users ~ I'm collecting news for the April newsletter. Send anything noteworthy to: k o h a news AT gmail dot com News criteria: --- * News items can be of any length. * Anything and everything Koha. * Submit by the 28th. If you are working on an interesting project or development related to Koha, please let me know and I'll include it in the development section. -- Chad Roseburg Editor, Koha Newsletter ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report help
I think the problem is that return from ExtractValue returns only one item so the GROUP_CONCAT is only seeing one thing come in and doesn't add the separator: See this: http://stackoverflow.com/questions/10808149/mysql-use-extractvaluexml-value-values-to-get-all-multiple-values-split-on On Tue, Apr 14, 2015 at 11:05 AM, Nicole Engard neng...@gmail.com wrote: Hi all, I'm working on this report and I want there to be a BR between each distinct 650a - but for some reason it's not working. I worked on this in channel for a while and you can see the log here: http://irc.koha-community.org/koha/2015-04-14#i_1663170 Here's the report: Select b.biblionumber, GROUP_CONCAT(DISTINCT ExtractValue(m.marcxml, '//datafield[@tag=650]/subfield[@code=a]') SEPARATOR ' BR ') AS 'Subject',i.itype AS 'IType' FROM biblio b LEFT JOIN biblioitems m using (biblionumber) left join items i using (biblioitemnumber) WHERE i.location in ('ARCHIVES','ARCHSIZE','HISTORYMED','HISTMEDOVZ','HISTMEDREF','RAREBKROOM','RAREOVRSIZ') and i.itype != 'JOURNAL' and ExtractValue(m.marcxml, '//datafield[@tag=650]/subfield[@code=a]') is not null and ExtractValue(m.marcxml, '//datafield[@tag=650]/subfield[@code=a]') != '' group by i.biblionumber ORDER BY b.biblionumber Thanks in advance! Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Nick Clemens Quechee Wilder Libraries n...@quecheelibrary.org http://www.QuecheeLibrary.org Q (802) 295-1232 W (802) 295-6341 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] To publish Koha IN WEB
Hello My question Is it possible to get any IP- VPS To publish Koha I wish in free solutions or free computerize sites Thank you very much ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Favicon
i tried to put image in /var/www/favicon and direct the same but i failed * As it says in the description of those preferences, This should be a complete URL, starting with http://. The icon file must be placed somewhere it can be referred to by a full URL. If you're not sure where that is you could consult your system administrator. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report help
Hi Nicole Nick! I'm particularly interested with this report. What I did before was this: ExtractValue (marcxml,'//datafield[@tag=653]/subfield[@code=a][1]') as Keywords, ExtractValue (marcxml,'//datafield[@tag=653]/subfield[@code=a][2]') as Keywords, ExtractValue (marcxml,'//datafield[@tag=653]/subfield[@code=a][3]') as Keywords but the subjects/keywords are in different columns and I have arbitrarily put in up to 40 columns for this keywords. whatever report we arrive will be great and could be use by a greater number of Koha users. Cheers ya'll! :) -- View this message in context: http://koha.1045719.n5.nabble.com/Report-help-tp5835592p5835643.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Favicon
*thankx Owen* * i already used that option but i failed , the problem i don't where to put image and how to direct it , i have the same server, i tried to put image in /var/www/favicon and direct the same but i failed * ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] search with kw,wrdl
when someone search a book which is no available it give result of - Results of search for 'kw,wrdl: jamani' http://192.168.1.2/cgi-bin/koha/opac-search.pl?idx=q=jamani# *No results found!* No results found for that in Mario Mgulunde Learning Resources Centre catalog. [image: Subscribe to this search] http://192.168.1.2/cgi-bin/koha/opac-search.pl?idx=kwq=jamaniformat=rss2 in this case i want to remove kw,wrdl , and that icon at the catalog which show user to subscribe ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report help
Well this is awesome - thanks so much for giving me an option! On Tue, Apr 14, 2015 at 3:39 PM, Nick Clemens n...@quecheelibrary.org wrote: Yes to both. It's not a perfect workaround by far, but thought it was worth mentioning You could something like CONCAT_WS(' BR ',IFNULL(ExtractValue(m.marcxml,'//datafield[@tag=650][position()=1]/subfield[@code=a]',''),IFNULLExtractValue(m.marcxml,'//datafield[@tag=650][position()=2]/subfield[@code=a]'),'')) to keep out extra BRs I don't know of a way you can easily get around guessing on the number, that seems to require creating a function like in the stack overflow link. If someone does know how I would to know too ;-) On Tue, Apr 14, 2015 at 4:09 PM, Nicole Engard neng...@gmail.com wrote: Don't I have to guess at what the max number of subjects would be then? and then won't I have a bunch of BRs all over the place if there is only one subject? On Tue, Apr 14, 2015 at 2:02 PM, Nick Clemens n...@quecheelibrary.org wrote: You can also use the position marker in the xpath to pick an arbitrary number of subject headings: GROUP_CONCAT(DISTINCT ExtractValue(m.marcxml,'//datafield[@tag=650][position()=1]/subfield[@code=a]'),' BR ',ExtractValue(m.marcxml,'//datafield[@tag=650][position()=2]/subfield[@code=a]'),' BR ',ExtractValue(m.marcxml,'//datafield[@tag=650][position()=3]/subfield[@code=a]') SEPARATOR ' BR ') AS 'Subject' On Tue, Apr 14, 2015 at 1:17 PM, Nick Clemens n...@quecheelibrary.org wrote: I think the problem is that return from ExtractValue returns only one item so the GROUP_CONCAT is only seeing one thing come in and doesn't add the separator: See this: http://stackoverflow.com/questions/10808149/mysql-use-extractvaluexml-value-values-to-get-all-multiple-values-split-on On Tue, Apr 14, 2015 at 11:05 AM, Nicole Engard neng...@gmail.com wrote: Hi all, I'm working on this report and I want there to be a BR between each distinct 650a - but for some reason it's not working. I worked on this in channel for a while and you can see the log here: http://irc.koha-community.org/koha/2015-04-14#i_1663170 Here's the report: Select b.biblionumber, GROUP_CONCAT(DISTINCT ExtractValue(m.marcxml, '//datafield[@tag=650]/subfield[@code=a]') SEPARATOR ' BR ') AS 'Subject',i.itype AS 'IType' FROM biblio b LEFT JOIN biblioitems m using (biblionumber) left join items i using (biblioitemnumber) WHERE i.location in ('ARCHIVES','ARCHSIZE','HISTORYMED','HISTMEDOVZ','HISTMEDREF','RAREBKROOM','RAREOVRSIZ') and i.itype != 'JOURNAL' and ExtractValue(m.marcxml, '//datafield[@tag=650]/subfield[@code=a]') is not null and ExtractValue(m.marcxml, '//datafield[@tag=650]/subfield[@code=a]') != '' group by i.biblionumber ORDER BY b.biblionumber Thanks in advance! Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Nick Clemens Quechee Wilder Libraries n...@quecheelibrary.org http://www.QuecheeLibrary.org Q (802) 295-1232 W (802) 295-6341 -- Nick Clemens Quechee Wilder Libraries n...@quecheelibrary.org http://www.QuecheeLibrary.org Q (802) 295-1232 W (802) 295-6341 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Nick Clemens Quechee Wilder Libraries n...@quecheelibrary.org http://www.QuecheeLibrary.org Q (802) 295-1232 W (802) 295-6341 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report help
You can also use the position marker in the xpath to pick an arbitrary number of subject headings: GROUP_CONCAT(DISTINCT ExtractValue(m.marcxml,'//datafield[@tag=650][position()=1]/subfield[@code=a]'),' BR ',ExtractValue(m.marcxml,'//datafield[@tag=650][position()=2]/subfield[@code=a]'),' BR ',ExtractValue(m.marcxml,'//datafield[@tag=650][position()=3]/subfield[@code=a]') SEPARATOR ' BR ') AS 'Subject' On Tue, Apr 14, 2015 at 1:17 PM, Nick Clemens n...@quecheelibrary.org wrote: I think the problem is that return from ExtractValue returns only one item so the GROUP_CONCAT is only seeing one thing come in and doesn't add the separator: See this: http://stackoverflow.com/questions/10808149/mysql-use-extractvaluexml-value-values-to-get-all-multiple-values-split-on On Tue, Apr 14, 2015 at 11:05 AM, Nicole Engard neng...@gmail.com wrote: Hi all, I'm working on this report and I want there to be a BR between each distinct 650a - but for some reason it's not working. I worked on this in channel for a while and you can see the log here: http://irc.koha-community.org/koha/2015-04-14#i_1663170 Here's the report: Select b.biblionumber, GROUP_CONCAT(DISTINCT ExtractValue(m.marcxml, '//datafield[@tag=650]/subfield[@code=a]') SEPARATOR ' BR ') AS 'Subject',i.itype AS 'IType' FROM biblio b LEFT JOIN biblioitems m using (biblionumber) left join items i using (biblioitemnumber) WHERE i.location in ('ARCHIVES','ARCHSIZE','HISTORYMED','HISTMEDOVZ','HISTMEDREF','RAREBKROOM','RAREOVRSIZ') and i.itype != 'JOURNAL' and ExtractValue(m.marcxml, '//datafield[@tag=650]/subfield[@code=a]') is not null and ExtractValue(m.marcxml, '//datafield[@tag=650]/subfield[@code=a]') != '' group by i.biblionumber ORDER BY b.biblionumber Thanks in advance! Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Nick Clemens Quechee Wilder Libraries n...@quecheelibrary.org http://www.QuecheeLibrary.org Q (802) 295-1232 W (802) 295-6341 -- Nick Clemens Quechee Wilder Libraries n...@quecheelibrary.org http://www.QuecheeLibrary.org Q (802) 295-1232 W (802) 295-6341 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report help
Don't I have to guess at what the max number of subjects would be then? and then won't I have a bunch of BRs all over the place if there is only one subject? On Tue, Apr 14, 2015 at 2:02 PM, Nick Clemens n...@quecheelibrary.org wrote: You can also use the position marker in the xpath to pick an arbitrary number of subject headings: GROUP_CONCAT(DISTINCT ExtractValue(m.marcxml,'//datafield[@tag=650][position()=1]/subfield[@code=a]'),' BR ',ExtractValue(m.marcxml,'//datafield[@tag=650][position()=2]/subfield[@code=a]'),' BR ',ExtractValue(m.marcxml,'//datafield[@tag=650][position()=3]/subfield[@code=a]') SEPARATOR ' BR ') AS 'Subject' On Tue, Apr 14, 2015 at 1:17 PM, Nick Clemens n...@quecheelibrary.org wrote: I think the problem is that return from ExtractValue returns only one item so the GROUP_CONCAT is only seeing one thing come in and doesn't add the separator: See this: http://stackoverflow.com/questions/10808149/mysql-use-extractvaluexml-value-values-to-get-all-multiple-values-split-on On Tue, Apr 14, 2015 at 11:05 AM, Nicole Engard neng...@gmail.com wrote: Hi all, I'm working on this report and I want there to be a BR between each distinct 650a - but for some reason it's not working. I worked on this in channel for a while and you can see the log here: http://irc.koha-community.org/koha/2015-04-14#i_1663170 Here's the report: Select b.biblionumber, GROUP_CONCAT(DISTINCT ExtractValue(m.marcxml, '//datafield[@tag=650]/subfield[@code=a]') SEPARATOR ' BR ') AS 'Subject',i.itype AS 'IType' FROM biblio b LEFT JOIN biblioitems m using (biblionumber) left join items i using (biblioitemnumber) WHERE i.location in ('ARCHIVES','ARCHSIZE','HISTORYMED','HISTMEDOVZ','HISTMEDREF','RAREBKROOM','RAREOVRSIZ') and i.itype != 'JOURNAL' and ExtractValue(m.marcxml, '//datafield[@tag=650]/subfield[@code=a]') is not null and ExtractValue(m.marcxml, '//datafield[@tag=650]/subfield[@code=a]') != '' group by i.biblionumber ORDER BY b.biblionumber Thanks in advance! Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Nick Clemens Quechee Wilder Libraries n...@quecheelibrary.org http://www.QuecheeLibrary.org Q (802) 295-1232 W (802) 295-6341 -- Nick Clemens Quechee Wilder Libraries n...@quecheelibrary.org http://www.QuecheeLibrary.org Q (802) 295-1232 W (802) 295-6341 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report help
Yes to both. It's not a perfect workaround by far, but thought it was worth mentioning You could something like CONCAT_WS(' BR ',IFNULL(ExtractValue(m.marcxml,'// datafield[@tag=650][position()=1]/subfield[@code=a]',''),IFNULL ExtractValue(m.marcxml,'//datafield[@tag=650][ position()=2]/subfield[@code=a]'),'')) to keep out extra BRs I don't know of a way you can easily get around guessing on the number, that seems to require creating a function like in the stack overflow link. If someone does know how I would to know too ;-) On Tue, Apr 14, 2015 at 4:09 PM, Nicole Engard neng...@gmail.com wrote: Don't I have to guess at what the max number of subjects would be then? and then won't I have a bunch of BRs all over the place if there is only one subject? On Tue, Apr 14, 2015 at 2:02 PM, Nick Clemens n...@quecheelibrary.org wrote: You can also use the position marker in the xpath to pick an arbitrary number of subject headings: GROUP_CONCAT(DISTINCT ExtractValue(m.marcxml,'//datafield[@tag=650][position()=1]/subfield[@code=a]'),' BR ',ExtractValue(m.marcxml,'//datafield[@tag=650][position()=2]/subfield[@code=a]'),' BR ',ExtractValue(m.marcxml,'//datafield[@tag=650][position()=3]/subfield[@code=a]') SEPARATOR ' BR ') AS 'Subject' On Tue, Apr 14, 2015 at 1:17 PM, Nick Clemens n...@quecheelibrary.org wrote: I think the problem is that return from ExtractValue returns only one item so the GROUP_CONCAT is only seeing one thing come in and doesn't add the separator: See this: http://stackoverflow.com/questions/10808149/mysql-use-extractvaluexml-value-values-to-get-all-multiple-values-split-on On Tue, Apr 14, 2015 at 11:05 AM, Nicole Engard neng...@gmail.com wrote: Hi all, I'm working on this report and I want there to be a BR between each distinct 650a - but for some reason it's not working. I worked on this in channel for a while and you can see the log here: http://irc.koha-community.org/koha/2015-04-14#i_1663170 Here's the report: Select b.biblionumber, GROUP_CONCAT(DISTINCT ExtractValue(m.marcxml, '//datafield[@tag=650]/subfield[@code=a]') SEPARATOR ' BR ') AS 'Subject',i.itype AS 'IType' FROM biblio b LEFT JOIN biblioitems m using (biblionumber) left join items i using (biblioitemnumber) WHERE i.location in ('ARCHIVES','ARCHSIZE','HISTORYMED','HISTMEDOVZ','HISTMEDREF','RAREBKROOM','RAREOVRSIZ') and i.itype != 'JOURNAL' and ExtractValue(m.marcxml, '//datafield[@tag=650]/subfield[@code=a]') is not null and ExtractValue(m.marcxml, '//datafield[@tag=650]/subfield[@code=a]') != '' group by i.biblionumber ORDER BY b.biblionumber Thanks in advance! Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Nick Clemens Quechee Wilder Libraries n...@quecheelibrary.org http://www.QuecheeLibrary.org Q (802) 295-1232 W (802) 295-6341 -- Nick Clemens Quechee Wilder Libraries n...@quecheelibrary.org http://www.QuecheeLibrary.org Q (802) 295-1232 W (802) 295-6341 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Nick Clemens Quechee Wilder Libraries n...@quecheelibrary.org http://www.QuecheeLibrary.org Q (802) 295-1232 W (802) 295-6341 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha