Version 6.72

Theatre Manager will

• Reorganize the database (there are a couple of changes to the database since version 6.64)

The user will need to

Web Sales

• Added the ability to do custom extended searches for event in the tickets window. Samples are contained in the TMtickets.html web page. This should not affect any sites, unless you want to add a different kind of search (such as by genre or what have you) to the tickets page. Do not make these web page changes if you do not need a custom search. Most sites will not need these.
  • Sample usage of this extra parameter are:
    Sample 1: Using the Performance flag to find out which performances match a particular letter <any kind> Comedy Drama
    
    <select name="search" id="search">
    <option value="">**any kind**</option>
    <option value="(PB_PERF_FLAG='C')">Comedy</option>
    <option value="(PB_PERF_FLAG='D')">Drama</option>
    </select>
    
    Sample 2: Using the contents of play notes to see if a particular word is in it <any kind> Comedy Drama
    
    <select name="search" id="search">
    <option value="">**any kind**</option>
    <option value="pos('comedy',low(P_SALES_NOTES))">Comedy</option>
    <option value="pos('drama',low(P_SALES_NOTES))">Drama</option>
    </select>
    
• Added the ability to print bar codes on certain pages that have ticket data in them. This can occur on the checkout confirmation pages (after the patron has purchased), on the list of historical orders (if the patron wants to reprint the order) and/or on the 'future tickets' option which allows the patron to print tickets/bar codes by event, should they have purchased via the box office or through multiple web purchases.
  
  There are a couple of advisory notes about printing bar codes on tickets
1. Do not implement this feature unless you have a good system for detecting admissions and patrons trying to use the scanned ticket twice. We offer the ability to scan tickets at the door using wireless hand held technology (symbol 1846 & custom palm software). This communicates to theatre manager web listener to check that people have (or have not) used their tickets wirelessly. The alternative is to use a hand held CCT scanner tied to a computer that also talks to the web listener.
2. You will need confirmation technology at each entrance to the venue. This allows you to check people in and out anywhere. It also allows people to check in once, then leave, then come back. In call cases, a ticket can only be used once.
3. The sample pages print a bar code for each ticket. We have not created a fancy looking ticket with advertising on it and the bar code - but that can be done for your site if you wish. Our sample only shows the capability to print a bar code on a per ticket basis.

This feature can be implemented on any version of theatre manager. Enterprise versions can use a single web server to provide checking for all scanners. All other versions require a dedicated copy of theatre manager set in the 'check attendance' mode for that event.

The additional code in a web page is to simply to refer to an image file <IMG src="<field>F_HTML_TIX_BAR_CODE</field>">
This code sends an encrypted message to our servers and asked for a barcode to be returned to the web page. You can add parameters to this link if you wish to rotate, scale or remove the numbers from the bar code. The additional parameters are:

Parameter	Sample use
&notext	Removes the text from the bar code image <IMG src="<field>F_HTML_TIX_BAR_CODE</field>&notext">
&vertical	Rotates the the bar code image and puts it vertically on the page. The default is horizontal <IMG src="<field>F_HTML_TIX_BAR_CODE</field>&vertical">
&width=xx	Changes the width of the barcode in either horizontal or vertical mode. The default is 50 <IMG src="<field>F_HTML_TIX_BAR_CODE</field>&width=100">
&counterclockwise	rotates the bar code counterclockwise. If printing horizontally, it will be upside down. If printing vertcally, it will be bottom to top. <IMG src="<field>F_HTML_TIX_BAR_CODE</field>&counterclockwise">
	Note that multiple parameters can be combined if desired. For example, the following prints with no text, bottom to top and wider than normal. Additional parameters can be in any order. <IMG src="<field>F_HTML_TIX_BAR_CODE</field>&counterclockwise&notext&width=100">

If anybody changes the link in any way, attempts to modify it, they will received an invalid bar code. This ensures that unscrupulous internet hackers cannot create any random tickets to attempt to counterfeit them. Theatre Manager will not accept them.

Sample bar codes look like:

Valid Bar Code	Invalid Bar Code

• You can update your pages to match the template pages by:
  • Download the sample web page folder for Mac or Windows
  • Install the sample web pages into a directory of your choice. You will need to specify the password you were previously given
  
  
• Pages that changed in this archive that may need to be updated in your web pages. Do not change any of the pages if you do not intend implementing print at home tickets or want to implement at door controls over ticket admissions.

in TMtemplates Folder
rowOldCartDonation.html	added column to end of table that is blank to support bar codes. Code is <td>&nbsp;</td>
rowOldCartFestival.html	this file is used when browsing old shopping carts. If you wish to have bar codes in the historical shopping cart, then please add bar code column for festival tickets. Code is: <td align="right"><IMG src="<field>F_HTML_TIX_BAR_CODE</field>"></td> Also changed the location of the class="tablerowdetail" from the <TR> to each of the <TD> sections. This must be done so that the bar code is printed black on a white background.
rowOldCartMailFee.html	added blank column <td>&nbsp;</td>
rowOldcartorderFee.html	added blank column <td>&nbsp;</td>
rowOldCartPass.html	added blank column <td>&nbsp;</td>
rowOldCartReserve.html	this file is used when browsing old shopping carts. If you wish to have bar codes in the historical shopping cart, then please add bar code column for reserved tickets. Code is: <td align="right"><IMG src="<field>F_HTML_TIX_BAR_CODE</field>"></td> Also changed the location of the class="tablerowdetail" from the <TR> to each of the <TD> sections. This must be done so that the bar code is printed black on a white background.
rowCheckoutDonation.html	added blank column <td>&nbsp;</td>
rowCheckoutFestival.html	this file is used when displaying the items that the patron has just purchased. If you wish to have bar codes in the currently checked out shopping cart, then please bar code column for festival tickets. Code is: <td align="right"><IMG src="<field>F_HTML_TIX_BAR_CODE</field>"></td> Also changed the location of the class="tablerowdetail" from the <TR> to each of the <TD> sections. This must be done so that the bar code is printed black on a white background.
rowCheckoutMailFee.html	added blank column <td>&nbsp;</td>
rowCheckoutOrderFee.html	added blank column <td>&nbsp;</td>
rowCheckoutPass.html	added blank column <td>&nbsp;</td>
rowCheckoutReserve.html	this file is used when displaying the items that the patron has just purchased. If you wish to have bar codes in the currently checked out shopping cart, then please bar code column for reserved tickets. Code is: <td align="right"><IMG src="<field>F_HTML_TIX_BAR_CODE</field>"></td> Also changed the location of the class="tablerowdetail" from the <TR> to each of the <TD> sections. This must be done so that the bar code is printed black on a white background.
rowFutureTicketFestival.html	this file is used when displaying the tickets for upcoming events that the patron purchased in the past. If you wish to have bar codes for future events, then please bar code column for festival tickets. Code is: <td align="right"><IMG src="<field>F_HTML_TIX_BAR_CODE</field>"></td> Also changed the location of the class="tablerowdetail" from the <TR> to each of the <TD> sections. This must be done so that the bar code is printed black on a white background.
rowFutureTicketHeader.html	added an extra column in the ticket header to support the extra column in each row. Check the web page to see the code change.
rowFutureTicketReserved.html	this file is used when displaying the tickets for upcoming events that the patron purchased in the past. If you wish to have bar codes for future events, then please bar code column for reserved tickets. Code is: <td align="right"><IMG src="<field>F_HTML_TIX_BAR_CODE</field>"></td> Also changed the location of the class="tablerowdetail" from the <TR> to each of the <TD> sections. This must be done so that the bar code is printed black on a white background.
in WebPages folder
TMoldCartDetails.html	added an extra column in the ticket header to support the extra column in each row. Check the web page to see the code change.
TMCheckoutConfirmation.html	added an extra column in the ticket header to support the extra column in each row. Check the web page to see the code change.
TMFutureTickets.html	added an extra column in the ticket header to support the extra column in each row. Check the web page to see the code change.
TMTickets.html	Shows a sample of how to use the extra search criteria for finding events. This sample is in the comments and for documentation purposes only.
tmContact.html	cosmetic change: removed the http:// from in front of the web site address
tmContactHours.html	cosmetic change: removed the http:// from in front of the web site address
TMCheckoutConfirmationEmail.html	added an extra column in the ticket header to support the extra column in each row. Check the web page to see the code change.
TMCGI folder
barcode	This is an additional CGI script that acts as a proxy to the Arts Management bar code server. All bar codes are generate using a special program on our web server. However, if you refer to our web server from your web pages, it may tell the customer that they are accessing a non-secure web site. To address that, we have created this cgi script that sits on your web site and passes any requests for bar codes through to our server, as if it were on your server. This solves the customers problem of appearing to leave a secure site. To install this and make it work: 1) copy the 'barcode' cgi script to your web site's cgi-bin directory 2) change the permissions on the file to the unix equivalent of CHMOD 755 3) go to setup->Default Data and change the URL for the bar code from www2.artsman.com/barcode to www.yourwebsite.com/cgi-bin/barcode

Credit Card Server

• There is a new version of the PC charge software that we have received (version 5.7.1H). All venues are currently runnig 5.7.1D and if you are experiencing no problems, we suggest that you do not upgrade at this time. Save the upgrading of this to when there is a lull in box office activities
• You can download the latest manual if you wish it. If you would like the link to the software, please send an email to support @ artsman . com
• NOTE: page 20 of this manual has some very specific notes about upgrading from the current version. It states to extract the installers and then to read to see if there are any merchant setup changes for your merchant provider. You can access this file directly on our web site if you wish to read it first.

Misc Changes

• added the ability to merge duplicates for any of the 4 volunteer code tables
• fixed a bug to set the proper field value in the 'allow to use' field in code tables during upgrades (for allow to use at box office, internet and development)
• exporting payments for analysis now decrypts the credit card information, if allowed.
• This version should address most of the issues where users still appear logged on (but are not). When TM starts as the only user, it will detect this flag and clear it.