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:[email protected]] *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
[email protected] <mailto:[email protected]>
907-235-3180 (main)
907-435-3154 (direct)
