Middlebury

Webtix Development

To test a sale in WebTix change:

In config.php: $cstage['emailNotify'] = "example@example.com"; - change you your address

$cstage['cc_testing'] = false; // test credit card - not live (some modules do not support this - if you change to true it will not charge your card.

Resources:

The Webtix changelog is posted at: https://www.centerstageticketing.com/help/

Updating:

Currently webtix is version controlled in Git.

Previously an update was performed by doing a 3 way file compare on the old base webtix custom files, the new base webtix custom files and the old edited custom files to make a set of new edited custom files that include the new updates from the new base files.

Upgrade Webtix Database

  • Make a folder and extract the latest version of webtix into it.
  • Hit it with a web browser and enter your database info in the database tab and hit save.
  • Copy paste the generated SQL statement that includes any updates into PHPMyAdmin SQL and run.
  • Hit save again on the database tab in the webtix installer. You should not get any more notices and your database is now up to date.

To make live: (to be added?)

Adding new students

Every term it is convenient to add the entering students to webtix so they do not need to be entered manually. This is very easy.

How to import new students spreadsheet.

File:

  • Make sure the "Sheet" is labeled "customer" not "Sheet1". (otherwise the table "Sheet1" will be created)
  • Make sure the fields are labeled the same as the corresponding fields in customer. ("Last Name" for instance will not map to a field)
  • Check its file type by looking at file properties. This one was Excel 97-2003 XLS workbook. You want this info for the import screen on PHPMyAdmin.

Database:

  • Back up the main database like normal.

Test Import:

  • On chisel go to box office database and do some searches on some of the students in the customer table. Make sure they are not in there.
  • Now test an import on chisel. Take note of the number of records in the customer table. Go to "import" tab and choose the appropriate settings. In this case left charset on utf-8, removed partial import check, chose format "Excel 97-2003 XLS workbook" (chose whatever corresponds to the format your file is in), and checked that "The first line of the file contains the table column names". Hit "go".
  • Check the customer table to see if the number of records was incremented by the amount of records in the imported file. Search for a few of the records and confirm they went in appropriately.

Production:

  • Reproduce the import steps on production.
Powered by MediaWiki