Solved! The collection field (ccode in the item table) was not filled in on the imported items so Koha would not check the item out. I've gone through and executed conditional SQL commands to get this information into the database and it now works brilliantly. Seth Mayo IT Technical Manager Email: smayo@stpeters.nsw.edu.au ------------------------------------------------------- St Peter's Anglican Primary School Howe Street Campbelltown NSW 2560 PH: 02 4627 2990 DID: 02 8203 1368 Website: http://www.stpeters.nsw.edu.au On 25 January 2011 12:38, Chris Cormack <chris@bigballofwax.co.nz> wrote:
We've just installed a new 3.2.2 installation of Koha in our library. Calyx in Sydney Australia has helped us import data from our old system and all the data seems quite sound and accurate barring a few adjustments which were expected. However I have a strange problem that I'm hoping there is an easy and quick answer to...
If looking up a book in any search box (backend or frontend) by barcode,
system will successfully retrieve it. However when you go to checkout a book, you find a patron - this works, then you are asked to scan the barcode to loan the item out. When we do this, we get "Barcode was not found". So we know the data is fine because we can search otherwise for the barcodes, but scanning them into the checkout doesn't work. I've looked at what
2011/1/25 Seth Mayo <smayo@stpeters.nsw.edu.au>: the the
barcode reader is doing and found it to be scanning the barcode correctly. I also tried copying and pasting the barcode form the OPAC into the checkout box in case there is some data problem there but this still returns nothing.
Any suggestions or help would be very appreciated! We have students returning Thursday and, while other features can be worked through slowly, this one is sort of critical as we all know!
Hi Seth
Do you have commandline access to the database? If so try running
SELECT barcode FROM items LIMIT 10;
That should get you 10 barcodes, if they are all null, then I think we have found your problem.
Chris