Silk Central Test Manager 17.0 - Excel Export/Import Error

0 Likes

When a user is attempting to either Export or Import data from Excel to Silk Central, the following error message can sometimes be found:-

This can be seen if the Import/Export limit has been set lower than the file will allow. (max length in this instance 32,767)

In 17.0 you are able to control the Excel Export/Import RowLimit value. Due to the architecture change in 17.0 you now have the freedom of changing this setting on the individual instances themselves. 

Please ensure that you clarify which instance you are currently running the Export against. 

Once you have the correct Instance in mind please navigate to:- 

C:\Program Files (x86)\Silk\Silk Central 17.0\nameofinstance\Conf\FrontendServer\SccFrontendBootConf.xml 

Ammend the following xml setting as follows:- 

<ExcelExportRowLimit>20000</ExcelExportRowLimit> 
- <!-- 0 to disable limit 
--> 
<ExcelImportCellLimit>20000</ExcelImportCellLimit> 
- <!-- total number of cells a workbook may contain; 0 to disable limit 
-->

Simply increase the limit within the .xml file to allow you to complete the Import/export.

Comment List
Related
Recommended