The Templar Web Client Interface is intended to serve as a replacement for the Templar Client used with Templar Enterprise Edition installation.
In its current BETA state, it should only be used only in addition to the Templar Client as some parts of the functionality are still a work in progress.
Templar Web Client Interface BETA Requirements
Currently the BETA only supports Templar Enterprise Edition installations that are using MySQL database.
SQL and Oracle database supports is being worked on currently.
You also will need a Web Server that supports PHP 5.6 has it installed and setup.
Templar Web Client Interface BETA Setup
- Extract the templar7.zip folder to a Web Server
- Edit the config\db.php so it points to the correct MySQL database
You will need to update the host, port, database name, username and password in the following lines:
'dsn' => 'mysql:host=localhost;port=3306;dbname=templar',
'username' => 'templar',
'password' => 'templar', - Edit the config\params.php fil so it points to the location of your Templar Server’s related folders in the following lines:
'fileUploadFolder' => 'C:/Program Files/TemplarServer/transmit/pickup/',
'receivePickupFolder' => 'C:/Program Files/TemplarServer/receive/pickup/',
'incomingHtmlFileFolder'=>''C:/Program Files/TemplarServer/receive/pickup/',
'rootFolder' => 'C:/Program Files/TemplarServer/', - Backup your current MySQL database. The Web Client Interface doesn’t affect normal operation of Templar, but it is best to backup the database first to be safe.
- Run the following SQL against the DB to update it to be compatible with the new:
• Add new auto-increment column ID to TRADINGPARTNERAGREEMENT
• Add new auto-increment column ID to TPQUALIDS
• Add new auto-increment column ID to TPKEYIDS
• Set ID on usertplink to auto increment
• Add new column TPAALIAS varchar() to TRADINGPARTNERAGREEMENT
• Run following query:
UPDATE TRADINGPARTNERAGREEMENT set TPAALIAS = (select TPPROPVALUE from TPAPROPERTIES where TPPROPNAME='tpa.alias' and TPTPAID=TPAID and TPTPAREVNO=TPAREVNO)
The default length of 45 characters should be long enough for the TPA Alias field (unless you have longer aliases currently in use) - what this change does is move the alias from a separate table to the TPA table itself
• The auto-increment columns should be int - you can add them using this command:
ALTER TABLE `myTable` ADD COLUMN `id` INT AUTO_INCREMENTUNIQUE FIRST;
replace MyTable with table name
