Skip to content
EntryWick documentation

Imports and exports

Events → Imports and exports. Spec: docs/API_V1.yaml tag "Bulk", docs/INTEGRATIONS.md §3 v3 (Eventbrite), L04.

One list of everything your organization has imported or exported — from this page, through the API, or from Eventbrite. The list refreshes itself while anything is running.

Importing people from a file

Import people takes a CSV with one row per person. Columns are matched by their headings (first name, last name, email, phone, type, group, day, date of birth, ID); a column that matches nothing is kept on the person as an answer.

  • Up to 500 rows import while you wait, and the counts appear as soon as it is done.
  • More than 500 rows run in the background on the Starter plan and above; the row shows how far it has got ("1,250 of 3,434").
  • Preview only does all the matching and changes nothing — the counts are exactly what a real run would do.
  • Nobody is added twice. Every row is matched first by its ID, then by email and name, then by phone and name. A match is updated in place and keeps its tickets.
  • A row that cannot be placed — no name, a type the event does not have, the plan's attendee cap — is left out and listed in a Rejects file with the reason, ready to fix and upload again.

Exporting

Export gives registrations, people or tickets as CSV or Excel, with times in the event's timezone. Up to 2,000 rows download at once; a larger export is built in the background and a Download link appears on its row. Links stop working after a day.

From Eventbrite

From Eventbrite brings an event's people across once, for an organization moving to EntryWick:

  1. Connect Eventbrite and approve on Eventbrite's screen.
  2. Choose the Eventbrite event and the EntryWick event it goes into.
  3. For each ticket class, choose the attendee type it becomes — or Don't import (complimentary or staff tickets, for example). A class named like one of your types is chosen for you.
  4. Start import. It runs in the background (Starter and above) and appears in the list.

Each order becomes one registration and each attendee a person with their tickets, confirmed without emails unless you tick "Send confirmation and ticket emails". Cancelled and refunded attendees are skipped. Running the same event again adds nobody twice. Nothing is ever changed on Eventbrite, and the connection can be removed once you are done.

Through the API

POST /v1/events/{event_id}/imports, POST /v1/exports, then GET /v1/jobs/{id}: the same jobs, with progress, counts, rejects_url and result_url. See the developer reference.