|
|
-
Equimax uses FirstBase for quite a few different tasks,
each one described below: The Equimax Client System,
The eStore, and the Rotating Information System.
-
Equimax Client System
Equimax
and FirstBase Software worked together to create the Equimax Client
System (ECS), a complete database-to-web and web-to-database
application that dynamically generates complete or regional lists of
job candidates to authenticated Equimax users.
The source database lives on an NT platform. Once per day,
data is sent to firstbasesoftware.com via some standard method
(FTP, HTTP, ssh/scp, SMTP/email, etc).
An automatic process detects the new incoming data, parses it,
and builds fresh databases.
The web interface is then used by Equimax subscribers to
access real time information about job candidates.
Searches can be limited to particular regions, and selected candidates
can be placed on a private list for later viewing.
In addition, modifications to online information can be
packaged as CSV files and sent back to the Equimax computers
for direct downloading into their master database.
These database to web and web to database tasks are accomplished using the
macro
programming language from FirstBase. The tool dbmacro
is used both to parse incoming data into directly loadable records,
and as the CGI mechanism that generates the dynamic candidate lists.
-
The Equimax eStore
Equimax and FirstBase Software designed and implemented a custom
eStore application used for commercial products available from
Equimax.
The eStore application uses a front end
of static web pages, listing various commercial products,
with a flexible back end of context generated web forms.
Each of the generated forms is based on user selections,
and all fields of data are checked for validity.
Purchase the FirstBase Software eStore application $995.
Shoppers are notified of all taxes and shipping costs,
and can modify their order as much as needed before finalizing
their selections.
And, these context sensitive web forms, generated on the fly,
do not use cookies anywhere, for anything.
After a secure order is verified (twice), then a PGP encrypted
email attachment with a CSV (database loadable) file is
sent to Equimax and the file is loaded directly into their
legacy order entry system.
This custom estore application
and the seamless web to database communication of completed
orders is accomplished using
dbmacro.
-
Rotating Information System
The Rotating Information System (RIS) uses a set
of information records stored in a standard FirstBase database and
periodically
generates a new paragraph, record, or quote, for inclusion into a web page.
Purchase RIS for $39.
This is a very simple use of a web page connected to a database.
The Tips of the Week on
equimax
are rotated every Monday from a FirstBase database
by a cron job that executes this
macro source code.
As another example, the
complete set of quotes
is generated on-the-fly by this
macro source code.
This application demonstrates two methods of using FirstBase
database-to-web connectivity:
- static pages are generated (once per week) using
a single database record and
- a page using all of the quotes in the
database is generated on demand.
Each of these tasks is easily done using FirstBase tools.
© Copyright 1996-2008 FirstBase Software, Inc.
|
