How to create RSA ACE/Server custom reports in a .CSV format for import into a spreadsheet
Originally Published: 2000-10-17
Last Modified: 2023-10-06
Article Number
Applies To
RSA ACE/Server Reports
TFS Technology's Keon Security Server (KSS) 4.5
Microsoft Excel
Microsoft Windows
Report Creation Utility
Issue
All custom reports made from the RSA ACE/Server are currently created using a '|' (pipe), the Table delimiter. It is possible to reconfigure a spreadsheet application such as Microsoft Excel to use this character when importing tables (with Excel you need only rename the file to have a .XLS extension). However, most spreadsheets and other applications, including TFS Technology's Keon Security Server, are able to import from a CSV (Comma Separated Values) file. These will have a .CSV file extension and use the ',' (comma) as the delimiter.
Resolution
Find the lines:
IF rpt-format = 2 THEN DO:
dir-name = dir-name + "/" + "mytest" + ".xls".
OUTPUT TO VALUE(dir-name).
PUT "LocalDate| LocalTOD| ShortMessage| UserName| Login| AffectedUserName| TokenSerialNum| ClientName| GroupName| SiteName| GMTDate| GMTOD" SKIP.
and change the ".xls" to ".csv", to look like this:
IF rpt-format = 2 THEN DO:
dir-name = dir-name + "/" + "mytest" + ".csv".
OUTPUT TO VALUE(dir-name).
PUT "LocalDate, LocalTOD, ShortMessage, UserName, Login, AffectedUserName, TokenSerialNum, ClientName, GroupName, SiteName, GMTDate, GMTOD" SKIP.
Save the file. Open logpipe.i with an editor, and replace all instances of "|" (pipe) with ","(comma).
Run the report again. This will create the required .CSV file. This procedure only works with custom reports.
Related Articles
How to create an ACE/Server Custom Report 25Number of Views CSV Format for Token Requests Input File 16Number of Views Custom Reports 89Number of Views CSV Format for User Group Membership Requests Input File 9Number of Views Scheduled custom reports are intermittently failing and generating blank reports in RSA Identity Governance & Lifecycle 175Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager Patch Updates RSA Authentication Manager Upgrade Process RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities
Don't see what you're looking for?