on 12-09-2015 10:15 AM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vishnu,
you can try using OS commands for deleting the file. you can refer the below threat
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.