Hi, In reference to clarity version 13.0.1, the export to excel generates only 300 rows. In later upgrades, is there any change in this functionality? Is this documented somewhere? Please give references.
There are two types of 'Export to Excel'
The link named 'Export to Excel' is intended for exporting a set of records less than 300 rows in a pretty format for Excel (or Power Point) and there is another link for 'Export to Excel (Data Only) ; this link exports a larger set of records and the limitation is constrained by PPM System Configuration and by Excel.
For more information on the differences and limitations of Exporting data using Excel, refer to the following article:
TEC1046117 : Export to Excel Only Exports the first 300 rows
If you are using the 'Export to Excel (Data Only)' link, there may be a performance impact if you are using attribute value protection configurations.
Reference the following article for more details:
TEC592946 : Poor Performance on Exporting data into Excel due to AVP Settings
There are more articles that may be helpful to you. Please use the following keywords to search our knowledgebase : export to excel limit
Export to excel has around 300 records and just export to excel you can configure via administration Maximum rows for Export to Excel
Since version 13.0 and the introduction to a new method of Export to Excel / Export to Powerpoint, the limitation has been documented as exporting a maximum of 300 rows:
Basics User Guide v13.0.00
It also states that the prior functionality (now named) 'Export to Excel (Data Only)' will export more rows than this, up to the limit specified by the option in Suman's reply.
The following Ideas also pertain to the current limits of this feature:
Rename "Export to Excel" to "Export to Excel (300 rows)"
Based on CASE 21189536-1: EXPORT ONLY UP TO 300 ROWS TO
Remove Export To excel limitaion (or) restrict to some records with settings in admin module
Please identify which ones cover your case and vote them up if you would like to add your support for getting them included into the product in a future version.
If it still kills the app server when a user asks for more than 300 rows, please kill this feature.
Remove Export to Excel From Clarity (I see my idea is under review - cool!)
We removed the links to this from CA PPM so that users could no longer take our app servers done.
We have implemented governor limitations for exporting in 13.3 patch and 14.1+
Check out the following article:
Master setting in CSA to limit the max rows for Export to Excel
Document ID: TEC611566
We recently upgraded to 15.2 and we see this popup when try to export. In earlier version (13.3) , we were able to export anything.
Does anyone know if any limitation added now. CSA(In NSA) and Administration--> General Settings-->system options also does not have this 'Maximum rows for Export to Excel' in v15.2. so we can not increase limit.
Already replied to this thread
Retrieving data ...