Database files are handled in two stages. First, if a .DBF file is encountered(???.DBF), a small program is written which will create two files, a header file(???.HDF) and a coma delimited file(???.CDF). When the whole data set has been processed you
If you are not running your own internet server (and those who are are not the expected clientele of this package) you will find it difficult to integrate Database tables into your HTML. Our approach is to turn these files into HTML tables which severly limits their flexibility but makes them accessible to any browser either stand-alone or over the internet.
There are two situations when this is invoked.
A database file conforms to the naming of an object or article
In this case an HTML table is created of the entire database. It will be called [fileName].HTM and it will be presented as a link in the page for that object.
If the file is a long one it will be chopped up into 100 record slices (so as not to become interminable to load) and each slice will appear as a link in the parent document.
A database file is specified in the configuration file ".CH2"
Not Yet Implemented
Such a record will take the following form
In such a case an SQL query will be sent to the database in the form of select * from [dbfFile] where [key] is like %[objectName] for each database:key set presented and the resulting HTML table appended to the parent document.
Database files are handled in two stages. First, if a .DBF file is encountered(???.DBF), a small program is written which will create two files, a header file(???.HDF) and a coma delimited file(???.CDF). When the whole data set has been processed you will be asked if you want to run these programs.
When you answer yes to this dbase3 will be called with the temporary programs and the .CDF and .HDF files will be created at which time you will be asked if you want to turn them into HTML tables. Answering yes to this will run the entire program again except that this time, the comma delimited files will be processed instead of the .DBF files and you will have a complete data set in HTML.
.CSV files (the product of Microsoft products like Excel and Access) are first processed into the .CDF format and then turned into tables as above.
You can create a comma delimited file from any database program or Spread sheet by using the "Save As" function and the resulting file will be turned into an HTML table with a link to the parent document.
Which File Extensions you want turned into tables is specified in the configuration file .CH1 entries below:
Specifies that these file types will be turned into .CSV types. At present this software does not make the conversion but it will warn you if the source file is more than 5 minutes older than its .CSV equivalent. To create a link to such files use the .CSV filename as shown below.
Specifies which files are to become tables in within the document as in the case of dbf\dbf-xls.csv
Specifies which files are to become external documants linked to the parent page as in the case of dbf\dbf-long.dbf
Specifies which other files will be tested as possible links to database values. If this entry is not blank (or does not start with a "/,") each value in a table will be compared to files of the same name with the extensions in the list. The result is as you see it in dbf\dbfshort.dbf This can be a lengthy process to no advantage if these links do not exist so think about the values here. Those in the example above are the most common possibilities though DWF would also work if using the WHIP plugin.
File extensions of .DBF .CDF and .HDF are reserved for the database conversion functions.
|EXT||PAGE||COMMENTS||TMP||NOHTML||-||???||TEXT||Unknown extensions read into HTML as PREformated||FALSE||FALSE||-||BAK||-||Backup files from the text editor||TRUE||TRUE||-||BAT||-||TEMP*.BAT copies or converts the reference files||TRUE||TRUE||-||BIB||TEXT||A Blbliography or reference file||FALSE||FALSE||-||CAP||IMAG||Captions for images||FALSE||TRUE||-||CDF||DBF||Comma delimited wannabe from Microsoft||FALSE||FALSE||-||CDF||FILE||Will be converted to an HTML table||TRUE||TRUE||-||CH1||USIN||Primary configuration file||FALSE||TRUE||-||CH2||USIN||Configuration file for multi page data sets||FALSE||TRUE||-||CSV||DBF||Comma delimited wannabe from Microsoft||FALSE||FALSE||-||DBF||FILE||Will be converted to cdf and then to a table||FALSE||FALSE||-||DWF||DWF||Drawing Web Format (for CAD needs PLUG-IN)||FALSE||FALSE||-||EN*||TEXT||Treated the same as text for the moment||FALSE||FALSE||-||ENC||TEXT||ENglish Captions||FALSE||TRUE||-||ENF||TEXT||ENglish Footnotes||FALSE||FALSE||-||ENL||TEXT||ENglish Lists||FALSE||FALSE||-||ES*||TEXT||Spanish language files to become HTML||FALSE||FALSE||-||ESC||TEXT||Spanish Captions||FALSE||FALSE||-||ESF||TEXT||Spanish Footnotes||FALSE||FALSE||-||ESL||TEXT||Spanish Lists||FALSE||FALSE||-||FR*||TEXT||FRench language files to become HTML||FALSE||FALSE||-||FRC||TEXT||FRench Caption||FALSE||TRUE||-||FRL||TEXT||FRench List||FALSE||FALSE||-||FRF||TEXT||FRench FootNotes||FALSE||FALSE||-||FTN||TEXT||Foot notes||FALSE||FALSE||-||GIF||IMAG||Image file known to HTTP||FALSE||FALSE||-||HDF||DBF||Temporary Header file created from a DBF file||TRUE||TRUE||-||HTM||HTM||HTML files become links in the main document||FALSE||FALSE||-||JPG||IMAG||Image file known to HTTP||FALSE||FALSE||-||LOG||ERROR||CARTHTML.LOG records errors for debugging||TRUE||TRUE||-||LST||TEXT||Becomes a bullet list||FALSE||FALSE||-||PRG||-||TEMP.PRG is a temporary file generated for dbase3||TRUE||TRUE||-||TIF||IMAG||Image file unknown to HTTP (converted to GIF)||FALSE||FALSE||-||TMP||-||Temporary files erased aling with temp*.*||TRUE||TRUE||-||TXT||TEXT||Will be converted to HTML (as will HTMLlist)||FALSE||FALSE||-|