Exporting Holding Fund Records

You are able to export holding fund data from within the Admin> Reports area.

Click into I> View table of holding fund records:

Select 'Create a Spreadsheet'

Click 'Yes' to create the spreadsheet:

Set the file name, the 'Save as type' as Excel Workbooks (*.xlsx) and tick the 'Automatically open file' box if you would like to view the data straight after the export.

Click 'Save'

Click 'Continue' to the next message:

You can now specify the fields you would like to export.

To move all fields from the previous table view, click 'Move All'

The 'Field export order' box on the right-hand side, will now have a list of all the fields within the data table. You are able to 'Export' the fields out now, or if you have any further fields you would like to add, you will need to move to the next step.

To add further fields from the fund (Invest) database, select 'Current Table ("Invest")' from the dropdown:

You will need to know which fields and the name of the field you would like to move over to the field export order box.

If you are unsure of the names of the fields you would like to export, contact our Support Team on 0800 028 0033 or email support@synaptic.co.uk for guidance. 

Note: Not all fields are the same name as within the system.

Select the field name and click '>>Move>>' to add it to the 'Field export order' box:

Once you have add all the additional fields, select 'Export'

Click 'OK' to the following message:

You data has now been exported: