People who have access to edit client information can also import clients from Excel & CSV files. This can be done by clicking 'Add Client' from the bottom of the client list, and then clicking 'Import from file' at the top right of the screen.

The first row in the file should contain the column names, as detailed below.

Following this should be a list of people to be imported, with one line per person.

The following fields are imported into the system;

Client
Reference No
Address
Address line 2
City
State
Postcode
Phone
Fax

A client's ID number can also be used to update existing clients, along with a clients name - the following fields can be used;

ID (this referrs to the internal ID number within the VTEvents system)
Client

Client Contacts

Client contacts can also be imported at the same time as clients, generally by specifying them as additional fields in the Excel / CSV document.

The following fields should be used;

Contact - name
- This represents the contact's full name
First name
- Optional - this can be used in place of a contact's full name, along with the last name below
Last name
- Optional - this can be used in place of a contact's full name, along with the first name above
Email
Phone
Mobile Phone

Browser not supported