Skip to main content
Solved

Date/Time Function Evaluation in FME Server

  • September 22, 2020
  • 2 replies
  • 14 views

pmcpherson
Contributor
Forum|alt.badge.img+9

Maybe this is known behavior, but I noticed that when using the following dataset name in an Excel Feature writer in FME Server, that the expression was not evaluated correctly when using the Data Download or Data Streaming services.

 

"testfilename_@DateTimeFormat(@DateTimeNow(),%Y%m%d).xlsx"

 

Interestingly, it works fine in Desktop, and when using the Job Submitter service in Server.

 

Has anyone else encountered this type of issue?

Best answer by hollyatsafe

Hi @pmcpherson​ ,

 

This is a known issue (FMESERVER-10821), we do not currently have plans to address this, however I have assigned this question to the issue so that you are updated if any changes are made in future.

 

As a workaround, please create the Excel filename as an attribute in an AttributeCreator/Manager first e.g.

 

New Attribute = filename

Attribute Value = testfilename_@DateTimeFormat(@DateTimeNow(),%Y%m%d).xlsx

 

Then specify this new attribute in the Feature Writer Dataset parameter.

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

2 replies

Forum|alt.badge.img+2
  • Best Answer
  • September 28, 2020

Hi @pmcpherson​ ,

 

This is a known issue (FMESERVER-10821), we do not currently have plans to address this, however I have assigned this question to the issue so that you are updated if any changes are made in future.

 

As a workaround, please create the Excel filename as an attribute in an AttributeCreator/Manager first e.g.

 

New Attribute = filename

Attribute Value = testfilename_@DateTimeFormat(@DateTimeNow(),%Y%m%d).xlsx

 

Then specify this new attribute in the Feature Writer Dataset parameter.


pmcpherson
Contributor
Forum|alt.badge.img+9
  • Author
  • Contributor
  • September 28, 2020

I will give that workaround a try. Thanks Holly!


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