Tools menu in the user panel gives us the option to do bulk data upload in CSV files (Assessments, Organisations, Contacts).
To bulk upload the data you need to download the template provided for the relevant section and fill it in.
When you have the files that are ready to upload, click on the ‘Validate CSV file(s)’ button to validate the files and checking for errors before it will be uploaded into the system. The system won’t let you upload if there is any errors in the file.
If you would like to upload Organisations, Contacts and Assessments at the same time, make sure that you are uploading all of the CSV files at the same time and then click on ‘Validate CSV file(S)’. If you will try to upload those separately you may come across errors as the data won’t match.
Data upload tool allows you to add Organisations/Contacts/Assessments in bulk but can be also used as a tool to update information on the system in bulk (e.g. changing email addresses, name of person responsible within the organisation etc.). To find out more about updating information in bulk click here.
An example of Contacts bulk upload filled-in CSV file:
An example of Contacts bulk upload filled-in CSV file:
An example of Contacts bulk upload filled-in CSV file:
For all entities there are two possible actions, "C" which signifies that the entity is to be created new, and "U" which signifies that the existing entity is to be updated. To either create or update an entity please put the corresponding letter in the action column of the CSV file.
action - C (Create)
organisationName - Organisation name
primaryContact - Primary Contact (within the Organisation)
personResponsible - person responsible (within your Organisation)
active - TRUE/FALSE (TRUE if Company is active/ FALSE if the company is deactivated - it will show in the Organisations tab only if you tick ‘Show deactivated’)
impact - can be number 0-5, fill in only if known; otherwise leave empty
notes - internal notes/optional
Here is an example of a filled-in CSV file as an example: