[Koha] Importing Circulation History data

Indranil Das Gupta indradg at gmail.com
Fri May 24 16:46:14 NZST 2013


Hi,

On Fri, May 24, 2013 at 7:32 AM, Steven Nickerson <snicker1 at 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


More information about the Koha mailing list