More than 10000 Excel exports

Potemi
Tera Contributor

‎02-14-2024 01:21 AM

I want to export a list of tables in Excel. ServiceNow has a limit of 10,000 items, but I want to export more than that. I would like to export Excel with a limit of 50,000 using JavaScript, not ServiceNow settings. Can you give me a script?

0 Helpfuls
  • 748 Views
7 REPLIES 7

Dr Atul G- LNG
Tera Patron
Tera Patron

‎02-14-2024 01:27 AM

Hi @Potemi 

 

OOTB it is 10K is limit, you can increase the limit but it may impact system performance.

 

Go to system properties -- Import /Export 

 

LearnNGrowAtul_0-1707902869229.png

 

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls

Potemi
Tera Contributor
In response to Dr Atul G- LNG

‎02-14-2024 01:31 AM - edited ‎02-14-2024 09:20 PM

@Dr Atul G- LNG 

Thanks for the answer. Isn't it possible to leave the system properties unchanged and set an upper limit in Javascript? The CSV output was done in Javascript. The following settings have been made into UI actions.

 

 

0 Helpfuls

Dr Atul G- LNG
Tera Patron
Tera Patron
In response to Potemi

‎02-14-2024 01:42 AM

NO mate, you need to change the properties only, also as I said, more count can impact the performance.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls