When adding a new Automated Import Template, you will need to fill in several pieces of information. You will need to give your template a name, choose whether you want to deploy a campaign after the import is completed (e.g. automatically) and finally the techie bit; you need to enter your “Filename Match Expression”.
The match expression is how Campaign Builder will recognise your import file and distinguish it from any other files on your FTP site.
- Campaign Builder will only import a file name once, you must use a unique file name each time you wish to import.
- To ensure the filename is unique, add the possibility for digits at the end of the filename e.g. [0-9]*
- You must include the extension of the file (e.g. .csv)
- It is good practice to avoid having spaces in your filename
This expression means that Campaign Builder will pick up any filename that starts NewRegistrations and has some digits after it (0-9) (e.g. NewMembersSMS20120912). This means that a NewRegistrations file could be uploaded every day and Campaign Builder would be able to pick them up individually.
N.B. You could also use NewRegistrations[a-z]*.csv, which would allow the campaign name to be followed by more than 1 lower case letter.
You can test your file name by entering an example file name and test it. Simply enter your example file name, including the extension (e.g. .csv) and click “Validate”.
The filename match expression can be any regular expression.