ACS: Transfer File (Download SFTP) computed file name

henrique_romero

29-01-2018

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?

1405688_pastedImage_0.png

Did anyone have this problem before?

Best

RIck Romero

Accepted Solutions (1)

Accepted Solutions (1)

henrique_romero

30-01-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

Answers (3)

Answers (3)

arouillard44

30-01-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,

henrique_romero

29-01-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

29-01-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,