On Wednesday, April 20, 2016 at 11:28:31 AM UTC-4, Claudia Jürgen wrote: > > > > Am 20.04.2016 um 16:57 schrieb Tim Donohue: > > > > On 4/20/2016 9:44 AM, Mark H. Wood wrote: > > Is there any use case for a text_language value of an empty or blank > string? Should we not convert such values to null values in the business > logic layer on ingestion, and remove this puzzle? > > > No, there is not. It's just a hard puzzle to solve. I'm not exactly sure > *when* these empty / blank language values get into the system. > > > guess they come mostly from import and templates. (gonna check tomorrow > just leaving). > > And they are difficult to get rid of via the UI. One can only delete the > metadatum and create it again. > > Apart from making sure they are not created a curation task to clean up > would be good. Not only for empty values but invalid ones not referring to > a locale or some with trailing spaces etc. like "en ". As the text_lang > influences other things like sort in browse it would be useful. Also > checking for null values where there most likely should be some and for > fields which should not have any and got some. In older versions the > default text lang was applied to all metadata field even dates. > > Claudia > > > What prompted my original question was this duplication in the dc.contributor.author field where we are struggling to clean up authority issues. I exported records that were created by the submission forms and then some of them were edited in the UI (Mirage2) metadata editing screen. Some had empty strings and some had nulls.
I get the following results in the database: dspace=> select count(*) from metadatavalue where text_lang is null; count -------- 241888 (1 row) dspace=> select count(*) from metadatavalue where text_lang = ''; count ------- 8497 (1 row) -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
