Publish tickets quickly with a dataview

Cultural centres publish their tickets and season tickets in Yesplan every year around March to make them available for sale. But how can you do this fast?

Lots of clicks in the calendar 

Until now you had to find each individual event in the Yesplan event calendar, open it and click on the publication button. And hope that you didn't overlook an event. That is time-consuming and we think it can be improved… 

Few clicks in dataviews 

You can tackle this in a smarter way thanks to dataviews. You can create a dataview with a list of all events that you want to publish. Even better: from that dataview you can open and publish events. Afterwards they automatically disappear from your list. How does it work? 

1. Create a dataview 

  •  In Yesplan go to “Reports” > “Dataviews” 
  • Click on the buttons “New” > “Events” 

2. Add the desired columns 

 In the dataview click on “Edit columns” then add the following columns: 

  • Date
  • Name 
  • Displayed Start Time
  • Location 
  • Status 
  • Profile 
  • Publication status. This varies per installation, but typically you'll find the button under 
    • Integrations > Ticketing > Publish 
    • Integrations > Publish > Publish 
    • Integrations > Send to ticket sales > Publish 

Of course, you can add other columns to the dataview (e.g. agency, ticket prices, etc.). 

3. Add the desired filters 

Click on “Edit filter” then add the desired filters, such as: 

  •  a particular period 
  •  at a particular location 
  •  with the status “Confirmed” 
  •  and the profile “Performance” 

 If you filter by the value “OFF” in the “publish” field, then you'll only see the events that have not yet been published.

4. Publish! 

In the dataview you can now 

  • open an event by double clicking it 
  • go to the correct tab and publish the event
  • after which the event disappears from your dataview 

 Tip: Would you like a summary of all published events? In the “publish” field, filter by the value “ACTIVE”.