Re: [Koha-devel] Staff interface redesign is ready to be tested

2022-07-08 Thread Cab Vinton
low things down a bit. It's probably a tiny minority of end-users that are used to setting up their own sandboxes from scratch. All best, Cab Vinton, Director Plaistow Public Library Plaistow, NH ___ Koha-devel mailing list Koha-devel@lists.koh

Re: [Koha-devel] Staff interface redesign is ready to be tested

2022-07-02 Thread Cab Vinton
There was also a demo install on the BibLibre website a few months back. Perhaps it's still current & someone from the redesign team can share the credentials? All best, Cab Vinton, Director Plaistow Public Library Plaistow, NH ___ Koha-deve

Re: [Koha-devel] Effective circulation rule preview/tester

2022-06-22 Thread Cab Vinton
All best, Cab Vinton, Director Plaistow Public Library Plaistow, NH ___ Koha-devel mailing list Koha-devel@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : https://www.koha-community.org/ git :

Re: [Koha-devel] Adding recent (current/past year) statistics to the items table

2022-04-29 Thread Cab Vinton
a>), but librarians are lazy & a native solution is more likely to be used :-) Just one librarian's opinion ... Cab Vinton, Director Plaistow Public Library Plaistow, NH ___ Koha-devel mailing list Koha-devel@lists.koha-community.org https://lists.ko

Re: [Koha-devel] Staff interface redesign: Update

2022-01-19 Thread Cab Vinton
If there's a time that makes sense for end-users to chime in, let me know. I know less is more at certain project stages. I'm sure there'll be interest among librarians to provide feedback when the timing's right. All best, Cab Vinton, Director Plaistow Public

Re: [Koha] Records visible to those who login

2021-10-27 Thread Cab Vinton
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-devel] Changing the lost card value

2021-10-18 Thread Cab Vinton
I think another option would be the Patron Import tool: ...tools/import_borrowers.pl Cheers, Cab Vinton, Director Plaistow Public Library Plaistow, NH On Mon, Oct 18, 2021 at 9:43 AM Jonathan Druart wrote: > > Hi Stephen, > > You can use > Koha::Patrons->find(42)->los

Re: [Koha-devel] Built-in offline circulation interface

2021-10-16 Thread Cab Vinton
Fwiw, we'd somehow missed that there was a built-in capability/ system preference. Always assumed the utility was our only option. This functionality is an important part of Koha's feature set, so +1 to always having at least one up-to-date option available. Cheers, Cab Vinton

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

2021-10-12 Thread Cab Vinton
> > 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

2021-10-07 Thread Cab Vinton
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.

2021-09-15 Thread Cab Vinton
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?

2021-08-24 Thread Cab Vinton
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?

2021-08-24 Thread Cab Vinton
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?

2021-08-24 Thread Cab Vinton
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

2021-07-04 Thread Cab Vinton
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-devel] Koha Command and Control

2020-12-16 Thread Cab Vinton
This popped into my email ... Above my pay grade, but maybe of relevance? https://newrelic.com/ All best, Cab Vinton, Director Plaistow Public Library On Tue, Dec 15, 2020 at 6:04 PM wrote: > > Hi all, > > > > For a while, I’ve been thinking that it might be good to h

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

2020-07-16 Thread Cab Vinton
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

2019-10-04 Thread Cab Vinton
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

2019-09-09 Thread Cab Vinton
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

2019-09-04 Thread Cab Vinton
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

2019-06-14 Thread Cab Vinton
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

2019-06-14 Thread Cab Vinton
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

2019-02-22 Thread Cab Vinton
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

2019-02-22 Thread Cab Vinton
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

2019-02-22 Thread Cab Vinton
;, 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

2018-11-08 Thread Cab Vinton
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-devel] Signed off status

2018-08-29 Thread Cab Vinton
gt; https://wiki.koha-community.org/wiki/Development_workflow > > Best regards > > El mié., 29 ago. 2018 a las 9:37, Cab Vinton () > escribió: >> >> Every now & then I come across a bug that's been signed off, but the >> status is still "Needs Signoff"

[Koha-devel] Signed off status

2018-08-29 Thread Cab Vinton
o, probably from someone higher up the food chain than a regular end-user like me? I didn't find guidance in the Development Workflow wiki, but I might have missed something. Many thanks, Cab Vinton, Director Plaistow Public Library Plaistow, NH ___

Re: [Koha] Duplicate ISBN report modification

2018-08-17 Thread Cab Vinton
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

2018-08-16 Thread Cab Vinton
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

2018-08-15 Thread Cab Vinton
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

2018-08-14 Thread Cab Vinton
. 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-devel] Batch cleanup to the catalog

2018-08-01 Thread Cab Vinton
ase, & also that the cleanup itself will be done in stages. Ultimate goals are to get rid of unnecessary fields, and to make sure they're not imported into the catalog in the first place. Thanks again, Cab Vinton Plaistow Public Library On Wed, Aug 1, 2018 at 11:28 AM, Michael Hafen

[Koha-devel] Batch cleanup to the catalog

2018-08-01 Thread Cab Vinton
M? (I'm assuming there's no issue w/ using such tools to work w/ much smaller subsets of records.) Thanks in advance for any guidance. All best, Cab Vinton, Director Plaistow Public Library Plaistow, NH ___ Koha-devel mailing list Koha-dev

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

2018-07-22 Thread Cab Vinton
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-devel] Koha reports wiki

2018-07-22 Thread Cab Vinton
there are only 29 Holds and 50 Patrons queries.) All best, Cab Vinton, Director Plaistow Public Library Plaistow, NH ___ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel we

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

2018-07-21 Thread Cab Vinton
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-devel] Koha reports wiki

2018-07-21 Thread Cab Vinton
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 Lib

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

2018-07-20 Thread Cab Vinton
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-devel] Koha reports wiki

2018-07-20 Thread Cab Vinton
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-devel mailing list Koha-devel@lists.koha-commun

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

2018-07-19 Thread Cab Vinton
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

Re: [Koha-devel] Koha reports wiki

2018-07-19 Thread Cab Vinton
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

2018-07-19 Thread Cab Vinton
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

[Koha-devel] Koha reports wiki

2018-07-19 Thread Cab Vinton
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-devel mailing list Koha-de

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

2018-07-17 Thread Cab Vinton
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?

2018-07-10 Thread Cab Vinton
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?

2018-07-06 Thread Cab Vinton
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?

2018-07-05 Thread Cab Vinton
. 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

2018-06-17 Thread Cab Vinton
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

2018-06-17 Thread Cab Vinton
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

2018-06-06 Thread Cab Vinton
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

2018-06-06 Thread Cab Vinton
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

[Koha-devel] Branch column in statistics table

2018-05-03 Thread Cab Vinton
he reports below.) All best, Cab Vinton, Director Plaistow Public Library Plaistow, NH SELECT b.categorycode, s.branch as 'checked out at', b.branchcode as 'patron branch', count(s.datetime) as count FROM statistics s LEFT JOIN borrowers b ON (s.borrowernumber = b.borrowern

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

2018-04-24 Thread Cab Vinton
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

2018-04-23 Thread Cab Vinton
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

2018-04-23 Thread Cab Vinton
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

2018-04-23 Thread Cab Vinton
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

2018-04-23 Thread Cab Vinton
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

2018-04-23 Thread Cab Vinton
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

[Koha-devel] For larger support companies

2018-04-22 Thread Cab Vinton
Koha developers may be contrary enough that this wouldn't work, but still a fun idea: https://github.com/codedance/Retaliation Video here -- https://www.youtube.com/watch?v=1EGk2rvZe8A Many possible applications :-) Squirrel on your birdfeeder, child in the cookie jar, ... Cab V

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

2018-03-27 Thread Cab Vinton
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

2018-03-27 Thread Cab Vinton
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

2017-10-05 Thread Cab Vinton
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-devel] Development/ QA protocol question

2017-03-30 Thread Cab Vinton
> Bug 15760, 13690 are about Koha::Schema. They are very small but they fix > global problems and can have big side effects. > Patches that add external JS libs, move files, update less/css, or thing > like bug 9978 are huge but are easy to review Ah, OK. Makes sense. Thank you, Jonathan!

Re: [Koha-devel] Development/ QA protocol question

2017-03-30 Thread Cab Vinton
> A one line patch can be much more complex than a 1k lines patch ¯\_(ツ)_/¯ Now you got me curious. Can you provide an example of this? For research purposes :-) ___ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community

Re: [Koha-devel] Development/ QA protocol question

2017-03-29 Thread Cab Vinton
On Wed, Mar 29, 2017 at 4:58 PM, Jonathan Druart wrote: > There is a "Patch complexity" field, but I personally do not use it (I > should yes). I've see. Don't think anyone else uses it either :-) Would be cool if it auto-populated with the number of new/ different lines in the patch ... Pretty

Re: [Koha-devel] Development/ QA protocol question

2017-03-29 Thread Cab Vinton
Thank you, Owen. If the priority scale is unused, then seems like a good candidate for removal/ suppression from Bugzilla, if possible. Severity is definitely a good first pass. As I mentioned earlier, however, the vast majority are "enhancements", so QAer's would have to move on to other factors

Re: [Koha-devel] Development/ QA protocol question

2017-03-29 Thread Cab Vinton
Yes, all makes perfect sense, Jonathan. I suspect the way in which projects work their through QA is opaque to most libraries, and like any client, they're always happy when their projects get lots of attention, move through quickly, etc. I believe at any given time there are dozens of patches so

Re: [Koha-devel] Development/ QA protocol question

2017-03-29 Thread Cab Vinton
On Wed, Mar 29, 2017 at 10:30 AM, Jonathan Druart wrote: > I would not expect a QAer to be paid (by the sponsor of the enh) to review a > patch, I'd call that more corruption / conflict of interest than sponsoring :) Ah. Hadn't thought of it that way. Good point. Not sure there's an easy way arou

[Koha-devel] Development/ QA protocol question

2017-03-29 Thread Cab Vinton
other option, of course, but that's unpleasant for both sides :-) I realize the QA person often, & perhaps preferably, will work for a different firm. And there may be other complicating factors I'm not aware of. Grateful for any thoughts from folks on the programming side of thing

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

2017-03-23 Thread Cab Vinton
> 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

2017-03-23 Thread Cab Vinton
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

2017-03-23 Thread Cab Vinton
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

2017-03-23 Thread Cab Vinton
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

2017-03-23 Thread Cab Vinton
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

2015-09-28 Thread Cab Vinton
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: [CODE4LIB] Identifying misshelved items

2015-01-20 Thread Cab Vinton
etc.) as that's the OS our pages are most comfortable with. Thanks for the suggestions! Cab Vinton Plaistow Public Library Plaistow, NH On Thu, Jan 15, 2015 at 7:30 PM, Ronald Houk wrote: > Just realized I had a typo. Should look something like. > > diff -Nau <(so

Re: [CODE4LIB] Wi-Fi location triangulation

2015-01-19 Thread Cab Vinton
Are we talking beacons here? Gimbal (made by Qualcomm) has beacons that cost just $5 per. No experience w/ beacons, but they're on my too-long list of fun but potentially useful tech to look into ... Cab Vinton, Director Plaistow Public Library Plaistow, NH

[CODE4LIB] Identifying misshelved items

2015-01-15 Thread Cab Vinton
he last correctly shelved book; see Rosen/ Rosenberg above). Has this wheel already been invented? Grateful for any & all suggestions! Best, Cab Vinton, Director Plaistow Public Library Plaistow, NH

Re: [CODE4LIB] circulation statistics

2015-01-14 Thread Cab Vinton
tantly growing list of user-contributed reports here: http://wiki.koha-community.org/wiki/SQL_Reports_Library/ Can't speak to Aleph, but there is a Developer's Network which should point you in the right direction: https://developers.exlibrisgroup.com/ Best, Cab Vinton Plaistow Public Library

Re: [Koha] Inventory/ shelf-reading

2014-12-21 Thread Cab Vinton
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

2014-12-16 Thread Cab Vinton
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

2014-05-19 Thread Cab Vinton
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-devel] RSS feed for Public Lists

2014-04-03 Thread Cab Vinton
depending on the library, item type, etc. I'm format-agnostic, but agree that keeping things consistent with other Koha RSS feeds makes a lot of sense. Cheers, Cab Vinton, Director Plaistow Public Library Plaistow, NH On Thu, Apr 3, 2014 at 1:54 AM, David Cook wrote: > Hi folks: >

Re: [Koha] Report guidance

2014-02-21 Thread Cab Vinton
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

2014-02-21 Thread Cab Vinton
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

2013-12-12 Thread Cab Vinton
(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

[CODE4LIB] Programmatic retrieval of book series info?

2013-11-19 Thread Cab Vinton
each title with the appropriate series info. GoodReads has an API, for example, but wondering if anyone on the list has already come up with a good method or has suggestions. Many thanks in advance, Cab Vinton, Director Plaistow Public Library Plaistow, NH

[Koha] Fwd: Managing fines in a consortial environment

2013-10-20 Thread Cab Vinton
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 __

Re: [Koha-devel] Bugzilla account changes?

2013-09-12 Thread Cab Vinton
Thanks, Galen -- that did it. I'd seen that but it wasn't clear that it would also change the login. Should have simply tried it! Cheers, Cab Vinton On Thu, Sep 12, 2013 at 3:36 PM, Galen Charlton wrote: > Hi Cab, > > > On Thu, Sep 12, 2013 at 12:29 PM, Cab Vinton

[Koha-devel] Bugzilla account changes?

2013-09-12 Thread Cab Vinton
I'm moving to a new job (to another Koha library!) and I'd like to take my Bugzilla a/c with me. The login appears to be locked to my old work email address, however. Is there an admin who could change the login and/ or help me manage the transfer? Thanks, Cab Vinton San

Re: [CODE4LIB] Visualizing (public) library statistics

2013-06-06 Thread Cab Vinton
Many thanks to all for the suggestions. It will take some time for me to go through them all, but I'll share anything I'm able to come up with on my end. Many thanks again, Cab Vinton Sanbornton Public Library

[CODE4LIB] Visualizing (public) library statistics

2013-06-05 Thread Cab Vinton
f how things work on the back end. Cheers, Cab Vinton, Director Sanbornton Public Library Sanbornton, NH

[Koha] New SQL Report - Permissions Check

2013-05-24 Thread Cab Vinton
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

2013-05-22 Thread Cab Vinton
+ 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

2013-05-21 Thread Cab Vinton
* 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

2013-05-14 Thread Cab Vinton
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

2013-05-10 Thread Cab Vinton
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

2013-05-09 Thread Cab Vinton
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

2013-05-01 Thread Cab Vinton
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

  1   2   >