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
Solved
How to add last modified date/time of Excel File and new Column in FME?
Best answer by david_r
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.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+15- Contributor
- 2252 replies
Maybe use a system caller?
https://www.windows-commandline.com/get-file-modified-date-time/
is of any help?
- 8394 replies
- Best Answer
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.
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.