Project

General

Profile

Actions
Copy link

bug #7074

closed

Use TimePeriod for Media.mediaCreated

Added by Andreas Müller about 5 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Highest
Assignee:
Andreas Müller
Category:
cdm
Target version:
CDM UML 5.0
Start date:
Due date:
% Done:

100%

Estimated time:
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 dataportalClosedAndreas Kohlbecker

Actions
Related to EDIT - feature request #6658: Make mediaCreated editable in Media viewClosedKatja Luther

Actions
Related to EDIT - task #7414: Delete mediaCreatedOldClosedAndreas Müller

Actions
Related to EDIT - feature request #7411: adapt mediaCreated in taxeditor to timePeriodClosedKatja Luther

Actions
Related to EDIT - bug #7468: Updated script for mediaCreated does not work for PostGreSQLClosedAndreas Müller

Actions
Related to EDIT - feature request #10057: Add "accessed" field to OriginalSourceBaseClosedAndreas Müller

Actions
Blocks EDIT - bug #7092: Adapt dates in Nicks images after mediaCreated became TimePeriodResolvedAndreas Müller

Actions
Actions
Copy link
 #1

Updated by Andreas Müller about 5 years ago

  • Status changed from New to In Progress
Actions
Copy link
 #2

Updated by Andreas Müller about 5 years ago

Actions
Copy link
 #3

Updated by Andreas Müller about 5 years ago

Actions
Copy link
 #4

Updated by Andreas Müller about 5 years ago

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

Updated by Andreas Müller over 4 years ago 

SELECT *
FROM Media m
WHERE m.mediaCreated IS NOT NULL

UPDATE Media
SET titleCache = Replace(mediaCreated, '-', '')
WHERE id = 271
Actions
Copy link
 #6

Updated by Andreas Müller over 4 years ago

  • Status changed from In Progress to Resolved
  • % Done changed from 0 to 50
Actions
Copy link
 #7

Updated by Andreas Müller over 4 years ago

  • Description updated (diff)
Actions
Copy link
 #8

Updated by Andreas Müller over 4 years ago

  • Related to task #7414: Delete mediaCreatedOld added
Actions
Copy link
 #9

Updated by Andreas Müller over 4 years ago

  • Status changed from Resolved to Closed
  • % Done changed from 50 to 100
Actions
Copy link
 #10

Updated by Andreas Müller over 4 years ago

Actions
Copy link
 #11

Updated by Andreas Müller over 4 years ago

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

Updated by Andreas Müller 9 months ago

Actions
Copy link

Also available in: Atom PDF