Related Topics • INFO: ISO Auto Holding of Received APDU until Shipped APDU is received from Lender • INFO: Changing Note Types for ISO • INFO: Expire Dates and ISO ILL • INFO: Forwarding Requests via ISO ILL • See more

Other Support Options • Contact Atlas Systems Phone Numbers, Support Options, Online Help, and more. • Listserv Pose a question to other users.

Page Tools Print this page E-mail this page

Feedback How helpful was this article? 5 Best 4 3 2 1Worst 0 N/A Suggestions:

SUMMARY

If going live with the entire ILLiad System, there is a script in the Implementation Manual. However, once live with one module, a different script must be run to go live with Borrowing/Doc Del or Lending separately.

BORROWING EXAMPLES

Going Live with Borrowing Only (single server)

use ILLData
go
delete from Users where Username <> 'Lending' and Username <> 'Unmatched' and Username not in
(select Symbol from DeliveryLocations)
go
delete from ESPUpdate where ProcessType <> 'Lending'
go
update Transactions set SpecIns = Username, Username = 'BeforeLiveTest', ProcessType =
'TestBorrow' where ProcessType = 'Borrowing'
go
delete from UserAccounts
go
delete from UserAccountsLink
go
delete from UserNotes
go

Going Live with Borrowing Only (shared server) - replace XYZ with your site code

use ILLData
go
update Transactions
set ProcessType = 'TestXYZ', SpecIns = UserName, Username = 'BeforeLiveTest', TransactionStatus =
'Cancelled by ILL Staff'
where ProcessType = 'Borrowing'
and Username in (select username from UsersALL where NVTGC = 'XYZ')
go

LENDING EXAMPLES

Going Live with Lending Only (single server)

use ILLData
go
delete from ESPUpdate where TransactionNumber in
(select TransactionNumber from Transactions where ProcessType = 'Lending')
go
update Transactions set SpecIns = Username, Username = 'BeforeLiveTest', ProcessType = 'TestLend'
where ProcessType = 'Lending'
go

Going Live with Lending Only (shared server) - replace XYZ with your site code

use ILLData
go
delete from ESPUpdate where TransactionNumber in
(select TransactionNumber from Transactions where ProcessType = 'Lending' and Username = 'XYZ')
go
update Transactions set SpecIns = Username, Username = 'BeforeLiveTest', ProcessType =
'TestLendXYZ' where ProcessType = 'Lending' and Username = 'XYZ'
go