Re: [OPEN-ILS-GENERAL] Reminders for expiring cards

[Elisabeth Keppler]

We are SO looking forward to 2.9!

On Fri, Dec 18, 2015 at 5:43 PM, Angela Kilsdonk 
wrote:

> Hi Vince,
>
> In version 2.9 there is a new Action Trigger called "30 Day Account
> Expiration Courtesy Notice" that can be used to send patrons a reminder
> that their accounts will expire in the near future.  The Action Trigger can
> be modified for a time period other than 30 days.
>
> Hope this helps,
> Angela
>
> On Fri, Dec 18, 2015 at 4:33 PM, Vince Giordano <
> vgiord...@juniatalibrary.org> wrote:
>
>> Does anyone use a method for reminding patrons that their library card is
>> soon expiring?
>>
>> We are having patrons who primarily use Overdrive contact us and say
>> there is an error or block on their account (due to their card expiring). I
>> didn't know if there was a feature to send out a courtesy email of some
>> kind. Putting a reminder message on the footer of the print receipt is one
>> I am considering.
>>
>>
>> 
>>  This
>> email has been sent from a virus-free computer protected by Avast.
>> www.avast.com
>> 
>> <#151b74415727455e_151b73aae23db4a4_DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>>
>
>
>
> --
> Angela Kilsdonk
> Education Manager
> Equinox Software Inc. / The Open Source Experts
> 1-877-OPEN-ILS (673-6457)
>



-- 
Lise Keppler, Technical Services
Forsyth County Public Library
2851 Fairlawn Dr
Winston Salem NC  27106
336-703-3048

Re: [OPEN-ILS-GENERAL] Reminders for expiring cards

[Angela Kilsdonk]

Hi Vince,

In version 2.9 there is a new Action Trigger called "30 Day Account
Expiration Courtesy Notice" that can be used to send patrons a reminder
that their accounts will expire in the near future.  The Action Trigger can
be modified for a time period other than 30 days.

Hope this helps,
Angela

On Fri, Dec 18, 2015 at 4:33 PM, Vince Giordano <
vgiord...@juniatalibrary.org> wrote:

> Does anyone use a method for reminding patrons that their library card is
> soon expiring?
>
> We are having patrons who primarily use Overdrive contact us and say there
> is an error or block on their account (due to their card expiring). I
> didn't know if there was a feature to send out a courtesy email of some
> kind. Putting a reminder message on the footer of the print receipt is one
> I am considering.
>
>
> 
>  This
> email has been sent from a virus-free computer protected by Avast.
> www.avast.com
> 
> <#151b73aae23db4a4_DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>



-- 
Angela Kilsdonk
Education Manager
Equinox Software Inc. / The Open Source Experts
1-877-OPEN-ILS (673-6457)

Re: [OPEN-ILS-GENERAL] Reminders for expiring cards

[Elisabeth Keppler]

Forsyth NC runs a report on the 15th of every month identifying the email
addresses of those patrons whose cards expire the next month.  We use
vendor Constant Contact to send a mass email to all those addresses letting
the patrons know that their cards are due to expire.  Included in the text
of the message are instructions for how to renew.  Hope that helps!

Thanks,
Lise

On Fri, Dec 18, 2015 at 5:33 PM, Vince Giordano <
vgiord...@juniatalibrary.org> wrote:

> Does anyone use a method for reminding patrons that their library card is
> soon expiring?
>
> We are having patrons who primarily use Overdrive contact us and say there
> is an error or block on their account (due to their card expiring). I
> didn't know if there was a feature to send out a courtesy email of some
> kind. Putting a reminder message on the footer of the print receipt is one
> I am considering.
>
>
> 
>  This
> email has been sent from a virus-free computer protected by Avast.
> www.avast.com
> 
> <#151b73adbade270e_DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>



-- 
Lise Keppler, Technical Services
Forsyth County Public Library
2851 Fairlawn Dr
Winston Salem NC  27106
336-703-3048

[OPEN-ILS-GENERAL] Reminders for expiring cards

[Vince Giordano]

Does anyone use a method for reminding patrons that their library card is
soon expiring?

We are having patrons who primarily use Overdrive contact us and say there
is an error or block on their account (due to their card expiring). I
didn't know if there was a feature to send out a courtesy email of some
kind. Putting a reminder message on the footer of the print receipt is one
I am considering.


This
email has been sent from a virus-free computer protected by Avast.
www.avast.com

<#DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

[OPEN-ILS-GENERAL] Evergreen for Academics group: December 18 meeting minutes

[Yamil Suarez]

Hello,

Here are the links to access the Meetbot formatted minutes and the
meeting log, for those that did not make the meeting.

(Meetbot) Minutes:
http://evergreen-ils.org/meetings/evergreen/2015/evergreen.2015-12-18-14.01.html

IRC Log:
http://evergreen-ils.org/meetings/evergreen/2015/evergreen.2015-12-18-14.01.log.html

The next meeting date/time has not been determined, but the topic will
again be "reserves".

Thanks,
Yamil

P.S. For viewing all upcoming Evergreen community meetings scheduled:

http://evergreen-ils.org/communicate/calendar/

You can also subscribe to the various community calendars so that the
meetings automatically appear in our calendar.

Re: [OPEN-ILS-GENERAL] Notification is library is last owning on a held item? OCLC Last Copy/Withdraws

[Josh Stompro]

I've been looking into how to handle OCLC last copies for our consortium this 
week and I just wanted to run in by the group.  Please let me know if there is 
a better/easier way to handle this that you have found.  Or if there are any 
gotchas that you know of.

I searched the general list to find out what others are doing and didn't see 
that there was a great built in way to do it with the reporter.  So I attempted 
to do it with a sql query.

There is a "Last Copy Delete Time" data source that that doesn't seem to take 
the copy location into account, it works off of the bib being deleted.

I'm wondering if this could be setup as a reporter data source to make it 
easier to access.  After looking at the "Hold per copy ratio by pickup and 
descendants" data source that Galen just added it looks like it should be 
possible.

The query selects all bib records that have one or more copies with a 
discard/weed status and gives a count of the number of copies that have that 
status, along with a count of all other copies on that bib that have a status 
other than weed/discard.  If there are no other copies then you have removed 
the last copy.  It scopes the search to an org unit and all of its descendants, 
so it can be used for one branch, or for a system.

This method does require that you change the status of all copies you want to 
get rid of to withdrawn/weed before deleting them.  So your workflow for 
getting rid of lost/damaged/missing/long overdue may need to be adjusted.  Or 
the query could look for more status types to consider deleted and not deleted. 
 I'm not sure what the best way to handle that would be.

I also wasn't sure about the subqueries, if I needed to use different table 
aliases than what is used in the main query, so that may be unnecessary.

In the following query you would need to change the org unit id "101" in the 
actor.org_unit_descendants to your org unit you want to scope to. And I don't 
know if the asset.copy.status id numbers are uniform, so check to make sure 
that 13 = your withdrawn/weed status.

SELECT bre.id,
   bre.tcn_value,
   Xpath('n:datafield[@tag=035]/n:subfield[@code="a"]/text()',
   bre.marc :: xml, '{{n,http://www.loc.gov/MARC21/slim}}'),
   Count(ac.id)  AS
   withdrawn_count,
   (SELECT Count(ac1.id)
FROM   asset.copy ac1
   JOIN asset.call_number acn1
 ON ( ac1.call_number = acn1.id )
WHERE  acn1.record = bre.id
   AND ac1.status != 13
   AND ac1.circ_lib IN (SELECT id
FROM   actor.org_unit_descendants(101))) AS
   other_copies
FROM   biblio.record_entry bre
   JOIN asset.call_number acn
 ON ( bre.id = acn.record )
   JOIN asset.copy ac
 ON ( acn.id = ac.call_number )
WHERE  ac.status = 13
   AND ac.circ_lib IN (SELECT id
   FROM   actor.org_unit_descendants(101))
   AND (SELECT Count(ac1.id)
FROM   asset.copy ac1
   JOIN asset.call_number acn1
 ON ( ac1.call_number = acn1.id )
WHERE  acn1.record = bre.id
   AND ac1.status != 13
   AND ac1.circ_lib IN (SELECT id
FROM
   actor.org_unit_descendants(101))) = 0
GROUP  BY bre.id;



Josh Stompro - LARL IT Director

From: open-ils-general-boun...@list.georgialibraries.org 
[mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Hardy, 
Elaine
Sent: Wednesday, April 02, 2014 2:19 PM
To: 'Evergreen Discussion Group'
Subject: Re: [OPEN-ILS-GENERAL] Notification is library is last owning on a 
held item?

PINES would like this feature to identify when the last copy held by a system 
(not a branch) is deleted from the bib record for removing OCLC holdings as 
well.

Elaine

J. Elaine Hardy
PINES & Collaborative Projects Manager
Georgia Public Library Service
1800 Century Place, Ste 150
Atlanta, Ga. 30345-4304

404.235-7128
404.235-7201, fax
eha...@georgialibraries.org
www.georgialibraries.org
www.georgialibraries.org/pines
From: 
open-ils-general-boun...@list.georgialibraries.org
 [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of 
Elisabeth Keppler
Sent: Wednesday, April 02, 2014 8:06 AM
To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] Notification is library is last owning on a 
held item?

We'd also like to be able to identify when our own library's last copy is being 
discarded or deleted so we can remove our OCLC holdings.  We're on 2.4.3, if 
that makes a difference, and would welcome any suggestions.

I can report holds for which there is no holdable copy (which we call "hopeless 
holds") if that would help you,