Solved

How to add last modified date/time of Excel File and new Column in FME?

  • 29 October 2018
  • 4 replies
  • 25 views

Badge

Hi all,

I am wondering how is the best way to create a new column in fme with say last modified date and then extract the last time excel file was saved into the column for each record?

Thanks

icon

Best answer by david_r 29 October 2018, 17:26

View original

4 replies

Badge +3

Maybe use a system caller?

https://www.windows-commandline.com/get-file-modified-date-time/

is of any help?

Badge

I have this information but can't see anything in FME to get the last date modifield.

Userlevel 4

You can use Directory and File Pathnames reader, just remember to turn on the option to retrieve file properties.

Each feature will then have an attribute path_modified_date which probably contains what you're looking for.

Badge

You can use Directory and File Pathnames reader, just remember to turn on the option to retrieve file properties.

Each feature will then have an attribute path_modified_date which probably contains what you're looking for.

That is super, thank you

 

Reply