Database Generator



This new and improved "shortcut" script engine takes the data straight from your spreadsheet (ClarisWorks®, AppleWorks®, Microsoft Excel® or other similar format) and converts it into a searchable JavaScript Database for your website. This is a super tool for the web developer offering his/her clients that little bit extra.

The first step is to prepare your spread sheet for this script engine:

  • Titles - If you want your searchable database to have titles for the various columns, simply make sure that Row 1of your spreadsheet has a title typed for each column, and that you have clicked the radio button below that specifies this row for titles.
  • HTML in your spread sheet:
    • URL's - If you want your searchable database to have a link in a given column, simply make sure that the column contains your entire link like this: <A HREF=http://www.somedomain.com TARGET=_blank>A link to some domain</A> (You may use the full URL or a root-relative link)
    • Images - If you want your searchable database to display an image in a returned result, simply make sure that the column contains your entire image root-relative like this: <IMG SRC=images/imagename.gif WIDTH=30 HEIGHT=50 BORDER=1>. Caution: Watch the sizes you specify for images - remember that the search results will be displaying text as well. "Floating" following text may be done.
  • Forbidden characters: You may use any characters you wish in your spreadsheet cells (ISO-8859-1). However, this script engine uses the following doublets as delimiters, so avoid the following double characters: double tildes (~~), double accents acute (``), and double asterisks (**).

Once your source spreadsheet is ready, you mark and copy the rows and columns from your spreadsheet (Claris Works®, AppleWorks® or Microsoft Excel® or other similar format) into the window below.

Copying data from your spreadsheet: Click once in Row 1, Column A. Then move to the last row of data and to the right to the last column of data, and, holding the shift key down, click in that cell. Your spreadsheet data will now be highlighted. Type control-c or apple-c. Then click in the window below and type control-v or apple-v)

A click of the button and you will have a searchable database using your own data, ready to load online.



Client's Website Title (optional)

Your Name (optional):

Your Copyright Info (optional):

Your Database Title (optional):

I have no Titles in Row 1             I have Titles in Row 1

After your script is returned, you may test it using the "Test It" button below the window.

Important: resulting HTML file must be named "index.html", or file name in function doSrchCk in script must reflect the different name you assign.


© Copyright 1994-2008 John H. and Erika E. Keyes