Within SFMC we have set up an listening trigger automation in automation studio which runs whenever a new file is put on the ftp site.
However often it fails on the import as the filename which contains Hours and Minutes might be slightly off.
For example the file is uploaded at 1/1/2016 at 10:53 pm but has the name myfile_010120161050.txt. As a result when the trigger runs it calls the import but the times do not match so it says 'Error – file does not exist'.
How can we get this to work without using a static file name?
Is there a wildcard we can use like so instead of:
myfile_%%day%%%%month%%%%year%%%%hour%%%%minute%%%%.txt
We can just use:
myfile_%%.txt
Thanks
Bryan
Best Answer
Yes you can do "Contains" "Begins with" or "Ends with" for the naming convention.
ref (https://help.exacttarget.com/en/documentation/automation_studio/triggered_automations/)
For the import activity, there are other personalization strings that can be used. https://help.exacttarget.com/en/documentation/automation_studio/triggered_automations/
Try using %%FILENAME_FROM_TRIGGER%% inside the import activity.