This patchset add two columns to import biblios to allow for searching on these values, it should allow for future use in matching and expanded display to give more record feedback
Created attachment 66927 [details] [review] Bug 19269 - database changes
Created attachment 66928 [details] [review] Bug 19269: Rancor - Add LCCN, pubdate to indexing Also, fix control number updating for updated records
Hi Nick, can you please add a test plan for the second patch? > Also, fix control number updating for updated records
Created attachment 77910 [details] [review] Bug 19269 - database changes
Created attachment 77911 [details] [review] Bug 19269: Rancor - Add LCCN, pubdate to indexing This patch filsl the two new columns in the import_biblios table: lccn, pubdate It also fixes update of ocntrol number in the import_biblios table To test: 1 - Apply and update database 2 - Import some records 3 - Check the import table to see new columns are populated correctly 4 - check control number is correct in table too 5 - Open advanced cataloging editor 6 - Set your batch as searchable (settings->import batches) 7 - You should now be able to search batches for lccn or pubdate or control number 8 - Verify records are found as expected and can be saved to catalog or batch
Will need to be rebased with depends on bugs.
Created attachment 80989 [details] [review] Bug 19269: Rancor - Add LCCN, pubdate to indexing This patch fills the two new columns in the import_biblios table: lccn, pubdate It also fixes update of ocntrol number in the import_biblios table Because 010 fields can have leading and trailing whitespace, added trim before INSERT into import_biblios table. -cori lynn To test: 1 - Apply and update database 2 - Import some records 3 - Check the import table to see new columns are populated correctly 4 - check control number is correct in table too 5 - Open advanced cataloging editor 6 - Set your batch as searchable (settings->import batches) 7 - You should now be able to search batches for lccn or pubdate or control number 8 - Verify records are found as expected and can be saved to catalog or batch