How to render a exported Riskminder Report Data correctly using EXCEL

book

Article ID: 109846

calendar_today

Updated On:

Products

CA Rapid App Security CA Advanced Authentication CA API Gateway

Issue/Introduction

At times exported Riskminder Reports with CSV format (Comma Separated Values) do not render some columns (show up as “#NAME?”") in an EXCEL spreadsheet. The columns render fine in other editors such as Textpad or in Notepad++ editor.

How to render a Riskminder Report Data (like Device ID) ?

Environment

Riskminder Reports

Resolution

This is an Excel issue as this issue does not reproduce in a TEXTPAD or Notepad++ editory.  To resolve the issue follow the following steps:  

1. Open a blank EXCEL worksheet.
2. Select the "Data" pull down on EXCEL 
3. Proceed to import with "From CSV file/Text"
 

Additional Information

None.