Support center

Import my existing contacts

Yes! If your data is structured, there is a good chance we can import your existing address book into System One.

Most of our clients gathered information in a database during the time before they switched to us. In the past years, we've imported enormous databases with multiple linked tables and simple excel sheets with a few columns.

It's the job of our IT team to analyse your data and write, test & execute code to map it into our structure.

We're happy to review your database and advise you on possibilities and costs.


How to deliver?

We have some tips on how you can deliver your contacts database.

Note: Make sure to show us your database before investing time in modifying your data. We might have suggestions to save you time.

What format should I use?
We can handle different formats, but an Excel sheet (.xlxs) works fine for us.

Can I deliver my data in multiple Excel tabs or in multiple files?
It's more cost efficient if you combine information into as few tabs/files possible.
For instance, if you have an Excel sheet that has two tabs with promoters and venues, try combining them, adding an extra column that describes the type of row: venue or promoter.

Can you give an example of what columns my file should have?
An Excel sheet can have the following columns:

  • CompanyType
    e.g. promoter/venue
  • CompanyName
  • CompanyAddressLine1
  • CompanyAddressLine2
  • CompanyPostalCode
  • CompanyCityName
  • CompanyStateName
  • CompanyCountryName
  • CompanyWebsite
  • CompanyVatNumber
  • CompanyGeneralPhone
  • ContactFirstName
  • ContactLastName
  • ContactGender
    e.g. male/female
  • ContactEmail
  • ContactMobile
  • ContactPosition
  • ContactBirthDate

Every import is a custom process. If you have data that doesn't fit this example, discuss with us!