Problem: the CCODE in the Koha SQL database is limited to 10 characters only.  We have (transferring our data from spreadsheets) dozens of categories that exceed this limit e.g. "marine biology", "yacht cruising", etc.

When dealing with authorized values, you have two parts: the authorized value itself (limited to 10 characters) and the description, which isn't so limited. "Marine biology" sounds to me like the description. For example, from our catalog: AVNF | Videocassette, non-fiction BIO | Biography CDM | Music CD CDR | CD-ROM software So the good news is you'll be able to retain your descriptive category information. The bad news is you'll still have to update your spreadsheets to replace phrases like "marine biology" with a corresponding less-than-10-letter code. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

I may be wrong, so anyone out there with more knowledge please correct, but I don't think you can use spaces in the ccode so changing the length wont help. Can't you do a simple find and replace? Make your current collect code the description and make up a new shorter ccode for the underlying code. For most of the Koha web pages its the description that shows not the code. Susan Bennett ILS System Administrator Geauga County Public Library 440 286-6811 x 125 440 286-7419 FAX On Mon, Nov 29, 2010 at 3:26 PM, Paul <paul.a@aandc.org> wrote:

Problem: the CCODE in the Koha SQL database is limited to 10 characters only. We have (transferring our data from spreadsheets) dozens of categories that exceed this limit e.g. "marine biology", "yacht cruising", etc.

Does anyone know of a quick way to modify the field length in SQL "on the fly"?

Many thanks - the alternative is to manually correct tens of thousands of entries spread across hundreds of spreadsheets.

Paul

_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha