CSV Import

Introduction

Dotfile offers the possibility to import individual or company data via CSV.

How To Import

• For companies import: Companies > Click on the arrow on the right of the “Add new company” button > Import from CSV.
• For individuals import: Individual > Click on the arrow on the right of the “Add new individual” button > Import from CSV.

Here is a video example of how to import companies while applying a verification Template.

Formatting Rules

In order for your import to go smoothly, you may follow a few rules:

For individuals, you need to have at least the following columns for the import to be successful:

• first_name
• last_name
• is_beneficial_owner
• is_business_contact

The other columns you can add to your import are:

• email (required if is_business_contact is set to true)
• birthdate
• birth_country or residence_country.

Be aware that country names must follow ISO 3166-1 alpha-2 standard (e.g: FR, DE, NL) and that dates need to be formatted like yyyy-mm-dd.

Data from any other column you may want to add (e.g. customer_id ) will be imported as Case Custom Data

For companies, import trigger enrichment via official data sources. Using the registration_number and the country, Dotfile will create a case with all the available data on the company and create individuals such as Beneficial Owners if found.

Templates

When importing either individuals or companies, you can select to apply a verification Template to run checks in batch.