Close button
Warning icon
Third-party cookies required
Your browser's security settings do not allow third-party cookies. Please adjust your browser's security settings or try a different browser to view this content.
By clicking “Allow,” you agree to the storage of cookies on your device to improve page navigation, analyse site usage, and support our marketing efforts. For more information, see our cookie policy.
Reject
Allow
Cookie menu button
Back icon

Articles by topic

Online Events & Live Streaming

Table of contents

Last updated:
March 4, 2025

Contacts

Contact management plays a crucial role in event organisation. In this article we will explain the main features of contact management in Oniva, from creating individual contacts to organising contact groups.

Screenshot of contacts in Oniva

What is guest management?

Guest management is the process of managing information about people who attend or are expected to attend an event. This includes collecting, editing, and managing contact information, as well as organising contacts into groups for targeted communication. Contacts can be created manually, imported from Excel, or imported from a user profile. Each contact is assigned a personal event link that guests can use to access the event.

Oniva treats contacts and bookings as two separate entities that are closely related. Contacts include all information about people who are either attending the event or are potential attendees, regardless of their current booking status. Bookings, on the other hand, are the actual registrations made by attendees for the event. While contacts provide a comprehensive list of all potential attendees, bookings provide a more detailed view of actual attendance at an event. In some configurations, it's also possible for a contact to have multiple bookings.

Importing contacts

In Oniva, you can add contacts in two ways: via an Excel import or by transferring existing accounts. If accounts already exist for your target group (e.g., employees), you can import them directly. Stored data such as language, gender, or username will be automatically transferred. This increases security, as only registered users gain access. This feature is only available with a premium licence (see article on authorisation groups).

If you want to add new people to your contact list, you can upload their data via an Excel import. The order or naming of columns does not matter, as you can assign them to the correct Oniva data fields during the import process.

Important formatting requirements:

  • Language: Only "DE", "EN", "FR", and "IT" are allowed.
  • Gender: Only "F" (female) and "M" (male) are valid.
  • Deviating values (e.g., "Female" or "German") will be skipped.

How to import contacts

  1. Open the event.
  2. Navigate to the "Contacts" menu.
  3. Select "Import contacts".
  4. Choose a file and start the import.
Screenshot of navigating to import contacts

If multiple authorisation groups exist, the appropriate group must be selected during the import. When importing from existing accounts, you select an account group that is managed in the workspace or account settings (admin rights required).

Requirements for the Excel file

  • Each contact must have a unique identifier; otherwise, the row will be skipped.
  • If an identifier appears multiple times, only the first contact will be created.
  • The file may contain only one worksheet.
  • Only one header row is allowed; contacts will be imported from row 2 onwards.
  • Empty rows will be skipped.
  • No formulas or formatting should be used.
Two tables in Excel configured according to Oniva's formatting requirements

Import options

During the import, you can specify what should happen to the data:

  • Add new contacts: Creates new contacts if the identifier does not already exist.
  • Update existing contacts: Updates existing contacts based on the identifier.
  • Delete contacts that are no longer in the file: Removes all contacts not included in the Excel file (Warning: This action cannot be undone!). This option is only suitable if no invitations have been sent yet.

Assigning contact groups

During the import, you can directly assign contacts to a contact group. More information on this can be found in the next section.

Linking data fields

After selecting the file, you must assign the Excel columns to the appropriate Oniva data fields. Unassigned columns will not be imported. If you need custom fields such as CRM number, account manager, or keywords, create them in the registration form beforehand. If these fields should be visible only to you but not to guests, activate the "Hide for contact" option.

The identifier

The identifier is used to uniquely recognise a contact and determines whether an existing record is updated or a new one is created. Suitable identifiers include email address, customer number, or employee number, as names can appear multiple times. If a contact registers themselves without an invitation, the system automatically generates a random 16-character ID. Identifiers can be exported along with the contacts.

Available data fields

In addition to custom fields, the following fields are available by default:

  • Identifier: Unique ID for assigning contacts.
  • Email/Mobile number: Required for sending invitations.
  • Language: Relevant for multilingual events.
  • Account manager: Optional for notifying customer representatives.
  • Gender: Used for salutations in campaigns (if not available, "Hello" is used).
  • Check-in info: Displayed in the check-in app (e.g., "VIP", "Seat number").
  • First name, last name, etc.: Depends on the fields in the registration form.

Note: Only the identifier is mandatory. All other fields can be left empty during the import and completed by the guest. The more data you import, the less the guest has to fill in themselves.

Data validation

Before importing, you can review the data of the first contact. If everything looks correct, you can start the import. Once completed, the status will be available in the import log.

Screenshot of the navigation to the import logs.

Import status and import logs

Depending on the size of the import, it may take some time to complete. You can check the import status by clicking on logs in the upper right corner of the contacts section. The system also shows how many contacts were created, updated, deleted, and skipped. "Skipped" means the system could not process the contact because the identifier was missing or incorrect, or because the record already existed and updating was not selected. To see which records were skipped, you can review the detailed log and filter for "skipped" entries. The detailed log always displays the row number along with a message. You can then check the corresponding row in the Excel file.

Screenshot of the navigation to the detailed log.

Contact status

  • Open: The contact was added by the admin and has not yet visited the event website via the personal event website link.
  • Accessed: The contact has visited the event website at least once.
  • Registered: The contact has made a booking or was manually registered by the admin.
  • Deregistered: The contact has declined the invitation or was manually unregistered by the admin.
  • Waiting: The contact has made a booking on the waiting list or was manually added to the waiting list by the admin.
  • Attended: The contact has a valid booking and has been checked in using one of the check-in solutions.

Contact groups

Contact groups are a useful feature that allows you to organise your contacts into subgroups for better management and targeted communication. You can create contact groups directly under the "Contacts" menu. You can either use existing filters or search terms to pre-select your contact list, or you can manually select the desired contacts. Then, you can add them to the appropriate contact group. If you want to assign a contact group during the import of contacts, you can do so in the advanced options of the import process, either by creating a new group or selecting an existing one.

Screenshot of creating contact groups from the contact list

If you want to create a contact group based on criteria other than the available filters, you can also do this through an import. To do this, prepare an Excel file containing all the contacts that should be added to the contact group. It's important that each contact has an identifier specified.

Screenshot of creating a contact group

To add a contact group retroactively with an import, follow these steps:

  1. Prepare an Excel file containing all the contacts that should be added to the contact group, ensuring that each contact has an identifier.
  2. In the Oniva interface, select the "Contacts" menu and click on "Import contacts".
  3. Upload the prepared file and activate the option "Update existing contacts only".
  4. Click on "Show advanced options" and select the contact group or create a new one.
  5. Match the identifier from the Excel sheet to the corresponding table columns and skip everything else.
Screenshot of entering the contact group during an import

After completing the import, all contacts will be added to the contact group. To remove a contact from a contact group, simply open the contact and edit it to change the contact group assignment.


Frequently asked questions

  • What is the difference between contacts and bookings?
    Contacts list all contacts regardless of their booking status, while Bookings list all confirmed bookings.
  • The number of campaign recipients doesn't match the number shown under Contacts. What could be the reason?
    If the number of contacts doesn't match the number of campaign recipients, it could be due to the following reasons:
    - Some contacts haven't provided an email address.
    - Some contacts have unsubscribed from campaigns.
  • I have empty rows in my contact list with the status "Accessed." How do they occur, and what do they mean? Should I delete them?
    Empty rows with the status "Accessed" occur when a user opens the event website and clicks "Register" but either cancels the booking or does not enter any data within 15 minutes. These entries have no impact and can be deleted if unwanted, but they often provide useful insights. For example, they show how many users visit the page without completing their booking – potential reasons could include a high price, a lengthy registration form, or an unsuitable event date.
  • Two columns are displayed for a piece of information (email address / name, etc.) in my contact list. What could be the reason?
    If information appears in multiple columns, it indicates that the record in the registration form isn't linked with the correct identifier. The system doesn't recognise that the information in both columns corresponds to the same data. To ensure proper linkage of guest data, always work with a predefined identifier from the system where available. By default, the following identifiers are defined: title, function, firstname, lastname, organization, phone_mobile, image, job_title, badge_info, email, street, zip, city.
Download illustration

Was this article helpful?

Thank you very much! Your feedback has been recorded.
Huch! Beim Absenden des Formulars ist etwas schief gelaufen.

Helpful Information for event managers

Discover exciting articles about creating unforgettable events.

Didn't find an answer?

If you couldn't find the information you were looking for, our support team is happy to help. Create a ticket, and we will get back to you as soon as possible.
Time icon
Support hours
Monday to Friday, 08:00 to 17:00
(excluding public holidays in the city of Zurich)

Contact support

Warning icon
Third-party cookies required
Your browser's security settings do not allow third-party cookies. Please adjust your browser's security settings or try a different browser to view this content.

Refunds

Refunds are subject to a fee of CHF 2.50 per transaction in addition to the processing fee. Whether this fee will be borne by the guest or the organizer can be determined by you. The refund will then be processed for the full or partial amount. Ideally, you should specify this in your guest terms and conditions.
Warning icon
Third-party cookies required
Your browser's security settings do not allow third-party cookies. Please adjust your browser's security settings or try a different browser to view this content.