Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

ACS: Transfer File (Download SFTP) computed file name

Avatar

Avatar
Ignite 1
Level 2
henrique_romero
Level 2

Likes

6 likes

Total Posts

18 posts

Correct Reply

2 solutions
Top badges earned
Ignite 1
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Ignite 1
Level 2
henrique_romero
Level 2

Likes

6 likes

Total Posts

18 posts

Correct Reply

2 solutions
Top badges earned
Ignite 1
Validate 1
Boost 5
Boost 3
Boost 1
View profile
henrique_romero
Level 2

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)

Avatar

Avatar
Ignite 1
Level 2
henrique_romero
Level 2

Likes

6 likes

Total Posts

18 posts

Correct Reply

2 solutions
Top badges earned
Ignite 1
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Ignite 1
Level 2
henrique_romero
Level 2

Likes

6 likes

Total Posts

18 posts

Correct Reply

2 solutions
Top badges earned
Ignite 1
Validate 1
Boost 5
Boost 3
Boost 1
View profile
henrique_romero
Level 2

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)

Avatar

Avatar
Validate 1
Level 3
arouillard44
Level 3

Likes

18 likes

Total Posts

53 posts

Correct Reply

9 solutions
Top badges earned
Validate 1
Give Back 5
Give Back 3
Give Back
Boost 5
View profile

Avatar
Validate 1
Level 3
arouillard44
Level 3

Likes

18 likes

Total Posts

53 posts

Correct Reply

9 solutions
Top badges earned
Validate 1
Give Back 5
Give Back 3
Give Back
Boost 5
View profile
arouillard44
Level 3

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,

Avatar

Avatar
Ignite 1
Level 2
henrique_romero
Level 2

Likes

6 likes

Total Posts

18 posts

Correct Reply

2 solutions
Top badges earned
Ignite 1
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Ignite 1
Level 2
henrique_romero
Level 2

Likes

6 likes

Total Posts

18 posts

Correct Reply

2 solutions
Top badges earned
Ignite 1
Validate 1
Boost 5
Boost 3
Boost 1
View profile
henrique_romero
Level 2

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

Avatar

Avatar
Validate 1
Level 3
arouillard44
Level 3

Likes

18 likes

Total Posts

53 posts

Correct Reply

9 solutions
Top badges earned
Validate 1
Give Back 5
Give Back 3
Give Back
Boost 5
View profile

Avatar
Validate 1
Level 3
arouillard44
Level 3

Likes

18 likes

Total Posts

53 posts

Correct Reply

9 solutions
Top badges earned
Validate 1
Give Back 5
Give Back 3
Give Back
Boost 5
View profile
arouillard44
Level 3

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,