Export to Excel function produces duplicate rows in the output spreadsheet

Document ID : KB000049176
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

After exporting data from Service Desk Manager via the "Export to Excel" functionality, it can happen that you see duplicate data in the output Excel spreadsheet. This occurs when sorting of the data is different than the default (such as in a filtered list) and a large number of items (approximately 500 or higher) are in the list.

Solution:

Adding the NX variable, NX_EXPORT_FETCH_GROUP_SIZE to NX.env, and then restarting the Service Desk Manager service solves the problem.

To implement this change, please add the following line to the NX.env file that is located in $NX_ROOT, which is the Service Desk Manager installation directory:

@NX_EXPORT_FETCH_GROUP_SIZE=3000

Note: The default value, when the environment variable is not specified, is 300.

Remember to recycle Service Desk Manager services.