File Sender Filename scheme problem

[shweta_walaskar2]

Hello,

we need to pick two types of files from the same folder on FTP server:

Examples of filenames are:

FILEINVRPT12_28102010.xml and FILESLSRPT12_28102010.xml

We tried to use Advanced selection of files for these two file types and the filename scheme used was

FILEINVRPT.xml in filename and FILESLSRPT.xml in Filename mask for Advanced selection

All files of type FILEINVRPT.xml have been picked up but FILESLSRPT.xml were not.

We tried to remove advanced selection and even used *.xml and . as filename scheme ,still these files aren't picked up.

Then we tried giving exact filename (hardcoded) for some of these files and they were picked up ,so there should be no problem with these files.

Can anyone please suggest what could be the reason for this strange behaviour?

Thanks a lot.

Best Regards,

Shweta

[shweta_walaskar2]

Not sure of what could be the exact reason,but we deleted some old files on FTP server and it started working

[Former Member]

Hi,

In the 'Advanced Selection' option, instead of FILESLSRPT.xml give FILESLSRPT and try.

-Supriya.

[shweta_walaskar2]

Hi Supriya,

Tried .doesn't work

Thanks.

Regards,

Shweta

[RKothari]

Hello,

What is the processing sequence you are using: By Name or By Date??

Please check the sequence should be By Name if you don't want to make it Timestamp dependent.

-Rahul

[shweta_walaskar2]

Hello Rahul,

Where can I see Processing sequence (By Name or By Date) in File sender adapter channel?

Thanks.

Regards,

Shweta

[Former Member]

Hi Shweta,

You can see the processing sequence on the 'Processing' tab in the sender channel.

But I wonder how would it help to resolve your issue.

-Supriya.

[former_member207622]

Hi shweta

In FTP and file content conversion we dont see processing sequence , In NFS we can see

Regards

Ninad

[shweta_walaskar2]

Hi,

Yes,I am using FTP and this option is not available.

Thanks.

Regards,

Shweta

[Former Member]

Hi Shwetha,

As per my understanding, you need to pick two different files(not having same naming convension) from the same folder. I see that you are using Advanced selection for Source files.

This can be easily achieved, I have done it and providing you the steps to configure the adapter.

1. In the File Access parameters, provide the source directory and filename as FILE*.xml.

2. Now, check the option, advanced selection for source files.

provide the directory = 10.20.30.40

and the File Name Mask FILEINVRPT.xml, FILESLSRPT.xml

Ensure that the file placed in the FTP should have the same naming convension of the filename.

Thanks,

[Former Member]

Hi Shweta

Could you try below option,

1.configure the channel with NFS option.

2. use any PI serve directory & place 4 or 5 files with different names in directiory

3. mention the file name as * in the file communication channel

check if it is working?

if it works so it can be the authorization problem of file or FTP user.

Thanks

Rinku

[shweta_walaskar2]

Hello,

For test,I am not using Advanced selection now.

I used FILESLSRPT12_281020??.xml and some files matching this scheme have been picked up

Does this give any hint?

Regards,

Shweta

[former_member207622]

Hi Shweta

Can you please clarify , I am not getting what you done and what is the result

Thanks

Ninad

[shweta_walaskar2]

Hi Ninad,

Instead of using asterisk(*) as wild card character ,I used ?? as replacement for last two characters of filename and such files having filename same as this (except last two characters) were picked up

Regards,

Shweta

[former_member207622]

Great ! Now if you can try using advanced selection and doing as per Rahul suggested by giving directory and file name with wild card char , see if it works

By the way , how is that possible , what version youa are using.

Regards

Ninad

[shweta_walaskar2]

Hi Ninad,

Its not so good,because I dont want to make it timestamp dependent

hence I tried to use FILESLSRPT12_????????.xml

Its not working again :(((

Its XI3.0 SP17

Regards

Shweta

[Former Member]

Hi Shweta,

Have you checked the filename scheme properly, as it is case-sensitive.

-Supriya.

[shweta_walaskar2]

Hello Supriya,

Thanks for your reply.

But as I mentioned,even star().star() is not working. (Sorry I have to write 'star' as it goes off after posting)

Regards,

Shweta

[former_member207622]

Hi Shweta

Please check this thread , you need to enter first type of file in filename and second type of file in additional files

leave exclusion mask empty .

hope this helps

regards

Ninad

[shweta_walaskar2]

Hello Ninad,

Thanks for your reply.

I had tried the same but it didn't work.

Now I am trying to do a very simple test removing advanced selection and giving *.xml, Still these files are not picked up.

Any idea?

Regards,

Shweta

[former_member207622]

Hi Shweta ,

Can you please check if you have read ,write ,modify permissions present for file and directory .

Can you run the same channel with another file and see whether its being picked up from local directory /

please make ftp connection mode as permanent ,and see if you find any logs in channel monitoring

regards

Ninad

Edited by: Ninad Sane on Oct 28, 2010 12:15 PM

[Former Member]

Hi,

Then there is a possibility that cache is not getting refreshed after you making the changes in channel.

-Supriya.

[shweta_walaskar2]

Hi Supriya,

If I change the channel to have hardcoded file name ,then it works.

Which implies that changes are reflected in the channel.

Is there any other possibility?

Thanks.

Regards,

Shweta

[RKothari]

Hello,

Please provide Directoy path (If not mentioned) under the Directory name along with File Name Mask in the advance selection of source file.

Don't enter anything in Exclusion mask.

Regards,

Rahul

[shweta_walaskar2]

Hello Ninad,

I can process same file by hardcoding filename,so it cannot be file permission issue.

Changing mode to Permanently didn't help.

One point I would like to mention,there are hundreds of such type of files which are waiting to be picked.

Can this have some impact?

Thanks.

Regards,

Shweta

[shweta_walaskar2]

Hi Rahul,

Thanks for your reply.

I am doing the same.

Regards,

Shweta