My thoughts exactly. Thanks, Miika. On Tue, 3 Mar 2020 at 19:10, Nurminen, Miika <[email protected]> wrote:
> On 3.3.2020 15:51, Sean Carte wrote: > > It seems that in this repository all the authors have been entered > > using dc.creator rather than contributor.author. > > > > I suppose I'm going to have to find a way to move all the authors into > > contributor.author fields before any of this can work. > > > Hi Sean, > > This is probably not a recommended way compared to e.g. CSV-files or > REST updates but if modifying the database directly is an option (e.g. > during a service break with backups in place just in case), the fastest > way to accomplish this would be a SQL update, e.g. > > UPDATE metadatavalue SET metadata_field_id=[dc.contributor.author] > WHERE metadata_field_id=[dc.creator id]; > > where [...]s are numeric ids retrievable from the metadata registry > (e.g. in our database dc.contributor has id 1 and dc.contributor.author > has id 3). > > > Good luck, > Miika Nurminen > -- -- All messages to this mailing list should adhere to the DuraSpace Code of Conduct: https://duraspace.org/about/policies/code-of-conduct/ --- 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 view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/CA%2BxAuhMeuhdobgbazm5LFFbORcwK3b2cnVV6r6vGi8CZ_ZcDKQ%40mail.gmail.com.
