Page Comparison

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 in SCSB application?

...

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');

...

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';

...

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.