We present performances at a number of different external venues who will be able to scan our tickets if we can export some basic information, including bar codes. I can easily get everything I need by running the Order Export Utility. Here's the wrinkle: our current ticket design uses the Ticket No for bar codes instead of the N-Scan Number, which is what the Order Export outputs.
We've already done our season subscription ticket printing & mailing, so changing the ticket design isn't an option until next season. In the meantime, I figure there must be an easy way to change the output on the Order Export Utility from N-Scan Number to Ticket No.
Is there a way to flip this output? Perhaps in a system table? I remember reading something about a stored local procedure that could also alter the order export output...any ideas?
I guess my last resort would be to copy the SQL and create a local custom version of the utility with the output modified, but it seems like there must be an easier way...
Thanks in advance for any ideas!
Hello Jonathan,
There is indeed a procedure you can use for this purpose. LP_ORDER_EXPORT is called during the generation of the report, and you can use it to alter the table TW_ORDER_IMPORT before the contents is output. There are 10 local use columns included in the report where you could put the ticket number if you wanted to preserve the original data. The comments in the procedure provide some guidance.
-Michael Wilcox, Tessitura Network
Thanks so much, Michael! That did the trick. It took me a while to figure out how best to get what I needed using TW_ORDER_IMPORT as my starting point, but I got there. I'm essentially undoing FS_NSCAN_BARCODE and then running an UPDATE statement that dumps the resulting number into local_use0. Thanks again for pointing me in the right direction!
Hi Jonathan,Would you be willing to share your LP_ORDER_EXPORT edit with me? I'm looking to add something to the Export output and am running into a stumbling block also!
Thanks!