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?

  • dBase-Iii+ doesn't allow you to choose date format. – Vince Feb 2 '18 at 11:32
  • Well the FME esrishape writer does, as can be seen in my updated answer. – Eva Großmann Feb 2 '18 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 Feb 2 '18 at 17:54
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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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