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
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
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 :
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
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
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
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
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
>
> 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
;, 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
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
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"
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
___
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
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
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
.
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
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
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
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
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
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
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
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.
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
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
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
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
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
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
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
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
.
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
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
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
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
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
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
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
>
>
>
>
>
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
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)
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
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
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 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
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
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
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,
> 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!
> 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
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
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
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
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
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
> 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
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
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
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
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,
>
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
___
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
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
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
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
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
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
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
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:
>
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
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
(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
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
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
__
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
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
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
f how things work on the back end.
Cheers,
Cab Vinton, Director
Sanbornton Public Library
Sanbornton, NH
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
+ 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
* 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
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
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
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
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 - 100 of 158 matches
Mail list logo