Tracking Data entry logs
Sylvester Chikoti
Fitchett, Deborah
You could query the database if you’re up for some fun with SQL and regular expressions.
We do queries like:
select count(*) from item,metadatavalue where item.owning_collection = 'ec3f9cb5-3508-469a-ad29-77f0d15374f8' and item.uuid = metadatavalue.dspace_object_id and metadata_field_id = 11 and text_value like '2023%';
to get the number of items added to a given collection in a given year (based on the dc.date.accessioned).
The dc.description.provenance should have a “Submitted by Joe Bloggs (joe.b...@example.com) on 2024-08-28T02:16:25Z [etc etc]” line so breaking this out into the information you want should be doable, albeit a bit fiddly.
Deborah
From: dspac...@googlegroups.com <dspac...@googlegroups.com>
On Behalf Of Sylvester Chikoti
Sent: Wednesday, August 28, 2024 7:22 PM
To: DSpace Technical Support <dspac...@googlegroups.com>
Subject: [dspace-tech] Tracking Data entry logs
|
You don't often get email from chiko...@gmail.com. Learn why this is important |
|
Caution: This email originated from outside our organisation. Do not click links or open attachments unless you recognize the sender and know the content is safe. |
Hi all, I am struggling to know how may items have been submitted into dspace and by who for a certain period of time. How can i achieve this in dspace 7.6?
Thanks
--
All messages to this mailing list should adhere to the Code of Conduct:
https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx
---
You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
dspace-tech...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/dspace-tech/2e4e3c3a-cc8d-4d31-8a52-c8f9c49c7e47n%40googlegroups.com.
"The contents of this e-mail (including any attachments) may be confidential and/or subject to copyright. Any unauthorised use, distribution, or copying of the contents is expressly prohibited. If you have received this e-mail in error, please advise the sender by return e-mail or telephone and then delete this e-mail together with all attachments from your system."