[Koha] Koha QA Sprint - Friday 17th April

2015-04-14 Thread Katrin Fischer
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?

2015-04-14 Thread Magnus Enger
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

2015-04-14 Thread regina kivuyo
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

2015-04-14 Thread Owen Leonard
  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

2015-04-14 Thread leaspag
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

2015-04-14 Thread kohanews

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

2015-04-14 Thread Nick Clemens
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

2015-04-14 Thread Nisreen Qabbani
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

2015-04-14 Thread Owen Leonard
 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

2015-04-14 Thread schnydszch
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

2015-04-14 Thread regina kivuyo
*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

2015-04-14 Thread regina kivuyo
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

2015-04-14 Thread Nicole Engard
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

2015-04-14 Thread Nick Clemens
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

2015-04-14 Thread Nicole Engard
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

2015-04-14 Thread Nick Clemens
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