Export Search Results to Excel

Ankur Jain

Hi All,

I have a requirement to create a feature to export search results to excel.Could anyone guide me on the same.

Thanks ,

Ankur

Find more posts tagged with

Comments

Greg Griffiths

There are several ways, you can use Excel Web Query, XML Search API with an XLST, WebReports and others depending on your specific requirements.

Greg Griffiths

crossposted athttps://knowledge.opentext.com/knowledge/cs.dll?func=ll&objId=42366213&objAction=viewincontainer&ViewTopicsByReply&ListView&ListViewID=42366213

Appu_Nair1

Are you looking for clues or something more substantial.

Clue #1:If you have WR installed you can turn any search result into Excel.

Clue#2:If you put the output of a RH as any document with a suitable mimetype like application/vnd-msexcel or the new excel mimetype the browser will interpret it as a Excel document. I have seen socket code do this without actually making a excel document to be served. In use in our company right now. Cannot tell you because it is our IP and I was not the person who thought of it.

Clue#3:You have a function called Add search Results to a collection. If you trace that code you will see how you can get the search results. I used this to manipulate search results in a previous job.

Clue#4:You can use Search API or searchXML API and output results as XML. With some internet research you could take the XML and make it into Excel.

Not sure how you will manipulate/be within Excel limitations on rows et al.

From: eLink Entry: Content Server Development Forum [mailto:development@elinkkc.opentext.com]
Sent: Wednesday, December 11, 2013 6:39 AM
To: eLink Recipient
Subject: [EXTERNAL]Export Search Results to Excel

Export Search Results to Excel

Posted by ankur-jain@hcl.com (Jain, Ankur) On 12-11-2013 07:34

Hi All,

I have a requirement to create a feature to export search results to excel.Could anyone guide me on the same.

Thanks ,

Ankur

[To post a comment, use the normal reply function]
Forum:	Content Server Development Forum
Content Server:	Knowledge Center

Wolf Alexander Beyer

A) Add the search results to a collection. open the collection -> Download as Spreadsheet.

write a webreport that export the search results with search result as data source (additional Licensing required).

Regards

Alexander Beyer

Executive Director

complon GmbH

Friedenheimer Str. 47

80686 München

Phone: +49 89 579497911

Mobil: +49 170 2242042

E-Mail: Alexander.beyer@complon.com

Am 11.12.2013 um 13:40 schrieb "eLink Entry: Content Server Development Forum" <development@elinkkc.opentext.com>:

eLink : Export Search Results to Excel
Export Search Results to Excel Posted byankur-jain@hcl.com (Jain, Ankur)On 12-11-2013 07:34

Hi All, I have a requirement to create a feature to export search results to excel.Could anyone guide me on the same. Thanks , Ankur
[To post a comment, use the normal reply function]
Forum: Content Server Development Forum
Content Server: Knowledge Center

Patrick Pidduck

Hi Ankur,

The closest “out of the box” feature we have is to create a collection from search results, then use the collection “Download as Spreadsheet” feature.

Regards,

Patrick.

From: eLink Entry: Content Server Development Forum [mailto:development@elinkkc.opentext.com]
Sent: Wednesday, December 11, 2013 7:39 AM
To: eLink Recipient
Subject: Export Search Results to Excel

Export Search Results to Excel

Posted byankur-jain@hcl.com (Jain, Ankur) On 12-11-2013 07:34

Hi All,

I have a requirement to create a feature to export search results to excel.Could anyone guide me on the same.

Thanks ,

Ankur

[To post a comment, use the normal reply function]
Forum:	Content Server Development Forum
Content Server:	Knowledge Center

Kyle_Swidrovich

Is CSV format insufficient?

Content Server 10 has the capability to export to CSV.

Ankur Jain

Hi All,

1.We do have Web Reports but the user want to use a particular search form and search display style and also they want to export any search result they want to excel.

2. I do have information about collections and export from there but the export does not give the data they want to get in results like they want details of record like the rsi and to from dates which is not displayed in excel export of the collection.

3.We are on CS 10.0 Update 7 where can the feature of export to CSV be found.

4. Can anyone please give more details about use Search API or searchXML API.

Thanks,

Ankur

Tracy_Caughell

Hi. If RM is already in use, there is a system setting to turn on a feature that will allow you to send the results of a search to a disposition snapshot. From the disposition snapshot you can choose the function menu and export metadata and choose which RM (and PO) fields to export to xls. I think the system setting is 'send to disposition' and is found in the RM workspace/RM administration/system settings. Tracy________________________________________From: eLink Entry: Content Server Development Forum [development@elinkkc.opentext.com]Sent: December 18, 2013 11:44 PMTo: eLink RecipientSubject: RE Export Search Results to Excel 3RE Export Search Results to Excel 3 Posted by ankur-jain@hcl.com (Jain, Ankur) On 12-18-2013 23:43Hi All,1.We do have Web Reports but the user want to use a particular search form and search display style and also they want to export any search result they want to excel.2. I do have information about collections and export from there but the export does not give the data they want to get in results like they want details of record like the rsi and to from dates which is not displayed in excel export of the collection.3.We are on CS 10.0 Update 7 where can the feature of export to CSV be found.4. Can anyone please give more details about use Search API or searchXML API.Thanks,Ankur________________________________[To post a comment, use the normal reply function]Topic: Export Search Results to ExcelForum: Content Server Development ForumContent Server: Knowledge Center

Ankur Jain

Hi Tracy,

Thanks for the information.We do have RM but our requirement is not only of getting results of Disposition Search Exported to Excel, but any kind of Content Server Search.

Thanks,

Ankur

Greg_Griffiths

sounds like you will need to do some custom coding here to achieve this, at least editing the WebLingo files, see the links I posted in my first reply.