Also refer to this,
8.1 Export Limit Properties
You can set the number of records to return during an export using the URL parameter sysparm_record_count. However, the system analyzes the following settings to determine whether an export limit should be applied.
- First, the platform checks the property that defines the format-specific export limit (see table). Each format can have a different limit. Although this property can be set to any value, exceeding the default export limit can impact system performance. You may want to set the property at or below the default limit and have users export large amounts of data in smaller increments.
- If the format-specific property is not set, the system checks the property for the general export limit (see table). This property can also be set to any value, but exceeding the default export limit can impact system performance.
- If neither the format-specific export limit nor the general export limit property is set, the system enforces the default export limit (see table).
 | Note: These properties are not defined by default. You must add the property to assign a value to it. |
| Format | Format-Specific Export Limit | General Export Limit | Default Export Limit |
|---|---|---|---|
| XML | glide.xml.export.limit | glide.ui.export.limit | 10,000 |
| CSV | glide.csv.export.limit | glide.ui.export.limit | 10,000 |
| EXCEL | glide.excel.export.limit | glide.ui.export.limit | 10,000 |
| glide.pdf.max_rows | N/A | 5,000 | |
| glide.pdf.max_columns | N/A | 25 |
Although the number of columns can be set higher than 25 in the PDF export, this is not advisable as only 25 header labels fit on a page.A warning threshold property called glide.ui.export.warn.threshold controls how the records are exported. If a user attempts to export a number of records from a list that exceeds the warning threshold, a dialog box offers the choice of waiting for the export to complete or having the exported records emailed as an attachment. The warning threshold can be changed in the system property. The email attachment must not exceed the maximum allowed email size or configured email attachment size. For more information, see Exported Table Emails.
8.1.1 Example 1: Exporting to CSV
- glide.csv.export.limit = 20,000
- glide.ui.export.limit = 10,000
- com.glide.processors.XMLProcessor.max_record_count = 20,000
- Default export limit for CSV = 10,000
| Records to be Exported | Records Returned |
|---|---|
| 15,000 | 15,000 |
| 30,000 | 20,000 |
| Note: In the second export, the number of records returned from the database is limited because the number of records specified for export exceeds the value set in the glide.csv.export.limitproperty. |
8.1.2 Example 2: Exporting to Excel
- glide.excel.export.limit = no entry
- glide.ui.export.limit = no entry
- Default export limit for EXCEL = 10,000
| Records to be Exported | Records Returned |
|---|---|
| 10,000 | 10,000 |
| 30,000 | 10,000 |
| Note: In the second export, the number of records returned from the database is limited because the number of records specified for export exceeds the default export limit for Excel, 10,000 records. |
8.1.3 Example 3: Exporting to PDF
- glide.pdf.max_rows = 3,500
- Default and maximum export limit for PDF = 5,000
| Records to be Exported | Records Returned |
|---|---|
| 2,000 | 2,000 |
| 10,000 | 5,000 |
| Note: In the first export, all records are returned because the number of records specified for export does not exceed the glide.pdf.max_rows property. In the second export, the number of records returned is limited because the number of records specified for export exceeds the value in the glide.pdf.max_rows property. |
8.2 Breaking Up Large Exports
If the number of records to be exported exceeds the actual export limit, you may want to break the export into smaller increments that do not place a significant performance load on the platform.
- Filter the list to display the records you want to export.
- Write down the number of records returned.
- If the record number is higher than the defined threshold, issue a sysparm query for the first 10,000 records using the following syntax:
- https://<instance name>.service-now.com/syslog_list.do?XML&sysparm_order_by=sys_id&sysparm_record_count=10000
- This exports the first 10,000 records in order, sorted by the sys_id number.
- Find the next record in order, such as 10,001.
- Right-click the row and copy the sys_id of the next record you want to export.
- Access the next series of records with a greater than or equal to query run against the sys_id of record 10,001.
- The following example shows a query that uses a sys_id of b4aedb520a0a0b1001af10e278657d27. Use the syntax shown in this query to export the next set of records.
- https://<instance name>.service-now.com/syslog_list.do?XML&sysparm_query=sys_id%3E%3Db4aedb520a0a0b1001af10e278657d27&sysparm_order_by=sys_id&sysparm_record_count=10000
- Note: URL queries use typical percent encoding. In this example, the greater than sign (>) is encoded as %3E and the equal sign (=) is encoded as %3D.
- Continue issuing this query, using the starting sys_id for the next set of records until you have exported all the necessary records.
8.3 Excel Export Threshold
Excel exports are intended for relatively small exports, fewer than 500,000 cells, while CSV can handle larger exports.
Whenever you export to Excel and the resultant spreadsheet has more than 500,000 cells (by default), the export process stops and you are given the Excel file at that point. In the bottom row, there will be the following message: Export stopped due to excessive size. Use CSV for a complete export:
The Excel export cell threshold is customizable using the glide.excel.max_cells integer property. Note: Increasing this threshold may cause a memory issue in your instance. The threshold is set at an appropriate level to prevent resource issues.
The export will put the information into the Excel document with 32,000 rows per spreadsheet.
Hi Sruthi,
You can simply go to export settings from left navigation panel, and change the values for excel limit to 55000:
