Index page
Database Tables

txt\dbf.txt
DBF.TXT
dbf|right||Data Bases

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


txt\dbf.lst

txt\dbf-0.txt
dbf|right||Data Bases

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
objectName|frame|dbf1:key1,dbf2:key2|Title
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.


txt\dbf-1.txt
Comma Delimited Files
It is also possible to trigger a database like function and build the HTML tables directly from a comma delimited file.

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:

CsvList=XLS,MDB
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.

DbfIntList=XLS
Specifies which files are to become tables in within the document as in the case of dbf\dbf-xls.csv

DbfExtList=DBF,MDB
Specifies which files are to become external documants linked to the parent page as in the case of dbf\dbf-long.dbf

DbfLinkList=HTM,GIF,JPG
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.


txt\dbf-2.lst

dbf\dbf-long.dbf
  • Database File: dbf-long 100 200 300 400 500

  • dbf\dbf-xls.csv
    dbf-xls
    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 -

    dbf\dbfshort.dbf
  • Database File: dbfshort

  • Files Referenced for dbf
  • c:\carthtml\demodata\TXT\DBF.TXT
  • c:\carthtml\demodata\TXT\DBF.LST
  • c:\carthtml\demodata\TXT\DBF-0.TXT
  • c:\carthtml\demodata\TXT\DBF-1.TXT
  • c:\carthtml\demodata\TXT\DBF-2.LST
  • c:\carthtml\demodata\DBF\DBF-LONG.DBF
  • c:\carthtml\demodata\DBF\dbf-xls.CSV
  • c:\carthtml\demodata\DBF\dbfshort.DBF


  • Up Index Cover

    Inquiries to: cart@nickerson.icomos.org
    Generated Tue Nov 09 08:55:17 1999 by: CART Computer Aided Recording Tools
    [Compiled: Tue Nov 09 08:43:43 1999(vC++)]