An
update is available for Microsoft
Commerce Server 2007 and for Microsoft Commerce Server 2009.
In
Commerce Server 2007 and in Commerce Server 2009, you can import
Web
server log files
into the Commerce Server data warehouse. Web
server log files
contain user-agent
strings. You can use the
csdw_makeuseragentdata
stored procedure together with the user-agent reference data that
is in the data warehouse database to generate a report about operating
system
versions,
browsers, browser versions,
and search engine crawlers.
This
update adds the
latest information about operating systems, browsers, and search engines
to the user-agent reference data. Additionally, the update updates the stored procedure to
generate accurate site
user reporting.
This update affects
the following user-agent reference tables:
- UserAgentBrowserCategory
- UserAgentOperatingSystem
- UserAgentPortal
- UserAgentSecurity
- UserAgentVersion
Additionally, this update updates the
csdw_makeuseragentdata
stored
procedure
that uses the user-agent reference data
to populate tables and cubes that are
in the site user reporting.
Update information
Prerequisites
You must have Commerce Server 2007 Service Pack 2 (SP2) or
Commerce Server 2009 installed to apply this update.
Restart requirement
You do not have to restart the computer after you apply this
update.
Update replacement information
This update does not replace any other updates.
File information
The English version of this update has the file
attributes (or later file attributes) that are listed in the following table.
The dates and times for these files are listed in Coordinated Universal Time
(UTC). When you view the file information, it is converted to local time. To
find the difference between UTC and local time, use the
Time
Zone tab in the
Date and Time item in Control
Panel.
For all supported versions of Commerce Server 2007
Collapse this tableExpand this table
| File name | File version | File
size | Date | Time | Platform |
|---|
| Csdwschema.sql | Not
applicable | 3,749,720 | 13-Nov-2009 | 11:04 | Not
applicable |
| Csreports.sql | Not
applicable | 235,244 | 13-Nov-2009 | 11:28 | Not
applicable |
For all supported versions of Commerce Server 2009
Collapse this tableExpand this table
| File name | File version | File
size | Date | Time | Platform |
|---|
| Csdwschema.sql | Not
applicable | 3,749,720 | 16-Nov-2009 | 11:15 | Not
applicable |
| Csreports.sql | Not
applicable | 235,244 | 16-Nov-2009 | 11:39 | Not
applicable |
Installation notes
After you extract the hotfix package, you obtain the following
files.
For Commerce Server 2007- CommerceServer2007SP2-KB976523-ENU.exe
- Csdwuaupdate.sql
- Hotfix.txt
For Commerce Server 2009- CommerceServer2007SP3-KB976523-ENU.exe
- Csdwuaupdate.sql
- Hotfix.txt
Install
the CommerceServer2007SP2-KB976523-ENU.exe file to update the user-agent
reference data and the
stored procedures for Commerce Server 2007.
Install the CommerceServer2007SP3-KB976523-ENU.exe
file to update the user-agent reference data and the
stored procedures for Commerce Server 2009.
Additionally, you must run the Csdwuaupdate.sql file against
the existing Commerce Server data warehouse database to update the user-agent
reference data and the
related stored procedures.
Microsoft
has confirmed that this is a problem in the Microsoft products that are listed
in the "Applies to" section.
For more information about Commerce
Server data warehouses,
visit the following Microsoft Developer Network (MSDN) Web site:
For more information about user-agent strings, visit
the following MSDN Web site: