How do I Use the UK Changes Data Cleanse system?

From Catalyst
Revision as of 08:40, 21 October 2013 by Chris Morrison (talk | contribs) (Importing the Cleansed Data)
Jump to: navigation, search

Summary

The following article explains how to export your customer data to UK Changes and how to import the returned cleansed data back into Platinum.

These reports and import templates are chargeable and if you wish to have these configured on your system then please Contact your Platinum dealer or our sales team on 0116 230 1500 or by using our website sales contact page for details.

More Information

  • To export the customer data from Platinum go to " UK Changes Data Cleanse UK Changes Data Export".

This will export your full customer database to a 'ExpCus.csv' file in '<Platinum Installation Drive>:\sx\SXIcons\Output\'.

This file can now be uploaded to your UK Changes account for cleansing.

Importing the Cleansed Data

Once you receive the data back from UK Changes you will need to extract the returned file to '<Platinum Installation Drive>:\sx\'.

If you have only had the standard data cleanse you will rename this file to 'standard_results.csv', if you have opted for the additional data cleanse you will need to rename this file to 'additional_results.csv'. If you do not rename the files appropriately the import will fail.

  • In Platinum go to " UK Changes Data Cleanse".
  • If you have had the standard data cleanse choose 'UK Changes Import Standard' if you have had the additional data cleanse choose 'UK Changes Import Additional'.
If you choose the incorrect import or you have renamed the file incorrectly the import will fail or import incorrect data, Catalyst can not be held responsible for any errors which arise from using the incorrect import template.


Feedback
Thank you for using our Knowledge Base, we value your feedback. Did you find this article useful? 'Yes' or 'No'
Keywords AND Misspellings
UK Changes, UKChanges, Data, cleanse, clean