EPrints Technical Mailing List Archive
See the EPrints wiki for instructions on how to join this mailing list and related information.
Message: #10093
< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First
Re: [EP-tech] report on how many users with ORCIDs in our repository, but limited by year/date.
- To: "eprints-tech@ecs.soton.ac.uk" <eprints-tech@ecs.soton.ac.uk>
- Subject: Re: [EP-tech] report on how many users with ORCIDs in our repository, but limited by year/date.
- From: Tomasz Neugebauer <Tomasz.Neugebauer@concordia.ca>
- Date: Tue, 29 Apr 2025 01:04:45 +0000
CAUTION: This e-mail originated outside the University of Southampton.
I was able to construct an SQL query that does the job, it's this:
SELECT COUNT(*)
FROM user
WHERE orcid IS NOT NULL
AND orcid != ''
AND orcid_token_expires_year IS NOT NULL
AND orcid_token_expires_year <= 2044;
Then I spent the rest of the day trying to extract this same info using the EPrints API / Perl script, and I just couldn't get it to work! One error after another after another... defeat after defeat. AI coding bots had equally little success. I think
the info is in a field in the user object called orcid_token_expires, but how to extract the info to get that same information proved too much. I will try again, just because now I have to get it, but if anyone can help, it would be greatly appreciated!
Tomasz
From: eprints-tech-request@ecs.soton.ac.uk <eprints-tech-request@ecs.soton.ac.uk> on behalf of Alan.Stiles [He/Him/They] <alan.stiles@open.ac.uk>
Sent: Monday, April 28, 2025 12:27 PM To: eprints-tech@ecs.soton.ac.uk <eprints-tech@ecs.soton.ac.uk> Subject: Re: [EP-tech] report on how many users with ORCIDs in our repository, but limited by year/date. Attention This email originates from outside the concordia.ca domain. // Ce courriel provient de l'extérieur du domaine de concordia.ca
CAUTION: This e-mail originated outside the University of Southampton.
CAUTION: This e-mail originated outside the University of Southampton.
Sorry Tomasz, To my understanding, the token is valid for 20 years, so it should be before 1/1/2045, (epoch time 2366841600) but my fingers apparently couldn’t type the right date in the email last week…
Alan.
|
- Follow-Ups:
- Re: [EP-tech] report on how many users with ORCIDs in our repository, but limited by year/date.
- From: David R Newman <drn@ecs.soton.ac.uk>
- Re: [EP-tech] report on how many users with ORCIDs in our repository, but limited by year/date.
- References:
- [EP-tech] report on how many users with ORCIDs in our repository, but limited by year/date.
- From: Tomasz Neugebauer <Tomasz.Neugebauer@concordia.ca>
- Re: [EP-tech] report on how many users with ORCIDs in our repository, but limited by year/date.
- From: "Alan.Stiles [He/Him/They]" <alan.stiles@open.ac.uk>
- Re: [EP-tech] report on how many users with ORCIDs in our repository, but limited by year/date.
- From: Tomasz Neugebauer <Tomasz.Neugebauer@concordia.ca>
- Re: [EP-tech] report on how many users with ORCIDs in our repository, but limited by year/date.
- From: "Alan.Stiles [He/Him/They]" <alan.stiles@open.ac.uk>
- [EP-tech] report on how many users with ORCIDs in our repository, but limited by year/date.
- Prev by Date: Re: [EP-tech] report on how many users with ORCIDs in our repository, but limited by year/date.
- Next by Date: Re: [EP-tech] report on how many users with ORCIDs in our repository, but limited by year/date.
- Previous by thread: Re: [EP-tech] report on how many users with ORCIDs in our repository, but limited by year/date.
- Next by thread: Re: [EP-tech] report on how many users with ORCIDs in our repository, but limited by year/date.
- Index(es):