Export (0) Print
Expand All

How to Change the Profiles Primary Key

Commerce Server 2007
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

By default, Commerce Server 2007 stores Profiles data by using the email_address field as the primary key. Your business scenario may dictate that another field, such as logon_name, be the primary key. This topic outlines the steps that are required to change this default behavior, by using the starter site as an example. Follow all procedures in the order listed:

  • Change the Profiles System primary key.

  • Update the starter site configuration (if you are using the starter site).

  • Update the starter site Web pages (if you are using the starter site).

  • Update the Customer and Orders Manager tool.


To perform the steps outlined in this procedure, you must first install the Commerce Server SDK. For more information about how to install the SDK, see the installation guide. By default, the SDK is installed in the C:\Program Files\Microsoft Commerce Server 2007\SDK folder.


Running the scripts in this procedure will delete all Profiles objects and tables. Therefore make sure that you back them up before following this procedure.

To change the Profiles System primary key to use logon_name

  • Open Microsoft SQL Server Management Studio and execute the following SQL script:


    By default, this is located in the C:\Program Files\Microsoft Commerce Server 2007\sdk\Samples\Profiles folder.

    Import the Profilesql_nonemaillogonname.xml profile schema file. By default, this is located in the C:\Program Files\Microsoft Commerce Server 2007\sdk\Samples\Profiles folder. For information about how to import profile schema, see How to Import Profile Schema.

To update the Starter Site

  1. Open the Web.config file for the starter site. By default, this folder is located in the C:\inetpub\wwwroot\StarterSite folder.

  2. Change the value of the userIdKey attribute from "GeneralInfo.email_address" to "GeneralInfo.logon_name".

    This attribute is located in the configuration/CommerceServer/profiles/userProfile node.

  3. Add a new attribute that is named logonNameProperty, and assign it a value of "GeneralInfo.logon_name". This attribute is located in the configuration/system.web/membership/providers/add node (where the membership provider is UpmProvider). The node will look like the following:

    <membership defaultProvider="UpmProvider">
        <add name="UpmProvider" 

To update the Starter Site Web pages

  1. Open the StarterSite in Visual Studio 2005 or Visual Studio 2008.

  2. Open the Register.aspx file, which is located in the User folder.

  3. Change the value of the RequireEmail property to true. This property is located in the <asp:CreateUserWizard> control, and looks like the following:

    <asp:Content ID="Content" ContentPlaceHolderID="MainContent" 
      <asp:CreateUserWizard ID="NewUserForm" runat="server"
        OnCreatedUser="NewUserForm_CreatedUser" ... />
  4. Locate the HTML code where the UserName row is defined in a table. After the closing </tr> tag for UserName, add the following code to create a new row in the table for Email:

      <td align="right">
        <asp:Label ID="EmailLabel" runat="server" 
          meta:resourceKey="EmailLabel" /></td>
        <asp:TextBox ID="Email" runat="server" 
        <asp:RegularExpressionValidator ID="EmailValidator" 
          runat="server" ControlToValidate="Email"
        <asp:RequiredFieldValidator ID="EmailRequired" runat="server" 
  5. Remove the following <asp:RegularExpressionValidator> control from the page:

    <asp:RegularExpressionValidator ID="UserNameValidator" 
      runat="server" ControlToValidate="UserName" 
  6. Save and close the Register.aspx file.

  7. Open the Register.aspx.resx file, which is located in the User\App_LocalResources folder.

  8. Remove these rows from the resources table:

    • UserNameValidator.ErrorMessage

    • UserNameValidator.ToolTip

  9. Change these rows in the resources table to the specified values:

    • UserNameLabel.Text to "Logon name:"

    • UserNameRequired.ErrorMessage to "Please enter your logon name."

    • UserNameRequired.ToolTip to "Please enter your logon name."

  10. Add the following rows in the resources table, and set them to the specified values:

    • EmailLabel.Text to "E-mail address:"

    • EmailRequired.ErrorMessage to "Please enter your e-mail address."

    • EmailRequired.ToolTip to "Please enter your e-mail address."

    • EmailValidator.ErrorMessage to "Please enter a valid e-mail address."

    • EmailValidator.ToolTip to "Please enter a valid e-mail address."

  11. Save and close the Register.aspx.resx file.

  12. Open the Register.aspx.cs file, which is located in the User folder.

  13. In the OnLoad event, locate the following line:

  14. Change the line to the following:

  15. Save and close the Register.aspx.cs file.

To update the Customer and Orders Manager tool

  1. Locate the four *_presentationinfo_nonemaillogonname.xml files. By default, these are installed in the C:\Program Files\Microsoft Commerce Server 2007\sdk\Samples\Profiles folder. Each file is for a different culture; EN, DE, FR, and JA.

  2. Copy the four files into the Profiles Web Service folder. By default this is C:\inetpub\wwwroot\ProfilesWebService.

  3. Open the Profiles Web Service Web.config file by using Visual Studio or a text editor.

  4. Change each of the <cultureConfig> elements in the <presentationConfiguration> section to point to the new presentation information file you copied in step 2, as follows:

  5. Save and close the Web.config file.

The procedure outlined in this topic shows how you can change the default Profiles System primary key from email_address to logon_name. However, you may have to change the primary key to a different field, such as tel_number. To do this, you must follow the same procedure as the one outlined in this topic, but you will have to modify the scripts and procedures shown in this topic.

You must have permissions to execute SQL scripts and to import profile schema.

© 2015 Microsoft