Cybersecurity
DevOps Cloud (ADM)
IT Operations Cloud
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.