Importing Web Log File Data

  • Article

You use the Web server log import task to import Web log file data from your site. You determine the import frequency for the data by analyzing traffic at your site. The more traffic your Web site has, the more frequently you should import Web log file data.

You can import log files from Web sites that are not running Internet Information Services (IIS) 5.0 and do not include Commerce Server components. For more information about adding applications and Web servers that do not use Commerce Server components, see Adding a Non-Commerce Application and Web Server.

Before you import Web log file data, you must synchronize your site configuration with the Data Warehouse by executing the Configuration synchronization task. After you import Web log file data, you must run the Report preparation task, which organizes the imported data into designated online analytical processing (OLAP) cubes.

To import Web log files into your Data Warehouse

  1. Expand Microsoft SQL Server, expand SQL Server Group, and then expand the server on which your Data Warehouse is installed.

  2. Right-click Data Transformation Services, and then click New Package.

    Alternatively, if you are changing an existing package, right-click Data Transformation Services, click All Tasks, and then select Open Package. Select the package you want to change, and then click Open.

  3. On the Task menu, click Web server log import (Commerce Server).

  4. In the Import Web Server Logs dialog box, do the following:

    Use this To do this
    Description Type a description for the import task.
    Site name Select from the drop-down list the name of the Web site that contains the Web server log you are importing.
    Application Click to sort the list of log files by application.
    Machine (Computer) Click to sort the list of log files by computer.
    IIS Web Site Click to sort the list of log files by IIS Web site.
    Log File Path Click to sort the list of log files by log file path.
    Log file path Type the path of the Web log file you want to import, or click the ellipsis [...] button to browse for the log file path.
    View Log Files Click to open the Web Server Log Files dialog box, select the Web log files you want to import from the Web Server Log Files list, and then click OK to return to the Import Web Server Logs dialog box.
    Import all log files since last import Select this option to specify that all log files created since the last import will be imported.
    Import log files based on date/time range Select this option to specify that only log files created between the Start date/time and End date/time will be imported.
    Start date/time Type the date and time for the beginning of the range from which log files will be imported. This option is available only if you select the Import log files based on date/time range option.
    End date/time Type the date and time for the end of the range from which log files will be imported. This option is available only if you select the Import log files based on date/time range option.

  5. Click OK.

  6. On the Package menu, click Execute.

    The Executing Package dialog box appears, showing the progress of your import. When the import process is complete, the Package Execution Results dialog box informs you it completed successfully.

Ee810517.note(en-US,CS.10).gif Note

  - If the Web log file import process fails, run the **Data deletion** task to delete the data associated with that Web log file, and then run the **Report preparation** task to refresh the OLAP cubes.
  1. Click OK, and then click Done.

The data from the Web log file is imported into the Data Warehouse. You must run the Report preparation task to organize the imported data into the designated OLAP cubes.

Ee810517.note(en-US,CS.10).gif Notes

  • You can add multiple Data Transformation Services (DTS) tasks to a package, add sequencing or workflow information, and then run all the tasks in the package.

  • You can refine your import process by setting a variety of advanced Web log file import properties. For information about configuring Web log file import properties, see Configuring Web Log File Import Properties. For information about setting Web server properties, see Configuring a Web Server.

See Also

Data Warehouse Components

Configuring Web Log File Import Properties

Synchronizing Site Configuration with the Data Warehouse

Preparing to Create Reports

Deleting Data from the Data Warehouse


All rights reserved.