This video, geared towards filePro developers rather than end-users, is
designed to show you how fast and easy it is to integrate filePro with the
web.
Much can be added in terms of funtionality using JavaScript, advanced
techniques like AJAX, etc. This video focuses on the basic concepts behind
using OneGate to power the web side of your filePro applications.
Get the Windows Media 9 Video! -- or -- Get the Apple QuickTime Video!
Video Outline and Time Indices
- I. Introduction (0:10)
- II. Installation of Onegate (0:56)
- A. Unpack the tar file
- B. Run the install script and supply when asked:
- 1. Location of perl
- 2. Location of your working OneGate directory
- 3. Location of OneGate program (cgi directory on webserver)
- 4. Location of OneGate tools
- 5. If you need .pl suffix (yes for windows, no for unix)
- III. Create Form using HTML in document directory on webserver (3:47)
- A. In the opening form tag, set the action to the url of the OneGate program
- B. Set a hidden field "onegate_set" to the name of the program set (application) that OneGate will be running
- C. Add fields to the form for the rest of the data that you need to pass into filePro
- IV. Configuration of Onegate using OGConfig (6:10)
- A. Add entry to the list allowed program sets
- B. Define environment variables (Always define TERM when using filePro)
- C. Configure the Program Set
- 1. Choose the Program Set
- 2. Define allowed fields
- 3. Define the command set (the command to run the filePro process) (redirect output and standard error to /dev/null in your command)
- V. Set up the Filepro Processing (11:22)
- A. Declare variables that will store input from the web form and be used in writing the output file
- B. Get the value of the output file (ONEGATE_OUTFILE) using getenv (this is where OneGate will expect the results to go)
- C. Declare variable for file operations
- D. Declare the parser result for error checking
- E. Call the OneGate XML parser (that populates a table called "onegate") and check for success/failure
- F. Get the value of the input file (ONEGATE_INFILE) (this will be field 1 of the records that are associated with this transaction)
- G. Lookup to the table created by OneGate to get your input data
- H. Use a loop (thru all fields) to get the cgi data
- 1. Error checking
- 2. Set variables equal to the cgi data
- 3. Delete the record in the onegate table
- 4. Check for the next field
- I. Write the output file (in HTML)
- 1. Open the output file for writing
- 2. Write static html where needed
- 3. Do whatever filePro processing you want based on the input from the web form
- 4. Write dynamic html that includes the results of the processing
- 5. Close the output file
- 6. End processing
- VI. Quick look at the database used in the demo (24:25)
- VII. Watch it all work in the web browser (25:20)
- VIII. Conclusion (26:29)