Re: [Koha] Records visible to those who login

I looked at those settings but didn't see where logged in status could be used as the controlling factor. What am I missing? Cab Vinton Plaistow Public Library Plaistow NH On Wed, Oct 27, 2021, 11:56 Tomas Cohen Arazi wrote: > You can do it! > > You could use a combination of O

Re: [Koha] [EXTERNAL] Re: Reports timing out, prevents access to web interfaces

> > Tasha Bales > Enterprise Services > http://isesi.web.boeing.com/ > > -Original Message- > From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Cab Vinton > Sent: Thursday, October 7, 2021 03:49 > To: koha > Subject: [EXTERNAL] Re: [Koha] Reports timi

Re: [Koha] Reports timing out, prevents access to web interfaces

the report to see if there are ways to achieve the same results more efficiently. In our case, this means seeking help from folks who are far more experienced with SQL than we are. Best of luck! Cab Vinton, Director Plaistow Public Library Plaistow, NH

Re: [Koha] How to make the Price field visible in the OPAC normal view.

the road? This type of operation is trivial using a tool such as MarcEdit, though. Exporting & re-importing is obviously less time-consuming w/ smaller catalogs. All best, Cab Vinton, Director Plaistow Public Library Plaistow, NH ___ Koha

Re: [Koha] Batch edit to control fields?

lways blank (for books, at least). But I think we're on the right track now. Many thanks again. Cab Vinton, Director Plaistow Public Library On Tue, Aug 24, 2021 at 1:20 PM Caroline Cyr-La-Rose wrote: > > There is a particularity with substring and control fields in SQL. > > The dif

Re: [Koha] Batch edit to control fields?

nt is pulling spaces rather than the actual values. Would be grateful for any suggestions on why the SUBSTRING & ExtractValue statements don't appear to be working well together. All best, Cab Vinton, Director Plaistow Public Library SELECT SUBSTRING(ExtractValue(metadata,'//controlfie

[Koha] Batch edit to control fields?

dification template, but it seems to be expecting standard fields & subfields (i.e., it won't accept a 2 digit number to represent a position). We can always export to MarcEdit, but if we can do this from within Koha, that would be great. All best, Cab Vinton, Director Plaistow Public L

Re: [Koha] Question on magazine local images

Believe the AllowMultipleCovers system preference does what you want, Manos. Full instructions here: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26145 All best, Cab Vinton, Director Plaistow Public Library On Sun, Jul 4, 2021 at 1:04 PM Manos PETRIDIS wrote: > > I unde

Re: [Koha] Wrong order wehen sorting public list by copyright year

this manually every time the mapping table is changed? Something we would need to check w/ our support vendor on? All best, Cab Vinton, Director Plaistow Public Library Plaistow, NH ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz

Re: [Koha] Report help needed - lost items

suspect SQL is sensitive to the order of these statements, but there are probably other issues as well. Hopefully someone else w/ better report-writing chops than me can take it from there. Or if you found something that works, Elaine, please share w/ the list :-) All best, Cab Vinton, Director Plaistow

Re: [Koha] Alerts for every Nth check out

e of interest to us. Best of luck, Cab Vinton, Director Plaistow Public Library Plaistow, NH On Tue, Sep 3, 2019 at 1:27 AM sriharsha wrote: > > Hi, > > I am trying to set up Koha for local kid's library in my town. I would like > to know if it is possible for Koha to alert staff m

Re: [Koha] Top 10 Circulating Books

sue','renew') AND i.homebranch=<> GROUP BY b.biblionumber ORDER BY circs DESC LIMIT 10 All best, Cab Vinton, Director Plaistow Public Library Plaistow, NH On Fri, Aug 30, 2019 at 4:26 AM Ma. Victoria H. Silva-Manuel wrote: > > HI. > > I got the SQL report below to

Re: [Koha] [EXTERNAL] Uploading local cover images

Many thanks, Heather! x pixels is a pretty big image :-) In looking at the covers in our catalog, they seem to be in the 300 x 400 pixel range. We could do some experiments, of course, but it would be great to have more official guidance. Thanks again! Cab Vinton Plaistow Public

[Koha] Uploading local cover images

he manual? (https://koha-community.org/manual/18.11/en/html/tools.html#upload-local-cover-image-label) Many thanks in advance! Cab Vinton, Director Plaistow Public Library Plaistow, NH ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co

Re: [Koha] Report for items held by 2 out of 3 branches

Hi, All -- Think the version below should do what we're looking for. (Thank you, Barton!) All best, Cab Vinton SELECT b.biblionumber, SUBSTRING_INDEX(m.isbn, ' ', 1) AS isbn, b.title, i.homebranch, i.itemcallnumber FROM items i LEFT JOIN bibl

Re: [Koha] Report for items held by 2 out of 3 branches

t 11:11 AM Barton Chittenden wrote: > > you could add > > count(distinct homebranch) > 1 > > to your HAVING statement > > On Fri, Feb 22, 2019 at 9:03 AM Cab Vinton wrote: >> >> Hi, All -- >> >> We have a report (see below) that generates a rand

[Koha] Report for items held by 2 out of 3 branches

;, so efficient code is an important factor. Anyone have suggestions on how best to write this report? Many thanks in advance, Cab Vinton, Director Plaistow Public Library Plaistow, NH https://catalog.southernnh.bywatersolutions.com SELECT b.biblionumber, SUBSTRING_INDEX(m.isbn, ' ', 1) AS

Re: [Koha] OPAC Search too slow in Koha 18.05.05

ty in 18.05? We just upgraded to 18.05. Thoughts on staying w/ Zebra vs. switching over to ES? Many thanks in advance, Cab Vinton Plaistow Public Library Plaistow, NH On Thu, Nov 8, 2018 at 6:48 AM Barton Chittenden wrote: > > Actually, if you have Zebra facets enabled, turn them *off*. I b

Re: [Koha] Duplicate ISBN report modification

On Thu, Aug 16, 2018 at 4:47 PM, Barton Chittenden wrote: > Cab, would you mind adding that to the 'Catalog/Bibliographic Reports' > section of the Koha wiki? Done! -- https://wiki.koha-community.org/wiki/SQL_Reports_Library#Duplicate_titles_.28using_title_and_ISBN.29.2C_multi-branch_version Ca

Re: [Koha] Duplicate ISBN report modification

Many thanks, Barton. I think that may have done it! I added an ISBN check (i.isbn not null or empty string) as otherwise the report was pulling many false duplicates. Will have some happy catalogers now :-) All best, Cab Vinton Plaistow Public Library On Thu, Aug 16, 2018 at 9:48 AM, Barton

Re: [Koha] Duplicate ISBN report modification

ranch owns more than 1 copy of a particular item :-( Figured a subquery would work as a way to first restrict the results to records where Branch A owns at least one copy, & then to perform the search for duplicate records on the resulting subset. All best, Cab Vinton Plaistow Public Library

[Koha] Duplicate ISBN report modification

. Adding the following lines did not provide correct results, unfortunately: LEFT JOIN items m ON (m.biblionumber=b.biblionumber) WHERE m.homebranch = <> I suspect a subquery may be required, but it's beyond my current proficiency w/ MySQL :-( Thanks in advance for any guidance. All

Re: [Koha] [Koha-devel] Koha reports wiki

there are only 29 Holds and 50 Patrons queries.) All best, Cab Vinton, Director Plaistow Public Library Plaistow, NH ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] [Koha-devel] Koha reports wiki

me just to show the marcxml -> metadata queries. (there was > also a change in 17.11 -- statistics now has a location field, this breaks > queries that use location but don't specify the table). Sounds good. Not sure where the template lives, however. Cab Vinton, Director Plaistow Public Library

Re: [Koha] [Koha-devel] Koha reports wiki

of space. The links to the Holds, Patrons, & Circulation Reports pages will of course remain at the top of the main page. All best, Cab Vinton, Director Plaistow Public Library Plaistow, NH ___ Koha mailing list http://koha-community.org Koha@lists.

Re: [Koha] [Koha-devel] Koha reports wiki

move in 17.05 > for instance. > > Bug 17047 is currently signed off; if you logged in and added a comment to > the QA team that this was a priority (and possibly also added a vote (next > to 'importance' on the bug page), that would help move things along. :-) > > --B

[Koha] Koha reports wiki

pages see a lot of use, however, so I don't want to barge in and inadvertently make things worse. Anything I should be aware of before jumping in? All best, Cab Vinton, Director Plaistow Public Library Plaistow, NH ___ Koha mailing list ht

Re: [Koha] Drawing Software - Floor Mapping Library's Collections

man's point of view!) Trickiest part is perhaps making sure the cn_sort values in the item records are correct? A couple related bugs: * https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=737 * https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10814 Cheers, Cab Vinton

Re: [Koha] Batch restriction of patrons?

long, & not just those for whom we happened to be the home branch. Correct? Many thanks, Cab Vinton, Director Plaistow Public Library ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Batch restriction of patrons?

rest of the available checkboxes (Phone, Print, SMS)? Thanks! Cab Vinton, Director Plaistow Public Library ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Batch restriction of patrons?

. Unfortunately, it doesn't look like the Batch Patron Modification tool can be used to set patrons' debarred status (though we can set a new expiration date for their cards). I believe the Patron Import tool might be an option, but that seems too convoluted. Am I missing something? Many t

Re: [Koha] MySQL EOL

Thank you, Chris. Guess it will be up to individual support companies to make their own determinations on when to upgrade. Cheers, Cab On Sun, Jun 17, 2018 at 5:05 PM, Chris Cormack wrote: > Hi Cab > > The latest version of Koha works fine with 5.6 and 5.7 (and the latest > mariadb releases) s

[Koha] MySQL EOL

way out. Things one wonders on a lazy Father's Day afternoon ... Cab Vinton Plaistow Public Library ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Variables in reports

s.com > Urgency : enhancement > Status : RESOLVED OK, excellent. Thank you, Barton. Cheers, Cab Vinton ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Variables in reports

three times without getting errors. As an aside, here's another approach to finding items owned by all 3 branches: WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= i.dateaccessioned AND i.homebranch IN ('kimball','plaistow','sandown') GROUP BY biblionumber HA

Re: [Koha] Items held by more than one branch

mber,barcode,itype,location,ccode,itemlost,withdrawn > FROM items i > LEFT JOIN biblio b USING (biblionumber) > where biblionumber in (select biblionumber from items group by biblionumber > having count(distinct(homebranch)) >1) > order by i.biblionumber > > > > >

Re: [Koha] Items held by more than one branch

Sorry, no dice -- returns a single item :-( The mysteries of SQL ... Cheers, Cab On Mon, Apr 23, 2018 at 5:06 PM, Paul Hoffman wrote: > On Mon, Apr 23, 2018 at 09:19:10AM -0400, Cab Vinton wrote: >> Trying to write a report that will provide details for items held by >> more

Re: [Koha] Set report sort order at runtime

Thanks, Owen. Some quick Googling turned up several solutions that rely on setting a variable & then using CASE WHEN syntax. Tried this but Koha threw an error on the SET statement :-( SET @OrderByColumn = 'AddedDate' . ORDER BY CASE WHEN @OrderByColumn='AddedDate' THEN CONVERT(varchar(50)

Re: [Koha] Items held by more than one branch

d a way to include information for all items on that single line. We have 3 branches, so output would vary depending on whether a particular item is owned by just 2 or all 3 libraries. (Btw, I know the above is redundant, but ultimately I'll be adding fields that are not the same -- price, ord

[Koha] Items held by more than one branch

temlost=0 AND i.withdrawn=0 HAVING COUNT(i.itemnumber) > 1 ORDER BY b.title Grateful in advance for any assistance! All best, Cab Vinton Plaistow Public Library Plaistow, NH ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://li

[Koha] Set report sort order at runtime

Is this possible? This code did not work: ORDER BY <> as SQL turned this into: ORDER BY 'itemcallnumber' Think this would be a useful feature if Koha will allow it. Thanks in advance for any guidance, Cab Vinton, Director Plaistow Public Libr

Re: [Koha] Report for holds count by bib record & branch

Hi, all -- Did some more testing & it appears that Item Type information is not available when holds are placed for the Next Available item. Can't think of an easy work-around as it's entirely possible to have items attached to the same bib with different item types. Cheer

[Koha] Report for holds count by bib record & branch

de a fix? Many thanks in advance, Cab Vinton Plaistow Public Library ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Slow report for periodicals ranked by circ

AND s.datetime BETWEEN <> AND <> GROUP BY b.biblionumber ORDER BY circs DESC The report did run much quicker when I eliminated the UNION statement & used just one of the Items tables. Would be grateful to know if there's a better way of writing this report. Many thanks,

Re: [Koha] Statement of responsibility display w/ movies

> That doesn't sound correct to me. Did you try it? Not really as the other blocker still applied: "At this time the only keyword in use is 'subtitle.'" Again, we're wanting to suppress the 245 c, not the 245 b (subtitle), & only for movies. Unclear what keyword, if any, applies the former subfie

Re: [Koha] Statement of responsibility display w/ movies

I think we can do this very simply by working with those stylesheets. Will have a bash at that instead :-) Cheers, Cab Vinton Plaistow Public Library ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Statement of responsibility display w/ movies

Ah, thank you, Owen! I'd seen that, but didn't realize that different mapping was possible for different frameworks. Will give it a bash. Thanks again, Cab On Thu, Mar 23, 2017 at 12:13 PM, Owen Leonard wrote: >> So I'm wondering if there's an elegant way of suppressing the >> information in

[Koha] Statement of responsibility display w/ movies

only for particular item types (i.e., movies). Or perhaps a way to display just the last clause (usually the movie's director), following the final semi-colon. Thoughts? Cab Vinton, Director Plaistow Public Library Plaistow, NH ___ Koha mailing list h

Re: [Koha] Preserving circ history of deleted item

hat shouldn't deter you. Standard cataloging practice would be to add a new item and withdraw the old item while suppressing it from the catalog. OK, HTH! All best, Cab Vinton, Director Plaistow Public Library Plaistow, NH On Wed, Mar 15, 2017 at 12:37 PM, Ellen Kaye wrote: > Hello, >

[Koha] Lowering max reserves/ holds

ny thoughts to share, here's a super-quick 4-question survey on your max reserves policy: http://goo.gl/forms/XhBsajq2j0. We'll share the results on the list! Thank you, Cab Vinton, Director Plaistow Public Library Plaistow, NH ___

Re: [Koha] Inventory/ shelf-reading

t to use ;-) Technology's supposed to make things easier, after all ... Best, Cab Vinton Plaistow Public Library ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Inventory/ shelf-reading

what it's worth, we're not looking to get too fine-grained here. We're not too concerned with titles out of order, for example, within an author. We're really looking for authors out of order. Grateful for your thoughts & suggestions. All

[Koha] Statistics for inter-branch activity

out are checked in.) Can anyone explain what's going on here? Does it have something to do with how Transfers between branches are recorded by Koha? Thanks for any insight you can offer. Best, Cab Vinton, Director Plaistow Public Library Plaistow, NH

Re: [Koha] Report guidance

Head slap. Well, that's what I get for editing one of my old reports too quickly -- It should be b.branchcode = 'PLAISTOW' instead of b.branchcode <> 'PLAISTOW' Or rather -- WHERE i.homebranch = <> AND b.branchcode = <> Sheesh. Long week ... Than

[Koha] Report guidance

ISTOW' AND b.branchcode <> 'PLAISTOW' AND s.type in ('issue','renew','localuse') AND s.datetime BETWEEN '2013-01-01' AND '2013-12-31' ORDER BY i.cn_sort asc, i.itype, i.ccode Grateful for any

[Koha] Circulation/ fines rules

(amount) Renewals allowed (count) Renewal period Holds allowed (count) ALL All All 21 days 0.10 1 10 2 21 999 KIMBALL All All 21 days 0.10 1 10 2 21 999 PLAISTOW All All 21 days 0.10 1 10 2 21 999 SANDOWN All All 21 days 0.10 1 10 2 21 999 Thank you, Cab Vinton, Director Plaistow Public Library

[Koha] Fwd: Managing fines in a consortial environment

ports, feature requests, etc. FWIW, the only related bug I've found is this one -- http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9975 Thanks, Cab Vinton, Director Plaistow Public Library Plaistow, NH & Southern NH Library Cooperative __

[Koha] New SQL Report - Permissions Check

Permissions Check Developer: Christopher Brannon Module: Patrons Purpose: Search for ANY patrons that have some dangerous flags set. Modify the WHERE statement to watch for flags you want to keep an eye on. Status: Complete SELECT surname AS 'Last Name',firstname AS 'First Name',cardnumber AS 'Car

[Koha] New SQL Report - Patron Permissions

+ peanut gallery commentary -- Whoa. Will have to spend some time learning from this lovely SQL ... Cheers, Cab Vinton Sanbornton PL Sanbornton, NH Patron Permissions Developer: Christopher Brannon Module: Patrons Purpose: List patrons by library and type, and show what the status of all

[Koha] SQL Report Update

* Report edited so that it now works :-) Non Circulating Items Developer: Nicole C. Engard, ByWater Solutions Module: Circulation Purpose: List items that have never circulated Status: Complete SELECT b.title, b.author, i.barcode, i.itemcallnumber FROM items i LEFT JOIN biblio b USING (biblionumb

[Koha] Inspiring summary of how to contribute to Open Source

This is for the WordPress community, but I think it provides a useful example of the many ways we can contribute to an open source project such as Koha -- http://wp.smashingmagazine.com/2013/05/10/contributing-to-wordpress/ Cheers, Cab Vinton Sanbornton Public Library Sanbornton, NH

Re: [Koha] New Report Update

Holds Queue Workaround - *Developer:* George H. Williams - Latah County Library District - *Module:* Holds - *Purpose:* In Koha 3.10 there is a bug that is making the built in "Holds queue" report in the circulation module work incorrectly (bug 9950). This report can act as a repla

[Koha] New Report Update

Overdues With Holds Waiting - *Developer:* Nicole C. Engard, ByWater Solutions - *Module:* Holds/Circulation - *Purpose:* A list of items that are overdue that have holds on them. A report to help you know who to call with overdues to tell them others are waiting for their items

[Koha] New Report Update

ilable here:- https://chrome.google.com/webstore/detail/page-monitor/pemhgklkefakciniebenbfclihhmmfcd<https://chrome.google.com/webstore/detail/page-monitor/pemhgklkefakciniebenbfclihhmmfcd?hl=en> Unless there's an overwhelming hue & cry to cease & desist, I'll continue with u

[Koha] Admin email address

After changing our admin email address, we expected that our hold notices, non-emailed overdues, etc. would be sent to that email. However, emails are still being sent to our original admin email address. Any thoughts on what could be happening here? We're running Koha 3.8. Thank you,

Re: [Koha] Koha Usage Examples

es of type Academic in the UK ... Best of luck, Cab Vinton Sanbornton Public Library ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Z39.50 issues

Thanks, Galen! The new LOC db info works fine now. Will have to look into why our other db's are acting up now ... Cheers, Cab ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Z39.50 issues

Anyone else having problems grabbing records through Z39.50 in the past couple of days? Our FirstSearch, LOC & NYPL destinations all return errors ... We haven't changed any settings & they still match the settings from http://irspy.indexdata.com ... Thanks, Cab Vinton, Direct

[Koha] Import matching rule for 001 tag

meter be changed, but since OCLC numbers come in varying lengths (7,8,9 digits?), I'm not sure how this would work. Any thoughts? (And yes, I'm aware that the 001 tag is not fool-proof. In this case, however, it suits our purposes well.) Many thanks! Cab Vinton, Director Sanbornton

[Koha] Movie cover images

other identifier. Koha relies exclusively on the ISBN as far as I can tell. A sample movie for which we have no cover image: Madagascar 3 (UPC 097361169941). We have Koha 3.8. Thank you, Cab Vinton, Director Sanbornton Public Library Sanbornton, NH Life is short. Read

Re: [Koha] Analytic records question

s. Best, Cab Vinton, Director Sanbornton Public Library Sanbornton, NH Life is short. Read fast! On Wed, Jan 9, 2013 at 10:34 PM, Bernardo Gonzalez Kriegel wrote: > Cab, > perhaps I'm wrong, but you have added a proper item with his own call > number to your record "Lef

[Koha] Analytic records question

umber=25778 Link to the ereader record: http://catalog.splnh.com/cgi-bin/koha/opac-detail.pl?biblionumber=25777 Thanks for your thoughts. Cab Vinton, Director Sanbornton Public Library Sanbornton, NH Life is short. Read fast! ___ Koha mailing list h

Re: [Koha] [Koha-devel] Search operators

Also: MARC 521 field for: 0 - Reading grade level 1 - Interest age level 2 - Interest grade level MARC 526 field for Lexile, Accelerated Reader, etc. levels Cheers, Cab Vinton, Director Sanbornton Public Library Sanbornton, NH Life is short. Read fast

Re: [Koha] Import patrons tool

og in & take advantage of the various account features. Passwords will be something like last 6 digits of their library card number. Cheers, Cab Vinton, Director Sanbornton Public Library Sanbornton, NH Life is short. Read fast! On Mon, Dec 3, 2012 at 3:08 PM, Cab Vinton wrote: > Am I corre

[Koha] Import patrons tool

ll of the blank field values will overwrite the values in the corresponding fields in Koha. Thank you, Cab Vinton, Director Sanbornton Public Library Sanbornton, NH Life is short. Read fast! ___ Koha mailing list http://koha-community.org Koha@lists.kat

[Koha] Merging items on same record?

Is there a way to merge different items on the same record? I know there's a way to merge bib records, but that doesn't apply here. My goal is to preserve the circ histories attached to the individual items. Thanks, Cab Vinton, Director Sanbornton Public Library Sanbornton, NH Lif

[Koha] Acquisitions module

t responses. Thank you! Cab Vinton, Director Sanbornton Public Library Sanbornton, NH Life is short. Read fast! ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Batch item modification problem

Well, not clear exactly what I did, but selecting and de-selecting among the various 3 Withdrawn statuses (null #1, null #2 & Withdrawn) seems to do the trick. Cab Vinton, Director Sanbornton Public Library Sanbornton, NH On Fri, Aug 31, 2012 at 2:49 PM, Cab Vinton wrote: > We have a nu

[Koha] Batch item modification problem

We have a number of items with a status of Withdrawn that we would like to set to "not Withdrawn". The batch item modification tool does not seem to allow this, however, as this means setting the Withdrawn status to null. Anyone have any tips on how this might be accomplished? Thank

[Koha] Stable vs maintenance releases?

sophy of development, etc? With thanks, Cab Vinton, Director Sanbornton Public Library Sanbornton, NH Life is short. Read fast! ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Spell-check/ Did you mean

7;t upon us & NH is next ... Cab Vinton, Director Sanbornton Public Library Sanbornton, NH Life is short. Read fast! ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Spell-check/ Did you mean

preferences. Can anyone address whether this is expected behavior, or whether the fuzzy search engine is improved in 3.8? Didn't LibLime's Harley have something along these lines? Thank you, Cab Vinton, Director Sanbornton Public Libra

[Koha] Inactive borrowers report

item either being checked in or returned). Anyone have pointers on how to achieve this? It's beyond my current minimal level of SQL-fu. Many thanks, Cab Vinton, Director Sanbornton Public Library Sanbornton, NH Life is short. Read fast! ___ Koha

Re: [Koha] Retrieving 10-digit ISBNs in a report

> I cannot help you to solve the ISBN problem, but would be very interested > to learn how you do the carousel. Could you share? Or give some hints how to > make it work on my library catalog? Thanks! There are many options out there & we haven't settled on one approach yet. Will share once we get

Re: [Koha] [Koha-devel] Retrieving 10-digit ISBNs in a report

'd be happy to hear them. Many thanks again, Cab Vinton, Director Sanbornton Public Library Sanbornton, NH Life is short. Read fast! On Thu, Mar 8, 2012 at 12:49 AM, Nicholas van Oudtshoorn wrote: > A simple bit of code can be used to get the first valid 10-digit ISBN. This > is the

[Koha] Retrieving 10-digit ISBNs in a report

804840288 | 9780804840286 (tr 9780811876377 : | 0811876373 : 1569244677 9781400064588 (acidfree paper) 9780061429255 | 0061429252 9781451661064 (hardcover) | 14 Is there a way to run a report that outputs only the 10 digit ISBNs? Many thanks, Cab Vinton, Director Sanbornton Public Library Sanbo

[Koha] Fwd: FOSS4LIB registry now open for new packages/releases/providers/events/institutions

Thought this might be of wider interest to the Koha community. Cheers, Cab Vinton, Director Sanbornton Public Library Sanbornton, NH -- Forwarded message -- From: Peter Murray Date: Tue, Jan 17, 2012 at 3:39 PM Subject: FOSS4LIB registry now open for new packages/releases

[Koha] Well, this is disappointing ...

Both courses will include presentations and demos from vendors and systems librarians and possible site visits to libraries using ILS systems in their day-to-day operations." Free hosting is a nice bonus, but still ... Cab Vinton, Director Sanbornton Public Library Sanbornton, NH "

Re: [Koha] Primary & secondary email addresses

(http://bugs.koha-community.org), it looks like there's some work being done in this area, however. Will have to remember to search the system prefs & bugzilla before posting! Cheers, Cab Vinton, Director Sanbornton Public Library Sanbornton, NH "Politeness and consideration for

[Koha] Primary & secondary email addresses

Does anyone know how Koha (3.04.02) handles emailed notices when there is a secondary email address, but no primary address? My suspicion is that no notice is sent out & the notice is bundled into the compiled "Overdue Notices" message to the admin for patrons w/out addresses ...

Re: [Koha] Playing a sound file with bad barcodes

file or sound to play -- not sure how big coding job that would be -- but this should work for us. Thanks again! Cab Vinton, Director Sanbornton Public Library Sanbornton, NH "Politeness and consideration for others is like investing pennies and getting dollars back." Thomas Sowell

[Koha] Playing a sound file with bad barcodes

Koha play a sound whenever this happens. In the meantime, has anyone used a Greasemonkey script or the like for this purpose? Text of the error messages is as follows: No Item with barcode The barcode was not found Other ideas I may have overlooked? Thanks, Cab Vinton, Director Sanbornton Public

[Koha] Task scheduler

In whatever version of Koha we're running, it appears that the Task Scheduler can not be used to schedule tasks on a recurring basis, e.g., once a week, every 14 days, etc. (I'm thinking of running Reports periodically, in particular.) Is this accurate? Thank you, Cab Vinton

Re: [Koha] Walkthrough: Using OPACMySummaryHTML to share on Facebook (etcetera)

Can someone show an example of this system preference in action? Sounds very interesting! Cab Vinton, Director Sanbornton Public Library Sanbornton, NH On Fri, Jun 10, 2011 at 11:19 AM, Magnus Enger wrote: > Viktor et al! > > I have taken the liberty of creating a wiki page base

[Koha] Deleting patrons

Are there any issues related to deleting patrons that one should be aware of? I'm thinking particular of the "usual" circulation and & statistical reports that libraries run for annual reports, etc. Thank you, Cab Vinton, Director Sanbornton Public Lib