Want to export huge data through report.

[salu]

Hi All,

I want to export a huge date about 4 lakh row of data.I am trying to export in excel,it giving at maximum 50,000 row in excel.Please let is it maximum limit of the service now or is there any way to export it.Please suggest a solution.

[Subhajit1]

Go to System Properties: sys_properties.list in App Nav

Check for the Property glide.excel.export.limit.

Change the value to 400k.

While exporting you might face Performance Issues

Corrected the Property Name.

For more information on performance refer to this article:-

My report contains more than 50k columns.

[salu · Accepted solution]

Hi Das,

Thank you for the information.Please let me know is there ay provison to set a limit while exporting.

Export first 50000 row and then next 50k like that.

[harikrish_v]

HI Saranya,

By default, the limit for excel import is 10000. You can go to system properties and change this value to something higher, property name is glide.excel.export.limit . But be careful as to not increase it by too much.

http://wiki.servicenow.com/index.php?title=Exporting_Data#Export_Limit_Properties

Hope this helps. Please mark this question as answered if this solves your problem.

Thanks & Regards,

Hari

[salu]

Hi Vijayan,

Thanks for the response.

Please let me know is there any provision to set up a limit while exporting the data.

Thanks

Saranya