[Koha] Rebuild Zebra cron job

hings I should check? Thanks! --Katelyn. Katelyn Browne High School Librarian & Technology Teacher Capital City Public Charter School 100 Peabody Street NW Washington, DC 20011 (202) 387-0309 x1745 kbro...@ccpcs.org http://www.ccpcs.org/library/ _

[Koha] MARC modification templates

the problem is with the P/usd issue and requires some regular expressions (which are not my expertise). If you are good at RegEx, or you have addressed a similar problem, can you make some suggestions? Thanks! --Katelyn. Katelyn Browne High School Librarian & Technology Teacher Capital City

Re: [Koha] ًQuestions about 952 Field

Yes, each physical item should have its own 952 with a unique barcode. Katelyn Browne High School Librarian & Technology Teacher Capital City Public Charter School 100 Peabody Street NW Washington, DC 20011 (202) 387-0309 x1745 kbro...@ccpcs.org http://www.ccpcs.org/library/ On Fri, May 29,

Re: [Koha] Advice on barcode replacement/central catalog

e you import. --Katelyn. Katelyn Browne High School Librarian & Technology Teacher Capital City Public Charter School 100 Peabody Street NW Washington, DC 20011 (202) 387-0309 x1745 kbro...@ccpcs.org http://www.ccpcs.org/library/ On Tue, Jun 2, 2015 at 1:11 PM, Mark Tompsett wrote: > Greet

Re: [Koha] Help with report on percentage of Circ

Hi Nicole, I think you just need to add AND s.type = 'issue' to the WHERE section of your query for x (e.g. right after ba.code = 'JUR'). That got the numbers looking right for my collection. --Katelyn. Katelyn Browne Middle/High School Librarian Capital City Publi

[Koha] Patron Info on Circ Screen

fied other patron screens, but not that sidebar.) Thanks, Katelyn. Katelyn Browne Middle/High School Librarian Capital City Public Charter School 100 Peabody Street NW Washington, DC 20011 (202) 387-0309 x1745 kbro...@ccpcs.org http://www.ccpcs.o

Re: [Koha] Development for 'On Demand' Printouts of Overdue Bills

2.itemnumber = fa.itemnumber) > '0.00' GROUP BY itemnumber ORDER BY borrowernumber) faa GROUP BY borrowernumber) fines USING (borrowernumber) WHERE p.city LIKE <> AND p.zipcode LIKE <> AND p.categorycode LIKE <> AND ((overdue.title IS NOT NULL)

Re: [Koha] Interesting report request

USING (biblionumber) WHERE date(issues.date_due) BETWEEN <> AND <> GROUP BY borrowernumber --Katelyn. Katelyn Browne Middle/High School Librarian Capital City Public Charter School 100 Peabody Street NW Washington, DC 20011 (202) 387-0309 x1745 kbro...@ccpcs.org http://www.ccpcs.org/li

Re: [Koha] Remove checked out status from marc records

952$q is the due date, and 952$s is the date last checked out--those are the subfields I would clear. (Disclaimer: I have not tried this and don't know for sure what will happen!) --Katelyn. Katelyn Browne Middle/High School Librarian Capital City Public Charter School 100 Peabody Stre

Re: [Koha] Report Help

type y's, just change the order: GROUP BY i.itype, biblionumber). --Katelyn. Katelyn Browne Middle/High School Librarian Capital City Public Charter School 100 Peabody Street NW Washington, DC 20011 (202) 387-0309 x1745 kbro...@ccpcs.org http://www.ccpcs.org/library/ On Fri, Apr 11, 2014

Re: [Koha] Empty shelves

biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) WHERE authorised_values.category LIKE 'loc' GROUP BY authorised_values.authorised_value HAVING COUNT(DISTINCT biblioitems.biblionumber)=0 --Katelyn. Katelyn Browne Middle/High School Librarian Capital City Public Charter Sch

Re: [Koha] Looking for a bit of report help

FROM (SELECT i.ccode, COUNT(DISTINCT itemnumber) AS 'issues' FROM statistics s JOIN items i USING (itemnumber) WHERE s.datetime BETWEEN <> AND <> AND s.type='issue' GROUP BY i.ccode) x LEFT JOIN (SELECT ccode, COUNT(itemnumber) AS 'itemc

[Koha] Inventory Workaround

ion to set datelastseen (952$r) in batch item modification. Does anyone have a suggestion for a workaround for the time being? Preferably something we can do through the staff interface, since I need to train other librarians to do this as well. We have version 3.14.4 right now. Thanks! Katelyn.

Re: [Koha] Inventory Workaround

ent weekend date for inventory so it's clear how the book was last seen. --Katelyn. Katelyn Browne Middle/High School Librarian Capital City Public Charter School 100 Peabody Street NW Washington, DC 20011 (202) 387-0309 x1745 kbro...@ccpcs.org http://www.ccpcs.org/library/ On Mon, Jun 2, 2014

Re: [Koha] report for items in transit

bt.datearrived IS NULL Katelyn Browne Middle/High School Librarian Capital City Public Charter School 100 Peabody Street NW Washington, DC 20011 (202) 387-0309 x1745 kbro...@ccpcs.org http://www.ccpcs.org/library/ On Tue, Jun 3, 2014 at 5:59 AM, vikram zadgaonkar < vikramczadgaon...@gmail

Re: [Koha] How to restrict patron permanently?

We created a patron category called GONE that has no privileges for anything and expires quickly. We move patrons into it when they graduate or leave the school mid-year. If they return for some reason, we move them back into the appropriate category. Katelyn Browne Middle/High School Librarian

Re: [Koha] Barcode population/import

a big deal. Katelyn Browne Middle/High School Librarian Capital City Public Charter School 100 Peabody Street NW Washington, DC 20011 (202) 387-0309 x1745 kbro...@ccpcs.org http://www.ccpcs.org/library/ On Sun, Jun 15, 2014 at 4:33 AM, tony.h wrote: > Greetings, > > Apparently, I

Re: [Koha] Report help- reading history

LIMIT 10) topten ON (topten.borrowernumber = statistics.borrowernumber) WHERE topten.name IS NOT NULL AND statistics.datetime BETWEEN <> AND <> AND statistics.type = "issue" ORDER BY topten.name ASC Katelyn Browne Middle/High School Librarian Capital City Public Charter School 100

Re: [Koha] Z39.50 server for children's books

Paul, I don't know about Christian books, but I have pretty good luck with the Madison (WI) Metropolitan Schools <http://irspy.indexdata.com/full.html?id=Z39.50%3A199.197.115.61%3A210%2FMain> for Scholastic paperbacks and other school trade editions. --Katelyn. Katelyn Browne