[Koha] Call for News: July 2018 Newsletter

2018-07-13 Thread kohanews

I'm collecting news for the July newsletter. Send anything noteworthy to:

k o h a news AT gmail dot com

News criteria:
---

** For events **:
   - Please include dates for past events. If I can't find dates I may 
not add it.
   - Announcements for future events with dates T.B.A. are fine ...Eg., 
Kohacon

   - For past events ,  one month back is the cut-off  .

* News items can be of any length.
* Images are fine
* Anything and everything Koha.
* Submit by the 26th of the month.

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.

Thank you!

--
Chad Roseburg
Editor, Koha Community Newsletter

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Report help needed

2018-07-13 Thread Paul Hoffman
On Fri, Jul 13, 2018 at 10:06:56AM -0700, Elaine Bradtke wrote:
> This report finds Authors not linked to authorities.  But it only lists
> their names (some of them are quite prolific, and sometimes it's only one
> biblio that needs checking).
> How can I make the following give the biblio number as well as the name?
> 
> SELECT DISTINCT heading FROM (
>  SELECT ExtractValue(metadata,
> '//datafield[@tag="100"]/subfield[@code="a"]') AS heading
>  FROM biblio_metadata
>  WHERE
>   length(ExtractValue(metadata,
> '//datafield[@tag="100"]/subfield[@code="a"]')) != 0 AND
>   length(ExtractValue(metadata,
> '//datafield[@tag="100"]/subfield[@code="9"]')) = 0
> UNION
> [...]

I assume that you can just add biblionumber to the output everywhere 
that a heading appears, something like this (untested!):

SELECT DISTINCT biblionumber, heading FROM (
SELECT biblionumber, ExtractValue(metadata, 
'//datafield[@tag="100"]/subfield[@code="a"]') AS heading
FROM   biblio_metadata
WHERE  length(ExtractValue(metadata, 
'//datafield[@tag="100"]/subfield[@code="a"]')) != 0
ANDlength(ExtractValue(metadata, 
'//datafield[@tag="100"]/subfield[@code="9"]')) = 0
UNION
[...]

Paul.

-- 
Paul Hoffman 
Software Manager
Fenway Libraries Online
c/o Wentworth Institute of Technology
550 Huntington Ave.
Boston, MA 02115
(617) 442-2384 (FLO main number)
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] adding field to Marc Framework

2018-07-13 Thread Elaine Bradtke
​From my own experience, it's better to set the fields to hidden rather
than delete them entirely.​

Elaine Bradtke
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
---
"Writing about music is like dancing about architecture"
--Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)

On Sun, Jul 8, 2018 at 11:18 PM, Michael Kuhn  wrote:

> Hi Rajesh
>
> > I am currently using Koha 18.0x. In my own Marc Framework, I deleted
> > field 700. Now I want to add this to existing frame work. I am not
> > able to do.
> > kindly help me
>
> Go to Koha menu "Administration > MARC bibliographic framework", select
> the "Action" button of your own framework, choose "MARC structure" and
> click on "+New tag".
>
> Everything about frameworks you will find in the fine Koha manual at
> https://koha-community.org/manual/18.05/en/html/administrati
> on.html#marc-bibliographic-frameworks
>
> Hope this helps.
>
> Best wishes: Michael
> --
> Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
> Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
> T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


[Koha] Report help needed

2018-07-13 Thread Elaine Bradtke
This report finds Authors not linked to authorities.  But it only lists
their names (some of them are quite prolific, and sometimes it's only one
biblio that needs checking).
How can I make the following give the biblio number as well as the name?

SELECT DISTINCT heading FROM (
 SELECT ExtractValue(metadata,
'//datafield[@tag="100"]/subfield[@code="a"]') AS heading
 FROM biblio_metadata
 WHERE
  length(ExtractValue(metadata,
'//datafield[@tag="100"]/subfield[@code="a"]')) != 0 AND
  length(ExtractValue(metadata,
'//datafield[@tag="100"]/subfield[@code="9"]')) = 0
UNION
 SELECT ExtractValue(metadata,
'//datafield[@tag="110"]/subfield[@code="a"]') AS heading
 FROM biblio_metadata
 WHERE
  length(ExtractValue(metadata,
'//datafield[@tag="110"]/subfield[@code="a"]')) != 0 AND
  length(ExtractValue(metadata,
'//datafield[@tag="110"]/subfield[@code="9"]')) = 0
UNION
 SELECT ExtractValue(metadata,
'//datafield[@tag="111"]/subfield[@code="a"]') AS heading
 FROM biblio_metadata
 WHERE
  length(ExtractValue(metadata,
'//datafield[@tag="111"]/subfield[@code="a"]')) != 0 AND
  length(ExtractValue(metadata,
'//datafield[@tag="111"]/subfield[@code="9"]')) = 0
UNION
 SELECT ExtractValue(metadata,
'//datafield[@tag="130"]/subfield[@code="a"]') AS heading
 FROM biblio_metadata
 WHERE
  length(ExtractValue(metadata,
'//datafield[@tag="130"]/subfield[@code="a"]')) != 0 AND
  length(ExtractValue(metadata,
'//datafield[@tag="130"]/subfield[@code="9"]')) = 0
) AS heads
ORDER BY heading

Thanks in advance!

Elaine Bradtke
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
---
"Writing about music is like dancing about architecture"
--Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Chrome vs. Firefox in recent versions of Koha / Firefox

2018-07-13 Thread Christopher Davis
You see, Mozilla and Google just have very different business models and 
make their money accordingly.


FWIW,

Christopher Davis, MLS
Systems & E-Services Librarian
Uintah County Library
cgda...@uintah.utah.gov
(435) 789-0091 ext. 261
uintahlibrary.org 
basinlibraries.org 
facebook.com/uintahcountylibrary 
instagram.com/uintahcountylibrary 


On 07/13/2018 02:23 AM, Narcis Garcia wrote:

This Firefox behaviour can be reported to Mozilla's bug tracker.

Google Chrome's focus is to keep people out of control from their
personal data leakage. If someone likes this application GUI, I
recommend Chromium or Iridium even better.
https://en.wikipedia.org/wiki/Chromium_(web_browser)
iridiumbrowser.de


El 12/07/18 a les 19:44, Nick Clemens ha escrit:

Hi All,

I was testing today in different browsers and noted that Chrome seems to be
loading much faster than Firefox.

In looking at the logs, I see that Chrome makes about 3 requests per page,
while Firefox is making 20+ calls, mostly for .css and .js files. It seems
that Firefox has changed it's caching strategy and more files are being
reloaded.

Has anyone else noticed this or tested using Chrome?

-Nick


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Chrome vs. Firefox in recent versions of Koha / Firefox

2018-07-13 Thread Narcis Garcia
This Firefox behaviour can be reported to Mozilla's bug tracker.

Google Chrome's focus is to keep people out of control from their
personal data leakage. If someone likes this application GUI, I
recommend Chromium or Iridium even better.
https://en.wikipedia.org/wiki/Chromium_(web_browser)
iridiumbrowser.de


El 12/07/18 a les 19:44, Nick Clemens ha escrit:
> Hi All,
> 
> I was testing today in different browsers and noted that Chrome seems to be
> loading much faster than Firefox.
> 
> In looking at the logs, I see that Chrome makes about 3 requests per page,
> while Firefox is making 20+ calls, mostly for .css and .js files. It seems
> that Firefox has changed it's caching strategy and more files are being
> reloaded.
> 
> Has anyone else noticed this or tested using Chrome?
> 
> -Nick
> 
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha