Microsoft KB Archive/199362

= How to Import User Data =

Article ID: 199362

Article Last Modified on 11/23/2000

-

APPLIES TO


 * Microsoft Site Server 3.0 Standard Edition

-



This article was previously published under Q199362



SUMMARY
The article describes sample steps to import user data from Personalization and Membership to an Analysis database.



MORE INFORMATION
This configuration assumes a complete installation of Site Server with SQL Server selected for the Analysis database.

Set up the Membership Instance:
 * 1) In the MMC, under P&M, right-click the server name, select New, and choose Membership Server Instance.
 * 2) Click Next.
 * 3) Select Custom Configuration and click Next.
 * 4) Select AUO and LDAP only, and then click Next.
 * 5) Create a new Membership Directory and click Next.
 * 6) Use Membership Authentication and click Next.
 * 7) Set the Membership Directory name to "UA Test" and the administrator's password to "password," and then click Next.
 * 8) Select a SQL Server database and click Next.
 * 9) Enter the server name. The database name is "SSMembership," the username is "sa," and the password is blank. Click Next.
 * 10) Select "All Unassigned" for IP address and port 1003. Click Next.
 * 11) Click Finish.
 * 12) Right-click on Membership Server #2, select Rename, and enter "UA Test."

Configure the Users:  In the MMC, right-click on MDM and select Properties. Enter "localhost" and port 1003, and then click OK. Select Logon Anonymously and click OK. Expand the MDM. Under ou=Admin,cn=Schema, ensure that cn=userComment and cn=userPassword both exist. Under ou=Admin,ou=ExportConfig,ou=Users, double-click cn=Default. Click Add Value and enter "userComment" and "userPassword," and then click OK. Right-click ou=Members, select New, and then choose User.</li> Click Next.</li> Enter "testuser1" for the name and click Next.</li>  Click Add Attribute and add the following: <pre class="fixed_text">       Email Address (mail)         "testuser1@domain.com" First Name (givenName)      "Test1" Last Name (sn)              "User1" user-comment (userComment)  "Test User 1 Comment" user-password (userPassword) "testuser1pass" </li> Click Next.</li> Click Add, double-click Public in the left column, and then click OK.</li> Click Finish.</li> Right-click ou=Members, select New, and choose User.</li> Click Next.</li> Enter "testuser2" for the name and click Next.</li>  Click Add Attribute and add the following: <pre class="fixed_text">       Email Address (mail)         " testuser2@domain.com" First Name (givenName)      "Test2" Last Name (sn)              "User2" user-comment (userComment)  "Test User 2 Comment" user-password (userPassword) "testuser2pass" </li> Click Next.</li> Click Add, double-click Public in the left column, click OK.</li> Click Finish.</li></ol>

Create the Web Site: <ol> In Windows Explorer, go to \Inetpub, and create a folder called "UA Test."</li> Create a file under "UA Test" called Default.htm:

Welcome To IIS 4.0!

Test default page.

</li> <li>Create a file under "UA Test" called Test.htm:

Welcome To IIS 4.0!

Test non-default page.

</li> <li>Create a file under "UA Test" called GetCookie.asp:

<%@ LANGUAGE="VBScript" %>

<% Response.Buffer = True %>

<HTML>

<HEAD>

<TITLE>Recover Personalization Settings</TITLE>

</HEAD>

<BODY>

Recover Personalization Settings

<BR><BR>

<%

On Error Resume Next

if Request("REMOTE_USER") = "" Then

Response.Write "You have not been authenticated by the system. "

Response.Write "Please contact your administrator."

Else

Set UserObjects =

Server.CreateObject("Membership.UserObjects")

Set vusr = Server.CreateObject("Membership.verifusr")

vusr.IssueCookie "SITESERVER", "GUID=" & UserObjects.Get("GUID")

vusr.IssueCookie "MEMUSER", UserObjects.Get("cn")

Response.Write "Personalization settings have been recovered. "

End if

%>

<a href="/?scid=default.htm">Home Page</a>

</BODY>

</HTML>

</li> <li>Close Windows Explorer.</li> <li>In the MMC, under IIS, right-click the computer name, select New, and choose Web Site.</li> <li>Enter "UA Test" for Web Site Description and click Next.</li> <li>Leave IP at "All Unassigned," change Port to "8010," and click Next.</li> <li>Click Browse, select \Inetpub\UA Test, and click OK.</li> <li>Click to uncheck "Allow anonymous access to this web site" and click Next.</li> <li>Click Finish.</li> <li>Right-click the "UA Test" Web site, select Task, and choose Membership Server Mapping.</li> <li>Select "UA Test" and click OK.</li> <li>Right-click the "UA Test" Web site and select Properties.</li> <li>Click Properties under Logging, and note where the log files are being stored (W3SVC3\exyymmdd.log).</li> <li>Click Cancel.</li> <li>Click the Membership Authentication tab.</li> <li>Click Other Password Authentication, check only DPA, and then click Apply.</li> <li>Click OK.</li> <li>Right-click the "UA Test" Web site and click Start.</li></ol>

Generate the Log Files: <ol> <li>On a separate computer that has not hit this server before (or delete all cookies for this server), start Internet Explorer.</li> <li>Type in http:// :8010/GetCookie.asp and then press Enter.</li> <li>Enter "testuser1" for Member ID, "testuser1pass" for Password, and then click OK. You should see:

Recover Personalization Settings / Personalization settings have been recovered. / Home Page

</li> <li>Type in http:// :8010 and press Enter. You should see:

Test default page

</li> <li>Type in http:// :8010/test.htm and press Enter. You should see:

Test non-default page

</li> <li>Close Internet Explorer.</li> <li>Repeat steps 1 through 10 on an additional computer, substituting Member ID, "testuser2" and Password "testuser2pass" on step 4.</li></ol>

Create the Database:
 * 1) Run the Database Setup Wizard.
 * 2) Click Next.
 * 3) Click Update an Existing Database and click Next.
 * 4) Set Server to the servername, the Database to "SSAnalysis," login as "sa," and password as blank. Click Connect.
 * 5) Click OK.
 * 6) Click OK.
 * 7) Click Finish.
 * 8) Click OK.
 * 9) Click OK.

Import the Log Files:
 * 1) Start Usage Import.
 * 2) Click OK.
 * 3) Select Auto Detect and click OK.
 * 4) Change IP Port to 8010 and Local Time Zone to GMT 00:00 and click OK.
 * 5) Enter a period (.) for Home Page URL.
 * 6) Click the Inferences tab and uncheck "Multiple users use the same username."
 * 7) Click OK.
 * 8) Click Tools and choose Options.
 * 9) Ensure that "Use cookies for inferences" is checked.
 * 10) Exit and restart Usage Import.
 * 11) In the Import Manager window, click Browse, select winnt\system32\LogFiles\w3svc3\exyymmdd.log and click Open.
 * 12) Click Start Import.
 * 13) Click OK.
 * 14) Click Close.
 * 15) Close Usage Import.

Import the P&M Data:
 * 1) Start Custom Import.
 * 2) Click Get External Data.
 * 3) Click User Data.
 * 4) Enter " :8010" for Server Name, "administrator" for User name, and "password" for Password.
 * 5) Ensure that "Get user records modified on or after (date)" is unchecked.
 * 6) Click Import.
 * 7) Click OK.
 * 8) Close Custom Import.

Create a Report:
 * 1) Start Report Writer.
 * 2) Select New Report Definition and click OK.
 * 3) Right-click Report Definition and select New Calculation.
 * 4) Right-click Row Dimensions and select New Dimension.
 * 5) Select Dimensions, choose Users, choose Username, and then click OK.
 * 6) Right-click Measures and select New measure.
 * 7) Select Measures, choose Visits, and then choose Number of visits.
 * 8) Right-click Measures and select New measure.
 * 9) Select Dimensions, select Users, select Cookie, and then choose User-comment.
 * 10) Change Calculate Using to Maximum.
 * 11) Click OK.
 * 12) Ensure Presentations is set to Table.
 * 13) Select File and choose Run Report.
 * 14) Enter "Test" for File name and click OK.

The generated report will show all users who entered the site along with the user-comment and user-password attributes.

For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

246435 Report Writer Not Reporting Account Usage as Expected

Keywords: kbhowto KB199362

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.