Technical information

1. Data tables

TourOp holds 44 data tables, which can be divided into six main sections:

(1) The storage of pre-set elements such as hotels, flights, vehicles, contacts, etc.
(2) Price structures such as overnights, flight rates, rental formulas for vehicles, etc.
(3) Quotation data which keeps track of all quotation-related records, partly starting from the previous two data, and partly using new “quotation-only” information.
(4) Follow-up data such as availability, alternatives and confirmations.
(5) Reports, used for vouchers, lay-out, PDF-printouts, documents, etc.
(6) Secondary tables like currencies, countries, nationalities, etc.

The following is the full table list:

  • Brookers
  • Brooker types
  • Air rates
  • Banks
  • Boards
  • Vehicles
  • VAT scales
  • VAT conversion parameters
  • Accommodation categories
  • Countries
  • Currencies
  • Destination descriptions
  • Information about the destination
  • Quotations general data and travellers
  • Accommodation per quote
  • Transport per quote
  • Destination info per quote
  • Insurances per quote
  • Vehicle specifications per quote
  • Tours, packages and services per quote
  • Status of quotations
  • Quotation versions
  • General follow-up after booking
  • Follow-up accommodation details after booking
  • Follow-up vehicle rental details after booking
  • Follow-up flights after booking
  • Follow-up insurances after booking
  • Follow-up tours, packages, services detail after booking
  • Follow-up accommodation detail after booking
  • Accommodation
  • Travel insurances
  • Nationalities
  • Exchange rates
  • Currency conversion parameters
  • General rates
  • Tours
  • Reservation centrals
  • Signatures of employees
  • Supplements
  • Titles
  • Services
  • Travel agents
  • Vouchers
     

2. Barcodes

All vouchers are automatically printed out with a barcode which identifies the file's internal reference. Barcodes are generated with the Code 128 symbology. For example:
 

 

3. Accessing raw data

Generally we don't feel like giving access to the raw data, because there is a risk to cause big problems if a person does not know what s/he is doing. If the customer is technically skilled enough, it is not a problem to provide in an access code. Access is possible through a standard UNIX shell prompt or by PhpMyAdmin, an open source tool for easy MySQL administration, see www.phpmyadmin.net or the following screenshot:
 

 

4. Traffic and memory

TourOp was carefully designed in regard to traffic and memory consumption. The right SQL-indexing and CPU load balancing guarantees smooth and quick database actions. Our tests have indicated that TourOp almost never exceeds 5% of CPU of the machine. In rare cases the memory might go over 5%, when dynamic PDF reports are generated (especially when holding binaries) or when more heavier mail routines have to be executed. Even for those actions, the memory consumption stays below 5% most of the time. Since TourOp is webbased software, it is dependent for its speed on the ISP of the user (Belgacom, Telenet, ...). If the internet provider is experiencing a slower connection, this will also have an impact on TourOp. For this reason, we recommend to have a backup internet connection, in case the main connection has problems. Especially for larger enterprises, the advantages can be considerable.
 

5. Data Storage

TourOp stores its data on a server in a Class-A datacenter. If you start working, you make a connection to that server. The computer of the employee acts as a thin client. There is a consensus that this architecture is generally more modern, more efficient and more robust then the ancient LAN-configurations. Also the maintaince costs can be heavily reduced.
 

6. Security issues

The authentication password is sent each time you perform any action, using standard UNIX htaccess authentication. We take backups of your entire database every day of the week, which are overwritten every next weekday. Additionnally, one general backup is created once a month whith remains available for a year. These backup facilities are all automated. When a computer of an employee crashes, s/he can immediately continue to work with another computer, without any loss of data.
 

7. Client requirements

TourOp does not need any plugins or special configurations; it only needs a browser and a PDF reader for the reports. TourOp requires Microsoft Internet Explorer 7.0 or higher. Any computer that can run this browser, can run TourOp. This means that all PC's and laptops from 2005 or later are suitable. Also Mac users can use TourOp if they are equipped with Microsoft Internet Explorer 7.0 or higher.

You can use any printer that works on your local computer. All reports are generated in PDF, so all the print settings are also controlled by that generated file.

TourOp does not need to be installed. You receive a unique login and password for every employee, and your computer is ready to start.
 

8. Mobile devices

TourOp is acccessible for any device that:

- is equipped with the Microsoft Internet Explorer browser 7.0 (or any higher version)
- has a screen resolution which is equal to, or wider than, 1024*768 pixels
- has access to the internet
 

9. Environment and technologies

TourOp runs under BSD UNIX with the Apache Web Server. MySQL is used as database server. The server software itself is programmed in Perl. These technologies are known under the LAMP-prinicple. For the client side, the interfaces towards the browser are developed with HTML, Ajax, CSS and javascript. The Google Maps API is used to display destination info on a map.
www.freebsd.org
www.perl.com
www.apache.org
www.mysql.com
maps.google.com

 

 

 

© TourOp is a product of Dot Internet Ltd - All rights reserved.

Back to Homepage