Customize And Personalize (CAP)

CAP Database Operations


Related material

  • CaP Introduction
  • CaP Run Time Database Operations documentation
  • CaP Painter documentation and tutorial

    Overview

    The CaP Database Manager has three basic functions in additional to the Adminstrative functions.

    Basic Operations

    Once the isntallation steps below have been completed, the steps to Customize and Personalize your .ASP forms are very simple. It is recommeneded that if possible you turn off or customize your anti-virus software. Most anti-virus software monitors changes to ASP and HTM files and will slow down the CaP process significantly.

  • First select the System Folder name you wish to work in.

    Starting a Session and Creating or Maintaining the Run Time Database

    If this is the first installation of the CaP product, you will need to create a new CaP run time database after starting the CaP run time session.

  • File, Database Utilities, Create New Database, select CAPDB, press OK to continue.

    If you have previously installed the CaP product you should un-install and re-install using the latest Install Shield self extracting setup software from IEG. After installing the CaP product you should perform a Run Time Database reorganization by starting the CaP run time and then doing:

  • File, Database Utilities, Reorganize Existing database, Modified Structures only ..., select CAPDB, press OK to continue.

    Initial Setup

    If this is the first installation of the CaP product, you will need to define the location of Internet Explorer. You may wish to perform a search on your local drives to find "IEXPLORE.EXE". The location of this program is typically found in the folder "c:\program files\Internet Explorer\". A browse facility is available to navigate to the correct location.

    The next step will be to define system or application folder names. These folder names should match the actual folders that you defined under the CaP installation preparation. The names of these folders should be associated with the applications you will be working with.

    Here are some examples: { FINN , SISDB, TOMATO }. Note that other names may be set up under the System/Application folder. These sub-folders { POWER, BASIC, INTERNAL, EXTERNAL, ENGLISH } are not defined in the CaP Table of System names.

    D:\IEG\CAP\FINN\BASIC\menu.asp
    D:\IEG\CAP\FINN\POWER\menu.asp
    D:\IEG\CAP\FINN\BASIC\FINNlib.css
    D:\IEG\CAP\FINN\POWER\FINNlib.css
    
    C:\IEG\CAP\SISDB\INTERNAL\logon.asp
    C:\IEG\CAP\SISDB\EXTERNAL\webon.asp
    
    C:\IEG\CAP\TOMATO\menu.asp
    

    For each System Folder two deploy paths are available. One for the Test environment and the other for the Production Environment. If you wish to able to deploy these forms, the respective Path strings should contain the proper path name. If you are deploying across a LAN, you should use mapped drive letters to specify the correct location. If you have sub-folders, those same subfolders will be appended to the path string.

    For example if you have a deploy path of "M:\FINN\POWER\*.asp", the path in the System folder would be "M:\FINN\". Since POWER is a sub-folder under the CaP System Folder it will be automatically appened to FINN.

    It is recommeneded to note your naming convention of the deployed environment and map your folder and sub-folder names under CaP to be the same.

    One Time Implementation.

    To implement changes made by the CaP product a function will need to be added to the IEGLIB.JS file. This function is at the end of a file named CAPJS.JS and is named "ApplyCAPChanges". Copy this function into the ieglib.js file if you plan on deploying a CAP customized ASP form.

    Copy the new .asp files from <Cap Installation directory>/<system>/<language>/NEW to the web server.