[EP-tech] Date Record Created

[jkerwin2101 at gmail.com (James Kerwin)]

Ahhhh that's it! Thank you!

I'm now slightly embarrassed to say how long I spent searching through the
various EPrints tables looking for this.

The initial plan is to have a script that looks at how many items are put
in the repository and breaks them down by some time period (e.g. month). If
it's still wanted I'll make it into a button on the admin side that
provides either a spreadsheet/google docs link or maybe even use it as an
opportunity to play with graph modules etc.

We did look into something similar last year where we get the upload date
and proper deposit date (as defined by EPrints) to assess how long items
spent in review. This felt a little bit too much like surveilling staff
which isn't something I'm on board with so it was quickly dropped. "Do no
evil..." and so on.

Thanks,
James

On Mon, Aug 24, 2020 at 2:08 PM John Salter <J.Salter at leeds.ac.uk> wrote:

> Hi James,
> The 'history' dataset is your friend here!
>
> Are you wanting to do this for a handful of records, or script something?
>
>
>
> A dataset search along these lines should work:
> dataset: history
>
> datasetid: eprint
>
> dataobjid: the eprint id you are interested in
>
> action: 'create'
>
>
>
> The history dataset is searchable via the web interface, but for some
> older versions or EPrints you might want to add the 'datasetid' to the
> search form.
>
>
>
> Let me know if you need more info!
>
> Cheers,
>
> John
>
>
>
> *From:* eprints-tech-bounces at ecs.soton.ac.uk [mailto:
> eprints-tech-bounces at ecs.soton.ac.uk] *On Behalf Of *James Kerwin via
> Eprints-tech
> *Sent:* 24 August 2020 13:43
> *To:* eprints-tech at ecs.soton.ac.uk
> *Subject:* [EP-tech] Date Record Created
>
>
>
> Afternoon All,
>
>
>
> In the EPrints database is there data on when a record was created? We
> have the date an item is deposited which indicates when an item was made
> live in the repository. The record is created prior to this when a user
> uploads a file or OA Link through Elements. The record is created in the
> review buffer.
>
>
>
> When a record is modified there is a "last mod" date and when it goes into
> the live archive this is treated as the deposit date.
>
>
>
> If not I can find a way to make it happen in future. It would be
> incredibly helpful if I didn't need to do this.
>
>
>
> Thanks,
>
> James
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20200824/931dd8d7/attachment-0001.html