Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Topics

Table of Contents

Accession

Q: Does the Accession (Ongoing) fail in SCSB despite having an unique item barcode?

A: It is possible that the different barcode have the same item id. SCSB expects the owning institution item id to be unique. This is unlikely to occur though we have seen such records among partner's data. This is a data issue and must be fixed at the partner's ILS before attempting to accession again.

Customer Code

Q: How to add new or edit / delete existing Customer Code / Delivery Locations to the in SCSB application?

A: The Customer Code and Delivery Locations are part of the customer_code_t table (columns CUSTOMER_CODE and DELIVERY_RESTRICTIONS). New additions, modifications or deletions needs to be handled by using appropriate SQL scripts to insert, update or delete the data.

Code Block
languagesql
titleSample Insert query
INSERT INTO `recap`.`customer_code_t` (`CUSTOMER_CODE_ID`, `CUSTOMER_CODE`, `DESCRIPTION`, `OWNING_INST_ID`, `DELIVERY_RESTRICTIONS`, `PWD_DELIVERY_RESTRICTIONS`, `RECAP_DELIVERY_RESTRICTIONS`, `CIRC_DESK_LOCATION`) VALUES ('100', 'ZZ', 'ZZ', '1', 'ZZ', 'ZZ', 'ZZ', 'ZZ');


Code Block
languagesql
titleSample Update query
UPDATE `recap`.`customer_code_t` 
SET 
    `CUSTOMER_CODE_ID` = '11',
    `CUSTOMER_CODE` = 'SZ',
    `DESCRIPTION` = 'ZZ',
    `DELIVERY_RESTRICTIONS` = 'ZZ',
    `PWD_DELIVERY_RESTRICTIONS` = 'ZZ',
    `RECAP_DELIVERY_RESTRICTIONS` = 'ZZ',
    `CIRC_DESK_LOCATION` = 'ZZ'
WHERE
    `CUSTOMER_CODE_ID` = '10';


Code Block
languagesql
titleSample Delete query
DELETE FROM `recap`.`customer_code_t` WHERE `CUSTOMER_CODE_ID`='9';

Solr

Q: How to optimize Solr Index in SCSB?

A: Please follow the Solr Optimization Guide here.