[Koha] How to get the subjects column in Guided reports wizard

2016-02-10 Thread venkat narayana Thandu
Dear Professionals, How to get the subject headings column in ''Guided reports wizard'' to get the report total stock list along with subjects. Thanks & With Regards, Venkata Narayana T Hyderabad. ___ Koha mailing list http://koha-community.org Koha@li

[Koha] Reporting biblios with no items

2016-02-10 Thread Beda Szukics
Hello The following report: SELECT biblio.biblionumber, biblio.title FROM biblio LEFT JOIN items ON biblio.biblionumber = items.biblionumber WHERE items.itemnumber IS NULL shows all the biblios with no item. Is there a possibility to expand it so it doesn't show all the _analytic_ records

[Koha] Error framework test

2016-02-10 Thread João Pinto
Hi Everyone, Is there any possibility to see where are the errors when we use framework test. In this case over the tag, or subfields, so we can correct them. The errors are: itemnum · The field itemnum MUST be mapped · The corresponding subfield MUST be in with -1 (ignore) tab

[Koha] Last minute link to Koha-US monthly meeting

2016-02-10 Thread Christopher Davis
Dear Colleagues, This is a last minute invitation to attend today's monthly Koha-US meeting to reveal the location of the 2016 Koha-US annual meeting (just in case you can't make it, here are the results: ), held at 11:00 am Central Time (right no

[Koha] Missing link on Link to meeting scheduled for this morning

2016-02-10 Thread Christopher Davis
Dear Colleagues, This is a last minute invitation to attend today's monthly Koha-US meeting ( to reveal the location of the 2016 Koha-US annual meeting (just in case you can't make it, here are the results:(), he

[Koha] Biblioitems table

2016-02-10 Thread Shell, Lezlie
We just imported our collection into our new Koha installation. It went really smoothly. Based on the schema, though, I was expecting to find a sortable call number in biblioitems.cn_sort. Since we don't circulate any materials, I didn't create any items. Is there something I needed to set o

[Koha] FW: Biblioitems table

2016-02-10 Thread Shell, Lezlie
Yet another instance of retroactive clarity. I am looking at the biblioitems table in Administration/Koha to MARC mapping. I did not have a value 942|6 in my 942 import field. If I had populated 942$6 with my 050 tag contents, would Koha have created the sortable version and populated biblioi

Re: [Koha] FW: Biblioitems table

2016-02-10 Thread Joy Nelson
Lezlie- I generally don't ever populate the biblioitems callnumber fields. I'm wondering also if those fields are holdovers from a previous version of Koha. The itemcallnumber, classification and cn_sort values I work with are all in the items table. If the biblioitems.cn_sort value is to be pop