EPrints Technical Mailing List Archive

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

Message: #10080

To: "eprints-tech@ecs.soton.ac.uk" <eprints-tech@ecs.soton.ac.uk>
Subject: [EP-tech] Populate ORCID numbers on all enprintid where the creator name is found.
From: "Beaudoin, Mario" <Mario.Beaudoin@uqtr.ca>
Date: Thu, 10 Apr 2025 14:48:37 +0000

CAUTION: This e-mail originated outside the University of Southampton.

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.

Follow-Ups:
- Re: [EP-tech] Populate ORCID numbers on all enprintid where the creator name is found.
  - From: David R Newman <drn@ecs.soton.ac.uk>