To add an File deployment that supports an excel file (.xlsx):
- In the sidebar select Configuration.
- Select the Deployments tab.
- Select Add....
- In the General step of the Deployment wizard:
- Select File from the Select Application Provider list.
- Enter the Deployment Name, File Deployment-File Path-xlsx.
- Enter the Description: File deployment for xlsx file formats.
- In the Deployment step:
- Select CSV/XLS/XLSX from the File Format list.
- Select File Path (on-premises only) or File Upload from the File Data Source Type list.
If you chose File Path, enter c:\xlsx in the Shared Folder on Gateway Server field.
- Set Enable Cross Reference Tracking to True only if you want to ensure Gateway stores and tracks the cross-references for the data being synchronized. This helps the destination application determine if it is a create or update action.
If the field is unchecked, cross-references will not be stored, and it will be up to the destination application to determine whether to create or update data in the destination application.
- Select Save.
Note: Repeat the above sequence for a .xls format also.