[OPEN-ILS-GENERAL] DOB field in patron accounts

[Rogan Hamby]

That's fairly straightforward.  If you wanted to make sure every user was
at least 18 years old you could do something like

update actor.usr set dob = now() - interval '18 years' where dob is null;


On Mon, Feb 16, 2015 at 4:50 PM, Holly Brennan <haderhold at ci.homer.ak.us>
wrote:

>  There is an issue with requiring DOB if you don’t already have a DOB
> entered for every user. We added a dummy DOB to each user who didn’t have
> one (01/01/1901) when migrating to Evergreen. That way no one was blocked
> for not having a DOB, and we were still able to make the switch and require
> the DOB field to be entered with new users. We now check for that dummy DOB
> when updating patrons records, adding the true DOB.
>
>
>
> Equinox managed our migration, so I don’t know the details of how to go
> about adding a DOB to all users who contain a blank.
>
>
>
> -Holly
>
>
>
> Holly Brennan
>
> Library Technology Specialist
>
> Homer Public Library, Alaska
>
>
>
> hbrennan at cityofhomer-ak.gov
>
> 907-235-3180 (main)
>
> 907-435-3154 (direct)
>
>
>
>
>
> *From:* Open-ils-general [mailto:
> open-ils-general-bounces at list.georgialibraries.org] *On Behalf Of *Jackson,
> Robert
> *Sent:* Monday, February 16, 2015 5:18 AM
> *To:* Evergreen Discussion Group
> *Subject:* Re: [OPEN-ILS-GENERAL] DOB field in patron accounts
>
>
>
> The local administrator should be able to use the Admin->Local
> Administration->Library Setting Editor to accommodate this. Filter on DOB
> and Edit the “Require dob field on patron registration” setting.
>
>
>
> -----------------------------
> Robert J. Jackson
> Systems Administrator Int.
> Indiana State Library
> http://library.in.gov
> 315 W Ohio St
> Indianapolis, IN 46202
> (317) 234-7317
> rjackson at library.in.gov
>
> *From:* Open-ils-general [
> mailto:open-ils-general-bounces at list.georgialibraries.org
> <open-ils-general-bounces at list.georgialibraries.org>] *On Behalf Of *Pippin,
> Johnnie
> *Sent:* Monday, February 16, 2015 9:04 AM
> *To:* open-ils-general at list.georgialibraries.org
> *Subject:* [OPEN-ILS-GENERAL] DOB field in patron accounts
>
>
>
> *Good morning,*
>
>
>
> *Our system is looking at making the DOB field within patron accounts
> required in order to save their information. We feel that this helps at the
> granular scale of distinguishing multiple patrons with the same name. At
> patron registration, the DOB field is yellow shaded. However, once any of
> the other required fields are completed, the DOB field becomes white and is
> not required. I have read that having the DOB field mandatory is possible
> within Evergreen. If this is true, how can it be done? If it is false, can
> it be changed?*
>
>
>
>
>
> Thanks!
>
>
>
> -Johnnie
>
>
>
> --------------------------------------------------------------------
>
> Johnnie Pippin - NC Cardinal Consultant
>
> State Library of North Carolina
> 4640 Mail Service Center
> Raleigh, NC 27699-4640
> johnnie.pippin at ncdcr.gov
>
> Office: 919.807.7408 / Fax: 919.733.8748
>
> [image: Cardinal][image: Cardinal 2]
>
> -------------------------------------------------------------------
>
>
>
> North Carolina Department of Cultural Resources
>
>
>
> Opinions expressed in this message may not represent the policy of my
> agency.  Email correspondence to and from this address may be subject to
> the North Carolina Public Records law “NCGS.Ch. 132” and may be disclosed
> to third parties by an authorized state official.
>
>
>
>
>
>
>
>
>



-- 

Rogan Hamby, MLS, CCNP, MIA
Managers Headquarters Library and Reference Services,
York County Library System

“You can never get a cup of tea large enough or a book long enough to suit
me.”
― C.S. Lewis <http://www.goodreads.com/author/show/1069006.C_S_Lewis>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20150216/aca0f9f0/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 9078 bytes
Desc: not available
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20150216/aca0f9f0/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 6813 bytes
Desc: not available
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20150216/aca0f9f0/attachment-0003.png>