<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Thanks Joe, <div>I'm guessing that the `issues` and `old_issues` update the statistics file each time those particular transactions are completed? Can you point me to an example of the transaction sent via the staff pages to mysql, or give me an idea how to capture it? I'm thinking this might be a good opportunity to learn how to do transactions.</div><div><br><div><div>On Aug 20, 2009, at 5:00 PM, Joe Atzberger wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">Yes, but you are on your own to map the data out of your current system. The "issues" and "old_issues" tables hold the current and past circ transactions, respectively. Then there is a separate statistics table that is queried for some reports. You can extrapolate what goes in there by performing some test transactions and noting the result.<br> <br>--Joe<br><br><div class="gmail_quote">On Thu, Aug 20, 2009 at 11:14 AM, Erik Lewis <span dir="ltr"><<a href="mailto:elewis@ngrl.org">elewis@ngrl.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> Is there a way to load checkouts/issues, renewals, checkins, and holds/<br> reserve into koha 3.03? Got 2 reasons for wanting to do this. 1)<br> Need to see how feasible it is to migrate this data from our old<br> system, and 2) I'd like a large chunk of circ data to play with<br> retrieving of statistics.<br> </blockquote></div><br></blockquote></div><br></div></body></html>