Skip to main content
Solved

DateFormatter Data Interoperability 2017.1

  • February 21, 2018
  • 6 replies
  • 10 views

Hi,

I have just updated Data Interoperability to 2017.1 and have noticed the DateFormatter transformer has been removed with no sign of either of the new DateTime transformers...any ideas how I can get the new transformers? Or at least get back the DateFormatter? Thanks

Best answer by bruceharold

dateformatter.fmwt

We can see DateTimeConverter and DateTmeStamper are missing in Data Interoperability.

Safe will reach out to you so we can jointly understand your environment, then Safe and Esri will offer some options.

In the meantime the attached template can be used to import the old style DateFormatter into Workbench.

View original
Did this help you find an answer to your question?

6 replies

david_r
Evangelist
  • February 21, 2018

The DateFormatter was retired and the functionality has been replaced by the DateTimeConverter in FME 2017.

This was due to a major overhaul in the datetime capabilities in FME.


bruceharold
Contributor
Forum|alt.badge.img+17
  • Contributor
  • Best Answer
  • February 21, 2018
dateformatter.fmwt

We can see DateTimeConverter and DateTmeStamper are missing in Data Interoperability.

Safe will reach out to you so we can jointly understand your environment, then Safe and Esri will offer some options.

In the meantime the attached template can be used to import the old style DateFormatter into Workbench.


LizAtSafe
Safer
Forum|alt.badge.img+15
  • Safer
  • February 21, 2018
@n543

Just like David said, most of the date/time functionality is within the DateTimeConverter transformer now. Here is a blog post highlighting most of what it can do: FME2017.1: Yet Another Awesome DateTime Update

The @DateTimeFormat() function still exists within the Text Editor though. Step 6 of this exercise in the Desktop Advanced 2017 Training Manual shows how to do this.

-Liz


  • Author
  • February 21, 2018
LizAtSafe wrote:
@n543

Just like David said, most of the date/time functionality is within the DateTimeConverter transformer now. Here is a blog post highlighting most of what it can do: FME2017.1: Yet Another Awesome DateTime Update

The @DateTimeFormat() function still exists within the Text Editor though. Step 6 of this exercise in the Desktop Advanced 2017 Training Manual shows how to do this.

-Liz

Thanks Liz, unfortunately DateTimeConverter is not available either but the @DateTimeFormat() function looks like a good alternative for now. Cheers!

 

 


  • Author
  • February 21, 2018
bruceharold wrote:
dateformatter.fmwt

We can see DateTimeConverter and DateTmeStamper are missing in Data Interoperability.

Safe will reach out to you so we can jointly understand your environment, then Safe and Esri will offer some options.

In the meantime the attached template can be used to import the old style DateFormatter into Workbench.

Thanks Bruce.

 

 


Note that the DateTimeConverter (in 2017.1.1 at least) is not a complete functional replacement for DateFormatter.

The main difference (bug?) is that if there is no match on the input format, the Rejected output nulls the input attribute, making it impossible to chain these things (parsing several non-std formats) without manually copying of the original input attribute.

In DateFormatter this was the 'Set Invalid Date Attributes to: <No Action>'.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings