<div class="gmail_quote">2010/11/29 Paul <span dir="ltr"><<a href="mailto:paul.a@aandc.org">paul.a@aandc.org</a>></span><br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div>First, are spaces allowed in the 10 character CCODE? Are there any other
restrictions (numerics, underlines, hyphens, etc)? I find nothing
(easily) in the documentation. As a comparison, the LOC code allows 80
characters including (at least) spaces.<br><br></div></blockquote><div><br>It appears that you can, at least, define a CCODE type with spaces. Whether it works in practice or not I don't know.<br> </div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div>
For various historical reasons we have nearly two hundred
"categories" spread across 468 spreadsheets - that would be a
possible 100,000 "simple search and replace" operations
;={ and I've never had much success with Perl looking for entries
in a specific column of a spreadsheet where obviously the "category
name" could also appear in the title, keywords and reviews which we
obviously do not want to modify.<br><br></div></blockquote><div><br>We use Text::CSV in a number of places in Koha to work with comma delimited files, and it works very nicely. I don't see why you should have any problem munging up 468 spreadsheets using that module. But then, maybe I'm being naive here. :-)<br>
</div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div>
So I'll probably end up attempting to modify the SQL parameter for field
length (a task which, from past experience with Oracle, I am not looking
forward to.)<br><br></div></blockquote><div><br>This will probably break things at worst and at best is ill advised. It will definitely result in complications during future upgrades should the core code change in the future.<br>
<br>Custom code hacks (especially of this nature) are not recommended for the sake of future sanity and happiness.<br><br>Kind Regards,<br>Chris <br></div></div>