This discussion is archived
4 Replies Latest reply: Jun 12, 2012 10:30 PM by MAK RSS

Download search result in Excel sheet

MAK Newbie
Currently Being Moderated
hello Experts ,

I am working on UCM 11g.

We have a search template which helps us to search on UCM. I have to extract our search result in MS excel sheet. Could you please suggest the easiest way for it?

Thanks,
Mahesh
  • 1. Re: Download search result in Excel sheet
    Srinath Menon Guru
    Currently Being Moderated
    Hi ,

    If you enable Record Management feature and set it to Standalone mode then the option to download search results in PDF (that is the only one I have checked) is available .

    Thanks
    Srinath
  • 2. Re: Download search result in Excel sheet
    user10960252 Newbie
    Currently Being Moderated
    In Bex's book there is an example that does exactly this. It is placed in chapter 8. It is about UCM 10 g, but if you find the resources that should be overwritten to show the link in menu bar it will work perfect in UCM 11g

    Hope it helps
  • 3. Re: Download search result in Excel sheet
    MAK Newbie
    Currently Being Moderated
    Hello,

    I have been trying to create the following component from BEX's book, which creates an extra value on a drop down to export search resullts to a CSV file:

    <@dynamichtml custom_searchapi_result_options@>
    <$include super.custom_searchapi_result_options$>
    <option value="window.location='<$HttpCgiPath$>?<$QUERY_STRING
    $>&IsJava=1&MergeInclude=spreadsheet_search_results'">
    Download Spreadsheet</option>
    <@end@>

    <@dynamichtml spreadsheet_search_results@>
    Title,Author,Date,Security Group,Content ID,Content Type
    <$loop SearchResults$><$dDocTitle$>,<$dDocAuthor$>,<$dInDate
    $>,<$dSecurityGroup$>,<$dDocName$>,<$dDocType$>
    <$endloop$>
    <$setContentType("text/csv")$>
    <$setHttpHeader("Content-Disposition",
    "attachment;filename=search_results.csv")$>
    <@end@>

    As this drop down is now different in UCM 10gR3 this no longer appears to work (I get an error when adding these as a resource file) I presume I need change this include "$include super.custom_searchapi_result_options". How do I find out which include to use? I am quite new to creating custom components.

    Thanks for your help,
  • 4. Re: Download search result in Excel sheet
    MAK Newbie
    Currently Being Moderated
    Hello,

    Bex Huff 's book gave the solution. Thanks for pointing me to the exact chapter.
    Now I can download the excel sheet.

    But, it has only 50 max rows. :(

    We have below string which creates the URL and takes the searched query.
    *<$HttpCgiPath$>?<$QUERY_STRING$>&IsJava=1&MergeInclude=spreadsheet_search_results"$>*

    I have observed, it has a "ResultCount=50". Can we increase it ???? I need to configure it for 2k ResultCount.

    Thanks,
    MAK

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points