<p>You can certainly do this, and you don't even need access to the backend if you are running Koha 3.2.0 or later.<br>
You can do it all by creating a report from sql in the reports section.</p>
<p>I will find you the sql to do it when I get in front of a real computer (not a phone :)).</p>
<p>Sorry to hear about the lost stock, I hope Koha can be some help in the recovery, any more questions don't hesitate to ask.</p>
<p>Chris</p>
<p><blockquote type="cite">On 19 Jan 2011 17:41, "Joann Ransom" <<a href="mailto:jransom@library.org.nz">jransom@library.org.nz</a>> wrote:<br><br>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" target="_blank">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">
<p><font color="#500050">><br>> Hi All,<br>> <br>> I'm hoping I can get some advice with regard to pulling data from Koha. <br>> <br>> My ...</font></p>_______________________________________________<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" target="_blank">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><font color="#888888"><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="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%">
</div>
</font><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></p>