/SRMNXP/CAT01 - Catalog Extractor

[Former Member]

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

[former_member773558]

HI ,

I have added json file and status shows as green also but staging table ddn't get updated, Kindly help if any setting is required for it.

Thanks and Regards,

Shaweta

[laurent_burtaire]

Hello Shaweta,

did you check logs in SLG1 transaction for object /SRMNXP/CTLG_EXT_LOG.

Concerning JSON extraction process, i advise you to use the report /SRMNXP/CATALOG_SCHEDULER rather than the transaction /SRMNXP/CAT01..

Regards.

Laurent.

[Former Member]

Hi Gopi Krishna,

I also facing a same issue. After uploding the JSON file we are unable to find the entries in Staging table.

I am new to the SRM UI. Could you please let me know the technically, how it will upload the data into staging table and sample JSON file. Is there any condition to follow before upload the file.

It would great help for me if you provide the solution.

Thanks    

Sree

[Former Member]

Hi Experts,

I want to retrieve data from the Punch-out Catalog into SRM staging tables using HTTP web service.

The external catalog link is accessible from SRM portal without any issue but when I am trying to import the data using /SRMNXP/CAT01 it is runing forever and nothing is updating in staging table.

Please reply asap .

Thanks,

JP

[Former Member]

Hi JP,

You cannot extract the data from punch out, the data needs to be in JSON format for the /SRMNXP/CAT01 program to extract and load the data into the staging tables.

Thanks,

Ashwin

[Former Member]

Hi Ashwin,

Could you please tell me how I can convert data into JSON format.

Please see some line from SRM_UI_Add_On_SP01.

They have written that there is two we can can import third party catalog.

2.4.3 Catalog Data Import Formats

3rd party catalog providers can supply the data according to OCI 5.0 specification in 2 ways:

 JSON file

 HTTP(s) Webservice.

Could you please let me know the configuration or the step to do this.

Thanks,

JP

[Former Member]

Hi Jay,

I believe there is some confusion here. The two methods mentioned in the document is related to the delivery method of the file. The supplier catalog can be sent as a file or hosted on there end and extracted via HTTP/HTTPs web service.

If you go into /SRMNXP/CAT01, you will notice that these are one of the options.

On your other question on how to convert, this has to be done via:

1. Manual data conversion

2. Using Ariba Procurment content.

You can refer to article created by Michael Jud .

Thanks,

Ashwin

[Former Member]

Hi Ashwin,

In your first paragraph, you have wrote that "The supplier catalog can be sent as a file or hosted on there end and extracted via HTTP/HTTPs web service.".

My question is if catalog will be sent by file it should be in json format and we just need to upload with transaction /SRMNXP/CAT01.

But if we want to extract using web service , how should i approach , do the client will give me such URL,if you have such example , please let me know, i will show to my client and will ask to create same urL.

Thanks,

JP

[Former Member]

Hi JP,

The URL shall be entered in the /SRMNXP/CAT01. The data is this present in JSON format but instead on the file sent to you, the hosted data can be pulled from the supplier on periodic basis.

As an example: It will look like this: https://asfdsdf.32452fgv.com/invoke/JSONMX&FUNCTION=DOWNLOADJSON

I cannot share the actual URL as this will reveal other confidential information.

Thanks,

Ashwin

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[bhargavab4]

Hi Ashwin,

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

Regards,

Bhargava

[Former Member]

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

[Yateesh_h]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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:

1. Is there any other configuration that I need to be taking care of?
2. 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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

Praveen

Thanks for the reply.

I'll arrange for the notes to be implemented and will let you know how I get on.

Also how do I refresh the gateway cache?

Regards

Keith

[Former Member]

Sure.

You clear the GW cache thru customizing.

SPRO-> SAP Web AS -> Gateway -> Odata channel -> Administration -> Cache settings  -> Cleanup Cache and Persistency.

There should be a T-code for it, I don't recall right away.

Oh and be sure to un-check Test mode before you finally run it.