[Koha] issues with late orders mail

Good morning We are facing a problem sending mails to late orders Koha 3.22 .7 Postfix working fine for all other mail services (circulation, basket...etc) The issue is that when we try to claim to a vendor for late orders, we get a success message from koha 'email has been sent' , but no

Re: [Koha] Nature of Contents

Sorry. I did not mean to add hyperlinks in "How to get there:". I should simply have been >> How to get there: Home › Administration › MARC frameworks › BK-A framework structure › Tag 008 subfield structure › Edit subfields constraints Thank you. Irma On 6 October 2017 at 14:17, Irma

[Koha] Nature of Contents

Hi. How to make "Nature of Contents" field in 008 mandatory? Thanks. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Nature of Contents

Hello Ma Interesting question. It is not possible to make particular Character Positions in the marc21 plugin Mandatory. It is sourced from here: http://www.loc.gov/marc/bibliographic/bd008.html Only the 008 field can be made Mandatory. How to get there: Home

Re: [Koha] Help needed with SQL report

Hi Elaine, how about this: SELECT biblioitems.biblionumber, biblio.title, ExtractValue(biblioitems.marcxml, '//datafield[@tag="260"]/subfield[@code="c"]') AS text FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on

[Koha] Help needed with SQL report

I need a report that gives bib number, title and 260$c from a set of records within a range of biblio numbers. This is what the wizard gives me: SELECT biblioitems.biblionumber,biblio.title,biblio.copyrightdate FROM items LEFT JOIN biblioitems on

[Koha] Slow report for periodicals ranked by circ

Hi, All -- The following report takes several minutes to run, which leads to me the sad probability that my SQL skillz are ... weak: SELECT b.title, count(s.datetime) AS circs FROM statistics s JOIN ( SELECT itemnumber, biblionumber, homebranch, itype FROM deleteditems UNION SELECT

Re: [Koha] Help needed with SQL report

It gives the error message: *The following error was encountered:* The database returned the following error: Unknown column 'biblioitems.marcxml' in 'field list' Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road,

Re: [Koha] Help needed with SQL report

Since 17196 (17.05) you need to join on biblio_metadata Try the following query: SELECT biblioitems.biblionumber, biblio.title, biblio.copyrightdate, ExtractValue(m.metadata, '//datafield[@tag="260"]/subfield[@code="c"]') AS text FROM items LEFT JOIN biblioitems on

Re: [Koha] Help needed with SQL report

Elaine, In 17.05, biblioitems.marcxml was moved to biblio_metadata.metadata. --Barton On Thu, Oct 5, 2017 at 10:43 AM, Elaine Bradtke wrote: > It gives the error message: > *The following error was encountered:* > The database returned the following error: > Unknown column