FTP File Adapter

[former_member200339]

Dear Experts,

We had FTP adapter and is now replaces with SFTP adapter. One of drawback with SFTP adapter is that it does not provide exclusion mask as file adapter.

I have the following requirement. I have 3 flows picking data from same folder. FTP Adapter configuration and file names are as below.

Flow	Directory	File Name Scheme	Exclusion Mask
Flow1	Directory_XYZ	*pain.002*	cres*lsv_VPLSV*
Flow2	Directory_XYZ	creschzf_pain.002.001.02.lsv_VPLSV*	Not set
Flow3	Directory_XYZ	*	*pain.002*

Flow-1
deutdeff_pain.002.001.02_dbdi_pain.002_report_20150313095000306_245709532672.SNL18172D11426240232576040S
citichzz_pain.002.001.02.fak_pmifch2l_PMI_ACK_CITI_20150313062151.SNL18240D11426242349432095S
citichzz_pain.002.001.02.res_pmifch2l_PMI_RES_CITI_20150313060436.SNL18240D11426241082255723S
citichzz_pain.002.001.02.res_pmifch2l_PMI_RES_CITI_20150316062749.SNL18240D11426502215340896S
dabadkkk_pain.002.001.02_STATUS-150316U011.SNL52940D11426486137848659S

Flow-2
creschzf_pain.002.001.02.lsv_VPLSV_4691674_20150313_132259.xml.SNL51740D11426252586988341S
creschzf_pain.002.001.02.lsv_VPLSV_4691674_20150316_102200.xml.SNL51740D11426500998054918S

Flow-3
sogefrpp_camt.fin.mt940_REF940.SNL10823D11426281092457641S
bbvaesmm_camt.fin.mt940_PMIFCH2LXXX_MT940_20150314090000745_281.SNL10845D11426320325659296S
deutdeff_camt.fin.mt9xx_MT942_PMPD942_13032015161518657.txt.SNL18172D11426263325490374S
deutdeff_camt.fin.mt9xx_MT940_ResearchLab_12032015070534493.txt.SNL18172D11426143955970029S

So far I found regular expression as below.
Flow1    -              .*pain\.002\.001\.02(?!\.lsv_VPLSV)
Flow2    -              creschzf_pain\.002\.001\.02\.lsv_VPLSV.*

But I did not find regular expression for flow3.

Thanks and Regars,

Rana Brata De

[iaki_vila]

Hi Rana,

Why don't ask your sender to set a name file with a structure that you can do an easy mask or to store them in alternative sub-folder?, for example to start the files with fl3_.

Regards.

[gagandeep_batra]

Hi Rana,

Why dont you put Condition on receiver  determination.

Regards

GB

[former_member200339]

There is only one receiver for all files so putting condition in receiver determination will not solve the issue. Also, we had FTP setup and we just would like to replace File Adapter with SFTP adapter as mapping and conditions in ID are already complex.