[Koha] Sitemap

2020-08-19 Thread Victor Barroso Oliveira
Good Morning, In which koha folder should I insert the sitemap.xml? I inserted in the folder / usr / share / koha / opac / htdocs more when I type https: //meusite/sitemap.xml the sitemap.xml code is not displayed What is the correct procedure? Thank you, Victor

Re: [Koha] SQL help

2020-08-19 Thread Indranil Das Gupta
You didn't mention your koha version. That's kinda necessary info if you are trying to extract from marcxml -indranil On Wed, 19 Aug, 2020, 7:42 pm Patricia Dowling, < patricia.dowl...@oireachtas.ie> wrote: > > I wonder if anyone in the community can steer me on this basic SQL query? > I am a ve

Re: [Koha] SQL help

2020-08-19 Thread Ian Bays
Hi Patricia. The three tables are often joined using biblionumber and this might get something close to what you want: SELECT biblionumber, title, author, copyrightdate FROM biblio LEFT JOIN biblioitems USING (biblionumber) LEFT JOIN biblio_metadata USING (biblio

Re: [Koha] SQL help

2020-08-19 Thread Tomas Cohen Arazi
What Koha version are you using? The table and column names have changed a bit between versions. El mié., 19 ago. 2020 a las 11:13, Patricia Dowling (< patricia.dowl...@oireachtas.ie>) escribió: > > I wonder if anyone in the community can steer me on this basic SQL query? > I am a very novice SQL

Re: [Koha] SQL help

2020-08-19 Thread Tomas Cohen Arazi
So you want what Ian said: SELECT biblionumber FROM biblio_metadata WHERE ExtractValue(metadata, '//datafield[@tag="440"]/subfield[@code="a"]') LIKE '%Irish Office pamphlets%'; El mié., 19 ago. 2020 a las 12:20, Patricia Dowling (< patricia.dowl...@oireachtas.ie>) escribió: > Hi Tomas, > > It

[Koha] Error with koha-common : Depende: libmojolicious-plugin-openapi-perl pero no va a instalarse

2020-08-19 Thread Luis Moises Rojas
I had installed koha 19.11 before using the same procedure. I had installed these also sudo apt-get install cpanminus sudo apt install build-essential cpanm -i Mojolicious::Plugin::OpenAPI And perl. But these have this error. Any Help? -- *Luis Moisés Rojas P.*

[Koha] SQL help

2020-08-19 Thread Patricia Dowling
I wonder if anyone in the community can steer me on this basic SQL query? I am a very novice SQL user so apologies in advance! I want to get a list of bibnumbers for all records with a value of “Irish Office pamphlets” in the 440a tag (series) with title, author and publication date so that I

Re: [Koha] SQL help

2020-08-19 Thread Patricia Dowling
Hi Tomas, It’s 19.11.07 From: Tomas Cohen Arazi Sent: Wednesday 19 August 2020 16:19 To: Patricia Dowling Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] SQL help What Koha version are you using? The table and column names have changed a bit between versions. El mié., 19 ago. 2020 a las

Re: [Koha] Error with koha-common : Depende: libmojolicious-plugin-openapi-perl pero no va a instalarse

2020-08-19 Thread Mason James
On 20/08/20 5:10 am, Luis Moises Rojas wrote: I had installed koha 19.11 before using the same procedure. I had installed these also sudo apt-get install cpanminus sudo apt install build-essential cpanm -i Mojolicious::Plugin::OpenAPI And perl. But these have this error. Any Help? hi Luis

Re: [Koha] Error with koha-common : Depende: libmojolicious-plugin-openapi-perl pero no va a instalarse

2020-08-19 Thread Mason James
On 20/08/20 5:38 pm, Mason James wrote: On 20/08/20 5:10 am, Luis Moises Rojas wrote: I had installed koha 19.11 before using the same procedure. I had installed these also sudo apt-get install cpanminus sudo apt install build-essential cpanm -i Mojolicious::Plugin::OpenAPI And perl. But thes