ACS: Transfer File (Download SFTP) computed file name | Adobe Higher Education
Skip to main content
R
rick_romero
Level 2
January 29, 2018
해결됨

ACS: Transfer File (Download SFTP) computed file name

  • January 29, 2018
  • 5 답변들
  • 4075 조회

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

이 주제는 답변이 닫혔습니다.
최고의 답변: 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 답변

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_romero작성자
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_romero작성자답변
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"

 

 

    약관 및 조건Accessibility statement

    Loading footer...