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.
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.
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.
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.
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
1. Export report of desired checked out books
Koha > Report > Create from SQLUse 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 circulationhttps://addons.mozilla.org/en-US/firefox/addon/koct/
Koha offline circulation file format
https://wiki.koha-community.org/wiki/Koha_offline_circulation_file_format
No comments:
Post a Comment