12 digit barcoding - masking

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

 

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??

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=====