Re: [Koha] Extracting list of biblios with . in the subject

2019-03-22 Thread Barton Chittenden
Here's how to do it using SQL: SELECT ExtractValue( metadata, '//datafield[@tag=650]/subfield[@code="a"]' ) as 'Topical term', biblionumber, title FROM biblio INNER JOIN biblio_metadata using (biblionumber) WHERE ExtractValue( metadata, '//datafield[@tag=650]/subfield[@code="a"

Re: [Koha] Extracting list of biblios with . in the subject

2019-03-22 Thread Hernandez, Heather
Hi, Tami-- Ah--ours displays exactly the same way--we don't have records with the subject "Lampreys," but we do have whales: - Topics - Whales - Whales.

Re: [Koha] [EXTERNAL] Extracting list of biblios with . in the subject

2019-03-22 Thread Hernandez, Heather
Hi, Tami-- Your example is a properly formed Library of Congress topical heading in a 650 field, which is supposed to end with a mark of punctuation or a closing parenthesis--and the ending mark of punctuation is usually a period/full stop. Are you trying to identify records with such properly fo

[Koha] Extracting list of biblios with . in the subject

2019-03-22 Thread Tami Wilkerson
Hello, I would like to create a report for a list of bibliographic records that have a period in the 650 subfield a field. Example: a Topical term Fish tagging. Any ideas on how to do this? Thanks, Tami Tami Wilkerson, MLIS Library Program Lead/Librarian Columbia River Inter-Tribal F

Re: [Koha] Problem with upgrading Koha from 17.11 to 18.11

2019-03-22 Thread Daniel Owens
Oh, of course. Full output is below, but looking through the errors, I found two kinds: * "Loading failed for the

Re: [Koha] Problem with upgrading Koha from 17.11 to 18.11

2019-03-22 Thread Indranil Das Gupta
Keep the browser console on while you reload the page and see what errors show up. On Fri 22 Mar, 2019, 11:17 PM Daniel Owens, wrote: > Thank you Indranil and Beda for the suggestion to clear my browser > cache. I did clear the browser, but the page still has no styling. > > Any other ideas? >

Re: [Koha] Problem with upgrading Koha from 17.11 to 18.11

2019-03-22 Thread Daniel Owens
Thank you Indranil and Beda for the suggestion to clear my browser cache. I did clear the browser, but the page still has no styling. Any other ideas? Daniel On 3/22/19 10:40 AM, Indranil Das Gupta wrote: Hi Daniel, Did you do *the* one mandatory step after every major version upgrade - cl

Re: [Koha] Problem with upgrading Koha from 17.11 to 18.11

2019-03-22 Thread Indranil Das Gupta
Hi Daniel, Did you do *the* one mandatory step after every major version upgrade - clear your browser cache? Hope this helps Indranil Das Gupta L2C2 Technologies On Fri 22 Mar, 2019, 8:59 PM Daniel Owens, wrote: > I just upgraded from 17.11 to 18.11. Afterward, both the staff client > and OPAC

Re: [Koha] Problem with upgrading Koha from 17.11 to 18.11

2019-03-22 Thread Beda Szukics
Did you clear the browser history? That usually helps. Beda Am 22.03.2019 um 16:28 schrieb Daniel Owens: > I just upgraded from 17.11 to 18.11. Afterward, both the staff client > and OPAC display very basic HTML, with no styling. The staff client > login looks like this: > > >  Koha

[Koha] Problem with upgrading Koha from 17.11 to 18.11

2019-03-22 Thread Daniel Owens
I just upgraded from 17.11 to 18.11. Afterward, both the staff client and OPAC display very basic HTML, with no styling. The staff client login looks like this: Koha Username: Password: Library: * English * Tiếng Việt

[Koha] KohaCon19 Update

2019-03-22 Thread Charles Quain
Dear Koha Community On behalf of the organising group, I am sending another update on the preparations for KohaCon19. The schedule for talks and workshops is now full. We are delighted to announce that Ken Chad will be our Keynote speaker giving a paper titled “Community, openness and directions