The Zurich release has arrived! Interested in new features and functionalities? Click here for more

Exporting Excel from the CSM portal will take me more than 10 minutes for 13,000 records.

LuisaMariaO
Tera Contributor

Hi community,

Exporting Excel from the CSM portal will take me more than 10 minutes for 13,000 records.

LuisaMariaO_0-1756245972263.png

What can I do to make it not take so long?

widget: DGS: Mosaic Component List

<ul class="dropdown_menu" ng-if="showDrop">
<li ng-repeat="t in ::exportTypes">
<a ng-href="/{{data.table}}_list.do?{{::t.value}}&sysparm_query={{data.exportQueryEncoded}}&sysparm_view={{options.export_view}}&sysparm_fields={{data.fields.join(',')}}" target="_new" tabindex="-1">${Export as} {{::t.label}}</a>
</li>
</ul>

Thanks

5 REPLIES 5

That doesn't explain the why. Why would an end user need to download that many records via the portal? Especially since it's on the portal, so it is something that will be done more than once. You won't have any control over when it is done. Why not automate it? Create a catalog item for the request and have the system make the export and email it to the end user. 

But it should never be necessary to export that many records as an end user and certainly not more than once.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark