Issue 14871

Check how date-time is processed in our publishing and indexing process

14871
Reporter: bko
Assignee: bko
Type: Task
Summary: Check how date-time is processed in our publishing and indexing process
Priority: Critical
Resolution: Done
Status: Closed
Created: 2014-01-21 16:21:48.319
Updated: 2014-01-23 17:09:09.504
Resolved: 2014-01-23 16:43:05.985
        
Description: From DanBIF, a question about whether the date-time in the following format
{{17-05-2013 09:49}} works with our data publishing and indexing process. The format should follow recommended ISO 8601:2004(E) standard. See http://terms.tdwg.org/wiki/dwc:eventDate

This includes generating a DwC-A for testing, feed into IPT, and trigger the crawling. From the result we should see whether there is any issue with our processing on date-time. ]]>
    

Attachment eventDate.png



Author: bko@gbif.org
Created: 2014-01-22 16:15:40.836
Updated: 2014-01-22 16:15:40.836
        
In the registry-sandbox:
http://registry-sandbox.gbif.org/web/index.html#/dataset/03065ca1-d973-4b23-a3d1-d13a694d56d6?uuid=03065ca1-d973-4b23-a3d1-d13a694d56d6

Andrei is working on staging so stop here and follow up later.
    


Author: bko@gbif.org
Created: 2014-01-23 16:40:29.977
Updated: 2014-01-23 16:40:29.977
        
Putting date time variations in http://terms.tdwg.org/wiki/dwc:eventDate shows how our indexing processes data time. Please see attached image.

It looks like the current processing need at least complete yyyy-mm-dd in eventDate. The processing doesn't honour intervals expressed following the definition. In all cases, time is not processed correctly, including interval of time and timezone information.


    


Author: bko@gbif.org
Comment: The result of eventDate processing.
Created: 2014-01-23 16:42:02.296
Updated: 2014-01-23 16:42:02.296


Author: bko@gbif.org
Comment: The checking is done. Now it's up to decision whether we improve this part.
Created: 2014-01-23 16:43:06.007
Updated: 2014-01-23 16:43:06.007


Author: jlegind@gbif.org
Created: 2014-01-23 16:59:36.109
Updated: 2014-01-23 16:59:36.109
        
Good job Burke :)
This will be a useful reference in the future.
    


Author: bko@gbif.org
Comment: Looks like POR-944 and POR-954 are related.
Created: 2014-01-23 17:09:09.504
Updated: 2014-01-23 17:09:09.504