Migrating WebSphere Commerce search

• WC_installdir/bin
• WCDE_installdir\bin

• migrateSearchFacet.bat
• migrateSearchFacet.bat -instance instance_name -dbuser db_user -dbuserpwd db_password
• migrateSearchFacet.sh -instance instance_name -dbuser db_user -dbuserpwd db_password

1. Run the following SQL query:

   
   select distinct srchfieldname from clsattrsrchconf where attrname is not null;
   

   Note the result for comparison. For example:

   
   SRCHFIELDNAME
   ------------------
   CAS_F1
   

2. Run the following SQL query:

   
   select srchattr_id, propertyvalue, propertyname from srchattrprop 
   where propertyname in ('facet', 'facet-classicAttribute') and propertyvalue not like 'price%'
   

   Note the result for comparison. For example:

   
   SRCHATTR_ID            |PROPERTYVALUE
   ------------------------------------------------------------------------------------------------------
   -7000000000000000127   |ads_f10001_ntk_cs
   -7000000000000000125   |ads_f10501_ntk_cs
   -7000000000000000123   |ads_f11001_ntk_cs
   -1002                  |mfName_ntk_cs
   -1039                  |parentCatgroup_id_facet
   -1013                  |parentCatgroup_id_search
   -2000                  |xf_ads_f1_ntk_cs
   1030                   |cas_f1_ntk_cs
   

3. Find and update the record that begins with the SQL select statement result from Step 5.c.i. in the propertyvalue column (case insensitive). For example, the SRCHATTR_ID with 1030 matches the sample snippets.
   Set the propertyname value from facet to facet-classicAttribute:

   
   update srchattrprop set propertyname='facet-classicAttribute' where srchattr_id='SRCHATTR_ID'
   

   Where SRCHATTR_ID contains the matching row value. For example, 1030.
4. Insert a row for each of the classic attributes into the FACET table. Ensure that the facet_id does not conflict with any existing values. For example:

   
   insert into facet (facet_id, attr_id, srchattr_id, selection, sort_order, keyword_search, 
   zero_display, storeent_id, max_display, sequence, field1, field2, field3, optcounter) 
   values (-1039, null, 1030, 0, 0, 1, 0, 10901, 20, 0.0, null, null, null, 0)
   

   Note: Ensure that your statement matches your environment. For example, by updating the correct storeent_id value.
5. Insert a row in the FACETDESC table for the attributes. For example, if the attribute name is Color:

   insert into facetdesc values(-1039, -1, 'Color', 'classic attribute COLOR', null, null, null, 1);
   

6. Trigger a delta update or perform a full index update.

UPDATE ATTR SET FACETABLE = 1 WHERE ATTR_ID IN (list_of_facetable_attribute_ids);

• WC_installdir/components/foundation/subcomponents/search/bin
• WCDE_installdir\components\foundation\subcomponents\search\bin

• migrateSolrSearch.bat -masterCatalogId masterCatalogId
• migrateSolrSearch.bat -instance instance_name -masterCatalogId masterCatalogId -dbuser db_user -dbuserpwd db_password [-searchServerName searchServerName] [-searchServerPort searchServerPort]
• migrateSolrSearch.sh -instance instance_name -masterCatalogId masterCatalogId -dbuser db_user -dbuserpwd db_password [-searchServerName searchServerName] [-searchServerPort searchServerPort]

If your search cluster is federated from a remote search server, run the remote instructions for the search index setup migration utility:

1. Start Rational Application Developer.
2. Right-click the test server. Then, select Clean....

1. Go to the following directory:
   • WC_installdir/instances/instance_name/search/pre-processConfig
   • WCDE_installdir\search\pre-processConfig
2. Manually compare all the files in the MC_masterCatalogId.timestamp directory with the files in the MC_masterCatalogId directory.
3. Identify all the changed files, and merge the specific Feature Pack 7 changes from the MC_masterCatalogId.timestamp directory to the files with the same names in the MC_masterCatalogId directory.

1. Go to the following directory:
   • WC_installdir/instances/instance_name/search/solr/home/MC_masterCatalogId/locale_name/indextype
   • WCDE_installdir\search\solr\home\MC_masterCatalogId\locale_name\indextype
2. For each core, manually compare the solrconfig.xml, wc-data-config.xml, and schema.xml files in the conf.timestamp directory with the files in the conf directory.
3. Identify all the changed files, and merge the specific previous Feature Pack changes from the conf.timestamp directory to the files with the same names in the conf directory.

• WC_eardir/Stores.war/storedir/Snippets/ReusableObjects/SearchFacetsDisplay.jspf
• workspace_dir\Stores\Web Content\ storedir\Snippets\ReusableObjects\SearchFacetsDisplay.jspf

parentCatgroup_id_facet

parentCatgroup_id_search

<c:if test="${totalCount > 1}">
   <c:forEach var="facetField" items="${globalfacets}">
   <c:if test="${facetField.value eq 'parentCatgroup_id_search'}">
   <c:if test="${fn:length(facetField.entry) > 1}">
      <%@ include file="../../Snippets/Search/CategoryFacetDisplay.jspf" %>
         <c:set var="f" value="${f + 1}" />
      </c:if>
   </c:if>
</c:forEach>

<c:if test="${totalCount > 0}">
   <c:forEach var="facetField" items="${globalfacets}">
   <c:if test="${facetField.value eq 'parentCatgroup_id_search'}">
   <c:if test="${fn:length(facetField.entry) > 0}">
      <%@ include file="../../Snippets/Search/CategoryFacetDisplay.jspf" %>
         <c:set var="f" value="${f + 1}" />
      </c:if>
   </c:if>
</c:forEach>

• WC_eardir/Stores.war/storedir/Snippets/Search/SearchSetup.jspf
• workspace_dir\Stores\Web Content\ storedir\Snippets\Search\SearchSetup.jspf

request.setAttribute("handledSearchTerm"
   ,SpecialCharacterHelper
   .getHandledString(searchTerm, false));

request.setAttribute("handledFilterTerm"
   ,SpecialCharacterHelper
   .getHandledString(wcp.get("filterTerm"), false));

request.setAttribute("handledManufacturer"
   ,SpecialCharacterHelper
   .getHandledString(wcp.get("manufacturer"), false));

request.setAttribute("handledSearchTerm"
   ,SpecialCharacterHelper
   .escapeDollar(searchTerm));

request.setAttribute("handledFilterTerm"
   ,SpecialCharacterHelper
   .escapeDollar(wcp.get("filterTerm")));

request.setAttribute("handledManufacturer"
   ,SpecialCharacterHelper
   .escapeDollar(wcp.get("manufacturer")));

• WC_eardir/Stores.war/storedir/include/BreadCrumbTrailDisplay.jsp
• workspace_dir\Stores\Web Content\ storedir\include\BreadCrumbTrailDisplay.jsp

<c:if test="${fn:startsWith(breadcrumbLabel, '({')}">
   <c:set var="rangeLabel" value="${fn:replace(breadcrumbLabel,'({','')}" />
   <c:set var="rangeLabel" value="${fn:replace(rangeLabel,'})','')}" />
   <c:set var="rangeLabel" value="${fn:replace(rangeLabel,'}','')}" />

<c:if test="${fn:startsWith(breadcrumbLabel, '{')}">
   <c:set var="rangeLabel" value="${fn:replace(breadcrumbLabel,'{','')}" />
   <c:set var="rangeLabel" value="${fn:replace(rangeLabel,'}','')}" />

• working_dir/search/instance_name/search/solr/home