[EP-tech] Date Record Created

James Kerwin jkerwin2101 at gmail.com
Mon Aug 24 16:30:22 BST 2020


Oh it certainly appears to be still happening as we speak (searching for
August 2020 and revision = 1):

mysql> select objectid,actor,revision, timestamp_month from history where
datasetid = "eprint" and revision = 1 and timestamp_year  = 2020 and
timestamp_month = 8;

(just the bottom of the 5000 rows)

|  3098698 | /opt/eprints3/bin/get_records |        1 |               8 |
|  3098698 | /opt/eprints3/bin/get_records |        1 |               8 |
|  3098699 | /opt/eprints3/bin/get_records |        1 |               8 |
|  3098699 | /opt/eprints3/bin/get_records |        1 |               8 |
|  3098700 | /opt/eprints3/bin/get_records |        1 |               8 |
|  3098700 | /opt/eprints3/bin/get_records |        1 |               8 |
|  3098701 | /opt/eprints3/bin/get_records |        1 |               8 |
|  3098701 | /opt/eprints3/bin/get_records |        1 |               8 |

I think I had better give the uni a bit of a poke for our RT2 money!
Admittedly, not the best time to be asking for cash.

Thanks,
James

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

> This might be an artefact of the older versions of the Symplectic
> connector.
> I think it used to create an EPrints to compare possible merges, and then
> throw it away.
>
> I don't think this should still be happening - maybe see what the main /
> max dates are for these records to see if it's still happening?
> Look at the 'actor' data for the records too.
>
>
>
> 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 16:03
> *To:* eprints-tech at ecs.soton.ac.uk
> *Cc:* John Salter <J.Salter at leeds.ac.uk>
> *Subject:* Re: [EP-tech] Date Record Created
>
>
>
> Should I be concerned about the number of "empty" eprint IDs I see in the
> history table?
>
>
>
> It appears there are a lot that have two instances of "revision = 1" where
> the record appears to be briefly created and then immediately destroyed and
> the relevant ID is skipped over and never used. I am making sure that I
> only look for "datasetid = eprint".
>
>
>
> I don't want to get too bogged down with this because it's not the end of
> the world, but I am tempted to pull on the thread and see what's going on.
>
>
>
> Thanks,
>
> James
>
>
>
>
>
> On Mon, Aug 24, 2020 at 2:41 PM James Kerwin via Eprints-tech <
> eprints-tech at ecs.soton.ac.uk> wrote:
>
> 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
>
> *** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> *** Archive: https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C91fe209117234e8a725f08d84842a448%7C4a5378f929f44d3ebe89669d03ada9d8%7C0&amp;sdata=0LGgIM08drqCf45dpa7JFIgT5HWc6dq5bW1u%2BVBCE0M%3D&amp;reserved=0
> <https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C91fe209117234e8a725f08d84842a448%7C4a5378f929f44d3ebe89669d03ada9d8%7C0&amp;sdata=0LGgIM08drqCf45dpa7JFIgT5HWc6dq5bW1u%2BVBCE0M%3D&amp;reserved=0>
> *** EPrints community wiki: https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C91fe209117234e8a725f08d84842a448%7C4a5378f929f44d3ebe89669d03ada9d8%7C0&amp;sdata=rIIpAdIHKCK2XrgWPm%2BwMss62AQ0SuiE94x9bD20TQg%3D&amp;reserved=0
> <https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C91fe209117234e8a725f08d84842a448%7C4a5378f929f44d3ebe89669d03ada9d8%7C0&amp;sdata=rIIpAdIHKCK2XrgWPm%2BwMss62AQ0SuiE94x9bD20TQg%3D&amp;reserved=0>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20200824/2a4af7d2/attachment-0001.html 


More information about the Eprints-tech mailing list