We have patrons (borrowers) from many states and countries. Is it possible to separate the city and the state anywhere? We also keep track of the in-state patrons home counties. Zip codes don't really work since some go across county lines. Any suggestions? -- Linda Culberson lculber@mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives & History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Facsimile: 601/576-6824
This would be an enhancement request - one that I completely agree with. I don't know why City State were in one field - maybe cause all countries don't have city/state designations - but that doesn't mean we can't have an extra field that some people don't use. Now all we need is someone to do the development - and a sponsor. Nicole On Mon, Dec 14, 2009 at 12:08 PM, Linda Culberson <lculber@mdah.state.ms.us> wrote:
We have patrons (borrowers) from many states and countries. Is it possible to separate the city and the state anywhere? We also keep track of the in-state patrons home counties. Zip codes don't really work since some go across county lines. Any suggestions?
-- Linda Culberson lculber@mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives & History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Facsimile: 601/576-6824
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Thanks for your quick response about the states, Nicole. I apologize that I hit "send" too soon. We were wondering whether we could add a borrower attribute (using extended attributes) for a state code, and then another for the county. The state codes would include something for foreign counties, so that wouldn't have to allow nulls, but if we had one for counties, is it okay for it to accept nulls? Nicole Engard wrote:
This would be an enhancement request - one that I completely agree with. I don't know why City State were in one field - maybe cause all countries don't have city/state designations - but that doesn't mean we can't have an extra field that some people don't use.
Now all we need is someone to do the development - and a sponsor.
Nicole
On Mon, Dec 14, 2009 at 12:08 PM, Linda Culberson <lculber@mdah.state.ms.us> wrote:
We have patrons (borrowers) from many states and countries. Is it possible to separate the city and the state anywhere? Â We also keep track of the in-state patrons home counties. Zip codes don't really work since some go across county lines. Â Any suggestions?
-- Linda Culberson         lculber@mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives & History P. O. Box 571 Jackson, MS 39205-0571 Telephone:  601/576-6873 Facsimile:  601/576-6824
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Linda Culberson lculber@mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives & History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Facsimile: 601/576-6824
Hello We have set up borrower attributes for some libraries for municipality, township, and voting area. These need not be completed so whether null or not I don;t know, but they can be left blank. Agnes Linda Culberson wrote:
Thanks for your quick response about the states, Nicole. I apologize that I hit "send" too soon.
We were wondering whether we could add a borrower attribute (using extended attributes) for a state code, and then another for the county. The state codes would include something for foreign counties, so that wouldn't have to allow nulls, but if we had one for counties, is it okay for it to accept nulls?
Nicole Engard wrote:
This would be an enhancement request - one that I completely agree with. I don't know why City State were in one field - maybe cause all countries don't have city/state designations - but that doesn't mean we can't have an extra field that some people don't use.
Now all we need is someone to do the development - and a sponsor.
Nicole
On Mon, Dec 14, 2009 at 12:08 PM, Linda Culberson <lculber@mdah.state.ms.us> wrote:
We have patrons (borrowers) from many states and countries. Is it possible to separate the city and the state anywhere? Â We also keep track of the in-state patrons home counties. Zip codes don't really work since some go across county lines. Â Any suggestions?
-- Linda Culberson         lculber@mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives & History P. O. Box 571 Jackson, MS 39205-0571 Telephone:  601/576-6873 Facsimile:  601/576-6824
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Agnes Rivers-Moore Assistant Librarian Hanover Public Library
participants (3)
-
Agnes Rivers-Moore -
Linda Culberson -
Nicole Engard