DB Export Help

Script Description

The DB Export script takes the records stored in a database table and places them into a local dynamic web page with accompanying JavaScript code to allow the retrieval of the records on devices without the ability to access the database.

Usage

To run the script, configure the settings, then double–click the script or run it from the command line.

Notes

• Although the script was written to work with Microsoft Access 2002, it should work with other database programs such as MySQL.
• All of the user-configurable settings are in the main script file.
• The script should handle spaces in table names.
• If a column contains both digits and other characters, the column is sorted alphabetically ("a" comes before "b", " 100" comes before "30", etc.)

Settings

Database Provider

This setting specifies the program that handles the database requests. Unless you are using a program other than Microsoft Access, you should be able to leave this setting at its default value. This setting cannot be blank.

Database File Directory

The directory that contains the database file. If the database is in a different directory, the the path must either be absolute like C:\path\to\directory, or relative like ..\to\directory. If left blank, the script will assume that the database is in the same directory as itself.

Database File Name

This setting controls the database file name. The file name must be in the specified directory, and must be a valid database file for your provider program. This setting cannot be blank.

Database Table Name

This setting controls which table in the database will be searched. A database may contain more than one table, but only one table at a time may be exported by this script. To export multiple tables, run the script on each table, setting the table name for each table. This setting cannot be blank.

Output File Directory

This setting controls the directory in which the output file will be created. The directory must exist. The directory may be specified as either an absolute or relative path. If this setting is left empty, the output file is placed in the same directory as the script.

Output File Name

This setting controls the name of the output file. The name must be a valid file name. The script will overwrite an existing file without warning if you specify the name of an existing file. This setting cannot be blank.

Disclaimer

This software is provided without a warranty of any kind. The author of this code takes no responsibility for any problems caused by its use. Use this script at your own risk.