Configuring Web Log Files 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 using Internet Services Manager.

To configure the default Web site properties for import

To specify the location of a log file to the Data Warehouse

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 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.

Ee798348.important(en-US,CS.10).gif Important

  - You must select **Client IP address**, **URI stem**, and **Time** in order 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](ee811427\(v=cs.10\).md).
  1. 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.

To specify the location of a log file to the Data Warehouse

  1. Expand Internet Information Services, expand the server name, right-click Default Web Site, and then click Properties.

  2. In the Default Web Site Properties dialog box, click Properties.

  3. In the Extended Logging Properties dialog box, on the General Properties tab, type the path of the log file directory in the Log file directory box.

  4. Click OK to exit the Log file Properties dialog box, and then click OK to exit the Default Web Site Properties dialog box.

The Data Warehouse can find the log file for your Web site. 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 Synchronizing Site Configuration with the Data Warehouse.

See Also

Configuring a Web Server

Configuring an Application

Adding a Non-Commerce Application and Web Server

Synchronizing Site Configuration with the Data Warehouse


All rights reserved.