To create a new e-mail activity, do the following:
- Log on as the database user
- At a command prompt, navigate to the WCinstall_dir/CommerceServer55/bin/.
Within that directory, at a command prompt, type the following,
createEmailTemplate.db2 db_namedb_userJSP_pathproperty_file
template_name "template_description" storeIdcreateEmailTemplate.db2.sh db_namedb_userJSP_pathproperty_file
template_name "template_description" storeIdWithin that directory, at a command prompt, type the following,
createEmailTemplate.oracle db_namedb_userJSP_pathproperty_file
Template_name "template_description" storeIdcreateEmailTemplate.oracle.sh db_namedb_userJSP_pathproperty_file
template_name "template_description" storeIdwhere:
- db_name
- is the name of the 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
When prompted, enter the user's database password.
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