Skip to main content
These are the fields for clients, venues, inventory, acts, guests, hotels, vehicles and sponsors. How to read a row, the fields at the top of the file and the other records are in Import file fields. Every field here is Stable for version 2.x.

Clients (clients[])

Clients (customers) that projects and gigs are for. Give a record a ref (any short name, such as main-stage) so other records in the same file can point at it, and an external_id (its ID in your other system) so importing the file again updates that record instead of adding a copy.

Example: clients

A client with a ref, an external ID and a primary contact.

Venues (venues[])

Venues that gigs take place at. Give a record a ref (any short name, such as main-stage) so other records in the same file can point at it, and an external_id (its ID in your other system) so importing the file again updates that record instead of adding a copy.

Example: venues

A venue with its production details.

Inventory (inventory[])

Gear the organization owns.

Example: inventory

A piece of gear with its count.

Acts (acts[])

Performing acts that run-of-show items can name. Give a record a ref (any short name, such as main-stage) so other records in the same file can point at it. Acts match by name, ignoring case; external_id is kept for reference and does not match a record.

Example: acts

An outside act that a run-of-show cue can name by ref.

Guests (guests[])

People on the org’s guest list. A gig’s guest list names them with guest_ref. Give a record a ref (any short name, such as main-stage) so other records in the same file can point at it. A guest with an email or phone matches an existing guest by it; a guest with neither matches a guest of the same name who has no contact details either. external_id is kept for reference and does not match a record.

Example: guests

Guests the org keeps, a gig’s guest list that names them by ref, and a guest source listed for reference (import ignores it).

Hotels (hotels[])

Hotels the org has saved. A gig’s hotel stays name them with hotel_ref. Give a record a ref (any short name, such as main-stage) so other records in the same file can point at it. A hotel with a place_id joins the shared directory record for that place; one without matches a hotel the org has saved with the same name, ignoring case. A matched hotel is not changed. external_id is kept for reference and does not match a record.

Example: hotels

A saved hotel and a gig’s stay there with its guests, named by member email.

Vehicles (vehicles[])

The org’s own and rented vehicles. A gig’s rides name them with vehicle_ref. Give a record a ref (any short name, such as main-stage) so other records in the same file can point at it. A vehicle matches a vehicle of the same name, ignoring case. A matched vehicle is not changed. external_id is kept for reference and does not match a record.

Example: vehicles

An org van and a gig’s ride in it, with its riders named by member email.

Sponsors (sponsors[])

The org’s sponsors. A gig’s sponsor deals name them with sponsor_ref. Give a record a ref (any short name, such as main-stage) so other records in the same file can point at it. A sponsor matches the org’s sponsor with the same name, ignoring case, when their emails agree or either has none. A matched sponsor is not changed. external_id is kept for reference and does not match a record.

Example: sponsors

A sponsor with a standing deal, and a deal tied to one gig.