Sirsi Admin

• Deduping eBooks
• Reordering eBook 856 links to an order we define, NOT lastest enter3ed
• Uploading delete records to EDS
• New books display on website with Library Thing?

We have to use the sirsi user in order to run API and do other administrative type tasks.

Open putty 

to switch to sirsi user type: sudo su - sirsi

enter your samID password 

Command line hints

Subscription Renewals

selorder -f=2019 -tSUBSCRIPT -b">0" -oOVJ | selorderlin -iO -v">0" -w"=0" -A">20190430<20190901" -B"=0" -H"E-BOOK,EBP,EJ-PACKAGE,RAS,SM" -oCSAnOW.9012.W.9013. | selcatalog -iC -e"260,264" -oSte | selvendcyc -iV -oWS | selvendor -iK -oSJ

Feb 1  - June-Sept renewal dates

June 1 - Oct-Jan renewal dates

Oct 1 Feb-May renewal dates

NGL|FY|ORDER-ID |

cat file.txt | selorder -iJ -oJd

selcharge -d">20190511<20190607" -qY -oUId | seluser -iU -oSpB | selitem -iI -oSB > 60daysOverdue1.txt
selcharge -d">20190511<20190609" -qY -oUId | seluser -iU -oSpB | selitem -iI -oISB | selbill -iI -oSr > Morethan60days_bills1.txt

Put in same Workbook
Use VLOOKUP to look by item ID in the bills to see if LOST is a bill reason

example: =VLOOKUP(C4,Sheet2!$D$1:$E$14,2,False)