Additional system properties in the CSV export process for created tables

Masaaki Taguchi · ‎06-28-2022

Added system property "glide.ui.export.limit" because the CSV export exceeds 10000 lines.
We have seen that this has an impact on performance.
Should I remove this property after the work?
Or should I change the value (e.g. 10000)?

Community Alums · ‎06-28-2022

Hi @Masaaki Taguchi ,

Default Value is :

glide.ui.export.limit

:10,000

The platform provides a default upper limit for data exports.

The purpose of the upper limit is to avoid creating performance issues when a table is excessively large. If you must export more records than the threshold permits, Break up a large export into separate manageable chunks.

In cases where you absolutely need to export a large chunk of data at once, you can create a system property to increase the limit:

Enter sys_properties.list into the filter text field.
Click New.
In the Name field, enter glide.ui.export.limit.
For type, select integer.
In the Value field, enter <new amount>.
Click Submit.

You can now export all of your records (for this one, the limit was increased to 20000):

Mark my answer correct & Helpful, if Applicable.

Thanks,
Sandeep

View solution in original post

Community Alums · ‎06-28-2022

Glad to see my answer helped you, Kindly mark the answer as Correct & Helpful both such that others can get help.

Thanks,
Sandeep

Community Alums · ‎07-01-2022

Hi @Masaaki Taguchi ,

Any update to this ?Any follow-up required? if not

Kindly mark the answer as Correct & Helpful both such that others can get help.

Thanks,
Sandeep

Hitoshi Ozawa · ‎06-28-2022

Hi Taguchi-san,

Should have used "glide.csv.export.limit" instead of general export limit property "glide.ui.export.limit".

Property "glide.ui.export.limit" is not defined by default. To revert back to the default value, delete the property if it is no longer necessary.

If both the format-specific export limit and the general export limit property aren't set, the system enforces the default export limit.

https://docs.servicenow.com/en-US/bundle/sandiego-platform-administration/page/administer/exporting-...

Masaaki Taguchi · ‎07-01-2022

Hi Ozawa-san,

With "glide.csv.export.limit", export was possible, but download was only possible up to 10000.
So this time I changed "glide.ui.export.limit" and downloaded.

Sorry for the poor explanation.

Thanks,

Masaaki.taguchi