ZIP/postal code lookup table should be moved to the database
Bug #1365073 reported by
Galen Charlton
This bug affects 4 people
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Evergreen |
New
|
Wishlist
|
Unassigned | ||
Bug Description
It would be handy if the table used for the patron address-
If this change were made, additional blue sky ideas to consider at the same time:
[1] For cases where a postal code is used by more than one city, adding a way for circ staff to select the appropriate one during patron registration.
[2] Adding scoping of the postal code table by OU, to control the visibility of selected entries and to allow libraries and systems to override the cities returned for a given ZIP code.
Another relevant bug for revamping this feature is bug 1196393.
Evergreen master
Revision history for this message
| Rogan Hamby (rogan-hamby) wrote | #1 |
Revision history for this message
| Garry Collum (gcollum) wrote | #2 |
Revision history for this message
| Rogan Hamby (rogan-hamby) wrote | #3 |
| tags: | added: admin-pages |
To post a comment you must log in.
Because of the complex (messy?) ways that zip/postal codes map to actual towns should we look at some kind of in db structure that allows for duplication of zips that can map to multiple townships and scope them by org unit? Then, once the org unit the patron is registered for is entered it will map the zip/postal against those valid for that org unit.
E.g. we have one zip code that maps to two different townships in different adjacent counties (which happen to be our second level org units since we're county libraries).