Talis Developer Network - Deleted works - Comments

Thank you!

Wes — Mon, 13 Nov 2006 10:11:19 +0000

Thank you Brian that is really helpful.

Perhaps I'd better go down the Alto route after all...!

deleted works

Brian Crampton — Mon, 13 Nov 2006 09:05:56 +0000

If you have a look at the work_logdelete.pl script it is not only the WORKS table that is changed.

The CONTROL_NUMBER table contains a list on control numbers and the script physically deletes any rows related to the WORK_ID in question. The CONTROL_NUMBER table also has a unique id attribute called NUMBER_ID that takes values from the CONTROL_NUMBER_RID table. Everytime a new row is inserted in the CONTROL_NUMBER table the value in the RID table is updated and then the new value used in the CONTROL_NUMBER table.

The full attributes in the table are
NUMBER_ID,
NUMBER,
MAIN,
WORK_ID,
SUBFIELD_OCC,
COLLECTION_ID,
PRIOR_ID

The rows in this table would also have to be rebuilt. The main issue would be to make sure the NUMBER_ID values were unique and that the CONTROL_NUMBER_RID table was updated to avoid conflicts e.g. duplicate CONTROL_ID values trying to be inserted by the on-line. The MAIN attribute would be "T" and the last three can have the value of 0.

It is also possible that rows in WORK_WORK_LINK were also deleted if they existed.

The safest option is to recreate the works through Alto but if you do update the database it would be important that you test any changes on the MIS server and that you are happy before making any changes on the live system.

Brian Crampton
Developer, Talis

Deleted works

Wes — Fri, 10 Nov 2006 15:51:40 +0000

Due to my (over zealous!) use of work_logdelete, we have about a dozen newly catalogued records which have been deleted as they had not yet had any items attached.

I have changed their status from 9 (deleted) to 0 (catalogued) in the WORKS table and pushed them into the WORK_UPDATE table but we still just get "No records found" when we search for them in Alto.

Am I missing a small but vital piece of sql to make them magically reappear or do I really have to input all of that data by hand...

Many grateful thanks to anyone who can help!

Wes
University of Northampton