When creating an excel file for Protect you need to follow the specific format of uploading individuals.
Businesses and individuals need to be uploaded into Protect separately. The individual template is attached and the business one can be found here.
The following column headers are needed in the individual upload with two required fields. Below is a list of the column headers needed with an explanation of the data needed within the field. We need a full name in the individual file for the upload to run, you can either use Full name or first name and last name.
First Name* - First Name, this field is required.
Middle Name - Middle Name
Last Name* - Last Name, this field is required.
Full Name* - First Name and last name, this field is required.
Generation - Senior/Junior
DOB - Dob must be formatted YYYY-MM-DD
Address - 1st Line of address
City - City
Postcode - Postcode
Country - Country needs to be a country code, we have a list of the country codes attached below.
Nationality - Offical nationality of a client.
National ID - Clients ID, Most regulators do not hold this information so it may not reduce the results.
Profile Name* - Profile Name is a required field within the upload. There is no limit to profiles.
Saving the file in the correct format
The upload files need to be uploaded into Protect in (.CSV) and must be provided in UTF-8 Encoding, you can complete both of these by following the below steps.
Click 'Save as' on Excel
Select 'Save as type' as .CSV
Select 'Tools' next to 'Save' and then select 'Web options'
Choose encoding across the top of the pop-up.
Select Unicode (UTF-8) within the dropdown labelled 'Save this document as' and click ok.
You can now save your file and upload the file into the Protect product.
Your file will now start screening within the background, once the file has been completed it will show one of three statuses.
Completed - Your file has successfully uploaded and the relevant profiles have been created.
Partially completed - Your file has uploaded all the correct records but there is an issue with records in the file. You can download the error file which enables you to rectify the problems and upload a new file with the corrected records.
Failed - There is an issue with records in your file. You can download the error file which enables you to rectify the problems and upload a new file with the corrected records.