Share via


How to Configure 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 Information Services (IIS) Manager.

To configure the default Web site properties for import

  1. Click Start, point to Programs, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.

  2. In the IIS Manager console, in the left pane, expand Internet Information Services, expand the server on which you unpacked the site, right-click the default Web site, and then click Properties.

  3. In the Default Web Site Properties dialog box, on the Web Site tab, in the Enable logging section, 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.

  4. Click Properties.

  5. In the Logging Properties dialog box, on the Advanced tab, do the following:

    Use this

    To import this

    Date

    The date on which activity occurred on the Web site.

    Time

    The time the activity occurred.

    Client IP Address

    The IP address of the client that accessed the server.

    User Name

    The name of the user who accessed the server.

    Service Name

    The Internet service and instance number that was accessed by a client.

    Server Name

    The name of the server on which the log entry was generated.

    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.

    Protocol Status

    The status of the action, in HTTP or FTP terms.

    Protocol Substatus

    The additional status of the action, in HTTP or FTP 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.

    Time Taken

    The length of time (in milliseconds) the action took to finish.

    Protocol Version

    The protocol (HTTP, FTP) version used by the client. For HTTP, this is either HTTP 1.0 or HTTP 1.1.

    Host

    The content of the host header.

    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.

    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 how to set Web server properties, see How to Configure 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 Coordinated Universal Time, or Greenwich Mean Time (GMT). Setting this option could cause some log files not to be imported.

  6. In the Logging Properties dialog box, click OK.

  7. In the Default Web Site Properties dialog box, click OK.

See Also

Other Resources

Importing Data into the Data Warehouse

Running the DTS Tasks

Managing the Data Warehouse

Commerce Server Operations