cancel
Showing results for 
Search instead for 
Did you mean: 

FTP - Picking file from different directories (Exclusion Mask)

Former Member
0 Kudos

Hi guys,

after checking the Library and this blog <a href="/people/mickael.huchet/blog/2006/09/18/xipi-how-to-exclude-files-in-a-sender-file-adapter:///people/mickael.huchet/blog/2006/09/18/xipi-how-to-exclude-files-in-a-sender-file-adapter

...i am confused because my FTP-Channel is not picking the file(s).

Well because Directory and Filename are mandatory i am confused in using the parameters given in the blog. But what should i use here?!

My aim is to read a file called WE_*.dat from directories like WDA, WDB, WDC which are lying under path /Input/whatever/

Put when i try to give the target directory its starts to be confusing to me. In Mandatory i give /Input/whatever/ and WE_dat and additionally under Exclusion mask i add WDA with file mask WE_.dat and so on

I already got the error 'com.sap.aii.adapter.file.ftp.FTPEx: 550 CWD failed'

therefore i changed the parameters of the FTP-folders but still i am not able to read these files from the different directories.

What thought is wrong in my doing?!

br Jens

Accepted Solutions (1)

Accepted Solutions (1)

former_member614185
Contributor
0 Kudos

Hi jens,

In the mandatory source Directory and file name, u just give some dummy name.

then select the advanced selection for source files.

Now give ur directory and its corresponding file name,

it will automatically pick your advanced mode selection criteria.

Former Member
0 Kudos

@Prabu: the dummy-solution i tried and the adapter adds the dummyvalues to the directory-parameter of the mandatory fields! No idea why....

error is like /input/whatever/dummy": directory not found

@Vishal: what do u mean by advance file source?! Is this with File?! i am using FTP-Protocoll

@Iñaki: do u have some example of using this?! If i understand this right you add a UDF in the mapping calling an FTP-Folder...?!

thx to all

former_member614185
Contributor
0 Kudos

jen you just try same as given in the blog. I m sure your scenario will work

Source directory: <Nothing>

File name: <Nothing>

  • Advanced selection for source file:

Directory File Nmae Mask

/Input/whatever/WDA WE_*.dat

like this you assign. hope /Input/whatever/WDA this is ur dir.

Former Member
0 Kudos

Hi, well no it's like i edited it before. I get the error:

<i>'com.sap.aii.adapter.file.ftp.FTPEx: 550 CWD failed. "/Input/whatever/WDA/<dummy>": directory not found</i>

as u described it is also mentioned in the blog and i have no idea what might be wrong to my solution....

Former Member
0 Kudos

Hi Jens,

Try with this:

Source Directory: /Input/whatever/WDA (any of those three directories)

File Name: <Nothing>

  • Advanced selection for source file:

Directory File Name

/Input/whatever/WDA WE_*.dat

/Input/whatever/WDB WE_*.dat

/Input/whatever/WDC WE_*.dat

Regards,

Sreenivas

former_member614185
Contributor
0 Kudos

>>>'com.sap.aii.adapter.file.ftp.FTPEx: 550 CWD failed. "/Input/whatever/WDA/<dummy>": directory not found

you should not give <dummy> in the directory path <b>"/Input/whatever/WDA/<dummy>":</b>.

And make sure that ur directory is accessible by ur XI server.

Former Member
0 Kudos

Hi Sreenivas,

this is the solution. Finally i made it like

Mandatory:

Directory: /Input/whatever/WDA

Filename:<dummy>

  • Advanced selection for source file:

Directory File Name

/Input/whatever/WDA WE_*.dat

/Input/whatever/WDB WE_*.dat

/Input/whatever/WDC WE_*.dat

Thx for all ur help!!!

br Jens

Answers (2)

Answers (2)

Former Member
0 Kudos

Jens,

try leavin the exclusion mask as it is..

under the advance file source, and additional files, give the source directory name and the file name..

this shud work..

regards,

Vishal

iaki_vila
Active Contributor
0 Kudos

Hi,

I dont' know why to use xi ftp adapter, i usually use ftp or sftp apis from java in the java mapping step, its more easy an quick.

Regards.