Other Support Options
|
| • |
Listserv
Pose a question to other users. |
|
|
| Revised | : | January 4, 2006 (mc) |
| Version | : | Client 6.1 and higher |
| Revision | : | 1 |
PROBLEM: Cancellations or OCLC Reasons for No are all updating as Other
January 4, 2006
SUMMARY
After updating to version 6.1 of the ILLiad Client, you may notice that in a shared server configuration all of your requests update as the reason other for cancellations and conditionals regardless of the reason chosen in the list. This is because of a change in 6.1 that allowed all shared servers to split out those reasons for each site. In order to use this, though, you must have a list of cancellation reasons in your tables for each NVTGC code.
The update for 6.1 did not populate these tables automatically because some shared server installations had already split out their cancellation reasons ahead of time. Below is a script that will allow you to take your current reasons and replicate them for all of your NVTGC codes in your database. Be sure to backup the database before running such a script.
EXAMPLE
Connect to your ILLData database using SQL Enterprise Manager on your SQL Server as either the "sa" user or Windows authentication. Take this example script below and run it on your ILLData database for each NVTGC code, replacing the piece of the script in red with your NVTGC code
use ILLData
go
insert into LendingReasonsforCancellation
select ReasonNumber, 'ABC', Reason, DefaultNote, OCLCCode, DoclineCode, RLINCode
from LEndingReasonsforCancellation where NVTGC = 'Lending'
go
insert into LendingReasonsforCond
select ReasonNumber, 'ABC', Reason, DefaultNote, OCLCCode, DoclineCode, RLINCode
from LEndingReasonsforCond where NVTGC = 'Lending'
go
insert into ReasonsforCancellation
select ReasonNumber, 'ABC', Reason, DefaultNote
from ReasonsforCancellation where NVTGC = 'ILL'
go
insert into DocDelNotFoundReasons
select ReasonNumber, 'ABC', Reason, DefaultNote
from DocDelNotFoundReasons where NVTGC = 'ILL'
go
