Dynamic input file name with the sysdate

Follow

AASIF NIYAZ kHAJA MOHIDEEN

• March 03, 2021 01:25

Infogix Community ,

We are getting a file from an external system every day. The file name will be in the format of abc_yymmdd.txt. That means the file name is changing every day. How do I configure the file layout the read the file dynamically? 

0

• 

  Gerard Cafaro

  • March 04, 2021 20:17

  This can be accomplished via the File Monitor feature. At a high-level, this is a control that would run frequently, typically every few minutes, and its input is a directory on your filesystem. Instead of capturing file data, it captures information around the files themselves based on inclusion/exclusion rules within the control. Generally the filenames are extracted and are sent to a second control to process the content of the file found. This allows for files with dynamic names to get captured without updating logic. 

  Within the Assure's in-product help (Help > Launch Full Help), there's more detailed instructions on using this feature under the "File Monitor Controls" and "Input Files Express" pages.

  0

  Comment actions Permalink

Please sign in to leave a comment.