Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: explain how to export authority record from SOLR

...

The look-up UI is currently the only place this information is sent to. However just a limited number of fields are sent. The place in the source code to modify to get more fields there is org.dspace.authority.orcid.OrcidAuthorityValue#choiceSelectMap. This is also documented in the readme of the org.dspace.authority package.

You can eventually query and export the information directly from the SOLR authority core if needed (see the FAQ belows)

How to add additional metadata fields in the authority cache that are not related to ORCID?

...

It is found in the config/spring/api/orcid-authority-services.xml configuration file. Look for the <bean name="OrcidSource">, which is initialized with a URL of http://pub.orcid.org 

How can I export all the authority records that have an ORCID?

Please note that all the links below assume that you are running solr on localhost and you use the standard core names without prefix.

Authority records with an ORCID are the solr document with a orcid_id field.

The following solr query will identify such records

orcid_id:*

http://localhost:8983/solr/authority/select?indent=true&q.op=OR&q=orcid_id%3A*

to get only the SOLR Authority records used by some DSpace items, you need to perform a join search in SOLR (https://solr.apache.org/guide/solr/latest/query-guide/join-query-parser.html) between the authority and the search core. This is a sample query that you can customize to include additional metadata other than dc.contributor.author

{!join from=dc.contributor.author_authority to=id fromIndex=search}dc.contributor.author_authority:*

http://localhost:8983/solr/authority/select?indent=true&q.op=OR&q=%7B!join%20from%3Ddc.contributor.author_authority%20to%3Did%20fromIndex%3Depflsearch%7Ddc.contributor.author_authority%3A*

eventually you can filter them using the previous query orcid_id:* (as a fq) to get only the authority records that are used by some dspace items and have an ORCID.

http://localhost:8983/solr/authority/select?fq=orcid_id%3A*&indent=true&q.op=OR&q=%7B!join%20from%3Ddc.contributor.author_authority%20to%3Did%20fromIndex%3Depflsearch%7Ddc.contributor.author_authority%3A*

Usually, you need to export the solr document id, last_name, first_name and orcid_id fields, the id field contains the uuid used in your metadata as "authority" in the metadatavalue table. Using a such an export (you can force the CSV format using the wt parameter in solr)

http://localhost:8983/solr/authority/select?fl=id%2Clast_name%2Cfirst_name%2Corcid_id&fq=orcid_id%3A*&indent=true&q.op=OR&q=%7B!join%20from%3Ddc.contributor.author_authority%20to%3Did%20fromIndex%3Depflsearch%7Ddc.contributor.author_authority%3A*&wt=csv

you can

  • create a CSV to import the authority record in DSpace as Person item (the SOLR output must be adapted to the DSpace Bulk Edit format)
  • manipulate a CSV export of the dspace item to replace the authority value with a relation to the Person items