HI
I have a requirement to export more than one lakh records into excel sheet.
challenges:
-> Data is coming from a view having multiple joins.( Facing performance issue at production)
-> So we followed appian records approach, but export to excel button is getting disabled when record count is more than one lakh.
-> As the records count is high, we are not interested to go stored pro and staging table approach
Any advice is helpful
Discussion posts and replies are publicly visible
Hi buddy,try to use english terms that everyone can support you. lakh is indian ;)you can use multiple other approaches:you can add a view as data store entity.https://docs.appian.com/suite/help/22.3/Export_To_Excel_Smart_Service.htmlorhttps://docs.appian.com/suite/help/22.3/Export_To_CSV_Smart_Service.htmland for the record export, you can fine some best practices here:https://docs.appian.com/suite/help/22.2/Optimizing_Record_Lists_for_Export_to_Excel.htmlis this helping you?
Hi Richard Michaelis
Thanks for your immediate response.
This was an existing project , we are not getting all values into database view.
-> we used stored proc to get required data, but while using CDT to excel plugin , it is occupying much java heap memory .
did you just one of the mentioned smart services?
and another question: what is the deeper sense to export that many lines into an excel? doesn't feel 100% senseful....
yes Richard Michaelis
Mr_AR said:but while using CDT to excel plugin , it is occupying much java heap memory
As I mentioned below, you would need to manually implement paging while using this technique - i.e. only loading a certain amount of information into the process per pass, and updating the same file with your iterative passes.