...
- Click on the Admin button in the top right of CenterView PhixFlow and select System Configuration
- Go to the System Directories tab
...
- Open the model Dashboards and Forms 01-08: Views, filters and dashboards
- Go to the Stream Overall Debt Levels, and open the configuration form for the view Overall Debt Levels
- Go to the Advanced tab
- In field Excel Template specify debtOverview.xls
- Press
Press
- Open the template you just used:
- If you have sftp access, e.g. via FileZilla, you can retrieve the file from the cloud server from templates directory noted above
- If not, a copy of the template is available in the control framework:
- Press
- Show the control framework in the left-hand menu bar of CenterViewPhixFlow - Expand the folder CenterView PhixFlow Training
- Double click on the control Excel template to open it
- Go to the Files tab
- Double-click on the template file to open or download it
- Press
- Review the template – you will need to unhide the first sheet to see it
- You will see that the first worksheet (Basic Data) is blank - CenterView PhixFlow always writes exported data to the first worksheet; formatted cells are found on the worksheet Formatted Data.
- Open the view Overall Debt Levels, and export the data to Excel
- You will see the exported data from CenterView PhixFlow in the first worksheet – and formatted output on the second worksheet
...