[Koha] Flood recovery in Brisbane - pulling data from Koha

LAURENT Henri-Damien henridamien.laurent at biblibre.com
Wed Jan 19 18:09:43 NZDT 2011


Hi
Sorry for your library and your users.
you may find there
http://wiki.koha-community.org/wiki/SQL_Reports_Library
some useful reports
those can be processed from the Guided Reports in the koha intranet.
The data you ask for is all contained in fields of the database.
But you would have to precise your demands, since Itemcount should
always be 1 if you are using barcode.
Hope that helps.
-- 
Henri-Damien LAURENT

Le 19/01/2011 04:31, Amanda and Hugh Gardner a écrit :
> Hi All,
>  
> I'm hoping I can get some advice with regard to pulling data from Koha. 
>  
> My library has recently been completely inundated during the Brisbane
> floods and nothing was saved except the library catalogue on Koha!  I am
> the current librarian, however, I have only been in the position for
> four weeks and have not had a chance to learn the ins and outs of Koha. 
> I am also not a techie so am relying on IT staff to assist with my
> queries which has not proved successful as they are off recovering other
> parts of the organisation's network.
>  
> In order to create an inventory of the library collection for insurance
> purposes I would like to export data from the following fields and dump
> them into an Excel create an spreadsheet.
>  
> The data I need are from the following fields:
>  
> Item type
> Title
> Publisher
> Date
> ISBN
> ISSN
> Item count
> Location
> Barcode
>  
> Can this be done from the back end of Koha and if so, how do I do it? 
>  
> Any advice would be greatly appreciated, keeping in mind I am not
> familiar with this database at all and will have no IT support.
>  
> Many thanks,
>  
> Amanda


More information about the Koha mailing list