Skip to main content
OCLC Support

How do I add and remove Delivery Locations in ILLiad?

Symptom
  • You have set up delivery locations in the Customization Manager and added them to the DeliveryLocations and the CustomDropDown tables.  You did not run any SQL commands to add the Delivery Locations.  You want to know how to add and remove Locations?
Applies to
  • ILLiad
Resolution

Because you have not run any SQL commands to add Delivery Locations in the past, you need to do the following:  ,

  1. You need to add and remove the Delivery Locations to and from the DeliveryLocations and the CustomDropDown tables.
  2. You also should check your Web Pages for NewAuthRegistration, NewUserRegistration, and ChangeUserInformation to see if you have the NVTGCs listed in the coding to know if you need to add and remove the sites from your Web pages.  If you see the NVTGCs listed, you need to add and remove the Delivery Locations.  If you do not see them listed, you do not need to make changes to your Web Pages.
  3. You can also follow the instructions for Adding Delivery Locations.
Additional information

If you had added your Delivery Location with the SQL Commands, then you would need to add the Delivery Location following the Adding Delivery Locations documentation.  For any you need to remove, you can remove them from the DeliveryLocations and the CustomDropDown tables.  You would know if you added the Delivery Locations through a SQL command previously because you would have many keys in the Customization Manager that start with the symbol.  So if you see a symbol of an example of ABC in the Delivery Locations and you Search all Tables and Keys for ABC, and you get results, then you need to add the Delivery Location through the SQL commands.  If you do not see any results, then you need to add the value to the DeliveryLocations and the CustomDropDown tables.

Page ID
19026