|
Web Site Data Upload and User Management Solutions
|
|
Area of Technology: Automated creation and upload of charts to the web site and subscriber management applications for a currency exchange evaluation company.
|
|
Company Name: FxVol Research Ltd.
|
|
Website URL: http://www.fxvolresearch.com/
|
|
Overview of Business:
|
|
Description of Problem:
|
|
GVC Role: Global Village Consulting Inc. provided all developmental
services for the solutions provided during the project. The initial web site had previously been developed but was not functional. GVC staff worked with FxVol staff to create a solution that would best leverage what already existed. The role included requirements capture and system design, software development and site changes, testing, deployment, and setting up infrastructure elements such as a redundant Internet connection.
|
Project Description: The FxVol web site project was the development of an application which would automatically log in and receive new trading data on an hourly basis. This data would then be recorded into Excel spreadsheets and the corresponding charts; updated, converted
into *.gif files, and automatically uploaded to the web site for viewing by subscribers. A similar desktop application was created for specified charts whose data must be manually entered rather than automatically received. Upon initiation, this second application would also perform the chart updating and uploading functions.
On the web site, some HTML updates and the reorganizing of information were made. An administrative database was created to receive, record,
and manage subscriber registration. Security features were implemented along with workflow features for auto emailing of notices and registrations.
|
Description of Solution: Global Village Consulting Inc. developed a solution that provided a simple, user friendly solution which addressed all the functionality for the web site applications. The solution was developed with the following technology components:
MySQL: The core functionality for the application is a Unix application written in Perl using the Perl DBI module. DBI allowed access to MySQL in an independent manner so the database could easily be switched if necessary. MySQL was used for the database backend.
macs with Ange-ftp: This editor was used in order to save files over an ftp connection as the shell access to the host servers was not possible. This enabled the editing of files without having to upload them every time, saving developer time and client money.
Visual Basic (VBA): VBA was used in the upload applications to interface between the data source (BridgeStation) and data storage (Excel) using a DDE connection. Updated charts are uploaded to the
website on an hourly and daily basis using Windows2000's event scheduler and an ftp program. A freeware tool (Blat) was used to notify the site administrator of any errors via e-mail.
|
|
Project Deliverables:
|
