Background
Creating events one by one can be time consuming, especially when a season calendar is already available and there are a lot of events to create.
Resolution
Easily create multiple events using our Excel spreadsheet event template.
-
Download the Template
- On the Tapin2 Admin portal, click on Events, then Events again from the blue bar on the left side
- On the Events page, click on the Upload Events button
- On the Upload Events page click the Download Template button to download our event Excel spreadsheet xlsx file
- Open the template in your preferred spreadsheet app
-
Edit the Template
- For each of your events create an entry in the spreadsheet:
-
Title: Event name seen by customers
-
Start Date: include a date and time (adjust for Event Start Adjustment if applicable)
-
End Date: include a date and time
-
Include in Reports: True or False
-
Event Type: include the name of the Event Type (leave blank if not applicable)
-
- Save your completed spreadsheet file when finished
- The screenshot below shows a sample spreadsheet that is ready to be uploaded to create 7 events:
- For each of your events create an entry in the spreadsheet:
-
Upload the Template
- With your spreadsheet now completed, navigate to the events upload page on the Admin portal by clicking on Events, then the Upload Events button
- Drag and Drop your spreadsheet onto the "Drop files here to upload" button OR alternatively click the button and choose your file
- After uploading your file the page will refresh and the first 5 rows of your data will be displayed for you to review
- When the data looks correct to you, click on the Upload File button to upload the file
- The next page will display a list and count of all events that were successfully created and events that failed to create
- As a last step, navigate to your venue's Events page and confirm that all of your events have been correctly created
-
Common Issues
When uploading multiple events ensure a smooth process by addressing these common issues:- Duplicate Information - Check for any existing events with identical details
- Date Formatting - Confirm the formatting for Start Date and End Date dates is correct
- File Type Verification - Ensure you are using our spreadsheet Events template file with the file extension .XLSX
-
Troubleshooting Tips
- If issues persist, try the following:
- Device Switch - Attempt the process on a different computer or device
- Browser Change - Try using a different browser to upload the file
- Contact support at Support@tapin2.co.