ACS: Transfer File (Download SFTP) computed file name | Community
Skip to main content
R
rick_romero
Level 2
January 29, 2018
Solved

ACS: Transfer File (Download SFTP) computed file name

  • January 29, 2018
  • 5 replies
  • 4075 views

Hello all,

I'm creating a workflow for a client where daily we will download a file from a SFTP server and update AC database.

The file is uploaded to the SFTP server by the client, and it is created automatically and has a dynamic name: file_date.cvs (ie: clients_20180129.csv).

Can I use computed name (dynamic name with date variables) on the file name?

Did anyone have this problem before?

Best

RIck Romero

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 rick_romero

Guys,

Just for the record, in case someone come to the same issue.

I tested with <%= formatDate(new Date(), "%4Y%2M%2D") %> and it didn't work. (on AC Standard)

So we can't use the same syntax that we use on AC Classic.

Regard the wild card (*), I also tried, but it only can be used on the last position, as the description says: "File path on the remote server (the * wildcard is accepted in last position)"

So it will only work in case you want to ignore the file extension.

Cheers,

-Rick Romero

5 replies

arouillard44
arouillard44
Level 4
January 29, 2018

Hello,

I don't know if ACS works like classic on this possibility, but you can try it :

Clientes_<%= formatDate(new Date(), "%4Y%2M%2D") %>.csv


It's an idea,

Regards,

R
rick_romeroAuthor
Level 2
January 29, 2018

arouillard44​

Thanks, I will test and I will let you know.

For now I asked the client to generate a static filename, but this probably will catch me back again.

Cheers

arouillard44
arouillard44
Level 4
January 30, 2018

Henrique,

i'm sure about one thing, if my solution doesn't works, you can use regEx.

it's not perfect, but permit you to use date with Clientes_*.csv

Best Regards,

R
rick_romeroAuthorAccepted solution
Level 2
January 30, 2018

Guys,

Just for the record, in case someone come to the same issue.

I tested with <%= formatDate(new Date(), "%4Y%2M%2D") %> and it didn't work. (on AC Standard)

So we can't use the same syntax that we use on AC Classic.

Regard the wild card (*), I also tried, but it only can be used on the last position, as the description says: "File path on the remote server (the * wildcard is accepted in last position)"

So it will only work in case you want to ignore the file extension.

Cheers,

-Rick Romero

W
wesleybrett1
Level 2
January 6, 2021

Here is the syntax for standard:

"Clientes_"+DateFormat(ToDate(GetDate()),"%4Y%2M%2D")+".csv"

 

 

    Terms & ConditionsAccessibility statement

    Loading footer...