Re: [Koha] Records visible to those who login

[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 OpacHiddenItems and
> OpacHiddenItemsExceptions.
>
>
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

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

[Cab Vinton]

Just out of curiosity, how large is your database, Tasha? We've
managed to run into issues w/ about 90K records (standard MARC bibs
for books, etc.).

This isn't all that large in the grand scheme of things, so when we
run into issues, I know either our SQL has some optimization issues,
or the report may be a bit too ambitious (lots of UNION statements,
etc.) & we should consider only running when the library's closed. We
have a support vendor, so this is typically when we ask for help from
people smarter than us :-)

Wonder if you'd have better luck finding guidance on sites more
focused on database administrators? (StackExchange,
https://forums.mysql.com/, or even a local DBA/ MySQL user group)

Cheers,

Cab

On Mon, Oct 11, 2021 at 9:52 PM Bales (US), Tasha R
 wrote:
>
> Hi Cab, that is in fact helpful feedback.  I've taken queries that we've used 
> for years with Millennium and Oracle, and am rewriting them for Koha and 
> MySQL.  So far, MySQL does seem pickier.  I have tried using the "EXPLAIN" 
> command to help identify inefficient queries, but it didn't really help.
>
> One tactic we've tried in the past is to create views containing subsets of 
> data that we need to frequently iterate over, to help decrease processing 
> time.  Maybe that is an approach we could use here, but I am wary of trying 
> to modify our database in any way.  Maybe a last resort.  Thanks again.
>
>
> 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 timing out, prevents access to web 
> interfaces
>
> EXT email: be mindful of links/attachments.
>
>
>
> I don't have any particularly helpful advice to offer, unfortunately, but I 
> can confirm from personal experience that certain queries can indeed bring 
> your system to a crawl. I don't think there's a solution to this unless 
> there's a way to firewall report queries from the rest of Koha, or to 
> automatically throttle misbehaving processes.
>
> In my case, I'd copied & pasted a report from the wiki, but a change in 
> Koha's database structure since the report's creation led to, well, very bad 
> results.
>
> I think your best bet is to take a really close look at 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
> ___
>
> Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

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

[Cab Vinton]

I don't have any particularly helpful advice to offer, unfortunately,
but I can confirm from personal experience that certain queries can
indeed bring your system to a crawl. I don't think there's a solution
to this unless there's a way to firewall report queries from the rest
of Koha, or to automatically throttle misbehaving processes.

In my case, I'd copied & pasted a report from the wiki, but a change
in Koha's database structure since the report's creation led to, well,
very bad results.

I think your best bet is to take a really close look at 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
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

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

[Cab Vinton]

>> Is there a way to use the batch operations to add the note from the 
>> items.price field ?

This would work w/ the Batch record modification tool if it had access
to the 952 tag & subfields. Unfortunately, it doesn't, at least in
20.05. Perhaps a good enhancement for down 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 mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Batch edit to control fields?

[Cab Vinton]

Does indeed make sense, Caroline. Thank you!

Report now generates much more sensible results, though it's
interesting that the previous version was also finding things. If the
SUBSTRING was off by 1, in theory almost all of the values should have
been spaces since the 008/32 is almost always 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 difference has to do with the starting character of the substring, i.e. 
> the 33 in the following sequence
>
> SUBSTRING(ExtractValue(metadata,'//controlfield[@tag=008]'),33,1)
>
> MARC starts counting at 1, whereas SQL starts counting at 0. Or it might be 
> the reverse, I don't remember exactly. Anyway, the thing is that you can't 
> use the MARC character position (in this case 33 because you're looking for 
> 008/33), directly in the substring statement. You have to add 1.
>
> So to look for 008/33 you have to use
>
> SUBSTRING(ExtractValue(metadata,'//controlfield[@tag=008]'),34,1)
>
> to look for 008/15-17, like in the example in the link I sent, you have to use
>
> SUBSTRING(ExtractValue(metadata,'//controlfield[@tag=008]'),16,3)
>
> Does that make sense?
>
> Caroline
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Batch edit to control fields?

[Cab Vinton]

Thanks so much, Caroline! Good excuse to brush up on my French.

Have used MarcEdit before, but not for this, so your instructions will
be vachement utiles :-)

Btw, we've been using the report below to identify which records have
issues w/ the 008/33. However, the ExtractValue statement 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,'//controlfield[@tag=008]'),33,1)
AS LitForm, i.itemcallnumber, i.itype, i.ccode, CONCAT('', biblionumber, '' ) AS bibnumber
FROM biblio_metadata
LEFT JOIN items i USING (biblionumber)
ORDER BY i.biblionumber DESC, i.itemcallnumber
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Batch edit to control fields?

[Cab Vinton]

Hi, All --

Does anyone know if the Batch record modification tool can handle
control fields? -- specifically, changes to various positions in the
leader, 008, etc. We're trying to update the 008/33 in a large number
of records.

I've tried creating an action for this under a MARC modification
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 Library
Plaistow, NH
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Question on magazine local images

[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 understand that magazines are handled in koha under Serials / Continuing
> resources, with a record for the magazine, and one or more items for the
> magazine issues.
> I also understand that one may upload one or more local images at the
> record level.
>
> I wonder if/how may one upload local images at the item level, so that
> every item (magazine issue) has the cover image pertaining to the specific
> issue.
>
> TIA
> Manos Petridis
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

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

[Cab Vinton]

> Yes, this helped! After changing the Koha-to-MARC-mapping I ran the
> maintenance job "batchRebuildBiblioTables.pl". Now the sort order of the
> public lists in the OPAC works as desired.

Is that job typically scheduled to run automatically, or would
libraries have to run 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
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Report help needed - lost items

[Cab Vinton]

Very late to the party, but maybe this could provide a clue.

The following throws an error, but I believe the basic idea of finding
records where the lowest itemlost value isn't zero is on the right
track:

WHERE itype = <>
GROUP BY biblionumber
HAVING MIN(itemlost) > 0

I 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 Public Library
Plaistow, NH


On Sat, Aug 24, 2019 at 8:30 PM Elaine Bradtke  wrote:
>
> Mark, that still didn't do the trick, but thanks!
> Caroline, this is much closer to what I need. But still not quite right.
> It's messy because I've altered a report that I found in the report library
> rather inelegantly.
>
> What I really need is a list of titles and biblio numbers of biblios where
> the last item is lost, or missing, or withdrawn (I can change that part of
> the query myself).  I have to limit it by format because we have articles
> and components in the catalogue that don't have item records attached.
> What I'm getting now lis a list of biblios with items that are missing but
> it includes biblios that still have one or more items that are on the shelf
> (but at least one item that is missing). Or in other words, I'm looking for
> biblios where the all the items are missing/lost/withdrawn.
>
> Many thanks for your help!
>
> Elaine Bradtke
> VWML
> English Folk Dance and Song Society | http://www.efdss.org
> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
> Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
> Song Society in London, England. If you wish to phone me personally, send
> an e-mail first. I work off site)
> --
> Registered Company No. 297142
> Charity Registered in England and Wales No. 305999
>
>
> On Fri, Aug 23, 2019 at 12:30 PM Caroline Cyr-La-Rose <
> caroline.cyr-la-r...@inlibro.com> wrote:
>
> > Hello Elaine,
> >
> > from what I understand, you want bibliographic information on lost items?
> >
> > I'd need to know exactly the purpose of the report to help you more as
> > there are things in there I don't understand (like why select barcode,
> > when afterwards you group by biblionumber, or why the title is there
> > twice).
> >
> > First, instead of selecting from the biblio table, I would go the other
> > way and select from the items table. That way, you are sure of getting
> > only things that have an item.
> >
> > If you want to limit by itemtype, you can add WHERE itype = < > type|itemtypes>> in your query to have the ability to choose your
> > itemtype upon executing your report.
> >
> > I cleaned your query up a little bit, but like I mentioned before, as I
> > don't know the purpose, it might not be what you need.
> >
> > SELECT
> >  CONCAT(
> >  ' >  biblionumber,
> >  '\">',
> >  title,
> >  ''
> >  ) AS Title,
> >  biblionumber,
> >  barcode,
> >  ccode,
> >  onloan AS 'Checkout date'
> > FROM
> >  items
> >  JOIN biblio USING (biblionumber)
> > WHERE itemlost != 0
> >AND itype = <>
> >
> > Let us know if this works.
> > Caroline
> >
> >
> > On 19-08-23 15 h 00, Mark Alexander wrote:
> > > Excerpts from Elaine Bradtke's message of 2019-08-23 11:32:44 -0700:
> > >> I've got the following adapted from one in the reports library.  But I
> > need
> > >> to limit it by item type, or not return everything that doesn't have an
> > >> item record attached. We've got lots of components in our catalogue that
> > >> don't have items and it's returning all of them:
> > >>
> > >> SELECT
> > >>  CONCAT(
> > >>  ' > ',
> > >>  bib.biblionumber,
> > >>  '\">',
> > >>  bib.title,
> > >>  ''
> > >>  ) AS Title,
> > >>  bib.title,
> > >>  bib.biblionumber,
> > >>  lostitems.barcode,
> > >>  lostitems.ccode,
> > >>  lostitems.onloan AS 'Checkout date'
> > >> FROM
> > >>  biblio bib
> > >> 

Re: [Koha] Alerts for every Nth check out

[Cab Vinton]

My first thought was to run a daily report using the MOD function on
the total number of checkouts, i.e., MOD(30,10) = 0, MOD(120,10) = 0,
etc.

Unfortunately, patrons often don't check out just one item at a time,
so you'd miss many cases if you only flagged patrons whose issues
count was an exact multiple of 10. The count may have increased from
117 to 126, for example.

But I think the DIV (quotient) function should work. I believe DIV(n,
10) increases by one with every multiple of 10, so the report would
simply have to find cases where DIV([total checkouts], 10) increased
over the previous day.

Don't have time to test this, but perhaps you or someone else can test
some code to see if this is on the right track. We have a 1000 Books
Before Kindergarten program here & would like to honor other heavy
borrowers as well, so this type of report would certainly be 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 members when a patron
> checks out every 10th book?
>
> ie, someway for staff to know that John Smith is checking out 10th/20th/30th
> ... book? We would like to reward such patron.
>
> Thank you,
> Sri
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Top 10 Circulating Books

[Cab Vinton]

Try this --

SELECT count(s.datetime) AS circs, b.title, b.author, i.ccode
FROM statistics s
JOIN items i ON (i.itemnumber=s.itemnumber)
LEFT JOIN biblio b ON (b.biblionumber=i.biblionumber)
WHERE s.datetime BETWEEN <> AND <>
AND s.itemnumber IS NOT NULL AND s.type IN ('issue','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 generate the top 10 circulating books from
> koha-community.
>
> SELECT count(s.datetime) AS circs, b.title, b.author,
>i.ccode FROM statistics sJOIN items i ON
> (i.itemnumber=s.itemnumber) LEFT JOIN biblio b ON
> (b.biblionumber=i.biblionumber) WHERE DATE(s.datetime) >
> DATE_SUB(CURRENT_DATE(),INTERVAL 6 MONTH)
>   AND DATE(s.datetime)<=CURRENT_DATE() AND
>   s.itemnumber IS NOT NULL AND s.type IN ('issue','renew')GROUP BY
> b.biblionumber ORDER BY circs DESC LIMIT 10
>
>
> How can we add date range and branch filter?
>
> Thank you.
>
> --
> Ma. Victoria H. Silva-Manuel
> Registered Librarian, 3892
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

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

[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 Library

On Fri, Jun 14, 2019 at 1:35 PM Hernandez, Heather
 wrote:
>
> Hi, Cab--
>
> We've found that our installation of Koha needs the image file to have 
> dimensions of  pixels or less on each side.
>
> In case it's helpful, here's some info on our workflow:
> We do preservation scanning since we're a museum collection; in short, we 
> usually scan at 300dpi, full color, .tiff, and then create a .jpg from the 
> .tiff with dimensions of less than  pixels per side for uploading into 
> Koha.  We store the .tiffs as digital preservation masters, and they're also 
> handy if we get a request for a high quality version of an image (e.g., for 
> publication).  We also contribute .jpg cover images to OpenLibrary.org if 
> they're lacking there.
>
> Hope this is helpful!  Cheerio,
> h2
> ~~
> Heather Hernandez (she, her, hers)
> Technical Services Librarian
> San Francisco Maritime National Historical Park Research Center
> 2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA  94123-1284
> 415-561-7032, heather_hernan...@nps.gov
> Library catalog: http://keys.bywatersolutions.com/
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Uploading local cover images

[Cab Vinton]

Hi, All --

I've searched the manual & list archives, but wasn't able to find an
answer to this question.

What are best practices for uploading local cover images? I'm thinking
specifically of image size and aspect ratio.

According to github
(https://github.com/Koha-Community/Koha/blob/master/tools/upload-cover-image.pl):

"This script is called and presents the user with an interface
allowing him/her to upload a single cover image or bulk cover images
via a zip file.

Images will be resized into thumbnails of 140x200 pixels and larger
images of 800x600 pixels. If the images that are uploaded are larger,
they will be resized, maintaining aspect ratio."

Is this information still accurate? Our source images are typically
several megabytes in size & we don't want to spend time preprocessing
if this is unnecessary.

Any other tips not covered in the 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.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

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

[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 biblioitems m USING (biblioitemnumber)
LEFT JOIN biblio b ON i.biblionumber = b.biblionumber
WHERE
i.itype = 'NEWBOOK'
AND exists(
select * from items where items.itemnumber = i.itemnumber AND
DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned
)
GROUP BY
b.biblionumber
HAVING
isbn != ""
AND count(i.homebranch) > 1
ORDER BY rand()
LIMIT 7
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

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

[Cab Vinton]

Unless I'm missing the thread somehow, I don't think that will work as
the prior conditions for all 3 branches are still present in the WHERE
statement.

If we eliminate those, then we still need to include the acquisition
date condition somehow.

Thanks,

Cab


On Fri, Feb 22, 2019 at 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 random list of items
>> held by all 3 of our branches & purchased within the past 30 days.
>>
>> To generate more titles we'd like to loosen the criteria by specifying
>> that the titles should be held by just 2 of the 3 branches.
>>
>> I know how I'd approach this outside of Koha's SQL-based reporting
>> tool, but not sure how to write this without repeating a whole bunch
>> of code ((A or B) or (A or C) or (B or C)). The code is used to
>> populate a carousel on our OPAC's home page & it's already a bit
>> "pokey", 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 isbn,
>> b.title, i.homebranch, i.itemcallnumber
>>   FROM items i
>>   LEFT JOIN biblioitems m USING (biblioitemnumber)
>>   LEFT JOIN biblio b ON i.biblionumber = b.biblionumber
>>   WHERE i.itype = 'NEWBOOK'
>>   AND b.biblionumber IN (SELECT biblionumber FROM items WHERE
>> DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND
>> homebranch='KIMBALL')
>>   AND b.biblionumber IN (SELECT biblionumber FROM items WHERE
>> DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND
>> homebranch='PLAISTOW')
>>   AND b.biblionumber IN (SELECT biblionumber FROM items WHERE
>> DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND
>> homebranch='SANDOWN')
>>   GROUP BY b.biblionumber
>>   HAVING isbn != ""
>>   ORDER BY rand()
>>   LIMIT 7
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

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

[Cab Vinton]

Hi, All --

We have a report (see below) that generates a random list of items
held by all 3 of our branches & purchased within the past 30 days.

To generate more titles we'd like to loosen the criteria by specifying
that the titles should be held by just 2 of the 3 branches.

I know how I'd approach this outside of Koha's SQL-based reporting
tool, but not sure how to write this without repeating a whole bunch
of code ((A or B) or (A or C) or (B or C)). The code is used to
populate a carousel on our OPAC's home page & it's already a bit
"pokey", 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 isbn,
b.title, i.homebranch, i.itemcallnumber
  FROM items i
  LEFT JOIN biblioitems m USING (biblioitemnumber)
  LEFT JOIN biblio b ON i.biblionumber = b.biblionumber
  WHERE i.itype = 'NEWBOOK'
  AND b.biblionumber IN (SELECT biblionumber FROM items WHERE
DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND
homebranch='KIMBALL')
  AND b.biblionumber IN (SELECT biblionumber FROM items WHERE
DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND
homebranch='PLAISTOW')
  AND b.biblionumber IN (SELECT biblionumber FROM items WHERE
DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND
homebranch='SANDOWN')
  GROUP BY b.biblionumber
  HAVING isbn != ""
  ORDER BY rand()
  LIMIT 7
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

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

[Cab Vinton]

A couple follow up questions for you, Barton.

Are Zebra facets a general system preference? I see a few
facets-related preferences, but nothing specifically tied to Zebra.

We're still using Zebra in our system. Can you clarify what you mean
by ElasticSearch not yet being at feature-parity 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 believe that
> they're enabled by default, and they're dog slow.
>
> Zebra is *very* disk IO intensive. Make sure that its temporary directory
> is being written to the fastest drive you have.
>
> If you have the QueryFuzzy or QueryStemming system preferences enabled, be
> aware that they don't like single letter words such as "A" or "I" --
> essentially, they end up trying to search for 'a*' or 'i*'; on a slow file
> system they can entirely time out and not return any results. Those system
> preferences *do* provide for easier searching -- disabling them means that
> keywords have to be typed exactly as they are in the record, so there's a
> trade-off between speed and user utility, but if the searches are too slow,
> it might be worth looking into.
>
> Finally, take a look at ElasticSearch. It isn't at feature-parity with
> Zebra in 18.05, but it might be worth a look.
>
> On Wed, Nov 7, 2018 at 6:23 PM Mark Tompsett  wrote:
>
> > Greetings,
> >
> > I don't promise to be right, but here are a couple thoughts:
> > 1) You can use Zebra Facets -- there's a koha-conf.xml line in there
> > somewhere.
> > 2) Also, do you have plack turned on? Plack increases response times
> > considerably.
> >
> > GPML,
> > Mark Tompsett
> >
> > ___
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> >
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Duplicate ISBN report modification

[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

Cab
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Duplicate ISBN report modification

[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 Chittenden
 wrote:
>
>
> On Tue, Aug 14, 2018, 11:29 AM Cab Vinton  wrote:
>>
>> Hi, All --
>>
>> We're using the following report to identify records w/ duplicate ISBNs.
>>
>> SELECT GROUP_CONCAT(b.biblionumber SEPARATOR ', ') AS biblionumbers,
>> b.title, b.author, GROUP_CONCAT(i.isbn SEPARATOR ', ') AS isbns
>> FROM biblio b
>> LEFT JOIN biblioitems i ON (i.biblionumber=b.biblionumber)
>> GROUP BY CONCAT(substr(b.title,0,9),"/",i.isbn)
>> HAVING COUNT(CONCAT(substr(b.title,0,9),"/",i.isbn))>1
>
>
> I think you should be able to use
>
> having count(*) > 1
>>
>>
>> We're a coop, however, so it would be helpful to limit the results to
>> cases where our particular library owns at least one of the associated
>> items.
>>
>> Adding the following lines did not provide correct results, unfortunately:
>>
>> LEFT JOIN items m ON (m.biblionumber=b.biblionumber)
>> WHERE m.homebranch = <>
>
>
> I think the join is conflicting with your group by. Try using an exists()
> statement in your where clause:
>
> WHERE EXISTS(
> select * from items where b.biblionumber = items.biblionumber and
> items.homebranch = <>
> )
>
> This should be faster than a subquery because it will stop when it hits the
> first item that makes the query in the exists statement true.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Duplicate ISBN report modification

[Cab Vinton]

Thank you, MJ.

Unfortunately, neither hardcoding the branch location nor changing the
location of the JOIN statement changes anything.

I think what's happening is that, because of the WHERE condition, my
revision is simply a very inefficient way of catching instances where
a particular branch 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


On Wed, Aug 15, 2018 at 7:06 AM, MJ Ray  wrote:
> I'm a bit rusty on reports but could <> be
> replaced by the code for your library (like 'MAIN' in the sample data)
> or m.homebranch IN ('BRA1','BRA2') if you want to match multiple
> branches?
>
> And I suspect that LEFT JOIN may be position sensitive but I'm not sure
> what position would be best for either accuracy or performance.
>
> I am probably misunderstanding how/why the attempted change didn't work.
>
> Hope that helps,
> --
>
> MJR http://mjr.towers.org.uk/
> Member of http://www.software.coop/ (but this email is my personal view
> only)
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Duplicate ISBN report modification

[Cab Vinton]

Hi, All --

We're using the following report to identify records w/ duplicate ISBNs.

SELECT GROUP_CONCAT(b.biblionumber SEPARATOR ', ') AS biblionumbers,
b.title, b.author, GROUP_CONCAT(i.isbn SEPARATOR ', ') AS isbns
FROM biblio b
LEFT JOIN biblioitems i ON (i.biblionumber=b.biblionumber)
GROUP BY CONCAT(substr(b.title,0,9),"/",i.isbn)
HAVING COUNT(CONCAT(substr(b.title,0,9),"/",i.isbn))>1

We're a coop, however, so it would be helpful to limit the results to
cases where our particular library owns at least one of the associated
items.

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 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

[Cab Vinton]

All Holds, Patrons, and Circulation queries are now on their
respective dedicated pages.

I've also made a first attempt at adding subheadings to the Catalog/
Bibliographic Reports.

There are 140 of these, so a separate page may make sense for these
queries as well. (By way of comparison, 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

[Cab Vinton]

> If you click into those sections, You'll see that each query has been
> replaced by a link to the respective query on the Holds, Patrons and
> Circulation page -- this means that if people have links bookmarked, they'll
> get people to a link to the right page, but the queries are no longer
> duplicated -- we may want to change the page so that we use anchors rather
> than headers so that the individual queries don't show up in the table of
> contents on the main page.

The new Holds/ Patrons/ Circ pages have a number of queries not on the
main page, & until I moved them over, there were 20 or so queries on
the main page that weren't on the HPC pages.

In other words, it was a mess. I think it's a bad idea to continue to
have 2 locations for the same queries. Actually, it seems rather
pointless. The Note at the top of the main page asks folks to add new
queries to the appropriate HPC page, but that clearly was not
happening consistently. Bookmarks can & should be updated, & I think
most users would prefer to have a single site to search.

If the HPC sections are not deleted from the main page, within a few
months there'll just be another mess, w/ queries on one page, but not
the other. In addition, if the queries are on a dedicated page there's
one fewer outline level to deal with.

> I think that we should also put a "Works in version" row in the template.
> That will help some 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
___
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

[Cab Vinton]

Hi, All --

All Holds, Patrons, & Circulation reports have been copied over from
the main wiki reports page to the appropriate dedicated page.

I believe it should now be safe to delete these sections from the main
page (sections 2, 3, & 4, respectively). This should free up quite a
bit 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.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

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

[Cab Vinton]

Thank you, Barton.

I'm not totally clear on the future status of the Reports wiki. Is the
idea that it would be completely replaced by the Mana KB?

The wiki is very easy to use & I suspect a resource that many
librarians besides myself find very valuable (including librarians
using non-standard versions of Koha).

Mana may prove to be the same, but I don't think I have an easy way to
review what it will look like, or what it looks like in its current
state ...

So my initial thought is to just proceed w/ these relatively trivial
edits to the wiki. Will certainly hold off, though, if there's
consensus that it's a waste of time :-)

Cheers,

Cab


On Thu, Jul 19, 2018 at 9:56 AM, Barton Chittenden
 wrote:
> Cab,
>
> the reports wiki is in a state of benign neglect, because of development of
> _mana_, which will create a way for reports to be shared to and imported
> from a central server.
>
> See
>
> https://wiki.koha-community.org/wiki/Recommendation_engine_integrated_with_Mana_project_RFC
>
> https://wiki.koha-community.org/wiki/Mana_central_database
>
> Bug 17047 - Mana Knowledge Base : share data
> (https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17047).
>
> We're still adding queries to the report library and fixing reports as we
> find out that they're broken, but we haven't bulk updated the reports to
> reflect the biblioitems.marcxml -> biblio_metadata.metadata 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. :-)
>
> --Barton
>
> On Thu, Jul 19, 2018 at 8:01 AM, Cab Vinton  wrote:
>>
>> Hi, All --
>>
>> Apologies for the cross-posting.
>>
>> The clean up of the Reports wiki page appears to have got stalled out:
>> https://wiki.koha-community.org/wiki/SQL_Reports_Library
>>
>> (Large no. of duplicate listings of reports for holds, patrons, &
>> circulation (HPC), which also appear on corresponding pages --
>> https://wiki.koha-community.org/wiki/SQL_Reports_Holds, etc.)
>>
>> I've identified the reports on the main page that aren't cross-listed
>> (19 in total). I'd like to relocate these & then delete all the
>> listings under the HPC categories on the main page.
>>
>> I suspect these 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...@lists.koha-community.org
>> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
>> website : http://www.koha-community.org/
>> git : http://git.koha-community.org/
>> bugs : http://bugs.koha-community.org/
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

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

[Cab Vinton]

Wonder how hard it would be implement something like this in Koha:

http://tallons.law.utexas.edu/record=b2070846

(see dark blue Map It! button on the right, next to Status)

This is provided through a commercial product, but the basic
technology doesn't seem all that complicated (from a layman'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, 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] Batch restriction of patrons?

[Cab Vinton]

Re: using the notice triggers to automatically suspend patrons on
their last notice --

Since we're a multi-library system, I assume this means that anyone
who receives a last notice would be restricted?

In other words, this would affect any patron who happened to hold onto
materials too 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?

[Cab Vinton]

On Thu, Jul 5, 2018 at 5:45 PM, Barton Chittenden
 wrote:
> Another possibility would be to use the message triggers and automatically
> suspend patrons on their last notice.

Ah, that's an interesting idea.

For this to work for patrons without emails, would we simply select
the 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?

[Cab Vinton]

Hi, All --

We've used the noissuescharge setting in the Circulation preferences
to prevent patrons from checking items out when their fines exceed a
certain amount.

However, since most of our fines are relatively modest, it may take
several months to reach the noissuescharge cap if a patron only has 1
or 2 items checked out.

There doesn't appear to be a similar setting for blocking patrons when
a particular item becomes long overdue.

We can go into each patron's account & add a manual restriction, but
we generally have several patrons needing this change in status.
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 thanks in advance,

Cab Vinton, Director
Plaistow Public Library
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] MySQL EOL

[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) so shouldn't be an issue
> *fingers crossed* :)
>
> Chris
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] MySQL EOL

[Cab Vinton]

According to https://endoflife.software/applications/databases/mysql,
end of life date for MySQL ver 5.5 is December 2018 -- not too far
off.

Wondering what the roadmap for Koha looks like w/ respect to MySQL.

Versions 5.6 & 5.7 have several years still to go, and EOL for 8.0 is
presumably 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

[Cab Vinton]

> I assume that you were talking about the 'Runtime Variables' section of the
> wiki:
>
> https://wiki.koha-community.org/wiki/SQL_Reports_Library#Runtime_Variables

Yup.

> ... Nick, Jesse (pianohacker) and I have all played with this at one time or
> another, and I think that our consensus was that trying to set runtime
> variables is to avoid having to re-enter run-time parameters is a crapshoot
> -- it's possible to make it work sometimes, but it's hard to get right.
>
> So I think that you'll have to re-enter parameters by hand until Koha 18.05,
> when we get this enhancement that makes the problem go away:
>
> Bug 9634: Allow for parameters re-use on SQL reports
> URL : https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9634
> Priority: P5 - low
> Assigned To : n...@bywatersolutions.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

[Cab Vinton]

Hi, All --

We have a report with the following WHERE clause:

  WHERE b.biblionumber IN (SELECT biblionumber FROM items WHERE
DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND
homebranch='KIMBALL')
  AND b.biblionumber IN (SELECT biblionumber FROM items WHERE
DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND
homebranch='PLAISTOW')
  AND b.biblionumber IN (SELECT biblionumber FROM items WHERE
DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND
homebranch='SANDOWN')

Is there a way to declare & assign variables within a standard report?

I'm familiar w/ the section in the Reports wiki on runtime parameters
& variables 
(https://wiki.koha-community.org/wiki/SQL_Reports_Library#Runtime_Parameters).
I've also played around w/ SET statements. But no luck finding a way
to avoid repeating the date calculation 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
  HAVING count(DISTINCT homebranch) = 3

Thanks in advance for any guidance.

All best,

Cab Vinton
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] Items held by more than one branch

[Cab Vinton]

Thank you, Joy -- I think that did the trick. Nice work!

Cab


On Mon, Apr 23, 2018 at 7:09 PM, Joy Nelson <j...@bywatersolutions.com> wrote:
> Cab -
> This is a little (ok..a lot) quick and dirty, but does return results...
> does this help?
>
> SELECT i.biblionumber,b.title,
> homebranch,itemcallnumber,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
>
>
>
>
> On Mon, Apr 23, 2018 at 5:39 PM, Cab Vinton <bibli...@gmail.com> wrote:
>>
>> Sorry, no dice -- returns a single item :-(
>>
>> The mysteries of SQL ...
>>
>> Cheers,
>>
>> Cab
>>
>>
>> On Mon, Apr 23, 2018 at 5:06 PM, Paul Hoffman <p...@flo.org> 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 than one branch, with separate output for each library's item.
>> >
>> > Put the HAVING clause inside a subquery that determines which bibs'
>> > items should be included -- something like this (untested):
>> >
>> > SELECT b.biblionumber, i.homebranch, t.isbn, b.title, b.author, i.ccode,
>> > i.itype
>> > FROM items i
>> > LEFT JOIN biblio b USING (biblionumber)
>> > LEFT JOIN biblioitems t USING (biblionumber)
>> > WHERE i.itemlost=0 AND i.withdrawn=0
>> > AND b.biblionumber IN (
>> > SELECT b.biblionumber
>> > FROM items i
>> > LEFT JOIN biblio b USING (biblionumber)
>> > WHERE i.itemlost=0 AND i.withdrawn=0
>> > HAVING COUNT(i.itemnumber) > 1
>> > )
>> > ORDER BY b.title
>> >
>> > That's a bunch of data for all items (not lost or withdrawn) on bibs
>> > that have more than one item (not lost or withdrawn).
>> >
>> > HTH,
>> >
>> > Paul.
>> >
>> > --
>> > Paul Hoffman <p...@flo.org>
>> > Software Manager
>> > Fenway Library Organization
>> > 550 Huntington Ave.
>> > Boston, MA 02115
>> > (617) 442-2384 (FLO main number)
>> > ___
>> > Koha mailing list  http://koha-community.org
>> > Koha@lists.katipo.co.nz
>> > https://lists.katipo.co.nz/mailman/listinfo/koha
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>
>
>
>
> --
> Joy Nelson
> Vice President of Implementations
>
> ByWater Solutions
> Support and Consulting for Open Source Software
> Phone/Fax (888)900-8944
> What is Koha?
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

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

[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 <p...@flo.org> 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 than one branch, with separate output for each library's item.
>
> Put the HAVING clause inside a subquery that determines which bibs'
> items should be included -- something like this (untested):
>
> SELECT b.biblionumber, i.homebranch, t.isbn, b.title, b.author, i.ccode, 
> i.itype
> FROM items i
> LEFT JOIN biblio b USING (biblionumber)
> LEFT JOIN biblioitems t USING (biblionumber)
> WHERE i.itemlost=0 AND i.withdrawn=0
> AND b.biblionumber IN (
> SELECT b.biblionumber
> FROM items i
> LEFT JOIN biblio b USING (biblionumber)
> WHERE i.itemlost=0 AND i.withdrawn=0
> HAVING COUNT(i.itemnumber) > 1
> )
> ORDER BY b.title
>
> That's a bunch of data for all items (not lost or withdrawn) on bibs
> that have more than one item (not lost or withdrawn).
>
> HTH,
>
> Paul.
>
> --
> Paul Hoffman <p...@flo.org>
> Software Manager
> Fenway Library Organization
> 550 Huntington Ave.
> Boston, MA 02115
> (617) 442-2384 (FLO main number)
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Set report sort order at runtime

[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),AddedDate)
   WHEN @OrderByColumn='Visible' THEN CONVERT(varchar(2), Visible)
   WHEN @OrderByColumn='AddedBy' THEN AddedBy
   WHEN @OrderByColumn='Title' THEN Title
  END

Ah well.


On Mon, Apr 23, 2018 at 9:31 AM, Owen Leonard  wrote:
>> as SQL turned this into:
>>
>> ORDER BY 'itemcallnumber'
>
> As you have discovered, Koha will try to put your strings into quotes
> on the assumption that you're submitting something for some kind of
> matching purposes.
>
> I agree that it would be a nice option for parameters.
>
>  -- Owen
>
> --
> Web Developer
> Athens County Public Libraries
> http://www.myacpl.org
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

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

[Cab Vinton]

Thank you, Jonathan.

That fixes one problem (output now appears to be for the right bib
numbers), but the GROUP function introduces another issue -- namely, it
collapses the results so that just one item is show for each bib number:

14820 PLAISTOW 1572151714 : '20s & '30s style / Horsham, Michael. NONFICTION
BOOK

when what I originally was after was:

14820 PLAISTOW 1572151714 : '20s & '30s style / Horsham, Michael. NONFICTION
BOOK
14820 KIMBALL1572151714 : '20s & '30s style / Horsham, Michael.
NONFICTION BOOK

Looks like I'll have to find 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, ordering source, etc.)

Thanks again,

Cab Vinton



On Mon, Apr 23, 2018 at 10:14 AM, Jonathan Druart <
jonathan.dru...@bugs.koha-community.org> wrote:

> I'd say you are missing a group by.
>
> On Mon, 23 Apr 2018 at 10:19 Cab Vinton <bibli...@gmail.com> wrote:
>
>> Hi, all--
>>
>> Another report question...
>>
>> Trying to write a report that will provide details for items held by
>> more than one branch, with separate output for each library's item.
>>
>> Including the statement HAVING COUNT(i.itemnumber) > 1 collapses the
>> results to just one title. (Strangely, the bib returned only has a
>> single item attached.)
>>
>> I'm missing some basic feature of how SQL operates :-(
>>
>> SELECT b.biblionumber,i.homebranch,t.isbn,b.title,b.author,i.ccode,
>> i.itype
>> FROM items i
>> LEFT JOIN biblio b USING (biblionumber)
>> LEFT JOIN biblioitems t USING (biblionumber)
>> WHERE i.itemlost=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://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Items held by more than one branch

[Cab Vinton]

Hi, all--

Another report question...

Trying to write a report that will provide details for items held by
more than one branch, with separate output for each library's item.

Including the statement HAVING COUNT(i.itemnumber) > 1 collapses the
results to just one title. (Strangely, the bib returned only has a
single item attached.)

I'm missing some basic feature of how SQL operates :-(

SELECT b.biblionumber,i.homebranch,t.isbn,b.title,b.author,i.ccode,i.itype
FROM items i
LEFT JOIN biblio b USING (biblionumber)
LEFT JOIN biblioitems t USING (biblionumber)
WHERE i.itemlost=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://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Set report sort order at runtime

[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 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] Report for holds count by bib record & branch

[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.

Cheers,

Cab Vinton
Plaistow Public Library


On Tue, Mar 27, 2018 at 12:30 PM, Cab Vinton <bibli...@gmail.com> wrote:
> Hi, All --
>
> I'm trying to create a report that will give me hold counts broken down by
> bib record and the patron's branch.
>
> I believe what I have is pretty close, but some of the output omits the item
> type information.
>
> This is what I have:
>
> SELECT count(borrowers.branchcode) AS Holds, borrowers.branchcode,
> biblio.title, biblio.biblionumber, biblio.datecreated, items.itype
> FROM reserves
> LEFT JOIN borrowers USING (borrowernumber)
> LEFT JOIN biblio USING (biblionumber)
> LEFT JOIN items USING (itemnumber)
> GROUP BY biblio.biblionumber, borrowers.branchcode
> ORDER BY count(borrowers.branchcode) DESC, biblio.title
>
> And some sample output:
>
> Holdsbranchcodetitlebiblionumberdatecreateditype
> 6KIMBALLLilac girls :1420692016-04-19BOOK
> 6KIMBALLThe woman in the window :1581622018-01-03NEWBOOK
> 6KIMBALLVictoria. The complete second season /1585952018-01-30NEWMOVIE
> 4SANDOWNAccidental heroes :1571562017-10-28
> 4PLAISTOWFall from grace :1560952017-09-12
> 4KIMBALLThe great alone /1560892017-09-12
> 3SANDOWNI've got my eyes on you :1571502017-10-28
> 3PLAISTOWLilac girls :1420692016-04-19
> 3SANDOWNSweet vengeance /1571522017-10-28NEWBOOK
>
> Can anyone provide 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] Report for holds count by bib record & branch

[Cab Vinton]

Hi, All --

I'm trying to create a report that will give me hold counts broken down by
bib record and the patron's branch.

I believe what I have is pretty close, but some of the output omits the
item type information.

This is what I have:

SELECT count(borrowers.branchcode) AS Holds, borrowers.branchcode,
biblio.title, biblio.biblionumber, biblio.datecreated, items.itype
FROM reserves
LEFT JOIN borrowers USING (borrowernumber)
LEFT JOIN biblio USING (biblionumber)
LEFT JOIN items USING (itemnumber)
GROUP BY biblio.biblionumber, borrowers.branchcode
ORDER BY count(borrowers.branchcode) DESC, biblio.title

And some sample output:

Holdsbranchcodetitlebiblionumberdatecreateditype
6 KIMBALL Lilac girls : 142069 2016-04-19 BOOK
6 KIMBALL The woman in the window : 158162 2018-01-03 NEWBOOK
6 KIMBALL Victoria. The complete second season / 158595 2018-01-30 NEWMOVIE
4 SANDOWN Accidental heroes : 157156 2017-10-28
4 PLAISTOW Fall from grace : 156095 2017-09-12
4 KIMBALL The great alone / 156089 2017-09-12
3 SANDOWN I've got my eyes on you : 157150 2017-10-28
3 PLAISTOW Lilac girls : 142069 2016-04-19
3 SANDOWN Sweet vengeance / 157152 2017-10-28 NEWBOOK

Can anyone provide 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

[Cab Vinton]

Hi, All --

The following report takes several minutes to run, which leads to me
the sad probability that my SQL skillz are ... weak:

SELECT b.title, count(s.datetime) AS circs
FROM statistics s
JOIN (
  SELECT itemnumber, biblionumber, homebranch, itype FROM deleteditems
  UNION
  SELECT itemnumber, biblionumber, homebranch, itype FROM items
) AS all_items USING (itemnumber)
LEFT JOIN biblio b ON (b.biblionumber=all_items.biblionumber)
WHERE all_items.itype = 'MAGAZINE' AND all_items.homebranch = <>
 AND s.itemnumber IS NOT NULL AND s.type IN ('issue')
 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,

Cab Vinton
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] Statement of responsibility display w/ movies

[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
subfield.

Or for that matter, how one would specify that it was not to be
displayed on the search results page.

Above my pay grade, so will be following up w/ our support company :-)

Cheers,

Cab
___
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

[Cab Vinton]

Hmm ... Doesn't appear to be that simple --

According to the manual, "At this time the only keyword in use is 'subtitle.'"

And

"This tool only effects [sic] sites that are not using the XSLT Stylesheets."

Of course, our site uses stylesheets.

Good news is, 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

[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 the 245 c subfield but only for particular item types
>> (i.e., movies).
>
> Keywords to MARC Mapping can be configured per framework, so you could
> set up a separate framework for those items and select a different set
> of subfields to display:
>
> https://koha-community.org/manual/16.11/html/ch02s04.html#keywordmapping
>
>   -- Owen
>
> --
> Web Developer
> Athens County Public Libraries
> http://www.myacpl.org
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Statement of responsibility display w/ movies

[Cab Vinton]

This falls under the minor annoyance category, but user experience is
important so ...

Statements of responsibility for movies tend to be huge affairs -- a
tedious list of studios, producers, writers, directors, etc. -- like
so:

http://catalog.southernnh.bywatersolutions.com/cgi-bin/koha/opac-search.pl?q=jason+bourne

I'm fairly confident 99%+ of our patrons don't care about this
information & would prefer to not see it cluttering up the initial
results screen.

So I'm wondering if there's an elegant way of suppressing the
information in the 245 c subfield but 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  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Preserving circ history of deleted item

[Cab Vinton]

Hi, Ellen --

I'm far from an expert, but this should be pretty close to the truth :-)

There is a deleteditems table which retains some basic circ history
data -- no. of issues & renewals, date last borrowed, for example.

The statistics table retains *all* circulation transaction data, even
for deleted items, records & borrowers.

Writing reports to include the history of deleted items takes a little
bit of extra work, but the data is there. A lot depends on how you
want to access it.

Finally, there are ways of suppressing the display of withdrawn items
in the catalog, so that 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 <ellen.k...@goddard.edu> wrote:
> Hello,
> When I replace an item with an identical item (with the same bib record),
> how do I keep the circ. history for the work? (For example, if we want to
> gauge our patrons' interest in "Pedagogy of the Oppressed," but have to
> replace our battered copy, how do we preserve the circ. history?)
>
>  If I delete the old item, will the circ. history disappear? If I withdraw
> it, it shows in the catalog as "withdrawn," which we don't want. I know how
> to suppress a record, but not on the item level only.
>
> Thanks!
>
> Ellen Kaye, MLIS   *ellen.k...@goddard.edu <paula.tambure...@goddard.edu>*
> Technical Services Coordinator
> Eliot Pratt Library, Goddard College
> 123 Pitkin Road, Plainfield, VT  05667
> 802.322.1602 <%28802%29%20322-1607> or 802-454.8311 x216
>
> Website: http://www.goddard.edu/lits  Catalog:
> https://catalog.goddard.edu
> Find Us On Facebook: http://www.facebook.com/EliotDPrattLibrary
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Lowering max reserves/ holds

[Cab Vinton]

Hi, All --

Our maxreserves is currently set for 50 items, that is patrons can
have up to 50 holds at a time.

Turns out we have a patron who actually comes close to reaching this
limit on a regular basis -- almost continuously in fact.

Since staff are spending an inordinate amount of time dealing with one
patron's holds, we'd like to lower the limit to something more
reasonable, perhaps 20 or 25.

Before doing so, however, we want to make sure there aren't any hidden
potholes waiting for us.

These are the questions that have occurred to us, but if you have
other thoughts or advice, please feel free to share :-)

1./  Is there a message when patrons attempt to place one more hold
than is allowed? If so, it seems that the message is not customizable.

2./  Can the the hold limit be overridden by staff?

Thanks for any tips you can provide.

Even if you don't have any 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
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Inventory/ shelf-reading

[Cab Vinton]

Koha's inventory utility is handy but seems to be missing one critical
element, namely the ability to flag items out of call number order.

The utility also does not generate a downloadable file. This means
copying  pasting the results into a spreadsheet  some rather tedious
data clean-up to get workable data.

Has anyone come up with a streamlined method for using the inventory
tool to help identify mis-shelved items?

I'm on the verge of getting into writing a macro, but my VBA skills
are very rusty  I'm always happy to avoid reinventing the wheel.

For 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 best,

Cab Vinton, Director
Plaistow Public Library
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Statistics for inter-branch activity

[Cab Vinton]

Hi, All --

We're part of a 3-library coop where patrons have reciprocal borrowing
privileges at any of the 3 libraries.

Ideally, I'd like to be able to generate summary statistics on how
patrons from each library are using these privileges, based on
patrons' home library, the owner of items checked out,  where the
transaction physically took place.

I expected the following report to do this for me:

SELECT s.datetime, i.itemcallnumber, i.itype, i.ccode, i.barcode,
b.categorycode, s.type, b.cardnumber, s.branch, b.branchcode,
i.homebranch
FROM statistics s
LEFT JOIN items i on (i.itemnumber = s.itemnumber)
LEFT JOIN borrowers b ON (s.borrowernumber = b.borrowernumber)
WHERE s.type in ('issue','renew','localuse') AND s.datetime BETWEEN
Between (-mm-dd) AND and (-mm-dd)
ORDER BY i.itype, i.ccode, i.cn_sort asc

Unfortunately, for 17% of the transactions the home library of the
patron is missing (b.branchcode). In our case, this amounts to some
33,000 transactions for 2013.

The vast majority of these transactions (98%) are of type Local Use.
(We have the RecordLocalUseOnReturn preference set to 'Record' for
when items not checked 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
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Report guidance

[Cab Vinton]

Hi, All --

We're in a small consortium of three libraries  I'm trying to write a
report providing stats as follows --

Checkouts, renewals  local use of materials owned by a particular
branch by patrons belonging to a particular branch

The following report is generating numbers an order of magnitude too small --

SELECT s.datetime, i.itemcallnumber, i.itype, i.ccode, i.barcode,
b.categorycode, s.type
FROM statistics s
LEFT JOIN items i on (i.itemnumber = s.itemnumber)
LEFT JOIN borrowers b ON (s.borrowernumber = b.borrowernumber)
WHERE i.homebranch = 'PLAISTOW' 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 assistance or pointers.

All best,

Cab Vinton, Director
Plaistow Public Library
Plaistow, NH
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Report guidance

[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 = Owning Library|branches AND b.branchcode =
Borrower Home Branch|branches

Sheesh. Long week ...

Thank you, KB.

Cab Vinton
Plaistow PL


On Fri, Feb 21, 2014 at 3:06 PM, Katelyn Browne kbro...@ccpcs.org wrote:
 Hi Cab,

 If I understand correctly, you want a list of Plaistow items checked out to
 Plaistow patrons, so you should have b.branchcode = 'PLAISTOW'.

 The way you have it set up, it's finding Plaistow books checked out to
 non-Plaistow patrons. (Or is that really what you want, and the numbers are
 still too small?)

 --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, Feb 21, 2014 at 2:29 PM, Cab Vinton bibli...@gmail.com wrote:

 Hi, All --

 We're in a small consortium of three libraries  I'm trying to write a
 report providing stats as follows --

 Checkouts, renewals  local use of materials owned by a particular
 branch by patrons belonging to a particular branch

 The following report is generating numbers an order of magnitude too small
 --

 SELECT s.datetime, i.itemcallnumber, i.itype, i.ccode, i.barcode,
 b.categorycode, s.type
 FROM statistics s
 LEFT JOIN items i on (i.itemnumber = s.itemnumber)
 LEFT JOIN borrowers b ON (s.borrowernumber = b.borrowernumber)
 WHERE i.homebranch = 'PLAISTOW' 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 assistance or pointers.

 All best,

 Cab Vinton, Director
 Plaistow Public Library
 Plaistow, NH
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Circulation/ fines rules

[Cab Vinton]

With a 3-branch library system  the following rules, am I right in
assuming that rows 2 thru 4 are redundant  can be safely deleted?
(Settings for all four rows are identical.)

 Library Patron category Item type Loan period Unit Fine amount Fine
charging interval Overdue fines cap (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
Plaistow, NH
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] New SQL Report - Permissions Check

[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
'Card Number',categorycode,userid AS 'UserID',branchcode AS
'Library',Super AS 'superlibrarian',A AS 'circulate',SubA AS
'circulate subs',B AS 'catalogue',C AS 'parameters',SubC AS
'parameters subs',D AS 'borrowers',E AS 'permissions',F AS
'reserveforothers',SubF AS 'reserveforothers subs',G AS 'borrow',I AS
'editcatalogue',SubI AS 'editcatalogue subs',J AS 'updatecharges',K AS
'acquisition',SubK AS 'acquisition subs',L AS 'management',M AS
'tools',SubM1 AS 'tools subs (Pt 1)',SubM2 AS 'tools subs (Pt 2)',N AS
'editauthorities',O AS 'serials',SubO AS 'serials subs',P AS
'reports',SubP AS 'reports subs',Q AS 'staffaccess' FROM (SELECT
b.surname,b.firstname,b.cardnumber,b.userid,b.branchcode,b.categorycode,@CHECK:=b.flags
AS 'CheckQ',IF(@Check-131072=0,@Q:=On,@Q:=Off) AS 'Q',
IF(@Check-131072=0,@CHECK:=@Check-131072,@CHECK) AS
'CheckP',IF(@Check-65536=0,@P:=On,@P:=Off) AS 'P',(SELECT
group_concat(up.code) FROM user_permissions up WHERE
up.module_bit='16' AND borrowernumber=b.borrowernumber) AS SubP,
IF(@Check-65536=0,@CHECK:=@Check-65536,@CHECK) AS
'CheckO',IF(@Check-32768=0,@O:=On,@O:=Off) AS 'O',(SELECT
group_concat(up.code) FROM user_permissions up WHERE
up.module_bit='15' AND borrowernumber=b.borrowernumber) AS SubO,
IF(@Check-32768=0,@CHECK:=@Check-32768,@CHECK) AS
'CheckN',IF(@Check-16384=0,@N:=On,@N:=Off) AS 'N',
IF(@Check-16384=0,@CHECK:=@Check-16384,@CHECK) AS
'CheckM',IF(@Check-8192=0,@M:=On,@M:=Off) AS 'M',(SELECT
group_concat(up.code) FROM user_permissions up WHERE
up.module_bit='13' AND borrowernumber=b.borrowernumber AND up.code
BETWEEN a% AND i%) AS SubM1,(SELECT group_concat(up.code) FROM
user_permissions up WHERE up.module_bit='13' AND
borrowernumber=b.borrowernumber AND up.code BETWEEN j% AND z%) AS
SubM2, IF(@Check-8192=0,@CHECK:=@Check-8192,@CHECK) AS
'CheckL',IF(@Check-4096=0,@L:=On,@L:=Off) AS 'L',
IF(@Check-4096=0,@CHECK:=@Check-4096,@CHECK) AS
'CheckK',IF(@Check-2048=0,@K:=On,@K:=Off) AS 'K',(SELECT
group_concat(up.code) FROM user_permissions up WHERE
up.module_bit='11' AND borrowernumber=b.borrowernumber) AS SubK,
IF(@Check-2048=0,@CHECK:=@Check-2048,@CHECK) AS
'CheckJ',IF(@Check-1024=0,@J:=On,@J:=Off) AS 'J',
IF(@Check-1024=0,@CHECK:=@Check-1024,@CHECK) AS
'CheckI',IF(@Check-512=0,@I:=On,@I:=Off) AS 'I',(SELECT
group_concat(up.code) FROM user_permissions up WHERE up.module_bit='9'
AND borrowernumber=b.borrowernumber) AS SubI,
IF(@Check-512=0,@CHECK:=@Check-512,@CHECK) AS
'CheckH',IF(@Check-256=0,@H:=On,@H:=Off) AS 'H',
IF(@Check-256=0,@CHECK:=@Check-256,@CHECK) AS
'CheckG',IF(@Check-128=0,@G:=On,@G:=Off) AS 'G',
IF(@Check-128=0,@CHECK:=@Check-128,@CHECK) AS
'CheckF',IF(@Check-64=0,@F:=On,@F:=Off) AS 'F',(SELECT
group_concat(up.code) FROM user_permissions up WHERE up.module_bit='6'
AND borrowernumber=b.borrowernumber) AS SubF,
IF(@Check-64=0,@CHECK:=@Check-64,@CHECK) AS
'CheckE',IF(@Check-32=0,@E:=On,@E:=Off) AS 'E',
IF(@Check-32=0,@CHECK:=@Check-32,@CHECK) AS
'CheckD',IF(@Check-16=0,@D:=On,@D:=Off) AS 'D',
IF(@Check-16=0,@CHECK:=@Check-16,@CHECK) AS
'CheckC',IF(@Check-8=0,@C:=On,@C:=Off) AS 'C',(SELECT
group_concat(up.code) FROM user_permissions up WHERE up.module_bit='3'
AND borrowernumber=b.borrowernumber) AS SubC,
IF(@Check-8=0,@CHECK:=@Check-8,@CHECK) AS
'CheckB',IF(@Check-4=0,@B:=On,@B:=Off) AS 'B',
IF(@Check-4=0,@CHECK:=@Check-4,@CHECK) AS
'CheckA',IF(@Check-2=0,@A:=On,@A:=Off) AS 'A',(SELECT
group_concat(up.code) FROM user_permissions up WHERE up.module_bit='1'
AND borrowernumber=b.borrowernumber) AS SubA,
IF(@Check-2=0,@CHECK:=@Check-2,@CHECK) AS
'CheckSuper',IF(@Check0,On,Off) AS Super FROM borrowers b LEFT
JOIN categories USING (categorycode)) AS MainFlags WHERE
MainFlags.Super=On OR MainFlags.E=On OR MainFlags.M=On OR
MainFlags.SubM1 LIKE %delete_anonymize_patrons% OR MainFlags.SubM1
LIKE %edit_calendar% OR MainFlags.SubM1 LIKE %edit_news% OR
MainFlags.SubM1 LIKE %edit_notice_status_triggers% OR
MainFlags.SubM1 LIKE %edit_notices% OR MainFlags.SubM1 LIKE
%edit_news% OR MainFlags.SubM1 LIKE %items_batchdel% OR
MainFlags.SubM1 LIKE %schedule_tasks% OR MainFlags.SubM1 LIKE
%view_system_logs% OR MainFlags.SubP LIKE %create_reports% ORDER
BY surname, firstname ASC
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] SQL Report Update

[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 (biblionumber)
WHERE i.itemnumber NOT IN (SELECT itemnumber FROM issues WHERE
itemnumber IS NOT NULL)
  AND i.itemnumber NOT IN (SELECT itemnumber FROM
old_issues WHERE itemnumber IS NOT NULL)
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

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

[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
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] New Report Update

[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 replacement for the built in report until the bug
   is fixed.
   - *Status:* Complete

SELECT items.location, authorised_values.lib_opac AS 'COLLECTIONCODE',
items.itemcallnumber, items.enumchron, biblio.author, biblio.title,
 items.barcode
  FROM reserves JOIN biblio ON reserves.biblionumber = biblio.biblionumber
 JOIN borrowers ON reserves.borrowernumber = borrowers.borrowernumber
 JOIN items ON biblio.biblionumber = items.biblionumber
 LEFT JOIN hold_fill_targets ON reserves.biblionumber =
hold_fill_targets.biblionumber
 AND reserves.borrowernumber = hold_fill_targets.borrowernumber
 LEFT JOIN branchtransfers ON items.itemnumber = branchtransfers.itemnumber
 LEFT JOIN authorised_values ON items.ccode =
authorised_values.authorised_value
  WHERE ((authorised_values.category)=ccode)
 AND ((reserves.reservedate)=now())
 AND ((reserves.suspend)=0)
 AND ((reserves.waitingdate) IS NULL)
 AND ((reserves.priority)=1)
 AND ((items.notforloan)=0)
 AND ((items.damaged)=0)
 AND ((items.itemlost)=0)
 AND ((items.wthdrawn)=0)
 AND ((items.onloan) IS NULL)
 AND ((reserves.itemnumber) IS NOT NULL
 AND (reserves.itemnumber)=items.itemnumber)
 AND ((items.itype)REF)
 AND ((hold_fill_targets.itemnumber) IS NULL)
 OR (authorised_values.category=ccode
 AND hold_fill_targets.itemnumber=items.itemnumber)
  GROUP BY items.holdingbranch, authorised_values.lib_opac,
items.itemcallnumber, items.enumchron, biblio.author, biblio.title,
items.barcode, reserves.branchcode
  HAVING items.holdingbranch=Branch filled at|branches
 AND Count(branchtransfers.datesent)=Count(branchtransfers.datearrived)
  ORDER BY items.location, authorised_values.lib_opac,
items.itemcallnumber, items.enumchron, biblio.author, biblio.title ASC
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] New Report Update

[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
   - *Status:* Complete

SELECT p.cardnumber, p.surname, p.firstname,
   p.phone, p.address, p.city, p.zipcode,
   c.date_due,
   (TO_DAYS(curdate())-TO_DAYS( date_due)) AS 'days overdue',
   i.itype, b.title, b.author, i.itemcallnumber,
   i.barcode, COUNT(h.biblionumber) AS 'holds' FROM borrowers
pLEFT JOIN issues c USING (borrowernumber) LEFT JOIN items i USING
(itemnumber) LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber)
LEFT JOIN reserves h ON (b.biblionumber=h.biblionumber) WHERE
c.branchcode = Branch Code|branches AND c.date_due 
curdate()GROUP BY h.biblionumber HAVING COUNT(h.biblionumber)  0
ORDER BY p.surname ASC, c.date_due ASC
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] New Report Update

[Cab Vinton]

I've setup an alert on the Koha Reports wiki page --
http://wiki.koha-community.org/wiki/SQL_Reports_Library --  thought others
might also be interested in hearing about new reports as they're added.

I'm using a Chrome extension, Page Monitor to get the updates, available
here:-
https://chrome.google.com/webstore/detail/page-monitor/pemhgklkefakciniebenbfclihhmmfcdhttps://chrome.google.com/webstore/detail/page-monitor/pemhgklkefakciniebenbfclihhmmfcd?hl=en

Unless there's an overwhelming hue  cry to cease  desist, I'll continue
with updates as they happen.

Cheers,

Cab Vinton
Sanbornton Public Library

Holds Ratio by Homebranches

   - *Developer:* George H. Williams - Latah County Library District
   - *Module:* Holds
   - *Purpose:* Essentially the same as Hold Ratios in the circulation
   reports but with item Homebranch information instead of Holdingbranch
   - *Notes:* I didn't build the link to the biblio in the title field (as
   it is in the circulation report) so it would be easy for our staff to
   download the file as a spreadsheet if necessary. I also included some very
   basic 'notforloan' data for their information.
   - *Status:* Complete

SELECT count(DISTINCT reserves.borrowernumber) AS HOLDCOUNT,
 count(DISTINCT items.itemnumber) AS ITEMCOUNT,
 (COUNT(DISTINCT reserves.borrowernumber) / count(DISTINCT
items.itemnumber)) AS RATIO,
 biblio.title,
 CONCAT( 'a
href=\/cgi-bin/koha/catalogue/detail.pl?biblionumber=',
biblio.biblionumber,'\ target=_blank', biblio.biblionumber, '/a'
) AS 'LINK_TO_BIBLIO',
 GROUP_CONCAT(DISTINCT items.homebranch SEPARATOR ' // ') AS HOMEBRANCHES,
 GROUP_CONCAT(DISTINCT items.location SEPARATOR ' // ') AS LOCATIONS,
 GROUP_CONCAT(DISTINCT items.itype SEPARATOR ' // ') AS ITYPES,
 GROUP_CONCAT(DISTINCT items.itemcallnumber SEPARATOR ' // ') AS
CALLNUMBERS,
 GROUP_CONCAT(DISTINCT items.notforloan SEPARATOR ' // ') AS NOTLOAN
  FROM  reserves LEFT JOIN items ON items.biblionumber=reserves.biblionumber
 LEFT JOIN biblio ON reserves.biblionumber=biblio.biblionumber
  WHERE items.itemlost=0
 AND items.damaged=0
  GROUP BY biblio.biblionumber
  HAVING (COUNT(DISTINCT reserves.borrowernumber) / count(DISTINCT
items.itemnumber))3
  ORDER BY RATIO DESC
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha Usage Examples

[Cab Vinton]

Boston University's British Programmes is on Koha --

http://library.bu-london.co.uk/

Marshall Breeding's lib-web-cats is an excellent source for answering
this type of question:

http://www.librarytechnology.org/libwebcats/

A quick search did not bring up any other Koha libraries 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

[Koha] Z39.50 issues

[Cab Vinton]

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, 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] Z39.50 issues

[Cab Vinton]

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] Import matching rule for 001 tag

[Cab Vinton]

I'm having trouble getting this to work with the following settings:

Search index: Control-number
Score:  101
Tag: 001
Subfields: [blank]
Offset: 0
Length: 0 [blank does not work either]
Normalization rule: Control-number

I found an old post from Galen suggesting that that the Length
parameter 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 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] Movie cover images

[Cab Vinton]

We don't subscribe to any enhanced content services, so Amazon is our
only feasible source for movie cover images in the preferences.

Amazon does not seem to assign ISBNs to movies, however, only ASINs.

Has anyone found a way of getting images to display correctly using
the ASIN, UPC, or 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 fast!
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Analytic records question

[Cab Vinton]

We're planning on using Koha's analytic records to handle cataloging
of our ereaders and the ebooks loaded onto them.

(Info on analytic records here:
http://manual.koha-community.org/3.8/en/cataloging.html#cataloganalytics)

I'm able to link our ebook record to the record for our ereader. When
I check out the ereader, it is correctly checked out in both the staff
 public interfaces, as expected.

The record for the ebook, however, shows that it is still available
(while also showing that the ereader is checked out). Is this the
expected behavior? Our preference would be for the ebook to show as
checked out as well, even though there's no guarantee that this
particular item was desired or read by the patron and we may have to
make adjustments to our circulation statistics.

Link to the ebook record:
http://catalog.splnh.com/cgi-bin/koha/opac-detail.pl?biblionumber=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  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Analytic records question

[Cab Vinton]

I deleted the ebook item  now everything is working as it should:

http://staff.splnh.com/cgi-bin/koha/catalogue/detail.pl?biblionumber=25778

I was indeed confused about how analytic records should be set up.

A happy camper now :-)

Thanks you, Bernardo  Jared, for the prompt responses.

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
bgkrie...@gmail.com wrote:
 Cab,
 perhaps I'm wrong, but you have added a proper item with his own call
 number to your record Left behind...,
 and another virtual item when you link that record as an analytic of the 
 nook.

 So Koha shows that you have 2 items, one in the nook and another that
 is physically present.
 That last is shown as available.

 Is my understanding that you must not add a item to the analytic
 record, because is a subset of the physical item (nook).

 773 is repeatable, and the procedure shown in the manual let you add
 as many virtual items as necessary. Then you will have available (or
 not) items depending on the nooks availability.

 Regards,
 Bernardo
 --
 Bernardo Gonzalez Kriegel
 bgkrie...@gmail.com


 On Thu, Jan 10, 2013 at 12:26 AM, Cab Vinton bibli...@gmail.com wrote:
 We're planning on using Koha's analytic records to handle cataloging
 of our ereaders and the ebooks loaded onto them.

 (Info on analytic records here:
 http://manual.koha-community.org/3.8/en/cataloging.html#cataloganalytics)

 I'm able to link our ebook record to the record for our ereader. When
 I check out the ereader, it is correctly checked out in both the staff
  public interfaces, as expected.

 The record for the ebook, however, shows that it is still available
 (while also showing that the ereader is checked out). Is this the
 expected behavior? Our preference would be for the ebook to show as
 checked out as well, even though there's no guarantee that this
 particular item was desired or read by the patron and we may have to
 make adjustments to our circulation statistics.

 Link to the ebook record:
 http://catalog.splnh.com/cgi-bin/koha/opac-detail.pl?biblionumber=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  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

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

[Cab Vinton]

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!
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Import patrons tool

[Cab Vinton]

Am I correct in assuming that this tool can only be used for batch
updating of patron info if all of the existing info for each patron is
included in the CSV file to be uploaded?

In other words, I can't simply provide the bare minimum info  then
whatever new info is desired because all 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.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Import patrons tool

[Cab Vinton]

Whoops. I asked a similar question on the list 3 years ago  the
answer is that fields will not be overwritten with null values as long
as those columns are not included in the CSV file.

So as long as you have the minimum fields required, the Patron Import
tool can be used to update only select fields.

Minimum fields = borrownumber or cardnumber + branchcode +
categorycode + any fields marked as mandatory under the
BorrowerMandatoryField global preference.

Our plan is to update patron records with default userids  passwords
 then send out an email encouraging folks to log 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 bibli...@gmail.com wrote:
 Am I correct in assuming that this tool can only be used for batch
 updating of patron info if all of the existing info for each patron is
 included in the CSV file to be uploaded?

 In other words, I can't simply provide the bare minimum info  then
 whatever new info is desired because all 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.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Merging items on same record?

[Cab Vinton]

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

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] Acquisitions module

[Cab Vinton]

We have never used Koha's acquisitions module.

If you're on version 3.4 or higher  are using the module, I'd be
curious to learn more about your experience.

Has it worked well for you? Any tips, caveats or glitches to be aware of?

Happy to compile  share any off-list 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

[Koha] Batch item modification problem

[Cab Vinton]

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 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

[Cab Vinton]

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 bibli...@gmail.com wrote:
 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 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

[Koha] Stable vs maintenance releases?

[Cab Vinton]

Can someone explain the difference between these two?

http://download.koha-community.org/ lists these as 3.8.3 (stable) and
3.6.7 (maintenance) ...

I would have thought that a maintenance release is done on top of a
stable release, comprising minor bug fixes and the like.

And how is it determined what the latest stable release is? I notice
that Equinox's support page is still listing 3.4.1 as the current
stable version. Is this something that varies from support company to
support company, depending on their confidence in a particular
release, their philosophy 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

[Koha] Spell-check/ Did you mean

[Cab Vinton]

We're still on version 3.4  searching for nature defecit fails to
bring up the title Last child in the woods : saving our children from
nature-deficit disorder in both the staff  public catalog search.

We have the QueryFuzzy preference enabled under Search 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 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

[Cab Vinton]

It occurred to me to check ByWater's online demo --
http://intranet.bywatersolutions.com --  NATURE DEFECIT did retrieve
the title in question.

So, I'm hoping this issue will be resolved once we upgrade to 3.8.

Hope the crickets doesn't mean that the zombie apocalypse isn'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] Inactive borrowers report

[Cab Vinton]

The SQL Reports Library contains a couple of reports for inactive borrowers:

http://wiki.koha-community.org/wiki/SQL_Reports_Library#Inactive_Borrowers
SELECT DISTINCT borrowers.surname, borrowers.firstname,
borrowers.cardnumber, borrowers.email
FROM borrowers
WHERE NOT EXISTS (SELECT borrowernumber FROM statistics WHERE
borrowers.borrowernumber = borrowernumber AND statistics.datetime =
'-MM-DD')

http://wiki.koha-community.org/wiki/SQL_Reports_Library#Patrons_with_No_Checkouts
SELECT surname, firstname, cardnumber
FROM borrowers
WHERE borrowernumber NOT IN
 (SELECT DISTINCT borrowernumber
  FROM statistics
  WHERE type = 'issue' AND
  datetime BETWEEN Between (-mm-dd) AND and (-mm-dd))

I'd like to modify either of these to create a report that includes
the last date of activity for each patron inactive since a given date
(last activity is an 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 mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

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

[Cab Vinton]

 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 there :-)

Our thought was to get a carousel on our library's web page first,
then worry about getting it up on our catalog. That said, I know there
a few libraries out there that have already done this. A couple that
come to mind: http://search.myacpl.org/ 
https://library.plantandfood.co.nz/

If folks have favorite implementations, feel free to chime in! I think
this is something that many libraries would be interested in.

Cheers,

Cab
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

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

[Cab Vinton]

Thank you, Nick!

We're hosted by Equinox, so getting that php code in place would take
a bit of extra work for us.

I'm now thinking that we may better off just using a custom field for
this purpose.

If we stick w/ Amazon, their ASIN would be the best way to go. This is
the ISBN for most books, but something else entirely when dealing with
movies  certain other items. Yet another step in our cataloging
workflow ...

Then again, there are other options for book covers, so I'll be
looking into Google Books, LibraryThing, etc. If folks have specific
thoughts on this, I'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
vano...@gmail.com wrote:
 A simple bit of code can be used to get the first valid 10-digit ISBN. This
 is the php code we use - it could be adapted to perl quite easily,
 though (Actually, if I recall correctly, there is a C4 function to get
 the Normalised ISBN...)

 // Normalise the ISBN
 $isbn = preg_replace('/(.*) \| (.*)/', '$1', $isbn); // Get first isbn
 $isbn = preg_replace('/(.*) (.*)/', '$1', $isbn); // Get rid of text
 if (strlen($isbn) == 11) {
  if ($debugging) { print Chopping 11 digit ISBN to a 10 digit ISBN; }
  $isbn = substr($isbn,1,10);
 } else if (strlen($isbn) == 13) {
  $isbn = substr($isbn,3,9);
  $checksum = 0;
  $weight = 10;
  $isbnCharArray = str_split($isbn);
  foreach($isbnCharArray as $char) {
    $checksum += $char * $weight;
    $weight--;
  }
  $checksum = 11-($checksum % 11);
  if ($checksum == 10) {
    $isbn += X;
  } else if ($checksum == 11) {
    $isbn += 0;
  } else {
    $isbn .= $checksum;
  }
 } else if (strlen($isbn) != 10) {
  if ($debugging) { print pIllegal ISBN Found: $isbn/p; }
    exit;
 }
 if ($debugging) { print Normalised ISBN: $isbn; exit; }


 -
 Nick


 On 03/07/2012 05:50 AM, Cab Vinton wrote:

 Hi, All --

 For the purposes of creating a web-based carousel of book covers of
 our recent acquisitions, I'd like to run a report that generates a
 list of ISBNs of items added between 2 dates.

 Amazon  therefore Koha rely on 10-digit ISBNs for book cover retrieval.


 However, when I run a report using biblioitems.isbn, this is the
 output I get. Many truncated ISBNs, presumably because the max length
 = 30 restriction.

 9780425243244 (pbk.) | 0425243
 9780307718099 | 0307718093
 0804840288 | 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
 Sanbornton, NH
 ___
 Koha-devel mailing list
 koha-de...@lists.koha-community.org
 http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
 website : http://www.koha-community.org/
 git : http://git.koha-community.org/
 bugs : http://bugs.koha-community.org/



 ___
 Koha-devel mailing list
 koha-de...@lists.koha-community.org
 http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
 website : http://www.koha-community.org/
 git : http://git.koha-community.org/
 bugs : http://bugs.koha-community.org/
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Retrieving 10-digit ISBNs in a report

[Cab Vinton]

OK, this got no responses on the Koha developers list :-(, so trying here --

For the purposes of creating a web-based carousel of book covers for
our recent acquisitions, I'd like to run a report that generates a
list of ISBNs of items added between 2 dates.

Amazon,  therefore Koha, rely on 10-digit ISBNs for book cover retrieval.

However, when I run a report using biblioitems.isbn, this is the
output I get. Many truncated ISBNs, presumably because of the max
length = 30 restriction for this particular field.

9780425243244 (pbk.) | 0425243
9780307718099 | 0307718093
0804840288 | 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
Sanbornton, NH
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

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

[Cab Vinton]

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 peter.mur...@lyrasis.org
Date: Tue, Jan 17, 2012 at 3:39 PM
Subject: FOSS4LIB registry now open for new
packages/releases/providers/events/institutions
To: code4...@listserv.nd.edu


All --

The project that I was seeking feedback on over the fall is seeing the
light of day.  http://foss4lib.org/ is now open for use by the
community.  For the Code4Lib audience, this mostly means you can
create an account, log in, and create content nodes for specific
packages, releases, and events.  See
http://foss4lib.org/content/adding-information-foss4lib for links on
how to get started.

For people or organizations that provide support for open source
software in libraries -- implementation consulting, hosting, custom
code development, training, etc. -- we especially want to encourage
you to sign up and post your availability on the site.  One of the
overarching goals is to promote an ecosystem of open source support
providers for packages that are specific to libraries.  So we want to
make this registry a better place to go to find those support options
over a scattershot Google search.  Please note that there is one bit
of functionality in the registry that is not done right now.  Some
software packages have well developed lists of providers and
institutions that use the software, and we're not trying to reproduce
those in the registry.  There is a capability coming that will allow
URLs to these community lists to override the
provider/using-institution functionality of the registry.  More on
that soon.

Speaking of additional functionality, I am very interested in hearing
ideas about how the registry can advance the goal of supporting open
source software in libraries.  If you have any, feel free to discuss
them here or send me a direct e-mail.  A press release about FOSS4LIB
will be going out in the next couple of hours, and it will include
information about one-hour introductory sessions at Midwinter and
webinars later in January and February.


Here's the instructions:

Go to http://foss4lib.org/user/register and create an account for
yourself.  The pattern for usernames is recommended to be your first
and last name, but you can make it anything you want.  You'll receive
an e-mail with a one-time password to follow and set your password.

Then browse (http://foss4lib.org/packages) or search
(http://foss4lib.org/search/node) for your target software package(s).
 If you see it/them, great! -- move onto the next step.  If not,
follow Add content - package (http://foss4lib.org/node/add/package)
to create it.  Put in the common name (no release numbers) for your
package as its title and some descriptive chunk of text for the body.
Below this is a series of technology choices that you can make.  In
the case of Package Type, License, and Development Status you can pick
one of the choices.  For Operating System, Technologies Used,
Programming Language, and Database you can pick more than one (using
Command-Click or Control-Click, depending on your operating system).
For anything in this Technology area, if there are terms that you need
that aren't listed let me know and I'll add them.  Below Technology is
Links, and you can fill in any URLs that you know/have for this
package.  Below that is an Associations sect!
 ion where you can link this package to other packages in the system.
(See the DSpace entry, for instance --
http://foss4lib.org/package/dspace -- on how it is associated with
Djatoka.)  Now hit Save (or hit Preview then Save) your package
and go onto the next step.

As appropriate, create a Provider for your company/organization/self
(http://foss4lib.org/node/add/provider):  Put in the title and
description.  Then in the Supports section, pick one or more choices
for Provider Type.  (If you provide services other than the ones
listed here, let me know and I'll add them to the list.)  In the
Package field start typing the name of the package until it pops up in
the auto-complete drop-down and select it there.  (When you do so,
you'll see the package name appended with [nid:x] representing the
node ID.)  You can mix-and-match your Provider Type and Packages by
selecting Add Another Item.  In the Employees Registered section,
you can add people registered on FOSS4LIB (including yourself) that
will appear as associated with your firm.  Below that add arbitrary
URLs (such as to your homepage, client list, contact information,
etc.) that will appear on your provider page.  Then hit Save (or hit
Preview then Save) and your done!

Feel free to add Events (http://foss4lib.org/node/add/event), Package
Releases (http://foss4lib.org/node/add/release), and other Packages
(http://foss4lib.org/node/add/package) that you know about.  And thank
you for extending the usefulness of the FOSS4LIB site.


Peter
--
Peter Murray
Assistant

[Koha] Well, this is disappointing ...

[Cab Vinton]

http://www.librarytechnology.org/ltg-displaytext.pl?RC=16375

LibLime Academic Koha to be used by University Students in Spring
Semester 2012 [Dec. 8, 2011]

Spring semester 2012, three schools are joining LibLime in the Koha
with Class program. The three schools working with LibLime on this
project include: The School of Library and Information Science at
Indiana University; The Information School at the University of
Washington Gallagher; and the Graduate School of Library and
Information Science at Simmons College. Library school students at
these three Universities – taking classes in library automation and
technology systems -- will be studying the principles for design,
selection, implementation and management of automated systems of all
types in libraries. Each course will cover the use of ILSs for
technical service processing, reference and user services, and
management. 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

Politeness and consideration for others is like investing pennies and
getting dollars back. Thomas Sowell
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Primary secondary email addresses

[Cab Vinton]

In our version of Koha the AutoEmailPrimaryAddress preference reads:

Send/ Don't send an email to newly created patrons with their account
details at their alternate/ etc. email address.

So, presumably would not apply to notices?

From searching this preference on bugzilla
(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 others is like investing pennies and
getting dollars back. Thomas Sowell



2011/12/6 Ian Walls ian.wa...@bywatersolutions.com:
 There is a system preferenece, AutoEmailPrimaryAddress, that determines
 which email is used to send notices.  One of the options, first valid,
 checks the emails in the order: primary, secondary, alternate.  The first
 field that is populated with a valid email address (on a per-user basis) is
 used to send the notices.

 I recommend you verify that setting first, then proceed from there.

 Cheers,


 -Ian


 On Tue, Dec 6, 2011 at 2:27 AM, R Sunil Kumar sunil.ku...@ecoleglobal.com
 wrote:

 Dear All,

 I am also facing the same problem for email notices. Notices are only
 received by member who has given the primary email id for Koha 3.04

 My problem is that, email are not send to all the patron who's email id is
 given in the primary section, email is going to only ONE patron.
 Eventhough
 primary email id are given in some accounts. Secondly majority of the
 email
 id is given in the secondary email ID section and koha is not picking the
 secondary email id for sending the reminder.

 Can anybody have a solution/suggestion.

 Thanks and Regards

 R Sunil Kumar
 Library Technologist
 +91-9686576695

 -Original Message-
 From: koha-boun...@lists.katipo.co.nz
 [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of
 koha-requ...@lists.katipo.co.nz
 Sent: 06 December 2011 04:30
 To: koha@lists.katipo.co.nz
 Subject: Koha Digest, Vol 74, Issue 12

 Send Koha mailing list submissions to
        koha@lists.katipo.co.nz

 To subscribe or unsubscribe via the World Wide Web, visit
        http://lists.katipo.co.nz/mailman/listinfo/koha
 or, via email, send a message with subject or body 'help' to
        koha-requ...@lists.katipo.co.nz

 You can reach the person managing the list at
        koha-ow...@lists.katipo.co.nz

 When replying, please edit your Subject line so it is more specific
 than Re: Contents of Koha digest...


 Today's Topics:

   1. Re: Problems with Apache when trying to access Koha Admin
      (culiforge)
   2. Primary  secondary email addresses (Cab Vinton)
   3. Re: Improving permissions on lists (virtual shelves) (Robin Sheat)
   4. Re: Search by copy number not working properly (Marijana Glavica)


 --

 Message: 1
 Date: Mon, 5 Dec 2011 10:59:48 -0800 (PST)
 From: culiforge culinaryfo...@gmail.com
 To: koha@lists.katipo.co.nz
 Subject: Re: [Koha] Problems with Apache when trying to access Koha
        Admin
 Message-ID: 1323111588693-5049780.p...@n5.nabble.com
 Content-Type: text/plain; charset=us-ascii

 I found this post and it's exactly the issue I'm having.
 the problem is... I'm new to Linux, koha and mysql and therefore don't
 quite
 know how to follow through on the solution given.

 speak slowly and use small words and I will be grateful.

 cul

 --
 View this message in context:

 http://koha.1045719.n5.nabble.com/Problems-with-Apache-when-trying-to-access
 -Koha-Admin-tp5037373p5049780.html
 Sent from the Koha-general mailing list archive at Nabble.com.


 --

 Message: 2
 Date: Mon, 5 Dec 2011 16:46:59 -0500
 From: Cab Vinton bibli...@gmail.com
 To: Koha list koha@lists.katipo.co.nz
 Subject: [Koha] Primary  secondary email addresses
 Message-ID:

  CABW43UQ6uxqWs77WA_Q+30Gs0uTS9we=4h9q3bjhwftskg6...@mail.gmail.com
 Content-Type: text/plain; charset=ISO-8859-1

 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 ...

 Cheers,

 Cab Vinton, Director
 Sanbornton Public Library
 Sanbornton, NH

 Politeness and consideration for others is like investing pennies and
 getting dollars back. Thomas Sowell


 --

 Message: 3
 Date: Tue, 06 Dec 2011 11:35:50 +1300
 From: Robin Sheat ro...@catalyst.net.nz
 To: koha@lists.katipo.co.nz
 Subject: Re: [Koha] Improving permissions on lists (virtual shelves)
 Message-ID: 1323124550.18798.13.camel@zarathud
 Content-Type: text/plain; charset=utf-8

 BWS Johnson schreef op ma 05-12-2011 om 03:00 [-0800]:
      I'm still struggling with this. While I realise that some Patrons
  who shall remain nameless and spammers

[Koha] Primary secondary email addresses

[Cab Vinton]

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 ...

Cheers,

Cab Vinton, Director
Sanbornton Public Library
Sanbornton, NH

Politeness and consideration for others is like investing pennies and
getting dollars back. Thomas Sowell
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Task scheduler

[Cab Vinton]

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, Director
Sanbornton Public Library
Sanbornton, NH

Politeness and consideration for others is like investing pennies and
getting dollars back. Thomas Sowell
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

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

[Cab Vinton]

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 mag...@enger.priv.no wrote:
 Viktor et al!

 I have taken the liberty of creating a wiki page based on your email:
 http://wiki.koha-community.org/wiki/OPACMySummaryHTML

 Please feel free to add any other interesting uses for this syspref!

 Best regards,
 Magnus Enger
 libriotech.no
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha