|
»
Naming Practices: Authorized Values & Patron Attributes
|
View:
New views
3 Messages
—
Rating Filter:
Alert me
|
 |
Naming Practices: Authorized Values & Patron Attributes
by Chris Mueller-7
::
Rate this Message:
What are "best practices" when creating new categories for Authorized Values and new codes for Patron Attributes?
By accident I found that the maximum number of characters for a new Authorized Values category is 10. -- Nicole: Can this type of info be added to the documentation please? Suspect there is a maximum number of characters for new Patron Attributes codes but prefer not to create test codes until I find one which is too long. Anyone know what the max number is? Also suspect that there might be problems with SQL statements if any special characters are used in the categories and codes, other than perhaps "_" and "." (underscore and period). Is it best to use only alpha characters when naming categories and codes? Thanks for any insights and guidance. Chris Christine Mueller Database Administrator Office of Information Technology New Mexico State Library 1209 Camino Carlos Rey Santa Fe, NM 87507 Phone: 505-476-9744 christine.mueller@... http://www.stlib.state.nm.us/ _______________________________________________ Koha mailing list Koha@... http://lists.katipo.co.nz/mailman/listinfo/koha |
|
|
Re: Naming Practices: Authorized Values & Patron Attributes
by Agnes Rivers-Moore
::
Rate this Message:
You are right about the special characters. I once tried to set up a
Patron Attribute called Fire# and broke all kinds of things. Agnes Chris Mueller wrote: > What are "best practices" when creating new categories for Authorized > Values and new codes for Patron Attributes? > > By accident I found that the maximum number of characters for a new > Authorized Values category is 10. -- Nicole: Can this type of info be > added to the documentation please? > > Suspect there is a maximum number of characters for new Patron > Attributes codes but prefer not to create test codes until I find one > which is too long. Anyone know what the max number is? > > Also suspect that there might be problems with SQL statements if any > special characters are used in the categories and codes, other than > perhaps "_" and "." (underscore and period). Is it best to use only > alpha characters when naming categories and codes? > > Thanks for any insights and guidance. Chris > > > Christine Mueller > Database Administrator > Office of Information Technology > New Mexico State Library > 1209 Camino Carlos Rey > Santa Fe, NM 87507 > Phone: 505-476-9744 > christine.mueller@... <mailto:christine.mueller@...> > http://www.stlib.state.nm.us/ > ------------------------------------------------------------------------ > > _______________________________________________ > Koha mailing list > Koha@... > http://lists.katipo.co.nz/mailman/listinfo/koha > > ------------------------------------------------------------------------ > > This email was Anti Virus checked by Astaro Security Gateway. http://www.astaro.com -- Agnes Rivers-Moore Assistant Librarian Hanover Public Library _______________________________________________ Koha mailing list Koha@... http://lists.katipo.co.nz/mailman/listinfo/koha |
|
|
Re: Naming Practices: Authorized Values & Patron Attributes
by Nicole Engard-2
::
Rate this Message:
Okay - the best thing to do is always check the SQL structure (that
said I will update the new manual with this info) http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=blob_plain;f=installer/data/mysql/kohastructure.sql;hb=HEAD The link is VARCHAR(10) on patron attribute codes as well as authorized values. And when you're writing codes it's good practice to only have characters and numbers - no symbols. Nicole On Wed, Nov 4, 2009 at 5:25 PM, Agnes Rivers-Moore <arm@...> wrote: > You are right about the special characters. I once tried to set up a > Patron Attribute called Fire# and broke all kinds of things. > Agnes > > Chris Mueller wrote: >> What are "best practices" when creating new categories for Authorized >> Values and new codes for Patron Attributes? >> >> By accident I found that the maximum number of characters for a new >> Authorized Values category is 10. -- Nicole: Can this type of info be >> added to the documentation please? >> >> Suspect there is a maximum number of characters for new Patron >> Attributes codes but prefer not to create test codes until I find one >> which is too long. Anyone know what the max number is? >> >> Also suspect that there might be problems with SQL statements if any >> special characters are used in the categories and codes, other than >> perhaps "_" and "." (underscore and period). Is it best to use only >> alpha characters when naming categories and codes? >> >> Thanks for any insights and guidance. Chris >> >> >> Christine Mueller >> Database Administrator >> Office of Information Technology >> New Mexico State Library >> 1209 Camino Carlos Rey >> Santa Fe, NM 87507 >> Phone: 505-476-9744 >> christine.mueller@... <mailto:christine.mueller@...> >> http://www.stlib.state.nm.us/ >> ------------------------------------------------------------------------ >> >> _______________________________________________ >> Koha mailing list >> Koha@... >> http://lists.katipo.co.nz/mailman/listinfo/koha >> >> ------------------------------------------------------------------------ >> >> This email was Anti Virus checked by Astaro Security Gateway. http://www.astaro.com > > -- > > Agnes Rivers-Moore > Assistant Librarian > Hanover Public Library > > _______________________________________________ > Koha mailing list > Koha@... > http://lists.katipo.co.nz/mailman/listinfo/koha > Koha mailing list Koha@... http://lists.katipo.co.nz/mailman/listinfo/koha |
| Free embeddable forum powered by Nabble | Forum Help |
