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

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 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,'//datafiel

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

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 wrote: > You can also use the position marker in the xpath to pick an arbitrary > number of s

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"]'),'

[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

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

Re: [Koha] To publish Koha IN WEB

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

[Koha] Report help

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

[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/listi

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

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 y

[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' *No results found!* No results found for that in Mario Mgulunde Learning Resources Centre catalog. [image: Subscribe

[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://koh

Re: [Koha] CAS Authentication

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 serv

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

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

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:

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