Use the same synchronization to download and save data to any file format supported in Gateway as follows.
Prerequisites
- Gateway is installed with File and P6 providers.
- File Provider deployment, File Deployment-File Upload-xls, has been set up to use File Upload method.
- File Provider must be the destination application in the business flow and synchronization.
- A field mapping template for the Role object, Field Mapping Template for Role, has been added.
- A master data business flow for the Role object, Send P6 Roles to File in xls Format has been added.
- A synchronization, Send P6 Roles to File in xls Format, has been created.
- The File Name parameter in the synchronization is set to File Output.xls to save the sent data.
Procedure
- In the sidebar, select Monitoring.
- In the Job column, select the job number of P6 - File Project Data synchronization.
- Select the Data Details tab.
- Select File Output....
- Select Open or Save to download the <synchronization name>.zip to a local folder.
- Extract the contents of the zip file.
- Data is saved in File Output.xls that was entered when the synchronization was edited prior to the run.
Tip:
Edit the Send P6 Roles to File in xls Format again and change the File Name value as FileOutput.csv. Run and monitor the synchronization again to save the data in .csv format.