[Koha] Stocktaking and inventory

[Sandra Brook]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20070601/82203f42/attachment.html