EPrints Technical Mailing List Archive

See the EPrints wiki for instructions on how to join this mailing list and related information.

Message: #10081

< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

Re: [EP-tech] Populate ORCID numbers on all enprintid where the creator name is found.

Hi Mario,

I wrote the following script for this:

https://gist.github.com/drn05r/97814bd1875812f0f7fd5061cfd9ef54

The FindBin expects it to appear in a directory like:

/opt/eprints3/ingredients/scripts_extra/bin/tools/

So if you put it at a different path you may have to adjust the FindBin line.  If you run the script in the simplest form:

PATH_TO_SCRIPT/update_eprints_orcids ARCHIVE_ID

Then it will assume the following things:

1. Your creators_id field contains emails addresses that are also used in the email field of user records.

2. You user records have an orcid field and this is set for the user who has an email address that matches a creators ID.

3. That the names creators and probably editors field are stored in configuration like below (and in recent version of orcid_suuport Bazaar plugin);

$c->{orcid}->{eprint_fields} = ['creators', 'editors'];

There are various other options so you can configure this for your repository.  These should be listed if you run the script with --help.  E.g.

PATH_TO_SCRIPT/update_eprints_orcids --help

Regards

David Newman

On 10/04/2025 15:48, Beaudoin, Mario wrote:
CAUTION: This e-mail originated outside the University of Southampton.
CAUTION: This e-mail originated outside the University of Southampton.

Hi

 

We have several authors who just get an ORCID number and have more than 100 articles inside our repository.

I would like to know if they have a script or a way in mysql to add the ORCID number everywhere author's name is stored.

 

I try with batch edit:  delete authors and add it with ORCID but they move their position to the first place  that is not good.

Check the table  eprint_creators_name to find the author and I can add  on eprint_creators_orcid  the value  eprintid  pos and creators_orcid

But I do not think it is a good idea to write on the table like that.

 

Regards,

 

Mario Beaudoin| Chargé de projet informatique et technologique

Service de la bibliothèque |Université du Québec à Trois-Rivières

819 376-5011, poste 2258 | www.uqtr.ca

3351, boul. des Forges, C.P. 500, Trois-Rivières (Québec) G9A 5H7 | Local 4407, A.T.

 

 


*** Options: https://wiki.eprints.org/w/Eprints-tech_Mailing_List
*** Archive: https://www.eprints.org/tech.php/
*** EPrints community wiki: https://wiki.eprints.org/