Create CSV Report from Site-Search Result | Community
Skip to main content
A
akmind
Level 2
November 16, 2017
Solved

Create CSV Report from Site-Search Result

  • November 16, 2017
  • 9 replies
  • 2992 views

Hi Team,

We are facing one issue in Create CSV Report from site-search-result. Currently we are able to get only 10 rows in the Create CSV report from the 30 rows site-search result.

http://localhost:4506/sites.html/content

Required help in how to get all the result in Create CSV report.

AEM version: We are using AEM 6.1 version.

OS: Windows 8

Awaiting for your updates.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by kautuk_sahni

    AEM 6.1 -> when you create CSV without searching it creates CSV with full list where as then we export after doing searching then it creates only 10.

    AEM6.3 -> the behavior is correct.

    This is a Bug, please reach out to support for the fix.

    9 replies

    kautuk_sahni
    Community Manager
    kautuk_sahniCommunity Manager
    Community Manager
    November 17, 2017

    I tested on AEM 6.3 and on AEM 6.1, there is no such limit.

    i can export 16 pages. Can you help me reproduce this?

    `kautuk

    Kautuk Sahni
    A
    akmindAuthor
    Level 2
    November 17, 2017

    Thanks for the response.

    http://localhost:4506/sites.html/content

    Steps:

    1) click on search icon in the header

    2) Searching for a string 12 in full-text predicate and got 30 rows as result.

    3)CSV report contains only starting 10 rows of the result, still 20 are missing.

    FYI,

    We have a control on number of result to be display by setting the following property.  Same way we are suspecting anywhere we have to configure the export-result CSV.

    Awaiting for your updates.

    smacdonald2008
    smacdonald2008
    Level 10
    November 17, 2017

    YOu can also write a custom service to write a data set to Excel -- Adobe Experience Manager Help | Creating a Custom Reporting Service for Adobe Experience Manager

      A
      akmindAuthor
      Level 2
      November 17, 2017

      Is it a bug in the tool..?

      cant we get the whole search-result as a CSV..?

      Why only 10 rows by default its exporting..?

      smacdonald2008
      smacdonald2008
      Level 10
      November 17, 2017

      I am not seeing this - i get full set

      If you are not getting all results - try on a fresh instance. This confirms it should work. However - for the instance that is not working - i would say its a bug. You should open a ticket.

        smacdonald2008
        smacdonald2008
        Level 10
        November 17, 2017

        Also - if you remove that limit prop - are you getting full result set?

        kautuk_sahni
        Community Manager
        kautuk_sahniCommunity ManagerAccepted solution
        Community Manager
        November 20, 2017

        AEM 6.1 -> when you create CSV without searching it creates CSV with full list where as then we export after doing searching then it creates only 10.

        AEM6.3 -> the behavior is correct.

        This is a Bug, please reach out to support for the fix.

        Kautuk Sahni
          A
          akmindAuthor
          Level 2
          November 20, 2017

          Thanks for the response,

          Can you please specify some details about AEM version you tried.

          Below are the Observations in new Instance.

          I have tried with the new instance, i am able to get only 10 records as a export result from 30 display result.

          Details:

          AEM : 6.1

          OS: Windows 8

          Can you confirm this behavior, so that i can go and raise the ticket and show to our customer.

          A
          akmindAuthor
          Level 2
          November 20, 2017

          Thanks for the Confirmation, i will raise the ticket regarding this. Is there anything need to follow up after raised. If its resolvable means they will provide any patch for this defect.

          Terms & ConditionsAccessibility statement

          Loading footer...