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.
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!