Hi Helix, Thank you for your response. Answers to your questions are below:
It seems strange that you would get such column in BME if there were no values in it. I can think of these options: a) is that an export of your whole repository or only a part of it (e.g. collection)? If it's only a part, maybe the null is in an item that is not part of your current export. At first, I exported the whole repository, which is when I found the "xyz" column. I then went through and exported each collection individually and found that the "xyz" column is coming from only one collection. b) if BME doesn't detect any changes, do it in two turns: first, put a bogus value anywhere in that column and import it; second, re-export, remove the bogus value and import it. I am pretty sure the problem was a result of an upload I did last Friday, so I tried the bogus value import-then-remove method on just those 80 items, but it did not remove the "xyz" column. The collection has about 3000 items in it, so I cannot use the UI BME on the whole collection, but if I use Item Update through the CLI interface, won't the [en_US] be added automatically? I ran the queries you suggested, but I am new to looking at the database itself, so I am not sure how to interpret these results (I currently have 8712 items in the repository): SELECT text_lang FROM metadatavalue GROUP BY text_lang; "" "" "en" "en_US" SELECT count(*) FROM metadatavalue WHERE text_lang IS NULL; 25569 SELECT count(*) FROM metadatavalue WHERE text_lang = 'en_US'; 342570 SELECT count(*) FROM metadatavalue WHERE text_lang = ''; 574 Are these numbers counting metadata fields that do not usually have language codes in text_lang such as dc.identifier.uri, dc.date.accessioned, and dc.date.available? David ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
