Hi Guys -
Wondering if anyone out there has been able to 'mask' a barcode to make it 12 digits no matter how long the actual barcode is?
We need our Tessitura barcode to be 12 digits long as we have an external company scanning for access control to one venue of ours - they have a requirement that it has to be 12 digits long - so far we are up to 6 digits, but we need it to be 12
Ideas Tessitura goers??
Hi Ranie
A barcode is just a font, really, so you should just need a bit of sql code to format your number as a 12-digit character string by adding enough zeros to the front of it.
This type of thing should work:
-- Convert the number to text, (I’ve just used 123456 as a sample number here)
-- add 12 zeros to the front, to make sure it’s at least 12 characters long
-- and chop off everything before the rightmost 12 characters to bring it back to the correct length
select right('000000000000' + convert(varchar, 123456),12)
------------
000000123456
(1 row(s) affected)
You might need to put some version of that in a User-Defined Element to use it on your tix, I think – not sure if it’ll work as a Mask.
KEN MCSWAIN BUSINESS SOLUTIONS MANAGER
KEN.MCSWAIN@SYDNEYOPERAHOUSE.COM
T+61 2 9250 7876 F+61 2 9251 7821 M+61 418 659 360
SYDNEY OPERA HOUSE BENNELONG POINT
GPO BOX 4274, SYDNEY NSW 2001, AUSTRALIA
SYDNEYOPERAHOUSE.COM
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Ranie Daw Sent: Tuesday, 18 August 2009 08:45 To: Ken McSwain Subject: [Tessitura Ticketing Forum] 12 digit barcoding - masking
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Please consider the environment before printing this email. =====This message is intended for the addressee(s) named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====
Hey Ken - we'll have a look at this - i guess one thing to consider is that our barcode could go from 6 digits to 7 digits - so the equation should be flexible - i'll check it out and see if a userdefined element can do the trick.
Thanks for your feedback.
That’s why it does the trick with adding 12 zeros at the front, then trimming it down to 12 digits – it’s a simple way of ensuring that it doesn’t matter how many digits there are in your original number, there will always be exactly 12 in the output.