GitLab

Can you please share a working example of DataTime conversion?

Load manifest (JSON) showing actual data and also matching "meta" block for a date field.

I tried the following in Load Manifest (AWS R3M8 Preship environment) -

Data has this line -

"ProjectEndDate": "2008-02-01T14:00:00.000+03:00",

Meta block has this for DateTime conversion -

{
   "kind": "DateTime",
    "name": "UTC-ISO8601",
    "persistableReference": "{\"format\":\"yyyy-MM-ddTHH:mm:ss.fffZ\",\"timeZone\":\"UTC\",\"type\":\"DTM\"}",
    "propertyNames": [
           "ProjectEndDate  ]
}

I see this error when I query for troubleshooting (Search service) .

For now, we can simply discuss problem of DateTime conversion.

{
    "kind": "osdu:wks:master-data--SeismicAcquisitionSurvey:1.0.0",
    "query": "id: \"osdu:master-data--SeismicAcquisitionSurvey:ST0202R08-DC-23Oct\"",
     "returnedFields": [
        "id",
        "index"
    ]
}

Response

{
    "results": [
        {
            "index": {
                "trace": [
                    "Unit conversion: persistableReference not valid",
                    "Unit conversion: persistableReference not valid",
                    "DateTime conversion: Frame of reference does not match given data for property ProjectEndDate, no conversion applied."
                ],
                "statusCode": 400,
                "lastUpdateTime": "2021-10-23T10:13:21.496Z"
            },
            "id": "osdu:master-data--SeismicAcquisitionSurvey:ST0202R08-DC-23Oct"
        }
    ],
    "totalCount": 1
}

Thanks for your help.

cc - @gehrmann for information

cc - @jingdongsun , @anujgupta and @shamazum (since some work was done by IBM resources in this area, as far as I remember)