Data migration: bulk check-in

Bulk check-in using .koc (Koha Offline Circulation) file is easy to use the method. It is helpful while Koha trial runs for data migration from the old version of Koha or other software. This method also can apply to other contexts. The following steps discuss how to prepare the .koc file for bulk import of check-in entries.

1. Export report of desired checked out books

Koha > Report > Create from SQL

Use following SQL query to build a report for the purpose,

SELECT issues.issuedate,items.barcode 
FROM issues 
LEFT JOIN borrowers ON borrowers.borrowernumber=issues.borrowernumber 
LEFT JOIN items ON issues.itemnumber=items.itemnumber   
LEFT JOIN biblio ON items.biblionumber=biblio.biblionumber
WHERE items.homebranch =<<Branch|branches>> AND issues.issuedate BETWEEN <<Between Date (yyyy-mm-dd)|date>> and <<and (yyyy-mm-dd)|date>> ORDER BY issues.issuedate DESC

Download the report as a CSV or ODS (Open Document Spreadsheet) file.

2. Prepare the .koc file

Open the checked-out report file and add a new column to the mention transaction type.
Copy the contents in three columns. See the sample CSV file here.

Download and open the sample .koc file from here.
Copy and paste the contents below the first line in the .koc file.

Save and close the file.

3. Import the .koc file

Goto Koha > Circulation > Offline circulation > Upload offline circulation file (.koc) 
Find and upload the .koc file. Don't worry, if the screen show time out.

Goto Koha > Circulation > Offline circulation > Pending offline circulation actions
Select all the entries and click the Process button.

References

Firefox Addon for Koha Offline circulation
https://addons.mozilla.org/en-US/firefox/addon/koct/

Koha offline circulation file format
https://wiki.koha-community.org/wiki/Koha_offline_circulation_file_format