Keyword and URL for Search redirection

[Former Member]

I'm trying to run the following impex file:

INSERT_UPDATE SolrFacetSearchKeywordRedirect;keyword[unique=true];matchType(code);ignoreCase;language(isoCode)[default=en];facetSearchConfig(name);redirect(SolrURIRedirect.url) ;testing;EXACT;true;en;facetSearchConfig;"url"

but I'm getting the follwing error:

INSERT_UPDATE SolrFacetSearchKeywordRedirect;keyword[unique=true];matchType(code);ignoreCase;language(isoCode)[default=en];facetSearchConfig(name);redirect(SolrURIRedirect.url) ,,,cannot create due to unresolved mandatory/initial columns, column 6: could not resolve item for url;testing;EXACT;true;en;facetSearchConfig;url

ERROR: line 3 at main script: Can not resolve any more lines ... Aborting further passes (at pass 2).

I'm trying to add a new Keyword and URL for Search redirection.

Any help, more than welcome.

[Former Member · Accepted solution]

ImpEx for SOLR Configuration

Macros / Replacement Parameter definitions

$facetSearchConfigName=mySiteIndex $contentCatalog=mySiteContentCatalog $contentCV=catalogVersion(CatalogVersion.catalog(Catalog.id[default=$contentCatalog]),CatalogVersion.version[default=Staged])[default=$contentCatalog:Staged] $productCatalog=mySiteProductCatalog $productCatalogVersion=catalogversion(catalog(id[default=$productCatalog]),version[default='Staged'])[unique=true,default=$productCatalog:Staged] $lang=fr

Example 1 - URI Redirects

Once created the Solr URI's Redirects, we can create the Keywords redirect

$site-cart=mySite-cart $site-basket=mySite-basket $site-accelerator=mySite-accelerator $site-hymacc=mySite-hymacc

Redirect page URL

PDATE SolrURIRedirect;url[unique=true];&redirectRefID ;"/cart";$site-cart ;"/cart";$site-basket ;"http://www.hybris.com/multichannel-accelerator";$site-accelerator ;"http://www.hybris.com/multichannel-accelerator";$site-hymacc

Keyword Redirects

NSERT_UPDATE SolrFacetSearchKeywordRedirect;facetSearchConfig(name)[unique=true,default=$facetSearchConfigName];language(isocode)[unique=true,default=$lang];keyword[unique=true];matchType(code)[unique=true];redirect(&redirectRefID);ignoreCase[default=true] ;;;"cart";EXACT;$site-cart; ;;;"basket";EXACT;$site-basket; ;;;"accelerator";EXACT;$site-accelerator; ;;;"hymacc";EXACT;$site-hymacc;

Example 2 - Page Redirects

Once created the Solr Page Redirects, we can create the Keywords redirect

$site-help=mySite-help $site-shipping=mySite-shipping

Redirect page

PDATE SolrPageRedirect;redirectItem(uid,$contentCV)[unique=true];&redirectRefID ;faq;$site-help ;faq;$site-shipping

Keyword Redirects

NSERT_UPDATE SolrFacetSearchKeywordRedirect;facetSearchConfig(name)[unique=true,default=$facetSearchConfigName];language(isocode)[unique=true,default=$lang];keyword[unique=true];matchType(code)[unique=true];redirect(&redirectRefID);ignoreCase[default=true] ;;;"help";EXACT;$site-help; ;;;"shipping";STARTS_WITH;$site-shipping;

Example 3 - Product Redirects

Once created the Solr Product Redirects, we can create the Keywords redirect

$site-1382080=mySite-1382080 $site-2053266=mySite-2053266 $site-1352537=mySite-1352537

Category Redirect

NSERT_UPDATE SolrProductRedirect;redirectItem(code,$productCatalogVersion)[unique=true];&redirectRefID ;1008408;$site-1008408 ;1109451;$site-1109451 ;1352537;$site-1352537

Keyword Redirects

NSERT_UPDATE SolrFacetSearchKeywordRedirect;facetSearchConfig(name)[unique=true,default=$facetSearchConfigName];language(isocode)[unique=true,default=$lang];keyword[unique=true];matchType(code)[unique=true];redirect(&redirectRefID);ignoreCase[default=true] ;;;"M403";CONTAINS;$site-1008408; ;;;"M340";CONTAINS;$site-1109451; ;;;"S73";CONTAINS;$site-1352537;

Example 4 - Category Redirects

Once created the Solr Category Redirects, we can create the Keywords redirect

$site-sony=mySite-1028 $site-canon=mySite-1060 $site-memory=mySite-17033

Category Redirect

NSERT_UPDATE SolrCategoryRedirect;redirectItem(code,$productCatalogVersion)[unique=true];&redirectRefID ;1028;$site-sony ;1060;$site-canon

Keyword Redirects

NSERT_UPDATE SolrFacetSearchKeywordRedirect;facetSearchConfig(name)[unique=true,default=$facetSearchConfigName];language(isocode)[unique=true,default=$lang];keyword[unique=true];matchType(code)[unique=true];redirect(&redirectRefID);ignoreCase[default=true] ;;;"M8";STARTS_WITH;$site-sony; ;;;"M17";STARTS_WITH;$site-canon;

[chandnigideon13]

Hi,

Can we search any product in Search API(https://localhost:9002/occ/v2/adl/products/search) using Keywords configured in facet search config?

If so, how can we do that because when I am trying to pass the keyword in query para, it doesn't give me the result.

[Former Member]

Hi David,

Following script should work

 INSERT_UPDATE SolrURIRedirect;url[unique=true];&redirectRefID
 ;"/url";redirectRefID
 
 INSERT_UPDATE SolrFacetSearchKeywordRedirect;keyword[unique=true];matchType(code);ignoreCase;language(isoCode)[default=en];facetSearchConfig(name);redirect(&redirectRefID)
 ;testing;EXACT;true;en;facetSearchConfig;redirectRefID