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


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  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  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 
>> 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 
>> > 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 
>> >> 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
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  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 
> 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 
> > 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 
> 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 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  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 
> 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  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
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 
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  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] 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  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


Re: [Koha] To publish Koha IN WEB

2015-04-14 Thread Indranil Das Gupta
Hi,

On Tue, Apr 14, 2015 at 8:14 PM, Nisreen Qabbani
 wrote:
> Hello
> My question
> Is it possible to get any  IP- VPS
>   To publish Koha
> I wish in free solutions or free computerize sites

If you google, there are quite a few free VPS offers. Look for ones
that offer at least 1 GB of RAM and OS template of Debian Wheezy 7,
also whether they offer any support.

The cheapest VPSes around typically run off OpenVZ, and a poorly
configured box could have its zebra indexing affected.

cheers

-- 
Indranil Das Gupta

Phone : +91-98300-20971
Blog: http://indradg.randomink.org/blog
IRC  : indradg on irc://irc.freenode.net
Twitter : indradg

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-
Please exchange editable Office documents only in ODF Format. No other
format is acceptable. Support Open Standards.

For a free editor supporting ODF, please visit LibreOffice -
http://www.documentfoundation.org
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


[Koha] Report help

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


[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] 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


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


[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'
   

*No results found!*

No results found for that in Mario Mgulunde Learning Resources Centre
catalog. [image: Subscribe to this search]


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


[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


Re: [Koha] CAS Authentication

2015-04-14 Thread Matthias Meusburger

Hi,

Set the DEBUG variable to 1 in C4/Auth_with_cas.pm, try to log in and 
look in the log files. You should see for what reason the login was 
rejected.



Le 13/04/2015 21:28, leaspag a écrit :

Hi!

Recently, we decided to use Koha at my University and
I'm trying to integrate our CAS auth server with Koha but
I keep getting this error "Sorry, CAS login failed".
CAS generates a valid ticket but Koha does not login.

In Koha's intranet, casServerUrl is OK and I add "http://"; at the beginning
of OPACBaseURL. Also the user that I am trying to login exists in Koha
database.

I updated the version of Koha to 3.18 but the error persists.

Do you know what could it be the problem?

Regards,
Leandro.



--
View this message in context: 
http://koha.1045719.n5.nabble.com/CAS-Authentication-tp5835379.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 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=search&searchfield=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


[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] Does Koha plan to add 550, 562, 775, 780, 785 fields to Serial record workform?

2015-04-14 Thread catarinafrc
I've tried restarting 3 times and it didn't change anything 

also i have no idea about memcached on the server.

Going to give an example:

I want the field 321 to be visible, but when I go to catalog a period it
doesn't appear:

 


so i tried to change it on the admin section


 


but after restarting and etc it still doesnt appear on the cataloguing
section





--
View this message in context: 
http://koha.1045719.n5.nabble.com/Does-Koha-plan-to-add-550-562-775-780-785-fields-to-Serial-record-workform-tp4776690p5835464.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


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  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