Dear Ansie, if you intend to start with a clean slate for author authorities, there are two places where you can delete data.
*1. Database - authority key field in the metadatavalue table* cfr the db schema reference https://wiki.duraspace.org/display/DSDOC6x/Storage+Layer?preview=/68069687/78157937/dspace6.png If you still use the authority key field for something else on other fields, you may only want to wipe it on metadata fields where you had ORCID activated on (dc.contributor.author, ..) *2. SOLR Authority core* Aside from the database, your SOLR authority core will also be filled with authority records from ORCID. To delete those, navigate to, or issue a curl statement to the following, from a machine where you have access: path-to-solr/authority/update?stream.body=<delete><query>*:*</query></delete>&commit=true If you (or anyone else reading this) are interested in additional assistance, configuration or customization of the default DSpace ORCID implementation, feel free to shoot me an email. with kindest regards, Bram [image: logo] Bram Luyten *250-B Luci*us Gordon Drive, Suite 3A, West Henrietta, NY 14586 Gaston Geenslaan 14, 3001 Leuven, Belgium atmire.com <http://atmire.com/website/?q=services&utm_source=emailfooter&utm_medium=email&utm_campaign=braml> On 27 August 2018 at 15:33, Van der Westhuizen, Ansie <[email protected]> wrote: > > > Good afternoon > > > > We are in the process of upgrading our Dspace from Dspace 5.4 to Dspace > 6.3. We have enabled ORCID previously, but it has not been successful. Now > we are sitting with numerous Authority IDs for authors - from which several > are identical. Is there any way to strip all these items from the Authority > IDs from the sql command prompt? > > > > Your assistance will be much appreciated. > > > > Regards > > > > [image: e-mail-sig-photo] > > > > [image: e-mail-sig-logo2] > > > > *Mrs Ansie van der Westhuizen* > > *Non-Commercial Digital Developer: Institutional Repository Manager* (IR > Content Management) > > Library Services > > *Tel:* 012 429 3426 > > *E-mail:* [email protected] > > orcid.org/0000-0002-9268-992x > > > > [image: e-mail-sig-F] > <https://www.facebook.com/UniversityOfSouthAfrica> [image: > e-mail-sig-TW] <https://twitter.com/unisa> [image: e-mail-sig-L] > <https://www.linkedin.com/edu/university-of-south-africa/universiteit-van-suid-afrika-19881> > [image: e-mail-sig-Y] <https://www.youtube.com/user/UnisaVideos> > > > http://www.unisa.ac.za > > > > > > > > [image: e-mail-sig-photo] > > > > [image: e-mail-sig-logo2] > > > > *Mrs Ansie van der Westhuizen* > > *Non-Commercial Digital Developer: Institutional Repository Manager* (IR > Content Management) > > Library Services > > *Tel:* 012 429 3426 > > *E-mail:* [email protected] > > orcid.org/0000-0002-9268-992x > > > > [image: e-mail-sig-F] > <https://www.facebook.com/UniversityOfSouthAfrica> [image: > e-mail-sig-TW] <https://twitter.com/unisa> [image: e-mail-sig-L] > <https://www.linkedin.com/edu/university-of-south-africa/universiteit-van-suid-afrika-19881> > [image: e-mail-sig-Y] <https://www.youtube.com/user/UnisaVideos> > > > http://www.unisa.ac.za > > > > > > -- > 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 Community" 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-community. > For more options, visit https://groups.google.com/d/optout. > -- 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 Community" 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-community. For more options, visit https://groups.google.com/d/optout.
