Project

General

Profile

Actions

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
Category:
cdm
Target version:
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 #1

Updated by Andreas Müller about 5 years ago

  • Status changed from New to In Progress
Actions #2

Updated by Andreas Müller about 5 years ago

Actions #3

Updated by Andreas Müller about 5 years ago

Actions #4

Updated by Andreas Müller about 5 years ago

  • Blocks bug #7092: Adapt dates in Nicks images after mediaCreated became TimePeriod added
Actions #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 #6

Updated by Andreas Müller over 4 years ago

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

Updated by Andreas Müller over 4 years ago

  • Description updated (diff)
Actions #8

Updated by Andreas Müller over 4 years ago

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

Updated by Andreas Müller over 4 years ago

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

Updated by Andreas Müller over 4 years ago

Actions #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 #12

Updated by Andreas Müller 9 months ago

Actions

Also available in: Atom PDF