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?
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.
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_*.csvBest Regards,
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.
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,