Skip to main content
January 10, 2024
Question

Export to excel is not exporting all the data

  • January 10, 2024
  • 9 replies
  • 0 views

Hi All,

We are facing issue with Export to excel. while exporting we are not  getting data in to the excel sheet we have nearly 350 records only still we are facing this issue.If we give any filters then it is fetching the data otherwise it is exporting with no values in excel.Please find the screen shot

How can we resolve this? please provide suggestion

    9 replies

    harshitb6843
    January 10, 2024

    This is strange. Because I can figure it out from the screenshot that is a record export that you generate when you click on the download icon above the record list. So there is nothing about this that we can control and this is managed by Appian solely. Sill, what are your record configurations? Eg. the Database to which it is connected, is the sync enabled and what Appian version are you using? 

    stefanhelzle0001
    Brainy
    January 10, 2024

    Did you check the tomcat-stdout log file for any details?

    komalj3844
    January 10, 2024

    Was the Data displayed on the grid which you expected to be exported into excel file If Yes, Please refer the logs for more detailed error

    sandyaranik8759
    January 24, 2024

    Hi Sireesha,

    Did you get the solution? I am also facing similar kind of issue.

    [mention:b8ea18cfbb2e4f6d841cf3c1d4d7420b:e9ed411860ed4f2ba0265705b8793d05] [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05] [mention:15d45cf742934b33a0c4bac62721efa4:e9ed411860ed4f2ba0265705b8793d05] 

    In my case, I am exporting from read only grid(sourced from synced record ). Able to see the data on the grid ui when I applied with filter, after exporting to excel.  I see below message in the excel.

    I am using Appian version 23.3 .

    Here is the tomcat-stdout log message

    WARNING [ajp-nio-0.0.0.0-8009-exec-101] com.sun.jersey.spi.container.servlet.WebComponent.filterFormParameters A servlet request, to the URI"appianurl" contains form parameters in the request body but the request body has been consumed by the servlet or a servlet filter accessing the request parameters. Only resource methods using @FormParam will work as expected. Resource methods consuming the request body by other means will not work as expected.

    Please provide any suggestions to resolve this.

    stefanhelzle0001
    Brainy
    January 24, 2024

    Are you sure that the log message is relevant? With just seeing a mostly empty Excel, I am not sure how to help.

    sandyaranik8759
    January 25, 2024

    Yes, that's what it showing. I tried multiple times, saw same message.