Question Re: /SRMNXP/CAT01 - Catalog Extractor in Spend Management Q&A

/SRMNXP/CAT01 - Catalog Extractor

Former Member — Thu, 12 Jun 2014 12:57:30 GMT

Hi,

We are implementing cross catalog search in SRM 702 SP5. We have enabled OCI 5.0 & TREX. I am trying to upload catalog data in JSON format using transaction /SRMNXP/CAT01. Once executed, I see there the import history shows green. Is there a way to see more details on the execution of the job?

Please let me know.

Thanks,

Ashwin

Re: /SRMNXP/CAT01 - Catalog Extractor

bhargavab4 — Tue, 17 Jun 2014 13:17:30 GMT

Hi Ashwin,

Check by double clicking the log entry in the import history.

Regards,

Bhargava

Re: /SRMNXP/CAT01 - Catalog Extractor

Former Member — Tue, 17 Jun 2014 13:21:07 GMT

Hi Bhargava,

Thanks for the reply, we had to apply changes based on note to fix the import history log.

1882385 - SRMNXP:Catalog extraction Post Processing Office BC sets.

But in the log, it is stating "XXX: Could not create number range for Search Term Language". This seems to be causing issue with the searching for cross catalog.

Thanks,

Ashwin

Re: /SRMNXP/CAT01 - Catalog Extractor

Yateesh_h — Thu, 03 Jul 2014 12:24:05 GMT

Hi Ashwin,

In the SPRO, there is a node for maintaining number ranges for search. Could you please check if that has been maintained as suggested in the cook book.

Cheers,

Yateesh

Re: /SRMNXP/CAT01 - Catalog Extractor

Former Member — Thu, 18 Sep 2014 17:11:35 GMT

Hi Ashwin,

We are facing the same error "XXX: Could not create number range for Search Term Language" . Could you please share with me if you have a solution for this.

Cheers,

Gopi

Re: /SRMNXP/CAT01 - Catalog Extractor

Former Member — Thu, 18 Sep 2014 19:28:56 GMT

Hi Gopi,

Please make sure the number range for object /SRMNXP/IS is maintained as attached. If the number is not 01, the upload of catalog data does not work.

Re: /SRMNXP/CAT01 - Catalog Extractor

Former Member — Fri, 19 Sep 2014 07:21:53 GMT

Hi Ashwin,

Thanks a lot. You are right.

Now the error is gone, still we are seeig no results in our search. Will have to check if something else is missing.

Best Regards,

Gopi

Re: /SRMNXP/CAT01 - Catalog Extractor

Former Member — Fri, 19 Sep 2014 15:25:49 GMT

Hi Gopi,

After uploading the data, do you see any entries in table /SRMNXP/CAT_ITM?

You might be missing step to schedule the indexing, which is done through transaction ESH_COCKPIT.

Thanks,

Ashwin

Re: /SRMNXP/CAT01 - Catalog Extractor

Former Member — Sat, 20 Sep 2014 06:17:54 GMT

Hi Ashwin,

Yes, we see the data in the staging tables and also the indexing went good as we can see the entries in optimized column in ESH_COCKPIT

The issue is resolved now.I want to share the solution here. The problem was with some mandatory attributes in JSON file which the system was checking during the search return and failing. It was the price validity range for catalog items. After maintaining it manually in /SRMNXP/CAT_ITM the search worked good. And one more thing is we should deactivate the Catalog View ID feature in SPRO if not relevant.

Thanks a lot for your support Ashwin.

Best Regards,

Gopi

Re: /SRMNXP/CAT01 - Catalog Extractor

Former Member — Fri, 10 Oct 2014 15:33:53 GMT

Hi Ashwin, Hi All,

How is the HTTP call made to catalog supplier is it via SPRO->Define external services and by giving additional parameters such as FUNCTION = DOWNLOAD JSON?

If yes, can this be scheduled or will it be a manual process?

Or is the HTTP call to get JSON data made thru code? Especially if it has to be scheduled, lets say hourly or nightly?

I have gone thru the OCI 5 specification and this aspect was not clear. Since you say you have already enabled OCI 5 it will help if you could shed more light on this aspect.

Re: /SRMNXP/CAT01 - Catalog Extractor

Former Member — Mon, 13 Oct 2014 08:08:44 GMT

Hi Madhuri,

You can ask the catalog responsible to provide the JSON file and start uploading it via the catalog extractor.

Thanks and regards,

Gopi

Re: /SRMNXP/CAT01 - Catalog Extractor

Former Member — Tue, 04 Nov 2014 10:27:55 GMT

Hi All,

Do you have/know a sample catalog that can be used for testing the catalog extractor. We are waiting for Ariba to come out with 13s before it can be used with catalog extractor..

Regards,

Praveen.

Re: /SRMNXP/CAT01 - Catalog Extractor

Former Member — Thu, 06 Nov 2014 08:07:59 GMT

Hi Gopi,

I am in the same situation as you were earlier

OCI 5 extraction to staging tables done. Search Connectors set up in ESH cokcpit, Indexing scheduled and completed without errors. I see optimized entries for Attachments, Price conversion table/scales and SRM NXP search terms.

Yet when I go to Search in the UI, I'm not getting any results, I see the loading icon without any results for ever.

I have already made sure that Price validity range is being extracted from JSON file and also present in cat_itm table. Also no catalog views are present in SPRO.

Two questions:

Is there any other configuration that I need to be taking care of?
How do I include internal products to appear in my search ( I have already set up connectors for these as well - but nothing is returned in the results).

Any inputs appreciated...

Thanks,

Praveen.

Re: /SRMNXP/CAT01 - Catalog Extractor

Former Member — Thu, 06 Nov 2014 10:14:43 GMT

Hi Praveen,

Can you check and let me know if you can see the indexed items in the test search program 'ESH_TEST_SEARCH' . We can make sure that the indexing was successful and will move on to the next things to check.

Cheers,

Gopi

Re: /SRMNXP/CAT01 - Catalog Extractor

Former Member — Thu, 06 Nov 2014 11:30:53 GMT

Gopi, thanks for the quick response -

I ran the test program by giving connector name and freestyle search and I see entries for SRM (internal) product categories but not for the entries obtained by OCI 5 extraction, although the count does show up in "All Hits".

For search terms -

For internal Product Categories -

Note that from the ESH cockpit I'm not getting any errors for the search terms, and the indexing completes successfully without any errors.

Re: /SRMNXP/CAT01 - Catalog Extractor

Former Member — Mon, 10 Nov 2014 05:47:06 GMT

Hi Praveen,

Maintain the connector as NXP catalog during the search filter.

It should show the TREX items if the indexing is successful. Also please let us know if you see the number of items (optimized column) in ESH cockpit after the indexing job.

Regards,

Gopi

Re: /SRMNXP/CAT01 - Catalog Extractor

Former Member — Mon, 10 Nov 2014 10:17:34 GMT

Hi Gopi,

The search connector name has not been changed from the default template. These are the settings during the execution of the search test program ESH_TEST_SEARCH:

This does give the required result as:

The optimized entries are as shown below:

Also by opening the Enterprise Search page from the ESH cockpit (ESH cockpit -> Related Links -> Enterprise Search) I can key in the search parameters and I get the accurate results (see below).

This leads me to believe that the indexing and search are working okay. But the results from the search are not appearing on SRM UI page. Could it be because any additional configuration settings are required to bind the search results to the SRM UI?

Did you have to make any configuration changes in Embedded Search/TREX in order to display the results in UI?

PS: I'm positive I have configured all the required attributes from the user side in PPOMA_BBP.

Any suggestions are appreciated.

Thanks,

Praveen.

Re: /SRMNXP/CAT01 - Catalog Extractor

Former Member — Wed, 12 Nov 2014 11:13:03 GMT

Praveen

Did you find a solution for this?

I'm getting the exact same results as you but cannot get the search to return anything on the UI.

Regards

Keith

Re: /SRMNXP/CAT01 - Catalog Extractor

Former Member — Wed, 12 Nov 2014 12:09:59 GMT

Hi Keith - Yes I did. I've been meaning to create an end-to-end config document with nitty-gritty not present in the cookbook

Turns out we needed to implement notes:

2049470 - Search based on Product Category Hierarchy and

2034525 - Catalog Extractor for Product Relationships - Inclusion of Target Catalog Name

These corrections are present in SP06.

Also be sure to select the correct template in the Enhanced Search customizing options as below:

You want to clear the (Gateway & Browser) cache after these settings since the changes are being made to the models in ESH cockpit and load the UI page again.

Let me know if this works for you too..

Regards,

Praveen.

Re: /SRMNXP/CAT01 - Catalog Extractor

Former Member — Wed, 12 Nov 2014 12:23:31 GMT

My Apologies - updated correct second note, the (second) one mentioned in last note was for Product Relationships and is only applicable if you intend to maintain them.

For returning Search results in UI, you want to implement these two:

2049470 - Search based on Product Category Hierarchy

2051459 - Search for Item in Category Hierarchy has No Results

Thanks,

Praveen.