How to export more than 32000 rows per sheet in xlsx or more than 30000 rows in csv?

[dwilborn]

Hi All,

Hoping someone can point me in the right direction.  I'm trying to export 342,000 records into a csv or xlsx format and not having much luck.  I've updated all the entries I can at System Properties > Import Export to 500,000 for rows and 50,000,000 for cells.  This allowed me to export to xlsx at 32k per sheet, but this makes the exported data difficult to manipulate in the way I'd like to (maybe an excel expert who can tell me how to easily combine 32k rows from one sheet to another???).

I figured a csv export would overcome that limitation but it got stuck at a mere 30k total rows.  When I attempted to change the export limit on System Properties > Import Export I kept getting an error and it would stay at 30k.  I attempted to change the glide.csv.export.limit to more than 30k but this appears to be a scoped property that wants a suffix to be created when I attempt to modify it... invalid update.  Also tried to insert a global property of the same name... invalid insert.  Therefore I created the glide.ui.export.limit system property as detailed in an official help articles and community posts from the venerable Chuck Tomasi.  Set that limit to 500,000 and no change.

Name	Value
glide.csv.export.limit	30000	string	Security Support Common
glide.excel.export.limit	50000000	string	Global
glide.json.export.limit	50000000	string	Global
glide.ui.export.limit	50000000	string	Global
glide.xlsx.export.limit	50000000	string	Global
glide.xml.export.limit	50000000	string	Global

I'm concerned about the scope of the csv.export.limit property not being global

Any help is appreciated!

Daniel

[Tony Chatfield1]

Hi, if I understand correctly 'Security Support Common' is a ServiceNow scoped app, so I would start by logging the issue with SNC Support and ask them to clarify why a scoped app is being used to define a sys_property that should be global and how they recommend you go about updating it in your instance.