Do you require assistance? Please select from one of the following options:
 
Self Help


Email Support
Please complete the form below and we will get back to you as quickly as possible.
 
Telephonic Support
 Please call us on +27 21 657 5960. 

 

Home / Mi-Gateway / How to create a report of your Clients and Mandates in Mi-Gateway.

How to create a report of your Clients and Mandates in Mi-Gateway.

You can use the Clients and Mandates Download buttons to download CSV reports.

CSV files are files with comma separated values that can be opened in Microsoft Excel.

  1. Depending on what you would like to do, you can either download a list of Clients or Mandates. Screenshot - 2017-07-24 11.51.39.png
  2. Once downloaded the files are saved with a file name as follows: Mi-Gateway Client Report (Date Time).csv. The file will be downloaded into the browser’s Download folder.
  3. Once downloaded the file can be opened using Microsoft Excel. SpreadSheetComplete.png

If  you find that the that the data is not split on the comma then you can either do a quick or permanent fix.

SpreadSheet.png

The Quick Fix is as follows:

  1. Click on the Data tab.
    Screenshot - 2017-07-24 14.48.07.png
  2. Select “Text to Columns” and follow the wizard. Make sure “Delimited” is selected and click next.Screenshot - 2017-07-24 14.53.11.png
  3. Tick the Comma box. Then click finish.
    Screenshot - 2017-07-24 14.55.39.png

The Permanent Fix is as follows:

  1. Go to Control Panel.Screenshot - 2017-07-24 10.43.31.png
  2. Then go to Clock, Language and Region.Screenshot - 2017-07-24 10.46.57
  3. Select Regions.Screenshot - 2017-07-24 11.06.46.png
  4. Select Additional Settings which will present you with another pop-up window.Screenshot - 2017-07-24 11.09.49.png
  5. Change the List separator to a comma ( , ) and not a semi-colon ( ; ). Then click Apply and then OK. Screenshot - 2017-07-24 11.14.55.png
  6. Exit all windows and when you now open the CSV excel spreadsheet the table will be well formatted into columns. SpreadSheetComplete