Hi, I have an export process (non FME) from system that writes a file to a folder every day and gives that file a name depending on the date. eg 2465_20210514_01.csv. I would like to set a scheduled job in FME to read the new file in every day and process an output from it. Can I set up a reader in FME to pick a file based on a name that changes but with the same format (with the only change being date). Many thanks.
Question
Can I use a reader to find a file name that changes depending on the date?
+54
Multiple ways to do this.
- Create the filepath dynamically, feed this to the FeatureReader.
- Pretty straightforward.
- Attached a sample workspace.
- Scan all files in the directory, parse the date from the filename and filter current date.
- You might need to do this if the input is more flexible, like if the prefix and suffix are not fixed. Or multiple files each day.
- This can be a lot slower if the directory contains a lot of files.
- I prefer this one to because I prefer to be (feel like I am) in control.
+4- Contributor
Thank you very much for the quick reply. So of the second option "scan all files in the directory...." - is this something that can be done in FME? Thank you.
+54ruth_h wrote:
Thank you very much for the quick reply. So of the second option "scan all files in the directory...." - is this something that can be done in FME? Thank you.
Yes, this can be done with the "Directory and File Pathnames" reader.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.