Hi, On Fri, May 24, 2013 at 7:32 AM, Steven Nickerson <snicker1@maine.rr.com> wrote: <snipped>
but don't know the MySQL statement(s) to "import" it and exactly what fields in Koha's 'old_items' table that are required. Any comments/tips/thoughts
what you probably want here is 'old_issues' table and not 'old_items' http://schema.koha-community.org/tables/old_issues.html
Also, I'm assuming that if I accomplish this successfully I should also be able to do pretty much the same thing to get the currently checked-out items imported into the 'items' table as well.does that sound like a reasonable assumption/expectation?
not the 'items' table. It is the 'issues' table which hold the currently checked out items. http://schema.koha-community.org/tables/issues.html cheers -- Indranil Das Gupta Phone : +91-98300-20971 Blog : http://indradg.randomink.org/blog IRC : indradg on irc://irc.freenode.net Twitter : indradg -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards. For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org