Registering an e-mail activity template

To register a new e-mail activity template:

  1. Ensure that you know the storeid. The storeid is the value located in the STORE_ID column of the STORE database table. To determine the storeid :
    1. Connect to the WebSphere Commerce database.
    2. Run the following command:
      select * from storeent
      
  2. Follow the steps appropriate to your platform:
    1. WindowsAIXSun Solaris Operating EnvironmentLinux Log on as the database user.
    2. i5/OSiSeries Proceed to step 6.
  3. At a command prompt, navigate to the WCinstall_dir/CommerceServer56/bin/.
  4. Within that directory, at a command prompt, type the following,

    DB2

    Windows createEmailTemplate.db2 db_namedb_userJSP_pathproperty_file
    template_name "template_description" storeId

    AIXSun Solaris Operating EnvironmentLinux createEmailTemplate.db2.sh db_namedb_userJSP_pathproperty_file
    template_name "template_description" storeId

    Oracle

    Windows createEmailTemplate.oracle db_namedb_userJSP_pathproperty_file
    Template_name "template_description" storeId

    AIXSun Solaris Operating Environment createEmailTemplate.oracle.sh db_namedb_userJSP_pathproperty_file
    template_name "template_description" storeId

    where:

    db_name
    is the name of the WebSphere Commerce database
    db_user
    is the database user name for the specified db_name
    JSP_path
    is the fully qualified URL of the JSP associated with the template on the commerce server
    property_file
    is the property file associated with the template. If there is no property file, specify noTemplate
    template_name
    is the name of the template
    template_description
    is a short description for the template
    storeId
    is the store ID of the target store
  5. DB2 When prompted, enter the user's database password.
  6. i5/OSiSeries Using the Operations Navigator, or some other comparable method, run the following SQL on your instance:

    insert into schemaname.emlmsg 
      (emlmsg_id, jsppath, propertyfile, 
      name, description, storeent_id) 
        select coalesce(max(emlmsg_id), 0) + 1, 
          'JSP_path', 'property_file', 'template_name', 'template_description',
          storeId from emlmsg ;
    

    where:

    schemaname
    is the name of your instance
    JSP_path
    is the fully qualified URL of the JSP associated with the template on the commerce server
    property_file
    is the property file associated with the template. If there is no property file, specify noTemplate
    template_name
    is the name of the template
    template_description
    is a short description for the template
    storeId
    is the store ID of the target store

Feedback