Fixing ILLiad at

Ohio State for

Health Sciences

 

Angela Galvan

The Ohio State University

Health Sciences Library 

User experience matters everywhere.

ILL is a service.

It should be awesome and seamless!

"Angela, don't we have to use DOCLINE if we're in health sciences resource sharing?"

NOPE!*

 

 

 

 

*You'll keep it for Lending, if you want.

I wish I would have: 

  • Run an ILLiad database cleanup first.
  • Checked the Billing Manager.
  • Scripted updates for: 
    • Department/Status.
    • Billing Category. 
    • Anything else we needed to harmonize. 

Sample Script

Use OSUData

 

update LenderAddressesALL set BillingCategory = ‘OS2$10′

 

where ((BillingCategory like ‘%Default%’)

or (BillingCategory like ‘%OS2 Default$11%’)

or (BillingCategory like ‘%OS2  $10%’))

 

and NVTGC=’OS2′

Thanks! 

Photo CC-BY leg0fenris

X all the Y memes originally by Allie Brosh

Made with Slides.com