1- a. In Koha > Cataloging > Batch Item Modification
b. Scan barcodes from books on cart
c. Click Continue
d. Sort by Total Checkouts
e. copy and paste all rows and columns that correspond with an Item with checkout/use history
(from upper left corner of relevant data to lower right corner) :
2 - a. Paste data to Notepad
b. copy and paste laundered data from Notepad to:
3 - a. Excel > new spreadsheet
b. paste data into top left cell
c. format barcode cells to: "number" ; decimal places "0"
d. sort table by call number
4 - a. GO Back to Koka > Batch Editing
b. Unselect all the entries that were just laundered to spreadsheet table
c. change remaining records to:
7-Not For Loan "Out for Review"
8c-Shelving Location "Decision Shelves"
d. Click Save
5- a. GO Back to spreadsheet table
b. Go to each book on Cart that is listed on spreadsheet:
c. Check for level of damage:
a-full rebind (3-4 days)
b-partial re-cover (1-2 days)
c-minor repair (<1 day)
d-WTF (needs full replacement or biohazard dump)
d. For books that AREN'T Damaged: copy call# for re-print, remove from list
e. For books that ARE Damaged, on the spreadsheet, in column next to barcode:
assign number based on used and level of damage: i.e. 1a, 2d, 26c, ...
f. Copy remaining barcodes column
6- a. GO Back to Koha > Cataloging > Item Modification
b. paste barcodes
c. Click Continue
d. change records to:
4-"Damaged"
8c-Shelving Location "Tech Services"
8y-Koha Item Type "March Edit Export Transfer"
e. Click Save
7- a. GO back to Koha > Cataloging > Export Catalog Data
b. Select Koha Item Type "March Edit Export Transfer"
c. Click Export Bibliographic Records
8- a. Open downloaded MRK file (MARCEDIT will automatically open)
b. Select "Execute"
c. Click "Edit"
d. Find & Replace "yMEET" with "yBOOK"
e. In the Add/Edit Field Utility: add Field "590"
add Field Data "\\$acujkmdam1 a"
select Add Field
f. Save file as MRC (funnel icon at the top)
9- a. GO back to Koha > Cataloging > Stage MARC Records for Import
b. Select Koha Item Type "March Edit Export Transfer"
c. Upload saved MRC file
d. Record Matching Rule "999c..."
e. Check for Embedded item record data: "Yes"
f. How to Process Items: "Replace Items if Matching Bib was found ..."
g. Click Stage for Import
h. Click View Batch after it finishes processing
i. Select 'Import this Batch into catalog'
j. Edit Each Record with the appropriate 590 cujkmdam# #
