Project

General

Profile

bug #7074

Use TimePeriod for Media.mediaCreated

Added by Andreas Müller about 1 year ago. Updated 7 months ago.

Status:
Closed
Priority:
Highest
Category:
cdm
Target version:
Start date:
11/11/2017
Due date:
% Done:

100%

Severity:
critical
Found in Version:

Description

For older images it is often not exactly known when the picture was taken/created. In flora of Greece we sometimes have information such as "spring 1888" or "April 1986". This can not be handled with the current DateTime implementation.

Also the exact time is not always known, especially if you enter date manually.

Maybe we can have an extra hibernate user type which also allows to handle time if available.

Once this is finished, we need an update script and we need to update data from flora of Greece image import, images made by N. Turland. #7092


Related issues

Related to Edit - feature request #6659: Show mediaCreated in dataportal Closed 05/20/2017
Related to Edit - feature request #6658: Make mediaCreated editable in Media view Closed 05/20/2017
Related to Edit - task #7414: Delete mediaCreatedOld Resolved 05/14/2018
Related to Edit - feature request #7411: adapt mediaCreated in taxeditor to timePeriod Closed 05/14/2018
Related to Edit - bug #7468: Updated script for mediaCreated does not work for PostGreSQL Closed 06/11/2018
Blocks Edit - bug #7092: Adapt dates in Nicks images after mediaCreated became TimePeriod Resolved 11/24/2017

Associated revisions

Revision a2d22dbd (diff)
Added by Andreas Müller 7 months ago

fix #7074 Change Media.mediaCreated to TimePeriod and make let PartialUserType support hour and minute

Revision d2dc1d6d (diff)
Added by Andreas Müller 7 months ago

ref #7074 fix mediaCreated test data schema

Revision 00370c91 (diff)
Added by Andreas Müller 7 months ago

ref #7074 fix tests failing due to stricter format checking in Partial UserType

Revision ae6dcc19 (diff)
Added by Andreas Müller 7 months ago

ref #7074 adapt Media.mediaCreated in cdmlib-app

History

#1 Updated by Andreas Müller about 1 year ago

  • Status changed from New to In Progress

#2 Updated by Andreas Müller about 1 year ago

#3 Updated by Andreas Müller about 1 year ago

#4 Updated by Andreas Müller about 1 year ago

  • Blocks bug #7092: Adapt dates in Nicks images after mediaCreated became TimePeriod added

#5 Updated by Andreas Müller 7 months ago

SELECT *
FROM Media m
WHERE m.mediaCreated IS NOT NULL
UPDATE Media
SET titleCache = Replace(mediaCreated, '-', '')
WHERE id = 271

#6 Updated by Andreas Müller 7 months ago

  • Status changed from In Progress to Resolved
  • % Done changed from 0 to 50

#7 Updated by Andreas Müller 7 months ago

  • Description updated (diff)

#8 Updated by Andreas Müller 7 months ago

  • Related to task #7414: Delete mediaCreatedOld added

#9 Updated by Andreas Müller 7 months ago

  • Status changed from Resolved to Closed
  • % Done changed from 50 to 100

#10 Updated by Andreas Müller 7 months ago

#11 Updated by Andreas Müller 6 months ago

  • Related to bug #7468: Updated script for mediaCreated does not work for PostGreSQL added

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)