Good day all,
We need to export barcode data to a non-Tessitura venue, and have been asked for the following:
I've not used the order export utility in the past, but I'm not sure how to get the data in the format that they're looking for. Any advice would be appreciated! Thanks.
The order export utility and and XML format file might do it. We were playing with ours the other day. I'll give it a shot if you like. If i get it happening we can have a catch up and I'll walk you through it
That would be fantastic! Thanks Heath!
Looks like you are uploading to TM Entry? I did this over a year ago - used the order export utility to do so. I edited the file to only include barcode and TM event code as that was all we wanted for simplicity's sake for this particular event. The import to Entry has to be a .txt file I believe. One thing we ran into is that the barcode symbology that TM would accept was different from the barcode symbology in the data we exported from Tessitura. You may have to work with your (or your partners at this venue) Ticketmaster CSS to add an additional letter/character to the beginning of the barcodes being imported so that the scanners and/or Entry will accept the information. I would recommend creating a test event to work this out in Entry and test scan before attempting to put this into your live event.
Thanks Carlie! Yes, this is for a TM venue. Our first of many events there is in September, and they have asked for test data, so I feel like we have time to get it working, which is super great. What format did you use to send the data to them?
Hey Lesley,
Not sure if you're still looking for help on this, or if what I have is helpful for you, but I use the Order Export Utility for every performance to create mini-tickets of a sort by printing barcodes directly on labels. It's my almost-ticketless will call solution. I run the utility, save as an excel file, copy the column with the barcode data into a new sheet, and use the following formula to format the data for our scanners: ="*"&(A2)&"*", where A2 is the first cell with data. This simply adds an asterisk to either side of the numbers in our barcode data, but I'd imagine a similar solution could be used here.
A bit of a longer formula, if I'm understanding your screenshot correctly, but something to the effect of =(AX1)&","&(AN1)&","&(AO1)&","&(AP1)&","&(AQ1)&","&(AR1), based on the columns I have from my order export utility. Not sure what you'd need for the last two items in the string. But this what that formula gives me:
(note that this is from a past performance where I had already formatted the barcode data to include the asterisks)
You can then save the file in whatever format needed for the recipient. I'd save a formula that long somewhere so you can just copy it when you need to use it in the future, if you decide to go that route!