cancel
Showing results for 
Search instead for 
Did you mean: 

.csv to .csv with time stamp and need to delete the file in receiver SFTP

vishnu_pallamreddy
Contributor
0 Kudos

Hi All,

I have requirement where I need to pick the file and place it in SFTP.

The file format is .csv for both sender and receiver.

Clarify me on the below?

I need to do FCC (Transform bean for SFTP) in both the channels right?

and I need to delete the file in receiver SFTP folder before placing new file.

and I need to maintain time stamp for every file.

Please help me on this requirement...

Thanks & Regards,

Vishnu Pallamreddy.

Accepted Solutions (1)

Accepted Solutions (1)

former_member186851
Active Contributor
0 Kudos

Hello Vishnu,

If both are CSV ,you can just do a pick and drop scenario.

It would be better if you add a time stamp to differentiate the files.

vishnu_pallamreddy
Contributor
0 Kudos

Hi Raghu,

How to delete the receiver folder file when before placing new file?

apu_das2
Active Contributor
0 Kudos

Hi Vishnu,

Only option is to write a OS script and access it in CC or else create a separate channel and schedule it accordingly to delete the file.

By the way if your requirement is to place the file and delete then how your receiver system will utilize this.

If you want to do this just to create separate files entry then simply add time stamp in the file name.

Thanks,

Apu

maheswarareddykonda
Active Contributor
0 Kudos

Hi,

SFTP server team must be used that file which you are sending to that server. you better suggest them to delete their self once they used.

if that not correct better go for OS command

anyway you plaining to add time stamp , i don't think you will get issues while place new file

vishnu_pallamreddy
Contributor
0 Kudos

Hi All,

Thanks for replys,

From sender folder also I need to delete the file.

daily 10 file will create with different names and time stamps in same folder by running the report.

we have a job that will trigger daily and creates 10 files with different names at a time.

So now I need to pick the files and delete them in Sender filder.

by delete option we can delete those files.\But how can I pick all the files at a time with different names in same folder?\

All files are Micro Soft Excel Comma Seperated Values File type.

apu_das2
Active Contributor
0 Kudos

Hi,

Find out the common pattern from the file names then use regular expression for that like

If the file names are ABCDE.txt

                              GBCDF.txt then use source file name *BCD*.txt in Sender CC.

Else if you need to pick all file from this folder then use "*" in the source file name.

Thanks,
Apu

former_member186851
Active Contributor
0 Kudos

Hello Vishnu,

For deleting in the sender channel,use the mode "Delete" in the sender channel.

In the receiver you can try the options suggested by others like OS command

maheswarareddykonda
Active Contributor
0 Kudos

Hi,

From sender folder also I need to delete the file.

in processing tab you can maintain option as delete for the processing mode.



by delete option we can delete those files.\But how can I pick all the files at a time with different names in same folder?\

here explained with screenshots.


Answers (1)

Answers (1)

Harish
Active Contributor
0 Kudos

Hi Vishnu,

If you are passing the same file (without any changes) then you do not need transform bean.

For deletion of file, in ideal case file should be removed by the consumer system (the system which is consuming file from SFTP) on receiver side. The sender file you can remove the delete setting in processing tab.

regards,

Harish

vishnu_pallamreddy
Contributor
0 Kudos

Hi Harish,

so in PI there is no option to delete the receiver folder file right?

Harish
Active Contributor
0 Kudos

Hi Vishnu,

you can try using OS commands for deleting the file. you can refer the below threat

http://scn.sap.com/thread/3527105