Hello,
May I know Which table store bar code info at Tessitura?
How can I find the bar code setting in Tessitura.
The Tessitura documentation says that bar code is built in to Tessitura, based on the ticket number
select *from t_design_elementwhere description like '%barcode%'
ele_group_no ele_no description data type data_len test_val design_cat 4 215 Skidata Barcode C 22 1234512345678901212123 T
the barcode lenth is 22
which is not consistent with the length of ticket number(4)
I am very confused here....
Any suggestions would be appreciated
Thank you very much in advance.
Vicky
Hi Vicky,
Good day.
T_BARCODE_TYPE, T_FONT, T_PRINTER, t_design_ele_group, T_DESIGN_ELEMENT T_DESIGN These are tables maybe you are interested. len of 20 is 2. length of twenty is 6. Barcode is just a kind of font good for scanners. Sorry, I cannot read it. like customer_no and firstName, they are two objects. So they may or may not have consistent properties. have fun Ben
T_BARCODE_TYPE,
T_FONT,
T_PRINTER,
t_design_ele_group,
T_DESIGN_ELEMENT
T_DESIGN
These are tables maybe you are interested.
len of 20 is 2.
length of twenty is 6.
Barcode is just a kind of font good for scanners. Sorry, I cannot read it.
like customer_no and firstName, they are two objects.
So they may or may not have consistent properties.
have fun
Ben
Normal 0 false false false EN-US ZH-CN X-NONE MicrosoftInternetExplorer4
Hello Ben,
Thank you very much for your reply
I have done a quick search for barcode in our system,
USE [impresario]
GO
declare @SearchTerm varchar(50)
SET @SearchTerm = 'barcode'
SELECT
ROUTINE_NAME,
ROUTINE_DEFINITION
FROM
INFORMATION_SCHEMA.ROUTINES
WHERE
ROUTINE_DEFINITION LIKE '%' + @SearchTerm + '%'
ORDER BY
ROUTINE_NAME
and found that procedures/functions related to barcode are
FS_NSCAN_BARCODE FS_SKIDATA_BARCODE TP_GET_HEADER_ELEMENTS TP_GET_RECEIPT_ELEMENTS TP_GET_SKIDATA_BARCODE TP_POPULATE_ACCESS_CONTROL TP_UNDO_BENEVOLENCE_EXEC UP_POPULATE_REFTABLES_TABLE WP_PRINT_ORDER LP_INSERT_PERMISSIONS TP_GET_PERMISSION_ROW TP_GET_PRIOR_PERMISSION
**************
In the procedure TP_GET_TICKET_ORD_ELEMENTS returning barcode information in the final select
if @t_ele_no = 215 -- skidata barcode added 7/18/2004 MAR Exec [dbo].tp_get_skidata_barcode @sli_ticket_no, @perf_theater_no, @seat_section, @perf_perf_no, @sli_skidata_barcode output
if @t_ele_no = 244 -- nscan barcode added 1/3/2007 CWR Select @sli_nscan_barcode = [dbo].fs_nscan_barcode('99', @sli_ticket_no, @perf_perf_no)
In the procedure TP_GET_SKIDATA_BARCODE
Select @skidata_prefix = default_value
From t_defaults
Where parent_table = 'Impresario'
and field_name = 'Skidata Prefix'
fs_skidata_barcode(@skidata_prefix, @ticket_no, @theater_no, @section_no, @perf_no)
the bar code is encrypted at FS_SKIDATA_BARCODE
Both functions FS_NSCAN_BARCODE and FS_SKIDATA_BARCODE encrypt barcode
In procedure TP_POPULATE_ACCESS_CONTROL Procedure writes a row for every valid ticket in a given performance. Can be called by a report or by the T_PERF update trigger if door times are changed
Insert t_hsh_permissions(status, ticket_no, data_carrier_id, customer_no, permission_type,
validity_from, validity_to, theater_no, section_no, perf_no)
Select 'O',
e.ticket_no,
data_carrier_id = dbo.fs_skidata_barcode(@skidata_prefix, e.ticket_no, d.th_no, c.section, p.perf_no),
f.customer_no,
0,
p.doors_open,
p.doors_close,
d.th_no,
c.section,
p.perf_no
From t_perf p
JOIN t_facility d ON p.facility_no = facil_no
JOIN t_sub_lineitem e ON p.perf_no = e.perf_no
JOIN t_order f ON e.order_no = f.order_no
JOIN t_seat c ON e.seat_no = c.seat_no
Where p.perf_no = @perf_no
and e.sli_status = 12 -- only ticketed SLI's
Select @save_rowcount = @@rowcount
If @return_results = 'Y'
Select Convert(varchar, @save_rowcount) + ' ticketed seats sent to the Access Control server.'
Those procedures either doing insert or select for t_hsh_permissions,
Normal 0 false false false EN-US ZH-CN X-NONE MicrosoftInternetExplorer4 T_HSH_PERMISSIONS holds all of the data that will be and has been sent to Handshake.
The problem is I can’t see any records in this table.
We want barcode printed in our E-ticket(Customer could print at home). What would you suggest?
Thank you very much in advance!