Adobe Classic SFTP Activity | Community
Skip to main content
adithyacs86
adithyacs86
Level 5
January 21, 2020
Solved

Adobe Classic SFTP Activity

  • January 21, 2020
  • 1 reply
  • 4374 views

Hi Team, 

 

When i transfer (either download or upload) the files from 3rd party server to Adobe app server folders, we see that files gets appended with the timestamp at the end of the file. 

ex :- Starting transfer of 'sftp://sftp.test.com:portnumber//ftp/foldername/filename.csv' to 'filename_202001...a.csv'

But i dont want the file name to be changed or altered by including the timestamps to it. 

 

Please let me know if there is a way to restrict the suffix of timestamp to the file names. 

 

Thanks,
Adithya

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Florian_Courgey

Hi,

 

The only fix we found was to add a Javascript activity after the SFTP activity, with the below code:

 

var f = new File(vars.filename); // vars.filename will be automatically set by the previous SFTP activity logInfo('Old path:', f.fullName); // log full path var newPath = f.path + f.name.replace(/_\d{14}[a-z]+(\.\w+)$/, '$1'); // generate new path by replacing "{an underscore}{14 digits}{a few lowercase letters}" by nothing logInfo('New path:', newPath); f.renameTo(newPath); // move file to the new path vars.filename = newPath; // set ACC standard filename convention to the new name

 

This is not elegant but it works well. You may encapsulate it into a function in a Javascript code and call it from within your workflow.

 

The "File" doc can be found at https://final-docs.campaign.adobe.com/doc/AC/en/jsapi/c-File.html

1 reply

Florian_Courgey
Florian_CourgeyAccepted solution
Level 4
January 21, 2020

Hi,

 

The only fix we found was to add a Javascript activity after the SFTP activity, with the below code:

 

var f = new File(vars.filename); // vars.filename will be automatically set by the previous SFTP activity logInfo('Old path:', f.fullName); // log full path var newPath = f.path + f.name.replace(/_\d{14}[a-z]+(\.\w+)$/, '$1'); // generate new path by replacing "{an underscore}{14 digits}{a few lowercase letters}" by nothing logInfo('New path:', newPath); f.renameTo(newPath); // move file to the new path vars.filename = newPath; // set ACC standard filename convention to the new name

 

This is not elegant but it works well. You may encapsulate it into a function in a Javascript code and call it from within your workflow.

 

The "File" doc can be found at https://final-docs.campaign.adobe.com/doc/AC/en/jsapi/c-File.html

    Terms & ConditionsAccessibility statement

    Loading footer...