[Koha] Koha Architecture, difference between OPAC results and SQL Reports

Elaine Bradtke eb at efdss.org
Tue Mar 11 05:50:38 NZDT 2014

I'm not an expert on SQL but, in standard Koha, there is an administrative
setting that allows you to edit how the fields that use authorized values
display in the OPAC.  One of these is location.  In our case we use generic
'storage' in the OPAC and the specific details are available in the staff
This may or may not be the case in your version of Koha, but it's a simple
enough thing to check.

On Thu, Mar 6, 2014 at 3:18 PM, Andrew Gordon <agordon at nyam.org> wrote:

> Hello All,
> I have a rather basic question, but something that has been confusing me
> for a while as a newcomer to using Koha.
> When I am trying to do some routine data cleaning I regularly find that
> the OPAC results often differ from the SQL reports results on what I assume
> to be the same field. One regular offender here is items.location. The
> items location in the OPAC is different and often more detailed or complete
> than the value returned in a  report, which may often be blank despite
> there being a value in the OPAC.
> So my question is, what are the two different ways that values are being
> pulled for the OPAC results (staff side, mainly) and the SQL Report side,
> respectively. Or is this an indication that somehow data has not been
> entered correctly?
> Additionally, this is PTFS LibLime Academic Koha, I am assuming that it
> does not differ greatly from vanilla Koha in this respect.
> As an afterthought, is there a good source of documentation out there that
> gives a better idea of the internal workings of Koha, the shape of its data
> architecture and how it renders data across its many views? So far I can
> only really find end-user UI instructions.
> Many thanks,
> Drew
> ________________________________________
> Andrew Gordon, MSI
> Systems Librarian
> Center for the History of Medicine and Public Health
> New York Academy of Medicine
> 1216 Fifth Avenue
> New York, NY, 10029
> 212.822.7324
> http://nyamcenterforhistory.org/
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha

Elaine Bradtke
Data Wrangler
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel    +44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
"Writing about music is like dancing about architecture"
--Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)

More information about the Koha mailing list