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