search

ucsdlib / damsmanager

DAMS Manager
Other
3 stars 1 forks source link

Create DAMS events report #306

Closed gamontoya closed 5 years ago

gamontoya commented 5 years ago

Descriptive summary

Create a report from our db that contains events from 11:00 am Feb. 6, 2019 to 11:00 am Feb. 7, 2019

Rationale

Within the last 24 hours, a handful of objects became orphaned from the parent Data from Scripps Research Expeditions

Longshou was able to piece them back together, but we need to start investigating how this happened. This report is an initial attempt.

gamontoya commented 5 years ago

@lsitu High priority task

lsitu commented 5 years ago

@gamontoya / @arwenhutt The events report that contains the fields above (.csv format) is ready: eventsReport.csv.txt

There are a couple of issues I found in the report:

  1. The timestamp has 4 hours delayed with the PST time here. For example, I fixed the collection CLR https://library.ucsd.edu/dc/object/bb5021535s at 9:42am yesterday, but it's showing up as 2019-02-07T05:42:20+0000.
  2. The following two records that were pushed for DOI yesterday afternoon (at around 1:44pm and 2:08pm) are credited me as the editor: https://library.ucsd.edu/dc/object/bb0584631v (DOI push: 2019-02-07T09:44:44+0000) https://library.ucsd.edu/dc/object/bb5021535s (DOI push: 2019-02-07T10:08:47+0000)

Could we have a ticket to fix it? Thanks.

arwenhutt commented 5 years ago

Awesome, thanks Longshou! But let's hold off on changing anything until we figure out what caused the data loss. Otherwise it'll get harder to know what we're looking at.

arwenhutt commented 5 years ago

@lsitu to double check, does this report include all event metadata for the time period for everything in the DAMS?

lsitu commented 5 years ago

@arwenhutt That's all I can get with sparql. So I'll say yes. Just let me know if you need to review events in different date range.

lsitu commented 5 years ago

@arwenhutt I think the issue I raised above for the wrong editor credited for DOI update are fixed in PR https://github.com/ucsdlib/damsrepo/pull/79. So fell free to close the ticket now. Thanks.