Trialto Wine Group Ltd.

Challenge

Trialto owns three companies that each need to obtain, store, and report on wine sales and inventory data from various provinces in Canada. Each province has different sources of data in different formats and reporting periods.

Solution

Claero Systems created a private web-based application to manage the import, export, reporting, warehousing, etc. of this data.

Results

The system has been live since 2003. As of May 2009 the database currently has over 40 million records and handles more than 5000 queries an hour on average.

Technology Used

Linux, PHP, MySql, Curl, cron jobs

Associated Web Sites

Challenge

Create a clean, fast, and easy-to-update online portfolio for Calibrium International's extensive province-specific wine portfolio.

Solution

An online portoflio management system was created within their existing employee portal web site that allows Calibrium to manage their entire portfolio including the complex relationships between provinces, vintages, etc. They can add images (which is automatically resized as needed), wine reviews, etc. A Joomla module was created to integrate with their existing public web site and to provide the portfolio information to their customers and consumers. Dynamic PDF generation and image resizing was also used.

Results

The new site was launched in time for a big wine show in early 2008. Calibrium is very pleased with the results.

Technology Used

html, css, javascript, php, mysql, Joomla

Associated Web Sites

Challenge

Implement a content management solution for www.calibrium.com so that the Calibrium staff can update the content, images, catalogues, etc. on their web site through a simple browser without any additional software or training. At the same time, it was also required to implement a french language option.

Solution

Claero Systems implemented Joomla and JoomFish to provide an integrated content management and multilingual web site. A custom Joomla template was created to match the existing Calibrium web site.

Results

The site was launched successfully and is now being updated by Calibrium.

Technology Used

html, css, javascript, php, mysql, Joomla

Associated Web Sites

Challenge

Implement a content management solution for www.altovin.ca so that the Altovin staff can update the content, images, catalogues, etc. on their web site through a simple browser without any additional software or training. At the same time, it was also required to implement a French language option.

Solution

Claero Systems implemented Joomla and JoomFish to provide an integrated content management and multilingual web site. A custom Joomla template was created to match the existing Altovin web site. All content was translated and added by the Altovin staff.

Results

The site was launched successfully and is now being updated by Altovin.

Technology Used

html, css, javascript, php, mysql, Joomla

Associated Web Sites

Challenge

Implement a content management solution for www.liquidart.ca so that the Liquid Art staff can update the content, images, catalogues, etc. on their web site through a simple browser without any additional software or training. At the same time, it was also required to implement a French language option.

Solution

Claero Systems implemented Joomla and JoomFish to provide an integrated content management and multilingual web site. A custom Joomla template was created to match the existing Liquid Art web site. All content was translated and added by the Liquid Art staff.

Results

The site was launched successfully.

Technology Used

html, css, javascript, php, mysql, Joomla

Associated Web Sites

Challenge

Create a clean, fast, and easy-to-update online inventory page for Liquid Art's extensive province-specific wine portfolio.

Solution

A Joomla module was created to integrate their existing public web site with their private sales and inventory portal to provide the inventory information to their customers and consumers.

Results

The site is live with the new module and there has been a lot of very positive feedback.

Technology Used

html, css, javascript, php, mysql, Joomla

Associated Web Sites

Challenge

Implement a content management solution for www.trialto.com so that the Trialto staff can update the content, images, catalogues, etc. on their web site through a simple browser without any additional software or training. At the same time, it was also required to implement a french language option.

Solution

Claero Systems implemented Joomla and Joom!Fish to provide an integrated content management and multilingual web site. A canned Joomla template was modified create the new site design.

Results

The site was launched successfully and is now being updated by Trialto.

Technology Used

html, css, javascript, php, mysql, Joomla v1.0.x

Associated Web Sites

Challenge

Due to security problems, it was necessary to upgrade the existing Joomla sites to v1.5.

Solution

Claero Systems migrated the various templates and content in to a new clean v1.5 installation of Joomla.

Results

The sites has been created and is in production.

Technology Used

html, css, javascript, php, mysql, Joomla v1.5.x

Associated Web Sites

Challenge

Due to security problems, it was necessary to upgrade the existing Joomla sites to v1.5.

Solution

Claero Systems migrated the various templates, the custom portfolio module, and content in to a new clean v1.5 installation of Joomla.

Results

The sites has been created and is in production.

Technology Used

html, css, javascript, php, mysql, Joomla v1.5.x

Associated Web Sites

Challenge

Due to security problems, it was necessary to upgrade the existing Joomla sites to v1.5.

Solution

Claero Systems migrated the template and content in to a new clean v1.5 installation of Joomla.

Results

The sites has been created and is in production.

Technology Used

html, css, javascript, php, mysql, Joomla v1.5.x

Associated Web Sites

Challenge

Due to security problems, it was necessary to upgrade the existing Joomla sites to v1.5.

Solution

Claero Systems migrated the template, the custom inventory module, and content in to a new clean v1.5 installation of Joomla.

Results

The sites has been created and is in production.

Technology Used

html, css, javascript, php, mysql, Joomla v1.5.x

Challenge

As several Trialto companies started selling wine under the SAQ private order system, a better way of keeping track of the inventory and sales orders and depletions was needed.

Solution

Claero Systems built a private order system that was integrated to the existing employee portal / sales reporting web application. The new system allows for online inventory tracking and private sales order generation. The system creates a pdf that looks exactly like the SAQ order form so it can be directly faxed to the SAQ. All inventory is tracked and the sales data is immediately available in the sales reporting tools already used by Trialto.

Results

The system has been in production since the Fall of 2009 and is working well.

Technology Used

PHP, MySQL, HTML, CSS, JavaScript, FPDF

Challenge

The existing Liquid Art site was in need of revision. Some of the content was out-of-date, and much of the text was difficult to read from Windows computers because the design used a Macintosh standard font not normally found on Windows computers.

Solution

Claero Systems created a new site design with cross-browser and cross-platform formatting. Dreamweaver templates and CSS were used to create a site that is more easily maintainable and which has very consistent formatting. Some FLASH animation was added for visual appeal and more white space was used to give the pages a cleaner look.

Results

The new site is clean and effective. Feedback so far has been all postive.

Challenge

The Trialto Wine Group had an existing Windows 2000 computer network in their Vancouver office. Unfortunately, many of their employees worked from a satellite office in Calgary and from home offices in various cities across western Canada. There was no VPN, firewall, standard virus protection, or regular backups of data.

Solution

Claero performed a network and user audit. The steps which appeared would best improve Trialto's profitability were: 1) allow for contact sharing, sharing of sent and received emails between staff, and streamlining the process for their large number of fax-outs 2) enable remote users to access and leverage contact information, marketing and logistics files, and email and fax resources located in the Vancouver office 3) reduce the risk of data loss by enhancing security and protection systems. Claero Systems proposed a Windows 2000 Small Business Server for collaborative email and fax services, McAfee Virus Suite for two-tiers of virus protection, a Checkpoint Firewall / VPN server allowing remote users to leverage systems in the Vancouver office, and a systemized backup and preventative maintenance schedule.

Results

Since the completion of the installation in January 2002, the Trialto Vancouver network has been stable and uninhibited by any viruses or malicious hackers. Staff constantly use the server in Vancouver for file sharing, and the use of shared contacts and email folders has proven to be even more invaluable to all levels of the company than was initially anticipated. Additional remote staff have been set up using the VPN, and are able to not only use and contribute to all shared contact and email information, but can also use the centralized fax out system as well as re-use data kept on the server so they do not have to re-create marketing and logistics files. And, thanks to the backup and preventative maintenance systems and schedules, not one bit of data has been lost.

Technology Used

Checkpoint Firewall-1/VPN-1 server, Microsoft Small Business Server 2000, Veritas Backup Exec, McAfee Total Virus Defense

Challenge

Trialto was growing. The President who had always taken care of the computers, servers and the network, was spending more time on support than he was on managing the company. Although Trialto wanted to look into new tools to help the company, such as a VPN for remote users, and Exchange server for sharing of contacts and folders, the day to day support was already taking more time than was available.

Solution

Trialto wanted a company to help with the day to day support, but was not willing to trust outsourcing everything immediately. Claero proposed a support contract for much of the support, while still using internal people to help with the support.

Results

Claero implemented the Exchange server and after roughly six months, users had become confident and proficient with shared contacts, folders, and consolidated faxing. There was no question productivity was positively impacted. Claero also performed day to day support on an ongoing basis. Two years after implementation Claero performs all support, with the President happy to be running the company without worrying about any of the support work. Trialto and Claero come up with their IT budget together, and have since implemented a VPN, a very solid backup solution, enabled remote offices and users, a critical web portal for sales analysis, and multiple other projects.

Challenge

Trialto Wine Group was considering an investment in to a company that owned a large web application and they wanted to understand how good the programming and design was.

Solution

Claero Systems reviewed the application and source code and provided feedback and a concise written report on the results.

Results

The Trialto Wine Group was satisfied with the results.