Skip to Content

HTML Conversion Execs & Focexecs

Introduction

Initially all documentation should be produced in the standard DCF GML format and saved on the FRSDOC2 'D' disk. From here it will be copied and formatted to HTML and filed on the 'A' disk with a filetype of HTML. there are several execs and focexecs to accomplish this task.

Convert Regular Script and Job Descriptions.

This exec will create an HTML file from existing script files that should reside on the FRSDOC2 'D' disk. To accomplish this, follow the steps below:

  1. Make sure the file or group of files exists on the FRSDOC2 'D' disk.
  2. In the filelist type 'FRSHTML' next to the file that you want to convert. This exec goes through the following steps:
    • Accesses the 'Tools' disk
    • Adds HTML commands to create the standard background, buttons and format for FRS and adds current date.
    • Saves all changes in a temporary script file.
    • Executes the 'DCFHTML' exec on the temporary script file.
    • Erases the temporary script file.
  3. Follow instructions in section 'Finishing The Job'
Note: If the boxes created in HTML have data all running together, perform the steps below.
  1. In filelist type 'FIXTABLE' next to the HTML file to be fixed.
To avoid having this problem see the section on 'Helpful Hints'.

Create Tables From The FOCUS Database

Focexes can be used to extract data from a FOCUS database and convert it to an HTML file. We have some unique examples in the focexecs FRSCCDX and FRSJOBSX. When using FRSPROD in the program field (AUTODOC) we have had to put the actual program name in the condition code field. In order to pick up all programs in the database we had to define both fields, table the file twice creating two hold files, and then combine the two hold files into one complete data stream. Most programs will not be this complex. For simple FOCUS reports copy one of the skeleton files 'FRSLIST FOCEXEC A' for a simple list and 'FRSTABLE FOCEXEC A' for a boxed table. These files contain all the define statements that you should need to create a nice HTML FOCUS report.

  1. Look for the xx's and insert your own data.
  2. The FOCUS file D2230F01 (production database) is used in the example but if you are using another database change this name in the DEFINE and TABLE areas of the program.
  3. Run the Focexec that you just created to create the HTML file.
  4. When the HTML file is complete, follow the instructions in the segment 'Finishing the Job'.

Convert Schedules To HTML Tables

There are several schedules in script files on the FRSDOC2 'D' disk are descriptive by their titles (FRSMON (Monday), FRSFRI (Friday) etc.). To create an HTML table from these files follow these steps:

  1. Execute the exec FRSSCHD
  2. Follow the instructions and enter the file name and type of schedule. 
         Example:
         FRSMON Monday
         FRSMNTH Month-End
  3. the exec will do the following:
    • Copy the script file to a temporary data file.
    • Delete unnecessary data from temp file.
    • Create a temporary Master file and Focexec.
    • Run the temp focexec (FRSxxx) to create the HTML.
    • Erase temporary files.
  4. When the HTML file is complete, follow the instructions in the segment 'Finishing the Job'.

Finishing The Job

In order to have the new documents accessed by the network the following steps MUST be taken:

  1. Add the HTML file name to the file WEBSHARE FILELIST A.
  2. Add reference to file in appropriate menus as follows:
    • FRSTECH HTML A - All DOCUCxxx script files. This is mainly for Computer Center use.
    • FRSYSADM HTML A - All DOCSAxxx script files. (System Administration) and all schedules.
    • FRSHTMFA HTML A - All DOCFAxxx script files. (Financial Accounting)
    • FRSHTMAP HTML A - All DOCAPxxx script files. (Accounts Payable)
    • FRSHTMPO HTML A - All DOCPOxxx script files. (Purchasing)
    • FRSHTMFX HTML A - All DOCFXxxx script files. (Fixed Assets)
    • FRSJOBS HTML A - All J9xxxxxx script files. (FRS job descriptions)

Helpful Hints In Creating The Script Files.