Resources
 /
Support center
 /
Import my existing contacts

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.

Costs

Hourly rate
The development rate for 2023 is €200,- per hour.

Price estimation
It's not possible to determine a price, without reviewing the data first. To give a rough idea: many simple address imports take 2 to 4 hours. When there is more complex data, like show data or flights, the duration of the project is generally longer. Don't hestitate to send us your data to review.

Number of records
From a development point of view, the number of records in your file don't affect the time needed to write code that maps and transfers the data. It takes the same amount of time to import 100 or 50.000 records.

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!

Booking requests
add-a-booking-request-form-to-your-site
approve-booking-requests
booking-requests
change-artists-shown-in-a-booking-request-form
customize-booking-request-styling
Invoicing
bank-account-in-word-template
batch-modify-records
book-a-payment-on-an-invoice
change-the-currency-of-products
create-credit-note-for-the-full-amount
Availability check
how-to-hideunhide-artists-in-availability
how-to-use-the-availability-check
Bookkeeping
bookkeeping-code
bookkeeping-country
bookkeeping-currency
bookkeeping-update-january-2022
ledger-number
Email
date-and-time-formatting
define-your-spf-record
display-a-logo-in-an-email-signature
domain-authentication
edit-html-in-email-signature
Guest list
activating-a-guest-list
how-to-use-guest-lists
Logistics
itinerary-for-a-show
linked-travel-items-in-email-template
Exporting data
excel-templates
exporting-to-excel
product-type-84d1e
share-artist-schedule-with-another-system-one-client
Files
download-a-selection-of-files
how-much-storage-space-do-i-have-available-in-my-account
make-files-visible-to-external-users
what-are-system-wide-files
Personal settings
display-a-logo-in-an-email-signature
edit-html-in-email-signature
Setup
artist-profile
artists-visible-in-mobile-app
import-my-existing-contacts
promoter-profile
venue-profile
Products
change-the-currency-of-products
ledger-number
product-type-84d1e
unit-in-product
vat-rates
Shows
batch-modify-records
can-external-users-change-show-data
change-multiple-shows-at-once
change-the-currency-of-products
exchange-rates
Address book
batch-modify-records
brnnysund-register-integration
cant-find-address-on-map
company-email-migration
company-with-a-different-postal-address
Word templates
available-merge-fields
bank-account-in-word-template
date-and-time-formatting
esign-ready-template
how-to-create-or-modify-templates-in-word
Advancing
invitation-accepted-by-someone-else
managing-advancing-templates
send-an-advancing-request
what-are-personal-message-templates
what-is-advancing
User management
cant-change-username
create-an-account-for-a-developer
create-an-external-user-account
create-an-internal-user-account
deactivate-an-external-user
System settings
branding
configure-free-fields-shown-in-mobile-app
create-an-external-user-account
create-an-internal-user-account
managing-free-fields
iCalendar
changes-in-system-one-are-not-appearing-in-google-calendar
customize-icalendar-content-with-icalendar-templates
how-to-create-an-icalendar-feed-for-a-user
how-to-view-an-artists-events-on-external-calendars
icalendar-feed
Mobile app
accessing-files-offline-on-ios-devices
accessing-files-offline-on-android-devices
artists-visible-in-mobile-app
configure-free-fields-shown-in-mobile-app
is-there-a-mobile-app
Your website
add-a-booking-request-form-to-your-site
api--with-shows-in-json-format
create-an-account-for-a-developer
embed-shows-on-squarespace
embed-shows-on-wix
Integrations with other systems
add-a-booking-request-form-to-your-site
brnnysund-register-integration
connected-accounts
export-email-addresses-for-mass-mailings
google-places-integration
Contracts
batch-modify-records
change-the-currency-of-products
document-with-multiple-shows
how-to-delete-a-contract
Subscription
can-i-pay-my-subscription-by-invoice
change-my-billing-details
configure-payment-method
frequently-asked-questions-on-pricing
read-only-subscription
Google calendar
changes-in-system-one-are-not-appearing-in-google-calendar
subscribe-to-an-external-google-calendar
Free fields
configure-free-fields-shown-in-mobile-app
free-field-permission-profile
i-have-many-free-field-profiles-after-the-july-2021-update
Requirements
requirements-to-use-system-one
Flights
airports-database
Security
connected-accounts
help-with-sign-in
sharing-user-accounts
sign-in-with-facebook-removed
support--security
eSign
artist-rider-in-esign
can-i-have-my-own-signature-already-on-esign-documents-that-i-sent-out
change-something-specific-in-a-document
create-account-from-esign
do-i-need-another-esignature-service
Bank account
bank-account-in-word-template
setting-up-a-bank-account
Artist
artist-profile
artists-visible-in-mobile-app
change-artists-shown-in-a-booking-request-form
display--hide-artist-in-filters
how-to-hideunhide-artists-in-availability
Timetable
timetable-in-email-template
timetable-in-icalendar-template
timetable-in-word-template
what-is-a-timetable