Skip to Content
0
Former Member
Dec 21, 2007 at 03:43 AM

Vaildating File name with the data in the file using sender file adapter

13 Views

Hi,

Below is the scenario

1) Pick up files from a FTP server, the file name is dynamic, how do I put dynamic name in sender file adapter?

2) Determine if the user correctly named the file based on data in the file.

a. File naming structure that we will be concerned with is <company_code><accounting_time_period>.<extension>

b. The company code and the time period in the file name have to match the data in the file.

i. For example. If the file name is 1001_200712.csv and the data in the file is for company code 1005, time period 200712, the file is incorrectly named. Both values must be correct.

How do we do this?