File adapter wild card not working

[Former Member]

Hi Gurus,

My file adapter seems to have issues with me

This adapter do not obey me when I specify wild cards. I have tried * , ? and also "Adavnced selection of source file" but no use. Although, he is a perfect gentleman when I specify complete file names.

Could you please suggest how to tame him?

Regards,

AV.

[Former Member · Accepted solution]

Hi,

this is what SAP Help says about it:

file.sourceFileName=<filename>

Specify the name of the file that you want to process.

The name can contain a placeholder (*) at any point, so as to be able to select a list of files for processing.

The following are valid examples for filename:

myFile.txt

my*.txt

*.txt

File.

File.*

myle.

Names that comprise more than two parts are also permitted.

Hope it helps.

Regards

Patrick

[Former Member · Accepted solution]

Thanks for your replies.

I have tried with

file*.txt

file*.xml

file?.txt

.

*

But no file is picked.

Regards,

AV.

[Former Member · Accepted solution]

Hi Anirudh,

We had the same issue. It is working fine using the filesystem, but fails using FTP. When we were using it in FTP, it worked exactly as you say: it picked up only exact file name. It didn't work with the wildcards.

We haven't found any solution for this

So we think about creating an Unix script for copying these files to local filesystem.

BUT, this maybe caused also by FTP server which you are trying to connect - maybe some new servers support wildcards (because some guys say it is working for their FTP), some don't.

I'd advise you to connect to this ftp server in a command prompt and try to use some commands using wildcards. Is it working? For us it wasn't. (try renaming files, deleting or so...) It was working only with exact file name.

Peter

[justin_santhanam · Accepted solution]

Peter,

As I said, even I tried it.It's working only with NFS and not with FTP.

raj.

[justin_santhanam · Accepted solution]

Peter & Anirudh,

If you go to this link -http://help.sap.com/saphelp_nw70/helpdata/en/e3/94007075cae04f930cc4c034e411e1/content.htm

you can see the wild character is available only for File Access Parameters and not FTP Parameters.

raj.

[Former Member · Accepted solution]

Hi Anirudh,

try with file* i think this should work.........

are you using NFS or FTP......

Regards,

Rajeev Gupta

[Former Member · Accepted solution]

Raj,

but you have File Access parameter part also for FTP in the CC parameters.

And as I said, a lot of people said, it is working for them (with FTP). So I think it depends on the FTP server, if it can process wildcards.

Peter

Edited by: Peter Jarunek on Mar 27, 2008 3:02 PM

[Former Member · Accepted solution]

Thanks Peter,

It was actually my FTP server.

It doesn't support wildcards.

Regards,

AV.

[justin_santhanam · Accepted solution]

Peter,

Possibly, I'm not sure though. It doesn't support in my FTP server too.

raj.

[justin_santhanam]

Anirudh,

Are u using FTP Protocol? I believe this wild card character is supported only in NFS. Could you please confirm it?

raj.

[Former Member]

Hi Raj,

Thanks a lot. I tried with NFS and it worked as expected.

Its a revelation.

Wild cards do not work with FTP!!

Regards,

AV

[justin_santhanam]

No Problem :-). Refer the link, I mentioned above.

raj.

[Former Member]

Hi Anirudh,

this is really strange...........

just give your input file name with * and save and activate your comm channel.........just check your source file name matches your pattern specified in comm channel using *................it should work................just check again carefully for capital letters and small letters in filename..........if it doesnot work, give details of your source file complete name and wild card pattern you are giving..........

Regards,

Rajeev Gupta

Edited by: RAJEEV GUPTA on Mar 27, 2008 2:23 PM