Good afternoon all.

Brief History for that have not seen my other posts.

We are trying to migrate to Koha from Follett, when biblio info is exported from Follett the barcodes have zeros add in place of a space, T 12345 comes out as T0012345. I updated my records and re-import the barcode field and but when I try to check out a book it tells me barcode not found.

I have be trying some different thing with Mike Hafen. We have come to find that Koha is reading the barcode correctly but just isn’t finding it in the DB. We have found that the DB is pretty much set to latin1 as the character set but when I created the DB I select UTF-8 and I also converted the export data from Follett to UTF-8. Do I need to change the char set for the whole MySQL or is that a non-issue. I really have like this product but out librarians have said they will not re-barcode because on average they have 16k+ items that they would have to change.  I am at wits end with this issue and I would hate to be able to use Koha because it is everything we want except for this issue.

If anyone has seen this before please let me know your thoughts.

Thanks

Ed

Edward J. Roche

Network Administrator

Solanco School District

717.786.2151 x2437

"At the End of the Day, Did You Play to Win or Not to Lose?"