Flood recovery in Brisbane - pulling data from Koha
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
Hi Amanda, I should think you will be able to run any number of reports over the Koha data to haul out whatever 'results' you need so long as the backend data is available. It is easy to manipulate reports data in excel but the 64,000 line limit is a trap for young players (Access is better). You will probably also want to know the stock which was not currently on issue or loan. A last seen date might be useful too if you need to justify that the stock list is current ie not 'lost'. You may also want to extract the data about cost and list prices and date of purchase in order to get a sense of the value of the lost stock. You may need to sort by purchase date and claim 90% of the value of stock less than 1 year old but only 10% of stock 9 years old etc. Good luck Cheers Jo. 2011/1/19 Amanda and Hugh Gardner <hagardner@bigpond.com>
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
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Joann Ransom RLIANZA Head of Libraries, Horowhenua Library Trust. *Q: Why is this email three sentences or less? A: http://three.sentenc.es*
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
Hi Amanda, What a terrible situation you are in. We are a Koha support company in Sydney. If you'd like to give us a call, we can talk you through the various tables and data fields that might be useful, if that will help (gratis of course). We'll actually be in Brisbane next week for Linux Conf if that is relevant to you. Sorry about your circumstances. Bob Birchall CALYX Mob: 0414 796 988 On 19/01/11 14:31, Amanda and Hugh Gardner wrote:
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
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Bob Birchall Director Calyx Group Pty Limited Mob: 0414 796 988 Email: bob@calyx.net.au Web: www.calyx.net.au
* Amanda and Hugh Gardner (hagardner@bigpond.com) wrote:
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 Hi Amanda
As we confirmed off list that you are running 2.2.7 you wont be able to do this from within Koha. But if you can login to the server that Koha is running on. Then look at the /etc/koha.conf file. In there will be the name of the database, and a user and a password. run mysql -u username_from_file -p databasename_from_file it will then prompt you for the password, enter in the one from the file you should end up at a prompt that looks like mysql> Cut and paste this sql in SELECT itemtype,title,publishercode,publicationyear,isbn,issn,barcode FROM biblio,biblioitems,items WHERE biblio.biblionumber=biblioitems.biblionumber AND biblioitems.biblioitemnumber = items.biblioitemnumber ORDER BY biblio.biblionumber INTO OUTFILE '/tmp/itemlist.csv'; When that finishes running type quit; Then in /tmp/ on that machine there should be a file itemlist.csv which you should be able to open with excel or access. It is a tab separated text file which should be opened fine by either of them (chose tab as separator if it asks you when importing. Hopefully this will work for you. Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand
participants (5)
-
Amanda and Hugh Gardner -
Bob Birchall -
Chris Cormack -
Joann Ransom -
LAURENT Henri-Damien