User Tools

Site Tools


Introduction | Session 1 | Session 2 | Session 3 | Session 4 | Session 5 | Session 6 | Session 7 | Session 8

Stock Screener Tool (Database Tutorial)

This tutorial should take approximately 2 hours to complete.

Practical Sessions

  • This tutorial is broken down into eight practical sessions,
    • Session 1, EASA Server Configuration → 20 min
    • Session 2, Getting Started with the EASAP → 10 min
    • Session 3, Building the User Interface → 20 min
    • Session 4, Processing Object Data → 10 min
    • Session 5, Processing Events and Performing Actions → 30 min
    • Session 6, Putting Results in an Excel Spreadsheet → 10 min
    • Session 7, Generating a Report → 15 min
    • Session 8, Testing and Publishing the EASAP → 10 min

Scenario

An organization maintains one or more databases that contain information that a User frequently filters and queries; the User will eventually create and save a report.

Suppose have an additional requirement for a dedicated web application that allows an authorized User access from a phone, laptop or tablet in any location.

We further specify that a User be able to export his or her results to an existing reporting tool, in this example we use a Microsoft® Excel spreadsheet.

  • Our web application must therefore,
    • Automate the process of database interaction
    • Ensure error-free usage
    • Enable a User the ability to share results with his or her colleagues

Tutorial Summary

Let's develop an EASA application, or EASAP, that interacts with a database and a Microsoft® Excel spreadsheet.

The Stock Screening Tool EASAP allows a User to search a database of stocks.

A snapshot of the completed EASAP interface is shown below,

The EASAP user interface will include filters and queries to let a User refine a stock search within the database.

A User may store the results of a search in an Excel report.

This tutorial provides step-by-step instructions to Author the EASAP from start to finish.

As we build the application, think about how this could be applied to databases and processes which exist within your organization.

This tutorial is designed for use with an EASA Server that is running Windows. For a linux EASA Server contact our support personnel at support@easasoftware.com to receive a Linux version of the tutorial.


Tutorial Files

Below is a brief description of each file.

File Name Description
Results.xls MS Excel spreadsheet in which to store search results generated
Stock.jpg Selection image or “thumbnail” for the EASAP
report_body.html HTML template HTML for an EASAP generated report
EASAlogo.jpg Banner image located within report_body.html
read_StockData.txt Text file containing a SQL query to read data from the database

We are ready to begin Session 1.

Introduction | Session 1 | Session 2 | Session 3 | Session 4 | Session 5 | Session 6 | Session 7 | Session 8


Page Tools