on 08-09-2016 7:32 AM
Dear Friends,
I have a File to File scenario where receiver file should place with date not time stamp.
Sender is NFS and Receiver is SFTP advantco adapter. File is placing in ftp location with date time stamp.
Ex. abc_xyz_20160808_103022_234.txt.
I need only abc_xyz_20160808 format.
Please suggest solutions to achieve this.
Thanks a lot.
Sree
I know it's a long shot but can you try using parameter %DATE in your file name.
In the above document, it is used for generating file name while Archiving, but may be it works in file name also. Just give it a try.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Everyone,
I disagree with the custom module option. May be Apu has right that for only one scenario can be much work, but i think it is important to notice the benefits to have Eng's module, this module is very powerful and will let you to change attributes in the future without using ESR. I mean, you have not to develop the module, you only need to install and you will have this module in the future for other scenario. Think about the time to do the UDF or java mapping, may be the same or more than install a new module, and you will improve your PI skills knowing another thing how to install modules.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi sai,
You are using SFTP adapter in receiver end so OS command will not work for you.
I will not suggest you to brainstorm on custom module just to reduce time stamp from file name. Rather introduce mapping and write an UDF to access Dynamic configuration and modify file name there else if you dont want to use MM then simply write an Java mapping and set there your required file name.
Thanks,
Apu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sai,
Another alternative is to install Eng Swee Yeoh module bean to change the name of the file dynamically. Check scenario 3 in his blog.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Sai,
Is it a by pass scenario or you have mapping?
If its by pass try using OS Command.
Bypass scenario with a specific file naming schema | SCN
If mapping program exists try with UDF
Dynamic file name for pass-through scenario - Process Integration - SCN Wiki
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.