The Integration Central File Import includes support for the following:
- CSV (Comma delimited) (*.csv)
- CSV UTF-8 (Comma delimited) (*.csv)
- Max file size 15mb
- Quotes can encapsulate headings and/or the data for import
- Files can be imported live from local upload
- Files can be scheduled to import on a regular basis from SFTP
- Scheduled imports can be configured to use a wildcard for the date within the file name
- To do this in the template field change the dates to show DDMMYY in your preferred order
- Ensure to use single quotes around the date section
- If done correctly then the preview field will show the current date instead of letters
- The import will be based on how the name shows in the preview field so ensure all new files match the same requirements and maintain the same field layout for successful imports
- Import must be run on the date stated in the name of the file
Note:
- Images are not supported for import
- File styling is not supported for import