3

I have a data source with string fields containing dates formatted like 20180202120000 (YYYYMMDDhhmmss) and I would like to write these in date fields in a shapefile using FME (2016.1).

UPDATE: Feature Type Properties for [ESRISHAPE] writer:

enter image description here

In order to get the required ISO date format YYYY-MM-DD I've set a DateFormatter transformer like shown below:

enter image description here

When I redirect the writer to FMEInspector, the result looks as expected, but in the resulting shapefile the date fields contains only NULL values.

No Idea what I'm doing wrong, any hints?

Improve this question
3
  • dBase-Iii+ doesn't allow you to choose date format.
    – Vince
    Commented Feb 2, 2018 at 11:32
  • Well the FME esrishape writer does, as can be seen in my updated answer.
    – Eva Großmann
    Commented Feb 2, 2018 at 12:55
  • No, I mean you have to use YYYYMMDD to store the data. You can chosse invalid formats, or you chosse the only supported one and have it work.
    – Vince
    Commented Feb 2, 2018 at 17:54

1 Answer 1

Reset to default
3

Meanwhile I found an answer to this issue myself. There is an entry in the FME Knowledge Center concerning the problem:

https://knowledge.safe.com/questions/46033/date-is-shown-in-inspector-but-not-coming-up-in-sh.html

Bottom line is that Destination Date Format must be set to FME Date (%Y%m%d), then everthing works fine:

enter image description here

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.