[OPEN-ILS-GENERAL] alert for once juvenile becomes adult

[Justin Hopkins 📖]

Blake is going to put something together, for our own use if nothing 
else. Hopefully it will be useful for others :)

Justin

On 6/10/15 4:24 PM, Holly Brennan wrote:
>
> Thanks, Justin! Your messages were filtered to my junk – sorry for the 
> late reply!
>
> I can look at the whole database, but only change things I’m familiar 
> with (and this is not one).
>
> -Holly
>
> *From:*Open-ils-general 
> [mailto:open-ils-general-bounces at list.georgialibraries.org] *On Behalf 
> Of *Justin Hopkins ??
> *Sent:* Wednesday, June 10, 2015 12:11 PM
> *To:* Evergreen Discussion Group
> *Subject:* Re: [OPEN-ILS-GENERAL] alert for once juvenile becomes adult
>
> I should clarify that my previous suggestion was based on my 
> recollection that you have access to the database and could set this up.
>
> Justin
>
> On 6/10/15 3:09 PM, Justin Hopkins 📖 wrote:
>
>     Holly,
>
>     I think the simplest solution would be to run a script on a
>     nightly cron that updated the database as necessary. Flip the
>     Juvenile flag, change their profile, possibly remove the
>     grouping/ident2_value, and add an alert. I thought we might be
>     running something like that ourselves, but either I'm not finding
>     it, or it's just something we'd also talked about doing but never did.
>
>     Justin
>
>     On 6/10/15 3:00 PM, Holly Brennan wrote:
>
>         We’d like to be alerted when a patron who was marked as
>         juvenile (the checkbox based on their birth date) is now over
>         18. The goal would be to catch those now-adults and change
>         their library card type from Juvenile to Adult, so they are
>         now responsible for their library card rather than their
>         parent. We would also enter their ID information, and remove
>         the parent’s ID (typically their driver’s license).
>
>         The staff notification could be just a alert message. We’d
>         like to avoid having to look at an expired account and
>         calculate whether that patron is now an adult, so please no
>         solutions involving math. J
>
>         We’ve run a report for patrons who have Juvenile accounts but
>         are 18+, and there are hundreds. I’m guessing we’re on our own
>         fixing these ones, but maybe there is a miracle out there for
>         adding the alert to these accounts too?
>
>         Thanks!
>
>         Holly Brennan
>
>         Library Technology Specialist
>
>         Homer Public Library, Alaska
>
>         hbrennan at cityofhomer-ak.gov <mailto:hbrennan at cityofhomer-ak.gov>
>
>         907-235-3180 (main)
>
>         907-435-3154 (direct)
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20150610/cef0fc89/attachment-0001.html>