From cb9ca825d86999213a11207f4a342bd9f4e7ef9b Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Thu, 24 Sep 2020 13:18:39 -0400 Subject: [PATCH] LP#1776954 - Add release notes Signed-off-by: Chris Sharp --- docs/RELEASE_NOTES_NEXT/Cataloging/blank_tcn_source.adoc | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 docs/RELEASE_NOTES_NEXT/Cataloging/blank_tcn_source.adoc diff --git a/docs/RELEASE_NOTES_NEXT/Cataloging/blank_tcn_source.adoc b/docs/RELEASE_NOTES_NEXT/Cataloging/blank_tcn_source.adoc new file mode 100644 index 0000000000..d2e0939b36 --- /dev/null +++ b/docs/RELEASE_NOTES_NEXT/Cataloging/blank_tcn_source.adoc @@ -0,0 +1,15 @@ +Fix For "Blank" (Empty String) TCN Source +^^^^^^^^^^^^^ +Previously, it was possible for sparsely-populated MARC records to be +saved with a TCN Source of '' (the "empty string"), which caused the +901 $b subfield to be void of data, causing errors when exporting +MARC records to such third-party programs as Zotero. + +A site that has been running without this patch for a long time might want to +check how many bib records they have with an empty tcn_source: + +SELECT COUNT(*) FROM biblio.record_entry WHERE deleted IS FALSE AND tcn_source = ''; + +Sites can fix the problem by issuing UPDATE statements to set the 901$b to a value +like 'AUTOGEN' or 'Unknown'. They should probably do it per-record, however, to +avoid locking the table in a huge commit. -- 2.11.0