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

[Justin Hopkins 📖]

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
>>
>> 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/4fe4322a/attachment.html>