TfileList and tIterateToFlow components not picking any files up

[curtisdee13]

Hi All,

Currently having an issue grabbing files off an SFTP site. I've managed to setup the ftpComponent correctly and I can connect to the SFTP.

We're then using a tFileList which is then looking for a specfic file pattern from the uploads folder.

The file pattern we're looking for is "*_\\d{8}.csv" and this is an example set of filenames we're trying to pick up.

RHR_Payments_20220819.csv, RHR_Items_20220819.csv, RHR_Comps_20220819.csv, RHR_Checks_20220819.csv

Once the tFileList is complete, we're using a tIterateToFlow component, which I believe should order these files and process them individually.

The tIterateToFlow component has a mapping of column equal to FileName with a value equal to ((String)globalMap.get("tFTPFileList_1_CURRENT_FILE")).

Attached are the two components themselves, in case you wanted to look.

My main aim is to try and figure out why none of the filenames I've mentioned above are being passed through the tIterateToFlow component.

Hope this is enough information

Thanks

Curtis

[Anonymous · Accepted solution]

I think your regex is wrong. You showed this....

*_\\d{8}.csv

....I believe it needs to be this.....

.*_\\d{8}.csv

You appear to left out the "." at the beginning.