Hi Amanda,<br>
<br>
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). <br>
<br>
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'.<br>
<br>
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.<br>
<br>
Good luck<br>
<br>
Cheers Jo.<br><br><div class="gmail_quote">2011/1/19 Amanda and Hugh Gardner <span dir="ltr"><<a href="mailto:hagardner@bigpond.com">hagardner@bigpond.com</a>></span><br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div>
<div><font size="2" face="Arial"><span>Hi
All,</span></font></div>
<div><font size="2" face="Arial"><span></span></font> </div>
<div><font size="2" face="Arial"><span>I'm hoping I can get
some advice with regard to pulling data from Koha. </span></font></div>
<div><font size="2" face="Arial"><span></span></font> </div>
<div><font size="2" face="Arial"><span>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.</span></font></div>
<div><font size="2" face="Arial"><span></span></font><font size="2" face="Arial"><span></span></font><font size="2" face="Arial"><span></span></font> </div>
<div><font face="Arial"><font size="2"><span>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
</span>create an spreadsheet.</font></font>
<div dir="ltr" align="left"><span></span> </div>
<div dir="ltr" align="left"><font size="2" face="Arial"><span>The data I need are from the following
fields:</span></font></div>
<div dir="ltr" align="left"><font size="2" face="Arial"><span></span></font> </div>
<div dir="ltr" align="left"><font size="2" face="Arial"><span>Item type</span></font></div>
<div dir="ltr" align="left"><font size="2" face="Arial"><span>Title</span></font></div>
<div dir="ltr" align="left"><font size="2" face="Arial"><span>Publisher</span></font></div>
<div dir="ltr" align="left"><font size="2" face="Arial"><span>Date</span></font></div>
<div dir="ltr" align="left"><font size="2" face="Arial"><span>ISBN</span></font></div>
<div dir="ltr" align="left"><font size="2" face="Arial"><span>ISSN</span></font></div>
<div dir="ltr" align="left"><font size="2" face="Arial"><span>Item count</span></font></div>
<div dir="ltr" align="left"><font size="2" face="Arial"><span>Location</span></font></div>
<div dir="ltr" align="left"><font size="2" face="Arial"><span>Barcode</span></font></div>
<div dir="ltr" align="left"><font size="2" face="Arial"><span></span></font><font size="2" face="Arial"><span></span></font> </div>
<div dir="ltr" align="left"><font size="2" face="Arial"><span><span>Can this be done from
the back end of Koha and if so, how do I do it?
</span></span></font></div>
<div dir="ltr" align="left"><font size="2" face="Arial"><span><span></span></span></font> </div>
<div dir="ltr" align="left"><font size="2" face="Arial"><span><span>Any advice would be
greatly appreciated, keeping in mind I am not familiar with this database at all
and will have no IT support.</span></span></font></div>
<div dir="ltr" align="left"><font size="2" face="Arial"><span><span></span></span></font> </div>
<div dir="ltr" align="left"><font size="2" face="Arial"><span><span>Many
thanks,</span></span></font></div>
<div dir="ltr" align="left"><font size="2" face="Arial"><span><span></span></span></font> </div>
<div dir="ltr" align="left"><font size="2" face="Arial"><span><span>Amanda</span></span></font></div>
<div dir="ltr" align="left"><font size="2" face="Arial"><span><span></span></span></font> </div></div></div>
<br>_______________________________________________<br>
Koha mailing list <a href="http://koha-community.org" target="_blank">http://koha-community.org</a><br>
<a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Joann Ransom RLIANZA<br>Head of Libraries,<br>Horowhenua Library Trust.<br><br><i>Q: Why is this email three sentences or less?<br>
A: <a href="http://three.sentenc.es" target="_blank">http://three.sentenc.es</a></i><br><br>
<div style="visibility: hidden; left: -5000px; position: absolute; z-index: 9999; padding: 0px; margin-left: 0px; margin-top: 0px; overflow: hidden; word-wrap: break-word; color: black; font-size: 10px; text-align: left; line-height: 130%;" id="avg_ls_inline_popup">
</div>