Configuring the Default Web Site Properties for Import

Before you can import Web log files into the Data Warehouse, you must configure the Web log file properties to use the World Wide Web Consortium (W3C) log file format. You configure the Web log file properties by using Internet Services Manager.

To configure the default Web site properties for import

  1. Expand Internet Information Services, expand the server on which you unpacked the site, right-click the default Web site, and then click Properties.

  2. On the Web Site tab, in the Default Web Site Properties dialog box, do the following:

    Use this To do this
    Enable Logging Select this check box if you want to enable the log to record Web site activity.
    Active log format Select W3C Extended Log File Format from the drop-down list.
  3. Click Properties.

  4. On the Extended Properties tab, in the Extended Logging Properties dialog box, do the following:

    Select this To import this
    Date The date on which activity occurred on your Web site.
    Time The time the activity occurred.
    Client IP Address The IP address of the client that accessed your server.
    User Name The name of the user who accessed your server.
    Server IP Address The IP address of the server on which the log entry was generated.
    Server Port The port number the client is connected to.
    Method The action the client was trying to perform (for example, open a Web page).
    URI Stem The Uniform Resource Identifier (URI) stem of the resource accessed, for example, an HTML page.
    URI Query The query, if any, that the client was trying to perform. For example, a search string for which a client was seeking a match.
    HTTP Status The status of the action, in HTTP terms.
    Win32 Status The status of the action, in terms used by Microsoft Windows.
    Bytes Sent The number of bytes sent by the server.
    Bytes Received The number of bytes received by the server.
    User Agent The browser used on the client.
    Cookie The content of the cookie sent or received.
    Referrer The site that directed the user to the current site.

    Ee785005.important(en-US,CS.20).gif Important

    • You must select Client IP address, URI stem, and Time for Web log files to be imported correctly. Include the Date property to ensure accuracy in the reporting of dates. For information about setting Web server properties, see Configuring a Web Server.
    • Do not select Use local time for file naming and rollover. The Data Warehouse requires that the log file names are in Greenwich Mean Time (GMT). Setting this option could cause some log files to not be imported.
  5. Click OK to exit the Extended Logging Properties dialog box, and then click OK to exit the Default Web Site Properties dialog box.

The Web log file properties are configured in the W3C log file format.

After you have configured the default Web site properties for import into the Data Warehouse, you will need to synchronize the IIS properties in Commerce Server Manager with the properties in the IIS metabase and the Data Warehouse. For instructions for synchronizing the IIS properties with the Data Warehouse, see Running the Configuration Synchronization DTS Task.

See Also

Troubleshooting the Data Warehouse Import Process

Copyright © 2005 Microsoft Corporation.
All rights reserved.