Smarts NCM: Exporting config diff reports from Report Advisor in .csv format for Cisco Wireless Lan Controllers appear corrupted and run over into other spaces when viewing in Excel.

Products

• VMware Smart Assurance

Issue/Introduction

Symptoms:


Exporting config diff reports from Report Advisor in .csv format for Cisco Wireless Lan Controllers might look corrupted or ran over into other spaces when viewing in Excel. 

Please see below the corrupted report in excel.. 

Environment

VMware Smart Assurance - NCM

Cause

Cisco Wireless Lan Controllers can grow very large and have massive configuration files.

Resolution

This is a limitation of Excel.  The issue is Excel has a limitation of 32,767 characters and Wireless Lan Controllers can be very large and contain lots configuration information exceeding the 32K character limitation. It would be recommended to export in a different format.