Hi..it's Sandra again (KOHA 2.2.5 user)...David, Jason and Thomas...thanks for your suggestions on exporting the data..I'm sure they're all possible and would work.....but our IT have not been able to come up with the requested table :(. The data they have extracted is jumbled and incomplete. From our 4000 biblio records we have only 1750 titles, (and actually with matching author in adjoining colomn), but without matching barcodes, classification and pricing of the almost 8000 items, they're in separate colomns elsewhere on the 1000 page excel sheet. Our IT have asked me to give step by step instructions on how to export the requested data: the data I wanted on the table is (exactly as in the email I wrote to out IT) :

Information to include in library inventory Excel or Access database, Excel format is the easiest for us to use.

Title:                          Tab 1 245a

Author:                      Tab 0 100a    or         Tab1   245c

Classification:           Tab0   082a    or        Tab5    942k

Price:                         from Item Price

Barcode:                   Tab0   082b or             Tab5  942a        or       from Item Barcode

 

One other fields that it would be useful for you to include is:

Itemtype:      Tab 5  942c

The bold type indicates the preferred source for information, many thanks in advance.

Failing step-by-step instructions on how to extract this information what are the alternatives within the system for an efficient stocktaking? I've not been able to find anything about this subject in help documentation. Our accounting has also requested a print list of our inventory - help please

Many thanks in advance

Sandra Brook

Cairo, Egypt