Back to Table of Contents

Documenting Files

Comparing "Sessions"

Exporting Web Pages

Testing On A Local Computer



Documenting Files

ClickStats Pro documents all the currently open files. Open the file(s) you want to document with full password access, then click the document button. If the file(s) that are currently open have related files, you will be asked if you want to document the related file(s) as well. We recommend you open the related files manually with full password access if your files are password protected.

Next, you'll see a dialog that asks you to name the "Session." A "Session" is a snapshot of a particular database at a particular point in time (i.e. the point at which you document it). The default is the current date and time, but you can change this to be anything that you want (up to 64,000 characters). Then click "OK."

Documenting a database can take between one minute (or less) to an hour (or more) depending on the number of fields, layouts and value lists you have and the speed of your processor. Most "average" files (100 fields, 10 layouts) should take about 3 minutes or so.

After the Documenting Process is Finished

Once ClickStats Pro has finished documenting your file(s) you will see the "Main" screen with the last file documented currently selected. You can then click on any field to show the layouts and relationships (indicated by the word "Key" to the right of the field name) that the selected field is used in.

Click on any layout in the list next to the field list to view a list of all fields used on that layout, as well as the value list (if any) that is used by any field on the layout.

Click on any value list to see a list of values for that particular value list.

If you have a 17 inch or larger monitor, you can see all of the attributes at one time. If you are using a monitor that is smaller than 17 inches (or you're using a lower resolution) then ClickStats Pro will navigate to the appropriate tabbed section automatically.

See the next section Documenting Files for more info.

 

Comparing "Sessions"

In order to use ClickStats Pro's comparison feature, you will need to have documented more than one file or more than one session of the same file.

If you do not have two or more databases documented (or two or more sessions of the same database), then do so before you continue this section.

Click the "Compare" button. You will see a dialog that prompts you to choose a database to compare (top portal), and a database to compare it against (bottom portal). Choose a file from the top portal, and a different file from the bottom portal and click "OK."

You will see the progress of the comparison in a dialog. Once the comparison is completed, you'll see an on-screen report with the similarities and differences in the two files (or sessions) you chose.

IMPORTANT NOTE: Because FileMaker has a set number of pages that it can print, you might not see all of the results. For this reason, we have a "Export To HTML" button at the top of the screen. You can export the report to HTML and open it in your favorite browser. The comparison data is NOT saved unless you export to a text file or HTML - it is re-generated every time you run the comparison feature.

See the next section Documenting Files for more info.

 

Exporting Web Pages

The first step in creating your own HTML files to access your database is to choose a file and a layout. From the "Main" tab (17 inch or larger monitor users) or the "File/Fields" tab (14 inch monitor users) choose the file you want to create HTML files for.

For 17 inch users: Click the layout you want for the "Add/Edit/Update" layout.

For 14 inch users: Click the "Layouts/Value Lists/Scripts" tab, then click the layout you want for the "Add/Edit/Update" layout.

Next, click the "Web Export" tab. You will see the layout for choosing the various options for exporting your HTML pages. For this example, make sure the "Add/Edit/Update" radio button is selected then click the "Continue..." button in the lower right side of the screen. All of the various options are explained in greater detail in the Web Export Section of this documentation.

When prompted, click "OK." You will see that ClickStats Pro will export various files for you automatically.

Next, click the "Search" radio button, and click the "Continue..." button in the lower right side of the screen. You will then see a dialog that contains various options. For this example, simply click the "Continue" button. When asked whether you want to automatically create the "hitlist" click "Yes."

Once all the files have been exported into the "output" folder, you will be asked if you want ClickStats Pro to automatically create a new solution for you. If you click "Yes", you will be prompted to enter your IP address, and the name of the FOLDER for the new solution. Once that's done, you can either just generate the solution or generate the solution and have it open in your browser.

NOTE: to preview your solution in your browser: you MUST have an IP address, you MUST open the database you documented, you MUST "turn on" the Web Companion checkbox in the file you documented, you MUST have your networking protocol set to TCP/IP. Also, if you're on the Mac OS platform, you MUST have configured your Internet Config application to recognize your browser for the "http" command. See the Web Export Section for more information.

If you chose NOT to preview your solution, then you need to make all the necessary TCP/IP network changes (as described above) and you'll need to create a new directory (or folder) inside the "Web" folder that's inside the "FileMaker Pro 4.0" folder, and move all of the files from the "output" folder into the newly created directory inside the Web directory. You'll also need to copy the entire "images" directory into your new folder.

You can then open your file in FileMaker, and in your browser type the URL:

http://yourIPaddress/yourFolderName/default.htm

Where "yourIPaddress" is the server, your domain, or your local IP address, and "yourFolderName" is the new directory/folder you created in the "Web" folder.

Testing On A Local Computer

Macintosh:

For MacTCP:

Open the MacTCP control panel and assign the web server an IP address of 192.168.0.2. Click the "More" button, and make sure that it is set to Obtain Address Manually, that the IP Address is Class C, that the Gateway Address is 0.0.0.0, and that the fields in the Domain Name Server Information box are blank. If you do have a router address and are using a local Domain Name Server, you can enter this information instead.

  • If you are using a local AppleTalk network or a single computer, open the Chooser and make sure AppleTalk is Active. Next, open the Network control panel and select LocalTalk. Open the MacTCP control panel again and select the LocalTalk icon, then verify all your changes and restart the computer for them to take effect.
  • If you are using an Ethernet network, you can select EtherTalk in the Network control panel, and Ethernet in the MacTCP control panel instead.

For Open Transport:

Open the TCP/IP control panel, and assign the web server an IP address of 192.168.0.2.

  • If you are using a local AppleTalk network or a single computer, set Connect via: to AppleTalk (MacIP), Configure: to Manually, then click the "Select Zone" button and select the current AppleTalk zone. All other fields should be blank, unless you are using a router or Domain Name Server for your local network.
  • If you are using an Ethernet network, you can set Connect via: to Ethernet, Configure: to Manually, and enter a Subnet mask of 255.255.255.0. Again, all other fields should be blank unless you are using a router or Domain Name Server for your local network.
  • Any client computers should be configured to use the same connection method (LocalTalk/AppleTalk or Ethernet), but should have different IP addresses, higher than the server, such as 192.168.0.3 or 192.168.0.4 (you can also use 192.0.1.2 for the server and 192.0.1.3 and up for clients, if you like).

You can also see this info with pictures at: http://arpp.carleton.ca/mac/question/network.html

Windows 95/NT:

TCP/IP Network Settings

For single computer users:

  • Click the "Start" button and chose "Control Panels" from the "Settings" menu.
  • Double click on the "Network" icon.
  • From the listing of network components installed, choose the one for TCP/IP and click the "Properties" button.
  • From the "IP Address" tab, check the "Specify an IP address" and type 192.1.2.2 in the "IP Address"
  • Enter 255.255.255.0 for the "Subnet Mask"
  • Click "OK", and click "OK" again to close the window

For Network Users

Contact your network administrator to ask them what the IP address is of your computer. If you don't have one, you can follow the directions above.

Browser Settings

For Microsoft Internet Explorer:

  • Choose "Options" from the "View" menu.
  • Click the "Connection" tab
  • UNCHECK the "Connect to the Internet as needed" under the "Dialing" section.
  • Check the checkbox "Connect through a proxy server" and click the "Settings..." button.
  • In the space next to HTTP: type 192.1.2.2 and leave the "port" space blank.
  • Click "OK", Click "Apply" then click "OK" to close the Options window.
  • NOTE: When you want to use your dial-in access again, simply UNCHECK the "Connect through a proxy server" checkbox and CHECK the "Connect to the Internet as needed" checkbox.

For Netscape Navigator:

  • No changes to the preferences are necessary.

 

Previous: Installation Next: Documenting Files

Go To Table of Contents

 

Revision 1: October 15, 1997